DiamondNFLAD - TEAM COIN (SF)
Updated 2023-07-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- forked from NFLAD - TEAM COINs @ https://flipsidecrypto.xyz/edit/queries/77eb60c3-b743-4c75-84a4-e268a0505a39
Select
date_trunc('day',block_timestamp) as "Date",
nft_collection as "Wallet",
count (tx_id) as "Daily Sales",
sum (price) as "Daily Sales Volume ($USD)",
sum("Daily Sales Volume ($USD)") over (order by "Date") as "Total Sales ($USD)"
From flow.core.ez_nft_sales
where nft_collection ILIKE 'A.329feb3ab062d289.NFL_NFT'
and tx_succeeded = 'true'
and block_timestamp between '2022-01-14' and '2022-01-15'
and currency ilike 'A.ead892083b3e2c6c.DapperUtilityCoin'
group by 1, 2
order by 1 desc
Run a query to Download Data