The dataset
The dataset comprises a series of transactions with destinations set to Binance or OpenSea. These entities are served by multiple addresses, and for the sake of simplicity, we have selected one among the many associated with them.
The Binance 14 address (0x28c6c06298d514db089934071355e5743bf21d60
) represents a Binance hot wallet that is used to facilitate the connection between the centralized exchange and Ethereum. The funds in this wallet serve deposits and withdrawals outside of Binance.
On the other hand, the address for OpenSea, specifically Wyvern Exchange v2 (0x7f268357a8c2552623316e2562d90e642bb538e5
), corresponds to the marketplace contract for OpenSea.
To replicate this dataset using Flipside, we can use the following query:
sql =SELECT from_address, to_address, tx_hash FROM ethereum.core.fact_transactions WHERE block_timestamp >= '2023-01-01T00:00:00.000Z'   and   block_timestamp <= '2023-06-01T00:00:00...