cheeyoung-kekLil Noun Vs Noun Volume trend
Updated 2022-07-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with eth_in AS (
select
date_trunc('day', BLOCK_TIMESTAMP) as date,
sum (ETH_value) as eth_in_volume
from ethereum.core.fact_traces where TO_ADDRESS in (lower('0xd5f279ff9EB21c6D40C8f345a66f2751C4eeA1fB'),('0x0BC3807Ec262cB779b38D65b38158acC3bfedE10'))
and TX_STATUS='SUCCESS'
group by date
order by date desc
),
eth_out as (
select
date_trunc('day', BLOCK_TIMESTAMP) as date,
sum (ETH_value) as eth_out_volume
from ethereum.core.fact_traces where FROM_ADDRESS in (lower('0xd5f279ff9EB21c6D40C8f345a66f2751C4eeA1fB'),('0x0BC3807Ec262cB779b38D65b38158acC3bfedE10'))
and TX_STATUS='SUCCESS'
group by date
order by date desc
)
select a.date, eth_in_volume, eth_out_volume from eth_in a join eth_out b on a.date=b.date
Run a query to Download Data