-- Daily NFT Transaction on Polygon
select date(block_timestamp) dt
, TO_ADDRESS_NAME nft_address
, count(distinct tx_id) ct
from flipside_prod_db.polygon.transactions
where block_timestamp >= date('2021-06-01')
and to_label_type = 'nft'
group by 1,2
order by 1 asc