Crazy_KidNet $THOR Staked
Updated 2022-05-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
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