h4wkReclaim overview
    Updated 2023-10-20
    -- 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