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 | 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 |
|---|
| 76a296bb-a978-4575-a6b7-6005e2fa3b28 | 2026-09-22 14:50 | 2026-09-22 14:50 | 2026-09-22 14:50 | WDAY | WDAY270319C00220000 | call | 220.0000 | 2027-03-19 | 11.3600 | 11.3000 | 11.6000 | 189.6900 | 32940.00 | 5820.00 | 27120.00 | 29 | 12 | 37 | 213 | 0.173708920187793 | 0.388110259989373 | 0.39011042605929 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 36893080000.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T18:55:20.077577Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 48cb31ff-2d91-4601-b9f9-3287c86f66ac | 2026-09-22 14:50 | 2026-09-22 14:50 | 2026-09-22 14:50 | WDAY | WDAY270319C00230000 | call | 230.0000 | 2027-03-19 | 8.5800 | 8.4000 | 8.7000 | 189.6900 | 61810.00 | 37390.00 | 24420.00 | 72 | 14 | 108 | 113 | 0.955752212389381 | 0.377517225795748 | 0.377517225795748 | false | false | false | true | ||||||||||||||||
| 64c108b6-9f9e-4c62-93ef-26e4114c30d5 | 2026-09-17 09:46 | 2026-09-17 09:46 | 2026-09-17 09:46 | WDAY | WDAY290119C00230000 | call | 230.0000 | 2029-01-19 | 37.7800 | 37.5000 | 37.8000 | 198.6600 | 94450.00 | 38050.00 | 56400.00 | 25 | 9 | 25 | 0 | 0 | 0.33558110477057 | 0.33558110477057 | false | false | false | true | ||||||||||||||||
| fcffe712-4743-4119-87af-331a016dcd70 | 2026-09-16 14:10 | 2026-09-16 14:10 | 2026-09-16 14:10 | WDAY | WDAY261218P00180000 | put | 180.0000 | 2026-12-18 | 12.3700 | 12.3000 | 13.5000 | 189.4700 | 30931.00 | 1260.00 | 29671.00 | 25 | 16 | 67 | 248 | 0.270161290322581 | 0.471468238116182 | 0.479913501963858 | false | false | false | true | ||||||||||||||||
| 3b25ce55-a15e-4732-88c5-db78e00fcdba | 2026-09-16 10:24 | 2026-09-16 10:24 | 2026-09-16 10:24 | WDAY | WDAY261218C00195000 | call | 195.0000 | 2026-12-18 | 15.3400 | 15.3000 | 16.4000 | 187.0000 | 27610.00 | 6190.00 | 21420.00 | 18 | 9 | 19 | 445 | 0.0426966292134831 | 0.46508980919658 | 0.470380537249536 | false | false | false | true | ||||||||||||||||
| 3b8684de-2f06-4887-a63c-0db4e881a236 | 2026-09-14 10:22 | 2026-09-14 10:22 | 2026-09-14 10:22 | WDAY | WDAY261218P00185000 | put | 185.0000 | 2026-12-18 | 14.1900 | 14.1000 | 14.8000 | 191.0000 | 34050.00 | 7100.00 | 26950.00 | 24 | 9 | 27 | 112 | 0.241071428571429 | 0.475703382098252 | 0.478394228134149 | false | false | false | true | ||||||||||||||||
| b1d0b461-e128-4171-9ce2-fe5665bce8e3 | 2026-08-31 11:22 | 2026-08-31 11:22 | 2026-08-31 11:22 | WDAY | WDAY270319P00175000 | put | 175.0000 | 2027-03-19 | 13.2000 | 12.4000 | 13.2000 | 198.2500 | 139913.00 | 139913.00 | 0.00 | 106 | 8 | 120 | 17 | 7.05882352941176 | 0.450562798328468 | 0.450768395192148 | false | false | false | true | ||||||||||||||||
| 356b29e1-4161-417e-90aa-de22e3d5f545 | 2026-08-27 15:29 | 2026-08-27 15:28 | 2026-08-27 15:28 | WDAY | WDAY260911P00182500 | put | 182.5000 | 2026-09-11 | 6.3400 | 4.2000 | 7.4000 | 191.0000 | 94521.00 | 94521.00 | 0.00 | 149 | 5 | 150 | 18 | 8.33333333333333 | 0.688644210404226 | 0.688644210404226 | false | false | false | true | ||||||||||||||||
| e500bb56-04be-4635-b06f-da6f9e22181c | 2026-08-27 15:15 | 2026-08-27 15:14 | 2026-08-27 15:14 | WDAY | WDAY260828P00175000 | put | 175.0000 | 2026-08-28 | 1.7500 | 1.5000 | 2.7500 | 192.0000 | 174478.00 | 0.00 | 174478.00 | 997 | 6 | 1537 | 6990 | 0.219885550786838 | 1.95263086437112 | 1.95263086437112 | false | false | false | true | ||||||||||||||||
| 9680daab-0ecd-4559-978a-2f0fc215fdf6 | 2026-08-27 09:59 | 2026-08-27 09:59 | 2026-08-27 09:59 | WDAY | WDAY260904C00205000 | call | 205.0000 | 2026-09-04 | 6.6200 | 5.5000 | 6.8000 | 199.0600 | 39038.00 | 37738.00 | 1300.00 | 59 | 6 | 212 | 83 | 2.55421686746988 | 0.763023279919178 | 0.78208629278461 | false | false | false | true | ||||||||||||||||
| 1ae8e44e-6c7b-4e61-9fc1-98909391b92e | 2026-08-25 15:39 | 2026-08-25 15:39 | 2026-08-25 15:39 | WDAY | WDAY261016P00180000 | put | 180.0000 | 2026-10-16 | 7.8100 | 7.8000 | 8.3000 | 194.4700 | 14051.00 | 0.00 | 14051.00 | 18 | 9 | 20 | 44 | 0.454545454545455 | 0.506229120702062 | 0.506621776452295 | false | false | false | true | ||||||||||||||||
| fb0e16b8-1a99-48d7-adf6-208e76c82631 | 2026-08-19 14:58 | 2026-08-19 14:58 | 2026-08-19 14:58 | WDAY | WDAY260918C00210000 | call | 210.0000 | 2026-09-18 | 6.7000 | 6.7000 | 7.9000 | 198.4000 | 182331.00 | 6120.00 | 176211.00 | 272 | 40 | 1050 | 2772 | 0.378787878787879 | 0.485858196545975 | 0.491619391141811 | true | false | false | true | ||||||||||||||||
| 560c5077-06bf-4b78-9879-9ce18cb95555 | 2026-08-19 13:00 | 2026-08-19 12:59 | 2026-08-19 12:59 | WDAY | WDAY270617C00175000 | call | 175.0000 | 2027-06-17 | 43.9400 | 42.0000 | 47.0000 | 198.3600 | 35151.00 | 13290.00 | 21861.00 | 8 | 5 | 8 | 37 | 0.216216216216216 | 0.403368190378331 | 0.403536022737002 | true | false | false | true | ||||||||||||||||
| 38b0090a-7575-4710-be9b-e3847f29dac8 | 2026-08-19 10:54 | 2026-08-19 10:54 | 2026-08-19 10:54 | WDAY | WDAY260918C00210000 | call | 210.0000 | 2026-09-18 | 7.6000 | 7.6000 | 8.3000 | 200.0250 | 152002.00 | 0.00 | 152002.00 | 200 | 53 | 437 | 2772 | 0.157647907647908 | 0.499181485325743 | 0.499181485325743 | true | false | false | true | ||||||||||||||||
| 37593c2b-f4bb-4ef3-95de-83bb5946b106 | 2026-08-18 15:52 | 2026-08-18 15:52 | 2026-08-18 15:52 | WDAY | WDAY260821P00200000 | put | 200.0000 | 2026-08-21 | 9.4500 | 9.4000 | 11.3000 | 190.0000 | 31170.00 | 0.00 | 31170.00 | 33 | 10 | 44 | 616 | 0.0714285714285714 | 0.42433627776858 | 0.451951088340304 | true | false | false | true | ||||||||||||||||
| 6d6712f3-2f63-469d-a66a-0c5767d38e8e | 2026-08-17 15:12 | 2026-08-17 15:12 | 2026-08-17 15:12 | WDAY | WDAY260821P00185000 | put | 185.0000 | 2026-08-21 | 1.4900 | 1.0500 | 1.5000 | 191.9225 | 20922.00 | 20922.00 | 0.00 | 140 | 21 | 598 | 167 | 3.58083832335329 | 0.516957261680861 | 0.518565404054861 | false | false | false | true | ||||||||||||||||
| 04821f27-7c46-4286-870f-0a40eee4d332 | 2026-08-17 10:21 | 2026-08-17 10:21 | 2026-08-17 10:21 | WDAY | WDAY260821C00200000 | call | 200.0000 | 2026-08-21 | 2.2000 | 2.1500 | 2.6500 | 194.4750 | 14526.00 | 2865.00 | 11221.00 | 66 | 30 | 280 | 7617 | 0.0367598792175397 | 0.535800497466406 | 0.533821494533854 | true | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 36893080000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:55:20.077577Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 39058880000.00 |
| 2026-11-24 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 36800960000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:26:46.257544Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 36800960000.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T19:47:14.629482Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:16:43.855599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:30:09.852702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |