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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| fabf7f28-e433-4e4d-a8ef-a3d2866171d7 | 2026-09-18 15:52 | 2026-09-18 15:52 | 2026-09-18 15:52 | FN | FN270115P00350000 | put | 350.0000 | 2027-01-15 | 34.8500 | 32.9000 | 34.9000 | 386.0000 | 52280.00 | 52280.00 | 0.00 | 15 | 6 | 17 | 67 | 0.253731343283582 | 0.641472006081948 | 0.640189853375311 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 13923636407.00 | 2026-11-02 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| baedf707-d933-4b5e-90e3-f36c23dc6569 | 2026-09-15 11:59 | 2026-09-15 11:58 | 2026-09-15 11:58 | FN | FN270115C00500000 | call | 500.0000 | 2027-01-15 | 22.7900 | 21.9000 | 23.9000 | 379.9100 | 22792.00 | 0.00 | 22792.00 | 10 | 6 | 10 | 57 | 0.175438596491228 | 0.644236005912885 | 0.644236005912885 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 13708627223.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 11d83dcc-de22-43e4-be10-40570f5bec02 | 2026-09-11 10:46 | 2026-09-11 10:46 | 2026-09-11 10:46 | FN | FN261218P00400000 | put | 400.0000 | 2026-12-18 | 47.2300 | 45.2000 | 53.2000 | 414.8700 | 23615.00 | 9440.00 | 9450.00 | 5 | 5 | 5 | 31 | 0.161290322580645 | 0.673376097007231 | 0.673376097007231 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 13708627223.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 22cc723e-e7b7-478a-ae73-3b8e05b93bf5 | 2026-09-08 15:33 | 2026-09-08 15:33 | 2026-09-08 15:33 | FN | FN261120C00500000 | call | 500.0000 | 2026-11-20 | 27.6500 | 26.2000 | 28.4000 | 418.9550 | 55305.00 | 55305.00 | 0.00 | 20 | 5 | 22 | 198 | 0.111111111111111 | 0.719641149154195 | 0.719641149154195 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 13708627223.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 |
| e277e40c-a83d-4474-a0e8-1a87962de129 | 2026-08-28 14:26 | 2026-08-28 14:26 | 2026-08-28 14:26 | FN | FN260918P00440000 | put | 440.0000 | 2026-09-18 | 35.3400 | 35.3000 | 38.7000 | 418.8650 | 141360.00 | 0.00 | 141360.00 | 40 | 5 | 41 | 194 | 0.211340206185567 | 0.584705263083652 | 0.582120428942474 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 13708627223.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T18:46:22.896033Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3a07bc9b-82df-4137-b159-cd5433d311e1 | 2026-08-24 09:30 | 2026-08-24 09:30 | 2026-08-24 09:30 | FN | FN260918C00400000 | call | 400.0000 | 2026-09-18 | 39.2800 | 38.8000 | 44.4000 | 424.8413 | 251382.00 | 117920.00 | 133462.00 | 64 | 26 | 494 | 98 | 5.04081632653061 | 0.56570116715745 | 0.560591507993306 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 13708627223.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6968edc2-b2eb-4217-bd77-1d048da48401 | 2026-08-21 10:59 | 2026-08-21 10:59 | 2026-08-21 10:59 | FN | FN261120P00430000 | put | 430.0000 | 2026-11-20 | 60.3200 | 59.2000 | 61.9000 | 425.8075 | 60324.00 | 0.00 | 60324.00 | 10 | 6 | 10 | 3 | 3.33333333333333 | 0.715168647609689 | 0.715168647609689 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 13708627223.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 502a26cd-1430-42c1-8ce1-37bae262de8e | 2026-08-18 12:55 | 2026-08-18 12:55 | 2026-08-18 12:55 | FN | FN260918P00440000 | put | 440.0000 | 2026-09-18 | 20.1200 | 19.1000 | 21.0000 | 476.3400 | 20116.00 | 14116.00 | 6000.00 | 10 | 6 | 92 | 12 | 7.66666666666667 | 0.677849502939732 | 0.677849502939732 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 13708627223.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fc8072ec-8058-4f01-b1e8-5d59ef7f35e0 | 2026-08-18 11:40 | 2026-08-18 11:40 | 2026-08-18 11:40 | FN | FN260821C00500000 | call | 500.0000 | 2026-08-21 | 5.1200 | 5.0000 | 9.0000 | 478.8950 | 65040.00 | 47940.00 | 17100.00 | 127 | 23 | 1052 | 119 | 8.84033613445378 | 0.732788810838611 | 0.733131239648732 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 13708627223.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1f2b63c0-34ab-48df-a49c-f261058f454c | 2026-08-18 11:40 | 2026-08-18 11:40 | 2026-08-18 11:40 | FN | FN260821C00500000 | call | 500.0000 | 2026-08-21 | 6.7200 | 6.6000 | 8.6000 | 478.9900 | 40320.00 | 36220.00 | 4100.00 | 60 | 13 | 621 | 119 | 5.21848739495798 | 0.852828036293347 | 0.839631676955113 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 13708627223.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 03ff7726-4a9b-4c25-8b10-2d5d073a5f90 | 2026-08-17 15:17 | 2026-08-17 15:17 | 2026-08-17 15:17 | FN | FN260821C00620000 | call | 620.0000 | 2026-08-21 | 27.2400 | 24.2000 | 30.1000 | 597.6000 | 79008.00 | 79008.00 | 0.00 | 29 | 5 | 80 | 32 | 2.5 | 1.46936421654898 | 1.46936421654898 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 13708627223.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0b92f4bd-7e2d-49d4-a93f-2ec769d2ebee | 2026-08-17 10:58 | 2026-08-17 10:58 | 2026-08-17 10:58 | FN | FN260821P00590000 | put | 590.0000 | 2026-08-21 | 31.9800 | 29.1000 | 34.9000 | 597.3700 | 31979.00 | 22389.00 | 9590.00 | 10 | 5 | 14 | 36 | 0.388888888888889 | 1.44065745872717 | 1.44025143155379 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 13708627223.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 |