Simplify AnalyticsOptions flow alerts (market-wide)
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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | true | 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 |
| 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 | false | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | false | 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 |
| 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 | true | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | true | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |