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_alerts658,639 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 |
|---|
| c66e4e58-5ae1-4b0e-87d2-3f8a49e11b63 | 2026-09-30 15:50 | 2026-09-30 15:50 | 2026-09-30 15:50 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 4.0100 | 3.7000 | 4.2500 | 335.1700 | 16442.00 | 16057.00 | 385.00 | 41 | 9 | 13903 | 1830 | 7.59726775956284 | 0.265109643843423 | 0.300866774005888 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 4807322892000.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T19:50:15.606466Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| 36cc8277-4d2c-49a1-9d84-599f306b379a | 2026-09-30 15:47 | 2026-09-30 15:47 | 2026-09-30 15:47 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 3.9000 | 3.8500 | 3.9500 | 335.0700 | 11710.00 | 3910.00 | 0.00 | 30 | 5 | 13833 | 1830 | 7.55901639344262 | 0.258012505712212 | 0.258012505712212 | false | false | false | |||||||||||||||||
| 20d37227-c109-47c7-acd0-961e30875ced | 2026-09-30 14:00 | 2026-09-30 14:00 | 2026-09-30 14:00 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 3.2900 | 3.1500 | 3.4000 | 336.1100 | 16455.00 | 15510.00 | 945.00 | 50 | 6 | 12773 | 1830 | 6.97978142076503 | 0.244954168816509 | 0.260370470657906 | false | false | false | |||||||||||||||||
| c72d52b5-80cc-4aca-9510-e46d55453bda | 2026-09-30 12:07 | 2026-09-30 12:07 | 2026-09-30 12:07 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 2.7900 | 2.7500 | 2.7900 | 337.3550 | 27063.00 | 27063.00 | 0.00 | 97 | 18 | 10585 | 1830 | 5.78415300546448 | 0.276485477916351 | 0.276485477916351 | false | false | false | |||||||||||||||||
| 45faeea3-2df1-4c9a-a646-9154797ef6a8 | 2026-09-30 10:56 | 2026-09-30 10:56 | 2026-09-30 10:56 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 2.3300 | 2.3000 | 2.3400 | 338.0000 | 24209.00 | 18640.00 | 5569.00 | 104 | 6 | 7503 | 1830 | 4.1 | 0.296061276508873 | 0.296061276508873 | false | false | false | |||||||||||||||||
| e42c06f3-c6cc-4c6c-b1cc-06f32d6859cf | 2026-09-30 10:43 | 2026-09-30 10:43 | 2026-09-30 10:43 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 2.3900 | 2.3900 | 2.4000 | 338.6400 | 23900.00 | 0.00 | 23900.00 | 100 | 5 | 6644 | 1830 | 3.63060109289617 | 0.296300402040595 | 0.296300402040595 | false | false | false | |||||||||||||||||
| 40b31b28-f723-470e-b5ea-f6fca25be768 | 2026-09-30 10:33 | 2026-09-30 10:32 | 2026-09-30 10:32 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 2.6200 | 2.6000 | 2.6200 | 338.1200 | 24628.00 | 24628.00 | 0.00 | 94 | 5 | 6133 | 1830 | 3.35136612021858 | 0.296189365106139 | 0.296189365106139 | false | false | false | |||||||||||||||||
| 0bb2693f-b949-4ee4-9fae-84da3afc0626 | 2026-09-30 10:24 | 2026-09-30 10:24 | 2026-09-30 10:24 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 2.8400 | 2.7800 | 2.8400 | 337.7300 | 23004.00 | 23004.00 | 0.00 | 81 | 11 | 5667 | 1830 | 3.09672131147541 | 0.299923554896797 | 0.299923554896797 | false | false | false | |||||||||||||||||
| f8970478-69ed-48ca-8dfc-30aa9edbc533 | 2026-09-30 10:22 | 2026-09-30 10:21 | 2026-09-30 10:21 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 2.7600 | 2.7200 | 2.7600 | 337.8750 | 24012.00 | 24012.00 | 0.00 | 87 | 11 | 5495 | 1830 | 3.00273224043716 | 0.29881319504116 | 0.29881319504116 | false | false | false | |||||||||||||||||
| 2e23cb40-2b59-4213-b88a-9cdc4f44280e | 2026-09-30 10:13 | 2026-09-30 10:13 | 2026-09-30 10:13 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 2.6900 | 2.6500 | 2.7000 | 338.0000 | 28245.00 | 27976.00 | 0.00 | 105 | 21 | 4534 | 1830 | 2.4775956284153 | 0.304165809861621 | 0.304165809861621 | true | false | false | |||||||||||||||||
| a0387a2f-8b47-4ea4-9ed7-6fb022bd44e0 | 2026-09-30 10:12 | 2026-09-30 10:12 | 2026-09-30 10:12 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 2.6900 | 2.6800 | 2.7400 | 338.0000 | 31743.00 | 31473.00 | 270.00 | 118 | 5 | 4064 | 1830 | 2.2207650273224 | 0.304244525410169 | 0.30600297949967 | false | false | false | |||||||||||||||||
| 972da6f3-0454-46e4-872d-c4a1a384e66f | 2026-09-30 10:03 | 2026-09-30 10:03 | 2026-09-30 10:03 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 2.8500 | 2.8400 | 2.9400 | 337.7300 | 25081.00 | 286.00 | 24795.00 | 88 | 8 | 1622 | 1830 | 0.886338797814208 | 0.300927551644981 | 0.301931543308812 | false | false | false | |||||||||||||||||
| de07e1d2-58e8-4555-88e8-f5183676553d | 2026-09-29 09:31 | 2026-09-29 09:31 | 2026-09-29 09:31 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 5.9800 | 5.5500 | 6.3000 | 332.6500 | 17951.00 | 17351.00 | 600.00 | 30 | 7 | 370 | 2079 | 0.177970177970178 | 0.291932144395573 | 0.267874067730681 | true | false | false | |||||||||||||||||
| 681261c1-88f2-44f2-bb9f-f37043a1f8e9 | 2026-09-28 15:19 | 2026-09-28 15:19 | 2026-09-28 15:19 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 3.0000 | 2.9600 | 3.0000 | 338.3500 | 10491.00 | 10491.00 | 0.00 | 35 | 8 | 5125 | 1761 | 2.91027825099375 | 0.244996291524718 | 0.246423279602636 | true | false | false | |||||||||||||||||
| 37d33666-5a41-4fe9-b34d-b11d4023b453 | 2026-09-28 14:44 | 2026-09-28 14:44 | 2026-09-28 14:44 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 2.3400 | 2.3000 | 2.4500 | 339.9400 | 57330.00 | 0.00 | 57330.00 | 245 | 26 | 4339 | 1761 | 2.46394094264622 | 0.245271825266766 | 0.246251676563082 | true | false | false | |||||||||||||||||
| 7dee64bd-c432-44f0-bd79-8bf2ad8d974a | 2026-09-28 11:12 | 2026-09-28 11:12 | 2026-09-28 11:12 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 2.3300 | 2.3000 | 2.3300 | 340.2350 | 37513.00 | 37513.00 | 0.00 | 161 | 13 | 2501 | 1761 | 1.42021578648495 | 0.253686878904303 | 0.253686878904303 | false | false | false | |||||||||||||||||
| 77799641-6e7e-4f0a-a6c4-bf11bafba0e6 | 2026-09-28 10:36 | 2026-09-28 10:35 | 2026-09-28 10:35 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 2.0800 | 2.0800 | 2.1200 | 340.8400 | 45136.00 | 0.00 | 45136.00 | 217 | 13 | 1407 | 1761 | 0.798977853492334 | 0.251082333771287 | 0.251082333771287 | true | false | false | |||||||||||||||||
| f6bc7eed-aea9-47a1-8648-ab936b6687c8 | 2026-09-25 11:08 | 2026-09-25 11:08 | 2026-09-25 11:08 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 3.8500 | 3.8500 | 4.0500 | 337.8100 | 115500.00 | 0.00 | 115500.00 | 300 | 14 | 1029 | 1225 | 0.84 | 0.221405303538185 | 0.221405303538185 | false | false | false | |||||||||||||||||
| 018242da-e5f7-4ba4-af5d-ca48f3dee71d | 2026-09-24 13:25 | 2026-09-24 13:25 | 2026-09-24 13:25 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 4.2500 | 4.1000 | 4.2500 | 337.7900 | 38250.00 | 38250.00 | 0.00 | 90 | 7 | 950 | 749 | 1.26835781041389 | 0.227595260100505 | 0.227595260100505 | false | false | false | |||||||||||||||||
| 8355a02c-d639-4336-aa3c-6d47d1ab26c8 | 2026-09-21 15:04 | 2026-09-21 15:03 | 2026-09-21 15:03 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 4.9000 | 4.8000 | 4.9000 | 338.0000 | 45570.00 | 45570.00 | 0.00 | 93 | 13 | 1114 | 175 | 6.36571428571429 | 0.233770336610743 | 0.233770336610743 | false | false | false | |||||||||||||||||
| 0c0ffa81-c292-4937-adcb-9c21e710e08a | 2026-09-21 14:32 | 2026-09-21 14:32 | 2026-09-21 14:32 | AAPL | AAPL261002P00337500 | put | 337.5000 | 2026-10-02 | 4.8000 | 4.7000 | 4.8500 | 338.0000 | 16800.00 | 2400.00 | 0.00 | 35 | 6 | 881 | 175 | 5.03428571428571 | 0.236188619677005 | 0.236188619677005 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:50:15.606466Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T18:03:32.794352Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T16:13:44.335833Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:57:30.283739Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:46:23.879003Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:34:34.200174Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:27:44.285455Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:23:56.441043Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:14:21.800901Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:14:21.800901Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:05:50.172417Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:31:56.202644Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4938670512000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:23:02.177643Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4938670512000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:52:01.773916Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4938670512000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:13:28.016528Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4938670512000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:38:19.697231Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:11:41.812883Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:26:09.725902Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:06:05.917319Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:32:54.184324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |