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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| e5481348-d829-49c1-9dcd-d359b6bf718c | 2026-09-18 15:24 | 2026-09-18 15:24 | 2026-09-18 15:24 | GEMI | GEMI270115C00007500 | call | 7.5000 | 2027-01-15 | 0.8500 | 0.7000 | 0.8500 | 5.7784 | 22525.00 | 22525.00 | 0.00 | 265 | 21 | 977 | 1265 | 0.772332015810277 | 1.03606252617987 | 1.03606252617987 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | Financial Services | 316792679.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| c2744aee-638f-47e4-be13-f667aa2efe0f | 2026-09-18 15:23 | 2026-09-18 15:22 | 2026-09-18 15:22 | GEMI | GEMI261023C00007000 | call | 7.0000 | 2026-10-23 | 0.3500 | 0.2000 | 0.4000 | 5.7750 | 28025.00 | 28025.00 | 0.00 | 801 | 43 | 1050 | 142 | 7.3943661971831 | 1.03899610830589 | 1.03899610830589 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | Financial Services | 316792679.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 86bb2273-5e67-4c8f-a5c4-c8cfda875491 | 2026-09-18 11:18 | 2026-09-18 11:18 | 2026-09-18 11:18 | GEMI | GEMI261016C00005000 | call | 5.0000 | 2026-10-16 | 0.5000 | 0.4500 | 0.5500 | 4.8650 | 71900.00 | 0.00 | 71250.00 | 1438 | 26 | 2258 | 1967 | 1.14794102694459 | 1.02864932055562 | 1.02864932055562 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | Financial Services | 316792679.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 5183973f-f6bb-444c-8b6a-a590b5788efa | 2026-09-18 10:26 | 2026-09-18 10:25 | 2026-09-18 10:25 | GEMI | GEMI261016C00005000 | call | 5.0000 | 2026-10-16 | 0.5000 | 0.4500 | 0.5500 | 4.8900 | 18200.00 | 15400.00 | 750.00 | 364 | 32 | 384 | 1967 | 0.195221148957804 | 1.02377651931328 | 1.00423197084709 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | Financial Services | 316792679.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| e1af4b17-8b5b-4c73-a034-bf154848d5f9 | 2026-09-14 15:20 | 2026-09-14 15:19 | 2026-09-14 15:19 | GEMI | GEMI270115P00005000 | put | 5.0000 | 2027-01-15 | 1.2000 | 1.1500 | 1.2500 | 4.8350 | 31080.00 | 30360.00 | 0.00 | 259 | 12 | 1361 | 3713 | 0.3665499596014 | 1.02848580820736 | 1.02848580820736 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | Financial Services | 262267261.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 65ff0ece-027b-4aca-af92-f3a23fb2dfc0 | 2026-09-14 15:14 | 2026-09-14 15:13 | 2026-09-14 15:13 | GEMI | GEMI270115P00005000 | put | 5.0000 | 2027-01-15 | 1.2000 | 1.1500 | 1.2500 | 4.8400 | 71160.00 | 70560.00 | 0.00 | 593 | 8 | 1102 | 3713 | 0.296795044438459 | 1.03031553770192 | 1.03031553770192 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | Financial Services | 262267261.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b4ed436f-325b-4ba9-8a57-c714220409b5 | 2026-09-14 13:28 | 2026-09-14 13:28 | 2026-09-14 13:28 | GEMI | GEMI270115P00005000 | put | 5.0000 | 2027-01-15 | 1.2000 | 1.1500 | 1.2500 | 4.7950 | 54960.00 | 54120.00 | 720.00 | 458 | 17 | 509 | 3713 | 0.137085914354969 | 1.01366815407406 | 1.01366815407406 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | Financial Services | 262267261.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8272126b-5f5a-47b9-8bfc-34ab3c786554 | 2026-09-11 12:13 | 2026-09-11 12:13 | 2026-09-11 12:13 | GEMI | GEMI270115P00005000 | put | 5.0000 | 2027-01-15 | 1.2800 | 1.2500 | 1.3500 | 4.5650 | 12796.00 | 0.00 | 12796.00 | 100 | 10 | 100 | 3619 | 0.0276319425255595 | 1.00116798248647 | 1.00116798248647 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | Financial Services | 262267261.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T16:20:29.379987Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 84b689d5-2905-49c1-a739-9ea4bb705c1e | 2026-09-04 15:30 | 2026-09-04 15:30 | 2026-09-04 15:30 | GEMI | GEMI270115P00005000 | put | 5.0000 | 2027-01-15 | 1.3000 | 1.2500 | 1.3500 | 4.7000 | 13780.00 | 1950.00 | 11830.00 | 106 | 8 | 266 | 3397 | 0.0783043862231381 | 1.03656052986737 | 1.03656052986737 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | Financial Services | 262267261.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T19:47:04.296573Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 91c49a68-d8e5-4a94-ab9b-551d50a3dc9f | 2026-08-27 10:42 | 2026-08-27 10:42 | 2026-08-27 10:42 | GEMI | GEMI270115C00005000 | call | 5.0000 | 2027-01-15 | 1.2500 | 1.2000 | 1.3000 | 4.9550 | 11375.00 | 4500.00 | 0.00 | 91 | 5 | 165 | 2867 | 0.0575514475061039 | 1.03592530770716 | 1.0251188480409 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | Financial Services | 262267261.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T14:49:52.356548Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 28f6b0cd-d6dc-4775-a65a-f40c4e59c3d8 | 2026-08-20 09:53 | 2026-08-20 09:53 | 2026-08-20 09:53 | GEMI | GEMI260821C00004000 | call | 4.0000 | 2026-08-21 | 0.1900 | 0.1500 | 0.2500 | 4.1200 | 10547.00 | 0.00 | 8407.00 | 543 | 16 | 906 | 3706 | 0.244468429573664 | 1.17396708778888 | 1.29098310632392 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | Financial Services | 262267261.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c5608545-0254-4eab-bed8-f365b1d0dc47 | 2026-08-19 15:14 | 2026-08-19 15:14 | 2026-08-19 15:14 | GEMI | GEMI260821C00004000 | call | 4.0000 | 2026-08-21 | 0.1500 | 0.1000 | 0.2000 | 3.8850 | 15000.00 | 6045.00 | 8955.00 | 1000 | 5 | 4503 | 533 | 8.4484052532833 | 1.73625975737586 | 1.73625975737586 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | Financial Services | 262267261.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 99a6b5a0-2502-4278-9f53-c0e16a78e02a | 2026-08-19 13:36 | 2026-08-19 13:36 | 2026-08-19 13:36 | GEMI | GEMI280121C00022500 | call | 22.5000 | 2028-01-21 | 0.4000 | 0.4000 | 0.7000 | 3.8100 | 12000.00 | 0.00 | 12000.00 | 300 | 9 | 300 | 1627 | 0.184388444990781 | 1.06081141864627 | 1.06081141864627 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | Financial Services | 262267261.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1995c264-4243-48d5-bc08-32ca52d2a65c | 2026-08-17 09:41 | 2026-08-17 09:41 | 2026-08-17 09:41 | GEMI | GEMI280121C00005000 | call | 5.0000 | 2028-01-21 | 1.3500 | 1.3500 | 1.6000 | 3.5800 | 135000.00 | 0.00 | 135000.00 | 1000 | 35 | 1003 | 929 | 1.07965554359526 | 1.00399477923062 | 1.00399477923062 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | Financial Services | 262267261.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |