kasadeghUntitled Query
    Updated 2022-11-22

    SELECT
    'near' as chain,
    DAYNAME(block_timestamp) as day,
    hour(block_timestamp) as hour,
    sum(CAST(SPLIT(tx:receipt[0]['outcome']['logs'], ' ')[1] as INT)/power(10, 6)) as total_volume,
    avg(CAST(SPLIT(tx:receipt[0]['outcome']['logs'], ' ')[1] as INT)/power(10, 6)) as avg_volume,
    median(CAST(SPLIT(tx:receipt[0]['outcome']['logs'], ' ')[1] as INT)/power(10, 6)) as median_volume,
    count( DISTINCT SPLIT(tx:receipt[0]['outcome']['logs'], ' ')[3]) as senders_cnt,
    count(DISTINCT SPLIT(tx:receipt[0]['outcome']['logs'], ' ')[5]) as receivers_cnt,
    count(DISTINCT TX_HASH) as tx_count
    FROM near.core.fact_transactions
    WHERE TX_RECEIVER LIKE 'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near'
    AND not SPLIT(tx:receipt[0]['outcome']['logs'], ' ')[1] LIKE 'account'
    AND block_timestamp::date >='{{start_time}}' and block_timestamp::date <='{{end_date}}'
    and CAST(SPLIT(tx:receipt[0]['outcome']['logs'], ' ')[1] as INT)/power(10, 6)>0
    GROUP BY 1,2,3

    Run a query to Download Data