datavortexchanges
    Updated 2024-11-19
    WITH Events AS (
    SELECT
    TX_HASH
    FROM
    polygon.core.ez_decoded_event_logs
    WHERE
    EVENT_NAME = 'LiFiTransferStarted'
    AND DECODED_LOG:bridgeData:integrator = 'jumper.exchange'
    AND ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
    AND BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '2 month'
    ),
    TokenTransfers AS (
    SELECT
    tet.TX_HASH,
    tet.ORIGIN_FROM_ADDRESS,
    tet.AMOUNT_USD,
    tet.FROM_ADDRESS,
    tet.ORIGIN_TO_ADDRESS,
    tet.BLOCK_TIMESTAMP
    FROM
    polygon.core.ez_token_transfers tet
    JOIN Events e ON e.TX_HASH = tet.TX_HASH
    WHERE
    tet.ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
    AND tet.ORIGIN_FROM_ADDRESS = tet.FROM_ADDRESS
    ),
    Last30DaysResults AS (
    SELECT
    COUNT(DISTINCT tt.ORIGIN_FROM_ADDRESS) AS Users,
    SUM(tt.AMOUNT_USD) AS Volume,
    COUNT(DISTINCT tt.TX_HASH) AS Bridges
    FROM
    TokenTransfers tt
    WHERE
    tt.BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '1 month'
    ),
    QueryRunArchived: QueryRun has been archived