rahoBalancer Humpy Addy
Updated 2022-12-08
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
›
⌄
with humpy_tbal as (select
date_trunc('day', block_timestamp) as date,
origin_from_address,
origin_to_address,
event_index,
contract_address,
contract_name,
event_name,
event_inputs['from'] as from_ad,
event_inputs['to'] as to_ad,
event_inputs['value']/power(10,18) as amount
from polygon.core.fact_event_logs
where contract_address = '0xb797adfb7b268faeaa90cadbfed464c76ee599cd'
and from_ad = '0x36cc7b13029b5dee4034745fb4f24034f3f2ffc6'
)
tbal_tvl as (
select
*
from polygon.core.fact_event_logs
where contract_address = '0xb797adfb7b268faeaa90cadbfed464c76ee599cd'
and event_name = 'Transfer'
and
)
Run a query to Download Data