theericstoneAlchemix Harvesting
Updated 2023-03-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
date_trunc('day',block_timestamp) as date,
to_address,
count( distinct tx_id) as n_txns,
sum(amount ) as amount
from ethereum.udm_events where
block_id > 11937232
and symbol = 'DAI'
and event_type = 'erc20_transfer'
and to_address != lower('0xc21d353ff4ee73c572425697f4f5aad2109fe35b')
and from_address = lower('0xc21d353ff4ee73c572425697f4f5aad2109fe35b')
and tx_id in (
select distinct tx_id from ethereum.udm_events
where to_address = lower('0xc21d353ff4ee73c572425697f4f5aad2109fe35b')
and origin_function_name = 'harvest'
and block_id > 11937232
)
group by 1,2
order by date desc
Run a query to Download Data