Options 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9a239e1a-785e-45fd-b671-4d0761a943b5 | 2026-08-17 11:07 | 2026-08-17 11:07 | 2026-08-17 11:07 | UNG | UNG270115C00010000 | call | 10.0000 | 2027-01-15 | 1.4500 | 1.4000 | 1.4500 | 9.7450 | 29130.00 | 29130.00 | 0.00 | 201 | 12 | 335 | 7025 | 0.0476868327402135 | 0.599122493765502 | 0.59506698898633 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| db721e15-a636-453b-ae00-1d0c0a4809c2 | 2026-08-21 09:51 | 2026-08-21 09:51 | 2026-08-21 09:51 | UNG | UNG270115C00009000 | call | 9.0000 | 2027-01-15 | 2.0100 | 1.9700 | 2.1800 | 10.0599 | 10046.00 | 0.00 | 10046.00 | 50 | 5 | 56 | 3801 | 0.0147329650092081 | 0.556195772924086 | 0.556195772924086 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9d095769-1e27-4a40-91e3-f7a2b8dbe237 | 2026-08-21 09:51 | 2026-08-21 09:51 | 2026-08-21 09:51 | UNG | UNG270115C00009000 | call | 9.0000 | 2027-01-15 | 2.0100 | 1.9700 | 2.1700 | 10.0599 | 10028.00 | 0.00 | 10028.00 | 50 | 5 | 106 | 3801 | 0.0278873980531439 | 0.556195772924086 | 0.556195772924086 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| eb04012a-f9fd-453a-ad1c-32f1e2a8ff21 | 2026-08-25 10:59 | 2026-08-25 10:59 | 2026-08-25 10:59 | UNG | UNG261016C00009000 | call | 9.0000 | 2026-10-16 | 1.2200 | 1.2100 | 1.2200 | 9.9750 | 60686.00 | 52216.00 | 8470.00 | 498 | 38 | 4852 | 4761 | 1.01911363159 | 0.398849144065873 | 0.398849144065873 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:00:40.665909Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c92dfb9b-c70d-4803-9336-c79cf609cc39 | 2026-08-25 11:03 | 2026-08-25 11:03 | 2026-08-25 11:03 | UNG | UNG261016C00009000 | call | 9.0000 | 2026-10-16 | 1.3100 | 1.3000 | 1.3100 | 9.9850 | 22251.00 | 19781.00 | 2470.00 | 170 | 9 | 16118 | 4761 | 3.38542323041378 | 0.471176898336388 | 0.471176898336388 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | 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 |
| 17a9f1a9-22a0-4423-9bf2-9409d79a06ba | 2026-08-25 11:13 | 2026-08-25 11:13 | 2026-08-25 11:13 | UNG | UNG261016C00009000 | call | 9.0000 | 2026-10-16 | 1.3200 | 1.3200 | 1.3300 | 9.9901 | 15062.00 | 1862.00 | 13200.00 | 114 | 6 | 39943 | 4761 | 8.38962402856543 | 0.484861068951901 | 0.47639228167763 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | 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 |
| 213b7176-b481-4d6b-afd2-71c08db2784e | 2026-08-25 11:22 | 2026-08-25 11:21 | 2026-08-25 11:21 | UNG | UNG261016C00009000 | call | 9.0000 | 2026-10-16 | 1.3400 | 1.3300 | 1.3400 | 10.0050 | 14728.00 | 13132.00 | 1596.00 | 110 | 7 | 49834 | 4761 | 10.4671287544633 | 0.483780941470092 | 0.475268789761014 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3e25c6e8-9e52-4de6-ab4f-f8a7ce656398 | 2026-08-25 11:47 | 2026-08-25 11:47 | 2026-08-25 11:47 | UNG | UNG261002C00009500 | call | 9.5000 | 2026-10-02 | 0.9000 | 0.8100 | 0.9800 | 10.0350 | 44910.00 | 39960.00 | 4950.00 | 500 | 11 | 500 | 19 | 26.3157894736842 | 0.453540179154498 | 0.453540179154498 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a6d273fa-4de4-49dd-a323-87b0f1eacc57 | 2026-08-27 10:32 | 2026-08-27 10:32 | 2026-08-27 10:32 | UNG | UNG260918C00009500 | call | 9.5000 | 2026-09-18 | 1.1600 | 1.1600 | 1.2400 | 10.5836 | 11137.00 | 0.00 | 11137.00 | 96 | 9 | 402 | 776 | 0.518041237113402 | 0.40667478578319 | 0.380935631058699 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T14:37:18.031558Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c7714724-2a87-4fb1-a431-a24ab10f57f8 | 2026-08-27 11:20 | 2026-08-27 11:20 | 2026-08-27 11:20 | UNG | UNG260918C00009500 | call | 9.5000 | 2026-09-18 | 1.1400 | 1.0700 | 1.1400 | 10.5250 | 10471.00 | 10471.00 | 0.00 | 92 | 29 | 1245 | 776 | 1.60438144329897 | 0.437125494738053 | 0.420328637193002 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c97d6596-3494-4cd5-aef0-1542eea135a8 | 2026-08-28 13:13 | 2026-08-28 13:13 | 2026-08-28 13:13 | UNG | UNG260918C00009500 | call | 9.5000 | 2026-09-18 | 0.9500 | 0.9000 | 0.9500 | 10.3282 | 33139.00 | 33139.00 | 0.00 | 349 | 23 | 1337 | 1205 | 1.10954356846473 | 0.407320676021467 | 0.407320676021467 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T17:15:24.821907Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 26af73f7-0009-4c89-a844-e81dfc8e6e85 | 2026-09-03 09:37 | 2026-09-03 09:37 | 2026-09-03 09:37 | UNG | UNG260911C00010500 | call | 10.5000 | 2026-09-11 | 0.4000 | 0.4000 | 0.4600 | 10.7500 | 32002.00 | 41.00 | 31961.00 | 800 | 7 | 1006 | 1829 | 0.55002733734281 | 0.415323796632499 | 0.398012450800217 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T13:45:03.310585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2bd5f382-fdee-4d38-95cc-d6a8ca2cb87b | 2026-09-04 15:55 | 2026-09-04 15:55 | 2026-09-04 15:55 | UNG | UNG270115C00011000 | call | 11.0000 | 2027-01-15 | 1.4900 | 1.4400 | 1.5400 | 10.5622 | 74440.00 | 61030.00 | 0.00 | 500 | 11 | 2501 | 8232 | 0.303814382896016 | 0.634955879689212 | 0.627034558970973 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T20:00:02.053596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 62debdc6-b338-492f-95df-f0b62dd2a743 | 2026-09-09 13:42 | 2026-09-09 13:42 | 2026-09-09 13:42 | UNG | UNG270115C00010000 | call | 10.0000 | 2027-01-15 | 1.4900 | 1.4900 | 1.5500 | 10.1500 | 61247.00 | 0.00 | 61247.00 | 410 | 9 | 706 | 12318 | 0.0573144991069979 | 0.587026696579147 | 0.56979127674848 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T17:50:47.676652Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 23b21095-c35a-4510-80f9-5d0861e5d409 | 2026-09-10 10:30 | 2026-09-10 10:30 | 2026-09-10 10:30 | UNG | UNG261016C00009000 | call | 9.0000 | 2026-10-16 | 1.1300 | 1.1000 | 1.2000 | 9.8700 | 24539.00 | 0.00 | 24539.00 | 217 | 15 | 3705 | 72905 | 0.0508195597009807 | 0.531877190007126 | 0.449050152678988 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T14:36:53.026568Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c1cefc1b-6254-4c6a-aa55-3c2bd153aca9 | 2026-09-11 11:37 | 2026-09-11 11:37 | 2026-09-11 11:37 | UNG | UNG261016C00009000 | call | 9.0000 | 2026-10-16 | 1.2900 | 1.2900 | 1.3100 | 10.1350 | 18252.00 | 0.00 | 18252.00 | 141 | 14 | 1147 | 76129 | 0.0150665318078525 | 0.440239298021594 | 0.427328660238246 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:53:19.427541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 05fc33ed-5a3e-49d1-8a7b-21f29e997e2f | 2026-09-14 09:38 | 2026-09-14 09:38 | 2026-09-14 09:38 | UNG | UNG270115C00012000 | call | 12.0000 | 2027-01-15 | 0.8500 | 0.8500 | 0.8800 | 10.2650 | 16580.00 | 0.00 | 16580.00 | 195 | 13 | 205 | 20433 | 0.010032790094455 | 0.596932283637562 | 0.59260338750956 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 98d5f7c7-7c9e-4f46-a136-477fe3648be4 | 2026-09-17 12:06 | 2026-09-17 12:05 | 2026-09-17 12:05 | UNG | UNG270115C00012000 | call | 12.0000 | 2027-01-15 | 0.8300 | 0.7800 | 0.8500 | 10.4250 | 82970.00 | 67200.00 | 15770.00 | 1000 | 14 | 1294 | 21726 | 0.0595599742244316 | 0.562928266464939 | 0.558618976364299 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 822871397.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |