date_trunc('day', t.block_timestamp) AS Date,

t.tx_hash,

t.origin_from_address,

t.contract_address,

t.amount_usd,

t.token_price,

l.label_type

FROM blast.core.ez_token_transfers t

JOIN blast.core.dim_labels l

ON t.contract_address = l.address

WHERE l.project_name = 'blast'

LIMIT 1000