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.
Simplify Analyticsuw_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 |
|---|
| d53a10ea-e6a7-440b-9e9f-864a7f15d008 | 2026-08-25 11:34 | 2026-08-25 11:34 | 2026-08-25 11:34 | APH | APH270617C00220000 | call | 220.0000 | 2027-06-17 | 10.4000 | 9.1000 | 11.2000 | 158.2600 | 144560.00 | 28080.00 | 116480.00 | 139 | 18 | 173 | 321 | 0.538940809968847 | 0.458572288057358 | 0.459121824601651 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 193701701095.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8153e76b-58a1-47fa-b02a-39a0f0a91316 | 2026-08-24 14:00 | 2026-08-24 14:00 | 2026-08-24 14:00 | APH | APH261218C00150000 | call | 150.0000 | 2026-12-18 | 19.2000 | 18.9000 | 19.4000 | 154.5300 | 113280.00 | 111360.00 | 1920.00 | 59 | 13 | 218 | 151 | 1.44370860927152 | 0.465806312374485 | 0.465806312374485 | false | false | false | true | ||||||||||||||||
| 9a2b6b67-5f5a-46f0-822d-7a880ca92ea0 | 2026-08-24 12:12 | 2026-08-24 12:12 | 2026-08-24 12:12 | APH | APH261016C00190000 | call | 190.0000 | 2026-10-16 | 1.4000 | 1.1500 | 1.4000 | 153.9500 | 50260.00 | 50260.00 | 0.00 | 359 | 24 | 417 | 716 | 0.582402234636871 | 0.429201917650317 | 0.429201917650317 | false | false | false | true | ||||||||||||||||
| 31fd0151-03cb-41ec-90ff-d9d15e1f29d0 | 2026-08-24 09:33 | 2026-08-24 09:33 | 2026-08-24 09:33 | APH | APH260918P00150000 | put | 150.0000 | 2026-09-18 | 5.0000 | 3.9000 | 6.0000 | 152.6000 | 84000.00 | 4500.00 | 500.00 | 168 | 55 | 172 | 1582 | 0.108723135271808 | 0.404842985993565 | 0.404842985993565 | false | false | false | true | ||||||||||||||||
| 65bebbea-d836-4e65-90b3-8c3d990da104 | 2026-08-21 15:24 | 2026-08-21 15:23 | 2026-08-21 15:23 | APH | APH261016C00165000 | call | 165.0000 | 2026-10-16 | 7.8000 | 7.6000 | 7.8000 | 157.9300 | 74100.00 | 74100.00 | 0.00 | 95 | 11 | 213 | 702 | 0.303418803418803 | 0.420966491732553 | 0.420966491732553 | false | false | false | true | ||||||||||||||||
| 01229164-f6d8-4cca-96d2-f7e2fe54c165 | 2026-08-21 14:11 | 2026-08-21 14:11 | 2026-08-21 14:11 | APH | APH261016C00160000 | call | 160.0000 | 2026-10-16 | 9.3000 | 9.0000 | 9.3000 | 156.0000 | 200880.00 | 200880.00 | 0.00 | 216 | 7 | 237 | 220 | 1.07727272727273 | 0.421750968518235 | 0.421750968518235 | false | false | false | true | ||||||||||||||||
| 4c89fb45-459a-44b7-85e6-e0040dcfe5d5 | 2026-08-21 11:44 | 2026-08-21 11:44 | 2026-08-21 11:44 | APH | APH260918C00150000 | call | 150.0000 | 2026-09-18 | 10.1000 | 9.9000 | 10.3000 | 155.1400 | 325220.00 | 316130.00 | 9090.00 | 322 | 10 | 335 | 708 | 0.47316384180791 | 0.413663561393884 | 0.413663561393884 | false | false | false | true | ||||||||||||||||
| 4b45ac91-430b-4f83-b426-4d1437f2ee9b | 2026-08-20 11:55 | 2026-08-20 11:55 | 2026-08-20 11:55 | APH | APH270115P00145000 | put | 145.0000 | 2027-01-15 | 12.2000 | 12.0000 | 12.4000 | 153.9100 | 51240.00 | 0.00 | 45140.00 | 42 | 13 | 280 | 191 | 1.46596858638743 | 0.459100288393565 | 0.459100288393565 | false | false | false | true | ||||||||||||||||
| 96e98ed6-718d-4ae5-8d24-d65c1d76033f | 2026-08-20 10:28 | 2026-08-20 10:28 | 2026-08-20 10:28 | APH | APH260918C00150000 | call | 150.0000 | 2026-09-18 | 10.6000 | 10.6000 | 10.9000 | 155.3900 | 147340.00 | 0.00 | 147340.00 | 139 | 5 | 139 | 422 | 0.329383886255924 | 0.426826601473004 | 0.426826601473004 | false | false | false | true | ||||||||||||||||
| 30219681-3688-4dc3-abb1-f815ca9b6add | 2026-08-20 10:08 | 2026-08-20 10:08 | 2026-08-20 10:08 | APH | APH270617C00200000 | call | 200.0000 | 2027-06-17 | 13.7000 | 13.3000 | 14.3000 | 154.5600 | 200020.00 | 172620.00 | 27400.00 | 146 | 13 | 186 | 366 | 0.508196721311475 | 0.46737226965751 | 0.46737226965751 | true | false | false | true | ||||||||||||||||
| 46714939-fce8-4ac1-9345-61f6350ff825 | 2026-08-19 15:22 | 2026-08-19 15:22 | 2026-08-19 15:22 | APH | APH270617C00200000 | call | 200.0000 | 2027-06-17 | 14.1000 | 13.6000 | 16.0000 | 156.2700 | 188940.00 | 132540.00 | 56400.00 | 134 | 7 | 174 | 449 | 0.387527839643653 | 0.46196053527623 | 0.46196053527623 | true | false | false | true | ||||||||||||||||
| f711a16f-6507-4b82-9394-76692e56725c | 2026-08-19 12:01 | 2026-08-19 12:01 | 2026-08-19 12:01 | APH | APH261120P00160000 | put | 160.0000 | 2026-11-20 | 15.6000 | 15.6000 | 16.1000 | 157.0650 | 56160.00 | 0.00 | 56160.00 | 36 | 14 | 287 | 160 | 1.79375 | 0.470463683088792 | 0.470463683088792 | false | false | false | true | false | |||||||||||||||
| 8f9cb9b0-e2b9-4fc4-aa32-8254920eee8c | 2026-08-18 14:53 | 2026-08-18 14:53 | 2026-08-18 14:53 | APH | APH270617P00125000 | put | 125.0000 | 2027-06-17 | 9.9400 | 9.9000 | 10.5000 | 158.8450 | 337966.00 | 0.00 | 337966.00 | 340 | 26 | 503 | 17 | 29.5882352941176 | 0.488718731932317 | 0.484785424029538 | false | false | false | true | ||||||||||||||||
| 88de13f3-0b48-4d9a-ba50-2db41ad45df2 | 2026-08-18 14:53 | 2026-08-18 14:53 | 2026-08-18 14:53 | APH | APH270617P00125000 | put | 125.0000 | 2027-06-17 | 10.0000 | 9.9000 | 10.5000 | 158.9100 | 159934.00 | 0.00 | 159934.00 | 160 | 7 | 163 | 17 | 9.58823529411765 | 0.489531584722624 | 0.487074951503518 | false | false | false | true | ||||||||||||||||
| ea0cf552-2572-43ea-a292-bd98f22d5d8e | 2026-08-18 10:40 | 2026-08-18 10:40 | 2026-08-18 10:40 | APH | APH261218C00155000 | call | 155.0000 | 2026-12-18 | 20.9000 | 20.9000 | 21.9000 | 161.0650 | 85691.00 | 0.00 | 85691.00 | 41 | 7 | 45 | 403 | 0.11166253101737 | 0.458055727833271 | 0.458055727833271 | false | false | false | true | ||||||||||||||||
| eb3d0796-0193-4401-8727-d2305ebceb44 | 2026-08-17 12:13 | 2026-08-17 12:13 | 2026-08-17 12:13 | APH | APH270115P00150000 | put | 150.0000 | 2027-01-15 | 9.4000 | 9.4000 | 9.8000 | 171.1100 | 235094.00 | 0.00 | 235094.00 | 250 | 29 | 250 | 133 | 1.8796992481203 | 0.464943584862071 | 0.46438285889681 | false | false | false | true | ||||||||||||||||
| a581f458-db18-4792-a3d0-2b6652f5457f | 2026-08-17 12:03 | 2026-08-17 12:03 | 2026-08-17 12:03 | APH | APH260821C00170000 | call | 170.0000 | 2026-08-21 | 3.7000 | 3.5000 | 3.7000 | 170.7200 | 55500.00 | 55500.00 | 0.00 | 150 | 8 | 209 | 1916 | 0.109081419624217 | 0.462502752692176 | 0.462502752692176 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T16:14:40.561585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:38:06.174043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| 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 |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 193701701095.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |