crabtriumph-3379TOP3 Referrers (On-chain) Monthly
Updated 2024-08-26
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
›
⌄
-- forked from sssstatistic / TOP Referrers (On-chain) Monthly @ https://flipsidecrypto.xyz/sssstatistic/q/wiMHLAjIt5Fb/top-referrers-on-chain-monthly
With timeline as (
SELECT
to_timestamp(value['start']) AS start_time,
to_timestamp(value['end']) AS end_time,
value['season'] AS season
from
table(
flatten(
PARSE_JSON(
'[
{"start":"2024-05-15 00:00:00", "end":"2024-06-15 00:00:00", "season": 1},
{"start":"2024-06-15 00:00:00", "end":"2024-07-15 00:00:00", "season": 2},
{"start":"2024-07-15 00:00:00", "end":"2024-08-15 00:00:00", "season": 3},
{"start":"2024-08-15 00:00:00", "end":"2024-09-15 00:00:00", "season": 4},
{"start":"2024-09-15 00:00:00", "end":"2024-10-15 00:00:00", "season": 5},
{"start":"2024-10-15 00:00:00", "end":"2024-11-15 00:00:00", "season": 6},
{"start":"2024-11-15 00:00:00", "end":"2024-12-15 00:00:00", "season": 7},
]'
)
)
) f
where season = {{param_RefsSeason}}
),
level_info AS (
select
count(*) as level,
origin_from_address
from
blast.core.ez_decoded_event_logs el
where
contract_address in (
'0xc48f6213a1a4d3ead79db812c2b91817980532c3'
)
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived