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 | 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 |
|---|
| ea9b208e-9d45-4e01-aa39-31fdf0852169 | 2026-09-23 10:53 | 2026-09-23 10:53 | 2026-09-23 10:53 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 6.1000 | 5.9000 | 6.1000 | 338.6100 | 82350.00 | 82350.00 | 0.00 | 135 | 5 | 712 | 740 | 0.962162162162162 | 0.401335455938901 | 0.401335455938901 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1879382770000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T14:54:01.895756Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| c8a92094-9699-473c-abed-d213261c6d56 | 2026-09-23 12:37 | 2026-09-23 12:37 | 2026-09-23 12:37 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 4.3500 | 4.3500 | 4.4000 | 336.0400 | 20880.00 | 0.00 | 20880.00 | 48 | 25 | 1326 | 740 | 1.79189189189189 | 0.380286520296441 | 0.380286520296441 | true | false | false | true | ||||||||||||||||
| c1308b55-c0b2-49f6-8646-646936be7861 | 2026-09-23 12:59 | 2026-09-23 12:59 | 2026-09-23 12:59 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 3.6500 | 3.6500 | 3.7500 | 334.6500 | 32850.00 | 0.00 | 32850.00 | 90 | 8 | 2128 | 740 | 2.87567567567568 | 0.383049816893443 | 0.383049816893443 | false | false | false | true | ||||||||||||||||
| 18e95171-a9a5-449e-a254-0c09f22714b4 | 2026-09-23 15:03 | 2026-09-23 15:03 | 2026-09-23 15:03 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 4.1500 | 4.1000 | 4.1500 | 335.7000 | 10375.00 | 10375.00 | 0.00 | 25 | 10 | 3346 | 740 | 4.52162162162162 | 0.378809038814035 | 0.378809038814035 | false | false | false | true | ||||||||||||||||
| a34f5efb-6130-42a4-9e91-69285cd76eb1 | 2026-09-23 15:08 | 2026-09-23 15:08 | 2026-09-23 15:08 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 4.1500 | 4.0500 | 4.1500 | 335.7750 | 18260.00 | 18260.00 | 0.00 | 44 | 8 | 3407 | 740 | 4.60405405405405 | 0.37470293401072 | 0.37470293401072 | false | false | false | true | ||||||||||||||||
| fe5c4436-ec39-4dfc-93f9-629cb60df9bc | 2026-09-23 15:09 | 2026-09-23 15:09 | 2026-09-23 15:09 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 4.1500 | 4.1500 | 4.2000 | 335.7100 | 21580.00 | 0.00 | 21580.00 | 52 | 15 | 3460 | 740 | 4.67567567567568 | 0.378263242981136 | 0.378263242981136 | false | false | false | true | ||||||||||||||||
| 1f5fee46-df72-4250-82ab-e98134002688 | 2026-09-23 15:29 | 2026-09-23 15:29 | 2026-09-23 15:29 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 4.1000 | 4.0000 | 4.1000 | 335.0000 | 20500.00 | 20500.00 | 0.00 | 50 | 6 | 3592 | 740 | 4.85405405405405 | 0.380796209577162 | 0.380796209577162 | false | false | false | true | ||||||||||||||||
| 9d9b0ce7-dd92-4c15-b8fb-8f18de7e0997 | 2026-09-23 15:42 | 2026-09-23 15:42 | 2026-09-23 15:42 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 3.6000 | 3.6000 | 3.7000 | 334.0000 | 13320.00 | 0.00 | 13320.00 | 37 | 11 | 3854 | 740 | 5.20810810810811 | 0.37599289251841 | 0.37599289251841 | false | false | false | true | ||||||||||||||||
| d636bf67-d2c4-44d9-a21e-09d4f9e30dbc | 2026-09-23 15:54 | 2026-09-23 15:54 | 2026-09-23 15:54 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 3.5700 | 3.4500 | 3.7000 | 334.7700 | 40328.00 | 31328.00 | 9000.00 | 113 | 5 | 4208 | 740 | 5.68648648648649 | 0.371965144420032 | 0.367919037026198 | false | false | false | true | ||||||||||||||||
| 84cb95f1-a8c5-45fb-96a9-5a3610858413 | 2026-09-23 15:55 | 2026-09-23 15:55 | 2026-09-23 15:55 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 3.7300 | 3.6000 | 3.7500 | 334.9199 | 74500.00 | 74500.00 | 0.00 | 200 | 11 | 4455 | 740 | 6.02027027027027 | 0.380030138305317 | 0.374468735120621 | false | false | false | true | ||||||||||||||||
| b870e693-a2cf-474d-b132-fb334386a04b | 2026-09-24 09:34 | 2026-09-24 09:34 | 2026-09-24 09:34 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 2.7400 | 2.7400 | 2.8000 | 334.3750 | 21098.00 | 0.00 | 21098.00 | 77 | 16 | 420 | 1908 | 0.220125786163522 | 0.432880582808101 | 0.432880582808101 | false | false | false | true | ||||||||||||||||
| 4de419e1-d4e2-481e-b231-9a8862fd7b4e | 2026-09-24 09:35 | 2026-09-24 09:35 | 2026-09-24 09:35 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 3.2000 | 3.1000 | 3.2000 | 335.1000 | 12800.00 | 12800.00 | 0.00 | 40 | 6 | 502 | 1908 | 0.263102725366876 | 0.447582911394564 | 0.447582911394564 | true | false | false | true | ||||||||||||||||
| 15daeb92-6619-433e-b3ff-8474e68e54ad | 2026-09-24 09:43 | 2026-09-24 09:42 | 2026-09-24 09:42 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 2.7400 | 2.5900 | 2.7500 | 334.5002 | 12878.00 | 12878.00 | 0.00 | 47 | 12 | 1048 | 1908 | 0.549266247379455 | 0.424322022133522 | 0.424322022133522 | true | false | false | true | ||||||||||||||||
| 927e4021-d0db-4169-928c-cc5a43942244 | 2026-09-24 09:43 | 2026-09-24 09:43 | 2026-09-24 09:43 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 2.5700 | 2.4700 | 2.5700 | 334.0394 | 38550.00 | 38550.00 | 0.00 | 150 | 6 | 1324 | 1908 | 0.693920335429769 | 0.430857990348304 | 0.430857990348304 | false | false | false | true | ||||||||||||||||
| 1c87951f-0286-402f-ad4e-32228a9c9e77 | 2026-09-24 10:04 | 2026-09-24 10:04 | 2026-09-24 10:04 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 2.8700 | 2.8700 | 2.9600 | 335.3000 | 28700.00 | 0.00 | 28700.00 | 100 | 7 | 2187 | 1908 | 1.14622641509434 | 0.385590664768045 | 0.385590664768045 | false | false | false | true | ||||||||||||||||
| 5ba38372-cf48-4000-9d7f-13d035e72fae | 2026-09-24 10:09 | 2026-09-24 10:09 | 2026-09-24 10:09 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 3.3000 | 3.2000 | 3.3000 | 335.9100 | 20130.00 | 20130.00 | 0.00 | 61 | 5 | 2344 | 1908 | 1.22851153039832 | 0.399935115010205 | 0.399935115010205 | true | false | false | true | ||||||||||||||||
| 75361aed-0879-4877-a962-1c975b2966a8 | 2026-09-24 10:34 | 2026-09-24 10:34 | 2026-09-24 10:34 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 2.8000 | 2.7600 | 2.8000 | 335.0350 | 14280.00 | 14280.00 | 0.00 | 51 | 8 | 3375 | 1908 | 1.7688679245283 | 0.395134685712132 | 0.395134685712132 | false | false | false | true | ||||||||||||||||
| fc4e9749-b7ab-46d2-8b21-c9c6de4b2406 | 2026-09-24 10:52 | 2026-09-24 10:52 | 2026-09-24 10:52 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 3.5500 | 3.4500 | 3.5500 | 336.3150 | 15957.00 | 15957.00 | 0.00 | 45 | 7 | 3927 | 1908 | 2.05817610062893 | 0.401319017728291 | 0.401319017728291 | false | false | false | true | ||||||||||||||||
| d10d2f15-7691-4a28-b6dc-775dbb2778b5 | 2026-09-24 11:03 | 2026-09-24 11:03 | 2026-09-24 11:03 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 2.5800 | 2.5700 | 2.5800 | 334.6400 | 76356.00 | 73272.00 | 3084.00 | 296 | 13 | 4546 | 1908 | 2.38259958071279 | 0.390303806160469 | 0.390303806160469 | true | false | false | true | ||||||||||||||||
| b72085e4-e1c4-4c84-a435-d76a99f615e7 | 2026-09-24 11:13 | 2026-09-24 11:12 | 2026-09-24 11:12 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 2.2300 | 2.1900 | 2.2800 | 333.0000 | 17842.00 | 0.00 | 17619.00 | 80 | 6 | 4773 | 1908 | 2.50157232704403 | 0.391083621371811 | 0.38818731692332 | false | false | false | true | ||||||||||||||||
| 85a45a37-4c42-4d82-857f-2b519a88f7b6 | 2026-09-24 11:27 | 2026-09-24 11:27 | 2026-09-24 11:27 | GOOG | GOOG260925C00335000 | call | 335.0000 | 2026-09-25 | 2.4900 | 2.4600 | 2.4900 | 334.5600 | 12450.00 | 12450.00 | 0.00 | 50 | 7 | 5360 | 1908 | 2.80922431865828 | 0.384374992825589 | 0.384374992825589 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:39:09.093031Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:01:20.516262Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:05:07.702473Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:12:23.721983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:12:23.721983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:31:17.816750Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:47:37.737983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:57:58.068578Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:57:58.068578Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:35:42.562828Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:37:11.678086Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:45:09.673618Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:45:09.673618Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:06:35.686187Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:10:55.671270Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:35:45.310206Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:53:28.868411Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:05:25.664270Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:14:35.650072Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:29:44.716579Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |