penalty claimer holding type

h4wkpenalty claimer holding type

Updated 2025-05-30

-- forked from first claimer @ https://flipsidecrypto.xyz/studio/queries/6c953a7b-9713-49b9-bfce-c30912de5b6c

-- forked from penalty total @ https://flipsidecrypto.xyz/studio/queries/6ada0e8b-3aa6-44d1-833a-ed3e2631edd6

-- 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,

Last run: 18 days ago

548B

933s