itsxenuxUntitled Query
    Updated 2022-07-18
    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