theericstonescrap
Updated 2023-08-18
999
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
›
⌄
⌄
⌄
-- vanilla transfer
select * from solana.core.fact_events
where tx_id = '5EpLBNfzYYY2tri6RAkvWwG4364hdfhwy3buYuJG4CGoABiuTo7WbcikLAia3RDre4XKXhJ2byf8pZSB4YpDba46'
and block_timestamp > '2024-03-03'
and block_timestamp < '2024-03-05';
select * from solana.core.fact_events
where tx_id = 'dSCt5cAbUdRybj8J2SiQsYKAuNurky5Bqu4tEP96zXVEfsZsVzH7PrPrdPbzk69TBpVbYXqt4ugyRR958tVkpi4'
and block_timestamp > '2024-04-22'
and block_timestamp < '2024-04-24';
with total as (
select count(1) total_txns from
sei.core.fact_transactions
where block_timestamp > current_date - 30
and tx_succeeded = TRUE
),
complex as (
select distinct(tx_id) as tx_id
from sei.core.fact_msgs
where block_timestamp > current_date - 30
and msg_type ilike any ('execute','wasm')
and tx_succeeded = TRUE
),
labeled as (
select address
from sei.core.dim_labels
UNION
select currency as address
from sei.core.dim_tokens
),
select
Run a query to Download Data