DATE | NAME | TOTAL_MEMBERS | ONLINE_MEMBERS | FOLLOWERS | |
|---|---|---|---|---|---|
1 | 2025-02-28 00:00:00.000 | Ronin Network | 61382 | 7268 | 255663 |
2 | 2025-02-27 00:00:00.000 | Ronin Network | 61271 | 7184 | 255541 |
3 | 2025-02-26 00:00:00.000 | Ronin Network | 61184 | 7309 | 254839 |
4 | 2025-02-25 00:00:00.000 | Ronin Network | 60912 | 7090 | 254839 |
5 | 2025-02-24 00:00:00.000 | Ronin Network | 60912 | 7090 | 254839 |
6 | 2025-02-23 00:00:00.000 | Ronin Network | 60912 | 7090 | 254839 |
7 | 2025-02-22 00:00:00.000 | Ronin Network | 60851 | 7063 | 254839 |
8 | 2025-02-21 00:00:00.000 | Ronin Network | 60763 | 7306 | 254839 |
9 | 2025-02-20 00:00:00.000 | Ronin Network | 60635 | 7224 | 254839 |
10 | 2025-02-19 00:00:00.000 | Ronin Network | 60506 | 7213 | 254523 |
11 | 2025-02-18 00:00:00.000 | Ronin Network | 60376 | 7188 | 254250 |
12 | 2025-02-17 00:00:00.000 | Ronin Network | 60252 | 6942 | 253476 |
13 | 2025-02-16 00:00:00.000 | Ronin Network | 60158 | 6935 | 253313 |
14 | 2025-02-15 00:00:00.000 | Ronin Network | 60000 | 6766 | 253139 |
15 | 2025-02-14 00:00:00.000 | Ronin Network | 59898 | 6854 | 252674 |
16 | 2025-02-13 00:00:00.000 | Ronin Network | 59808 | 7035 | 253233 |
17 | 2025-02-12 00:00:00.000 | Ronin Network | 59664 | 6999 | 251904 |
18 | 2025-02-11 00:00:00.000 | Ronin Network | 59564 | 7176 | 251242 |
19 | 2025-02-10 00:00:00.000 | Ronin Network | 59496 | 6873 | 250772 |
20 | 2025-02-09 00:00:00.000 | Ronin Network | 59397 | 6884 | 250541 |
Sandeshtwitter and discord ronin
Updated 2025-03-10
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
›
⌄
with twitter as
(
with res AS (
SELECT
livequery.live.udf_api(
'GET',
'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
{ 'Content-Type': 'application/json' },
{
'sheets_id' : '1uyU6ma_-LAmydFEpVb_X_0f96KFYz7W8dVzKVwKljcQ',
'tab_name' : 'Twitter_data'
}
) as resp
),
data AS (
select resp:data as json_result_must_pivot
from res
),
users AS (
SELECT
value:"date"::TIMESTAMP as date,
value:"name" as name,
value:"followers"::INT as followers,
-- value:"following" as following
value:"id" as id
FROM
data,
LATERAL FLATTEN(input => data.json_result_must_pivot) d
-- limit 5
)
select * from users
where id='1481272552009969664'
Last run: about 1 month ago
28
2KB
6s