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_alerts375,978 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 | expiry |
|---|
| 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 |
|---|
| 0e7a4eeb-9764-4f1d-8f05-fa1847728190 | 2026-08-17 09:45 | 2026-08-17 09:44 | 2026-08-17 09:44 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.5600 | 0.5500 | 0.6500 | 13.8650 | 19460.00 | 0.00 | 17780.00 | 345 | 23 | 1111 | 45616 | 0.0243554893019993 | 0.621022138287425 | 0.588771099130824 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 8115827761.00 | 2026-11-09 | 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 |
| 1695549b-b0bc-4e6c-b255-a0cc37607246 | 2026-08-17 15:03 | 2026-08-17 15:03 | 2026-08-17 15:03 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.5300 | 0.5000 | 0.6000 | 13.7700 | 72880.00 | 0.00 | 72825.00 | 1374 | 20 | 6183 | 45616 | 0.135544545773413 | 0.609999111001594 | 0.578145039259559 | false | false | false | true | ||||||||||||||||
| f0a23c3f-6e16-49ee-abb0-520fa9de9c28 | 2026-08-17 15:36 | 2026-08-17 15:36 | 2026-08-17 15:36 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.5500 | 0.5000 | 0.6000 | 13.8150 | 22000.00 | 13750.00 | 0.00 | 400 | 5 | 6688 | 45616 | 0.146615222728867 | 0.600579270602571 | 0.600579270602571 | false | false | false | true | ||||||||||||||||
| 033e2b99-b5b6-4299-9c91-dcb1658b1ef7 | 2026-08-18 13:14 | 2026-08-18 13:14 | 2026-08-18 13:14 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.7000 | 0.6500 | 0.7500 | 14.2416 | 15120.00 | 1050.00 | 7910.00 | 215 | 14 | 2946 | 45761 | 0.0643779637682743 | 0.599381494742472 | 0.599381494742472 | true | false | false | true | ||||||||||||||||
| 583f440a-853c-4e83-8442-ac7a5cde99c2 | 2026-08-18 13:28 | 2026-08-18 13:28 | 2026-08-18 13:28 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.8000 | 0.7500 | 0.8000 | 14.3800 | 13520.00 | 13520.00 | 0.00 | 169 | 5 | 3280 | 45761 | 0.0716767553156618 | 0.62337595955712 | 0.62337595955712 | false | false | false | true | ||||||||||||||||
| c26a54d9-cb85-49af-a98d-2b91a2f7df55 | 2026-08-19 10:25 | 2026-08-19 10:25 | 2026-08-19 10:25 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.5500 | 0.5500 | 0.6000 | 13.8750 | 11000.00 | 0.00 | 11000.00 | 200 | 9 | 1008 | 46784 | 0.0215458276333789 | 0.603897588538012 | 0.606342011158256 | false | false | false | true | ||||||||||||||||
| eec504e4-0542-46a7-935d-569f506c5ae0 | 2026-08-19 10:25 | 2026-08-19 10:25 | 2026-08-19 10:25 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.5500 | 0.5500 | 0.6000 | 13.8750 | 11000.00 | 0.00 | 11000.00 | 200 | 15 | 1208 | 46784 | 0.0258207934336525 | 0.606342011158256 | 0.606342011158256 | false | false | false | true | ||||||||||||||||
| 78bad923-5e1e-4338-8413-536f4b77c475 | 2026-08-19 10:26 | 2026-08-19 10:26 | 2026-08-19 10:26 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.5500 | 0.5500 | 0.6000 | 13.8892 | 11000.00 | 0.00 | 11000.00 | 200 | 6 | 1408 | 46784 | 0.0300957592339261 | 0.602870420222619 | 0.602870420222619 | false | false | false | true | ||||||||||||||||
| fba33e65-df5b-4634-9e97-e711637d95ff | 2026-08-19 10:26 | 2026-08-19 10:26 | 2026-08-19 10:26 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.5500 | 0.5500 | 0.6000 | 13.8850 | 11000.00 | 0.00 | 11000.00 | 200 | 7 | 1608 | 46784 | 0.0343707250341997 | 0.603897588538012 | 0.603897588538012 | false | false | false | true | ||||||||||||||||
| 9d9aa7e4-129e-40c3-b527-4c9064dfbb75 | 2026-08-19 10:26 | 2026-08-19 10:26 | 2026-08-19 10:26 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.5500 | 0.5500 | 0.6000 | 13.8750 | 11000.00 | 0.00 | 11000.00 | 200 | 6 | 1808 | 46784 | 0.0386456908344733 | 0.606342011158256 | 0.606342011158256 | false | false | false | true | ||||||||||||||||
| 6d59f2f4-8f53-483c-8227-854f8f8b2eec | 2026-08-19 15:23 | 2026-08-19 15:23 | 2026-08-19 15:23 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.5000 | 0.5000 | 0.5500 | 13.8250 | 10000.00 | 0.00 | 10000.00 | 200 | 21 | 2966 | 46784 | 0.0633977428180575 | 0.584691532116745 | 0.584691532116745 | false | false | false | true | ||||||||||||||||
| 9309b120-55be-432d-a9d4-5d05253cd1d1 | 2026-08-20 09:56 | 2026-08-20 09:56 | 2026-08-20 09:56 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.7000 | 0.7000 | 0.7500 | 14.3700 | 27440.00 | 0.00 | 27440.00 | 392 | 5 | 1844 | 44643 | 0.041305467822503 | 0.585679499805773 | 0.585679499805773 | false | false | false | true | ||||||||||||||||
| 879767ee-c527-47d0-924b-b726b7d1f6ca | 2026-08-20 09:56 | 2026-08-20 09:56 | 2026-08-20 09:56 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.7100 | 0.6500 | 0.7500 | 14.3500 | 12519.00 | 807.00 | 11712.00 | 177 | 10 | 2172 | 44643 | 0.0486526443115382 | 0.591146931111506 | 0.584863539594712 | true | false | false | true | ||||||||||||||||
| e3895311-7e7b-4164-94b2-507a08b82a39 | 2026-08-20 11:13 | 2026-08-20 11:13 | 2026-08-20 11:13 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.7000 | 0.6500 | 0.7000 | 14.2850 | 21070.00 | 21070.00 | 0.00 | 301 | 14 | 5400 | 44643 | 0.120959612929239 | 0.60882277172533 | 0.60882277172533 | false | false | false | true | ||||||||||||||||
| 70ebbb70-5f6e-4c89-9fad-dfb4e9e5211b | 2026-08-20 11:39 | 2026-08-20 11:39 | 2026-08-20 11:39 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.7500 | 0.7000 | 0.8000 | 14.4250 | 14680.00 | 5680.00 | 0.00 | 196 | 7 | 5707 | 44643 | 0.127836390923549 | 0.59546232236457 | 0.601679117810064 | false | false | false | true | ||||||||||||||||
| b7e1c802-e4f8-480b-a910-d88fcd134287 | 2026-08-20 14:01 | 2026-08-20 14:01 | 2026-08-20 14:01 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.6500 | 0.6500 | 0.7000 | 14.2300 | 10996.00 | 0.00 | 10996.00 | 169 | 28 | 7118 | 44643 | 0.159442689783393 | 0.591768470887338 | 0.598160521807115 | true | false | false | true | ||||||||||||||||
| 19e34b1f-2f55-402a-8cbc-a6d249cff9c5 | 2026-08-21 15:09 | 2026-08-21 15:09 | 2026-08-21 15:09 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.6500 | 0.6000 | 0.6500 | 14.1950 | 27560.00 | 27560.00 | 0.00 | 424 | 10 | 4168 | 42160 | 0.0988614800759013 | 0.611951633957008 | 0.611951633957008 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |