2024-08-03 02:18 PM

Sniper2024-08-03 02:18 PM

Updated 2024-08-03

-- select

-- date_trunc('week', block_timestamp) date

-- ,case

-- when event_data:metadata like '%Mickey and Friends: Volume I%' then 'Mickey and Friends: Volume I'

-- when event_data:metadata like '%Star Wars™: Volume III%' then 'Star Wars™: Volume I'

-- when event_data:metadata like '%Zoo-F-O%' then 'Zoo-F-O'

-- when event_data:metadata like '%Masters of the Universe™ Special Edition 2022%' then 'Masters of the Universe™ Special Edition 2022'

-- when event_data:metadata like '%Masters of the Universe™%' then 'Masters of the Universe™'

-- else 'not registered'

-- end as collection_type

-- ,count (distinct event_data:id) NFTs

-- from flow.core.fact_events

-- where event_contract = 'A.ca63ce22f0d6bdba.Cryptoys'

-- --and event_data:metadata not like '%Mickey and Friends: Volume I%'

-- --and event_data:metadata not like '%Star Wars™: Volume I%'

-- --and event_data:metadata not like '%Zoo-F-O%'

-- --and event_data:metadata not like '%Masters of the Universe™ Special Edition 2022%'

-- --and event_data:metadata not like '%Masters of the Universe™%'

-- and event_type = 'Minted'

-- and tx_succeeded = 'true'

-- group by 1 , 2

with mint as (

select

block_timestamp,

try_parse_json(EVENT_DATA:metadata) as data,

event_data:id as id

from flow.core.fact_events

where event_contract = 'A.ca63ce22f0d6bdba.Cryptoys'

and event_data:metadata like '%Star Wars™%'

and EVENT_TYPE = 'Minted'

and TX_SUCCEEDED = 'true'

and block_timestamp>='2023-06-19'

-- GROUP by 1,2

QueryRunArchived: QueryRun has been archived

flipside