claim $THOR airdrop daily

boomer77claim $THOR airdrop daily

Updated 2021-12-02

select date_trunc('day', block_timestamp) as dt, sum(event_inputs:value/1e18) as THOR_claimed,

count(distinct event_inputs:to::string) as claimer_count,

sum (claimer_count) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as claimer_cumulative,

sum(THOR_claimed) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as THOR_claimed_cumulative

from ethereum.events_emitted

where event_inputs:from::string = '0x8526cec1d97a68c0e69420488d04dec5f101b46e' and tx_succeeded = 'TRUE'

group by 1

Run a query to Download Data

flipside