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_alerts474,253 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 |
|---|
| d73441c3-d50d-4a01-902f-224338dfdf7a | 2026-09-21 15:16 | 2026-09-21 15:16 | 2026-09-21 15:16 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 2.1300 | 2.1300 | 2.1500 | 351.3800 | 50694.00 | 0.00 | 50694.00 | 238 | 18 | 582 | 2203 | 0.264185201997276 | 0.313097715669684 | 0.312679303211589 | 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-21T19:21:01.961528Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 4bf0c38a-cfda-4415-a49d-06903660213b | 2026-09-21 15:16 | 2026-09-21 15:16 | 2026-09-21 15:16 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 2.2300 | 2.2300 | 2.2600 | 351.4300 | 82510.00 | 0.00 | 82510.00 | 370 | 29 | 1023 | 2203 | 0.464366772582842 | 0.316980638825219 | 0.316980638825219 | false | false | false | true | ||||||||||||||||
| 1e7416fa-3264-4990-befd-9e2a5469582e | 2026-09-21 15:16 | 2026-09-21 15:16 | 2026-09-21 15:16 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 2.2400 | 2.2400 | 2.2600 | 351.4050 | 49056.00 | 0.00 | 49056.00 | 219 | 8 | 1242 | 2203 | 0.563776668179755 | 0.317617360045524 | 0.317617360045524 | false | false | false | true | ||||||||||||||||
| 32ffa29b-f9e1-4711-8eb4-b238ac8b4535 | 2026-09-21 15:19 | 2026-09-21 15:19 | 2026-09-21 15:19 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 2.2800 | 2.2800 | 2.2800 | 351.3500 | 646836.00 | 0.00 | 0.00 | 2837 | 23 | 4142 | 2203 | 1.88016341352701 | 0.319841756858515 | 0.319841756858515 | false | false | false | true | ||||||||||||||||
| 8eda3460-f71b-4f36-a613-123783dac888 | 2026-09-21 15:19 | 2026-09-21 15:19 | 2026-09-21 15:19 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 2.2900 | 2.2800 | 2.3000 | 351.4400 | 222130.00 | 14656.00 | 46258.00 | 970 | 23 | 5311 | 2203 | 2.41080344984113 | 0.319662980366302 | 0.319662980366302 | false | false | false | true | ||||||||||||||||
| 7de7a97f-2943-444f-9d25-5948a594ff43 | 2026-09-21 15:20 | 2026-09-21 15:20 | 2026-09-21 15:20 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 2.2500 | 2.2500 | 2.3000 | 351.3550 | 14850.00 | 0.00 | 14850.00 | 66 | 11 | 5425 | 2203 | 2.46255106672719 | 0.318429744817502 | 0.318429744817502 | false | false | false | true | ||||||||||||||||
| 5f6230b3-3cf6-4489-a111-5d5c04c627bc | 2026-09-22 09:31 | 2026-09-22 09:31 | 2026-09-22 09:31 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 2.5100 | 2.3800 | 2.5100 | 353.7600 | 112827.00 | 112827.00 | 0.00 | 450 | 14 | 451 | 6051 | 0.0745331350190051 | 0.319543352011723 | 0.319543352011723 | false | false | false | true | ||||||||||||||||
| c1b7065d-2b26-4a30-a4f0-a72e0cde35f3 | 2026-09-22 10:00 | 2026-09-22 10:00 | 2026-09-22 10:00 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 2.8500 | 2.7500 | 2.8500 | 356.0000 | 10545.00 | 10545.00 | 0.00 | 37 | 13 | 948 | 6051 | 0.156668319286068 | 0.316234054301355 | 0.316234054301355 | false | false | false | true | ||||||||||||||||
| de5af7cf-dc1b-4cd6-aeb1-8b9ac928658d | 2026-09-22 11:12 | 2026-09-22 11:12 | 2026-09-22 11:12 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 2.4900 | 2.4200 | 2.5000 | 353.8200 | 99538.00 | 91881.00 | 7657.00 | 400 | 8 | 1808 | 6051 | 0.298793587836721 | 0.317344526271925 | 0.318223659886743 | true | false | false | true | ||||||||||||||||
| 2c848cc3-7e66-4b9f-93cd-1b81544619e4 | 2026-09-22 11:35 | 2026-09-22 11:35 | 2026-09-22 11:35 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 2.2400 | 2.1800 | 2.2400 | 351.9596 | 89600.00 | 89600.00 | 0.00 | 400 | 5 | 2272 | 6051 | 0.375475128078004 | 0.320459374043882 | 0.320459374043882 | false | false | false | true | ||||||||||||||||
| 609edcb4-6a53-4945-a7c9-a934a6ec4b2c | 2026-09-22 11:46 | 2026-09-22 11:45 | 2026-09-22 11:45 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 2.1700 | 2.1200 | 2.1800 | 351.6400 | 10872.00 | 9374.00 | 1498.00 | 50 | 7 | 2327 | 6051 | 0.384564534787638 | 0.319930606086477 | 0.318030103589419 | false | false | false | true | ||||||||||||||||
| cf449e32-2c6f-4170-9b8a-7f2a87c249e2 | 2026-09-22 12:34 | 2026-09-22 12:34 | 2026-09-22 12:34 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 1.6600 | 1.5900 | 1.6600 | 346.8550 | 18758.00 | 18758.00 | 0.00 | 113 | 7 | 2490 | 6051 | 0.411502231036192 | 0.326458192212722 | 0.326458192212722 | false | false | false | true | ||||||||||||||||
| e082a1b2-2273-4aa9-92ff-04172d9a2f6d | 2026-09-22 14:45 | 2026-09-22 14:45 | 2026-09-22 14:45 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 1.9700 | 1.9700 | 2.0000 | 349.1400 | 29550.00 | 0.00 | 29550.00 | 150 | 21 | 2896 | 6051 | 0.478598578747314 | 0.327300533632682 | 0.327300533632682 | false | false | false | true | ||||||||||||||||
| 98909e1e-8333-4ed9-8e74-f86dd65be405 | 2026-09-22 15:52 | 2026-09-22 15:52 | 2026-09-22 15:52 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 1.8400 | 1.8000 | 1.8500 | 347.8400 | 48680.00 | 48680.00 | 0.00 | 264 | 12 | 3188 | 6051 | 0.526855065278466 | 0.330093513301843 | 0.330093513301843 | true | false | false | true | ||||||||||||||||
| 0a73a37f-7564-4a82-93cb-e0c5165c86cc | 2026-09-23 10:50 | 2026-09-23 10:50 | 2026-09-23 10:50 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 1.0000 | 1.0000 | 1.0400 | 338.3800 | 54601.00 | 0.00 | 54601.00 | 546 | 16 | 2110 | 8604 | 0.245234774523477 | 0.345996834554304 | 0.345193077590452 | false | false | false | true | ||||||||||||||||
| 6327894a-da3f-4ddc-b4db-ddc2b705835e | 2026-09-23 11:26 | 2026-09-23 11:26 | 2026-09-23 11:26 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 0.9800 | 0.9800 | 1.0600 | 337.9050 | 104566.00 | 0.00 | 104566.00 | 1067 | 40 | 3620 | 8604 | 0.420734542073454 | 0.346556400992351 | 0.346556400992351 | false | false | false | true | ||||||||||||||||
| 76ab8f63-fb22-4bfa-8c05-611ff78cef10 | 2026-09-23 12:19 | 2026-09-23 12:19 | 2026-09-23 12:19 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 0.9200 | 0.9200 | 0.9700 | 336.9000 | 68632.00 | 0.00 | 68632.00 | 746 | 27 | 4386 | 8604 | 0.50976290097629 | 0.347753157521697 | 0.347815341365838 | true | false | false | true | ||||||||||||||||
| e0c7c07e-c1c3-471b-87d8-a3d63014390b | 2026-09-23 12:45 | 2026-09-23 12:45 | 2026-09-23 12:45 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 0.8700 | 0.8600 | 0.9200 | 335.2800 | 21571.00 | 0.00 | 21571.00 | 248 | 11 | 4642 | 8604 | 0.53951650395165 | 0.35256306039935 | 0.353463978864546 | false | false | false | true | ||||||||||||||||
| 25a654b5-1e22-4234-8ee2-c5a5c6a1a7ea | 2026-09-23 14:23 | 2026-09-23 14:23 | 2026-09-23 14:23 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 0.9600 | 0.9400 | 0.9700 | 336.0000 | 20160.00 | 20160.00 | 0.00 | 210 | 5 | 5005 | 8604 | 0.581706183170618 | 0.35552092080661 | 0.35552092080661 | false | false | false | true | ||||||||||||||||
| fc280ed4-6d0f-4aa4-949d-74ac44e5e1cc | 2026-09-24 10:34 | 2026-09-24 10:34 | 2026-09-24 10:34 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 0.7200 | 0.7200 | 0.8200 | 335.0700 | 59256.00 | 0.00 | 59256.00 | 823 | 7 | 932 | 8291 | 0.112411048124472 | 0.348335881353797 | 0.348427797155223 | false | false | false | true | ||||||||||||||||
| d15dc170-a523-4d1e-9b5b-aabe436a59a9 | 2026-09-24 10:34 | 2026-09-24 10:34 | 2026-09-24 10:34 | GOOG | GOOG261016C00385000 | call | 385.0000 | 2026-10-16 | 0.7300 | 0.7300 | 0.7800 | 335.0700 | 18980.00 | 0.00 | 18980.00 | 260 | 17 | 1246 | 8291 | 0.150283439874563 | 0.349441606342616 | 0.349441606342616 | false | 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-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-22T13:32:27.895939Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T14:01:27.900775Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T15:15:45.651673Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T15:38:41.762966Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T15:49:01.734970Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T16:35:05.886735Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T18:55:20.077577Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-23T14:51:34.694161Z"} |
| 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-23T15:28:13.578365Z"} |
| 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-23T16:24:45.701241Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T16:47:02.093743Z"} |
| 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-23T18:27:32.623000Z"} |
| 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-24T14:35:45.310206Z"} |
| 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 |