FIRST_CLAIMERS | SECOND_CLAIMERS | VESTED_CLAIMERS | CEX_CLAIMERS | TOTAL_CLAIMERS | FIRST_CLAIM | SECOND_CLAIM | SECOND_CLAIM_WITH_CEX | CEX_CLAIM | TOTAL_CLAIM | FIRST_CLAIM_WITH_CEX | TOTAL_CLAIM_WITH_CEX | PENALTY | FIRST_CLAIMING_COUNT | SECOND_CLAIMING_COUNT | FIRST_CLAIMING_COUNT_WITH_CEX | SECOND_CEX_CLAIM_COUNT | SECOND_CLAIM_COUNT_WITH_CEX | TOTAL_CLAIM_COUNT | TOTAL_CLAIM_COUNT_WITH_CEX | TOTAL_ALLOCATION | SECOND_ALLOCATION | TOTAL_PENALTY_WITH_CEX | AIRDROP_LEFT | CLAIMED_PERC | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 125613 | 7507 | 118106 | 31146 | 156759 | 217288540.774659 | 23056439.624142 | 34827942.749142 | 57816364.558477 | 240344980.398801 | 263333401.649659 | 298161344.957278 | 15370959.749428 | 181381 | 8898 | 212527 | 4204 | 13102 | 190279 | 221425 | 379403583.122378 | 220600000 | 23218628.499428 | 116070181.472719 | 69.407199448 |
h4wkbase total
Updated 19 hours ago
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
32
33
34
35
36
›
⌄
-- forked from base penalty @ https://flipsidecrypto.xyz/studio/queries/264efcda-dba9-4335-a15b-e666a1bdc446
-- 8d81W2jTM4M8GQSMzv9vx4fkTSeVKn1f2iWAZHRgvypY penalty
-- 2QfiM9uocJpSohZkeBvQe9usWB17CxbWqWD5F4tyws8C first 50% claiming
with base_first as (
select tx_from,
tx_to,
amount,
block_timestamp,
tx_id
from solana.core.fact_events e
join solana.core.fact_transfers t using (tx_id, block_timestamp)
where block_timestamp > '2024-10-16'
and program_id = 'DeDRoPXNyHRJSagxZBBqs4hLAAM1bGKgxh7cyfuNCBpo'
and mint = 'DBRiDgJAMsM95moTzJs7M9LnkGErpbv9v6CUR1DXnUu5'
and tx_from = '2QfiM9uocJpSohZkeBvQe9usWB17CxbWqWD5F4tyws8C'
)
, base_penalty as (
select tx_from,
tx_to,
amount,
block_timestamp,
tx_id
from solana.core.fact_events e
join solana.core.fact_transfers t using (tx_id, block_timestamp)
where block_timestamp > '2024-10-16'
and program_id = 'DeDRoPXNyHRJSagxZBBqs4hLAAM1bGKgxh7cyfuNCBpo'
and mint = 'DBRiDgJAMsM95moTzJs7M9LnkGErpbv9v6CUR1DXnUu5'
and tx_from = '8d81W2jTM4M8GQSMzv9vx4fkTSeVKn1f2iWAZHRgvypY'
)
, first_agg as (
select tx_to as user_address,
sum(amount) as first_amount,
count(distinct tx_id) as first_tx_count,
any_value(tx_id) as first_tx
from base_first
Last run: about 19 hours agoAuto-refreshes every 24 hours
1
284B
557s