kaibladeNear Hourly USDC Transfer Volume
    Updated 2022-11-21
    WITH near_usdc_data AS
    (SELECT block_timestamp, tx_hash, receiver_id, logs, SPLIT(logs[0], ' ') AS log_split1, log_split1[1]*1e-6 AS amount,
    -- TRY_TO_NUMERIC(amount1)*1e-6 AS amount
    log_split1[3] AS sender
    FROM near.core.fact_receipts
    WHERE receiver_id = 'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near'
    AND ARRAY_SIZE(logs)!= 0
    AND logs[0] != 'The account is already registered, refunding the deposit'
    AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '3 days')


    SELECT DATE_TRUNC ('hours', block_timestamp) AS "Hours",
    COUNT(tx_hash) AS "Transfer Volume"

    FROM near_usdc_data

    GROUP BY "Hours"
    Run a query to Download Data