Getting Started

yusyusGetting Started

Updated 2025-01-06

-- Get started with Flipside by running your first query:

-- the SQL statement below will get you a list of NFT

-- platforms on Ethereum, ranked by how many sales

-- they've had in the past month.

-- Be sure to see our documentation for more guidance,

-- including a full walkthrough of the app:

-- https://docs.flipsidecrypto.xyz/our-app/getting-started

with uniswap AS

(select origin_from_address, tx_hash

--platform,

--count(tx_hash) as n_swaps

FROM ethereum.defi.ez_dex_swaps

where block_timestamp :: DATE >= current_date - 31

AND

platform in ('uniswap-v2', 'uniswap-v3')

--group by 1

)

SELECT uniswap.origin_from_address as user,

count(DISTINCT uniswap.tx_hash) as n_swaps,

count(DISTINCT nft.tx_hash) as nft_purchases

FROM uniswap

JOIN ethereum.nft.ez_nft_sales nft

ON uniswap.origin_from_address = nft.buyer_address

WHERE nft.block_timestamp :: DATE >= current_date - 31

GROUP by 1

ORDER by 3 DESC

Last run: 3 months ago

...

21767

1MB