0x_spadeETH SWAPS AND NFT PURCHASES FROM LAST MONTH
Updated 2024-08-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH uniswap AS
(SELECT
--PLATFORM
ORIGIN_FROM_ADDRESS,
tx_hash
--COUNT(distinct TX_HASH) AS N_SWAPS,
FROM ethereum.defi.ez_dex_swaps
WHERE BLOCK_TIMESTAMP::DATE between '2024-07-01' and '2024-08-24'
AND platform IN ('uniswap-v2','uniswap-v3')
--GROUP BY PLATFORM
)
SELECT
uniswap.origin_from_address as USER,
count(distinct uniswap.tx_hash) as n_swaps,
count(distinct nft.tx_hash) as n_nft_purchases
FROM uniswap
INNER JOIN ethereum.nft.ez_nft_sales nft
ON uniswap.ORIGIN_FROM_ADDRESS = nft.buyer_address
WHERE nft.BLOCK_TIMESTAMP::DATE between '2024-07-01' and '2024-08-24'
group by user
order by n_nft_purchases desc
limit 100
QueryRunArchived: QueryRun has been archived