daniel1234567Wadgjhfdgjfdhg'
Updated 2023-02-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
/* Test Query — Parameters */
SELECT
date_trunc (week, block_timestamp) as date,
from_address,
sum(tx_fee) as tx_fees,
sum(gas_used) as gas_used,
avg(gas_price) as gas_price,
avg(eth_value) as eth_value
FROM ethereum.core.fact_transactions
where
from_address in (
lower('0x393Bd4c89CFbC668821Dcfff83589126A046f339'),
lower('0xE7bd51Dc30d4bDc9FDdD42eA7c0a283590C9D416'),
lower('0xce90a7949bb78892f159f428d0dc23a8e3584d75'))
and date_trunc('day',block_timestamp) > current_date - interval '52 weeks'
group by 1,2
Run a query to Download Data