mo115DeGate - Your Wallet
Updated 2023-04-23
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 Act as (with all_txs as (with txs as (select
date_trunc('day',BLOCK_TIMESTAMP) as date,
TX_HASH,
FROM_ADDRESS,
ETH_VALUE as AMOUNT_ETH,
TX_FEE,
'ETH' as Token,
'Ethereum' as Network
from
ethereum.core.fact_transactions
where
TO_ADDRESS = '0xa3af00a4ca8a11b840b1cb190d1c1d66da1546fc'
and ETH_VALUE > 0
union
select
date_trunc('day',BLOCK_TIMESTAMP) as date,
TX_HASH,
FROM_ADDRESS,
ETH_VALUE as AMOUNT_ETH,
TX_FEE,
'ETH' as Token,
'Arbitrum' as Network
from
arbitrum.core.fact_transactions
where
TO_ADDRESS = '0xa3af00a4ca8a11b840b1cb190d1c1d66da1546fc'
and ETH_VALUE > 0
),
ETH as (select date_trunc ('day',HOUR) as date, avg(PRICE)as price
from ethereum.core.fact_hourly_token_prices
where SYMBOL = 'WETH'
group by 1)
select t.date, TX_HASH,
FROM_ADDRESS,
AMOUNT_ETH*price as Amount_USD,
Run a query to Download Data