itsxenuxUntitled Query
Updated 2022-07-18
9
1
2
3
4
5
6
7
8
9
›
⌄
select
count (distinct txn_hash)
-- tx_receipt
-- tx_receipt[1]:"outcome":"status"
from flipside_prod_db.mdao_near.transactions
where (TX_RECEIPT[0]:outcome:status ilike '%SUCCESSVALUE%' or TX_RECEIPT[0]:outcome:status ilike '%SUCCESSRECEIPTID%')
-- where substr(tx_receipt[0]:"outcome":"status",3,7) = 'Success'
and date_trunc('day', block_timestamp) >= '2022-07-01'
limit 1
Run a query to Download Data