MostlyData_Solana Testing CTEs
    Updated 2025-03-18
    --/*
    with jito_payment_id as(
    select
    tx_id
    from solana.core.fact_transactions
    where
    signers[0] = 'EG2ziPBR4uc9MzCLxBmnrE7cozKZV8DTvVSxPWXiQ8vh'
    and block_timestamp between cast('2025-03-12' as timestamp) and cast('2025-03-18' as timestamp)
    )

    ,balance_change_info as (
    select
    sb.block_id,
    sb.tx_id,
    sb.account_address,
    sb.balance,
    sb.balance - sb.pre_balance as balance_change
    from solana.core.fact_sol_balances sb
    --join jito_payment_id jpi
    -- on jpi.tx_id = sb.tx_id
    where
    sb.account_address = 'Chorus6Kis8tFHA7AowrPMcRJk3LbApHTYpgSNXzY5KE'
    and block_timestamp between cast('2025-03-01' as timestamp) and cast('2025-03-10' as timestamp)
    )

    select
    *

    from balance_change_info --limit 100
    where balance_change > 0 and balance_change > 0.1
    --*/
    /*
    QueryRunArchived: QueryRun has been archived