Aave rewards- daily

bachiAave rewards- daily

Updated 2021-10-05

select date_trunc(day, block_timestamp) as date, tx_from_address as address, sum(event_inputs:amount::float / 1e18) as total_amount, count(*) as num_of_transasactions,

avg(event_inputs:amount::float / 1e18) as average_amount from ethereum.events_emitted

where contract_address = lower('0x4da27a545c0c5B758a6Ba100e3a049001de870f5')

and contract_name = 'staked aave'

and event_name='RewardsClaimed'

and block_timestamp > '2021-01-31'

group by address, date order by total_amount desc

Run a query to Download Data

flipside

flipside