0xbrun0test-smart-guys-akro_20230201
    Updated 2023-02-27
    -- Find people who brought $AKRO between 2023-02-01 and 2023-02-15
    -- before the surge in price
    with
    gen as (
    SELECT
    tb.user_address,
    (
    ARRAY_AGG(tb.balance) WITHIN GROUP (
    ORDER BY
    tb.block_timestamp
    )
    ) [0] AS balance_gen
    from
    ethereum.core.fact_token_balances tb
    where
    tb.block_timestamp <= '2021-1-01'
    and tb.contract_address = '0x9D65fF81a3c488d585bBfb0Bfe3c7707c7917f54'
    group by
    tb.user_address
    ),
    feb as (
    SELECT
    tb.user_address,
    (
    ARRAY_AGG(tb.balance) WITHIN GROUP (
    ORDER BY
    tb.block_timestamp
    )
    ) [0] AS balance_feb
    from
    ethereum.core.fact_token_balances tb
    where
    tb.block_timestamp <= '2023-02-25'
    and tb.contract_address = '0x9D65fF81a3c488d585bBfb0Bfe3c7707c7917f54'
    group by
    tb.user_address
    Run a query to Download Data