gaonip[Staging] Uniswap Trading actvitity on L2
Updated 2023-11-10
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
›
⌄
select 'eth' as chain, to_date(block_timestamp) as swap_date, count(tx_hash)
from ethereum.defi.ez_dex_swaps
where platform = 'uniswap-v3' and swap_date > '2023-01-01' and event_name
group by swap_date
union
select 'op' as chain, to_date(block_timestamp) as swap_date, avg(amount_in_usd)
from optimism.defi.ez_dex_swaps
where platform = 'uniswap-v3' and swap_date > '2023-01-01'
group by swap_date
UNION
select 'arb' as chain, to_date(block_timestamp) as swap_date, avg(amount_in_usd)
from arbitrum.defi.ez_dex_swaps
where platform = 'uniswap-v3' and swap_date > '2023-01-01'
group by swap_date
UNION
select 'poly' as chain, to_date(block_timestamp) as swap_date, avg(amount_in_usd)
from polygon.defi.ez_dex_swaps
where platform = 'uniswap-v3' and swap_date > '2023-01-01'
group by swap_date
union
select 'base' as chain, to_date(block_timestamp) as swap_date, avg(amount_in_usd)
from base.defi.ez_dex_swaps
where platform = 'uniswap-v3' and swap_date > '2023-01-01'
group by swap_date
Run a query to Download Data