frontboatgames by date testnet
Updated 2024-10-01
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
›
⌄
-- forked from games copy @ https://flipsidecrypto.xyz/edit/queries/9a22af24-91ef-4226-b64e-b59532bb02cc
SELECT
decoded_traces.function as action,
INPUT.value:name::string as client_reward_address_name,
INPUT.value:value::string as client_reward_address_value,
COUNT(*) as total_games,
DATE_TRUNC('day', decoded_traces.TIMESTAMP) as date
FROM
external.tokenflow_starknet.decoded_traces,
LATERAL FLATTEN(input => decoded_traces.INPUTS) as INPUT
WHERE
decoded_traces.CHAIN_ID = 'testnet'
AND decoded_traces.FUNCTION = 'new_game'
AND decoded_traces.CONTRACT IN (
'0x071d07b1217cdcc334739a3f28da75db05d62672ad04b9204ee11b88f2f9f61c'
)
AND INPUT.INDEX = 0
GROUP BY
date, action, client_reward_address_name, client_reward_address_value
ORDER BY
date, client_reward_address_name
QueryRunArchived: QueryRun has been archived