mlhUntitled Query
Updated 2022-08-03
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 tfrom as (SELECT BLOCK_TIMESTAMP::date as date,
TX_HASH,
ORIGIN_FROM_ADDRESS as wallet,
ORIGIN_TO_ADDRESS,
CONTRACT_ADDRESS as token_from,
EVENT_INPUTS:value as amount_from
from optimism.core.fact_event_logs
where ORIGIN_TO_ADDRESS in ( lower('0xE592427A0AEce92De3Edee1F18E0157C05861564'), lower('0x68b3465833fb72A70ecDF485E0e4C7bD8665Fc45') )
and EVENT_INPUTS:from = ORIGIN_FROM_ADDRESS
and EVENT_NAME = 'Transfer'
),
tto as (SELECT BLOCK_TIMESTAMP::date as date,
TX_HASH,
ORIGIN_FROM_ADDRESS as wallet,
ORIGIN_TO_ADDRESS,
CONTRACT_ADDRESS as token_to,
EVENT_INPUTS:value as amount_to
from optimism.core.fact_event_logs
where ORIGIN_TO_ADDRESS in ( lower('0xE592427A0AEce92De3Edee1F18E0157C05861564'), lower('0x68b3465833fb72A70ecDF485E0e4C7bD8665Fc45') )
and EVENT_INPUTS:to = ORIGIN_FROM_ADDRESS
and EVENT_NAME = 'Transfer'
),
a as (SELECT tfrom.*,
token_to,
amount_to
from tfrom
join tto on tfrom.TX_HASH = tto.TX_HASH
),
price as (SELECT hour::date as date,
TOKEN_ADDRESS,
SYMBOL,
DECIMALS,
avg(price) as daily_price
from optimism.core.fact_hourly_token_prices
GROUP by 1,2,3,4
Run a query to Download Data