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_alerts658,639 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 |
|---|
| 4bcba1f4-944d-4944-9b50-1532cc608b91 | 2026-09-14 11:17 | 2026-09-14 11:17 | 2026-09-14 11:17 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 0.3000 | 0.1500 | 0.6000 | 79.7200 | 57840.00 | 0.00 | 57840.00 | 1928 | 2 | 2174 | 6367 | 0.341448091722946 | 0.848199894418865 | 0.848199894418865 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Technology | 3521978898.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a15a40eb-2864-4806-9cee-12094e48a4ca | 2026-09-03 10:43 | 2026-09-03 10:43 | 2026-09-03 10:43 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 1.3000 | 1.3000 | 1.5000 | 81.6750 | 95550.00 | 0.00 | 95550.00 | 735 | 47 | 736 | 4147 | 0.177477694719074 | 0.603040047421306 | 0.603040047421306 | false | false | false | true | false | |||||||||||||||
| 44259e24-22d6-4c9b-9ec3-bf9deb6d373f | 2026-09-01 10:33 | 2026-09-01 10:33 | 2026-09-01 10:33 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 2.0000 | 2.0000 | 2.0500 | 83.6400 | 16400.00 | 0.00 | 1600.00 | 82 | 16 | 611 | 3555 | 0.171870604781997 | 0.593434152982011 | 0.593434152982011 | false | false | false | true | false | |||||||||||||||
| a2e900c0-3c19-4ab8-994b-1cf71543a50b | 2026-09-01 10:32 | 2026-09-01 10:32 | 2026-09-01 10:32 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 1.9000 | 1.9000 | 2.0500 | 83.6000 | 10070.00 | 0.00 | 10070.00 | 53 | 10 | 529 | 3555 | 0.148804500703235 | 0.579603091486438 | 0.579603091486438 | false | false | false | true | false | |||||||||||||||
| b4fc8e0f-ab50-4764-a56b-39ac8d5cd3bd | 2026-09-01 10:32 | 2026-09-01 10:31 | 2026-09-01 10:31 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 1.9000 | 1.9000 | 2.0500 | 83.6000 | 11020.00 | 0.00 | 11020.00 | 58 | 13 | 476 | 3555 | 0.133895921237693 | 0.579603091486438 | 0.579603091486438 | false | false | false | true | false | |||||||||||||||
| 0b3a8c16-56dd-40b9-97aa-2724b664cea8 | 2026-09-01 10:31 | 2026-09-01 10:31 | 2026-09-01 10:31 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 1.9000 | 1.9000 | 2.1000 | 83.7200 | 23180.00 | 0.00 | 23180.00 | 122 | 21 | 418 | 3555 | 0.117580872011252 | 0.573817557469136 | 0.573817557469136 | false | false | false | true | false | |||||||||||||||
| 0722856d-1848-4320-82b9-02b01f3b1102 | 2026-09-01 10:28 | 2026-09-01 10:28 | 2026-09-01 10:28 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 1.8000 | 1.8000 | 2.0000 | 83.0800 | 23580.00 | 0.00 | 900.00 | 131 | 22 | 296 | 3555 | 0.0832630098452883 | 0.588350935703995 | 0.588350935703995 | false | false | false | true | false | |||||||||||||||
| da3f6b8c-f565-4cb0-9acf-630d07bb27a5 | 2026-09-01 10:28 | 2026-09-01 10:28 | 2026-09-01 10:28 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 1.6500 | 1.6500 | 1.8500 | 82.6400 | 15675.00 | 0.00 | 1485.00 | 95 | 14 | 96 | 3555 | 0.0270042194092827 | 0.584079710887481 | 0.584079710887481 | false | false | false | true | false | |||||||||||||||
| c471b47f-584d-4f54-be8d-fee1afc69a60 | 2026-09-01 10:28 | 2026-09-01 10:28 | 2026-09-01 10:28 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 1.6500 | 1.6500 | 1.8000 | 82.6400 | 11385.00 | 0.00 | 11385.00 | 69 | 12 | 165 | 3555 | 0.0464135021097046 | 0.584079710887481 | 0.584079710887481 | false | false | false | true | false | |||||||||||||||
| ef9d6077-2fc9-4cd7-bde7-71ea19521b0c | 2026-08-31 11:47 | 2026-08-31 11:47 | 2026-08-31 11:47 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 1.6000 | 1.6000 | 1.7000 | 83.0000 | 31840.00 | 0.00 | 7680.00 | 199 | 62 | 853 | 3002 | 0.284143904063957 | 0.546119735835751 | 0.542987276844064 | false | false | false | true | false | |||||||||||||||
| 5da4760f-0ae3-4df7-a169-f5a87b31e433 | 2026-08-31 11:45 | 2026-08-31 11:45 | 2026-08-31 11:45 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 1.3000 | 1.3000 | 1.4500 | 82.5850 | 15600.00 | 0.00 | 1430.00 | 120 | 37 | 442 | 3002 | 0.147235176548967 | 0.510949981041607 | 0.510949981041607 | false | false | false | true | false | |||||||||||||||
| 4120089b-8f18-4792-b278-b4e180f7b886 | 2026-08-31 11:44 | 2026-08-31 11:44 | 2026-08-31 11:44 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 1.2500 | 1.2500 | 1.3000 | 82.5750 | 13125.00 | 0.00 | 625.00 | 105 | 33 | 296 | 3002 | 0.0986009327115256 | 0.502693437095152 | 0.502693437095152 | false | false | false | true | false | |||||||||||||||
| caf22b34-d34c-4f8f-84c8-df61728f21fc | 2026-08-31 11:44 | 2026-08-31 11:44 | 2026-08-31 11:44 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 1.1500 | 1.1500 | 1.2000 | 82.2700 | 14260.00 | 0.00 | 8050.00 | 124 | 40 | 135 | 3002 | 0.0449700199866755 | 0.497718863789095 | 0.497718863789095 | true | false | false | true | false | |||||||||||||||
| 9fa3e8d0-695b-4fb9-8499-f0ab057a7c42 | 2026-08-26 10:00 | 2026-08-26 10:00 | 2026-08-26 10:00 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 4.3000 | 4.3000 | 4.5000 | 89.5175 | 18490.00 | 0.00 | 18490.00 | 43 | 18 | 47 | 3020 | 0.0155629139072848 | 0.494031296268784 | 0.494031296268784 | false | false | false | true | false | |||||||||||||||
| b56a0a73-3c4c-40f7-ab5b-87a4ff827011 | 2026-08-25 15:24 | 2026-08-25 15:24 | 2026-08-25 15:24 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 3.6900 | 3.3500 | 5.0000 | 88.3600 | 227880.00 | 80290.00 | 147590.00 | 617 | 29 | 1194 | 1908 | 0.625786163522013 | 0.480095626296838 | 0.480095626296838 | true | false | false | true | ||||||||||||||||
| 4e7e4032-c491-4295-806d-601e74bd3615 | 2026-08-25 09:45 | 2026-08-25 09:45 | 2026-08-25 09:45 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 2.4000 | 2.4000 | 2.6000 | 85.3600 | 47760.00 | 0.00 | 47760.00 | 199 | 33 | 515 | 1908 | 0.269916142557652 | 0.474581995051349 | 0.474581995051349 | true | false | false | true | false | |||||||||||||||
| 3c57dccf-81a3-44aa-b989-fcc3c32a11ab | 2026-08-25 09:45 | 2026-08-25 09:45 | 2026-08-25 09:45 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 2.4000 | 2.4000 | 2.6000 | 85.3600 | 16800.00 | 0.00 | 16800.00 | 70 | 14 | 316 | 1908 | 0.165618448637317 | 0.474581995051349 | 0.474581995051349 | true | false | false | true | false | |||||||||||||||
| d3d74808-8363-448c-a0e9-b4d36f0eb147 | 2026-08-25 09:45 | 2026-08-25 09:44 | 2026-08-25 09:44 | OLED | OLED260918C00090000 | call | 90.0000 | 2026-09-18 | 2.2000 | 2.2000 | 2.4000 | 84.9300 | 40920.00 | 0.00 | 23320.00 | 186 | 29 | 246 | 1908 | 0.128930817610063 | 0.468632434335969 | 0.468632434335969 | false | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T19:47:14.629482Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |