nitsTotal transactions NFTs based on days
    Updated 2022-02-22
    with addr as (SELECT address,project_name
    from crosschain.address_labels
    where blockchAIN = 'solana' and label_type = 'nft')

    SELECT project_name,date(block_timestamp)as day, avg(amt)/pow(10,9) as avg_price,
    sum(amt)/pow(10,9) as total_sales,
    sum(total_sales) over(partition by project_name order by day) as cum_vol ,
    count(*) as total_txs ,
    sum(total_txs) over(partition by project_name order by day) as cum_txs
    from
    (SELECT * from
    (SELECT *,
    inner_instruction:instructions[0]:parsed:info:lamports+
    inner_instruction:instructions[1]:parsed:info:lamports+
    inner_instruction:instructions[2]:parsed:info:lamports+
    inner_instruction:instructions[3]:parsed:info:lamports as amt
    from solana.nfts
    where array_size(inner_instruction:instructions) > 4
    -- and instruction:programId = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8'
    )
    inner join
    addr
    on mint = address )
    where amt is not NULL
    GROUP by 1,2
    order by 2,5 desc
    Run a query to Download Data