Afonso_Diaz2024-05-30 01:35 PM
    Updated 2024-05-30
    WITH L2 AS(
    SELECT BLOCK_TIMESTAMP,ORIGIN_FROM_ADDRESS,TX_HASH,NVL(AMOUNT_OUT_USD,AMOUNT_IN_USD) AS AMOUNT_USD
    FROM polygon.defi.ez_dex_swaps
    WHERE BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'

    UNION ALL

    SELECT BLOCK_TIMESTAMP,ORIGIN_FROM_ADDRESS,TX_HASH,NVL(AMOUNT_OUT_USD,AMOUNT_IN_USD) AS AMOUNT_USD
    FROM avalanche.defi.ez_dex_swaps
    WHERE BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'

    UNION ALL

    SELECT BLOCK_TIMESTAMP,ORIGIN_FROM_ADDRESS,TX_HASH,NVL(AMOUNT_OUT_USD,AMOUNT_IN_USD) AS AMOUNT_USD
    FROM arbitrum.defi.ez_dex_swaps
    WHERE BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'

    UNION ALL

    SELECT BLOCK_TIMESTAMP,ORIGIN_FROM_ADDRESS,TX_HASH,NVL(AMOUNT_OUT_USD,AMOUNT_IN_USD) AS AMOUNT_USD
    FROM optimism.defi.ez_dex_swaps
    WHERE BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'

    UNION ALL

    SELECT BLOCK_TIMESTAMP,ORIGIN_FROM_ADDRESS,TX_HASH,NVL(AMOUNT_OUT_USD,AMOUNT_IN_USD) AS AMOUNT_USD
    FROM base.defi.ez_dex_swaps
    WHERE BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'
    ),

    L1 AS(
    SELECT BLOCK_TIMESTAMP,ORIGIN_FROM_ADDRESS,TX_HASH,NVL(AMOUNT_OUT_USD,AMOUNT_IN_USD) AS AMOUNT_USD
    FROM ethereum.defi.ez_dex_swaps
    WHERE BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'
    )

    QueryRunArchived: QueryRun has been archived