theericstoneTransmuter TVL
    Updated 2021-04-15
    WITH d as (
    SELECT
    amount,
    block_timestamp,
    block_id
    FROM ethereum.udm_events
    WHERE contract_address = lower('0x6B175474E89094C44Da98b954EedeAC495271d0F')
    AND to_address = lower('0xaB7A49B971AFdc7Ee26255038C82b4006D122086')
    AND block_id >= 11937214
    AND amount > 0
    AND event_name = 'transfer'

    UNION

    SELECT
    amount * -1,
    block_timestamp,
    block_id
    FROM ethereum.udm_events
    WHERE contract_address = lower('0x6B175474E89094C44Da98b954EedeAC495271d0F')
    AND from_address = lower('0xaB7A49B971AFdc7Ee26255038C82b4006D122086')
    AND block_id >= 11937214
    AND amount > 0
    AND event_name = 'transfer'
    ),
    g as (
    SELECT
    date_trunc('hour', block_timestamp) as t,
    sum(amount) as hour_sum
    FROM d
    GROUP BY 1
    ),
    oldtransmut as (
    SELECT
    'a' as transmuter_version,
    t as time_hour,
    Run a query to Download Data