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
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| a3860fe7-e92b-4292-944f-14dedfedfe20 | 2026-09-18 15:50 | 2026-09-18 15:49 | 2026-09-18 15:49 | AGI | AGI261120C00042000 | call | 42.0000 | 2026-11-20 | 1.2000 | 1.0500 | 1.2000 | 35.8250 | 48580.00 | 48580.00 | 0.00 | 405 | 33 | 466 | 100 | 4.66 | 0.523460302583302 | 0.523460302583302 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 14997425776.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 405d0655-d745-4fd2-b0d8-b441be04e2e8 | 2026-09-18 14:22 | 2026-09-18 14:22 | 2026-09-18 14:22 | AGI | AGI270115C00043000 | call | 43.0000 | 2027-01-15 | 2.0000 | 1.9500 | 2.2000 | 36.0000 | 17185.00 | 200.00 | 16985.00 | 86 | 25 | 88 | 8110 | 0.0108508014796547 | 0.50764247672893 | 0.500959705346893 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 14997425776.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 0d23b380-7934-46a5-bc73-c3444f3968c0 | 2026-09-18 13:18 | 2026-09-18 13:18 | 2026-09-18 13:18 | AGI | AGI261016C00036000 | call | 36.0000 | 2026-10-16 | 1.8700 | 1.7000 | 2.0500 | 35.9300 | 93328.00 | 23312.00 | 70016.00 | 500 | 5 | 508 | 515 | 0.986407766990291 | 0.469141038517037 | 0.469141038517037 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 14997425776.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 5f428b13-8a96-4e84-81a3-63d4cc723ee5 | 2026-09-17 10:42 | 2026-09-17 10:42 | 2026-09-17 10:42 | AGI | AGI260918C00031000 | call | 31.0000 | 2026-09-18 | 4.8700 | 4.8000 | 5.2000 | 35.8800 | 24344.00 | 0.00 | 24344.00 | 50 | 6 | 102 | 8113 | 0.0125724146431653 | 2.57424207216335 | 2.57424207216335 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 15014220205.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:48:09.438351Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 4fc95855-b136-45d7-88ee-fb5ffffc04a4 | 2026-09-17 09:58 | 2026-09-17 09:58 | 2026-09-17 09:58 | AGI | AGI270115C00043000 | call | 43.0000 | 2027-01-15 | 2.1000 | 1.9000 | 2.3000 | 35.6800 | 256600.00 | 253870.00 | 0.00 | 1222 | 40 | 1234 | 7208 | 0.171198668146504 | 0.53185061642343 | 0.53185061642343 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 15014220205.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:07:38.635762Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 8245fdfd-a35f-45a9-b095-789ad9a3075d | 2026-09-11 14:57 | 2026-09-11 14:57 | 2026-09-11 14:57 | AGI | AGI261218C00045000 | call | 45.0000 | 2026-12-18 | 1.3000 | 1.0500 | 1.3500 | 35.7000 | 115415.00 | 99170.00 | 16245.00 | 888 | 25 | 5840 | 14478 | 0.403370631302666 | 0.531190203194754 | 0.522679632578886 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 14972234131.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2ef0548f-e7fd-4854-bc99-c1be8d3cc328 | 2026-09-09 09:54 | 2026-09-09 09:54 | 2026-09-09 09:54 | AGI | AGI261218C00045000 | call | 45.0000 | 2026-12-18 | 1.8700 | 1.8000 | 1.9000 | 37.2300 | 46283.00 | 188.00 | 40545.00 | 248 | 11 | 332 | 10428 | 0.031837360951285 | 0.546845911396883 | 0.542508154968999 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 14972234131.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e357eef3-4a74-4d80-a292-bb915e056764 | 2026-09-04 13:34 | 2026-09-04 13:33 | 2026-09-04 13:33 | AGI | AGI261016P00041000 | put | 41.0000 | 2026-10-16 | 5.0000 | 4.9000 | 5.2000 | 37.1250 | 302991.00 | 302491.00 | 500.00 | 606 | 46 | 606 | 65 | 9.32307692307692 | 0.526793864932016 | 0.526793864932016 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 14972234131.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2d62fb1b-841f-46c1-b7f1-ad4af75dc96c | 2026-08-28 12:25 | 2026-08-28 12:25 | 2026-08-28 12:25 | AGI | AGI260918P00032000 | put | 32.0000 | 2026-09-18 | 0.3000 | 0.2500 | 0.3000 | 36.3800 | 17388.00 | 17388.00 | 0.00 | 580 | 34 | 1703 | 320 | 5.321875 | 0.50715565160321 | 0.50715565160321 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 14972234131.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:25:17.992358Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 937194ad-b54b-49dc-aabb-513f8a34381c | 2026-08-24 11:32 | 2026-08-24 11:32 | 2026-08-24 11:32 | AGI | AGI261218C00044000 | call | 44.0000 | 2026-12-18 | 2.9000 | 2.5500 | 2.9000 | 38.0100 | 215450.00 | 215450.00 | 0.00 | 743 | 38 | 743 | 1972 | 0.376774847870183 | 0.568050464509153 | 0.568050464509153 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 14972234131.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:49:37.820281Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d64733ad-7d22-4621-91d8-33e5a6afa954 | 2026-08-24 10:34 | 2026-08-24 10:34 | 2026-08-24 10:34 | AGI | AGI260918P00036000 | put | 36.0000 | 2026-09-18 | 1.0500 | 1.0500 | 1.1500 | 38.3000 | 10310.00 | 0.00 | 10310.00 | 98 | 7 | 122 | 332 | 0.367469879518072 | 0.529311129959481 | 0.523533003029963 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 14972234131.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:35:34.147296Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d417b859-eacd-41c8-82d9-e16083e9ad4c | 2026-08-19 09:48 | 2026-08-19 09:47 | 2026-08-19 09:47 | AGI | AGI260918C00035000 | call | 35.0000 | 2026-09-18 | 2.4700 | 2.4500 | 2.7000 | 35.7099 | 36863.00 | 17748.00 | 19115.00 | 149 | 26 | 462 | 681 | 0.6784140969163 | 0.513979821159015 | 0.511944226966334 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 14972234131.00 | 2026-11-04 | unknown | — | 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 |
| bf629b3a-06b5-46d0-ac1e-a5060bbc8506 | 2026-08-19 09:48 | 2026-08-19 09:47 | 2026-08-19 09:47 | AGI | AGI260918C00039000 | call | 39.0000 | 2026-09-18 | 1.0000 | 0.9500 | 1.0000 | 35.6962 | 13391.00 | 13391.00 | 0.00 | 134 | 30 | 339 | 578 | 0.586505190311419 | 0.526296401132431 | 0.526296401132431 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 14972234131.00 | 2026-11-04 | unknown | — | 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 |
| 33e95d57-17ae-429b-9733-56cf2b7fe66f | 2026-08-18 15:44 | 2026-08-18 15:44 | 2026-08-18 15:44 | AGI | AGI261218C00036000 | call | 36.0000 | 2026-12-18 | 3.0000 | 2.7000 | 3.0000 | 33.0400 | 65972.00 | 65972.00 | 0.00 | 220 | 25 | 228 | 3539 | 0.0644249788075728 | 0.523898793494671 | 0.523898793494671 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 14972234131.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 094be8ed-4cf3-46f0-bd29-d5eb7a27a5e9 | 2026-08-17 14:38 | 2026-08-17 14:37 | 2026-08-17 14:37 | AGI | AGI261218C00041000 | call | 41.0000 | 2026-12-18 | 2.0500 | 1.8000 | 2.1000 | 34.0400 | 126055.00 | 125645.00 | 205.00 | 615 | 45 | 615 | 4 | 153.75 | 0.531814619477644 | 0.531814619477644 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 14972234131.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |