kaibladeNear Hourly USDC Transfer Volume
Updated 2022-11-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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