ZSaeddata from fact_transactions
Updated 2023-10-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
BLOCK_TIMESTAMP,
BLOCK_ID,
TX_ID,
RECENT_BLOCK_HASH,
SIGNERS,
FEE,
SUCCEEDED,
ACCOUNT_KEYS[0],
PRE_BALANCES,
POST_BALANCES,
PRE_TOKEN_BALANCES[0],
POST_TOKEN_BALANCES[0],
INSTRUCTIONS[0],
INNER_INSTRUCTIONS[0],
LOG_MESSAGES,
UNITS_CONSUMED,
UNITS_LIMIT,
TX_SIZE
from solana.core.fact_transactions
where
date(BLOCK_TIMESTAMP) = '2023-06-30'
and tx_id ='322yt2ewf1nMhRpeLR2cJYA9G1FTAZjhZmktQ3PQ3ZppdDp95VJ4B7i288kebi4JNpVvKdDHfn68Ze4gNdyLTUoP'
Run a query to Download Data