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 | 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 |
|---|
| 3d34e414-0af2-430d-8ee2-be028724cfd0 | 2026-08-27 14:55 | 2026-08-27 14:55 | 2026-08-27 14:55 | PANW | PANW261016C00380000 | call | 380.0000 | 2026-10-16 | 37.3000 | 36.7500 | 37.8500 | 385.9900 | 74600.00 | 48490.00 | 0.00 | 20 | 6 | 288 | 271 | 1.06273062730627 | 0.589187593857296 | 0.589187593857296 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 305882920000.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aa66eca3-0d99-4d3c-a552-796b546bf235 | 2026-09-15 12:27 | 2026-09-15 12:27 | 2026-09-15 12:27 | PANW | PANW261016C00380000 | call | 380.0000 | 2026-10-16 | 22.6000 | 21.6000 | 22.7000 | 376.0000 | 76840.00 | 51975.00 | 24865.00 | 34 | 5 | 212 | 657 | 0.322678843226788 | 0.536952652410162 | 0.536952652410162 | true | false | false | true | ||||||||||||||||
| dc4fb7fc-8a8e-4b00-bc3e-266c5d6d10e3 | 2026-09-22 15:55 | 2026-09-22 15:55 | 2026-09-22 15:55 | PANW | PANW261016C00380000 | call | 380.0000 | 2026-10-16 | 17.6000 | 17.1000 | 17.6000 | 373.6350 | 59840.00 | 59840.00 | 0.00 | 34 | 8 | 194 | 931 | 0.208378088077336 | 0.524452974676466 | 0.524452974676466 | false | false | false | true | ||||||||||||||||
| 333d43cc-971b-4a44-ab75-e5eb4fd60be6 | 2026-09-23 10:24 | 2026-09-23 10:24 | 2026-09-23 10:24 | PANW | PANW261016C00380000 | call | 380.0000 | 2026-10-16 | 19.7100 | 19.0000 | 19.7500 | 379.1200 | 15770.00 | 13810.00 | 1960.00 | 8 | 6 | 55 | 1061 | 0.0518378887841659 | 0.522745674550683 | 0.519691916463361 | true | false | false | true | ||||||||||||||||
| 13d33790-a1da-4d3b-849f-c80a9b492de4 | 2026-09-23 11:30 | 2026-09-23 11:30 | 2026-09-23 11:30 | PANW | PANW261016C00380000 | call | 380.0000 | 2026-10-16 | 25.1300 | 24.6000 | 25.2000 | 388.0000 | 12565.00 | 12565.00 | 0.00 | 5 | 5 | 323 | 1061 | 0.304429783223374 | 0.523194882911321 | 0.526538849219432 | false | false | false | true | ||||||||||||||||
| 56ae9488-2cbf-4bbb-90c4-c972795a0043 | 2026-09-23 15:43 | 2026-09-23 15:43 | 2026-09-23 15:43 | PANW | PANW261016C00380000 | call | 380.0000 | 2026-10-16 | 26.3500 | 26.2000 | 26.5000 | 390.0000 | 31616.00 | 7907.00 | 10534.00 | 12 | 10 | 421 | 1061 | 0.39679547596607 | 0.522103272918571 | 0.522370173373486 | false | false | false | true | ||||||||||||||||
| 4134e540-8b7e-4625-8312-c237ec94ebf7 | 2026-09-24 09:46 | 2026-09-24 09:46 | 2026-09-24 09:46 | PANW | PANW261016C00380000 | call | 380.0000 | 2026-10-16 | 29.1000 | 29.1000 | 30.9500 | 394.4950 | 40740.00 | 0.00 | 40740.00 | 14 | 10 | 21 | 1160 | 0.0181034482758621 | 0.518241368711118 | 0.541086790320668 | true | false | false | true | ||||||||||||||||
| d766c984-3445-4b55-baf4-577eaece8e48 | 2026-09-25 09:51 | 2026-09-25 09:51 | 2026-09-25 09:51 | PANW | PANW261016C00380000 | call | 380.0000 | 2026-10-16 | 17.5000 | 17.2000 | 19.9000 | 377.7500 | 10500.00 | 0.00 | 10500.00 | 6 | 6 | 295 | 1172 | 0.251706484641638 | 0.502300120458555 | 0.502300120458555 | false | false | false | true | ||||||||||||||||
| 8b9662fa-79a6-46de-bc5f-54af63aab7b9 | 2026-09-25 15:48 | 2026-09-25 15:48 | 2026-09-25 15:48 | PANW | PANW261016C00380000 | call | 380.0000 | 2026-10-16 | 16.0900 | 15.9500 | 16.2500 | 375.0000 | 27346.00 | 17670.00 | 9676.00 | 17 | 6 | 574 | 1172 | 0.489761092150171 | 0.499419720937523 | 0.498305065518486 | false | false | false | true | ||||||||||||||||
| 4103d17a-bb8e-411c-aea9-f3fdc30aeb8e | 2026-09-25 15:48 | 2026-09-25 15:48 | 2026-09-25 15:48 | PANW | PANW261016C00380000 | call | 380.0000 | 2026-10-16 | 16.0700 | 16.0000 | 16.1500 | 375.0000 | 43377.00 | 6420.00 | 36957.00 | 27 | 6 | 616 | 1172 | 0.525597269624573 | 0.498583730340454 | 0.498026400047827 | false | false | false | true | ||||||||||||||||
| 61b98bfb-1e1f-4cd2-bffe-cd29b1cee216 | 2026-09-28 14:52 | 2026-09-28 14:52 | 2026-09-28 14:52 | PANW | PANW261016C00380000 | call | 380.0000 | 2026-10-16 | 26.7100 | 26.3000 | 27.0000 | 394.3999 | 96168.00 | 96168.00 | 0.00 | 36 | 7 | 569 | 1443 | 0.394317394317394 | 0.529808072683844 | 0.529808072683844 | false | false | false | true | ||||||||||||||||
| 9ffca5f2-7d32-4497-a3ea-46956e34f8b4 | 2026-09-28 15:14 | 2026-09-28 15:14 | 2026-09-28 15:14 | PANW | PANW261016C00380000 | call | 380.0000 | 2026-10-16 | 26.4100 | 26.1000 | 26.6000 | 393.7400 | 39618.00 | 39618.00 | 0.00 | 15 | 9 | 643 | 1443 | 0.445599445599446 | 0.534079610089171 | 0.534079610089171 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 305882920000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 306398260000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 321719400000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 321719400000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:31:00.015856Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 321719400000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:47:37.737983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 321719400000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:47:07.799094Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 306537320000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:52:56.276610Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 306537320000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:51:07.574812Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 306537320000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:51:07.574812Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 320729620000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:00:50.307488Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 320729620000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:15:55.789711Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |