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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| b8c2f77a-790a-49c4-9a60-bfc52ce05d9b | 2026-08-24 10:40 | 2026-08-24 10:40 | 2026-08-24 10:40 | RUTW | RUTW260930P02970000 | put | 2970.0000 | 2026-09-30 | 50.6000 | 49.8000 | 50.6000 | 3005.9104 | 263120.00 | 263120.00 | 0.00 | 52 | 6 | 200 | 96 | 2.08333333333333 | 0.189568716637795 | 0.189568716637795 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 57133c73-e37b-411d-aba5-c45817064b90 | 2026-08-24 10:40 | 2026-08-24 10:40 | 2026-08-24 10:40 | RUTW | RUTW260930P02970000 | put | 2970.0000 | 2026-09-30 | 50.4000 | 49.7000 | 50.5000 | 3005.9104 | 342720.00 | 342720.00 | 0.00 | 68 | 5 | 72 | 96 | 0.75 | 0.189021838696616 | 0.189021838696616 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f1e6d116-b012-4ab3-b8e6-000368060334 | 2026-08-27 13:44 | 2026-08-27 13:44 | 2026-08-27 13:44 | RUTW | RUTW260901P03010000 | put | 3010.0000 | 2026-09-01 | 16.1000 | 15.5000 | 16.1000 | 3018.5578 | 152950.00 | 152950.00 | 0.00 | 95 | 9 | 96 | 3 | 32 | 0.147617105443907 | 0.147617105443907 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:46:53.178792Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d8631548-d18c-46c3-9380-653f913955ae | 2026-08-28 16:04 | 2026-08-28 16:04 | 2026-08-28 16:04 | RUTW | RUTW260904C02980000 | call | 2980.0000 | 2026-09-04 | 20.7000 | 20.7000 | 21.5000 | 2972.3719 | 511290.00 | 0.00 | 511290.00 | 247 | 15 | 397 | 42 | 9.45238095238095 | 0.141907017204192 | 0.141907017204192 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c5944264-0df2-4aa5-8082-c4641226cba9 | 2026-09-01 15:01 | 2026-09-01 15:01 | 2026-09-01 15:01 | RUTW | RUTW260909P02950000 | put | 2950.0000 | 2026-09-09 | 41.2400 | 41.1000 | 42.3000 | 2921.0854 | 412360.00 | 148680.00 | 263680.00 | 100 | 7 | 300 | 6 | 50 | 0.149264716753603 | 0.149264716753603 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T19:21:20.162349Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c3f9ea3b-3503-4a27-8902-db11214e9f89 | 2026-09-04 16:01 | 2026-09-04 16:01 | 2026-09-04 16:01 | RUTW | RUTW260911C02975000 | call | 2975.0000 | 2026-09-11 | 21.7000 | 21.6500 | 22.6000 | 2975.6448 | 1302000.00 | 776860.00 | 486080.00 | 600 | 21 | 689 | 66 | 10.4393939393939 | 0.12326166859237 | 0.12326166859237 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T13:33:29.575205Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 47879262-b972-4690-8c67-d334df662543 | 2026-09-08 15:52 | 2026-09-08 15:52 | 2026-09-08 15:52 | RUTW | RUTW260930C03050000 | call | 3050.0000 | 2026-09-30 | 15.0000 | 15.0000 | 15.6000 | 2963.9274 | 150000.00 | 0.00 | 150000.00 | 100 | 5 | 122 | 170 | 0.717647058823529 | 0.148260257798388 | 0.148260257798388 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:30:57.501605Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9d321848-f553-4dc6-bff5-0e44853fee23 | 2026-09-10 09:48 | 2026-09-10 09:48 | 2026-09-10 09:48 | RUTW | RUTW260918P02870000 | put | 2870.0000 | 2026-09-18 | 26.1000 | 25.6000 | 26.2000 | 2900.3315 | 109620.00 | 109620.00 | 0.00 | 42 | 5 | 42 | 217 | 0.193548387096774 | 0.237023968244073 | 0.237023968244073 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T13:52:43.061304Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9a79aff2-a7e8-457d-90ec-7e920c717b53 | 2026-09-10 12:40 | 2026-09-10 12:39 | 2026-09-10 12:39 | RUTW | RUTW260924P02840000 | put | 2840.0000 | 2026-09-24 | 25.5000 | 25.5000 | 26.2000 | 2885.0000 | 145350.00 | 0.00 | 145350.00 | 57 | 5 | 57 | 2 | 28.5 | 0.222011957683421 | 0.222011957683421 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T17:02:16.286608Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ec73999c-2845-410e-9a75-9928d9e5ab80 | 2026-09-15 09:52 | 2026-09-15 09:52 | 2026-09-15 09:52 | RUTW | RUTW260916P02995000 | put | 2995.0000 | 2026-09-16 | 119.4000 | 118.2000 | 120.2000 | 2875.2704 | 143280.00 | 11940.00 | 131340.00 | 12 | 12 | 12 | 4 | 3 | 0.418577425980078 | 0.418577425980078 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 0c7d676d-afcb-4557-9fe6-40bedc7d5eeb | 2026-09-16 11:03 | 2026-09-16 11:03 | 2026-09-16 11:03 | RUTW | RUTW260918C02900000 | call | 2900.0000 | 2026-09-18 | 16.5000 | 16.4000 | 16.8000 | 2882.0007 | 224400.00 | 127050.00 | 97350.00 | 136 | 19 | 184 | 1252 | 0.146964856230032 | 0.283512510247576 | 0.283512510247576 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| eab1563c-7c64-4ca7-8f5d-e24b700b31b5 | 2026-09-16 14:58 | 2026-09-16 14:58 | 2026-09-16 14:58 | RUTW | RUTW260918C02870000 | call | 2870.0000 | 2026-09-18 | 15.0000 | 14.7000 | 15.3000 | 2856.6886 | 192000.00 | 22500.00 | 154500.00 | 128 | 14 | 151 | 22 | 6.86363636363636 | 0.24520417179356 | 0.24520417179356 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| e93d59de-a385-48fb-9290-6a8ac8660e93 | 2026-09-17 09:35 | 2026-09-17 09:35 | 2026-09-17 09:35 | RUTW | RUTW260918C02870000 | call | 2870.0000 | 2026-09-18 | 29.0000 | 28.8000 | 29.7000 | 2895.3597 | 429200.00 | 23200.00 | 406000.00 | 148 | 5 | 201 | 532 | 0.37781954887218 | 0.200354474504092 | 0.200354474504092 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| e1aac64c-df31-4fcc-8251-3e1afc754525 | 2026-09-18 10:11 | 2026-09-18 10:11 | 2026-09-18 10:11 | RUTW | RUTW261002P02760000 | put | 2760.0000 | 2026-10-02 | 12.3800 | 11.9000 | 12.4000 | 2850.9790 | 101550.00 | 101550.00 | 0.00 | 82 | 6 | 727 | 357 | 2.03641456582633 | 0.204543712819963 | 0.203888857453212 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 30306db9-0b6f-4600-83eb-657063d5d511 | 2026-09-21 11:05 | 2026-09-21 11:05 | 2026-09-21 11:05 | RUTW | RUTW260921P02870000 | put | 2870.0000 | 2026-09-21 | 1.2000 | 0.8000 | 1.5500 | 2875.6518 | 16560.00 | 9480.00 | 7080.00 | 138 | 8 | 770 | 210 | 3.66666666666667 | 0.121541345021998 | 0.121541345021998 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:05:23.809831Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 1a6b398c-3f14-49c3-b26e-72f586333fc8 | 2026-09-21 11:05 | 2026-09-21 11:05 | 2026-09-21 11:05 | RUTW | RUTW260921C02880000 | call | 2880.0000 | 2026-09-21 | 3.1000 | 2.7500 | 3.1000 | 2875.9438 | 31000.00 | 31000.00 | 0.00 | 100 | 5 | 472 | 190 | 2.48421052631579 | 0.177893022271867 | 0.177893022271867 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 12143b7d-dc96-4297-9fbc-fabc67ace75e | 2026-09-21 11:05 | 2026-09-21 11:05 | 2026-09-21 11:05 | RUTW | RUTW260921C02880000 | call | 2880.0000 | 2026-09-21 | 2.9000 | 2.2500 | 3.2000 | 2876.0252 | 58000.00 | 31320.00 | 26680.00 | 200 | 12 | 672 | 190 | 3.53684210526316 | 0.169092103279423 | 0.169092103279423 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 4a0c47ae-02e8-40c2-9607-85f9a260fd51 | 2026-09-21 11:17 | 2026-09-21 11:17 | 2026-09-21 11:17 | RUTW | RUTW260921C02880000 | call | 2880.0000 | 2026-09-21 | 3.9000 | 3.5000 | 4.5000 | 2879.6472 | 99060.00 | 0.00 | 99060.00 | 254 | 8 | 985 | 190 | 5.18421052631579 | 0.1518986703198 | 0.1518986703198 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:19:12.034191Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| e53ff90f-ddba-4c58-9761-b7947965f274 | 2026-09-21 14:33 | 2026-09-21 14:33 | 2026-09-21 14:33 | RUTW | RUTW260925P02850000 | put | 2850.0000 | 2026-09-25 | 7.6000 | 7.6000 | 8.0000 | 2880.7253 | 10640.00 | 0.00 | 10640.00 | 14 | 5 | 51 | 914 | 0.0557986870897155 | 0.163563305249006 | 0.163563305249006 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:37:54.025147Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 662fdb12-b115-487b-a72b-973ea4e82e13 | 2026-09-21 15:47 | 2026-09-21 15:47 | 2026-09-21 15:47 | RUTW | RUTW260924P02930000 | put | 2930.0000 | 2026-09-24 | 50.2000 | 49.7000 | 50.5000 | 2870.0000 | 25100.00 | 25100.00 | 0.00 | 5 | 5 | 6 | 8 | 0.75 | 0.14622503425988 | 0.14622503425988 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:50:07.722851Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |