StangFAST03 - game
Updated 2023-08-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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