samUntitled Query
    Updated 2022-08-17
    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