crypto_edgar2024-02-16 03:39 PM
    Updated 2024-02-17
    WITH FLP AS (
    SELECT
    -- COUNT(DISTINCT DECODED_ACCOUNTS[3]:pubkey),
    -- DISTINCT DECODED_ACCOUNTS[4]:pubkey
    -- DISTINCT DECODED_ACCOUNTS[5]:pubkey
    DISTINCT DECODED_ACCOUNTS[7]:pubkey
    -- COUNT(DISTINCT DECODED_ACCOUNTS[4]:pubkey),
    -- COUNT(DISTINCT DECODED_ACCOUNTS[5]:pubkey),
    -- COUNT(DISTINCT DECODED_ACCOUNTS[7]:pubkey)
    -- DECODED_ACCOUNTS
    FROM
    solana.core.ez_events_decoded
    WHERE
    BLOCK_TIMESTAMP >= '2023-12-28'
    AND PROGRAM_ID = 'FLASH6Lo6h3iasJKWDs2F8TkW2UKf3s15C8PMGuVfgBn'
    AND SUCCEEDED
    AND EVENT_TYPE = 'collectStakeFees'
    )
    -- TOKEN_PRICES AS (
    -- SELECT
    -- RECORDED_HOUR :: date as DAY,
    -- TOKEN_ADDRESS,
    -- AVG(CLOSE) AS PRICE
    -- FROM
    -- solana.price.ez_token_prices_hourly
    -- WHERE
    -- RECORDED_HOUR >= '2023-12-28'
    -- GROUP BY
    -- DAY,
    -- TOKEN_ADDRESS
    -- ),
    -- Final_Table AS (
    -- SELECT
    -- DATE_TRUNC('Day', TRANSFERS.BLOCK_TIMESTAMP) AS TRANSFERS_DAY,
    -- SUM(AMOUNT * PRICE) AS VOLUME,
    -- AVG(AMOUNT * PRICE) AS AVG_VOLUME,
    Last run: about 1 year ago
    DECODED_ACCOUNTS[7]:PUBKEY
    1
    BC5xAUpEbfeSWi5fJdvhFQhM3eMbTok2c7SY62daB3da
    2
    7b2jY9CeCWCnyKBvaLSnsV7qwUhbJGsJTPdyCsspPY7Q
    2
    99B
    0s