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_alerts326,449 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 |
|---|
| 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 |
|---|
| 37803f82-d312-418e-a511-2fb83d84feb0 | 2026-08-18 09:31 | 2026-08-18 09:31 | 2026-08-18 09:31 | WDC | WDC260828P00430000 | put | 430.0000 | 2026-08-28 | 4.7300 | 3.2500 | 4.9000 | 515.3050 | 238197.00 | 238197.00 | 0.00 | 504 | 23 | 1008 | 89 | 11.3258426966292 | 0.977175392942173 | 0.945180073796166 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 153929350631.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ea6efd7c-17b5-4573-b173-2d293964c871 | 2026-08-18 09:31 | 2026-08-18 09:31 | 2026-08-18 09:31 | WDC | WDC260828P00430000 | put | 430.0000 | 2026-08-28 | 4.2100 | 3.2500 | 4.9000 | 515.0100 | 106127.00 | 106127.00 | 0.00 | 252 | 5 | 504 | 89 | 5.66292134831461 | 0.925169813345412 | 0.925169813345412 | false | false | false | true | ||||||||||||||||
| b4fa71d5-970d-4e95-9366-34baabe8578c | 2026-08-17 15:00 | 2026-08-17 15:00 | 2026-08-17 15:00 | WDC | WDC270115C00720000 | call | 720.0000 | 2027-01-15 | 53.9900 | 49.6000 | 54.0000 | 533.1000 | 102583.00 | 102583.00 | 0.00 | 19 | 13 | 302 | 200 | 1.51 | 0.780098324182022 | 0.779714124680463 | false | false | false | true | false | |||||||||||||||
| 602b23b2-1a8a-4c55-a628-4ca19c492052 | 2026-08-17 13:18 | 2026-08-17 13:18 | 2026-08-17 13:18 | WDC | WDC270319C00770000 | call | 770.0000 | 2027-03-19 | 66.1100 | 64.5000 | 66.7000 | 531.1700 | 112390.00 | 79565.00 | 32825.00 | 17 | 5 | 19 | 83 | 0.228915662650602 | 0.794976216898597 | 0.795295561706639 | false | false | false | true | ||||||||||||||||
| 4233862a-ee2c-459c-9223-501cd5a16048 | 2026-08-17 12:10 | 2026-08-17 12:10 | 2026-08-17 12:10 | WDC | WDC260821C00540000 | call | 540.0000 | 2026-08-21 | 18.9000 | 17.6500 | 18.9000 | 537.2650 | 113398.00 | 113398.00 | 0.00 | 60 | 6 | 518 | 340 | 1.52352941176471 | 0.895401485722714 | 0.895401485722714 | false | false | false | true | ||||||||||||||||
| 0800da57-b2d7-4c54-ac11-80c048522bc5 | 2026-08-17 11:26 | 2026-08-17 11:26 | 2026-08-17 11:26 | WDC | WDC261218P00540000 | put | 540.0000 | 2026-12-18 | 92.5000 | 92.5000 | 94.7000 | 544.2042 | 296000.00 | 0.00 | 296000.00 | 32 | 5 | 33 | 72 | 0.458333333333333 | 0.79330290319718 | 0.79330290319718 | false | false | false | true | ||||||||||||||||
| d23fa0d8-f3f8-4a76-bc6b-b39b11f7f358 | 2026-08-17 11:25 | 2026-08-17 11:25 | 2026-08-17 11:25 | WDC | WDC260828C00570000 | call | 570.0000 | 2026-08-28 | 19.8400 | 19.7000 | 21.6000 | 543.1500 | 69445.00 | 14200.00 | 55245.00 | 35 | 19 | 98 | 41 | 2.39024390243902 | 0.79368877459126 | 0.806992527974617 | true | false | false | true | ||||||||||||||||
| 83b4cd2a-a4b0-4d1f-81d3-17099df1ab8f | 2026-08-17 10:45 | 2026-08-17 10:45 | 2026-08-17 10:45 | WDC | WDC260904C00555000 | call | 555.0000 | 2026-09-04 | 30.8100 | 30.2000 | 33.5000 | 538.3000 | 231070.00 | 3130.00 | 227940.00 | 75 | 6 | 87 | 175 | 0.497142857142857 | 0.786133674738167 | 0.799463716676244 | true | false | false | true | ||||||||||||||||
| 06266f2a-8124-4ad6-9717-3e56e030415e | 2026-08-17 10:28 | 2026-08-17 10:28 | 2026-08-17 10:28 | WDC | WDC260821P00550000 | put | 550.0000 | 2026-08-21 | 23.9300 | 23.6000 | 24.8000 | 543.5000 | 471325.00 | 445010.00 | 26315.00 | 197 | 8 | 936 | 377 | 2.48275862068966 | 0.906871805676798 | 0.905455032221784 | false | false | false | true | ||||||||||||||||
| f847d99b-a714-439b-9618-4dd541f17842 | 2026-08-17 10:07 | 2026-08-17 10:07 | 2026-08-17 10:07 | WDC | WDC260918C00570000 | call | 570.0000 | 2026-09-18 | 37.1200 | 36.9500 | 39.0000 | 538.5307 | 51970.00 | 3735.00 | 48235.00 | 14 | 8 | 22 | 152 | 0.144736842105263 | 0.77472575763743 | 0.778682935520056 | true | false | false | true | ||||||||||||||||
| d990bd19-7d24-4afa-a9f9-ee8dc5d60d2f | 2026-08-17 10:07 | 2026-08-17 10:07 | 2026-08-17 10:07 | WDC | WDC260918C00610000 | call | 610.0000 | 2026-09-18 | 24.8700 | 23.7500 | 26.5500 | 538.5307 | 54710.00 | 9975.00 | 44735.00 | 22 | 14 | 27 | 350 | 0.0771428571428571 | 0.776691763636661 | 0.776691763636661 | true | false | false | true | ||||||||||||||||
| af90f88a-8ed7-4a74-8682-98d67740f2bd | 2026-08-17 10:07 | 2026-08-17 10:07 | 2026-08-17 10:07 | WDC | WDC260918C00590000 | call | 590.0000 | 2026-09-18 | 30.6000 | 30.6000 | 31.5000 | 538.5307 | 201992.00 | 3070.00 | 198922.00 | 66 | 21 | 106 | 482 | 0.219917012448133 | 0.778817673070082 | 0.778003306847068 | true | false | false | true | ||||||||||||||||
| 85c29c32-7746-49ff-b7e3-49f793dc4807 | 2026-08-17 10:07 | 2026-08-17 10:07 | 2026-08-17 10:07 | WDC | WDC260918C00590000 | call | 590.0000 | 2026-09-18 | 31.0000 | 30.4000 | 31.5000 | 538.5307 | 99200.00 | 3100.00 | 96100.00 | 32 | 8 | 40 | 482 | 0.0829875518672199 | 0.784515110757115 | 0.784515110757115 | true | false | false | true | ||||||||||||||||
| 6572d053-8367-4792-82b0-673ec73f5a7e | 2026-08-17 09:58 | 2026-08-17 09:58 | 2026-08-17 09:58 | WDC | WDC260821C00547500 | call | 547.5000 | 2026-08-21 | 20.8700 | 20.1000 | 21.0000 | 545.2925 | 79300.00 | 52255.00 | 27045.00 | 38 | 13 | 50 | 60 | 0.833333333333333 | 0.960177919780705 | 0.957063755722966 | true | false | false | true | ||||||||||||||||
| 7789e8bb-a45a-4f25-a882-1214f5d893c9 | 2026-08-17 09:49 | 2026-08-17 09:49 | 2026-08-17 09:49 | WDC | WDC260918P00500000 | put | 500.0000 | 2026-09-18 | 30.1500 | 29.2000 | 31.3500 | 538.2250 | 226130.00 | 223110.00 | 3020.00 | 75 | 7 | 77 | 705 | 0.109219858156028 | 0.777186974602425 | 0.778057053337837 | true | false | false | true | ||||||||||||||||
| 4446babf-ac6a-4e5b-906f-6de4c5fbcf46 | 2026-08-17 09:45 | 2026-08-17 09:45 | 2026-08-17 09:45 | WDC | WDC260821P00570000 | put | 570.0000 | 2026-08-21 | 44.3900 | 42.7500 | 44.4000 | 535.0200 | 292990.00 | 270815.00 | 22175.00 | 66 | 17 | 67 | 125 | 0.536 | 0.996403112087121 | 0.993797289636128 | false | false | false | true | ||||||||||||||||
| 0fc9f8fe-ff6d-4628-a078-1e63f060b7ed | 2026-08-17 09:43 | 2026-08-17 09:43 | 2026-08-17 09:43 | WDC | WDC260828P00510000 | put | 510.0000 | 2026-08-28 | 17.7500 | 17.7500 | 20.1000 | 534.1950 | 62125.00 | 0.00 | 62125.00 | 35 | 5 | 72 | 88 | 0.818181818181818 | 0.787673373012186 | 0.787673373012186 | false | false | false | true | ||||||||||||||||
| d8d64fdd-abda-4a61-ada8-6c80561be937 | 2026-08-17 09:42 | 2026-08-17 09:42 | 2026-08-17 09:42 | WDC | WDC261016P00530000 | put | 530.0000 | 2026-10-16 | 62.0000 | 59.8000 | 65.5000 | 533.6600 | 341000.00 | 136400.00 | 204600.00 | 55 | 5 | 55 | 92 | 0.597826086956522 | 0.766013969557408 | 0.766013969557408 | false | false | false | true | ||||||||||||||||
| a3f75186-4f24-4ff3-abc9-172bc2a5936f | 2026-08-17 09:35 | 2026-08-17 09:35 | 2026-08-17 09:35 | WDC | WDC260828P00570000 | put | 570.0000 | 2026-08-28 | 56.8000 | 54.3500 | 56.8000 | 527.2800 | 153360.00 | 153360.00 | 0.00 | 27 | 6 | 27 | 4 | 6.75 | 0.827500879724405 | 0.827500879724405 | false | false | false | true | false | |||||||||||||||
| fddc3da3-9580-4501-9d0c-885ee5bc7a46 | 2026-08-14 16:00 | 2026-08-14 15:59 | 2026-08-14 15:59 | WDC | WDC260828C00500000 | call | 500.0000 | 2026-08-28 | 34.0000 | 30.1500 | 34.0000 | 509.9200 | 54400.00 | 54400.00 | 0.00 | 16 | 6 | 270 | 565 | 0.47787610619469 | 0.719946747042869 | 0.719946747042869 | false | false | false | true | ||||||||||||||||
| 54e16dc7-584a-4c11-846e-a74cf277faa1 | 2026-08-14 15:55 | 2026-08-14 15:54 | 2026-08-14 15:54 | WDC | WDC260821C00450000 | call | 450.0000 | 2026-08-21 | 55.5000 | 51.4500 | 55.5000 | 501.3500 | 127648.00 | 127648.00 | 0.00 | 23 | 10 | 60 | 367 | 0.163487738419619 | 0.754937679677123 | 0.753624568517881 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |