chrisfdpast_24h_transactions
Updated 2023-10-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from past_24h_active_users @ https://flipsidecrypto.xyz/edit/queries/c67b4521-b472-457e-a4a2-e6bbe032e1c1
-- forked from DEX_past_24h_volume copy @ https://flipsidecrypto.xyz/edit/queries/d7f0aa86-e4c7-4fbe-85e5-9fb57227c746
--Platform considered in the DEX volume computation
WITH dex_list(dex) as (
select * from (
values
('uniswap-v2'),
('uniswap-v3'),
('curve'),
('maverick'),
('sushiswap'),
('dodo-v1'),
('dodo-v2'),
('pancakeswap-v2'),
('pancakeswap-v3'),
('balancer')
))
select
count(distinct tx_hash) as transactions
from ethereum.defi.ez_dex_swaps
where exists (select 1 from dex_list where dex_list.dex = ethereum.defi.ez_dex_swaps.platform)
and BLOCK_TIMESTAMP > dateadd('hour', -24, current_timestamp(9)::timestamp_ntz)
and AMOUNT_IN_USD > 0
Run a query to Download Data