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_alerts566,287 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 |
|---|
| dd7a162d-3df3-4e23-80a1-0a2841891e32 | 2026-09-29 12:36 | 2026-09-29 12:35 | 2026-09-29 12:35 | SLS | SLS261002C00012000 | call | 12.0000 | 2026-10-02 | 0.3000 | 0.2500 | 0.3000 | 11.0000 | 14990.00 | 14990.00 | 0.00 | 500 | 24 | 620 | 1858 | 0.333692142088267 | 1.20372208895625 | 1.22936288673894 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 2324395111.00 | 2026-11-11 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T16:39:28.276769Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 517e8270-a132-42e3-813c-392a3165ff06 | 2026-09-28 10:32 | 2026-09-28 10:32 | 2026-09-28 10:32 | SLS | SLS261120C00015000 | call | 15.0000 | 2026-11-20 | 2.5400 | 2.5000 | 2.6500 | 11.6300 | 25447.00 | 0.00 | 25192.00 | 100 | 9 | 368 | 10685 | 0.0344408048666355 | 2.02509242115539 | 2.02509242115539 | true | false | ||||||||||||||||||
| c55abb4c-f0a2-4a7d-8a6b-49272951597a | 2026-09-25 13:48 | 2026-09-25 13:48 | 2026-09-25 13:48 | SLS | SLS261002C00013500 | call | 13.5000 | 2026-10-02 | 0.2200 | 0.2000 | 0.3000 | 11.6750 | 11000.00 | 25.00 | 10975.00 | 500 | 14 | 556 | 464 | 1.19827586206897 | 1.154969056561 | 1.26012881953974 | false | false | ||||||||||||||||||
| ac0f9bf5-644c-4449-b44a-84d80f958264 | 2026-09-25 10:29 | 2026-09-25 10:29 | 2026-09-25 10:29 | SLS | SLS261016C00025000 | call | 25.0000 | 2026-10-16 | 0.2500 | 0.2000 | 0.3000 | 11.6200 | 10974.00 | 10674.00 | 0.00 | 439 | 10 | 440 | 1854 | 0.237324703344121 | 2.106867010572 | 2.12652522077014 | false | false | ||||||||||||||||||
| c2c5a3cb-a03b-4e52-9a7e-e79f4734acdd | 2026-09-24 12:30 | 2026-09-24 12:29 | 2026-09-24 12:29 | SLS | SLS270115C00015000 | call | 15.0000 | 2027-01-15 | 3.9500 | 3.9000 | 4.2000 | 11.3650 | 19770.00 | 0.00 | 11870.00 | 50 | 5 | 144 | 50006 | 0.00287965444146702 | 2.00321896942183 | 2.00321896942183 | false | false | ||||||||||||||||||
| c7f5b582-9eb9-4e73-9bd2-1e547b68d273 | 2026-09-18 12:33 | 2026-09-18 12:33 | 2026-09-18 12:33 | SLS | SLS260918P00012000 | put | 12.0000 | 2026-09-18 | 0.9000 | 0.8000 | 0.9500 | 11.1700 | 17994.00 | 17994.00 | 0.00 | 200 | 7 | 698 | 2395 | 0.291440501043841 | 3.25596257726031 | 3.25596257726031 | false | false | ||||||||||||||||||
| 7a43693b-a72e-43cc-a1f1-d2e3fb89949b | 2026-09-18 10:05 | 2026-09-18 10:05 | 2026-09-18 10:05 | SLS | SLS261016P00011000 | put | 11.0000 | 2026-10-16 | 1.9100 | 1.7000 | 1.9500 | 11.2400 | 32442.00 | 32442.00 | 0.00 | 170 | 8 | 400 | 706 | 0.56657223796034 | 1.66427042279095 | 1.66427042279095 | false | false | ||||||||||||||||||
| f41e66b6-e9b4-4f0a-aff7-e9ecd51b1a3b | 2026-09-16 09:43 | 2026-09-16 09:43 | 2026-09-16 09:43 | SLS | SLS261016P00013000 | put | 13.0000 | 2026-10-16 | 3.3100 | 3.2000 | 3.5000 | 11.4750 | 16572.00 | 2310.00 | 14262.00 | 50 | 5 | 150 | 753 | 0.199203187250996 | 1.80303644794208 | 1.8335257926227 | false | false | ||||||||||||||||||
| 089d6124-265e-460d-8e03-51f03250e071 | 2026-09-15 12:13 | 2026-09-15 12:13 | 2026-09-15 12:13 | SLS | SLS270115C00025000 | call | 25.0000 | 2027-01-15 | 2.6000 | 2.4500 | 2.6000 | 11.2000 | 32440.00 | 32440.00 | 0.00 | 125 | 6 | 248 | 2036 | 0.121807465618861 | 2.00095442194034 | 2.00095442194034 | false | false | ||||||||||||||||||
| 823f1d48-f1c5-4560-9de6-80b5367619e6 | 2026-09-14 14:26 | 2026-09-14 14:26 | 2026-09-14 14:26 | SLS | SLS261002P00011500 | put | 11.5000 | 2026-10-02 | 1.2500 | 1.2500 | 1.3000 | 12.0000 | 137314.00 | 0.00 | 137314.00 | 1097 | 48 | 1112 | 159 | 6.9937106918239 | 1.44530766220185 | 1.44530766220185 | false | false | ||||||||||||||||||
| 24041252-62b4-4f6d-b9e5-d3873ef03b7a | 2026-09-09 10:31 | 2026-09-09 10:31 | 2026-09-09 10:31 | SLS | SLS280121C00030000 | call | 30.0000 | 2028-01-21 | 6.2000 | 5.9000 | 6.2000 | 13.0000 | 34718.00 | 34718.00 | 0.00 | 56 | 5 | 502 | 9333 | 0.0537876352726883 | 1.41097124047512 | 1.41429260980055 | false | false | ||||||||||||||||||
| 5aed9678-4eae-482f-8d29-f4890115415c | 2026-09-04 15:52 | 2026-09-04 15:52 | 2026-09-04 15:52 | SLS | SLS260911C00014000 | call | 14.0000 | 2026-09-11 | 0.7500 | 0.6000 | 0.7500 | 13.7800 | 11547.00 | 11547.00 | 0.00 | 154 | 10 | 674 | 814 | 0.828009828009828 | 1.07073660688621 | 1.11015426002031 | false | false | ||||||||||||||||||
| 55a03bc4-c056-4c23-91b2-56dee74c237b | 2026-09-02 12:24 | 2026-09-02 12:24 | 2026-09-02 12:24 | SLS | SLS261016P00010000 | put | 10.0000 | 2026-10-16 | 2.0000 | 1.9500 | 2.0000 | 13.7650 | 22199.00 | 22199.00 | 0.00 | 111 | 9 | 224 | 12875 | 0.0173980582524272 | 2.25303012009112 | 2.26028537063253 | false | false | ||||||||||||||||||
| 83a07f87-8f21-4a27-bdc7-681899033761 | 2026-08-28 15:06 | 2026-08-28 15:06 | 2026-08-28 15:06 | SLS | SLS261002C00030000 | call | 30.0000 | 2026-10-02 | 0.6600 | 0.3000 | 1.2500 | 13.5750 | 31580.00 | 16530.00 | 15050.00 | 482 | 30 | 596 | 12 | 49.6666666666667 | 2.06480244848777 | 2.10943110656507 | true | false | ||||||||||||||||||
| f4a3f7a3-59dd-46a7-be53-f8d1f46078c8 | 2026-08-25 14:40 | 2026-08-25 14:40 | 2026-08-25 14:40 | SLS | SLS260828C00015000 | call | 15.0000 | 2026-08-28 | 0.4500 | 0.3500 | 0.4500 | 14.3000 | 10438.00 | 10438.00 | 0.00 | 232 | 21 | 2731 | 3269 | 0.835423676965433 | 1.37011495941308 | 1.41073448104786 | false | false | ||||||||||||||||||
| 7378b3e5-0f2e-4c54-8ace-15a101f4ccf7 | 2026-08-21 14:34 | 2026-08-21 14:33 | 2026-08-21 14:33 | SLS | SLS270115C00030000 | call | 30.0000 | 2027-01-15 | 4.2000 | 3.7000 | 4.2000 | 15.2300 | 260180.00 | 260180.00 | 0.00 | 620 | 46 | 4340 | 69160 | 0.062753036437247 | 1.83236635635791 | 1.88425824831397 | false | false | ||||||||||||||||||
| f7d726da-42c1-4437-bad3-002d84c95404 | 2026-08-21 14:09 | 2026-08-21 14:09 | 2026-08-21 14:09 | SLS | SLS261016C00020000 | call | 20.0000 | 2026-10-16 | 3.6900 | 3.5000 | 3.7000 | 15.0000 | 45718.00 | 45718.00 | 0.00 | 124 | 10 | 10720 | 886 | 12.0993227990971 | 2.06493416791613 | 2.10649024920821 | false | false |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2340550767.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:35:37.335936Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2344589681.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:50:01.932714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2344589681.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:29:28.038338Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2326414568.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2320356196.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:45:45.480252Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2320356196.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2354686967.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2367813438.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2367813438.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:49:41.095224Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2367813438.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2367813438.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T20:00:02.053596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2367813438.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2367813438.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T19:10:32.565799Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2367813438.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T18:54:14.733334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2367813438.00 |
| 2026-11-11 |
| 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 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 2367813438.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |