Options 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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60ce5a9d-4c15-40ab-beb8-22e1b77a2abb | 2026-09-17 10:00 | 2026-09-17 10:00 | 2026-09-17 10:00 | NOK | NOK260918C00010000 | call | 10.0000 | 2026-09-18 | 0.8200 | 0.8200 | 0.8300 | 10.8150 | 80565.00 | 17015.00 | 63550.00 | 980 | 34 | 2663 | 68045 | 0.0391358659710486 | 0.969603194573363 | 0.764258730387209 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 60867740778.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:07:38.635762Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 0bf336e4-69b6-4162-9128-cc880add3c74 | 2026-09-16 15:56 | 2026-09-16 15:56 | 2026-09-16 15:56 | NOK | NOK261016C00012000 | call | 12.0000 | 2026-10-16 | 0.2000 | 0.1800 | 0.2100 | 10.0000 | 97143.00 | 97083.00 | 0.00 | 4829 | 30 | 37857 | 54027 | 0.700705202954079 | 0.655454223268438 | 0.655454223268438 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 58226310517.00 | 2026-10-22 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 9d0307dc-2294-4e85-ac6d-83b7f82ed27e | 2026-09-16 09:37 | 2026-09-16 09:37 | 2026-09-16 09:37 | NOK | NOK261016C00012000 | call | 12.0000 | 2026-10-16 | 0.2100 | 0.2000 | 0.2200 | 10.3150 | 101062.00 | 101062.00 | 0.00 | 4805 | 35 | 4986 | 54027 | 0.0922871897384641 | 0.616321957135704 | 0.605022242618869 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 58226310517.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 988cad01-a8aa-4078-a954-9142d1b855db | 2026-09-11 10:16 | 2026-09-11 10:16 | 2026-09-11 10:16 | NOK | NOK281215C00020000 | call | 20.0000 | 2028-12-15 | 2.2100 | 2.1900 | 2.3000 | 10.8850 | 88440.00 | 0.00 | 88440.00 | 400 | 5 | 555 | 2461 | 0.225518082080455 | 0.611006934395732 | 0.611006934395732 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 55412613066.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T14:26:53.669819Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f30aa727-f519-4cc2-860e-5d105e632a9c | 2026-09-08 13:26 | 2026-09-08 13:26 | 2026-09-08 13:26 | NOK | NOK281215C00010000 | call | 10.0000 | 2028-12-15 | 4.2800 | 4.1500 | 4.4500 | 10.8600 | 214120.00 | 8680.00 | 205440.00 | 500 | 5 | 4890 | 2465 | 1.98377281947262 | 0.580928619141515 | 0.580928619141515 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 55412613066.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T17:42:35.153326Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ea72fd43-13aa-46fd-a868-0496669733d5 | 2026-09-01 13:14 | 2026-09-01 13:14 | 2026-09-01 13:14 | NOK | NOK270416P00009000 | put | 9.0000 | 2027-04-16 | 1.2100 | 1.2100 | 1.2400 | 9.8350 | 154581.00 | 0.00 | 154581.00 | 1276 | 43 | 1276 | 29 | 44 | 0.586547296154069 | 0.586547296154069 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 55412613066.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T17:20:15.685951Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8f4617dd-07b2-47bb-91b3-0d7a4b13eb9c | 2026-08-25 09:42 | 2026-08-25 09:42 | 2026-08-25 09:42 | NOK | NOK270617C00015000 | call | 15.0000 | 2027-06-17 | 1.3000 | 1.2400 | 1.3000 | 10.2750 | 166257.00 | 123603.00 | 14964.00 | 1280 | 40 | 1281 | 23349 | 0.0548631633046383 | 0.679541966195854 | 0.676181759918627 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 55412613066.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 66da2597-70e7-4637-837f-f986ab61f463 | 2026-08-18 10:46 | 2026-08-18 10:46 | 2026-08-18 10:46 | NOK | NOK260925C00012000 | call | 12.0000 | 2026-09-25 | 0.3200 | 0.3200 | 0.3700 | 10.3600 | 97438.00 | 0.00 | 97438.00 | 3000 | 11 | 3085 | 3910 | 0.789002557544757 | 0.638584116939513 | 0.638584116939513 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 55412613066.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8d4c6265-c40c-4389-bf12-3c0e3de6f772 | 2026-08-17 11:53 | 2026-08-17 11:53 | 2026-08-17 11:53 | NOK | NOK261120C00012000 | call | 12.0000 | 2026-11-20 | 1.2200 | 1.1900 | 1.2200 | 10.9750 | 54860.00 | 54860.00 | 0.00 | 450 | 19 | 828 | 23622 | 0.0350520701041402 | 0.706085919109182 | 0.706085919109182 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 55412613066.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |