Date | Functions | Program Calls | Transactions | Unique Users | |
|---|---|---|---|---|---|
1 | 2024-08-29 00:00:00.000 | Idl Write | 7 | 7 | 1 |
2 | 2024-09-28 00:00:00.000 | End And Start Game | 87 | 87 | 1 |
3 | 2024-09-29 00:00:00.000 | End And Start Game | 591 | 591 | 1 |
4 | 2024-09-29 00:00:00.000 | Init Prediction Stats | 2 | 2 | 1 |
5 | 2024-09-29 00:00:00.000 | Init Season Stats | 1 | 1 | 1 |
6 | 2024-09-29 00:00:00.000 | Init User Stats | 7 | 7 | 4 |
7 | 2024-09-29 00:00:00.000 | Mark Withdrawn | 5 | 4 | 2 |
8 | 2024-09-29 00:00:00.000 | Predict | 14 | 14 | 3 |
9 | 2024-09-29 00:00:00.000 | Withdraw Winnings | 7 | 6 | 3 |
10 | 2024-10-01 00:00:00.000 | End And Start Game | 541 | 541 | 1 |
11 | 2024-10-01 00:00:00.000 | Init Season Stats | 1 | 1 | 1 |
12 | 2024-10-01 00:00:00.000 | Init User Stats | 1 | 1 | 1 |
13 | 2024-10-01 00:00:00.000 | Predict | 3 | 3 | 2 |
14 | 2024-10-01 00:00:00.000 | Withdraw Winnings | 1 | 1 | 1 |
15 | 2024-10-02 00:00:00.000 | End And Start Game | 900 | 900 | 1 |
16 | 2024-10-02 00:00:00.000 | Init Season Stats | 1 | 1 | 1 |
17 | 2024-10-02 00:00:00.000 | Init User Stats | 2 | 2 | 1 |
18 | 2024-10-02 00:00:00.000 | Mark Withdrawn | 5 | 4 | 2 |
19 | 2024-10-02 00:00:00.000 | Predict | 11 | 11 | 2 |
20 | 2024-10-02 00:00:00.000 | Withdraw Unused Accounts Rent | 783 | 36 | 1 |
hbd1994002 - Daily Function Calls and Transactions
Updated 2025-03-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
›
⌄
with base_query as (
select
BLOCK_TIMESTAMP,
TX_ID,
replace(substr(utils.udf_base58_to_hex(INSTRUCTION:data),3,1000), '') as instruction_data,
INDEX,
signers[0] as user
from eclipse.core.fact_events
where SUCCEEDED = 'TRUE'
and PROGRAM_ID = 'DcZMKcjz34CcXF1vx7CkfARZdmEja2Kcwvspu1Zw6Zmn')
select
date_trunc('day', BLOCK_TIMESTAMP) as "Date",
case
when substr(instruction_data,0,16) = '3b86a17013edc06b' then 'End And Start Game'
when substr(instruction_data,0,16) = 'f6db9f60f8d1dac8' then 'Withdraw Unused Accounts Rent'
when substr(instruction_data,0,16) = 'fe7270f425312080' then 'Predict'
when substr(instruction_data,0,16) = '4bb494755164a932' then 'Withdraw Winnings'
when substr(instruction_data,0,16) = 'f13de01f5091cacb' then 'Mark Withdrawn'
when substr(instruction_data,0,16) = 'b17114e8b557783e' then 'Init User Stats'
when substr(instruction_data,0,16) = 'cb7483c1bcb89132' then 'Init Season Stats'
when substr(instruction_data,0,16) = '40f4bc78a7e9690a' then 'Idl Write'
when substr(instruction_data,0,16) = '1d27c86c5e60638d' then 'Init Prediction Stats'
end as "Functions",
count(*) as "Program Calls",
count(distinct tx_id) as "Transactions",
count(distinct user) as "Unique Users"
from base_query
group by 1,2
order by 1,2
Last run: 11 days agoAuto-refreshes every 24 hours
...
1212
65KB
71s