StangFAST03 - game
    Updated 2023-08-25
    -- forked from 01 - overview @ https://flipsidecrypto.xyz/edit/queries/5fb49465-8651-4902-8c74-3a32a8bd3cc3

    --- min( identifier ) -> wager
    --- origin to address
    --- 0xf3ACbca9A49A0738D3fCD6836843890C7352736C - Coin Flip [ 0x81542c95 ]
    --- 0xb386ff2f5148a1fd91743785ade661b26861364b - Range [ 0xa0e7f53e ] , Limbo [ 0xa0e7f53e ]
    --- 0xddaB0c89957fCE47B1e92d3EE835Ce8f632528a2 - RPS [ 0x81542c95 ]
    --- 0xb812743b801d357468b48cdef3ece84d39dd8fff - Plinko [ 0x517c521d ]
    --- 0x203c2cae7cf5c66fb64c7c0999cf3f760bd70e8e - Dice [ 0xa378bc15 ]
    --- 0xb5fb07261f83e90e2913879d440ece4e83fc2bb3 - Keno [ 0x6376cb1b ]
    --- 0x93d088c58884708924bf7631769c4c950d4f77c7 - Roulette [ 0xcd6ac2b4 ]
    --- 0x76043712c692b83e79e9d51a2897767dc30d7b94 - PVP Flip [ 0x9ea81f2b ] [ CALL_ORIGIN ]

    with

    avax_price AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS day
    , avg( a.price ) AS price
    FROM
    avalanche.core.fact_hourly_token_prices a
    WHERE
    a.symbol = 'WAVAX'
    GROUP BY 1
    ORDER BY 1 DESC
    )

    SELECT
    date_trunc( 'day' , a.block_timestamp ) AS "date"

    , count( DISTINCT a.origin_from_address ) AS "player"
    , count( DISTINCT a.tx_hash ) AS "play count"
    , sum( a.amount * b.price ) AS "wagered"

    , case
    Run a query to Download Data