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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| faef2f16-475e-4517-82ae-a9f0cd49f9ef | 2026-09-21 15:09 | 2026-09-21 15:09 | 2026-09-21 15:09 | USAR | USAR270319C00019000 | call | 19.0000 | 2027-03-19 | 3.2000 | 3.1500 | 3.4500 | 16.8600 | 31690.00 | 0.00 | 31690.00 | 99 | 5 | 99 | 285 | 0.347368421052632 | 0.824161924723901 | 0.824161924723901 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 4106403261.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 11d5b242-fa23-4e81-a036-b9306419eea9 | 2026-09-18 09:35 | 2026-09-18 09:35 | 2026-09-18 09:35 | USAR | USAR261016C00016000 | call | 16.0000 | 2026-10-16 | 1.1300 | 1.1100 | 1.2500 | 15.6800 | 11304.00 | 0.00 | 11304.00 | 100 | 6 | 100 | 938 | 0.106609808102345 | 0.728592900731864 | 0.728592900731864 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3761347922.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:40:42.153741Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 0adfd4bd-c2fb-4440-bb50-428c7b201ef5 | 2026-09-17 10:32 | 2026-09-17 10:32 | 2026-09-17 10:32 | USAR | USAR261002C00018500 | call | 18.5000 | 2026-10-02 | 0.1700 | 0.1600 | 0.2000 | 15.4700 | 22073.00 | 0.00 | 21784.00 | 1300 | 94 | 1305 | 89 | 14.6629213483146 | 0.769212495638685 | 0.758168492346915 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3824975147.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| d76f3cb8-37ba-43cd-a64c-1599da34bf80 | 2026-09-09 12:30 | 2026-09-09 12:30 | 2026-09-09 12:30 | USAR | USAR270115C00050000 | call | 50.0000 | 2027-01-15 | 0.2700 | 0.2000 | 0.2700 | 17.3850 | 16411.00 | 16388.00 | 23.00 | 608 | 40 | 608 | 11909 | 0.0510538248383575 | 1.00443645624115 | 0.974525429780852 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3844552755.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T16:45:40.179334Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ee09d214-f2b6-41c3-adbe-3cdd11ee56aa | 2026-09-03 09:30 | 2026-09-03 09:30 | 2026-09-03 09:30 | USAR | USAR260918P00018000 | put | 18.0000 | 2026-09-18 | 1.0400 | 1.0000 | 1.3300 | 17.9700 | 56389.00 | 1430.00 | 45279.00 | 542 | 78 | 542 | 6292 | 0.086141131595677 | 0.756883998149674 | 0.763784928374234 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3844552755.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5713123b-8133-4693-aa16-44690bc721ca | 2026-08-31 15:54 | 2026-08-31 15:54 | 2026-08-31 15:54 | USAR | USAR260918P00018000 | put | 18.0000 | 2026-09-18 | 1.3200 | 1.3000 | 1.3300 | 17.8250 | 18186.00 | 0.00 | 18186.00 | 138 | 22 | 3666 | 5178 | 0.707995365005794 | 0.788349663063832 | 0.775673897096485 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3844552755.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 97b9b3bf-eb20-42c9-b8c5-281746f3a8a2 | 2026-08-28 15:53 | 2026-08-28 15:53 | 2026-08-28 15:53 | USAR | USAR260925C00019000 | call | 19.0000 | 2026-09-25 | 1.3200 | 1.1200 | 1.3400 | 17.9900 | 16128.00 | 16128.00 | 0.00 | 122 | 9 | 141 | 219 | 0.643835616438356 | 0.872975525999956 | 0.85781398254719 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3844552755.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T19:57:19.773601Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c1cd367b-7f8b-406f-a0d4-2af27f16ca4a | 2026-08-28 09:42 | 2026-08-28 09:42 | 2026-08-28 09:42 | USAR | USAR260918C00020000 | call | 20.0000 | 2026-09-18 | 1.1800 | 1.1500 | 1.2700 | 19.0200 | 46080.00 | 0.00 | 46080.00 | 390 | 5 | 900 | 13763 | 0.06539271961055 | 0.8678132506517 | 0.8678132506517 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3844552755.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2089f998-2505-440e-9ce6-d7e175b19ac0 | 2026-08-28 09:41 | 2026-08-28 09:41 | 2026-08-28 09:41 | USAR | USAR260918C00020000 | call | 20.0000 | 2026-09-18 | 1.2300 | 1.1900 | 1.3800 | 19.1300 | 24509.00 | 0.00 | 24509.00 | 199 | 6 | 510 | 13763 | 0.0370558744459783 | 0.86778213175379 | 0.86778213175379 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3844552755.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| edb3f35e-bbe2-4212-97fa-c5f63259cb4c | 2026-08-25 11:09 | 2026-08-25 11:09 | 2026-08-25 11:09 | USAR | USAR260904C00019500 | call | 19.5000 | 2026-09-04 | 1.1100 | 1.0900 | 1.1200 | 19.1440 | 78599.00 | 57344.00 | 21255.00 | 707 | 34 | 740 | 154 | 4.80519480519481 | 1.00561916000247 | 1.00561916000247 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3844552755.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b63b55e8-a724-470e-b4c1-3c7ad0d0b150 | 2026-08-25 11:07 | 2026-08-25 11:07 | 2026-08-25 11:07 | USAR | USAR260918C00021500 | call | 21.5000 | 2026-09-18 | 1.0000 | 0.9800 | 1.0100 | 19.0650 | 61130.00 | 45450.00 | 15680.00 | 610 | 33 | 642 | 9 | 71.3333333333333 | 0.957455201079672 | 0.957455201079672 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3844552755.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a5545f77-855b-4094-a361-a9fd43fed60e | 2026-08-25 09:49 | 2026-08-25 09:49 | 2026-08-25 09:49 | USAR | USAR260828C00019000 | call | 19.0000 | 2026-08-28 | 0.5900 | 0.5100 | 0.6100 | 18.5300 | 12485.00 | 8657.00 | 168.00 | 210 | 10 | 279 | 1040 | 0.268269230769231 | 1.1978065482637 | 1.13510496484182 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3844552755.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9fafbb4b-9b70-4380-97dd-a154918e3985 | 2026-08-24 13:47 | 2026-08-24 13:47 | 2026-08-24 13:47 | USAR | USAR260904C00020000 | call | 20.0000 | 2026-09-04 | 0.5100 | 0.5000 | 0.5700 | 18.0600 | 30279.00 | 4838.00 | 25441.00 | 596 | 64 | 738 | 1818 | 0.405940594059406 | 0.956033639112701 | 0.933935054840837 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3844552755.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fbd6c7fb-9254-4c02-9607-60ce172a7ae1 | 2026-08-21 13:48 | 2026-08-21 13:48 | 2026-08-21 13:48 | USAR | USAR260904C00020000 | call | 20.0000 | 2026-09-04 | 1.1500 | 1.0900 | 1.1500 | 19.4550 | 57383.00 | 57383.00 | 0.00 | 499 | 10 | 1750 | 437 | 4.0045766590389 | 0.905503548961746 | 0.89891307292502 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3844552755.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c7a00dc1-ed95-48e3-b6e5-47ea0ff994a8 | 2026-08-21 12:37 | 2026-08-21 12:37 | 2026-08-21 12:37 | USAR | USAR260828C00018500 | call | 18.5000 | 2026-08-28 | 1.2700 | 1.2700 | 1.3700 | 19.1700 | 27433.00 | 0.00 | 27433.00 | 216 | 29 | 2199 | 268 | 8.20522388059701 | 0.856574243140299 | 0.852974125343109 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3844552755.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3e5b5d83-84ec-4edf-a444-049cd6f72348 | 2026-08-18 10:01 | 2026-08-18 10:01 | 2026-08-18 10:01 | USAR | USAR280121C00027000 | call | 27.0000 | 2028-01-21 | 6.1500 | 6.1500 | 6.5000 | 18.7200 | 116866.00 | 0.00 | 116866.00 | 190 | 18 | 193 | 3928 | 0.0491344195519348 | 0.918085055610961 | 0.916923150329582 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3844552755.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |