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.
uw_flow_alerts326,449 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 |
|---|
| 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 |
|---|
| 2449f4f4-9a2e-4e15-ae93-2f92ebdd3d65 | 2026-09-22 13:22 | 2026-09-22 13:22 | 2026-09-22 13:22 | FIS | FIS261120C00037500 | call | 37.5000 | 2026-11-20 | 1.4500 | 1.4000 | 1.4500 | 35.0600 | 26390.00 | 26390.00 | 0.00 | 182 | 14 | 429 | 2 | 214.5 | 0.412329916170093 | 0.412329916170093 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 18029078858.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T17:23:35.118331Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| de562146-8191-4365-b12d-2ec67e3740fd | 2026-09-22 11:39 | 2026-09-22 11:39 | 2026-09-22 11:39 | FIS | FIS261218P00035000 | put | 35.0000 | 2026-12-18 | 2.8000 | 2.7500 | 2.8000 | 34.8593 | 13160.00 | 8400.00 | 0.00 | 47 | 14 | 454 | 340 | 1.33529411764706 | 0.429406920708097 | 0.429406920708097 | false | false | false | true | false | |||||||||||||||
| 33e08191-3210-4424-a72d-6402631fe05f | 2026-09-22 11:39 | 2026-09-22 11:39 | 2026-09-22 11:39 | FIS | FIS261218P00035000 | put | 35.0000 | 2026-12-18 | 2.8000 | 2.7500 | 2.8500 | 34.8550 | 15400.00 | 6160.00 | 0.00 | 55 | 18 | 361 | 340 | 1.06176470588235 | 0.429121165558261 | 0.429121165558261 | false | false | false | true | false | |||||||||||||||
| 959861cc-53d0-4a13-b84b-2caa21000f85 | 2026-09-22 11:12 | 2026-09-22 11:12 | 2026-09-22 11:12 | FIS | FIS261120C00037500 | call | 37.5000 | 2026-11-20 | 1.5000 | 1.4000 | 1.5000 | 35.0200 | 35250.00 | 35250.00 | 0.00 | 235 | 30 | 240 | 2 | 120 | 0.424466686492694 | 0.424466686492694 | false | false | false | true | false | |||||||||||||||
| 43524a2d-5af5-428c-9930-bc54550081c4 | 2026-09-22 10:46 | 2026-09-22 10:46 | 2026-09-22 10:46 | FIS | FIS270319C00037500 | call | 37.5000 | 2027-03-19 | 3.0000 | 2.8000 | 3.2000 | 35.0000 | 22200.00 | 15000.00 | 7200.00 | 74 | 7 | 74 | 5 | 14.8 | 0.381657906233374 | 0.381657906233374 | true | false | false | true | false | |||||||||||||||
| 3eb3c042-7c9f-46b0-b211-5e48e6c50826 | 2026-09-22 10:33 | 2026-09-22 10:33 | 2026-09-22 10:33 | FIS | FIS261218P00030000 | put | 30.0000 | 2026-12-18 | 0.9000 | 0.6500 | 0.9000 | 34.9050 | 13950.00 | 13950.00 | 0.00 | 155 | 38 | 185 | 95 | 1.94736842105263 | 0.439498496338545 | 0.439498496338545 | false | false | false | true | ||||||||||||||||
| 0d4f3a97-bf0b-4a70-91d7-ecf6309f222e | 2026-09-16 14:01 | 2026-09-16 14:01 | 2026-09-16 14:01 | FIS | FIS261009P00035000 | put | 35.0000 | 2026-10-09 | 0.5000 | 0.4500 | 0.6000 | 37.0000 | 13150.00 | 100.00 | 12950.00 | 263 | 32 | 265 | 31 | 8.54838709677419 | 0.384203887169303 | 0.384203887169303 | false | false | false | true | ||||||||||||||||
| c8059ae4-b1f3-429d-bb00-62747d504aae | 2026-09-16 10:49 | 2026-09-16 10:49 | 2026-09-16 10:49 | FIS | FIS260925C00037000 | call | 37.0000 | 2026-09-25 | 1.1000 | 1.1000 | 1.1500 | 37.2800 | 53350.00 | 0.00 | 53350.00 | 485 | 33 | 485 | 0 | 0 | 0.40152654083004 | 0.40152654083004 | false | false | false | true | false | |||||||||||||||
| 6037280c-f4a6-41f6-b450-ec313e6b4af8 | 2026-09-15 10:54 | 2026-09-15 10:54 | 2026-09-15 10:54 | FIS | FIS270115P00035000 | put | 35.0000 | 2027-01-15 | 2.3000 | 2.3000 | 2.4000 | 37.0000 | 21160.00 | 0.00 | 21160.00 | 92 | 22 | 92 | 457 | 0.201312910284464 | 0.447693430132138 | 0.447693430132138 | false | false | false | true | ||||||||||||||||
| 2fe8e7ce-b055-4aa2-adc7-ea4138863a3f | 2026-09-14 14:00 | 2026-09-14 13:59 | 2026-09-14 13:59 | FIS | FIS260918C00039000 | call | 39.0000 | 2026-09-18 | 0.4000 | 0.2500 | 0.4000 | 37.9600 | 12350.00 | 12350.00 | 0.00 | 309 | 34 | 384 | 203 | 1.89162561576355 | 0.5048429121339 | 0.5048429121339 | false | false | false | true | ||||||||||||||||
| 97cac772-1530-40a8-9c49-bf3a6d21a5c1 | 2026-09-14 13:05 | 2026-09-14 13:04 | 2026-09-14 13:04 | FIS | FIS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.6500 | 0.6000 | 0.8000 | 39.9100 | 32500.00 | 4680.00 | 27820.00 | 500 | 20 | 2102 | 2907 | 0.723082215342277 | 0.411096028746429 | 0.411096028746429 | true | false | false | true | ||||||||||||||||
| 5ec4d6ba-2daf-4683-8f3d-7330701fa450 | 2026-09-14 12:29 | 2026-09-14 12:29 | 2026-09-14 12:29 | FIS | FIS270115C00047500 | call | 47.5000 | 2027-01-15 | 1.3000 | 1.2000 | 1.3000 | 39.7500 | 28970.00 | 28970.00 | 0.00 | 223 | 29 | 224 | 436 | 0.513761467889908 | 0.387926042256595 | 0.387926042256595 | false | false | false | true | ||||||||||||||||
| ec418686-1a35-466f-81fa-3cf5375295e0 | 2026-09-08 12:40 | 2026-09-08 12:40 | 2026-09-08 12:40 | FIS | FIS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.8000 | 0.7500 | 0.8500 | 39.7400 | 44560.00 | 38320.00 | 6240.00 | 557 | 19 | 2065 | 199 | 10.3768844221106 | 0.344010885215023 | 0.344010885215023 | true | false | false | true | ||||||||||||||||
| db521eff-dcea-4116-b12d-a0083226a631 | 2026-09-08 12:39 | 2026-09-08 12:39 | 2026-09-08 12:39 | FIS | FIS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.7000 | 0.6000 | 0.7000 | 39.6100 | 84280.00 | 84280.00 | 0.00 | 1204 | 48 | 1270 | 199 | 6.38190954773869 | 0.328587860491777 | 0.328587860491777 | false | false | false | true | ||||||||||||||||
| 01f4f418-a0ae-4411-92b7-74a1e308941a | 2026-09-08 12:39 | 2026-09-08 12:39 | 2026-09-08 12:39 | FIS | FIS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.7500 | 0.7000 | 0.7500 | 39.7000 | 17850.00 | 17850.00 | 0.00 | 238 | 9 | 1508 | 199 | 7.57788944723618 | 0.332054390666761 | 0.332054390666761 | false | false | false | true | ||||||||||||||||
| 137ecf46-6581-4c2c-a112-ba049e222803 | 2026-09-04 15:21 | 2026-09-04 15:20 | 2026-09-04 15:20 | FIS | FIS280121C00045000 | call | 45.0000 | 2028-01-21 | 6.0000 | 6.0000 | 6.6000 | 41.8750 | 12000.00 | 0.00 | 12000.00 | 20 | 11 | 20 | 49 | 0.408163265306122 | 0.318336080585376 | 0.318336080585376 | false | false | false | true | ||||||||||||||||
| 2ad6e7f9-1ad5-42bb-91fd-bc6f26569eca | 2026-08-27 10:32 | 2026-08-27 10:32 | 2026-08-27 10:32 | FIS | FIS270115C00042500 | call | 42.5000 | 2027-01-15 | 2.8500 | 2.7000 | 3.1000 | 40.3300 | 19950.00 | 12255.00 | 7695.00 | 70 | 8 | 70 | 43 | 1.62790697674419 | 0.351495616598514 | 0.350305579836249 | false | false | false | true | ||||||||||||||||
| a9cc54e3-d2dc-4782-ac96-164c492f3356 | 2026-08-25 13:55 | 2026-08-25 13:54 | 2026-08-25 13:54 | FIS | FIS261218P00037500 | put | 37.5000 | 2026-12-18 | 2.2500 | 2.1000 | 2.4500 | 40.3350 | 13500.00 | 1125.00 | 12375.00 | 60 | 6 | 61 | 313 | 0.194888178913738 | 0.424111508648348 | 0.424111508648348 | false | false | false | true | ||||||||||||||||
| a5192979-2cfc-4a79-9cf6-a4c447f181db | 2026-08-24 14:12 | 2026-08-24 14:12 | 2026-08-24 14:12 | FIS | FIS270115C00047500 | call | 47.5000 | 2027-01-15 | 1.8000 | 1.7500 | 1.8000 | 41.4300 | 18000.00 | 18000.00 | 0.00 | 100 | 6 | 210 | 22 | 9.54545454545454 | 0.354196036519666 | 0.354196036519666 | false | false | false | true | ||||||||||||||||
| d331139b-6058-4108-aafe-09299e89aab0 | 2026-08-18 13:17 | 2026-08-18 13:17 | 2026-08-18 13:17 | FIS | FIS280121P00045000 | put | 45.0000 | 2028-01-21 | 9.7000 | 9.1000 | 10.3000 | 41.6850 | 320100.00 | 0.00 | 0.00 | 330 | 2 | 330 | 25 | 13.2 | 0.472606051295281 | 0.472606051295281 | false | true | true | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 18029078858.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:42:55.952799Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 18029078858.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:42:55.952799Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 18029078858.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:15:45.651673Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 18029078858.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:48:37.826382Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 18029078858.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:34:01.762519Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19003763041.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19003763041.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19689651911.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:09:54.469160Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19689651911.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19689651911.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 19689651911.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:49:37.903150Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19689651911.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:42:24.738421Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19689651911.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:42:24.738421Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19689651911.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:42:24.738421Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19689651911.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19689651911.00 |
| 2026-11-04 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19689651911.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19689651911.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| Common Stock |
| Technology |
| 19689651911.00 |
| 2026-11-04 |
| 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 |