with f_events as (

select

event_data,

event_contract,

event_type,

tx_id,

block_timestamp,

tx_succeeded

from

flow.core.fact_events

where

block_timestamp >= '2023-11-01 17:00:00.000'

),

mints AS (

SELECT

x.EVENT_DATA:editionID :: STRING AS "EditionID",

x.event_data:id AS id,

x.EVENT_DATA:renderID AS "Shape" --y.event_data:to as wallet

FROM

f_events x --join f_events y on x.tx_id=y.tx_id

WHERE

x.EVENT_CONTRACT = 'A.edf9df96c92f4595.Pinnacle'

AND x.EVENT_TYPE = 'PinNFTMinted'

AND "Shape" ILIKE 'LEV1-TURN%' -- and y.event_type='Deposit'

),

Shapes AS (

SELECT

EVENT_DATA:id :: STRING AS "ID",

2024 AS "seriesID",

EVENT_DATA:renderID AS "Shape",

EVENT_DATA:variant AS "Variant",

EVENT_DATA:isChaser AS "Chaser",