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_alerts425,429 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 | price |
|---|
| 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 |
|---|
| 19b4c91c-87b1-4aa6-93af-0bce9bc98cf5 | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | PCT | PCT280121C00005000 | call | 5.0000 | 2028-01-21 | 2.3000 | 2.3000 | 2.5500 | 5.0000 | 32201.00 | 0.00 | 32201.00 | 140 | 28 | 611 | 2568 | 0.237928348909657 | 0.881141494080018 | 0.881141494080018 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 1034659772.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| a3e6f2ee-70a6-46a1-9cbb-4f68a9a6a6d8 | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | PCT | PCT280121C00005000 | call | 5.0000 | 2028-01-21 | 2.3000 | 2.2500 | 2.5500 | 5.0000 | 33580.00 | 5750.00 | 14950.00 | 146 | 11 | 757 | 2568 | 0.294781931464174 | 0.886654326838616 | 0.886654326838616 | true | false | false | true | false | |||||||||||||||
| 49b0b67c-bf79-4b37-a1b2-cd8fa1d0d711 | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | PCT | PCT280121C00005000 | call | 5.0000 | 2028-01-21 | 2.3000 | 2.3000 | 2.5500 | 5.0000 | 13110.00 | 0.00 | 13110.00 | 57 | 5 | 814 | 2568 | 0.316978193146417 | 0.88849489787549 | 0.88849489787549 | false | false | false | true | false | |||||||||||||||
| 0d8b3c2a-7d51-45e3-add0-c410b6026cf8 | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | PCT | PCT280121C00005000 | call | 5.0000 | 2028-01-21 | 2.3000 | 2.2500 | 2.3000 | 5.0000 | 21390.00 | 21160.00 | 0.00 | 93 | 7 | 1020 | 2568 | 0.397196261682243 | 0.88849489787549 | 0.88849489787549 | false | false | false | true | false | |||||||||||||||
| 8fa0aab1-28a9-46f8-95fd-fb4e53f6bf4b | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | PCT | PCT280121C00005000 | call | 5.0000 | 2028-01-21 | 2.3000 | 2.2500 | 2.4500 | 5.0000 | 13570.00 | 1380.00 | 10810.00 | 59 | 5 | 1197 | 2568 | 0.466121495327103 | 0.89957025307274 | 0.89957025307274 | false | false | false | true | false | |||||||||||||||
| 14080a3a-9094-45b8-aa82-811473818205 | 2026-09-23 13:49 | 2026-09-23 13:49 | 2026-09-23 13:49 | PCT | PCT270319C00008000 | call | 8.0000 | 2027-03-19 | 0.7000 | 0.6000 | 0.7000 | 5.1450 | 148680.00 | 148680.00 | 0.00 | 2124 | 22 | 2774 | 10455 | 0.265327594452415 | 0.987711092903483 | 0.987711092903483 | false | false | false | true | false | |||||||||||||||
| 29dc995d-ee71-48b0-8d48-587b2ebf9f48 | 2026-09-23 13:50 | 2026-09-23 13:50 | 2026-09-23 13:50 | PCT | PCT270319C00008000 | call | 8.0000 | 2027-03-19 | 0.7000 | 0.6500 | 0.7000 | 5.2150 | 10500.00 | 10500.00 | 0.00 | 150 | 5 | 3023 | 10455 | 0.289143950263032 | 0.967821168194317 | 0.967821168194317 | false | false | false | true | false | |||||||||||||||
| 8df1fa29-ecb6-43e6-bb76-cefd7095addf | 2026-09-23 15:33 | 2026-09-23 15:32 | 2026-09-23 15:32 | PCT | PCT280121C00010000 | call | 10.0000 | 2028-01-21 | 1.3000 | 1.2500 | 1.3500 | 5.1350 | 25870.00 | 22230.00 | 260.00 | 199 | 6 | 3399 | 30418 | 0.111743046880137 | 0.9571664316671 | 0.9571664316671 | false | false | false | true | false | |||||||||||||||
| 8c21ffe0-469c-4898-a784-056c6f32524c | 2026-09-24 09:45 | 2026-09-24 09:45 | 2026-09-24 09:45 | PCT | PCT270319P00004000 | put | 4.0000 | 2027-03-19 | 0.6500 | 0.6500 | 0.8000 | 5.0192 | 19500.00 | 0.00 | 19500.00 | 300 | 5 | 300 | 160 | 1.875 | 0.921007710360728 | 0.921007710360728 | false | false | false | true | false | |||||||||||||||
| e3126dc5-2ccb-4b1c-b80f-199d25d4eaeb | 2026-09-24 09:46 | 2026-09-24 09:46 | 2026-09-24 09:46 | PCT | PCT261120P00005000 | put | 5.0000 | 2026-11-20 | 0.8000 | 0.6500 | 0.8000 | 5.0350 | 23990.00 | 23990.00 | 0.00 | 300 | 16 | 350 | 3867 | 0.0905094388414792 | 0.999491606452199 | 1.06427119625478 | false | false | false | true | false | |||||||||||||||
| a58b8bca-3a66-4e0e-bcc1-1cabfb7df8b9 | 2026-09-24 11:31 | 2026-09-24 11:31 | 2026-09-24 11:31 | PCT | PCT270319C00006000 | call | 6.0000 | 2027-03-19 | 0.9500 | 0.9000 | 0.9500 | 4.8750 | 48070.00 | 48070.00 | 0.00 | 506 | 18 | 859 | 31 | 27.7096774193548 | 0.955977849323457 | 0.955977849323457 | false | false | false | true | false | |||||||||||||||
| 1a7c1545-691f-42e5-9684-76387eff1d06 | 2026-09-24 11:33 | 2026-09-24 11:33 | 2026-09-24 11:33 | PCT | PCT270319C00006000 | call | 6.0000 | 2027-03-19 | 1.0000 | 0.9000 | 1.0000 | 4.9050 | 29600.00 | 29600.00 | 0.00 | 296 | 7 | 1155 | 31 | 37.258064516129 | 0.981309065465065 | 0.981309065465065 | false | false | false | true | false | |||||||||||||||
| 1e1a1247-570e-4b05-ad56-b57ed5c6f55e | 2026-09-24 11:33 | 2026-09-24 11:33 | 2026-09-24 11:33 | PCT | PCT270319C00006000 | call | 6.0000 | 2027-03-19 | 1.0000 | 0.9000 | 1.0000 | 4.9150 | 31000.00 | 31000.00 | 0.00 | 310 | 19 | 1465 | 31 | 47.258064516129 | 0.977399841364445 | 0.977399841364445 | false | false | false | true | false | |||||||||||||||
| a05ba41d-39f1-4b02-aa61-e1f808a1b976 | 2026-09-24 11:33 | 2026-09-24 11:33 | 2026-09-24 11:33 | PCT | PCT270319C00006000 | call | 6.0000 | 2027-03-19 | 1.0000 | 0.9000 | 1.0000 | 4.9250 | 26600.00 | 26600.00 | 0.00 | 266 | 19 | 2008 | 31 | 64.7741935483871 | 0.973496662856516 | 0.973496662856516 | false | false | false | true | false | |||||||||||||||
| 9249e510-e91e-43fb-959c-5cf69c296abb | 2026-09-24 11:33 | 2026-09-24 11:33 | 2026-09-24 11:33 | PCT | PCT270319C00006000 | call | 6.0000 | 2027-03-19 | 1.0000 | 0.9500 | 1.0000 | 4.9200 | 27700.00 | 27700.00 | 0.00 | 277 | 25 | 1742 | 31 | 56.1935483870968 | 0.975447500696824 | 0.975447500696824 | false | false | false | true | false | |||||||||||||||
| d4a97da9-6ad5-4585-b281-7267ec6545f4 | 2026-09-24 11:36 | 2026-09-24 11:36 | 2026-09-24 11:36 | PCT | PCT270319C00006000 | call | 6.0000 | 2027-03-19 | 1.0000 | 0.9500 | 1.0500 | 4.0000 | 75700.00 | 46100.00 | 21300.00 | 757 | 22 | 3383 | 31 | 109.129032258065 | 0.96376471636661 | 0.959882157987725 | false | false | false | true | false | |||||||||||||||
| a5ddd965-3d3c-4d12-b821-80889468f6ed | 2026-09-24 11:36 | 2026-09-24 11:36 | 2026-09-24 11:36 | PCT | PCT270319C00006000 | call | 6.0000 | 2027-03-19 | 1.0000 | 0.9500 | 1.0000 | 4.0000 | 46500.00 | 46500.00 | 0.00 | 465 | 8 | 2626 | 31 | 84.7096774193548 | 0.967653080655545 | 0.967653080655545 | false | false | false | true | false | |||||||||||||||
| ea17bf82-8476-419d-8201-b09f4f35d764 | 2026-09-24 11:36 | 2026-09-24 11:36 | 2026-09-24 11:36 | PCT | PCT270319C00006000 | call | 6.0000 | 2027-03-19 | 1.0000 | 0.9500 | 1.0000 | 4.0000 | 26500.00 | 26500.00 | 0.00 | 265 | 5 | 3648 | 31 | 117.677419354839 | 0.959882157987725 | 0.959882157987725 | false | false | false | true | false | |||||||||||||||
| afccfcbc-5681-4cb3-9224-8aa80754bb0d | 2026-09-24 11:37 | 2026-09-24 11:36 | 2026-09-24 11:36 | PCT | PCT270319C00006000 | call | 6.0000 | 2027-03-19 | 1.0000 | 0.9500 | 1.0000 | 4.0000 | 26500.00 | 26500.00 | 0.00 | 265 | 5 | 3913 | 31 | 126.225806451613 | 0.954069056903051 | 0.954069056903051 | false | false | false | true | false | |||||||||||||||
| 56afe1f7-f469-4923-a376-dfbe80566c98 | 2026-09-24 11:37 | 2026-09-24 11:36 | 2026-09-24 11:36 | PCT | PCT270319C00006000 | call | 6.0000 | 2027-03-19 | 1.0000 | 1.0000 | 1.0500 | 4.0000 | 24800.00 | 0.00 | 24800.00 | 248 | 6 | 4161 | 31 | 134.225806451613 | 0.956005337128384 | 0.959882157987725 | true | false | false | true | false | |||||||||||||||
| d1372f97-a45f-47ce-b925-76b6c22a99dc | 2026-09-24 12:19 | 2026-09-24 12:19 | 2026-09-24 12:19 | PCT | PCT270115P00005000 | put | 5.0000 | 2027-01-15 | 1.0000 | 0.9500 | 1.0500 | 5.0450 | 19400.00 | 0.00 | 15900.00 | 194 | 5 | 535 | 35940 | 0.0148859209794101 | 0.963697757448107 | 0.963697757448107 | false | false | false | true | false | |||||||||||||||
| 22ae2d1d-d61d-4bc0-889c-c7c83650720a | 2026-09-24 15:53 | 2026-09-24 15:53 | 2026-09-24 15:53 | PCT | PCT280121C00010000 | call | 10.0000 | 2028-01-21 | 1.2500 | 1.2000 | 1.3000 | 4.8850 | 12500.00 | 0.00 | 10000.00 | 100 | 5 | 2135 | 32626 | 0.0654386072457549 | 0.989865614751791 | 0.989865614751791 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:55:17.981841Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:55:17.981841Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:37:14.904379Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:47:07.799094Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:47:07.799094Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:39:15.853086Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:39:15.853086Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:39:15.853086Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:39:15.853086Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:39:15.853086Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:21:04.578939Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1034659772.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:53:57.742588Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |