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_alerts609,118 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 |
|---|
| 73229a3d-f207-4879-ad52-9e750918f6a2 | 2026-09-29 14:39 | 2026-09-29 14:39 | 2026-09-29 14:39 | BX | BX261016P00109000 | put | 109.0000 | 2026-10-16 | 1.6800 | 1.6700 | 1.8200 | 114.0000 | 11445.00 | 3549.00 | 7896.00 | 68 | 14 | 114 | 111 | 1.02702702702703 | 0.398018006400572 | 0.399247675223733 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 85571262996.00 | 2026-10-22 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T18:41:07.734173Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| cb78b03c-a57d-4db4-b665-3d0986530f1d | 2026-09-29 11:33 | 2026-09-29 11:33 | 2026-09-29 11:33 | BX | BX261120P00100000 | put | 100.0000 | 2026-11-20 | 2.1200 | 2.1100 | 2.3200 | 113.0000 | 10595.00 | 0.00 | 10595.00 | 50 | 19 | 72 | 2028 | 0.0355029585798817 | 0.443780912532736 | 0.445214978744009 | false | false | false | |||||||||||||||||
| b9ae3073-d2e0-44a8-9b98-db33157f1140 | 2026-09-28 11:23 | 2026-09-28 11:23 | 2026-09-28 11:23 | BX | BX261016C00120000 | call | 120.0000 | 2026-10-16 | 2.2200 | 1.9800 | 2.2200 | 115.0000 | 10196.00 | 10196.00 | 0.00 | 46 | 5 | 318 | 632 | 0.503164556962025 | 0.398135427396836 | 0.39920109709734 | false | false | false | |||||||||||||||||
| 7f4a8a90-8160-4f87-bea5-93587275738a | 2026-09-28 11:23 | 2026-09-28 11:23 | 2026-09-28 11:23 | BX | BX261016C00120000 | call | 120.0000 | 2026-10-16 | 2.2100 | 1.9800 | 2.2100 | 114.0000 | 13230.00 | 13230.00 | 0.00 | 60 | 8 | 272 | 632 | 0.430379746835443 | 0.401066799888136 | 0.401066799888136 | false | false | false | |||||||||||||||||
| f5d3b31e-2543-4618-8230-54c2f3a79e0d | 2026-09-28 11:00 | 2026-09-28 10:59 | 2026-09-28 10:59 | BX | BX261218P00115000 | put | 115.0000 | 2026-12-18 | 8.3000 | 8.2500 | 8.4000 | 115.2700 | 80520.00 | 21580.00 | 58940.00 | 97 | 26 | 110 | 1976 | 0.055668016194332 | 0.416586454167961 | 0.416586454167961 | false | false | false | |||||||||||||||||
| 118206f9-199b-48e6-a4ae-1e3437e84404 | 2026-09-28 10:48 | 2026-09-28 10:48 | 2026-09-28 10:48 | BX | BX261218C00100000 | call | 100.0000 | 2026-12-18 | 17.7600 | 17.7000 | 18.9500 | 115.0000 | 46185.00 | 0.00 | 46185.00 | 26 | 8 | 330 | 251 | 1.31474103585657 | 0.33788183422471 | 0.362945728200042 | false | false | false | |||||||||||||||||
| 373ecc5b-e182-41b7-9cd6-66f9dc96b00a | 2026-09-28 10:46 | 2026-09-28 10:46 | 2026-09-28 10:46 | BX | BX261009P00111000 | put | 111.0000 | 2026-10-09 | 1.4000 | 1.3700 | 1.4000 | 115.0000 | 12751.00 | 12751.00 | 0.00 | 91 | 12 | 96 | 2 | 48 | 0.398813406555928 | 0.398813406555928 | true | false | false | |||||||||||||||||
| 055eb290-5e63-4324-a082-e7a1303c6f55 | 2026-09-24 11:04 | 2026-09-24 11:04 | 2026-09-24 11:04 | BX | BX270115P00120000 | put | 120.0000 | 2027-01-15 | 11.3900 | 11.3000 | 11.5500 | 116.6100 | 56932.00 | 0.00 | 56932.00 | 50 | 7 | 66 | 4434 | 0.0148849797023004 | 0.398510751631463 | 0.403150974022735 | false | false | false | |||||||||||||||||
| ee8cef68-048c-4aa7-a0d0-c310cae0e41d | 2026-09-24 09:46 | 2026-09-24 09:46 | 2026-09-24 09:46 | BX | BX261002P00115000 | put | 115.0000 | 2026-10-02 | 1.5500 | 1.5400 | 1.8300 | 117.3500 | 42666.00 | 0.00 | 42666.00 | 276 | 11 | 277 | 150 | 1.84666666666667 | 0.376583511240987 | 0.379715692275755 | false | false | false | |||||||||||||||||
| 41fffa04-c6a2-4b51-9b40-36fd37a324e9 | 2026-09-23 13:09 | 2026-09-23 13:09 | 2026-09-23 13:09 | BX | BX270917P00120000 | put | 120.0000 | 2027-09-17 | 16.4000 | 16.4000 | 16.7000 | 120.1100 | 254203.00 | 0.00 | 254203.00 | 155 | 39 | 514 | 805 | 0.638509316770186 | 0.409384413158559 | 0.409384413158559 | false | false | false | |||||||||||||||||
| 3e04f99f-76b1-4e2b-a49d-c668df16239f | 2026-09-23 10:56 | 2026-09-23 10:56 | 2026-09-23 10:56 | BX | BX261120C00120000 | call | 120.0000 | 2026-11-20 | 7.2800 | 7.2500 | 7.5500 | 120.3950 | 36421.00 | 0.00 | 36421.00 | 50 | 14 | 100 | 217 | 0.460829493087558 | 0.350225044508559 | 0.351807330353248 | false | false | false | |||||||||||||||||
| f48bbf2d-c8d7-4761-9ab0-7fdbf483dd1a | 2026-09-22 10:49 | 2026-09-22 10:48 | 2026-09-22 10:48 | BX | BX261002P00120000 | put | 120.0000 | 2026-10-02 | 1.6900 | 1.5900 | 1.7000 | 123.7550 | 34682.00 | 25049.00 | 9633.00 | 205 | 21 | 868 | 62 | 14 | 0.406913940600964 | 0.408305118055135 | true | false | false | |||||||||||||||||
| 481ed42f-8250-4c7e-8077-b3d8a5b096da | 2026-09-22 10:22 | 2026-09-22 10:22 | 2026-09-22 10:22 | BX | BX261016P00120000 | put | 120.0000 | 2026-10-16 | 2.7800 | 2.6700 | 2.8000 | 124.4000 | 52544.00 | 19462.00 | 33082.00 | 189 | 20 | 1352 | 2817 | 0.47994320198793 | 0.382290081535523 | 0.382290081535523 | false | false | false | |||||||||||||||||
| 2f653db9-16d8-4eae-8016-e8ec54826e67 | 2026-09-22 10:13 | 2026-09-22 10:13 | 2026-09-22 10:13 | BX | BX261016P00120000 | put | 120.0000 | 2026-10-16 | 2.3300 | 2.3200 | 2.4400 | 125.4050 | 27938.00 | 0.00 | 27938.00 | 120 | 15 | 636 | 2817 | 0.225772097976571 | 0.369338495153353 | 0.37024010193068 | true | false | false | |||||||||||||||||
| c5f44639-60b0-43b1-a312-c25d6ead48f2 | 2026-09-17 09:42 | 2026-09-17 09:42 | 2026-09-17 09:42 | BX | BX260918C00124000 | call | 124.0000 | 2026-09-18 | 2.3800 | 1.9100 | 2.8400 | 125.7100 | 78791.00 | 78791.00 | 0.00 | 331 | 11 | 331 | 177 | 1.87005649717514 | 0.516489273492892 | 0.520854932218583 | true | false | false | |||||||||||||||||
| 97104a31-632d-48be-8cf4-5fd64782ca90 | 2026-09-17 09:42 | 2026-09-17 09:42 | 2026-09-17 09:42 | BX | BX260918C00126000 | call | 126.0000 | 2026-09-18 | 1.2200 | 1.0000 | 1.3600 | 125.7100 | 71988.00 | 71988.00 | 0.00 | 588 | 9 | 590 | 27 | 21.8518518518519 | 0.515131949487181 | 0.515131949487181 | true | false | false | |||||||||||||||||
| d0396441-5fd5-44df-8434-950397caa9b4 | 2026-09-09 14:28 | 2026-09-09 14:28 | 2026-09-09 14:28 | BX | BX270115P00120000 | put | 120.0000 | 2027-01-15 | 7.0000 | 6.9000 | 7.2500 | 129.4450 | 138630.00 | 0.00 | 138630.00 | 198 | 30 | 558 | 5297 | 0.105342646781197 | 0.401985907182839 | 0.401985907182839 | true | false | false | |||||||||||||||||
| d5618895-766d-4751-ac09-5252b335ede2 | 2026-09-09 09:32 | 2026-09-09 09:31 | 2026-09-09 09:31 | BX | BX270115C00145000 | call | 145.0000 | 2027-01-15 | 6.7000 | 6.5500 | 6.7500 | 132.3900 | 276760.00 | 109930.00 | 0.00 | 413 | 24 | 1781 | 3305 | 0.538880484114977 | 0.345340812418797 | 0.347000083650402 | false | false | false | |||||||||||||||||
| a13f8d17-bbe9-47d0-995a-524825118fa8 | 2026-09-03 10:02 | 2026-09-03 10:02 | 2026-09-03 10:02 | BX | BX260918C00140000 | call | 140.0000 | 2026-09-18 | 3.7000 | 3.5000 | 3.8500 | 139.0800 | 235084.00 | 10740.00 | 195484.00 | 635 | 61 | 673 | 2859 | 0.235396991955229 | 0.35185070712549 | 0.358377889392558 | false | false | false | |||||||||||||||||
| 1866e237-be01-4d52-9283-ba33ea7a371a | 2026-08-21 12:30 | 2026-08-21 12:30 | 2026-08-21 12:30 | BX | BX260918P00140000 | put | 140.0000 | 2026-09-18 | 3.9400 | 3.8000 | 3.9500 | 143.6800 | 61796.00 | 61796.00 | 0.00 | 157 | 19 | 581 | 4911 | 0.11830584402362 | 0.365866321957498 | 0.368530952407951 | false | false | false | |||||||||||||||||
| 324c923f-886e-4b38-a4d1-395a2d1eefdc | 2026-08-20 14:24 | 2026-08-20 14:24 | 2026-08-20 14:24 | BX | BX260918P00140000 | put | 140.0000 | 2026-09-18 | 4.2900 | 4.1500 | 4.3000 | 142.8100 | 214681.00 | 214681.00 | 0.00 | 500 | 52 | 2957 | 2480 | 1.19233870967742 | 0.359776680066701 | 0.363657147293981 | false | false | false | |||||||||||||||||
| 82f2d824-4c25-440b-bf99-6a9199f4e204 | 2026-08-19 10:00 | 2026-08-19 10:00 | 2026-08-19 10:00 | BX | BX281215C00165000 | call | 165.0000 | 2028-12-15 | 25.5500 | 25.3500 | 25.5500 | 144.9800 | 155844.00 | 153299.00 | 2545.00 | 61 | 11 | 174 | 369 | 0.471544715447154 | 0.313398920143355 | 0.313513979755614 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 85571262996.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:36:52.175506Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 85991613060.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:26:10.967927Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 85991613060.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:26:10.967927Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 85991613060.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:01:52.060675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 85991613060.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:50:19.857671Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 85991613060.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:47:02.150049Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 89527057347.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:05:25.664270Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 89527057347.00 |
| 2026-10-22 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 89527057347.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:11:20.356460Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 89527057347.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:57:22.994560Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 93085020387.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:51:29.790694Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 93085020387.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:23:46.275389Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 93085020387.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:15:02.242582Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 94135895547.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:47:44.789077Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 94135895547.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:47:44.789077Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:10:05.195539Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |