StangFAST01 - Big number
    Updated 2023-08-01
    -- forked from 01 @ https://flipsidecrypto.xyz/edit/queries/00a37573-f347-450e-80c1-d91b5e86d2e8

    --- used LIKE and add the % to the end of each line

    --- Program log: Instruction: InitializeAccount --> Program log: User requires [ xxx shades ] to store [ xxx byte ]

    --- Program log: Instruction: IncreaseStorage --> ( Program log: Initial storage: ) - ( Program log: New storage: )
    --- Program log: Instruction: DecreaseStorage --> ?

    --- Program log: Instruction: IncreaseImmutableStorage --> ( Program log: Initial storage: ) - ( Program log: New storage: )
    --- Program log: Instruction: MakeAccountImmutable --> ?

    --- Program log: Instruction: RequestDeleteAccount --> request delete account
    --- Program log: Instruction: DeleteAccount --> success delete account
    --- Program log: Instruction: UnmarkDeleteAccount --> cancel delete account

    with

    sol_price AS
    (
    SELECT
    date_trunc( 'day' , a.recorded_hour ) AS day
    , avg( a.close ) AS price
    FROM
    solana.core.ez_token_prices_hourly a
    WHERE
    a.symbol = 'sol'
    GROUP BY 1
    ORDER BY 1 DESC
    )
    ,
    final AS
    (
    SELECT
    date_trunc( '{{period}}' , a.block_timestamp ) AS "date"

    Run a query to Download Data