h4wkReclaim overview
Updated 2023-10-20
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
›
⌄
-- 19.055441478439427 (fee rate) * (128 + 15_000)(account size including metadata) * ((365.25/2) * 2)(epochs in 2 years)
WITH created_rent AS (
select block_timestamp as create_time,
i.value['parsed']['info']['newAccount'] as newAddress,
CASE
WHEN array_contains('Program BPFLoaderUpgradeab1e11111111111111111111111 success'::VARIANT, log_messages) THEN 'Deploy Program'
WHEN array_contains('Program log: Instruction: InitializeAccount3'::VARIANT, log_messages) THEN 'Create Associated Account'
WHEN log_messages::string ilike '%Program M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K%' THEN 'MagicEden Buy/Sell'
WHEN log_messages::string ilike '%Program LCNTy2Q4HsKUecKEETwwzujjbAx9DGFJort8SjGzGFj%' then 'Ladder Caster'
WHEN log_messages::string ilike '%Program DDZDcYdQFEMwcu2Mwo75yGFjJ1mUQyyXLWzhZLEVFcei%' then 'Audius'
ELSE 'Unknown'
END AS event,
greatest( 19.055441478439427/1e9 * i.value['parsed']['info']['space'] * ((365.25/2) * 2), 0.00203928) AS rent
FROM solana.core.fact_transactions,
LATERAL FLATTEN(instructions) AS i
WHERE i.value['parsed']['type'] ilike 'create%' AND succeeded
AND block_timestamp::DATE >= (CURRENT_DATE-1) - 21
AND block_timestamp::DATE < (CURRENT_DATE-1)
UNION
select block_timestamp as create_time,
i.value['parsed']['info']['newAccount'] as newAddress,
CASE
WHEN array_contains('Program BPFLoaderUpgradeab1e11111111111111111111111 success'::VARIANT, log_messages) THEN 'Deploy Program'
WHEN array_contains('Program log: Instruction: InitializeAccount3'::VARIANT, log_messages) THEN 'Create Associated Account'
WHEN log_messages::string ilike '%Program M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K%' THEN 'MagicEden Buy/Sell'
WHEN log_messages::string ilike '%Program LCNTy2Q4HsKUecKEETwwzujjbAx9DGFJort8SjGzGFj%' then 'Ladder Caster'
WHEN log_messages::string ilike '%Program DDZDcYdQFEMwcu2Mwo75yGFjJ1mUQyyXLWzhZLEVFcei%' then 'Audius'
ELSE 'Unknown'
END AS event,
greatest( 19.055441478439427/1e9 * i.value['parsed']['info']['space'] * ((365.25/2) * 2), 0.00203928) AS rent
FROM solana.core.fact_transactions,
LATERAL FLATTEN(inner_instructions) AS i_tmp,
LATERAL FLATTEN(i_tmp.value['instructions']) AS i
WHERE i.value['parsed']['type'] ilike 'create%' AND succeeded
Run a query to Download Data