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.
uw_flow_alerts523,327 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 | expiry |
|---|
| 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 |
|---|
| 48af0d17-3815-4344-8a83-00803989399a | 2026-09-24 13:01 | 2026-09-24 13:01 | 2026-09-24 13:01 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 0.5000 | 0.4900 | 0.5000 | 41.3100 | 14450.00 | 14450.00 | 0.00 | 289 | 18 | 751 | 2330 | 0.322317596566524 | 0.711499396240713 | 0.711499396240713 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 27224645513.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T17:03:43.722265Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| c177eb92-8e37-415c-847d-0680026b44bf | 2026-09-23 15:48 | 2026-09-23 15:48 | 2026-09-23 15:48 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 0.5600 | 0.5600 | 0.5700 | 41.3894 | 18536.00 | 0.00 | 18536.00 | 331 | 15 | 657 | 2269 | 0.289554869986778 | 0.713032042695041 | 0.713032042695041 | false | false | false | true | ||||||||||||||||
| e8966edd-4269-4127-a348-d2cc52913ce9 | 2026-09-18 10:19 | 2026-09-18 10:19 | 2026-09-18 10:19 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 1.6800 | 1.6200 | 1.7000 | 38.6000 | 12936.00 | 12936.00 | 0.00 | 77 | 5 | 2979 | 3996 | 0.745495495495496 | 0.66654956226628 | 0.66654956226628 | false | false | false | true | ||||||||||||||||
| 82a19222-5b50-410d-9b3a-f68a085834c7 | 2026-09-18 09:46 | 2026-09-18 09:46 | 2026-09-18 09:46 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 1.3800 | 1.3200 | 1.3800 | 39.4400 | 23736.00 | 23736.00 | 0.00 | 172 | 6 | 1840 | 3996 | 0.46046046046046 | 0.682295892295208 | 0.676099688631044 | false | false | false | true | ||||||||||||||||
| dc595e56-8629-43c2-80c7-bf4fde22b0da | 2026-09-18 09:45 | 2026-09-18 09:45 | 2026-09-18 09:45 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 1.4000 | 1.3400 | 1.4400 | 39.3400 | 14000.00 | 14000.00 | 0.00 | 100 | 6 | 1668 | 3996 | 0.417417417417417 | 0.672986208670345 | 0.67046195517721 | false | false | false | true | ||||||||||||||||
| ad851a7e-d983-45a3-859c-81e9c61d586d | 2026-09-17 12:54 | 2026-09-17 12:54 | 2026-09-17 12:54 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 1.1300 | 1.1200 | 1.1600 | 40.9100 | 11300.00 | 2712.00 | 5198.00 | 100 | 8 | 3487 | 636 | 5.48270440251572 | 0.72842925399851 | 0.72842925399851 | false | false | false | true | ||||||||||||||||
| 84f9bdcb-ced8-4ced-8857-28ce82f38a4c | 2026-09-17 12:44 | 2026-09-17 12:44 | 2026-09-17 12:44 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 1.1200 | 1.1000 | 1.1700 | 40.9500 | 11200.00 | 0.00 | 8736.00 | 100 | 9 | 3382 | 636 | 5.31761006289308 | 0.726840747674507 | 0.728836513597382 | false | false | false | true | ||||||||||||||||
| 2d5e33ef-9922-4eaa-8991-c8c2b1e10f2c | 2026-09-17 12:38 | 2026-09-17 12:38 | 2026-09-17 12:38 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 1.1800 | 1.1600 | 1.1900 | 40.6500 | 11800.00 | 8142.00 | 1298.00 | 100 | 6 | 3172 | 636 | 4.9874213836478 | 0.71770372671292 | 0.71977124587999 | false | false | false | true | ||||||||||||||||
| 12f191e4-46a9-4300-9e7d-77e764e48d7e | 2026-09-17 12:38 | 2026-09-17 12:38 | 2026-09-17 12:38 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 1.1900 | 1.1800 | 1.1950 | 40.6000 | 11900.00 | 11900.00 | 0.00 | 100 | 8 | 3072 | 636 | 4.83018867924528 | 0.718117804645753 | 0.718117804645753 | false | false | false | true | ||||||||||||||||
| a980a18f-b190-4a94-84b5-0e7ee309c989 | 2026-09-17 12:37 | 2026-09-17 12:37 | 2026-09-17 12:37 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 1.1800 | 1.1600 | 1.2100 | 40.6380 | 24780.00 | 10148.00 | 8732.00 | 210 | 7 | 2972 | 636 | 4.67295597484277 | 0.719254733103409 | 0.718531204509715 | false | false | false | true | ||||||||||||||||
| 64f04af3-42ca-476b-b7fe-300067e1cfcc | 2026-09-17 11:42 | 2026-09-17 11:42 | 2026-09-17 11:42 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 1.2700 | 1.2500 | 1.3000 | 40.4000 | 16383.00 | 6350.00 | 10033.00 | 129 | 8 | 2604 | 636 | 4.09433962264151 | 0.724462225060675 | 0.72499695066001 | false | false | false | true | ||||||||||||||||
| 7a00ccd4-7744-4085-9946-7899fd689b2b | 2026-09-17 11:06 | 2026-09-17 11:06 | 2026-09-17 11:06 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 1.2000 | 1.1800 | 1.2700 | 40.9300 | 12120.00 | 7800.00 | 4320.00 | 101 | 5 | 2239 | 636 | 3.52044025157233 | 0.755442251760447 | 0.755442251760447 | false | false | false | true | ||||||||||||||||
| e5ce9c8a-66ac-4c9c-a19d-61d3dd53ac31 | 2026-09-17 10:57 | 2026-09-17 10:57 | 2026-09-17 10:57 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 1.2000 | 1.1800 | 1.2900 | 40.9600 | 12000.00 | 7800.00 | 4200.00 | 100 | 5 | 2035 | 636 | 3.19968553459119 | 0.756450913001782 | 0.758465556018873 | false | false | false | true | ||||||||||||||||
| 8b571ca5-ef51-4d52-9fb5-73cfb1f1d79d | 2026-09-17 10:44 | 2026-09-17 10:44 | 2026-09-17 10:44 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 1.3500 | 1.3000 | 1.3600 | 40.3350 | 16690.00 | 11290.00 | 5400.00 | 124 | 5 | 1430 | 636 | 2.24842767295597 | 0.745096311485348 | 0.742196444112344 | false | false | false | true | ||||||||||||||||
| 6a0f8a75-155b-44b9-8be1-fff24cda76da | 2026-09-17 10:31 | 2026-09-17 10:31 | 2026-09-17 10:31 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 1.5000 | 1.4500 | 1.5000 | 39.6950 | 15000.00 | 15000.00 | 0.00 | 100 | 7 | 927 | 636 | 1.45754716981132 | 0.724226195546917 | 0.724226195546917 | false | false | false | true | ||||||||||||||||
| c0bcc5d6-cec9-4cd4-ba38-161602269d42 | 2026-09-10 14:42 | 2026-09-10 14:42 | 2026-09-10 14:42 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 2.5100 | 2.5000 | 2.5800 | 37.9950 | 23092.00 | 0.00 | 23092.00 | 92 | 5 | 205 | 409 | 0.501222493887531 | 0.687023762647025 | 0.687023762647025 | true | false | false | true | ||||||||||||||||
| dea97ad2-f035-4c86-9cd5-b7d13e3cf9e6 | 2026-08-17 13:52 | 2026-08-17 13:52 | 2026-08-17 13:52 | SMCI | SMCI261002P00038000 | put | 38.0000 | 2026-10-02 | 4.0000 | 3.7000 | 4.0000 | 37.0000 | 80000.00 | 80000.00 | 0.00 | 200 | 9 | 220 | 11 | 20 | 0.75798654222837 | 0.75798654222837 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 27224645513.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:51:14.662813Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 25680776861.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 25680776861.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:50:28.178058Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 25680776861.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:50:28.178058Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 26508553244.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 26508553244.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 26508553244.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 26508553244.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 26508553244.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 26508553244.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 26508553244.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 26508553244.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:02:25.509626Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 26508553244.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:48:09.438351Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 26508553244.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 24136908208.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 24136908208.00 |
| 2026-11-03 |
| 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 |