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_alerts474,253 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 | strike |
|---|
| 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 |
|---|
| c7e66a24-4e07-4eda-b0e8-5b516afd3de4 | 2026-09-25 09:47 | 2026-09-25 09:47 | 2026-09-25 09:47 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 0.2200 | 0.1300 | 0.2300 | 757.7800 | 11682.00 | 1408.00 | 10274.00 | 531 | 49 | 1412 | 3259 | 0.433261736729058 | 0.826412031610559 | 0.838651123756744 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1657506895075.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T13:50:07.736084Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| b9d1bafb-40aa-4a64-8547-0bd96274e427 | 2026-09-24 15:31 | 2026-09-24 15:31 | 2026-09-24 15:31 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 0.2900 | 0.2400 | 0.2900 | 777.5400 | 12267.00 | 12267.00 | 0.00 | 423 | 41 | 8653 | 808 | 10.7091584158416 | 0.669399438582539 | 0.669399438582539 | false | false | false | |||||||||||||||||
| 8bb0ac48-62c6-4c4a-8b96-7f962fec49cb | 2026-09-24 12:11 | 2026-09-24 12:11 | 2026-09-24 12:11 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 1.2000 | 1.2000 | 1.2600 | 762.0000 | 13202.00 | 0.00 | 13202.00 | 110 | 19 | 7656 | 808 | 9.47524752475248 | 0.683964033711206 | 0.680967624101387 | false | false | false | |||||||||||||||||
| e76d7a94-6bdf-4bf5-ac71-294389a57a7b | 2026-09-24 10:42 | 2026-09-24 10:42 | 2026-09-24 10:42 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 1.1700 | 1.1100 | 1.1900 | 766.8400 | 51714.00 | 9945.00 | 29601.00 | 442 | 28 | 5801 | 808 | 7.17945544554455 | 0.743011744209924 | 0.743011744209924 | true | false | false | |||||||||||||||||
| 8d66e6e9-b888-4fb2-9de6-d02b4daba58e | 2026-09-24 10:36 | 2026-09-24 10:36 | 2026-09-24 10:36 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 1.3100 | 1.2500 | 1.3200 | 765.1700 | 56330.00 | 21484.00 | 19650.00 | 430 | 32 | 4739 | 808 | 5.86509900990099 | 0.741769706948251 | 0.741769706948251 | true | false | false | |||||||||||||||||
| 7d587b94-e41c-40e7-b011-cff06eddad70 | 2026-09-24 09:41 | 2026-09-24 09:41 | 2026-09-24 09:41 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 1.9300 | 1.8100 | 1.9700 | 762.3300 | 157488.00 | 157488.00 | 0.00 | 816 | 38 | 1002 | 808 | 1.24009900990099 | 0.786154459438991 | 0.78433979255561 | true | false | false | |||||||||||||||||
| 1d51e53a-ed5a-45df-ac56-4ceeeae2c1fc | 2026-09-23 15:39 | 2026-09-23 15:38 | 2026-09-23 15:38 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 7.2500 | 7.2500 | 7.4000 | 748.6100 | 26100.00 | 0.00 | 26100.00 | 36 | 12 | 776 | 633 | 1.2259083728278 | 0.717652240706082 | 0.717652240706082 | true | false | false | |||||||||||||||||
| f0f05eaf-ffa3-42e6-95dd-b062b99a22fb | 2026-09-21 15:58 | 2026-09-21 15:58 | 2026-09-21 15:58 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 11.7500 | 11.6500 | 11.7500 | 743.1250 | 14100.00 | 14100.00 | 0.00 | 12 | 12 | 1944 | 3 | 648 | 0.60745914413165 | 0.60745914413165 | false | false | false | |||||||||||||||||
| c6075ecf-d688-4e5d-b6cd-637cf59eb98d | 2026-09-21 15:54 | 2026-09-21 15:54 | 2026-09-21 15:54 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 10.9000 | 10.7500 | 10.9000 | 745.0000 | 25070.00 | 25070.00 | 0.00 | 23 | 10 | 1907 | 3 | 635.666666666667 | 0.610654486020375 | 0.610654486020375 | true | false | false | |||||||||||||||||
| 1142a166-64d7-4a97-9ef8-b28a0b04575d | 2026-09-21 15:48 | 2026-09-21 15:48 | 2026-09-21 15:48 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 10.0500 | 10.0500 | 10.2000 | 748.0000 | 12060.00 | 0.00 | 12060.00 | 12 | 6 | 1877 | 3 | 625.666666666667 | 0.610292064216385 | 0.610292064216385 | false | false | false | |||||||||||||||||
| 85c5a910-6092-4af0-a492-3012ba71a13c | 2026-09-21 15:15 | 2026-09-21 15:15 | 2026-09-21 15:15 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 10.5500 | 10.5500 | 10.7000 | 745.1650 | 30595.00 | 0.00 | 30595.00 | 29 | 12 | 1672 | 3 | 557.333333333333 | 0.590156095169879 | 0.590156095169879 | true | false | false | |||||||||||||||||
| ffc21af8-dd12-4d1d-bca1-2860c8ffcb91 | 2026-09-21 13:16 | 2026-09-21 13:16 | 2026-09-21 13:16 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 14.3000 | 14.1000 | 14.3000 | 734.0000 | 30027.00 | 30027.00 | 0.00 | 21 | 8 | 1134 | 3 | 378 | 0.579053426702267 | 0.579053426702267 | true | false | false | |||||||||||||||||
| 92f64031-100d-4e3c-9a27-00f710a7c6b1 | 2026-09-21 13:12 | 2026-09-21 13:12 | 2026-09-21 13:12 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 14.3000 | 14.3000 | 14.4500 | 734.6259 | 12870.00 | 0.00 | 12870.00 | 9 | 6 | 1102 | 3 | 367.333333333333 | 0.582365838980334 | 0.582365838980334 | true | false | false | |||||||||||||||||
| 455c24d8-163e-47ee-8c75-073040ea9258 | 2026-09-21 12:59 | 2026-09-21 12:59 | 2026-09-21 12:59 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 16.2500 | 16.1500 | 16.2500 | 728.7800 | 16250.00 | 16250.00 | 0.00 | 10 | 10 | 956 | 3 | 318.666666666667 | 0.560433470977876 | 0.560433470977876 | false | false | false | |||||||||||||||||
| 6e18905c-3969-4f52-8067-4eb61f97c7d7 | 2026-09-21 12:57 | 2026-09-21 12:57 | 2026-09-21 12:57 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 16.5000 | 16.4500 | 16.6250 | 727.8500 | 42900.00 | 3300.00 | 39600.00 | 26 | 7 | 932 | 3 | 310.666666666667 | 0.550216962659152 | 0.554035151640545 | false | false | false | |||||||||||||||||
| b91e2d3e-d72b-49bd-ad5a-d31cc2aaaae7 | 2026-09-21 12:12 | 2026-09-21 12:11 | 2026-09-21 12:11 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 18.0000 | 18.0000 | 18.2000 | 724.6450 | 72000.00 | 0.00 | 72000.00 | 40 | 16 | 334 | 3 | 111.333333333333 | 0.550932947235859 | 0.550932947235859 | false | false | false | |||||||||||||||||
| 40573214-de4b-4b0e-80e3-8e129f22c930 | 2026-09-21 11:37 | 2026-09-21 11:37 | 2026-09-21 11:37 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 22.4000 | 22.4000 | 22.6500 | 715.0000 | 29120.00 | 0.00 | 29120.00 | 13 | 5 | 271 | 3 | 90.3333333333333 | 0.530518331708119 | 0.531713975610177 | false | false | false | |||||||||||||||||
| 487b410b-1b53-4246-ae2f-54b15a82167e | 2026-09-21 11:31 | 2026-09-21 11:31 | 2026-09-21 11:31 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 23.9000 | 23.9000 | 24.1500 | 712.9900 | 35850.00 | 0.00 | 35850.00 | 15 | 9 | 258 | 3 | 86 | 0.524550320321312 | 0.525444413294819 | false | false | false | |||||||||||||||||
| 86506cef-a469-4e6e-84a9-2308013acbff | 2026-09-21 10:16 | 2026-09-21 10:16 | 2026-09-21 10:16 | META | META260925P00727500 | put | 727.5000 | 2026-09-25 | 23.2500 | 23.2500 | 23.5000 | 714.0000 | 51150.00 | 0.00 | 51150.00 | 22 | 9 | 215 | 3 | 71.6666666666667 | 0.54215882885389 | 0.54215882885389 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:37:02.882742Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:13:55.044964Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:44:10.025245Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:39:59.397883Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:42:52.039375Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:42:45.926021Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:50:07.722851Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:20:55.206028Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:16:02.178873Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:02:00.389820Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:02:00.389820Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:13:06.153982Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:39:42.073830Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:32:21.239106Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:16:37.999315Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |