justabfjNumber of NFTs Sold by the Hour
Updated 2022-07-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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