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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| e0869337-c75d-4150-aed3-3affba38fade | 2026-08-17 10:54 | 2026-08-17 10:54 | 2026-08-17 10:54 | ALM | ALM260918P00015000 | put | 15.0000 | 2026-09-18 | 1.0500 | 1.0000 | 1.1000 | 16.4672 | 10498.00 | 9973.00 | 210.00 | 100 | 5 | 350 | 289 | 1.21107266435986 | 0.920858435757989 | 0.920858435757989 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 74b38f3b-d4a2-42d3-8b93-a3592edf2eaf | 2026-08-20 14:59 | 2026-08-20 14:59 | 2026-08-20 14:59 | ALM | ALM261120C00020000 | call | 20.0000 | 2026-11-20 | 2.3500 | 2.0000 | 2.4000 | 17.5400 | 25850.00 | 18330.00 | 0.00 | 110 | 6 | 514 | 1021 | 0.503428011753183 | 0.907829108127097 | 0.907829108127097 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 41b2d5a6-34e2-43e2-b7fb-3acb2c22abb2 | 2026-08-21 10:42 | 2026-08-21 10:42 | 2026-08-21 10:42 | ALM | ALM270115C00025000 | call | 25.0000 | 2027-01-15 | 2.3000 | 2.1500 | 2.3500 | 18.4900 | 11270.00 | 690.00 | 10580.00 | 49 | 6 | 244 | 16 | 15.25 | 0.887094214406804 | 0.887094214406804 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:50:41.871179Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 89d15c00-d4fc-4487-ac39-eb4a05e97622 | 2026-08-24 12:54 | 2026-08-24 12:53 | 2026-08-24 12:53 | ALM | ALM270617C00020000 | call | 20.0000 | 2027-06-17 | 4.8000 | 4.8000 | 5.3000 | 18.1000 | 14400.00 | 0.00 | 11520.00 | 30 | 5 | 30 | 259 | 0.115830115830116 | 0.82054102375951 | 0.82054102375951 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | 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 |
| e590ebbe-6fcb-4d8c-b4c5-ed8154750498 | 2026-08-24 14:17 | 2026-08-24 14:17 | 2026-08-24 14:17 | ALM | ALM260918C00020000 | call | 20.0000 | 2026-09-18 | 1.1000 | 1.0000 | 1.1000 | 18.1400 | 10010.00 | 10010.00 | 0.00 | 91 | 7 | 1567 | 3079 | 0.508931471256902 | 0.941720609021023 | 0.941720609021023 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 429d5938-2ad6-471d-b684-700b07d7de01 | 2026-08-27 15:40 | 2026-08-27 15:40 | 2026-08-27 15:40 | ALM | ALM261016C00020000 | call | 20.0000 | 2026-10-16 | 1.9000 | 1.9000 | 1.9000 | 18.9350 | 100510.00 | 0.00 | 0.00 | 529 | 29 | 531 | 37 | 14.3513513513514 | 0.822838431270203 | 0.822838431270203 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:52:49.177007Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6092fdb0-1df0-4300-9fb3-e79e174773f1 | 2026-08-27 15:47 | 2026-08-27 15:47 | 2026-08-27 15:47 | ALM | ALM261016C00020000 | call | 20.0000 | 2026-10-16 | 1.9500 | 1.9000 | 1.9500 | 18.9450 | 24375.00 | 11115.00 | 0.00 | 125 | 13 | 658 | 37 | 17.7837837837838 | 0.838938958300059 | 0.838938958300059 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:52:49.177007Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 62e7508c-2201-447a-9f0d-e8b89bcf8399 | 2026-08-27 15:54 | 2026-08-27 15:54 | 2026-08-27 15:54 | ALM | ALM261016C00020000 | call | 20.0000 | 2026-10-16 | 1.8000 | 1.7500 | 2.1500 | 18.8400 | 23220.00 | 2160.00 | 21060.00 | 129 | 11 | 797 | 37 | 21.5405405405405 | 0.803703958566002 | 0.803703958566002 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T13:32:48.312014Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3186049d-0894-41b2-879d-028b3b9fabb5 | 2026-09-01 14:03 | 2026-09-01 14:03 | 2026-09-01 14:03 | ALM | ALM260918P00015000 | put | 15.0000 | 2026-09-18 | 0.3000 | 0.3000 | 0.5000 | 17.8450 | 10800.00 | 0.00 | 1830.00 | 360 | 11 | 948 | 2867 | 0.330659225671434 | 0.882714894665563 | 0.882714894665563 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:15:43.135015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 734cb7f1-213a-42d5-9b5d-b1ea826cf7cb | 2026-09-02 14:43 | 2026-09-02 14:43 | 2026-09-02 14:43 | ALM | ALM261218P00015000 | put | 15.0000 | 2026-12-18 | 1.9500 | 1.8000 | 2.5500 | 16.7800 | 13260.00 | 5070.00 | 8190.00 | 68 | 13 | 91 | 1610 | 0.0565217391304348 | 0.834146715171035 | 0.834146715171035 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:08:56.003529Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c73b70b1-51e9-4c88-869b-18950db2b041 | 2026-09-03 11:49 | 2026-09-03 11:49 | 2026-09-03 11:49 | ALM | ALM261016C00022500 | call | 22.5000 | 2026-10-16 | 0.5500 | 0.5500 | 0.6500 | 17.4100 | 16775.00 | 0.00 | 16775.00 | 305 | 12 | 1786 | 29 | 61.5862068965517 | 0.809818826519646 | 0.814819849456533 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7668580c-6947-43ce-a620-f3479b71ca8f | 2026-09-08 15:43 | 2026-09-08 15:43 | 2026-09-08 15:43 | ALM | ALM260918C00017500 | call | 17.5000 | 2026-09-18 | 2.2500 | 2.1500 | 2.3000 | 19.2500 | 11250.00 | 450.00 | 450.00 | 50 | 5 | 155 | 3446 | 0.0449796865931515 | 0.956060905118839 | 0.956060905118839 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1cc81f16-108e-443e-9c0b-b108ef18d206 | 2026-09-11 13:15 | 2026-09-11 13:15 | 2026-09-11 13:15 | ALM | ALM260918P00015000 | put | 15.0000 | 2026-09-18 | 0.7500 | 0.6500 | 0.7500 | 14.9750 | 35175.00 | 35175.00 | 0.00 | 469 | 6 | 622 | 3026 | 0.205551883674818 | 0.898357747268439 | 0.898357747268439 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T17:27:08.545704Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fe76be6d-9eca-4e06-9391-6ce2a3f3cbd0 | 2026-09-14 10:05 | 2026-09-14 10:04 | 2026-09-14 10:04 | ALM | ALM270115C00020000 | call | 20.0000 | 2027-01-15 | 1.6000 | 1.5000 | 1.8000 | 15.1950 | 32000.00 | 23360.00 | 8640.00 | 200 | 5 | 400 | 869 | 0.46029919447641 | 0.852388866493253 | 0.852964990230755 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3862810552.00 | 2026-11-02 | unknown | — | 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 |
| a9781ee2-e4ef-45b9-9d05-35c01553f38f | 2026-09-17 10:08 | 2026-09-17 10:08 | 2026-09-17 10:08 | ALM | ALM270115C00012500 | call | 12.5000 | 2027-01-15 | 3.6000 | 3.4000 | 3.6000 | 14.0500 | 46800.00 | 46800.00 | 0.00 | 130 | 24 | 140 | 113 | 1.23893805309735 | 0.889136273478753 | 0.889136273478753 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3713028102.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| afb56cc4-d995-4365-a5a8-3fde5b333fd5 | 2026-09-17 10:13 | 2026-09-17 10:13 | 2026-09-17 10:13 | ALM | ALM261016C00015000 | call | 15.0000 | 2026-10-16 | 1.0500 | 1.0500 | 1.1000 | 14.1600 | 18165.00 | 0.00 | 14070.00 | 173 | 7 | 268 | 123 | 2.17886178861789 | 0.87602187025377 | 0.864433734000354 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3713028102.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |