flipside

    All Tx To Investors, Team And Advisors copy
    winnie-fsAll Tx To Investors, Team And Advisors copy
    Updated 2023-10-13
    -- forked from crypto_edgar / All Tx To Investors, Team And Advisors @ https://flipsidecrypto.xyz/crypto_edgar/q/qmrH3iFCEIN1/all-tx-to-investors-team-and-advisors

    with
    stepn_private_sale as (
    SELECT
    BLOCK_TIMESTAMP,
    TX_ID,
    TX_TO,
    AMOUNT,
    'PRIVATE_SALE' as
    type
    FROM
    solana.core.fact_transfers
    WHERE
    TX_FROM = 'stepnCSERcxqBGrZ7r8nPL5N2vA4WRjRT78UnPJXZ7h'
    AND BLOCK_TIMESTAMP >= '2023-10-10'
    ),
    stepn_team as (
    SELECT
    BLOCK_TIMESTAMP,
    TX_ID,
    TX_TO,
    AMOUNT,
    'TEAM' as
    type
    FROM
    solana.core.fact_transfers
    WHERE
    TX_FROM = 'stepnD3WWdopKXUFzQANbY3nXhSBkWzPnv4GxEZpRSP'
    AND BLOCK_TIMESTAMP >= '2023-10-10'
    ),
    stepn_advisors as (
    SELECT
    BLOCK_TIMESTAMP,
    TX_ID,
    TX_TO,
    Run a query to Download Data