No Data to Display
0xHaM-dNew Users Top First Apps[Past Week]
Updated 2025-02-15
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 events as (
select
t1.BLOCK_TIMESTAMP,
t1.TX_ID,
FEE,
INSTRUCTIONS[1]:program_id as program_id,
-- t2.program_id,
t1.signers[0] as user
from eclipse.core.fact_transactions t1
-- LEFT JOIN eclipse.core.fact_events_inner t2 on trunc(t1.BLOCK_TIMESTAMP, 'd') = trunc(t2.BLOCK_TIMESTAMP, 'd') AND t1.TX_ID = t2.TX_ID
where t1.succeeded = True
)
-- , inner_events as (
-- select
-- t1.BLOCK_TIMESTAMP,
-- t1.TX_ID,
-- FEE,
-- t2.program_id,
-- t1.signers[0] as user
-- from eclipse.core.fact_transactions t1
-- LEFT JOIN eclipse.core.fact_events t2 on trunc(t1.BLOCK_TIMESTAMP, 'd') = trunc(t2.BLOCK_TIMESTAMP, 'd') AND t1.TX_ID = t2.TX_ID
-- where t1.succeeded = True
-- )
, combine as (
select * from events
-- UNION ALL
-- select * from inner_events
)
, functionTb as (
select
BLOCK_TIMESTAMP,
program_id,
TX_ID,
user,
FEE,
case
Last run: about 2 months ago
0
2B
82s