banterlytics2023-07-28 07:28 PM
    WITH gen AS (
    WITH all_tx AS (
    SELECT
    date_trunc('day', block_timestamp::date) AS dt,
    tx_hash,
    decoded_log:to::string AS event_to,
    decoded_log:from::string AS event_from,
    decoded_log:tokenId::string AS token_id
    FROM ethereum.core.fact_decoded_event_logs
    WHERE block_timestamp BETWEEN '2021-04-15 19:56:00.000' AND '2023-07-26 16:11:00.000'
    AND contract_address = lower('0x57a204aa1042f6e66dd7730813f4024114d74f37')
    AND event_name = 'Transfer'
    AND token_id < 1001
    ),
    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
    Run a query to Download Data