TOTAL_DROPPED | N_RECIPIENTS | DELAY | |
|---|---|---|---|
1 | 548267854.872501 | 399644 | 3668 |
theericstoneOptimism Airdrop Tracking
Updated 1 hour ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with alldrops as (
select * FROM
optimism.core.fact_token_transfers
where block_timestamp > '2023-02-08'
and from_address = lower('0x2501c477D0A35545a387Aa4A3EEe4292A9a8B3F0')
and contract_address = lower('0x4200000000000000000000000000000000000042')
)
select
sum(raw_amount)/pow(10,18) as total_dropped,
count(distinct(to_address)) as n_recipients,
timediff(minute, max(block_timestamp), current_timestamp) as delay
from alldrops;
Last run: about 1 hour agoAuto-refreshes every 3 hours
1
32B
4s