rezarwz$Blast Airdrop Claims Status Daily
Updated 2024-12-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
with all_claims as (
SELECT
tx.TX_HASH,
tx.block_timestamp as block_timestamp,
tr.to_Address as ua,
RAW_AMOUNT/pow(10,18) as amount
FROM
blast.core.fact_transactions tx
INNER join blast.core.fact_token_transfers tr on tx.tx_hash = tr.tx_hash
and tr.contract_address = lower('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')
and tx.to_Address = '0xf7be503166828fe8565c520d66645ac6a06bbdd7'
and tx.ORIGIN_FUNCTION_SIGNATURE != '0xca1d209d'
WHERE
tx.status = 'SUCCESS'
)
SELECT
date_trunc('hour', block_timestamp) as date,
count(DISTINCT ua) as "# of of Addresses Claimed",
sum(count(DISTINCT ua)) over(
ORDER by
date_trunc('hour', block_timestamp) asc
) as "Total Addresses Claimed",
sum(AMOUNT) as "Amount of Claimed $Blast",
sum(sum(AMOUNT)) over(
ORDER by
date_trunc('hour', block_timestamp) asc
) as "Total Claimed $Blast"
from
all_claims
group by
1
QueryRunArchived: QueryRun has been archived