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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 013b5a42-e4e5-428d-b98c-03d2e107236c | 2026-08-17 11:53 | 2026-08-17 11:53 | 2026-08-17 11:53 | LIN | LIN260918P00470000 | put | 470.0000 | 2026-09-18 | 9.5000 | 8.8000 | 9.5000 | 474.0550 | 53200.00 | 53200.00 | 0.00 | 56 | 8 | 67 | 519 | 0.129094412331407 | 0.217481379463837 | 0.217481379463837 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 214083797499.00 | 2026-10-30 | unknown | — | 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 |
| 6bf68f20-ce21-4fde-9689-e93570bfe8f4 | 2026-08-17 13:48 | 2026-08-17 13:47 | 2026-08-17 13:47 | LIN | LIN261120P00460000 | put | 460.0000 | 2026-11-20 | 15.3700 | 14.6000 | 16.0000 | 474.0000 | 104520.00 | 86090.00 | 16890.00 | 68 | 28 | 69 | 231 | 0.298701298701299 | 0.25016996846262 | 0.25016996846262 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 214083797499.00 | 2026-10-30 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 469058c3-3e03-4bf0-976e-8e65a53336ee | 2026-08-17 14:53 | 2026-08-17 14:53 | 2026-08-17 14:53 | LIN | LIN270115C00500000 | call | 500.0000 | 2027-01-15 | 19.5000 | 19.1000 | 19.9000 | 474.8300 | 95550.00 | 17550.00 | 78000.00 | 49 | 5 | 49 | 279 | 0.175627240143369 | 0.219384551519512 | 0.219384551519512 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 214083797499.00 | 2026-10-30 | 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 |
| 2e9ccb99-f55a-49db-aec1-aab09243274a | 2026-08-18 11:48 | 2026-08-18 11:47 | 2026-08-18 11:47 | LIN | LIN260918P00480000 | put | 480.0000 | 2026-09-18 | 12.1000 | 11.8000 | 12.9000 | 479.9000 | 180290.00 | 119790.00 | 60500.00 | 149 | 17 | 202 | 366 | 0.551912568306011 | 0.228115124719495 | 0.230058553245521 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 214083797499.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1785c60c-512a-4d63-b6d3-fa02573658a5 | 2026-08-21 11:41 | 2026-08-21 11:41 | 2026-08-21 11:41 | LIN | LIN261016C00490000 | call | 490.0000 | 2026-10-16 | 18.1000 | 17.0000 | 19.4000 | 490.5350 | 81450.00 | 3620.00 | 77830.00 | 45 | 21 | 54 | 88 | 0.613636363636364 | 0.214186090444937 | 0.21287137358029 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 214083797499.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 24bcc45b-d9b9-4083-b302-47adc43bdb2b | 2026-08-21 13:36 | 2026-08-21 13:36 | 2026-08-21 13:36 | LIN | LIN270617P00430000 | put | 430.0000 | 2027-06-17 | 15.8900 | 13.0000 | 16.2000 | 487.1500 | 79450.00 | 69940.00 | 3170.00 | 50 | 11 | 57 | 13 | 4.38461538461539 | 0.259019812412426 | 0.259793787580868 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 214083797499.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5e0c19c5-8d98-42db-ab39-0ed2b768793a | 2026-08-21 13:37 | 2026-08-21 13:37 | 2026-08-21 13:37 | LIN | LIN270617P00450000 | put | 450.0000 | 2027-06-17 | 21.6000 | 19.4000 | 21.6000 | 487.2050 | 324000.00 | 324000.00 | 0.00 | 150 | 33 | 150 | 33 | 4.54545454545455 | 0.255873672478816 | 0.255873672478816 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 214083797499.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 802e48f6-076d-4fe6-a5e1-a212089eb2af | 2026-08-24 13:44 | 2026-08-24 13:44 | 2026-08-24 13:44 | LIN | LIN261120C00495000 | call | 495.0000 | 2026-11-20 | 21.2000 | 21.2000 | 22.1000 | 486.1000 | 86920.00 | 0.00 | 86920.00 | 41 | 17 | 77 | 43 | 1.7906976744186 | 0.243585051115683 | 0.243585051115683 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 214083797499.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6cfc79e5-22df-4402-a38c-f3e1cffc91c5 | 2026-08-31 11:56 | 2026-08-31 11:56 | 2026-08-31 11:56 | LIN | LIN261120C00515000 | call | 515.0000 | 2026-11-20 | 13.5000 | 13.5000 | 14.5000 | 488.3500 | 58050.00 | 0.00 | 58050.00 | 43 | 7 | 45 | 124 | 0.362903225806452 | 0.24428733820028 | 0.24428733820028 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 214083797499.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ff15008e-917f-43ce-8140-9c056d8b771d | 2026-09-10 14:22 | 2026-09-10 14:22 | 2026-09-10 14:22 | LIN | LIN261016P00480000 | put | 480.0000 | 2026-10-16 | 22.3000 | 20.5000 | 24.2000 | 461.7350 | 78050.00 | 6690.00 | 71360.00 | 35 | 7 | 38 | 62 | 0.612903225806452 | 0.209422179757217 | 0.209422179757217 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 214083797499.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9b93cda7-10dc-44e5-9e25-1e76e9758d6d | 2026-09-17 12:13 | 2026-09-17 12:12 | 2026-09-17 12:12 | LIN | LIN261016P00440000 | put | 440.0000 | 2026-10-16 | 4.2700 | 3.9000 | 4.6000 | 458.1000 | 55530.00 | 47380.00 | 3850.00 | 130 | 28 | 188 | 222 | 0.846846846846847 | 0.226428822061116 | 0.228422239584254 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 211350185132.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 80ba3afe-a86f-4894-93a0-085d296275b9 | 2026-09-17 13:55 | 2026-09-17 13:55 | 2026-09-17 13:55 | LIN | LIN270617P00505000 | put | 505.0000 | 2027-06-17 | 59.3800 | 58.4000 | 59.8000 | 459.1450 | 89070.00 | 17820.00 | 71250.00 | 15 | 6 | 15 | 35 | 0.428571428571429 | 0.250467053929655 | 0.249821750026145 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 211350185132.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:13:15.605683Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 0561a3bd-fe91-4019-8503-7f2952fb218b | 2026-09-17 14:26 | 2026-09-17 14:25 | 2026-09-17 14:25 | LIN | LIN261016P00460000 | put | 460.0000 | 2026-10-16 | 10.6000 | 9.1000 | 10.8000 | 457.9200 | 50870.00 | 48760.00 | 2110.00 | 48 | 14 | 68 | 410 | 0.165853658536585 | 0.199513106839133 | 0.199513106839133 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 211350185132.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 9a4fe3d2-2c77-4c2b-8c9d-742a9d3af7d4 | 2026-09-17 14:37 | 2026-09-17 14:37 | 2026-09-17 14:37 | LIN | LIN270319P00430000 | put | 430.0000 | 2027-03-19 | 17.5100 | 17.2000 | 18.5000 | 457.7550 | 113800.00 | 0.00 | 113800.00 | 65 | 17 | 74 | 205 | 0.360975609756098 | 0.258780829563571 | 0.258780829563571 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 211350185132.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| f4462b4c-0294-4b37-bb55-a845ecb112b2 | 2026-09-18 12:04 | 2026-09-18 12:03 | 2026-09-18 12:03 | LIN | LIN270617C00525000 | call | 525.0000 | 2027-06-17 | 18.7000 | 18.7000 | 19.8000 | 457.0000 | 91630.00 | 0.00 | 91630.00 | 49 | 5 | 49 | 278 | 0.176258992805755 | 0.233477709558298 | 0.233477709558298 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 212235267045.00 | 2026-10-30 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:25:30.671610Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| f945a71f-f1db-4670-ba13-4660348daeee | 2026-09-18 14:07 | 2026-09-18 14:07 | 2026-09-18 14:07 | LIN | LIN261016P00450000 | put | 450.0000 | 2026-10-16 | 6.3000 | 5.9000 | 6.4000 | 459.6900 | 56070.00 | 27090.00 | 18900.00 | 89 | 12 | 258 | 163 | 1.58282208588957 | 0.218297535567752 | 0.218297535567752 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 212235267045.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |