web3gameguidesCryptoys Minters
    Updated 2023-06-03
    with minters as(
    SELECT event_data:id as id, event_data:to as to_deposit, *
    FROM flow.core.fact_events as e

    where event_contract like '%Cryptoys%'
    and event_type = 'Deposit'
    order by event_data:id ASC

    )

    select to_deposit, count(*)
    from minters
    where to_deposit <> '0xca63ce22f0d6bdba'
    group by to_deposit

    Run a query to Download Data