theericstoneBalance History for an Address
Updated 2022-06-20
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
›
⌄
⌄
/*with curbals as (
select
holder,
name,
symbol,
token_address,
last_value(timestamp) over(partition by holder, token_address order by block asc) as last_change_timestamp,
last_value(curr_value) over (partition by holder, token_address order by block asc) as balance
from
flipside_prod_db.tokenflow_eth.tokens_balance_diffs
where
timestamp > current_date - {{days_back}}
and holder = lower('{{holder_address}}')
),
balhist as ( */
select
holder,
name,
symbol,
token_address,
timestamp,
curr_value as new_balance,
prev_value as previous_balance
from
flipside_prod_db.tokenflow_eth.tokens_balance_diffs
where
timestamp > current_date - {{days_back}}
and holder = lower('{{holder_address}}')
order by timestamp desc;
Run a query to Download Data