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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 rowsrestricted — hover for the licence
active:option_symbol = GS260918P01000000×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9fa3bb05-7e5f-4827-875a-402e25169052 | 2026-09-17 14:38 | 2026-09-17 14:38 | 2026-09-17 14:38 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 47.5000 | 47.1500 | 48.9000 | 952.2800 | 95000.00 | 0.00 | 95000.00 | 20 | 5 | 98 | 2996 | 0.0327102803738318 | 0.67119071875307 | 0.664692845122698 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 277040859570.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 67f158da-8515-4242-9dba-5cf4aad2e019 | 2026-09-14 14:10 | 2026-09-14 14:10 | 2026-09-14 14:10 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 25.8000 | 22.8500 | 25.8000 | 984.0000 | 299280.00 | 299280.00 | 0.00 | 116 | 27 | 2404 | 4722 | 0.509106310885218 | 0.407706391293388 | 0.407706391293388 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3dcbc5d8-49ee-4864-8360-0daf325c2d7d | 2026-09-14 14:10 | 2026-09-14 14:10 | 2026-09-14 14:10 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 25.8000 | 22.8500 | 25.8000 | 984.0000 | 64500.00 | 64500.00 | 0.00 | 25 | 5 | 2273 | 4722 | 0.481363828886065 | 0.407706391293388 | 0.407706391293388 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 32de6d4c-adb5-4ddb-bc07-d0586b488978 | 2026-09-14 14:10 | 2026-09-14 14:10 | 2026-09-14 14:10 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 25.8000 | 23.2500 | 25.8000 | 983.5200 | 206400.00 | 206400.00 | 0.00 | 80 | 17 | 2484 | 4722 | 0.526048284625159 | 0.399750582989455 | 0.399750582989455 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2577f49d-3547-41a2-bfbe-dac1721e1daf | 2026-09-14 14:10 | 2026-09-14 14:10 | 2026-09-14 14:10 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 25.8000 | 25.6000 | 26.8000 | 983.2650 | 64500.00 | 51600.00 | 12900.00 | 25 | 6 | 2509 | 4722 | 0.53134265141889 | 0.395461789730916 | 0.395461789730916 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b8188f84-0cc6-4ffb-a15a-25dbde397496 | 2026-09-14 10:02 | 2026-09-14 10:02 | 2026-09-14 10:02 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 15.0200 | 13.9000 | 15.0500 | 1003.7000 | 210325.00 | 210325.00 | 0.00 | 140 | 8 | 905 | 4722 | 0.191656077933079 | 0.411169082369357 | 0.407276587596958 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:14:09.812180Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 888936da-d769-4634-a77f-cf45b4711dfc | 2026-09-11 15:24 | 2026-09-11 15:24 | 2026-09-11 15:24 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 7.9500 | 7.9500 | 8.2500 | 1028.3950 | 62010.00 | 0.00 | 57240.00 | 78 | 13 | 639 | 3890 | 0.16426735218509 | 0.340666623588217 | 0.340666623588217 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 495ddf1f-5677-48b3-a7da-3b36fe0405c2 | 2026-09-10 14:16 | 2026-09-10 14:15 | 2026-09-10 14:15 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 13.4000 | 13.4000 | 14.0000 | 1016.9200 | 83080.00 | 0.00 | 83080.00 | 62 | 31 | 321 | 3611 | 0.0888950429243977 | 0.354442410447593 | 0.354442410447593 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 05c1533d-7245-4af5-93ca-7773e603ec00 | 2026-09-10 09:40 | 2026-09-10 09:40 | 2026-09-10 09:40 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 14.0000 | 14.0000 | 15.1500 | 1021.2300 | 68600.00 | 0.00 | 68600.00 | 49 | 9 | 207 | 3611 | 0.0573248407643312 | 0.392191786495521 | 0.392191786495521 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T13:42:34.192825Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6508b231-3467-47fb-8657-31b037996e8a | 2026-09-10 09:40 | 2026-09-10 09:40 | 2026-09-10 09:40 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 14.0000 | 14.0000 | 15.3500 | 1020.8701 | 112000.00 | 0.00 | 112000.00 | 80 | 11 | 87 | 3611 | 0.0240930490168928 | 0.389968789615538 | 0.389968789615538 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T13:42:34.192825Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4b3ccc4b-8ac1-476f-ae49-b9b8af95d5d6 | 2026-09-10 09:40 | 2026-09-10 09:40 | 2026-09-10 09:40 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 14.0000 | 14.0000 | 15.1500 | 1020.8701 | 68600.00 | 0.00 | 68600.00 | 49 | 7 | 136 | 3611 | 0.0376626973137635 | 0.389968789615538 | 0.389968789615538 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T13:42:34.192825Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5964dde6-845b-47c1-880b-eb7835bd1e5b | 2026-09-04 10:59 | 2026-09-04 10:59 | 2026-09-04 10:59 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 12.4800 | 11.4500 | 13.4500 | 1025.4800 | 106093.00 | 83785.00 | 22308.00 | 85 | 12 | 172 | 2897 | 0.0593717638936831 | 0.296378448120549 | 0.296378448120549 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| db2ee0dd-6bd8-4cc1-aaf4-9433d9193e8f | 2026-09-03 10:12 | 2026-09-03 10:12 | 2026-09-03 10:12 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 15.0000 | 15.0000 | 16.4000 | 1024.7800 | 85525.00 | 1510.00 | 84015.00 | 57 | 7 | 301 | 2361 | 0.127488352393054 | 0.318925366017693 | 0.318925366017693 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a399a45f-eb76-43dd-b366-6cec0e73ee89 | 2026-09-03 10:04 | 2026-09-03 10:03 | 2026-09-03 10:03 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 13.9000 | 13.9000 | 14.9500 | 1029.9950 | 77840.00 | 0.00 | 77840.00 | 56 | 56 | 95 | 2361 | 0.0402371876323592 | 0.326524672521196 | 0.326524672521196 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | 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 |
| 317d8a7d-c37f-4d5c-8f66-f2fb66c05982 | 2026-08-31 09:54 | 2026-08-31 09:54 | 2026-08-31 09:54 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 17.4000 | 15.9500 | 17.4500 | 1025.6300 | 128760.00 | 64565.00 | 64195.00 | 74 | 6 | 1017 | 1183 | 0.859678782755706 | 0.324271878391743 | 0.325470458405393 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:02:22.723941Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9c0d57dd-6c74-4815-9bbb-dc790265792a | 2026-08-31 09:45 | 2026-08-31 09:45 | 2026-08-31 09:45 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 16.7000 | 16.7000 | 17.7500 | 1028.1900 | 81830.00 | 0.00 | 81830.00 | 49 | 24 | 460 | 1183 | 0.388841927303466 | 0.322865418690434 | 0.326735117681799 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 657a56db-c1ab-413d-87cf-d7028441bdbd | 2026-08-31 09:42 | 2026-08-31 09:42 | 2026-08-31 09:42 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 16.3000 | 16.3000 | 17.4500 | 1028.5200 | 190714.00 | 0.00 | 190714.00 | 117 | 35 | 382 | 1183 | 0.3229078613694 | 0.323185474993992 | 0.323185474993992 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b0cbbf90-dd88-4852-be7b-09e4775937eb | 2026-08-26 09:30 | 2026-08-26 09:30 | 2026-08-26 09:30 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 12.7900 | 9.9500 | 12.9500 | 1054.6300 | 157300.00 | 112855.00 | 44445.00 | 123 | 15 | 123 | 1027 | 0.119766309639727 | 0.332517148166709 | 0.331908821215173 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 88d02c88-6e6d-410a-ba73-74141be92a3b | 2026-08-26 09:30 | 2026-08-26 09:30 | 2026-08-26 09:30 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 12.9700 | 11.4500 | 14.6500 | 1054.6300 | 172445.00 | 95270.00 | 77175.00 | 133 | 28 | 282 | 1027 | 0.274586173320351 | 0.3337323323279 | 0.336761879252757 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 09f8c94f-6012-4d59-bb37-a64d0785feef | 2026-08-18 10:12 | 2026-08-18 10:12 | 2026-08-18 10:12 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 22.2000 | 19.9500 | 22.2000 | 1033.2300 | 270840.00 | 270840.00 | 0.00 | 122 | 25 | 128 | 873 | 0.146620847651775 | 0.319270172356249 | 0.319270172356249 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d120b317-c313-4252-b202-d577d0312546 | 2026-08-17 09:47 | 2026-08-17 09:47 | 2026-08-17 09:47 | GS | GS260918P01000000 | put | 1000.0000 | 2026-09-18 | 17.7000 | 16.7000 | 18.6500 | 1047.8500 | 56640.00 | 31860.00 | 24780.00 | 32 | 5 | 54 | 868 | 0.0622119815668203 | 0.314241016720113 | 0.314241016720113 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 287808378238.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |