Crazy_KidNet $THOR Staked
    Updated 2022-05-24
    WITH a AS (SELECT DISTINCT tx_id as tx1
    FROM ethereum.events_emitted
    WHERE contract_address = LOWER('0xa5f2211B9b8170F694421f2046281775E8468044') --THOR
    ),
    b AS (SELECT *
    FROM ethereum.events_emitted
    WHERE tx_to_address = LOWER('0x815c23eca83261b6ec689b60cc4a58b54bc24d8d') --vTHOR
    AND event_name = 'Deposit'),

    c AS (SELECT *
    FROM ethereum.events_emitted
    WHERE tx_to_address = LOWER('0x815c23eca83261b6ec689b60cc4a58b54bc24d8d') --vTHOR
    AND event_name = 'Withdraw'),
    d as (SELECT date(block_timestamp) as date, sum(event_inputs:value/power(10, 18)) as thor_staked
    FROM a JOIN b ON tx1 = tx_id
    GROUP BY date
    ORDER BY date),

    e as (SELECT date(block_timestamp) as date, sum(event_inputs:amount/power(10, 18)) as thor_unstaked
    FROM a JOIN c ON tx1 = tx_id
    GROUP BY date
    ORDER BY date)

    SELECT d.date, thor_staked, zeroifnull(thor_unstaked) as thor_unstaked, thor_staked + zeroifnull(thor_unstaked) as net_thor_staked
    FROM d LEFT JOIN e on d.date = e.date
    WHERE d.date > '2022-05-01'
    ORDER BY d.date
    Run a query to Download Data