2,358 answered market questions

SELECT
    ticker                                                                                        AS contract,
    formatDateTime(toTimeZone(argMax(sip_timestamp, (size, sip_timestamp)), 'America/New_York'), '%H:%i:%S') AS printed_at_et,
    round(toFloat64(argMax(price, (size, sip_timestamp))), 2)                                    AS print_price,
    max(size)                                                                                     AS print_size,
    formatReadableQuantity(toFloat64(argMax(price, (size, sip_timestamp))) * toFloat64(max(size)) * 100) AS notional_usd,
    toString(argMax(exchange, (size, sip_timestamp)))                                            AS exchange_id,
    replaceAll(replaceAll(toString(argMax(conditions, (size, sip_timestamp))), '[', ''), ']', '') AS condition_codes
FROM global_markets.options_trades
WHERE underlying_symbol = 'SPY'
  AND sip_timestamp >= '2025-05-15 00:00:00'
  AND sip_timestamp <  '2025-05-16 00:00:00'
GROUP BY ticker
ORDER BY print_size DESC, contract
LIMIT 10