Afonso_Diaz4 copy copy copy copy
    Updated 2023-12-05
    -- forked from 4 copy copy copy @ https://flipsidecrypto.xyz/edit/queries/4472812a-7e80-4d87-b49d-5e43de9243a1

    -- forked from 4 copy copy @ https://flipsidecrypto.xyz/edit/queries/3cb0af29-83ff-4a37-9f33-f3a2e2cf68da

    -- forked from 4 copy @ https://flipsidecrypto.xyz/edit/queries/775acb26-c829-4a01-934e-14b24a91a0e9

    -- forked from 4 @ https://flipsidecrypto.xyz/edit/queries/eb1d6f45-055b-48d4-839b-8842082e8a84

    -- forked from 2023-12-03 02:47 AM copy copy @ https://flipsidecrypto.xyz/edit/queries/317deef1-0d6e-4310-aab2-a27dccd20956

    -- forked from 2023-12-03 02:47 AM copy @ https://flipsidecrypto.xyz/edit/queries/146f42c6-de68-4faf-8465-35b64c92e046

    -- forked from 2023-12-03 02:47 AM @ https://flipsidecrypto.xyz/edit/queries/50005a74-ca7b-4827-935c-786d4af5a193


    with t as (
    select
    tx_id,
    block_timestamp,
    nvl(signers[1], signers[0]) as user,
    (post.value:uiTokenAmount:amount - pre.value:uiTokenAmount:amount)/1e6 as amount_acs
    from solana.core.fact_transactions
    join lateral flatten (input => pre_token_balances) pre
    join lateral flatten (input => post_token_balances) post
    where log_messages::string ilike '%6HW8dXjtiTGkD4jzXs7igdFmZExPpmwUrRN5195xGup%'
    and log_messages::string ilike '%Program log: Instruction: Claim rewards%'
    and succeeded = 1
    and pre.value:owner = user
    and pre.value:owner = post.value:owner
    )


    select * from t
    where block_timestamp::date >= '2023-04-01' and block_timestamp::date < '2023-06-01'

    limit 15000
    Run a query to Download Data