Mrfti2024-03-18 03:01 PM copy copy
Updated 2024-11-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- forked from 2024-03-18 03:01 PM copy @ https://flipsidecrypto.xyz/studio/queries/a0e5b7db-7161-4319-a4da-8082e82ee378
SELECT
date_trunc(DAY, block_timestamp) as "Date",
sum(amount) as "Total token claimed",
sum ("Total token claimed") over (order by "Date") as "Cumulative tokens claimed"
from
optimism.core.ez_token_transfers
where
from_address = lower ('0x9a69d97a451643a0bb4462476942d2bc844431ce')
and contract_address = lower ('0x4200000000000000000000000000000000000042')
group by 1
order by 1
QueryRunArchived: QueryRun has been archived