Simplify AnalyticsOptions flow alerts (market-wide)
core.flow_alerts
Every UW flow alert, on every ticker - untracked ones included, which is the point. Keyed on the vendor's alert id. `ticker` is verbatim (SPX weeklies arrive as SPXW). Not exportable: each alert carries the contract's bid and ask.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 rowsrestricted — hover for the licence
| iduuid | created_at ↑timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strikenumeric | expirydate | pricenumeric | bidnumeric | asknumeric | underlying_pricenumeric | total_premiumnumeric | total_ask_side_premnumeric | total_bid_side_premnumeric | total_sizebigint | trade_countinteger | volumebigint | open_interestbigint | volume_oi_rationumeric | iv_startnumeric | iv_endnumeric | has_sweepboolean | has_floorboolean | has_multilegboolean | has_singlelegboolean | all_opening_tradesboolean | alert_ruletext | rule_iduuid | expiry_countinteger | issue_typetext | sectortext | marketcapnumeric | next_earnings_datedate | er_timetext | missing_periscopeboolean | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99e2956d-604d-47fe-bae5-48df149c8e25 | 2026-08-17 15:10 | 2026-08-17 15:10 | 2026-08-17 15:10 | ONDS | ONDS280121C00010000 | call | 10.0000 | 2028-01-21 | 3.9000 | 3.8000 | 3.9500 | 9.0400 | 39819.00 | 31589.00 | 8230.00 | 102 | 12 | 1248 | 21168 | 0.0589569160997732 | 0.987386841321588 | 0.981981270811819 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3584363960.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f0907d10-dcdd-413a-842f-d3c0134f8c98 | 2026-08-18 13:29 | 2026-08-18 13:29 | 2026-08-18 13:29 | ONDS | ONDS280121C00020000 | call | 20.0000 | 2028-01-21 | 2.1400 | 2.1000 | 2.1500 | 8.9350 | 10704.00 | 10704.00 | 0.00 | 50 | 5 | 151 | 16017 | 0.00942748329899482 | 0.968977169092669 | 0.966623757325014 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3584363960.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e1fdfea1-a78f-4f4b-8e36-0a3f290af915 | 2026-08-19 09:59 | 2026-08-19 09:59 | 2026-08-19 09:59 | ONDS | ONDS270115C00012000 | call | 12.0000 | 2027-01-15 | 1.1300 | 1.0800 | 1.2000 | 8.7350 | 17093.00 | 15256.00 | 1837.00 | 151 | 7 | 181 | 19660 | 0.00920651068158698 | 0.928314310213145 | 0.919120003889354 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3584363960.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 910b281b-c5e5-429e-8216-da84fbdee1ae | 2026-08-24 12:58 | 2026-08-24 12:58 | 2026-08-24 12:58 | ONDS | ONDS261016C00009000 | call | 9.0000 | 2026-10-16 | 0.7300 | 0.7200 | 0.7600 | 8.2800 | 18252.00 | 1973.00 | 16279.00 | 250 | 8 | 1080 | 2263 | 0.477242598320813 | 0.798362232955657 | 0.790373040973903 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3584363960.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6c14f261-2139-428e-9b24-86ac4132d0a8 | 2026-08-26 09:52 | 2026-08-26 09:52 | 2026-08-26 09:52 | ONDS | ONDS280121C00017000 | call | 17.0000 | 2028-01-21 | 1.9600 | 1.9500 | 2.0000 | 8.1750 | 17445.00 | 0.00 | 17445.00 | 89 | 9 | 411 | 9226 | 0.0445480164751788 | 0.944988399955057 | 0.939808822890328 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3584363960.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 86eb28a2-bd59-42c9-ae38-a6b9a525d784 | 2026-08-26 14:22 | 2026-08-26 14:22 | 2026-08-26 14:22 | ONDS | ONDS280121C00010000 | call | 10.0000 | 2028-01-21 | 3.1400 | 3.0000 | 3.1500 | 8.1550 | 14109.00 | 14109.00 | 0.00 | 45 | 6 | 504 | 21945 | 0.0229665071770335 | 0.957640135488185 | 0.949110663825948 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3584363960.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T18:39:51.047298Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c0c2c407-7775-49eb-839e-7886b0eb6b51 | 2026-08-28 09:42 | 2026-08-28 09:42 | 2026-08-28 09:42 | ONDS | ONDS261218C00009000 | call | 9.0000 | 2026-12-18 | 1.4000 | 1.3400 | 1.5600 | 8.4299 | 58286.00 | 0.00 | 58286.00 | 417 | 6 | 420 | 5368 | 0.0782414307004471 | 0.855114948540349 | 0.822685557947616 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3584363960.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 427979f1-26ef-4182-9952-851effa97220 | 2026-08-28 11:12 | 2026-08-28 11:12 | 2026-08-28 11:12 | ONDS | ONDS260918C00007000 | call | 7.0000 | 2026-09-18 | 1.3000 | 1.3000 | 1.3500 | 8.2097 | 11729.00 | 0.00 | 11729.00 | 90 | 5 | 121 | 4728 | 0.0255922165820643 | 0.634234953857861 | 0.609341353236694 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3584363960.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 388f9ce0-00d0-4ced-a39c-7d975548f526 | 2026-09-16 15:49 | 2026-09-16 15:49 | 2026-09-16 15:49 | ONDS | ONDS270521C00010000 | call | 10.0000 | 2027-05-21 | 1.2500 | 1.2400 | 1.3600 | 7.0000 | 36128.00 | 127.00 | 36001.00 | 289 | 7 | 331 | 15 | 22.0666666666667 | 0.874456506334173 | 0.865859645405691 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3569491080.00 | 2026-11-12 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |