Select DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DAYS, COUNT(TX_ID), SUCCESS, to_label
from flipside_prod_db.polygon.transactions
where FROM_ADDRESS IN
(select ADDRESS
from flipside_prod_db.polygon.labels
where label_type = 'nft') OR
TO_LABEL_TYPE ILIKE '%NFT%' OR
TO_LABEL_SUBTYPE ILIKE 'marketplace' OR
FUNCTION_NAME ILIKE '%NFT%'
Group by 1,4,3