theericstoneTransmuter TVL
Updated 2021-04-15
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
30
31
32
33
34
35
36
›
⌄
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