ngxuan885Holders of the Headline NFTs & Token(3)
Updated 2022-06-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with NFTs as (SELECT ASSET_ID, ASSET_NAME,
CASE WHEN TOTAL_SUPPLY = 1 THEN 'Astros'
else 'Pixel Astros' end as kind, TOTAL_SUPPLY
from flipside_prod_db.algorand.asset
where CREATOR_ADDRESS = 'NIN73GEWDWBU3HHEPGWGIQZMOITN4PU3YVTKMR3ESI7DCH5ME4E5TLB4XU'
and ASSET_DELETED = FALSE),
-----------------------------------------------------------------------------------
initial as ( SELECT kind, min(BLOCK_TIMESTAMP)::date as intial_sale
from flipside_prod_db.algorand.asset_transfer_transaction t
JOIN NFTS n on n.ASSET_ID = t.ASSET_ID GROUP by 1)
-----------------------------------------------------------------------------------
SELECT BLOCK_HOUR::date as date,
case WHEN BLOCK_HOUR::date in (SELECT intial_sale from initial) THEN 'launch day'
else 'ordinary' end as kind,
avg(PRICE_USD) as price
from flipside_prod_db.algorand.prices_swap
where ASSET_ID = '137594422'
and BLOCK_HOUR::date >= '2021-11-01'
GROUP by 1,2 order by 1
Run a query to Download Data