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 | 126964 | 7510 | 119454 | 31146 | 158110 | 219713673.09668 | 23070931.364284 | 34842434.489284 | 57816364.558477 | 242784604.460964 | 265758533.97168 | 300600969.019441 | 15380620.9095227 | 183870 | 8902 | 215016 | 4204 | 13106 | 192772 | 223918 | 379403583.122378 | 220600000 | 23228289.6595227 | 113645049.150698 | 70.046395394 |
h4wkbase total
Updated 13 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 13 hours agoAuto-refreshes every 24 hours
1
284B
519s