Muze2023-03-21 07:12 PM
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
pool_name,
contract_address,
count( distinct tx_hash ) as number_swaps
from ethereum.core.ez_dex_swaps a
left join ethereum.core.dim_labels b on a.contract_address = b.address
and b.address_name ilike 'sushiswap'
where a.block_timestamp >= cast('2023-02-01' as timestamp)
and a.block_timestamp < cast('2023-03-01' as timestamp)
group by 1,2
order by 3 desc
limit 10
Run a query to Download Data