with alldrops as (

select * FROM

optimism.core.fact_token_transfers

where block_timestamp > '2023-09-18'

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, (select max(block_timestamp) from optimism.core.fact_blocks where block_timestamp > current_date),

current_timestamp) as delay

from alldrops;