davidwallUntitled Query
    Updated 2023-01-14
    --credit : https://app.flipsidecrypto.com/velocity/queries/629a4da2-04cb-4e17-8393-fb3f39420cbc
    with swaptxtable as (
    select distinct tx_hash
    from ethereum.core.fact_event_logs
    where event_name = 'Swap'
    and block_timestamp >= '2022-12-17'
    and tx_status = 'SUCCESS'


    union ALL

    select distinct tx_hash
    from arbitrum.core.fact_event_logs
    where event_name = 'Swap'
    and block_timestamp >= '2022-12-17'
    and tx_status = 'SUCCESS'


    union ALL

    select distinct tx_hash
    from avalanche.core.fact_event_logs
    where event_name = 'Swap'
    and block_timestamp >= '2022-12-17'
    and tx_status = 'SUCCESS'


    union ALL

    select distinct tx_hash
    from bsc.core.fact_event_logs
    where event_name = 'Swap'
    and block_timestamp >= '2022-12-17'
    and tx_status = 'SUCCESS'


    Run a query to Download Data