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 |
|---|
| 500dae04-5b18-4dff-843e-365154721cfa | 2026-09-02 10:39 | 2026-09-02 10:38 | 2026-09-02 10:38 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 14.8400 | 14.6500 | 15.3500 | 333.9520 | 148354.00 | 0.00 | 148354.00 | 100 | 15 | 308 | 2887 | 0.106685140284032 | 0.328731171256798 | 0.327748124554045 | false | false | false | true | false | 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-02T14:46:18.296261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 155a88cc-f2b7-464b-bcbf-f96a86c3f0e3 | 2026-09-21 10:13 | 2026-09-21 10:13 | 2026-09-21 10:13 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 22.0000 | 21.7500 | 22.0000 | 351.7150 | 33000.00 | 33000.00 | 0.00 | 15 | 5 | 312 | 6545 | 0.0476699770817418 | 0.352155742542875 | 0.352155742542875 | false | false | false | true | ||||||||||||||||
| a3db0c85-70c6-483e-9af2-e6498f4b961c | 2026-09-21 10:30 | 2026-09-21 10:30 | 2026-09-21 10:30 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 22.0000 | 22.0000 | 22.1500 | 351.8500 | 17600.00 | 0.00 | 2200.00 | 8 | 8 | 353 | 6545 | 0.0539343009931245 | 0.350808155405206 | 0.350808155405206 | false | false | false | true | ||||||||||||||||
| c88c6879-e958-4e88-9fe9-483f23907b89 | 2026-09-21 10:31 | 2026-09-21 10:30 | 2026-09-21 10:30 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 22.0000 | 21.9500 | 22.0500 | 351.8050 | 11000.00 | 0.00 | 8800.00 | 5 | 5 | 358 | 6545 | 0.0546982429335371 | 0.351257645010189 | 0.351257645010189 | false | false | false | true | ||||||||||||||||
| 3ce428a1-c5b3-4a69-a36d-9867daac7c4f | 2026-09-21 10:31 | 2026-09-21 10:31 | 2026-09-21 10:31 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 22.0500 | 21.9500 | 22.1000 | 351.9350 | 15435.00 | 2205.00 | 4410.00 | 7 | 7 | 365 | 6545 | 0.0557677616501146 | 0.350847594836158 | 0.350847594836158 | false | false | false | |||||||||||||||||
| 642ddf73-d29d-48e8-8bef-09fd2cd0926c | 2026-09-21 10:31 | 2026-09-21 10:31 | 2026-09-21 10:31 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 22.1900 | 22.0500 | 22.3000 | 352.1250 | 17755.00 | 4440.00 | 4435.00 | 8 | 8 | 374 | 6545 | 0.0571428571428571 | 0.351612183634091 | 0.350722848696449 | false | false | false | |||||||||||||||||
| 0396d175-7ff7-4b3a-ae05-b097e3f18616 | 2026-09-21 10:31 | 2026-09-21 10:31 | 2026-09-21 10:31 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 22.1500 | 22.0500 | 22.2000 | 352.1250 | 22150.00 | 2215.00 | 19935.00 | 10 | 10 | 386 | 6545 | 0.0589763177998472 | 0.350722848696449 | 0.350722848696449 | true | false | false | |||||||||||||||||
| 81845434-1b20-40be-b894-ca3118c243e1 | 2026-09-22 09:32 | 2026-09-22 09:32 | 2026-09-22 09:32 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 23.3000 | 22.9500 | 23.7000 | 353.7100 | 53590.00 | 0.00 | 53590.00 | 23 | 5 | 26 | 6614 | 0.00393105533716359 | 0.358467933458969 | 0.358467933458969 | false | false | false | true | ||||||||||||||||
| 3bbfcc17-9dbc-4182-833d-5127343585d5 | 2026-09-22 10:35 | 2026-09-22 10:35 | 2026-09-22 10:35 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 24.9000 | 24.9000 | 25.0500 | 356.7900 | 14940.00 | 0.00 | 14940.00 | 6 | 5 | 221 | 6614 | 0.0334139703658905 | 0.354685201163933 | 0.354685201163933 | false | false | false | true | ||||||||||||||||
| 41a3ef24-e3f6-427b-ac5f-11e2631310eb | 2026-09-22 15:32 | 2026-09-22 15:31 | 2026-09-22 15:31 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 20.9000 | 20.9000 | 21.0500 | 349.0000 | 60610.00 | 0.00 | 60610.00 | 29 | 5 | 533 | 6614 | 0.0805866344118536 | 0.361363003973385 | 0.361363003973385 | false | false | false | true | ||||||||||||||||
| ac3b0023-6ae2-488f-b40b-3e3c560bf5ce | 2026-09-23 11:06 | 2026-09-23 11:06 | 2026-09-23 11:06 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 15.4000 | 15.4000 | 15.5500 | 338.6750 | 26180.00 | 0.00 | 26180.00 | 17 | 16 | 328 | 6648 | 0.049338146811071 | 0.359375024541762 | 0.359375024541762 | true | false | false | true | ||||||||||||||||
| 5b7a2726-7bb4-4b23-aa72-cc5729f5ae75 | 2026-09-23 13:10 | 2026-09-23 13:09 | 2026-09-23 13:09 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 13.8000 | 13.6500 | 13.8000 | 334.9100 | 143520.00 | 143520.00 | 0.00 | 104 | 15 | 687 | 6648 | 0.103339350180505 | 0.36048225139457 | 0.360441649914182 | true | false | false | |||||||||||||||||
| 077e202a-935c-4bd6-83b2-473aba2e2f8b | 2026-09-23 15:59 | 2026-09-23 15:59 | 2026-09-23 15:59 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 13.9000 | 13.7500 | 14.0000 | 334.0000 | 45870.00 | 8340.00 | 37530.00 | 33 | 15 | 901 | 6648 | 0.135529482551143 | 0.362962631185995 | 0.363165785288735 | false | false | false | |||||||||||||||||
| 37b5f035-4e49-4fba-8270-f3cbe49ba990 | 2026-09-24 10:03 | 2026-09-24 10:03 | 2026-09-24 10:03 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 13.7000 | 13.4500 | 13.7000 | 335.1800 | 32880.00 | 32880.00 | 0.00 | 24 | 6 | 53 | 6808 | 0.00778495887191539 | 0.359689621548688 | 0.359689621548688 | true | false | false | true | ||||||||||||||||
| fdcd51fa-9a94-4bf4-af07-25607e2759c7 | 2026-09-24 13:14 | 2026-09-24 13:14 | 2026-09-24 13:14 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 14.9500 | 14.9000 | 15.1000 | 338.5700 | 41860.00 | 0.00 | 41860.00 | 28 | 5 | 269 | 6808 | 0.0395123384253819 | 0.355176708431229 | 0.355176708431229 | false | false | false | |||||||||||||||||
| 9e5627e7-5433-468f-8965-5672b8ebab69 | 2026-09-24 15:51 | 2026-09-24 15:51 | 2026-09-24 15:51 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 14.9000 | 14.6500 | 14.9500 | 338.4800 | 28310.00 | 25330.00 | 1490.00 | 19 | 9 | 417 | 6808 | 0.0612514688601645 | 0.355170346199931 | 0.354999995273863 | true | false | false | |||||||||||||||||
| d65a3c5c-0849-4a02-8de2-bf6112cb8e4e | 2026-09-28 09:37 | 2026-09-28 09:37 | 2026-09-28 09:37 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 14.7000 | 14.6000 | 15.0000 | 339.7250 | 11760.00 | 1470.00 | 10290.00 | 8 | 7 | 24 | 6934 | 0.00346120565330257 | 0.354035384047644 | 0.354035384047644 | true | false | false | |||||||||||||||||
| 07d8faea-02e8-4d91-8248-3ead7dead0f8 | 2026-09-28 09:58 | 2026-09-28 09:58 | 2026-09-28 09:58 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 14.4000 | 14.2000 | 14.4000 | 339.0000 | 10080.00 | 10080.00 | 0.00 | 7 | 5 | 94 | 6934 | 0.0135563888087684 | 0.350546377159446 | 0.350546377159446 | false | false | false | true | ||||||||||||||||
| def3ef36-6ff3-417f-bb69-dc8b60ec7843 | 2026-09-28 11:18 | 2026-09-28 11:18 | 2026-09-28 11:18 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 13.6100 | 13.6000 | 13.7500 | 337.0000 | 404112.00 | 0.00 | 404112.00 | 297 | 25 | 506 | 6934 | 0.0729737525237958 | 0.349463255514834 | 0.349463255514834 | false | false | false | |||||||||||||||||
| 334eff1f-32cd-4963-8b08-41401ebf9a54 | 2026-09-28 13:12 | 2026-09-28 13:12 | 2026-09-28 13:12 | GOOG | GOOG261120C00350000 | call | 350.0000 | 2026-11-20 | 13.9500 | 13.9500 | 14.1500 | 338.8100 | 55800.00 | 0.00 | 55800.00 | 40 | 13 | 639 | 6934 | 0.0921546005191809 | 0.347464849265016 | 0.347464849265016 | true | false | false |
| 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-21T14:14:40.112451Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-22T13:33:30.058722Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T14:35:47.926453Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T19:33:11.786837Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-23T15:09:03.866421Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T17:11:20.356460Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-24T14:04:09.722188Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T17:14:36.344002Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T19:53:57.742588Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-28T13:39:03.459259Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T13:59:44.308303Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T15:21:41.621308Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T17:15:39.910905Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |