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 |
|---|
| 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 |
|---|
| 040a5281-87fe-41f3-bc2f-e87a292a5d1a | 2026-09-21 10:43 | 2026-09-21 10:43 | 2026-09-21 10:43 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 7.5000 | 7.4500 | 7.5500 | 351.0000 | 10500.00 | 0.00 | 9750.00 | 14 | 6 | 646 | 1128 | 0.572695035460993 | 0.337388734000834 | 0.33833762647988 | false | false | false | true | false | 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-21T14:45:07.990945Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 29d229a5-051b-4f76-bca8-e54ad50be522 | 2026-09-21 11:28 | 2026-09-21 11:28 | 2026-09-21 11:28 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 7.7000 | 7.7000 | 7.8500 | 352.0525 | 21560.00 | 0.00 | 21560.00 | 28 | 6 | 706 | 1128 | 0.625886524822695 | 0.343922759035248 | 0.343922759035248 | false | false | false | true | ||||||||||||||||
| e3a64f1d-df35-4df4-8109-0e2a31e4f0ec | 2026-09-21 11:31 | 2026-09-21 11:31 | 2026-09-21 11:31 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 7.6500 | 7.6000 | 7.8500 | 352.0600 | 20655.00 | 0.00 | 20655.00 | 27 | 7 | 733 | 1128 | 0.649822695035461 | 0.338352359523664 | 0.338352359523664 | false | false | false | true | ||||||||||||||||
| f3e05d21-cb32-4f1d-911b-80bc266f8ab3 | 2026-09-21 15:52 | 2026-09-21 15:52 | 2026-09-21 15:52 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 7.4500 | 7.4500 | 7.6000 | 351.6900 | 22350.00 | 0.00 | 22350.00 | 30 | 5 | 978 | 1128 | 0.867021276595745 | 0.3412806470735 | 0.3412806470735 | false | false | false | true | ||||||||||||||||
| 5cc20141-da10-4f67-99ea-1b468fe62dc1 | 2026-09-22 12:22 | 2026-09-22 12:22 | 2026-09-22 12:22 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 5.2500 | 5.1500 | 5.3000 | 348.5000 | 22575.00 | 22050.00 | 0.00 | 43 | 8 | 842 | 1095 | 0.768949771689498 | 0.371300318952024 | 0.371300318952024 | false | false | false | true | ||||||||||||||||
| 50f6f9a8-c6fe-42b7-af0b-1c8ed3faa09c | 2026-09-22 12:32 | 2026-09-22 12:32 | 2026-09-22 12:32 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 4.1500 | 4.1500 | 4.2500 | 345.9350 | 24900.00 | 0.00 | 24900.00 | 60 | 5 | 1217 | 1095 | 1.11141552511416 | 0.386153468773972 | 0.386153468773972 | false | false | false | true | ||||||||||||||||
| 3e1ea89a-3a05-460c-9973-09bc62b4e2cc | 2026-09-22 13:00 | 2026-09-22 13:00 | 2026-09-22 13:00 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 4.2500 | 4.2000 | 4.3000 | 346.0000 | 12755.00 | 2150.00 | 8480.00 | 30 | 5 | 1709 | 1095 | 1.56073059360731 | 0.384188206906418 | 0.379385344404201 | false | false | false | true | ||||||||||||||||
| eccb9f08-1011-4bd4-b65f-7b7f2d9d4dc6 | 2026-09-22 15:11 | 2026-09-22 15:11 | 2026-09-22 15:11 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 5.0000 | 4.9500 | 5.0500 | 348.1300 | 16000.00 | 15500.00 | 500.00 | 32 | 10 | 3128 | 1095 | 2.85662100456621 | 0.368520358326131 | 0.36724954426061 | false | false | false | true | ||||||||||||||||
| 9e2ae913-e7c5-4f12-a99f-c760d3575e22 | 2026-09-22 15:50 | 2026-09-22 15:50 | 2026-09-22 15:50 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 5.0500 | 4.9000 | 5.5500 | 348.4900 | 22235.00 | 21215.00 | 1020.00 | 44 | 9 | 3411 | 1095 | 3.11506849315069 | 0.36441132226551 | 0.359758917230814 | true | false | false | true | ||||||||||||||||
| 5cf58a05-ca0c-47ad-b540-99eca8f8c603 | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 1.9400 | 1.8900 | 1.9500 | 342.0000 | 52962.00 | 28130.00 | 24832.00 | 273 | 9 | 847 | 1406 | 0.602418207681366 | 0.380801273120922 | 0.381151143509933 | false | false | false | true | ||||||||||||||||
| 6b34c4e6-5846-4788-a20e-47a738e97339 | 2026-09-23 09:51 | 2026-09-23 09:51 | 2026-09-23 09:51 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 1.8100 | 1.7700 | 1.8100 | 342.1900 | 72186.00 | 66246.00 | 5940.00 | 399 | 11 | 2044 | 1406 | 1.45376955903272 | 0.37992283154747 | 0.38088860546997 | false | false | false | true | ||||||||||||||||
| 000179bf-5715-4257-acc2-2e31f77a9888 | 2026-09-23 09:51 | 2026-09-23 09:51 | 2026-09-23 09:51 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 1.8000 | 1.7800 | 1.8000 | 342.1800 | 13852.00 | 12420.00 | 0.00 | 77 | 9 | 2282 | 1406 | 1.62304409672831 | 0.380092937392963 | 0.380092937392963 | false | false | false | true | ||||||||||||||||
| e084abce-246b-41ad-9def-61b8e731cb58 | 2026-09-23 09:53 | 2026-09-23 09:53 | 2026-09-23 09:53 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 1.7100 | 1.6600 | 1.7100 | 341.8300 | 22572.00 | 22572.00 | 0.00 | 132 | 9 | 3445 | 1406 | 2.450213371266 | 0.381548054337474 | 0.381548054337474 | false | false | false | true | ||||||||||||||||
| 9d8084ca-515f-4a76-ba4c-8a7bb72075f4 | 2026-09-23 09:53 | 2026-09-23 09:53 | 2026-09-23 09:53 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 1.7100 | 1.6600 | 1.7100 | 341.8300 | 24453.00 | 24453.00 | 0.00 | 143 | 7 | 3589 | 1406 | 2.55263157894737 | 0.381548054337474 | 0.381548054337474 | false | false | false | true | ||||||||||||||||
| 2d5c0d02-14e8-43a6-9218-a1ca042157f0 | 2026-09-23 09:53 | 2026-09-23 09:53 | 2026-09-23 09:53 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 1.7300 | 1.6800 | 1.7300 | 341.9400 | 12629.00 | 12629.00 | 0.00 | 73 | 13 | 3677 | 1406 | 2.61522048364154 | 0.380183732253843 | 0.380183732253843 | false | false | false | true | ||||||||||||||||
| e3778fd6-1931-4762-8580-36e28d72020a | 2026-09-23 09:54 | 2026-09-23 09:54 | 2026-09-23 09:54 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 1.6600 | 1.6000 | 1.6600 | 341.4600 | 83000.00 | 83000.00 | 0.00 | 500 | 41 | 4232 | 1406 | 3.0099573257468 | 0.387933489705239 | 0.387933489705239 | false | false | false | true | ||||||||||||||||
| a7c0389c-53dc-49c3-bb34-f6c1c46447b6 | 2026-09-23 09:54 | 2026-09-23 09:54 | 2026-09-23 09:54 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 1.6600 | 1.6300 | 1.6600 | 341.5000 | 82942.00 | 82942.00 | 0.00 | 500 | 33 | 4735 | 1406 | 3.36770981507824 | 0.386621162162937 | 0.385442718941241 | true | false | false | true | ||||||||||||||||
| 9f9463b6-98ca-44a3-a605-4df827b48ec0 | 2026-09-23 09:57 | 2026-09-23 09:57 | 2026-09-23 09:57 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 1.5100 | 1.4900 | 1.5100 | 340.4900 | 75500.00 | 75500.00 | 0.00 | 500 | 8 | 5788 | 1406 | 4.11664295874822 | 0.400920637771649 | 0.400920637771649 | false | false | false | true | ||||||||||||||||
| 50bc2cbb-ee4c-4782-9486-9cb08347602d | 2026-09-23 09:59 | 2026-09-23 09:59 | 2026-09-23 09:59 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 1.4500 | 1.4500 | 1.4600 | 340.0500 | 73950.00 | 0.00 | 73950.00 | 510 | 5 | 6831 | 1406 | 4.85846372688478 | 0.407084530338792 | 0.407084530338792 | false | false | false | true | ||||||||||||||||
| 941e68d0-4f46-4861-ae18-d5fdb2d3f06d | 2026-09-23 09:59 | 2026-09-23 09:59 | 2026-09-23 09:59 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 1.4300 | 1.4100 | 1.4400 | 339.9506 | 14258.00 | 4176.00 | 10082.00 | 100 | 5 | 6963 | 1406 | 4.95234708392603 | 0.405721881772372 | 0.406316588589648 | true | false | false | true | ||||||||||||||||
| 9808380b-9d3c-4faa-9cc3-41e3f08534d0 | 2026-09-23 10:18 | 2026-09-23 10:18 | 2026-09-23 10:18 | GOOG | GOOG260925C00347500 | call | 347.5000 | 2026-09-25 | 1.0000 | 1.0000 | 1.0500 | 336.0000 | 14000.00 | 0.00 | 14000.00 | 140 | 8 | 7462 | 1406 | 5.3072546230441 | 0.435223022106534 | 0.435223022106534 | 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-21T15:32:21.239106Z"} |
| 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-21T15:32:21.239106Z"} |
| 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:52:57.186278Z"} |
| 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-22T16:27:20.551854Z"} |
| 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 |
| 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-22T17:06:21.234354Z"} |
| 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-22T19:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T19:52:58.637042Z"} |
| 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-23T13:49:25.662048Z"} |
| 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-23T13:52:21.829557Z"} |
| 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-23T13:52:21.829557Z"} |
| 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-23T13:53:46.306961Z"} |
| 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-23T13:53:46.306961Z"} |
| 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-23T13:53:46.306961Z"} |
| 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-23T13:55:29.867504Z"} |
| 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-23T13:55:29.867504Z"} |
| 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-23T13:58:49.832976Z"} |
| 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-23T14:00:44.029710Z"} |
| 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-23T14:00:44.029710Z"} |
| 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-23T14:19:47.877581Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |