StangFAST04 - new and old users
Updated 2023-08-19
999
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 03 - game @ https://flipsidecrypto.xyz/edit/queries/b29f0808-96cd-42cf-b5a8-5547c90cc04d
-- 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
)
,
min1 AS
(
SELECT
min( a.block_timestamp ) AS min_date1
, a.origin_from_address AS new_player1
FROM
Run a query to Download Data