0xHaM-dOverall View
    Updated 2022-12-05
    WITH dim_table AS (
    SELECT *
    FROM (
    SELECT dateadd('hour', seq4(), '2022-07-01 00:00:00') AS date
    FROM TABLE(GENERATOR(rowcount => 100000))
    WHERE date <= date_trunc('hour', CURRENT_TIMESTAMP)
    ) AS h,
    (SELECT 'Mint' AS transaction_type
    UNION ALL
    SELECT 'Burn' AS transaction_type)
    )
    , mint_and_burn_transactions AS (
    SELECT
    tx_hash
    , event_index
    , block_timestamp
    , origin_from_address
    , event_inputs['from']::string AS sender
    , event_inputs['to']::string AS receiver
    , contract_address AS token_address
    , event_inputs['value']::bigint / pow(10,6) AS amount
    , (CASE WHEN sender = '0x0000000000000000000000000000000000000000' THEN 'Mint'
    WHEN receiver = '0x0000000000000000000000000000000000000000' THEN 'Burn'
    ELSE 'Others' END) AS tx_type
    , (CASE WHEN sender = '0x0000000000000000000000000000000000000000' THEN receiver
    WHEN receiver = '0x0000000000000000000000000000000000000000' THEN sender END) AS wallet_address
    FROM avalanche.core.fact_event_logs AS transfer
    WHERE tx_status = 'SUCCESS'
    AND event_name = 'Transfer'
    AND block_timestamp >= '2022-07-01 00:00:00.000'
    AND try_to_numeric(event_inputs['value']::string) IS NOT NULL
    AND contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

    AND (sender = '0x0000000000000000000000000000000000000000' -- mint
    Run a query to Download Data