theericstoneAlchemix Harvesting
    Updated 2023-03-09
    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