theericstoneALCX Supply
    Updated 2021-03-28
    WITH d as (
    SELECT
    32000 as amount,
    '2021-02-27' as block_timestamp,
    11939247 as block_id

    UNION

    SELECT
    amount,
    block_timestamp,
    block_id
    FROM ethereum.udm_events
    WHERE contract_address = lower('0xdbdb4d16eda451d0503b854cf79d55697f90c8df')
    AND from_address = '0x0000000000000000000000000000000000000000'
    AND block_id >= 11939247
    AND amount > 0
    AND event_name = 'transfer'

    UNION

    SELECT
    amount * -1,
    block_timestamp,
    block_id
    FROM ethereum.udm_events
    WHERE contract_address = lower('0xdbdb4d16eda451d0503b854cf79d55697f90c8df')
    AND to_address in ('0x0000000000000000000000000000000000000000')
    AND block_id >= 11939247
    AND amount > 0
    AND event_name = 'transfer'
    ),
    g as (
    SELECT
    date_trunc('hour', block_timestamp) as t,
    sum(amount) as hour_sum
    Run a query to Download Data