SELECT DATE(block_timestamp) as date_minted, parse_json(event_data:metadata) as m

FROM flow.core.fact_events as e

where event_contract like '%Cryptoys%'

and event_type = 'Minted'

SELECT date_minted, 1

FROM data

where m[4].value.value = '0001-01-01'