dan-smithUSDT burn
    Updated 2023-02-07
    SELECT
    CASE WHEN contract_address = '0xdac17f958d2ee523a2206206994597c13d831ec7' THEN 'usdc'
    WHEN contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN 'usdt'
    END AS token
    ,EVENT_NAME
    ,l.TX_HASH
    ,GAS_USED * BLOCK_HEADER_JSON:base_fee_per_gas / 1e18 AS eth_burn
    FROM ethereum.core.fact_decoded_event_logs l
    LEFT JOIN ethereum.core.fact_blocks b ON l.TX_HASH = t.TX_HASH
    WHERE (contract_address = '0xdac17f958d2ee523a2206206994597c13d831ec7'
    OR contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48')
    AND t.block_timestamp >= '2023-02-01'
    AND l.block_timestamp >= '2023-02-01'
    --GROUP BY 1, 2
    ORDER BY 1, 2
    LIMIT 100



    SELECT *
    FROM ethereum.core.fact_transactions
    LIMIT 1
    Run a query to Download Data