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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| fcd80f5c-5dcf-48ce-a8ed-a421631b6000 | 2026-08-17 11:34 | 2026-08-17 11:33 | 2026-08-17 11:33 | NEM | NEM270115P00115000 | put | 115.0000 | 2027-01-15 | 10.0000 | 9.5500 | 10.0000 | 120.7950 | 499988.00 | 499988.00 | 0.00 | 500 | 47 | 518 | 2570 | 0.201556420233463 | 0.451034762014669 | 0.451034762014669 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 129677907792.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a5233ff3-ce66-4665-84f5-244979be146d | 2026-08-20 13:08 | 2026-08-20 13:08 | 2026-08-20 13:08 | NEM | NEM270617P00135000 | put | 135.0000 | 2027-06-17 | 23.4200 | 22.7500 | 24.0500 | 127.6800 | 63230.00 | 4690.00 | 58540.00 | 27 | 19 | 33 | 0 | 0 | 0.472733464366842 | 0.471638371355041 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 129677907792.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2c1ff604-cc60-4f35-9a67-3f9700440067 | 2026-08-21 11:21 | 2026-08-21 11:20 | 2026-08-21 11:20 | NEM | NEM261218C00165000 | call | 165.0000 | 2026-12-18 | 5.4000 | 5.1500 | 5.4000 | 131.4000 | 513444.00 | 513444.00 | 0.00 | 951 | 45 | 1390 | 2144 | 0.648320895522388 | 0.499338866497879 | 0.499338866497879 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 129677907792.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ecb60878-31a5-411b-958e-98f25d7195aa | 2026-08-24 12:01 | 2026-08-24 12:01 | 2026-08-24 12:01 | NEM | NEM261120C00145000 | call | 145.0000 | 2026-11-20 | 7.7000 | 7.2500 | 7.7000 | 129.9500 | 265630.00 | 265630.00 | 0.00 | 345 | 19 | 350 | 0 | 0 | 0.504755979253633 | 0.499712008011199 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 129677907792.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T16:14:40.561585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8601e479-2534-4b87-afa2-8a86255ab5b6 | 2026-08-27 13:51 | 2026-08-27 13:51 | 2026-08-27 13:51 | NEM | NEM260828P00131000 | put | 131.0000 | 2026-08-28 | 0.8000 | 0.5000 | 1.0200 | 133.0300 | 80050.00 | 80050.00 | 0.00 | 1000 | 10 | 1055 | 122 | 8.64754098360656 | 0.592197444012788 | 0.579834023869795 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 129677907792.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c561eeec-e475-417e-89ec-7f0e1d6f2e98 | 2026-08-27 13:56 | 2026-08-27 13:56 | 2026-08-27 13:56 | NEM | NEM260828P00131000 | put | 131.0000 | 2026-08-28 | 0.8600 | 0.5500 | 1.0200 | 132.6900 | 86253.00 | 86253.00 | 0.00 | 1000 | 13 | 2055 | 122 | 16.844262295082 | 0.58104704382633 | 0.58104704382633 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 129677907792.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 57522418-17f3-45fe-89d2-f03c5fa7e46c | 2026-08-28 12:10 | 2026-08-28 12:10 | 2026-08-28 12:10 | NEM | NEM261016C00140000 | call | 140.0000 | 2026-10-16 | 4.0000 | 3.9500 | 4.4000 | 128.6400 | 244735.00 | 239600.00 | 5135.00 | 612 | 6 | 663 | 17273 | 0.0383836044694031 | 0.420481325245427 | 0.422418913803611 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 129677907792.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:25:17.992358Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 11e29369-0126-45c6-9a1d-a67daec89aca | 2026-08-28 12:44 | 2026-08-28 12:44 | 2026-08-28 12:44 | NEM | NEM261016P00105000 | put | 105.0000 | 2026-10-16 | 0.8900 | 0.5900 | 0.9300 | 127.4300 | 184677.00 | 182634.00 | 2043.00 | 2066 | 63 | 5007 | 641 | 7.81123244929797 | 0.430298961772971 | 0.434229836554585 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 129677907792.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ad51547d-b60f-4a9b-b503-fe42ed6045b8 | 2026-08-28 15:18 | 2026-08-28 15:17 | 2026-08-28 15:17 | NEM | NEM261016P00115000 | put | 115.0000 | 2026-10-16 | 2.6500 | 2.5000 | 2.6900 | 127.8750 | 1326402.00 | 682201.00 | 246701.00 | 5006 | 40 | 10229 | 2512 | 4.07205414012739 | 0.428358018953555 | 0.423863067661939 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 129677907792.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T19:36:54.231390Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4f4dfe5b-f0d5-419f-9a35-486195ddbfa3 | 2026-09-09 11:43 | 2026-09-09 11:42 | 2026-09-09 11:42 | NEM | NEM270617C00130000 | call | 130.0000 | 2027-06-17 | 21.3500 | 20.8500 | 21.8500 | 128.7000 | 55500.00 | 40560.00 | 14940.00 | 26 | 6 | 62 | 1212 | 0.0511551155115512 | 0.450055372357423 | 0.448909481643841 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 129677907792.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 684f7d01-f34a-405c-b105-bdb4572f0331 | 2026-09-18 10:36 | 2026-09-18 10:36 | 2026-09-18 10:36 | NEM | NEM270319P00135000 | put | 135.0000 | 2027-03-19 | 21.7300 | 21.4000 | 21.8000 | 122.4300 | 82560.00 | 45675.00 | 36885.00 | 38 | 6 | 54 | 112 | 0.482142857142857 | 0.462075767167857 | 0.460622518215803 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 130036163164.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |