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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48e836c4-2863-4f87-a18e-0a94c7f8a671 | 2026-08-17 15:00 | 2026-08-17 15:00 | 2026-08-17 15:00 | FRMI | FRMI261016C00010000 | call | 10.0000 | 2026-10-16 | 0.2600 | 0.2500 | 0.3000 | 6.1350 | 13054.00 | 0.00 | 13054.00 | 503 | 16 | 589 | 7741 | 0.0760883606769151 | 1.12033510454828 | 1.12322147200969 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | 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 |
| 73d9ab67-4d5f-44cd-8371-900dbfc7c69f | 2026-08-18 10:52 | 2026-08-18 10:52 | 2026-08-18 10:52 | FRMI | FRMI280121C00010000 | call | 10.0000 | 2028-01-21 | 2.0900 | 2.0500 | 2.2000 | 5.9300 | 10440.00 | 0.00 | 10440.00 | 50 | 6 | 68 | 5689 | 0.011952891545087 | 1.0660701818938 | 1.0660701818938 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9f885fae-3ab7-4bea-94ae-fccbccde96eb | 2026-08-18 15:36 | 2026-08-18 15:36 | 2026-08-18 15:36 | FRMI | FRMI260821C00005500 | call | 5.5000 | 2026-08-21 | 0.4000 | 0.3500 | 0.4000 | 5.7850 | 19995.00 | 19995.00 | 0.00 | 500 | 56 | 516 | 65 | 7.93846153846154 | 1.14067856851862 | 1.12110954938917 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0612a684-0dca-4ab4-ae12-95389588ad4c | 2026-08-19 09:48 | 2026-08-19 09:48 | 2026-08-19 09:48 | FRMI | FRMI270115C00010000 | call | 10.0000 | 2027-01-15 | 0.6500 | 0.6000 | 0.7000 | 5.5275 | 399136.00 | 395762.00 | 3374.00 | 6144 | 60 | 6198 | 49428 | 0.125394513231367 | 1.16570242094966 | 1.15544113348618 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c08b543a-8360-4291-bf39-dd600da7df50 | 2026-08-19 09:49 | 2026-08-19 09:49 | 2026-08-19 09:49 | FRMI | FRMI270115C00010000 | call | 10.0000 | 2027-01-15 | 0.7000 | 0.6000 | 0.7500 | 5.5450 | 962286.00 | 959626.00 | 0.00 | 13756 | 98 | 20054 | 49428 | 0.405721453427207 | 1.18907807641185 | 1.18907807641185 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8485f920-4811-4dd9-83a0-8a61a214ca66 | 2026-08-19 15:48 | 2026-08-19 15:48 | 2026-08-19 15:48 | FRMI | FRMI261218C00015000 | call | 15.0000 | 2026-12-18 | 0.3000 | 0.2500 | 0.3000 | 5.7750 | 111239.00 | 111239.00 | 0.00 | 3709 | 40 | 3710 | 7480 | 0.495989304812834 | 1.27088858029609 | 1.26677948296697 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ab557b32-e8c7-4f61-89b2-550e735822bc | 2026-08-21 11:44 | 2026-08-21 11:43 | 2026-08-21 11:43 | FRMI | FRMI261016C00006000 | call | 6.0000 | 2026-10-16 | 1.0500 | 1.0000 | 1.0500 | 6.0650 | 20019.00 | 20019.00 | 0.00 | 191 | 13 | 369 | 916 | 0.402838427947598 | 1.07170760466387 | 1.06010901389655 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | 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 |
| 9277e10c-7fd5-43e4-8432-a5d290681747 | 2026-08-21 15:32 | 2026-08-21 15:32 | 2026-08-21 15:32 | FRMI | FRMI260821C00005500 | call | 5.5000 | 2026-08-21 | 0.4000 | 0.4000 | 0.4500 | 5.9250 | 12850.00 | 0.00 | 12850.00 | 321 | 19 | 754 | 785 | 0.960509554140127 | 9.14943661371336 | 9.14943661371336 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b7d5278a-894c-4a84-b15c-092d66a4b936 | 2026-08-21 15:51 | 2026-08-21 15:51 | 2026-08-21 15:51 | FRMI | FRMI260904P00005500 | put | 5.5000 | 2026-09-04 | 0.2100 | 0.2000 | 0.2500 | 5.9499 | 21002.00 | 0.00 | 21002.00 | 1000 | 8 | 2011 | 150 | 13.4066666666667 | 0.916294114292504 | 0.916294114292504 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0ec8dc24-93e8-4653-afe1-ff8343c2fa8c | 2026-08-24 09:43 | 2026-08-24 09:43 | 2026-08-24 09:43 | FRMI | FRMI260828C00005500 | call | 5.5000 | 2026-08-28 | 0.3300 | 0.3000 | 0.5500 | 5.6750 | 14038.00 | 0.00 | 14038.00 | 420 | 9 | 422 | 1600 | 0.26375 | 1.07854303394546 | 1.07854303394546 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:46:45.098903Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 43b903a0-67c5-40fb-b948-fb2914c81a4c | 2026-08-25 13:35 | 2026-08-25 13:35 | 2026-08-25 13:35 | FRMI | FRMI260828C00006000 | call | 6.0000 | 2026-08-28 | 0.2500 | 0.2000 | 0.3000 | 6.0100 | 10565.00 | 10425.00 | 140.00 | 423 | 11 | 2752 | 2517 | 1.09336511720302 | 1.12419915594269 | 1.12419915594269 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4d1d83f8-03bc-4a08-b75e-ca2e4737c1e9 | 2026-08-27 12:13 | 2026-08-27 12:13 | 2026-08-27 12:13 | FRMI | FRMI261016C00006000 | call | 6.0000 | 2026-10-16 | 0.6900 | 0.6500 | 0.7000 | 5.5300 | 17366.00 | 17366.00 | 0.00 | 250 | 8 | 368 | 1689 | 0.217880402605092 | 1.07364893407802 | 1.05832705525905 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T16:30:57.923324Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 04592747-0dc3-4d8f-a695-32e8a2ed53f2 | 2026-09-04 12:34 | 2026-09-04 12:34 | 2026-09-04 12:34 | FRMI | FRMI261218C00007500 | call | 7.5000 | 2026-12-18 | 0.5500 | 0.5000 | 0.5500 | 4.9250 | 97606.00 | 97606.00 | 0.00 | 1775 | 33 | 1785 | 13402 | 0.133189076257275 | 1.14824033832086 | 1.14824033832086 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4a74be8e-5763-4e00-9419-d1b1e99310b6 | 2026-09-04 12:36 | 2026-09-04 12:36 | 2026-09-04 12:36 | FRMI | FRMI260911C00005000 | call | 5.0000 | 2026-09-11 | 0.2400 | 0.2000 | 0.3000 | 4.9850 | 12584.00 | 150.00 | 2434.00 | 520 | 8 | 565 | 367 | 1.53950953678474 | 0.927748220546385 | 0.927748220546385 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a9ddde04-ceb1-47b9-8cb1-4010de7e5444 | 2026-09-08 12:15 | 2026-09-08 12:15 | 2026-09-08 12:15 | FRMI | FRMI261218C00005000 | call | 5.0000 | 2026-12-18 | 1.6900 | 1.4500 | 1.8000 | 5.7750 | 25324.00 | 25324.00 | 0.00 | 150 | 9 | 172 | 1542 | 0.111543450064851 | 1.12372043971877 | 1.12372043971877 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8e2180ef-8856-4562-8d9c-6d69fa7d6ecc | 2026-09-08 15:44 | 2026-09-08 15:44 | 2026-09-08 15:44 | FRMI | FRMI261016C00008000 | call | 8.0000 | 2026-10-16 | 0.2500 | 0.2500 | 0.3000 | 5.7714 | 13761.00 | 0.00 | 13761.00 | 550 | 7 | 724 | 6428 | 0.112632233976353 | 1.14253854419085 | 1.12535372919734 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 301d2ed0-7f36-4f69-a1b7-5010ed579bad | 2026-09-09 11:26 | 2026-09-09 11:26 | 2026-09-09 11:26 | FRMI | FRMI270219C00007000 | call | 7.0000 | 2027-02-19 | 1.3000 | 1.2000 | 1.3000 | 5.5150 | 64800.00 | 64800.00 | 0.00 | 500 | 9 | 1050 | 1484 | 0.707547169811321 | 1.1876066306784 | 1.16023253591812 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T15:29:26.424015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f32c3245-c606-43ba-a9bc-a33dca2cc738 | 2026-09-10 11:26 | 2026-09-10 11:26 | 2026-09-10 11:26 | FRMI | FRMI280121C00017500 | call | 17.5000 | 2028-01-21 | 1.1500 | 0.9500 | 1.1500 | 5.4250 | 11470.00 | 11470.00 | 0.00 | 100 | 14 | 100 | 4118 | 0.0242836328314716 | 1.10498119143437 | 1.09278917067329 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 39b9a83d-7456-4954-bc1a-84110eba6d7f | 2026-09-15 09:40 | 2026-09-15 09:39 | 2026-09-15 09:39 | FRMI | FRMI261120C00008000 | call | 8.0000 | 2026-11-20 | 0.3000 | 0.2500 | 0.4000 | 5.0250 | 22742.00 | 0.00 | 22742.00 | 750 | 6 | 750 | 6051 | 0.123946455131383 | 1.18661757735279 | 1.18661757735279 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Real Estate | 3234360107.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |