RayyykFlow NFT Floor Price 6
Updated 2022-10-27Copy Reference Fork
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 nft as (select nft_collection as nft_address,
case
when nft_collection = 'A.0b2a3299cc857e29.TopShot' then 'NBA TopShot'
when nft_collection = 'A.e4cf4bdc1751c65d.AllDay' then 'NFL AllDay'
when nft_collection = 'A.e4cf4bdc1751c65d.PackNFT' then 'Pack NFT'
when nft_collection = 'A.329feb3ab062d289.RaceDay_NFT' then 'RaceDay NFT'
when nft_collection = 'A.329feb3ab062d289.UFC_NFT' then 'UFC NFT'
end as collections
from flow.core.ez_nft_sales
where collections is not null
group by 1)
select collections,
count(distinct(tx_id)) as tx_count
from flow.core.ez_nft_sales a
join nft b on a.nft_collection = b.nft_address
where nft_collection = 'A.0b2a3299cc857e29.TopShot'
and price = 0.01
and tx_succeeded = 'TRUE'
and block_timestamp >= '{{Start_date}}'
group by 1
union
select collections,
count(distinct(tx_id)) as tx_count
from flow.core.ez_nft_sales a
join nft b on a.nft_collection = b.nft_address
where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
and price = 1
and tx_succeeded = 'TRUE'
and block_timestamp >= '{{Start_date}}'
group by 1
union
select collections,
count(distinct(tx_id)) as tx_count
from flow.core.ez_nft_sales a
join nft b on a.nft_collection = b.nft_address
Run a query to Download Data