2844Daily count of total tx copy
    -- 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