2844Polygon NFT 1
Updated 2022-07-14
9
1
2
3
4
5
6
7
8
9
›
⌄
select BLOCK_TIMESTAMP::date as "DATE" , count (DISTINCT TX_ID) as "DAILY VOLUME",
CASE
WHEN BLOCK_TIMESTAMP::date >='2022-06-15' THEN 'PAST MONTH'
WHEN BLOCK_TIMESTAMP::date >'2021-06-15' AND BLOCK_TIMESTAMP::date <'2022-06-15' THEN 'PAST YEAR'
END AS "PERIOD"
from flipside_prod_db.polygon.udm_events
where TO_LABEL_TYPE = 'nft'
GROUP BY 1
Run a query to Download Data