samUntitled Query
Updated 2022-08-17Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with
veldrom_old as (
select count (distinct tx_hash) as Swap,
'core_table' as table_type
from optimism.core.fact_event_logs
where origin_to_address = lower('0xa132DAB612dB5cB9fC9Ac426A0Cc215A3423F9c9')
and event_name = 'Swap' and block_timestamp::date>CURRENT_DATE-30 ),
veldrom_new as (
select count (distinct tx_hash) as Swap,
'Veldrom_table' as table_type
from optimism.velodrome.ez_swaps
where block_timestamp::date>CURRENT_DATE-30 )
select * from veldrom_old
union ALL
select * from veldrom_New
Run a query to Download Data