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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34ac682b-1d07-4ff9-a30c-77aa4ff66ec0 | 2026-09-16 15:48 | 2026-09-16 15:48 | 2026-09-16 15:48 | AGI | AGI270115C00043000 | call | 43.0000 | 2027-01-15 | 1.6000 | 1.6000 | 1.7000 | 34.0000 | 35840.00 | 0.00 | 35840.00 | 224 | 7 | 5974 | 10025 | 0.595910224438903 | 0.521723898226644 | 0.521723898226644 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 14464202631.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| b5dfb6c0-6ebf-422f-a259-0c429b585dcb | 2026-09-16 15:49 | 2026-09-16 15:49 | 2026-09-16 15:49 | AGI | AGI270115C00043000 | call | 43.0000 | 2027-01-15 | 1.6500 | 1.6500 | 1.7000 | 34.0000 | 94050.00 | 0.00 | 88935.00 | 570 | 16 | 6570 | 10025 | 0.655361596009975 | 0.528479426298105 | 0.528479426298105 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 14464202631.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 036533fc-af1c-48b6-a164-d3883392cf26 | 2026-09-16 15:51 | 2026-09-16 15:51 | 2026-09-16 15:51 | AGI | AGI270115C00043000 | call | 43.0000 | 2027-01-15 | 1.6500 | 1.6500 | 1.7000 | 34.0000 | 10395.00 | 0.00 | 10395.00 | 63 | 5 | 6678 | 10025 | 0.666134663341646 | 0.527402196951905 | 0.527402196951905 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 14464202631.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 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 |
| f1570219-1952-4276-9786-93c4ae8799b7 | 2026-09-17 10:06 | 2026-09-17 10:06 | 2026-09-17 10:06 | AGI | AGI270115C00043000 | call | 43.0000 | 2027-01-15 | 2.1500 | 2.1000 | 2.2500 | 35.8500 | 224890.00 | 11825.00 | 206400.00 | 1046 | 23 | 2434 | 7208 | 0.337680355160932 | 0.53076695905434 | 0.53076695905434 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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 |
| 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 |
| bd98ad58-a0ac-4623-b26b-daf2b4b62d19 | 2026-09-17 13:09 | 2026-09-17 13:09 | 2026-09-17 13:09 | AGI | AGI270115P00032000 | put | 32.0000 | 2027-01-15 | 2.2500 | 2.1000 | 2.5000 | 35.9400 | 50625.00 | 50400.00 | 225.00 | 225 | 8 | 228 | 2177 | 0.104731281580156 | 0.530412833254901 | 0.530210669773416 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-17T17:10:56.508407Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 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 |
| 49e3b307-4998-4785-aaf8-299d7d9519e2 | 2026-09-18 13:18 | 2026-09-18 13:18 | 2026-09-18 13:18 | AGI | AGI261016P00031000 | put | 31.0000 | 2026-10-16 | 0.2500 | 0.2500 | 0.3500 | 35.9300 | 14950.00 | 0.00 | 14950.00 | 598 | 15 | 602 | 339 | 1.77581120943953 | 0.461836775860409 | 0.461836775860409 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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 |
| 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 |
| 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 |
| 6145e451-bf1e-4ecf-8b1f-079e53f78a27 | 2026-09-21 14:14 | 2026-09-21 14:14 | 2026-09-21 14:14 | AGI | AGI261016P00031000 | put | 31.0000 | 2026-10-16 | 0.3000 | 0.3000 | 0.4000 | 35.0500 | 22500.00 | 0.00 | 22500.00 | 750 | 27 | 758 | 923 | 0.821235102925244 | 0.458021310420673 | 0.458021310420673 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 14783296796.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:15:35.599753Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |