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 | 125790 | 7510 | 118280 | 31146 | 156936 | 217514606.067969 | 23070931.364284 | 34842434.489284 | 57816364.558477 | 240585537.432253 | 263559466.942969 | 298401901.99073 | 15380620.9095227 | 181704 | 8902 | 212850 | 4204 | 13106 | 190606 | 221752 | 379403583.122378 | 220600000 | 23228289.6595227 | 115844116.179409 | 69.466783833 |
h4wkbase total
Updated 16 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 16 hours agoAuto-refreshes every 24 hours
1
285B
763s