sriniUntitled Query
Updated 2022-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with sample_tx as (
select *
from solana.core.fact_transactions
where block_timestamp >= '2022-11-01'
and block_timestamp < '2022-11-02'
and succeeded = True
),
sample_tf as (
select *
from solana.core.fact_transfers
where block_timestamp >= '2022-11-01'
and block_timestamp < '2022-11-02'
)
select *
from sample_tx tx
left join sample_tf tf
on tx.tx_id = tf.tx_id
order by tx.tx_id
limit 100
Run a query to Download Data