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_alerts474,253 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 |
|---|
| 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 |
|---|
| 63cf6698-f87e-429b-80c7-ce487626e0bd | 2026-09-21 10:11 | 2026-09-21 10:10 | 2026-09-21 10:10 | S | S270115C00025000 | call | 25.0000 | 2027-01-15 | 2.7000 | 2.5000 | 2.7000 | 23.0000 | 38556.00 | 38556.00 | 0.00 | 143 | 8 | 663 | 13912 | 0.0476566992524439 | 0.606828061972672 | 0.604894660724506 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 8143990933.00 | 2026-12-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:12:42.136586Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 09107f7a-45fb-4368-af62-1e03a070da81 | 2026-09-16 15:16 | 2026-09-16 15:16 | 2026-09-16 15:16 | S | S261016C00022000 | call | 22.0000 | 2026-10-16 | 1.9600 | 1.9500 | 2.0500 | 23.0200 | 10788.00 | 0.00 | 10788.00 | 55 | 7 | 106 | 1172 | 0.0904436860068259 | 0.52783651301613 | 0.52783651301613 | false | false | false | |||||||||||||||||
| 73c7fe67-e684-4239-92e6-315675ba4211 | 2026-09-16 10:35 | 2026-09-16 10:35 | 2026-09-16 10:35 | S | S260918C00022000 | call | 22.0000 | 2026-09-18 | 1.6500 | 1.6500 | 1.7000 | 23.6050 | 14859.00 | 0.00 | 14859.00 | 90 | 5 | 524 | 22029 | 0.0237868264560352 | 0.712374555663788 | 0.712374555663788 | false | false | false | |||||||||||||||||
| 32b68ccd-fc13-4b7b-9252-e4b3fa023b72 | 2026-09-15 13:24 | 2026-09-15 13:24 | 2026-09-15 13:24 | S | S270319C00035000 | call | 35.0000 | 2027-03-19 | 1.3800 | 1.3000 | 1.4000 | 23.5650 | 28490.00 | 15260.00 | 13230.00 | 207 | 8 | 2276 | 2767 | 0.822551499819299 | 0.625719603348894 | 0.625719603348894 | true | false | false | |||||||||||||||||
| c7af1601-7fec-4ef3-bf58-7bd358836571 | 2026-09-15 13:24 | 2026-09-15 13:23 | 2026-09-15 13:23 | S | S270319C00035000 | call | 35.0000 | 2027-03-19 | 1.3500 | 1.3000 | 1.4000 | 23.5500 | 277768.00 | 257983.00 | 19110.00 | 2061 | 50 | 2063 | 2767 | 0.7455728225515 | 0.617369412648896 | 0.617369412648896 | false | false | false | |||||||||||||||||
| 4ddb2216-ec84-443a-b4bf-742442445885 | 2026-09-15 12:35 | 2026-09-15 12:34 | 2026-09-15 12:34 | S | S261218C00030000 | call | 30.0000 | 2026-12-18 | 1.0400 | 1.0000 | 1.0500 | 23.0000 | 30469.00 | 20369.00 | 10100.00 | 294 | 26 | 440 | 846 | 0.520094562647754 | 0.6170963799407 | 0.6170963799407 | false | false | false | |||||||||||||||||
| 91cb3e84-333f-429c-be06-8171cdc5272f | 2026-09-14 11:36 | 2026-09-14 11:36 | 2026-09-14 11:36 | S | S270115C00025000 | call | 25.0000 | 2027-01-15 | 2.2900 | 2.1000 | 2.3000 | 22.6850 | 64250.00 | 64250.00 | 0.00 | 280 | 15 | 338 | 14068 | 0.0240261586579471 | 0.588427280653226 | 0.582930922851429 | false | false | false | |||||||||||||||||
| fafcb57f-54a2-42d7-9523-b1feb2925d3f | 2026-09-14 10:02 | 2026-09-14 10:02 | 2026-09-14 10:02 | S | S270319C00020000 | call | 20.0000 | 2027-03-19 | 4.3000 | 4.3000 | 4.5000 | 21.4200 | 533597.00 | 0.00 | 533597.00 | 1240 | 39 | 1300 | 14139 | 0.0919442676285452 | 0.581972354532697 | 0.567610024068704 | false | false | false | |||||||||||||||||
| bf741575-eea0-4077-8f5e-f5ae36feda93 | 2026-09-14 09:40 | 2026-09-14 09:39 | 2026-09-14 09:39 | S | S261016C00021000 | call | 21.0000 | 2026-10-16 | 1.3900 | 1.2000 | 1.4000 | 21.0000 | 12227.00 | 12227.00 | 0.00 | 88 | 11 | 111 | 1577 | 0.0703868103994927 | 0.532042587166802 | 0.519900599538914 | false | false | false | |||||||||||||||||
| 4561bf30-c853-4022-9232-903484e14abd | 2026-09-02 15:02 | 2026-09-02 15:02 | 2026-09-02 15:02 | S | S260904C00020000 | call | 20.0000 | 2026-09-04 | 0.2000 | 0.1000 | 0.2000 | 19.5100 | 17063.00 | 17063.00 | 0.00 | 854 | 38 | 885 | 383 | 2.31070496083551 | 0.698288417255408 | 0.679734701155179 | false | false | false | |||||||||||||||||
| 8c058fd8-3d82-4fa7-a59d-304b9829568e | 2026-08-31 15:44 | 2026-08-31 15:44 | 2026-08-31 15:44 | S | S270115C00025000 | call | 25.0000 | 2027-01-15 | 2.0200 | 1.8500 | 2.0500 | 21.9850 | 10103.00 | 10103.00 | 0.00 | 50 | 6 | 106 | 13950 | 0.00759856630824373 | 0.567105966527464 | 0.557678878046268 | false | false | false | |||||||||||||||||
| e9f0ed55-efd3-461b-ad12-f55fd840cb8d | 2026-08-28 09:36 | 2026-08-28 09:36 | 2026-08-28 09:36 | S | S260918C00022000 | call | 22.0000 | 2026-09-18 | 0.9500 | 0.9000 | 1.2000 | 21.5000 | 66446.00 | 0.00 | 66446.00 | 700 | 15 | 2282 | 23336 | 0.0977888241343846 | 0.593484089033398 | 0.593484089033398 | true | false | false | |||||||||||||||||
| 2e4479e9-72cb-4f81-8954-c13bc5e3e61b | 2026-08-27 15:39 | 2026-08-27 15:39 | 2026-08-27 15:39 | S | S260918C00022000 | call | 22.0000 | 2026-09-18 | 2.2000 | 2.2000 | 2.2500 | 22.8250 | 66035.00 | 0.00 | 66035.00 | 300 | 13 | 6936 | 23567 | 0.294309840030551 | 0.793761997943352 | 0.789085264685429 | false | false | false | |||||||||||||||||
| 77dd19c7-3aa0-45e0-8440-8c9b21d8f2b5 | 2026-08-27 11:21 | 2026-08-27 11:21 | 2026-08-27 11:21 | S | S260918C00025000 | call | 25.0000 | 2026-09-18 | 0.7900 | 0.7500 | 0.8000 | 22.2750 | 12182.00 | 12182.00 | 0.00 | 154 | 17 | 410 | 8463 | 0.0484461774784355 | 0.79877070344002 | 0.784691543547713 | false | false | false | |||||||||||||||||
| 942d7043-7afa-4926-a9b0-d7c68c058d1c | 2026-08-27 10:24 | 2026-08-27 10:24 | 2026-08-27 10:24 | S | S260918C00022000 | call | 22.0000 | 2026-09-18 | 1.6500 | 1.6000 | 1.7500 | 22.1000 | 103659.00 | 3630.00 | 100029.00 | 628 | 36 | 1972 | 23567 | 0.0836763270675097 | 0.7287811362859 | 0.730550983549528 | false | false | false | |||||||||||||||||
| 050dadc9-33cb-4b65-9fa5-a772052403a3 | 2026-08-20 11:22 | 2026-08-20 11:22 | 2026-08-20 11:22 | S | S260821P00021000 | put | 21.0000 | 2026-08-21 | 0.3500 | 0.2500 | 0.5000 | 20.9400 | 22658.00 | 22588.00 | 70.00 | 648 | 50 | 651 | 792 | 0.821969696969697 | 0.760853568748219 | 0.731444660443822 | true | false | false | |||||||||||||||||
| cb5d7014-51ec-4ac2-bb6c-134964ac505b | 2026-08-17 09:53 | 2026-08-17 09:53 | 2026-08-17 09:53 | S | S261218P00021000 | put | 21.0000 | 2026-12-18 | 2.2800 | 2.2000 | 2.5000 | 21.9480 | 22806.00 | 0.00 | 22806.00 | 100 | 9 | 102 | 37 | 2.75675675675676 | 0.584067052743056 | 0.584067052743056 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7928414703.00 |
| 2026-12-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:16:52.058969Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7928414703.00 |
| 2026-12-03 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T17:45:33.615815Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T17:45:33.615815Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:39:52.032222Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:14:09.812180Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:08:56.003529Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:52:49.177007Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| unknown |
| — |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7736791387.00 |
| 2026-12-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |