kasadeghUntitled Query
Updated 2022-11-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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