nasdfajsklj2024-04-21 wallet balance value
Updated 2024-05-11
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
›
⌄
--reminder: add more chains
with data as (
select
block_timestamp::date as date
,date_trunc('week', block_timestamp)::date as week
,'ETH' as chain
, amount_usd
, origin_from_address
, origin_to_address
from ethereum.core.ez_token_transfers
where 1=1
and to_address = '0xc8c0e780960f954c3426a32b6ab453248d632b59'
and block_timestamp::date > '2024-04-05'
and origin_from_address != '0xc8c0e780960f954c3426a32b6ab453248d632b59' -- excludes our swaps, when we conver tokens to weth/usdc
and amount_usd is not null
--native tables
UNION ALL
select
block_timestamp::date as date
,date_trunc('week', block_timestamp)::date as week
,'ETH' as chain
, amount_usd
, origin_from_address
, origin_to_address
from ethereum.core.ez_native_transfers
where 1=1
and to_address = '0xc8c0e780960f954c3426a32b6ab453248d632b59'
and block_timestamp::date > '2024-04-05'
and origin_from_address != '0xc8c0e780960f954c3426a32b6ab453248d632b59' -- excludes our swaps, when we conver tokens to weth/usdc
and amount_usd is not null
)
, fee_payers as (
select
QueryRunArchived: QueryRun has been archived