justabfjNumber of NFTs Sold by the Hour
    Updated 2022-07-15
    with genesis_nft_ids as (
    select asset_id,
    sum(asset_amount) as total_amount
    from algorand.asset_transfer_transaction
    where sender = 'CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'
    and asset_receiver = 'MS7TKJ3MXE6CQ5IZW2ZQC2KT3NWJFQPRSDAFTZPGYPFCZZ43PL7UPBTZXE'
    and asset_amount > 0
    and asset_amount < 1000
    group by asset_id, asset_receiver
    ),
    genesis_nft_id_names as (
    select asset_id,
    asset_parameters:an as name
    from algorand.asset_configuration_transaction
    where asset_id in (
    select asset_id
    from genesis_nft_ids
    )
    ),
    genesis_nft_id_names_with_total_amount as (
    select a.asset_id,
    a.name,
    total_amount
    from genesis_nft_id_names a
    join genesis_nft_ids on genesis_nft_ids.asset_id = a.asset_id
    ),
    -- how quickly sold out
    asset_sales as (
    select date_trunc('day', block_timestamp) as day,
    date_trunc('hour', block_timestamp) as hour,
    sum(asset_amount) as total_amount
    from algorand.asset_transfer_transaction
    where sender = 'MS7TKJ3MXE6CQ5IZW2ZQC2KT3NWJFQPRSDAFTZPGYPFCZZ43PL7UPBTZXE'
    and asset_id in (
    select asset_id
    from genesis_nft_ids
    Run a query to Download Data