EVENT_DATE | DAILY_EVENT_COUNT | |
|---|---|---|
1 | 2023-08-11 00:00:00.000 | 1 |
2 | 2023-08-18 00:00:00.000 | 1 |
3 | 2023-08-19 00:00:00.000 | 2 |
4 | 2023-08-20 00:00:00.000 | 1 |
5 | 2023-08-31 00:00:00.000 | 3 |
6 | 2023-09-01 00:00:00.000 | 1 |
7 | 2023-09-02 00:00:00.000 | 1 |
8 | 2023-09-03 00:00:00.000 | 1 |
9 | 2023-09-05 00:00:00.000 | 19 |
10 | 2023-09-06 00:00:00.000 | 1 |
11 | 2023-09-07 00:00:00.000 | 3 |
12 | 2023-09-08 00:00:00.000 | 19 |
13 | 2023-09-09 00:00:00.000 | 2 |
14 | 2023-09-10 00:00:00.000 | 2 |
15 | 2023-09-12 00:00:00.000 | 19 |
16 | 2023-09-13 00:00:00.000 | 25 |
17 | 2023-09-14 00:00:00.000 | 13 |
18 | 2023-09-15 00:00:00.000 | 6 |
19 | 2023-09-16 00:00:00.000 | 1 |
20 | 2023-09-18 00:00:00.000 | 2 |
cryptonerd-iBCnogChildAccountPublished
Updated 2025-03-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- FlowRewards TVL over time
SELECT
DATE(BLOCK_TIMESTAMP) AS event_date,
COUNT(*) AS daily_event_count
FROM
flow.core.fact_events
WHERE
EVENT_CONTRACT = 'A.d8a7e05a7ac670c0.HybridCustody'
AND EVENT_TYPE = 'ChildAccountPublished'
GROUP BY
DATE(BLOCK_TIMESTAMP)
ORDER BY
event_date;
Last run: 3 months ago
...
476
14KB
7s