lagandispenserUntitled Query 5
    Updated 2022-01-04
    -- 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