saadiqToobins Run: Txns/day
    Updated 2023-08-14
    -- forked from Toobins Run @ https://flipsidecrypto.xyz/edit/queries/e82d764c-a81d-48ed-b02b-d5123c718e68
    WITH
    txns AS (
    select
    ROW_NUMBER() OVER (
    ORDER BY
    block_timestamp ASC
    ) AS row_num,
    block_timestamp,
    nft_to_address,
    nft_from_address
    from
    ethereum.core.ez_nft_transfers t
    where
    t.nft_address = lower('0xd6059164237F6dC4dF777714437c37CC85256089')
    and t.tokenid = 0
    )
    select
    left(t.block_timestamp, 10) as day,
    count(1) as txns
    from
    txns t
    group by
    day
    order by
    day desc
    Run a query to Download Data