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_alerts523,327 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 |
|---|
| 7bfad854-9453-4f9d-a0dd-b30cb096d37b | 2026-09-25 13:47 | 2026-09-25 13:47 | 2026-09-25 13:47 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 1.4600 | 1.4600 | 1.5200 | 340.8300 | 12702.00 | 0.00 | 12702.00 | 87 | 13 | 494 | 12964 | 0.0381055229867325 | 0.318079795492109 | 0.318079795492109 | 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-25T17:50:01.932714Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| db0d9594-5fdd-40b7-8b45-8e2efcd9d91a | 2026-09-25 11:43 | 2026-09-25 11:43 | 2026-09-25 11:43 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 1.4500 | 1.4500 | 1.5500 | 340.7450 | 14647.00 | 146.00 | 14501.00 | 101 | 12 | 308 | 12964 | 0.0237580993520518 | 0.318081170171234 | 0.318700739985773 | false | false | false | true | ||||||||||||||||
| 93299478-8342-4dd6-8d59-a6452ae20900 | 2026-09-23 15:53 | 2026-09-23 15:53 | 2026-09-23 15:53 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 1.3900 | 1.3800 | 1.4700 | 334.6500 | 277942.00 | 0.00 | 277942.00 | 2001 | 46 | 8177 | 13644 | 0.599311052477279 | 0.341854696971482 | 0.341267120905579 | true | false | false | true | ||||||||||||||||
| fa7e8c7e-4b11-44f6-a153-18e0a082633c | 2026-09-23 15:47 | 2026-09-23 15:47 | 2026-09-23 15:47 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 1.3600 | 1.3500 | 1.4100 | 334.0000 | 127966.00 | 0.00 | 127966.00 | 943 | 29 | 6144 | 13644 | 0.450307827616535 | 0.338476071504812 | 0.337815135342147 | false | false | false | true | ||||||||||||||||
| 4944c36a-a2c9-4642-94e9-0210c00c0983 | 2026-09-23 15:42 | 2026-09-23 15:42 | 2026-09-23 15:42 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 1.3600 | 1.3450 | 1.3800 | 334.0000 | 193664.00 | 98328.00 | 95336.00 | 1424 | 31 | 5201 | 13644 | 0.38119319847552 | 0.340564226125197 | 0.340564226125197 | false | false | false | true | ||||||||||||||||
| 862add3e-dda2-4238-8faa-0b7782480654 | 2026-09-23 15:42 | 2026-09-23 15:42 | 2026-09-23 15:42 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 1.3900 | 1.3700 | 1.4400 | 334.0000 | 32804.00 | 0.00 | 32804.00 | 236 | 11 | 3642 | 13644 | 0.266930518909411 | 0.341992128318115 | 0.341992128318115 | false | false | false | true | ||||||||||||||||
| c5a3f708-ef0f-41a9-a576-8d22be517059 | 2026-09-23 15:42 | 2026-09-23 15:42 | 2026-09-23 15:42 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 1.4000 | 1.3900 | 1.4100 | 334.7750 | 26180.00 | 12460.00 | 10640.00 | 187 | 10 | 3406 | 13644 | 0.249633538551744 | 0.341717553960267 | 0.341717553960267 | false | false | false | true | ||||||||||||||||
| e00fb033-b305-4baa-a9eb-204eaf24a85e | 2026-09-23 15:42 | 2026-09-23 15:42 | 2026-09-23 15:42 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 1.4000 | 1.4000 | 1.4600 | 334.8300 | 210232.00 | 0.00 | 210232.00 | 1501 | 82 | 3219 | 13644 | 0.235927880386983 | 0.341851908997677 | 0.341339109037246 | true | false | false | true | ||||||||||||||||
| 32b58a7f-ae29-4289-8e67-003548197328 | 2026-09-23 10:03 | 2026-09-23 10:03 | 2026-09-23 10:03 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 1.7000 | 1.7000 | 1.7700 | 338.5800 | 42501.00 | 0.00 | 42501.00 | 250 | 19 | 981 | 13644 | 0.0718997361477573 | 0.333309444519775 | 0.333879648274275 | true | false | false | true | ||||||||||||||||
| a78856a6-ad6d-4246-9e3d-31bab383a515 | 2026-09-22 13:09 | 2026-09-22 13:09 | 2026-09-22 13:09 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 2.8500 | 2.8300 | 2.8900 | 346.4899 | 16815.00 | 0.00 | 16815.00 | 59 | 6 | 2615 | 9116 | 0.286858271171566 | 0.322270865681291 | 0.322270865681291 | false | false | false | true | ||||||||||||||||
| 0b9f5f47-7fb9-45cb-8537-247a2e3dfcbc | 2026-09-22 12:31 | 2026-09-22 12:31 | 2026-09-22 12:31 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 2.8700 | 2.8000 | 2.8700 | 347.0600 | 14637.00 | 14637.00 | 0.00 | 51 | 6 | 2496 | 9116 | 0.273804300131637 | 0.318615936850589 | 0.318615936850589 | false | false | false | true | ||||||||||||||||
| 48fc8040-81b7-4476-8609-9ec6dd9e7d07 | 2026-09-22 11:55 | 2026-09-22 11:55 | 2026-09-22 11:55 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 3.6000 | 3.5500 | 3.6000 | 351.0400 | 18000.00 | 18000.00 | 0.00 | 50 | 8 | 2359 | 9116 | 0.258775778850373 | 0.314656014676703 | 0.314656014676703 | false | false | false | true | ||||||||||||||||
| 66190577-e099-4dcd-aca5-c47dcf897aec | 2026-09-21 12:12 | 2026-09-21 12:12 | 2026-09-21 12:12 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 3.9000 | 3.8500 | 3.9500 | 352.7000 | 43680.00 | 35880.00 | 0.00 | 112 | 7 | 767 | 8946 | 0.0857366420746702 | 0.304756382377026 | 0.304756382377026 | false | false | false | true | ||||||||||||||||
| 950e495a-b5f5-4771-a25f-9fce940f28eb | 2026-09-21 10:08 | 2026-09-21 10:08 | 2026-09-21 10:08 | GOOG | GOOG261016C00375000 | call | 375.0000 | 2026-10-16 | 3.4000 | 3.4000 | 3.5500 | 350.4500 | 19380.00 | 0.00 | 19380.00 | 57 | 5 | 180 | 8946 | 0.0201207243460765 | 0.305509237718011 | 0.305509237718011 | true | false | false | true |
| 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-25T15:46:29.692189Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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:54:40.302966Z"} |
| 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 |
| 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 |
| 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 |
| 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 |
| 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:42:45.926021Z"} |
| 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:42:45.926021Z"} |
| 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:04:12.048624Z"} |
| 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-22T17:14:46.677665Z"} |
| 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-22T15:56:22.412787Z"} |
| 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-21T16:13:06.153982Z"} |
| 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-21T14:10:29.738922Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |