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_alerts609,118 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 |
|---|
| 72d14547-f3a5-43e4-811e-bbf263c3bdf3 | 2026-09-30 13:31 | 2026-09-30 13:31 | 2026-09-30 13:31 | PLTR | PLTR261002P00187500 | put | 187.5000 | 2026-10-02 | 2.6100 | 2.5700 | 2.6100 | 187.8700 | 13050.00 | 13050.00 | 0.00 | 50 | 5 | 5659 | 1606 | 3.52366127023661 | 0.507247566622478 | 0.507247566622478 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 430164371123.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T17:35:36.166637Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| 3f870a57-3b5c-4073-a794-97ade56e50f3 | 2026-09-30 10:39 | 2026-09-30 10:39 | 2026-09-30 10:39 | PLTR | PLTR261002P00187500 | put | 187.5000 | 2026-10-02 | 2.0600 | 2.0100 | 2.0600 | 189.4621 | 20555.00 | 20555.00 | 0.00 | 100 | 7 | 3330 | 1606 | 2.07347447073474 | 0.530874192543242 | 0.529009784807893 | false | false | false | true | ||||||||||||||||
| a0b965e3-1e39-4ea2-8917-501e71f5c819 | 2026-09-30 10:21 | 2026-09-30 10:21 | 2026-09-30 10:21 | PLTR | PLTR261002P00187500 | put | 187.5000 | 2026-10-02 | 2.0300 | 1.9900 | 2.0400 | 189.4950 | 84552.00 | 84552.00 | 0.00 | 416 | 18 | 2704 | 1606 | 1.68368617683686 | 0.529505382482045 | 0.529505382482045 | false | false | false | true | ||||||||||||||||
| 2b38393d-d1d8-4eb2-b242-8e9923368d8e | 2026-09-30 10:13 | 2026-09-30 10:13 | 2026-09-30 10:13 | PLTR | PLTR261002P00187500 | put | 187.5000 | 2026-10-02 | 2.3600 | 2.3500 | 2.4300 | 188.0000 | 24966.00 | 1200.00 | 23528.00 | 106 | 29 | 1831 | 1606 | 1.140099626401 | 0.526088647014778 | 0.526618303585888 | false | false | false | true | ||||||||||||||||
| 961146a0-f99e-4478-8ff2-b1fb9d0dea90 | 2026-09-29 11:28 | 2026-09-29 11:28 | 2026-09-29 11:28 | PLTR | PLTR261002P00187500 | put | 187.5000 | 2026-10-02 | 4.3500 | 4.3500 | 4.4500 | 185.9200 | 20010.00 | 0.00 | 20010.00 | 46 | 12 | 2408 | 1364 | 1.76539589442815 | 0.524277044324239 | 0.524277044324239 | false | false | false | true | ||||||||||||||||
| 4f0dddb8-1f2c-44f4-90fa-7f3a4eb744f6 | 2026-09-29 09:54 | 2026-09-29 09:54 | 2026-09-29 09:54 | PLTR | PLTR261002P00187500 | put | 187.5000 | 2026-10-02 | 4.1000 | 4.0500 | 4.2000 | 186.5700 | 28700.00 | 0.00 | 26650.00 | 70 | 18 | 1565 | 1364 | 1.14736070381232 | 0.53967051277214 | 0.53967051277214 | false | false | false | true | ||||||||||||||||
| fc23b61b-91c4-4be3-8e52-edcb32fece61 | 2026-09-29 09:44 | 2026-09-29 09:44 | 2026-09-29 09:44 | PLTR | PLTR261002P00187500 | put | 187.5000 | 2026-10-02 | 4.9500 | 4.9000 | 5.0500 | 185.2100 | 296994.00 | 293529.00 | 3465.00 | 600 | 43 | 1236 | 1364 | 0.906158357771261 | 0.557236040056486 | 0.553676152886039 | false | false | false | true | ||||||||||||||||
| e858af4c-aa31-4aaa-a239-b8d58bc4c095 | 2026-09-29 09:43 | 2026-09-29 09:43 | 2026-09-29 09:43 | PLTR | PLTR261002P00187500 | put | 187.5000 | 2026-10-02 | 5.0600 | 5.0500 | 5.1000 | 184.9100 | 25282.00 | 0.00 | 25282.00 | 50 | 7 | 587 | 1364 | 0.430351906158358 | 0.543295667652762 | 0.54485721898626 | false | false | false | true | ||||||||||||||||
| 78c5f785-c0bb-4a34-9416-0579ac86949e | 2026-09-28 10:30 | 2026-09-28 10:30 | 2026-09-28 10:30 | PLTR | PLTR261002P00187500 | put | 187.5000 | 2026-10-02 | 4.1200 | 4.0500 | 4.1500 | 187.0000 | 30880.00 | 30880.00 | 0.00 | 75 | 6 | 1846 | 1352 | 1.36538461538462 | 0.534047325981447 | 0.534047325981447 | false | false | false | true | ||||||||||||||||
| 30cc03fc-df62-45fb-9e7f-9294b7f25dc6 | 2026-09-25 10:40 | 2026-09-25 10:40 | 2026-09-25 10:40 | PLTR | PLTR261002P00187500 | put | 187.5000 | 2026-10-02 | 3.3000 | 3.2000 | 3.3000 | 190.8100 | 33000.00 | 33000.00 | 0.00 | 100 | 5 | 1256 | 1038 | 1.21001926782274 | 0.46263544870315 | 0.46263544870315 | false | false | false | true | ||||||||||||||||
| b57ffca9-3e2a-4880-a1a7-f2f739cb6a9d | 2026-09-25 10:03 | 2026-09-25 10:03 | 2026-09-25 10:03 | PLTR | PLTR261002P00187500 | put | 187.5000 | 2026-10-02 | 2.9400 | 2.8700 | 2.9600 | 191.9100 | 43805.00 | 43217.00 | 588.00 | 149 | 16 | 915 | 1038 | 0.88150289017341 | 0.466174626940939 | 0.466174626940939 | true | false | false | true | ||||||||||||||||
| 851ea25c-7bdc-49f1-96cc-4ddcb0690226 | 2026-09-25 09:40 | 2026-09-25 09:40 | 2026-09-25 09:40 | PLTR | PLTR261002P00187500 | put | 187.5000 | 2026-10-02 | 2.7000 | 2.7000 | 2.8000 | 193.0050 | 29160.00 | 0.00 | 29160.00 | 108 | 7 | 260 | 1038 | 0.250481695568401 | 0.47863803296025 | 0.47863803296025 | false | false | false | true | ||||||||||||||||
| c0f0bf22-764a-4752-8ebe-2c10942f145e | 2026-09-23 09:42 | 2026-09-23 09:42 | 2026-09-23 09:42 | PLTR | PLTR261002P00187500 | put | 187.5000 | 2026-10-02 | 4.3000 | 4.1000 | 4.3000 | 191.7086 | 11180.00 | 11180.00 | 0.00 | 26 | 7 | 51 | 145 | 0.351724137931034 | 0.526800115341677 | 0.526800115341677 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 430164371123.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:42:27.796047Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 430164371123.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:23:56.441043Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 430164371123.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:14:21.800901Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 430164371123.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:29:51.337369Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 430164371123.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:56:35.860979Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 430164371123.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:46:07.678707Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 430164371123.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:44:04.459232Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 431337734921.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:31:22.759072Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 436376297111.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:43:48.295772Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 436376297111.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:04:05.801469Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 436376297111.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:41:37.814256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 441253809369.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |