kenobi9270USD : (USD value)
Updated 2022-02-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with tbl_ETH_quantity as(
select sum(amount) as sum , date(block_timestamp) as date from ethereum.udm_events
where to_address='0x660f6d6c9bcd08b86b50e8e53b537f2b40f243bd' and symbol='ETH'
group by date)
, tbl_ETH_usd as(
select sum(amount_usd) as sum , date(block_timestamp) as date from ethereum.udm_events
where to_address='0x660f6d6c9bcd08b86b50e8e53b537f2b40f243bd' and symbol='ETH'
group by date)
, tbl_USDC_quantity as(
select sum(amount_usd) as sum , date(block_timestamp) as date from ethereum.udm_events
where to_address='0x660f6d6c9bcd08b86b50e8e53b537f2b40f243bd' and symbol='USDC'
group by date)
, tbl_USDC_usd as(
select sum(amount_usd) as sum , date(block_timestamp) as date from ethereum.udm_events
where to_address='0x660f6d6c9bcd08b86b50e8e53b537f2b40f243bd' and symbol='USDC'
group by date)
select sum,date from tbl_USDC_usd
Run a query to Download Data