ambalikaUntitled Query
Updated 2022-11-23
9
1
2
3
4
5
6
7
›
⌄
select t.block_timestamp, t.tx_hash, nonce , from_address,ORIGIN_FROM_ADDRESS, to_address, ORIGIN_TO_ADDRESS, CONTRACT_ADDRESS, tx_fee, event_name,
EVENT_INDEX, rank() over (partition by t.tx_hash order by EVENT_INDEX desc) as event_index -- to select event with event_index=1
from bsc.core.fact_transactions t
left join bsc.core.fact_event_logs l on t.tx_hash=l.tx_hash
where status='SUCCESS'
and from_address='0xf06176c47d1b598823d0a98841f89fe931785f60'
Run a query to Download Data