datavortexconservative-blue
    Updated 2024-11-22
    WITH tab1 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 >= DATE_TRUNC('month', CURRENT_DATE)
    )
    SELECT
    SUM(AMOUNT_USD) AS total_volume,
    AVG(AMOUNT_USD) AS avg_volume,
    MEDIAN(AMOUNT_USD) AS median_volume
    FROM polygon.core.ez_token_transfers
    WHERE ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
    AND ORIGIN_FROM_ADDRESS = FROM_ADDRESS
    AND TX_HASH IN (SELECT TX_HASH FROM tab1)
    AND BLOCK_TIMESTAMP >= DATE_TRUNC('month', CURRENT_DATE);
    Last run: about 2 months ago
    TOTAL_VOLUME
    AVG_VOLUME
    MEDIAN_VOLUME
    1
    21171248.57094132184.855373678143.050086933
    1
    49B
    74s