Trust Dynamics and Market Behavior in Cryptocurrency: A Comparative Study of Centralized and Decentralized Exchanges

Supplementary resources, data, and code

by Xintong Wu, Wanlin Deng, Yutong Quan and Luyao Zhang*

(* the corresponding author: [email protected])

Figure 1. Overview of the article: created by Miro.

Table of Contents

• Data
• Code
• Images
• Reference

Data

Figure 2. Data collected flowchart: created by Miro.

Collected Data

For collecting data from the flipside, please refer to flipsidecrypto.xyz.

Meta Data Infomation

Data Files	Data Type	Data Content
1_Price.csv	Queried	WETH Daily Price
2_CEX_to_DEX.csv	Queried	CEX to DEX Transaction Flow
2_DEX_to_CEX.csv	Queried	DEX to CEX Transaction Flow
2_Netflow.csv	Queried	NetFlow

Data Dictionary

• WETH Daily Price

Variable Name	Description	Frequency	Unit	Type
DATE	Date of price	Daily	Date	Date
Price	Daily price of WETH	Daily	USD	Numeric

• Transaction between CEX and DEX

Variable Name	Description	Frequency	Unit	Type
DATE	Date of transfer	Daily	Date	Date
N_TRANSFER	Number of transfers	Daily	Count	Integer
USER	User identifier	Daily	Count	Integer
AMOUNT_USD	Amount in USD	Daily	USD	Numeric
AMOUNT_ETH	Amount in ETH	Daily	ETH	Numeric
CEX	Centralized Exchange	Daily	Text	Categorical
DEX	Decentralized Exchange	Daily	Text	Categorical

• Netflow between CEX and DEX

Variable Name	Description	Frequency	Unit	Type
DATE	Transaction Date	Daily	Date	Date
USER $\rightarrow$ DEX	User Interaction with DEX	Daily	Count	Integer
USER $\rightarrow$ CEX	User Interaction with CEX	Daily	Count	Integer
Net User	Net User Interaction	Daily	Count	Integer
Amount $\rightarrow$ DEX	Amount Related to DEX	Daily	USD	Numeric
Amount $\rightarrow$ CEX	Amount Related to CEX	Daily	USD	Numeric
Net Amount ETH	Net ETH Amount	Daily	ETH	Numeric
Amount $ $\rightarrow$ DEX	Amount in USD Related to DEX	Daily	USD	Numeric
Amount $ $\rightarrow$ CEX	Amount in USD Related to CEX	Daily	USD	Numeric
Net Amount $	Net USD Amount	Daily	USD	Numeric

Analyzed Data

Meta Data Infomation

Data Files	Data Type	Data Content
1_price_statistics_data.csv	Analyzed	statistics data of WETH daily price
2_cex_to_dex_statistics_data.csv	Analyzed	statistics data of CEX to DEX transaction flow
2_dex_to_cex_statistics_data.csv	Analyzed	statistics data of DEX to CEX transaction flow
2_netflow_statistics_data.csv	Analyzed	statistics data of NetFlow

Data Dictionary

• WETH Daily Price

Variable Name	Description	Frequency	Unit	Type
DATE	Date of price	Daily	Date	Date
Mean_PreviousMonth	Mean price of Previous Month	Monthly	USD	Numeric
Mean_NextMonth	Mean price of Next Month	Monthly	USD	Numeric
Mean_Difference	Price difference between Next Month and Previous Month	Monthly	USD	Numeric

• Transaction between CEX and DEX

Variable Name	Description	Frequency	Unit	Type
DATE	Date of transfer	Daily	Date	Date
Mean_PreviousMonth	Mean transaction of Previous Month	Monthly	USD	Numeric
Mean_NextMonth	Mean transaction of Next Month	Monthly	USD	Numeric
Mean_Difference	Transaction difference between Next Month and Previous Month	Monthly	USD	Numeric

• Netflow between CEX and DEX

Variable Name	Description	Frequency	Unit	Type
DATE	Date of transfer	Daily	Date	Date
Mean_PreviousMonth	Mean newflow transaction of Previous Month	Monthly	USD	Numeric
Mean_NextMonth	Mean newflow transaction of Next Month	Monthly	USD	Numeric
Mean_Difference	Newflow transaction difference between Next Month and Previous Month	Monthly	USD	Numeric

Code

Code Type	Google Colab File Name
Collection	Data_Collection.ipynb
Analysis	Data_Analysis.ipynb

Images

Price

./Images/Price.png

Transaction Flow

DEX to CEX		./Images/DtC.png
DEX to CEX		./Images/CtD.png
NetFlow		./Images/Net.png

Exchanges Trading Process

Binance WETH trading process		./Images/Binance.png
Uniswap WETH trading process		./Images/Uniswap.png

References

Data Reference: flipsidecrypto ( https://flipsidecrypto.xyz/)

Code Reference: flipsidecrypto/siavashj (https://flipsidecrypto.xyz/siavashj/q/1sPLGdSteDlQ)