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 |
|---|
| f28f718d-46db-46c3-ab49-3339d884a35e | 2026-09-22 13:21 | 2026-09-22 13:21 | 2026-09-22 13:21 | SOXX | SOXX270319P00450000 | put | 450.0000 | 2027-03-19 | 18.2500 | 17.6000 | 18.4000 | 567.3750 | 273750.00 | 273750.00 | 0.00 | 150 | 2 | 177 | 768 | 0.23046875 | 0.445699702638363 | 0.445699702638363 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 48453532778.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T17:23:35.118331Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| daee1b55-19e5-473e-8faf-073048caf23c | 2026-09-21 15:25 | 2026-09-21 15:25 | 2026-09-21 15:25 | SOXX | SOXX261120C00525000 | call | 525.0000 | 2026-11-20 | 58.4000 | 56.5000 | 60.3000 | 559.4200 | 175200.00 | 0.00 | 0.00 | 30 | 1 | 30 | 140 | 0.214285714285714 | 0.416106613443455 | 0.416106613443455 | false | true | false | true | ||||||||||||||||
| 731ca5ba-a858-4fb9-8ff3-15f90606d1a0 | 2026-09-17 12:51 | 2026-09-17 12:51 | 2026-09-17 12:51 | SOXX | SOXX261016P00480000 | put | 480.0000 | 2026-10-16 | 7.1000 | 7.1000 | 7.4000 | 519.5900 | 106500.00 | 0.00 | 106500.00 | 150 | 1 | 7777 | 5192 | 1.4978813559322 | 0.387897097650402 | 0.387897097650402 | false | true | false | true | ||||||||||||||||
| f396372a-a3e4-4e6e-82a1-8682136e6f2e | 2026-09-17 12:17 | 2026-09-17 12:17 | 2026-09-17 12:17 | SOXX | SOXX280121C00700000 | call | 700.0000 | 2028-01-21 | 48.3000 | 44.0000 | 51.8000 | 519.3700 | 1449000.00 | 1449000.00 | 0.00 | 300 | 2 | 300 | 335 | 0.895522388059702 | 0.382298588035635 | 0.382298588035635 | false | true | true | false | ||||||||||||||||
| 4ad77526-0a19-4632-8254-ac0725ad84b8 | 2026-09-16 15:51 | 2026-09-16 15:51 | 2026-09-16 15:51 | SOXX | SOXX270917P00400000 | put | 400.0000 | 2027-09-17 | 28.7000 | 26.4000 | 34.0000 | 501.0000 | 774900.00 | 0.00 | 774900.00 | 270 | 1 | 270 | 322 | 0.838509316770186 | 0.423005371871081 | 0.423005371871081 | false | true | false | true | ||||||||||||||||
| e4de8426-e54e-48d6-a01a-1876d65c9a7d | 2026-09-16 10:07 | 2026-09-16 10:07 | 2026-09-16 10:07 | SOXX | SOXX270219P00410000 | put | 410.0000 | 2027-02-19 | 14.1000 | 12.7000 | 16.0000 | 507.5100 | 423000.00 | 0.00 | 423000.00 | 300 | 1 | 300 | 84 | 3.57142857142857 | 0.42398566061158 | 0.42398566061158 | false | true | false | true | ||||||||||||||||
| a2baf083-9191-4176-82b5-4a53cba9ab63 | 2026-09-14 13:38 | 2026-09-14 13:38 | 2026-09-14 13:38 | SOXX | SOXX261016P00510000 | put | 510.0000 | 2026-10-16 | 25.8000 | 24.7000 | 27.6000 | 500.6100 | 645000.00 | 0.00 | 645000.00 | 250 | 2 | 254 | 2707 | 0.0938308090136683 | 0.366056557857205 | 0.366056557857205 | false | true | true | false | ||||||||||||||||
| 1458b70b-f09a-4ec3-a98b-ffc0680a5f39 | 2026-09-14 10:21 | 2026-09-14 10:21 | 2026-09-14 10:21 | SOXX | SOXX260918P00500000 | put | 500.0000 | 2026-09-18 | 7.9000 | 7.9000 | 9.8000 | 500.0000 | 142200.00 | 0.00 | 142200.00 | 180 | 1 | 2817 | 9101 | 0.309526425667509 | 0.405573181433005 | 0.405573181433005 | false | true | false | true | ||||||||||||||||
| f46d9a36-9994-43ad-b383-1d5b2e0743d9 | 2026-09-09 12:12 | 2026-09-09 12:12 | 2026-09-09 12:12 | SOXX | SOXX261016P00490000 | put | 490.0000 | 2026-10-16 | 10.5000 | 10.5000 | 12.9000 | 530.6499 | 126000.00 | 0.00 | 126000.00 | 120 | 1 | 122 | 3122 | 0.0390775144138373 | 0.410638515736158 | 0.410638515736158 | false | true | false | true | ||||||||||||||||
| e772a93a-a581-47b2-b0e1-e7e0fa53515d | 2026-09-09 10:01 | 2026-09-09 10:01 | 2026-09-09 10:01 | SOXX | SOXX270319P00520000 | put | 520.0000 | 2027-03-19 | 53.5000 | 50.6000 | 55.9000 | 533.3050 | 802500.00 | 802500.00 | 0.00 | 150 | 1 | 150 | 374 | 0.401069518716578 | 0.434150952254279 | 0.434150952254279 | false | true | false | true | ||||||||||||||||
| f00be79f-e894-4ae2-9485-8cdec0ffbf83 | 2026-09-08 10:41 | 2026-09-08 10:41 | 2026-09-08 10:41 | SOXX | SOXX261218P00550000 | put | 550.0000 | 2026-12-18 | 53.8000 | 52.4000 | 56.5000 | 529.5950 | 538000.00 | 0.00 | 538000.00 | 100 | 1 | 100 | 490 | 0.204081632653061 | 0.41159269613406 | 0.41159269613406 | false | true | false | true | ||||||||||||||||
| 05de1006-c308-4e6c-bbdf-fcecc86112db | 2026-09-03 11:11 | 2026-09-03 11:11 | 2026-09-03 11:11 | SOXX | SOXX261120P00440000 | put | 440.0000 | 2026-11-20 | 13.3500 | 12.1000 | 14.7000 | 497.8000 | 126830.00 | 0.00 | 62510.00 | 95 | 2 | 96 | 14 | 6.85714285714286 | 0.420543614026966 | 0.420543614026966 | false | true | false | true | ||||||||||||||||
| 1fe3402e-9a71-4dde-aae9-41830a8a9cdd | 2026-09-02 11:19 | 2026-09-02 11:19 | 2026-09-02 11:19 | SOXX | SOXX261016C00580000 | call | 580.0000 | 2026-10-16 | 3.9500 | 3.7000 | 4.0000 | 501.5450 | 296250.00 | 296250.00 | 0.00 | 750 | 2 | 1002 | 1084 | 0.924354243542435 | 0.350107924998916 | 0.350107924998916 | false | true | false | true | ||||||||||||||||
| 63f6627f-e6e3-4219-8639-0c592769be17 | 2026-08-31 10:16 | 2026-08-31 10:16 | 2026-08-31 10:16 | SOXX | SOXX270917P00350000 | put | 350.0000 | 2027-09-17 | 21.5000 | 18.0000 | 26.9000 | 510.9200 | 215000.00 | 0.00 | 215000.00 | 100 | 1 | 100 | 71 | 1.40845070422535 | 0.474544403967851 | 0.474544403967851 | false | true | false | true | ||||||||||||||||
| 2f1567ae-9306-412d-b171-ea4bcfebeae8 | 2026-08-31 10:12 | 2026-08-31 10:12 | 2026-08-31 10:12 | SOXX | SOXX261120P00470000 | put | 470.0000 | 2026-11-20 | 20.9000 | 19.2000 | 23.0000 | 510.4900 | 418000.00 | 0.00 | 418000.00 | 200 | 1 | 200 | 575 | 0.347826086956522 | 0.428380999119811 | 0.428380999119811 | false | true | false | true | ||||||||||||||||
| 9931e671-b5c8-42f2-8b44-0ffb08c2bd17 | 2026-08-31 10:11 | 2026-08-31 10:11 | 2026-08-31 10:11 | SOXX | SOXX270416P00410000 | put | 410.0000 | 2027-04-16 | 23.5000 | 21.7000 | 26.6000 | 510.8850 | 352500.00 | 0.00 | 352500.00 | 150 | 1 | 150 | 13 | 11.5384615384615 | 0.45373645320659 | 0.45373645320659 | false | true | false | true | ||||||||||||||||
| 0aa348a4-cc44-4bb6-8900-92e22af8fc72 | 2026-08-26 15:02 | 2026-08-26 15:02 | 2026-08-26 15:02 | SOXX | SOXX270115C00660000 | call | 660.0000 | 2027-01-15 | 13.9400 | 13.2000 | 14.7000 | 515.6400 | 623120.00 | 250600.00 | 372520.00 | 447 | 2 | 447 | 68 | 6.57352941176471 | 0.403039480894465 | 0.403039480894465 | false | true | false | true | ||||||||||||||||
| af9639d9-b4a7-4040-8e6f-14ed6d58df3e | 2026-08-25 09:56 | 2026-08-25 09:56 | 2026-08-25 09:56 | SOXX | SOXX270115P00545000 | put | 545.0000 | 2027-01-15 | 67.6500 | 64.7000 | 70.3000 | 515.7500 | 4059000.00 | 4059000.00 | 0.00 | 600 | 2 | 600 | 39 | 15.3846153846154 | 0.432218226541223 | 0.432218226541223 | false | true | true | false | ||||||||||||||||
| 468146e9-a668-4d04-832c-3334fe7e6141 | 2026-08-24 12:45 | 2026-08-24 12:45 | 2026-08-24 12:45 | SOXX | SOXX270115P00385000 | put | 385.0000 | 2027-01-15 | 12.3000 | 11.7000 | 14.5000 | 506.0250 | 246000.00 | 0.00 | 246000.00 | 200 | 1 | 200 | 73 | 2.73972602739726 | 0.486985988245724 | 0.486985988245724 | false | true | false | true | ||||||||||||||||
| e5ee3550-e1ac-4a49-81aa-a16ec8b103cb | 2026-08-20 10:44 | 2026-08-20 10:44 | 2026-08-20 10:44 | SOXX | SOXX270617P00365000 | put | 365.0000 | 2027-06-17 | 20.9000 | 19.3000 | 24.4000 | 524.4300 | 522500.00 | 0.00 | 522500.00 | 250 | 1 | 250 | 265 | 0.943396226415094 | 0.505023916497162 | 0.505023916497162 | false | true | false | true | ||||||||||||||||
| a9f41321-297b-4676-bd2b-d88c8fe41b10 | 2026-08-19 13:11 | 2026-08-19 13:11 | 2026-08-19 13:11 | SOXX | SOXX270917P00400000 | put | 400.0000 | 2027-09-17 | 38.0000 | 37.4000 | 40.6000 | 520.9900 | 950000.00 | 0.00 | 950000.00 | 250 | 1 | 251 | 5 | 50.2 | 0.49552609996199 | 0.49552609996199 | false | true | false | true | ||||||||||||||||
| be1df4b2-fb29-4cce-b044-2a0e5884cebd | 2026-08-19 09:44 | 2026-08-19 09:44 | 2026-08-19 09:44 | SOXX | SOXX260918P00500000 | put | 500.0000 | 2026-09-18 | 14.4000 | 13.8000 | 14.4000 | 528.2200 | 2880000.00 | 2880000.00 | 0.00 | 2000 | 3 | 2004 | 6225 | 0.321927710843374 | 0.454962720209615 | 0.454962720209615 | false | true | true | false | ||||||||||||||||
| 84d739a6-275b-426b-920a-d29772cc9494 | 2026-08-18 15:13 | 2026-08-18 15:13 | 2026-08-18 15:13 | SOXX | SOXX260828P00525000 | put | 525.0000 | 2026-08-28 | 14.7000 | 13.9000 | 15.3000 | 527.5050 | 117600.00 | 117600.00 | 0.00 | 80 | 1 | 122 | 93 | 1.31182795698925 | 0.465943137477803 | 0.465943137477803 | false | true | false | true |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 45373849185.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 42262911204.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 42262911204.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41399564022.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41399564022.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 2 |
| ETF |
| — |
| 44181950633.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 44181950633.00 |
| — |
| — |
| 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 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 44181950633.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T16:21:26.040266Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 44181950633.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:11:22.686371Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41370759630.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:47:12.085652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41370759630.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:12:38.137640Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41370759630.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:25:17.297093Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41370759630.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41370759630.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41370759630.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41370759630.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:11:05.103195Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41370759630.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41370759630.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41370759630.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41370759630.00 |
| — |
| — |
| — |
| 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 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41370759630.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 41370759630.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |