DiamondCryptoys Collection Mint
    Updated 2024-06-29
    with data as(
    SELECT
    event_data:id as id,
    parse_json(event_data:metadata) as m,
    parse_json(event_data:royalties) as r,
    *
    FROM
    flow.core.fact_events as e
    where
    event_contract like '%Cryptoys%'
    and event_type = 'Minted'
    and block_timestamp >= '5/23/2023'
    order by
    event_data:id ASC
    )
    SELECT
    id,
    m [0].value.value,
    m [1].value.value,
    m [2].value.value,
    m [3].value.value,
    m [4].value.value,
    m [5].value.value,
    m [6].value.value,
    m [8].value.value,
    m [9].value.value,
    m [10].value.value,
    m [11].value.value,
    r [12].value.fields [2].value.value
    -- tx_id
    from
    data
    WHERE
    m [6].value.value like '%Star Wars%'
    and m [4].value.value = '0001-01-01'

    QueryRunArchived: QueryRun has been archived