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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9e538999-a87d-4fdd-bf9e-a8c97e8918ee | 2026-09-16 15:26 | 2026-09-16 15:25 | 2026-09-16 15:25 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 30.0000 | 29.4600 | 30.1100 | 700.6800 | 152999.00 | 152999.00 | 0.00 | 51 | 6 | 125 | 635 | 0.196850393700787 | 0.214662663799596 | 0.214662663799596 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:29:08.379560Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 13456789-59ef-4344-93e2-6018e97f1d54 | 2026-09-18 15:55 | 2026-09-18 15:55 | 2026-09-18 15:55 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 10.8100 | 10.8000 | 10.9900 | 721.0000 | 108115.00 | 0.00 | 108115.00 | 100 | 5 | 151 | 650 | 0.232307692307692 | 0.142584168295568 | 0.143847815834102 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 485431540564.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 06ce91e0-39b9-4c24-a971-a7a9598f2dd1 | 2026-09-21 10:33 | 2026-09-21 10:33 | 2026-09-21 10:33 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 3.0800 | 3.0700 | 3.0800 | 735.1540 | 28028.00 | 28028.00 | 0.00 | 91 | 7 | 4074 | 736 | 5.53532608695652 | 0.175850358282393 | 0.175850358282393 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:34:41.643622Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 974ef2af-3a6d-456f-a292-8024327f6396 | 2026-09-21 10:33 | 2026-09-21 10:33 | 2026-09-21 10:33 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 3.0900 | 3.0800 | 3.0900 | 735.1300 | 64581.00 | 64581.00 | 0.00 | 209 | 17 | 4283 | 736 | 5.81929347826087 | 0.175916150303113 | 0.175916150303113 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:34:41.643622Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 325a164d-daff-4f49-86c5-17e630ed436d | 2026-09-21 10:57 | 2026-09-21 10:56 | 2026-09-21 10:56 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 2.9000 | 2.8900 | 2.9100 | 735.4700 | 11590.00 | 0.00 | 11590.00 | 40 | 5 | 5396 | 736 | 7.33152173913043 | 0.17318721695571 | 0.172827721723693 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:59:04.068372Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 4a9ee7c8-f5c0-4d01-b8bf-bf8f5f651fca | 2026-09-21 11:11 | 2026-09-21 11:11 | 2026-09-21 11:11 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 2.7700 | 2.7600 | 2.7700 | 736.0000 | 55400.00 | 55400.00 | 0.00 | 200 | 15 | 6024 | 736 | 8.18478260869565 | 0.176035298025925 | 0.176035298025925 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:13:03.739619Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| b78252ce-48bb-4b2d-96d8-3370ff3936b3 | 2026-09-21 11:29 | 2026-09-21 11:29 | 2026-09-21 11:29 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 2.7100 | 2.7100 | 2.7200 | 736.4150 | 150405.00 | 0.00 | 150405.00 | 555 | 21 | 6972 | 736 | 9.47282608695652 | 0.177194211266756 | 0.177194211266756 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:32:21.239106Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 38f2a1c2-60be-497c-a1e1-c5385cfcca21 | 2026-09-21 12:52 | 2026-09-21 12:52 | 2026-09-21 12:52 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 2.3100 | 2.3100 | 2.3200 | 738.0000 | 41349.00 | 0.00 | 41349.00 | 179 | 18 | 9620 | 736 | 13.070652173913 | 0.184707914920559 | 0.184707914920559 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| dc8e5229-e642-4096-9e5a-084a1821a1e5 | 2026-09-21 13:14 | 2026-09-21 13:14 | 2026-09-21 13:14 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 2.1700 | 2.1600 | 2.1800 | 739.0900 | 38626.00 | 4340.00 | 33201.00 | 178 | 8 | 10116 | 736 | 13.7445652173913 | 0.185081688699838 | 0.185081688699838 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:16:02.178873Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 523036d5-5218-4cdb-8118-0121028a358c | 2026-09-21 14:08 | 2026-09-21 14:08 | 2026-09-21 14:08 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 2.0100 | 2.0100 | 2.0200 | 739.0000 | 13467.00 | 0.00 | 13467.00 | 67 | 6 | 12168 | 736 | 16.5326086956522 | 0.187297227250705 | 0.187297227250705 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:09:57.736377Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 2a103ca9-c02d-4977-a43c-6cf45ee6d025 | 2026-09-21 14:18 | 2026-09-21 14:18 | 2026-09-21 14:18 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 1.9500 | 1.9500 | 1.9600 | 740.1700 | 12675.00 | 0.00 | 12675.00 | 65 | 5 | 12431 | 736 | 16.8899456521739 | 0.186723276114333 | 0.186723276114333 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:20:26.028708Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 4e7c6143-a369-4d54-a9d6-c64443ef9223 | 2026-09-21 14:33 | 2026-09-21 14:32 | 2026-09-21 14:32 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 1.9100 | 1.9000 | 1.9100 | 740.2200 | 25021.00 | 25021.00 | 0.00 | 131 | 19 | 12955 | 736 | 17.601902173913 | 0.185504144523751 | 0.185504144523751 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | 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 |
| 530b8da3-7acc-4cc6-9569-836d4ba69444 | 2026-09-21 14:35 | 2026-09-21 14:35 | 2026-09-21 14:35 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 1.8800 | 1.8700 | 1.8800 | 740.4100 | 24628.00 | 24628.00 | 0.00 | 131 | 13 | 13093 | 736 | 17.789402173913 | 0.186056496978536 | 0.186056496978536 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | 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 |
| e3d57dec-32aa-40ca-b81d-64fb81d54de5 | 2026-09-21 15:20 | 2026-09-21 15:20 | 2026-09-21 15:20 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 1.7500 | 1.7500 | 1.7600 | 741.7500 | 131250.00 | 0.00 | 131250.00 | 750 | 37 | 14977 | 736 | 20.3491847826087 | 0.193014032933642 | 0.193014032933642 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:21:01.961528Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 7e05e774-a79f-4888-8389-061837a18d4a | 2026-09-21 15:32 | 2026-09-21 15:32 | 2026-09-21 15:32 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 1.6700 | 1.6500 | 1.6700 | 742.0000 | 49981.00 | 35041.00 | 0.00 | 300 | 15 | 15547 | 736 | 21.1236413043478 | 0.192675085804541 | 0.193137985748007 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 484276301501.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 4bb45d97-287b-4eab-930f-6edc5298c571 | 2026-09-21 15:43 | 2026-09-21 15:42 | 2026-09-21 15:42 | QQQ | QQQ260925P00730000 | put | 730.0000 | 2026-09-25 | 1.6300 | 1.6200 | 1.6300 | 742.4300 | 32111.00 | 32111.00 | 0.00 | 197 | 8 | 16074 | 736 | 21.8396739130435 | 0.193738910025554 | 0.193738910025554 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:46:53.809312Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |