lagandispenserUntitled Query 5
Updated 2022-01-04
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
-- select * FROM terra.tax_rate LIMIT 20
-- select * from ethereum.TRANSACTIONs where block_timestamp = CURRENT_DATE-1 limit 20
with today_transactions as (
-- select tx_id from thorchain.swaps where block_timestamp >= CURRENT_DATE limit 10
select tx_id from thorchain.swaps where block_timestamp >= CURRENT_DATE
)
-- select thorchain.swaps.to_amount from thorchain.swaps INNER join today_transactions
-- SELECT MAX(thorchain.swaps.to_amount) AS LargestPrice FROM thorchain.swaps INNER join today_transactions
SELECT MAX(thorchain.swaps.to_amount) AS LargestPrice FROM thorchain.swaps where block_timestamp >= CURRENT_DATE-30
-- on(today_transactions.tx_id =ethereum.udm_events.tx_id )
-- select tx_id from thorchain.swaps where block_timestamp >= CURRENT_DATE limit 100
Run a query to Download Data