banterlyticsArt gobblers Minter stats
    Updated 2022-11-21
    with all_tx as (
    select date_trunc('day', block_timestamp::date) as dt,
    tx_hash, event_inputs:to::string as event_to,
    event_inputs:from::string as event_from, event_inputs:tokenId::string as token_id
    from ethereum_core.fact_event_logs
    where contract_address = lower('0x57a204AA1042f6E66DD7730813f4024114d74f37')
    and event_name = 'Transfer'
    and block_timestamp > '2021-01-01'
    ),
    transfers as
    ((SELECT
    event_to as wallet,
    dt,
    'mint' as action,
    1 as value
    FROM all_tx
    where event_from = '0x0000000000000000000000000000000000000000')
    union all
    (SELECT
    event_to as wallet,
    dt,
    'gain' as action,
    1 as value
    FROM all_tx
    where event_from != '0x0000000000000000000000000000000000000000')
    union all
    (SELECT
    event_from as wallet,
    dt,
    'lose' as action,
    -1 as value
    Run a query to Download Data