2844Daily count of total tx copy
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
-- forked from 54578a69-d101-46cf-9026-034010cd1b52
with nft_tx as (
select
block_timestamp::date as date,
txn_hash,
b.value as log
from flipside_prod_db.mdao_near.receipts, lateral flatten(input => logs) b
where log like '%nft_%'
and status_value:SuccessReceiptId is not null
)
, function_call as (
SELECT
txn_hash
from flipside_prod_db.mdao_near.actions_events_function_call
WHERE txn_hash in (SELECT txn_hash from nft_tx)
and METHOD_NAME ilike ('%nft_%')
)
SELECT
block_timestamp::date as date,
count(DISTINCT txn_hash) as tx_cnt,
count(DISTINCT TX_RECEIVER) as receiver_cnt,
count(DISTINCT tx_signer) as sender_cnt,
sum(TRANSACTION_FEE/1e24) as near_amt_fee,
sum(tx_cnt) over (order by date asc) as cum_tx_cnt
from flipside_prod_db.mdao_near.transactions
WHERE txn_hash in (SELECT txn_hash from function_call)
group by 1
order by 1
Run a query to Download Data