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.
Simplify Analyticsuw_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 | 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 |
|---|
| 9ad1e7b6-657a-4058-a2ed-08c0bf8ebaa0 | 2026-09-21 11:03 | 2026-09-21 11:03 | 2026-09-21 11:03 | LQDA | LQDA261120P00050000 | put | 50.0000 | 2026-11-20 | 2.4000 | 2.2000 | 2.7000 | 67.2800 | 10569.00 | 244.00 | 10325.00 | 44 | 8 | 63 | 249 | 0.253012048192771 | 0.910395947732026 | 0.904279739755842 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 5946075629.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:05:23.809831Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 05608509-b665-4bae-b2ff-5019bc59d4c1 | 2026-09-17 14:23 | 2026-09-17 14:23 | 2026-09-17 14:23 | LQDA | LQDA261016C00100000 | call | 100.0000 | 2026-10-16 | 0.5400 | 0.2500 | 0.9000 | 67.5800 | 23755.00 | 10705.00 | 10300.00 | 441 | 30 | 702 | 8479 | 0.0827927821677085 | 0.8977624479969 | 0.895229195601958 | true | false | false | true | ||||||||||||||||
| 48e3e44a-f43d-4e9a-9f55-99091bdc4611 | 2026-09-15 10:21 | 2026-09-15 10:21 | 2026-09-15 10:21 | LQDA | LQDA270115P00055000 | put | 55.0000 | 2027-01-15 | 6.8200 | 5.5000 | 7.5000 | 63.4700 | 12280.00 | 2070.00 | 10210.00 | 18 | 11 | 24 | 121 | 0.198347107438017 | 0.808218789034326 | 0.800198797720735 | true | false | false | true | ||||||||||||||||
| 3ae66570-a5f5-416c-9a61-ba8e3be66aa9 | 2026-09-11 15:29 | 2026-09-11 15:29 | 2026-09-11 15:29 | LQDA | LQDA260918P00050000 | put | 50.0000 | 2026-09-18 | 0.2500 | 0.0500 | 0.2500 | 67.6800 | 10583.00 | 10563.00 | 20.00 | 424 | 36 | 3555 | 5576 | 0.637553802008608 | 1.36355318227668 | 1.36355318227668 | false | false | false | true | ||||||||||||||||
| ac32991b-3077-4319-bf5b-0687638569f4 | 2026-09-11 12:35 | 2026-09-11 12:35 | 2026-09-11 12:35 | LQDA | LQDA260918P00058000 | put | 58.0000 | 2026-09-18 | 0.6000 | 0.4500 | 0.6500 | 68.4000 | 14984.00 | 13784.00 | 1200.00 | 250 | 41 | 2510 | 236 | 10.635593220339 | 1.0688688546574 | 1.06106882445817 | false | false | false | true | ||||||||||||||||
| ec664315-3143-40fc-805c-9cfe2778cb1d | 2026-09-09 14:56 | 2026-09-09 14:56 | 2026-09-09 14:56 | LQDA | LQDA270115P00055000 | put | 55.0000 | 2027-01-15 | 6.3000 | 6.0000 | 6.7000 | 68.7150 | 73111.00 | 1920.00 | 71191.00 | 116 | 36 | 116 | 88 | 1.31818181818182 | 0.860728383599315 | 0.852744861308447 | false | false | false | true | ||||||||||||||||
| 9dab1816-283d-4d37-825c-f656cf27c4cb | 2026-09-04 13:39 | 2026-09-04 13:39 | 2026-09-04 13:39 | LQDA | LQDA261016P00067500 | put | 67.5000 | 2026-10-16 | 8.3700 | 8.0000 | 8.4000 | 68.4150 | 41020.00 | 29400.00 | 11620.00 | 49 | 5 | 61 | 120 | 0.508333333333333 | 0.984953058774547 | 0.984953058774547 | false | false | false | true | ||||||||||||||||
| 7f559e30-7b5a-42db-a076-d49b6a11d465 | 2026-09-02 14:28 | 2026-09-02 14:28 | 2026-09-02 14:28 | LQDA | LQDA260911P00062000 | put | 62.0000 | 2026-09-11 | 2.0600 | 2.0500 | 2.8000 | 67.9400 | 12150.00 | 0.00 | 12150.00 | 59 | 14 | 64 | 103 | 0.621359223300971 | 1.1190164992801 | 1.08769003279477 | false | false | false | true | ||||||||||||||||
| ee0bb4c7-8aa1-43a2-8c38-aa7005c7e180 | 2026-08-28 15:17 | 2026-08-28 15:17 | 2026-08-28 15:17 | LQDA | LQDA260904C00075000 | call | 75.0000 | 2026-09-04 | 2.0000 | 1.4000 | 2.0500 | 68.3500 | 34170.00 | 20600.00 | 13370.00 | 171 | 23 | 1157 | 158 | 7.32278481012658 | 1.15371101673469 | 1.15371101673469 | true | false | false | true | ||||||||||||||||
| db33eb4a-7b1c-4e76-af04-e1741ff8d009 | 2026-08-28 12:17 | 2026-08-28 12:17 | 2026-08-28 12:17 | LQDA | LQDA260904P00050000 | put | 50.0000 | 2026-09-04 | 0.3000 | 0.1500 | 0.3500 | 68.2100 | 28884.00 | 4524.00 | 24330.00 | 963 | 43 | 3010 | 628 | 4.79299363057325 | 1.44487151957257 | 1.44487151957257 | true | false | false | true | ||||||||||||||||
| fd8537a2-cf29-48e0-b14d-259fefdf5087 | 2026-08-28 10:30 | 2026-08-28 10:30 | 2026-08-28 10:30 | LQDA | LQDA261016P00055000 | put | 55.0000 | 2026-10-16 | 4.5100 | 4.3000 | 4.6000 | 68.5400 | 16250.00 | 1380.00 | 13950.00 | 36 | 16 | 60 | 278 | 0.215827338129496 | 1.12627785474686 | 1.11301396676931 | false | false | false | true | ||||||||||||||||
| 5febe7f0-757e-4fff-81eb-5111e5d9d251 | 2026-08-27 09:51 | 2026-08-27 09:51 | 2026-08-27 09:51 | LQDA | LQDA260918C00081000 | call | 81.0000 | 2026-09-18 | 4.0000 | 3.3000 | 5.1000 | 70.2700 | 39950.00 | 13200.00 | 19950.00 | 100 | 6 | 100 | 100 | 1 | 1.12523767396373 | 1.1145677307023 | false | false | false | true | ||||||||||||||||
| a8379b3c-a00f-47b0-8e5a-9e1cf58de4f7 | 2026-08-24 14:16 | 2026-08-24 14:16 | 2026-08-24 14:16 | LQDA | LQDA260904P00055000 | put | 55.0000 | 2026-09-04 | 1.2000 | 0.8000 | 1.2000 | 70.4050 | 24300.00 | 22920.00 | 1380.00 | 203 | 31 | 4480 | 4310 | 1.03944315545244 | 1.39814145107572 | 1.37827889246578 | false | false | false | true | ||||||||||||||||
| 86713154-2114-4af7-a558-9578aeafd0b9 | 2026-08-24 14:14 | 2026-08-24 14:14 | 2026-08-24 14:14 | LQDA | LQDA260904C00095000 | call | 95.0000 | 2026-09-04 | 0.5000 | 0.3000 | 0.6500 | 70.3400 | 15047.00 | 14247.00 | 800.00 | 301 | 44 | 2321 | 241 | 9.63070539419087 | 1.16795454604554 | 1.16260857171697 | false | false | false | true | ||||||||||||||||
| 67403c1a-69de-4373-9e6f-0f9f7d656c2c | 2026-08-24 13:39 | 2026-08-24 13:39 | 2026-08-24 13:39 | LQDA | LQDA260904C00080000 | call | 80.0000 | 2026-09-04 | 2.2000 | 2.2000 | 2.5000 | 70.2200 | 31910.00 | 0.00 | 31030.00 | 145 | 5 | 276 | 49 | 5.63265306122449 | 1.14350717465371 | 1.11945609307654 | true | false | false | true | ||||||||||||||||
| f4580901-7504-4f22-b927-69894ab332af | 2026-08-21 14:47 | 2026-08-21 14:47 | 2026-08-21 14:47 | LQDA | LQDA260828P00060000 | put | 60.0000 | 2026-08-28 | 1.3000 | 1.1000 | 1.5000 | 68.6200 | 25214.00 | 11824.00 | 2470.00 | 194 | 27 | 3258 | 551 | 5.91288566243194 | 1.21900358117491 | 1.21900358117491 | false | false | false | true | ||||||||||||||||
| 450dc914-d713-423f-a1ab-699929e74562 | 2026-08-21 13:24 | 2026-08-21 13:24 | 2026-08-21 13:24 | LQDA | LQDA260828P00060000 | put | 60.0000 | 2026-08-28 | 1.1500 | 0.6000 | 1.2000 | 68.3200 | 29362.00 | 23513.00 | 5849.00 | 255 | 22 | 2800 | 551 | 5.08166969147005 | 1.15773549494899 | 1.11773700056879 | true | false | false | true | ||||||||||||||||
| 04263a96-4cb1-47e9-bbc5-29663133cf90 | 2026-08-21 13:24 | 2026-08-21 13:24 | 2026-08-21 13:24 | LQDA | LQDA260828P00060000 | put | 60.0000 | 2026-08-28 | 1.0700 | 0.6000 | 1.2000 | 68.3300 | 40395.00 | 12650.00 | 27745.00 | 377 | 20 | 2376 | 551 | 4.31215970961888 | 1.11845966969693 | 1.09807621872369 | false | false | false | true | ||||||||||||||||
| 938ea33e-0a98-4941-b0c8-e73a2a06c930 | 2026-08-21 13:24 | 2026-08-21 13:24 | 2026-08-21 13:24 | LQDA | LQDA260828P00060000 | put | 60.0000 | 2026-08-28 | 0.8800 | 0.8500 | 1.0500 | 68.9100 | 11255.00 | 0.00 | 10175.00 | 128 | 8 | 560 | 551 | 1.01633393829401 | 1.07522498029572 | 1.0531715613987 | false | false | false | true | ||||||||||||||||
| 12bfec60-3c38-4e1e-b3bf-dada5428eb66 | 2026-08-20 13:12 | 2026-08-20 13:12 | 2026-08-20 13:12 | LQDA | LQDA260918P00072500 | put | 72.5000 | 2026-09-18 | 8.7600 | 8.2000 | 8.8000 | 71.7000 | 65690.00 | 38720.00 | 26970.00 | 75 | 15 | 142 | 18 | 7.88888888888889 | 1.05448588542314 | 1.05448588542314 | false | false | false | true | ||||||||||||||||
| bcb0a1c6-8396-411f-83f7-b475b7d474f9 | 2026-08-20 12:22 | 2026-08-20 12:22 | 2026-08-20 12:22 | LQDA | LQDA261218P00055000 | put | 55.0000 | 2026-12-18 | 6.3500 | 5.5000 | 7.9000 | 71.8550 | 12060.00 | 8280.00 | 3780.00 | 19 | 8 | 35 | 173 | 0.202312138728324 | 0.946387921811891 | 0.936833207400936 | false | false | false | true | ||||||||||||||||
| 4773f712-0a19-4643-b99b-0baa9885d66f | 2026-08-17 13:16 | 2026-08-17 13:16 | 2026-08-17 13:16 | LQDA | LQDA260821P00078000 | put | 78.0000 | 2026-08-21 | 4.7900 | 3.9000 | 4.9000 | 76.9200 | 22512.00 | 20152.00 | 2360.00 | 47 | 11 | 86 | 48 | 1.79166666666667 | 1.32639157354607 | 1.3168612659751 | true | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 6121513055.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:36:37.058930Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:58:33.363095Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T18:01:17.201510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T19:36:54.231390Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:25:17.992358Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:38:22.875878Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:00:28.149501Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5845378127.00 |
| 2026-11-02 |
| 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 |