0xaimanUntitled Query
Updated 2022-05-23
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select rune_tx_id,asset_address , asset_address, asset_tx_id, min(block_timestamp) as fd from (
select * --block_timestamp,rune_tx_id, pool_name , asset_address, asset_tx_id, asset_e8, _asset_in_rune_e8
from thorchain.stake_events
)
where asset_e8>0 --or _asset_in_rune_e8>0
group by 1,2,3,4 order by 5
limit 1000
Run a query to Download Data