pine_samiweekly swappers
Updated 2023-06-07Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select 'swappers from TRIAS' as type, count(distinct ORIGIN_FROM_ADDRESS) as swapper,
date_trunc('{{date_range}}', block_timestamp) as date
from ethereum.core.ez_dex_swaps
where SYMBOL_IN = 'TRIAS'
and EVENT_NAME='Swap'
group by 3
UNION ALL
select 'swappers to TRIAS', count(distinct ORIGIN_FROM_ADDRESS),
date_trunc('{{date_range}}', block_timestamp)
from ethereum.core.ez_dex_swaps
where SYMBOL_OUT = 'TRIAS'
and EVENT_NAME='Swap'
group by 3
Run a query to Download Data