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.
Simplify Analyticsuw_flow_alerts326,449 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 |
|---|
| 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 |
|---|
| 6c56bdda-5eae-4000-832e-d5781267bbac | 2026-09-22 15:58 | 2026-09-22 15:58 | 2026-09-22 15:58 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 3.0500 | 3.0000 | 3.1000 | 351.1300 | 42700.00 | 39040.00 | 0.00 | 140 | 22 | 8851 | 6561 | 1.34903215973175 | 0.367363818464767 | 0.367363818464767 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2060606880000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| fa2a0030-1381-4d92-8770-7823893eee4c | 2026-09-22 15:54 | 2026-09-22 15:54 | 2026-09-22 15:54 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 3.2500 | 3.2500 | 3.3500 | 351.0000 | 81960.00 | 0.00 | 81960.00 | 252 | 27 | 8629 | 6561 | 1.3151958542905 | 0.367316260371006 | 0.36715448213893 | true | false | false | true | ||||||||||||||||
| 5d4e35d3-be5f-464c-82aa-c01f11b991e0 | 2026-09-22 15:41 | 2026-09-22 15:41 | 2026-09-22 15:41 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 3.6500 | 3.6500 | 3.7500 | 352.7450 | 14600.00 | 0.00 | 14600.00 | 40 | 5 | 8261 | 6561 | 1.25910684346898 | 0.362724697549854 | 0.362724697549854 | false | false | false | true | ||||||||||||||||
| aed1ef24-340b-45a4-914c-925cc1fafd81 | 2026-09-22 15:36 | 2026-09-22 15:36 | 2026-09-22 15:36 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 4.0500 | 4.0000 | 4.1000 | 353.6500 | 17010.00 | 16200.00 | 810.00 | 42 | 13 | 8185 | 6561 | 1.24752324340802 | 0.362233499424298 | 0.362233499424298 | true | false | false | true | ||||||||||||||||
| ea05f68f-7185-4a20-80df-c76fc8a81ad8 | 2026-09-22 14:59 | 2026-09-22 14:59 | 2026-09-22 14:59 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 3.6000 | 3.5500 | 3.7000 | 352.5000 | 102600.00 | 0.00 | 86400.00 | 285 | 16 | 7390 | 6561 | 1.1263526901387 | 0.366790178899561 | 0.367130423878936 | false | false | false | true | ||||||||||||||||
| 44609abc-1742-4fb4-b973-2d787cdcabef | 2026-09-22 14:05 | 2026-09-22 14:05 | 2026-09-22 14:05 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 4.0500 | 3.9500 | 4.0500 | 353.3900 | 11340.00 | 11340.00 | 0.00 | 28 | 7 | 5604 | 6561 | 0.85413808870599 | 0.373080900740768 | 0.371644227607356 | true | false | false | true | ||||||||||||||||
| 700dedb8-3550-4f39-9a16-d3c2864f75f7 | 2026-09-22 13:56 | 2026-09-22 13:56 | 2026-09-22 13:56 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 4.2500 | 4.1000 | 4.3000 | 353.7001 | 22525.00 | 22100.00 | 425.00 | 53 | 17 | 5352 | 6561 | 0.81572930955647 | 0.376464184797691 | 0.376093793681824 | false | false | false | true | ||||||||||||||||
| 3b0bf578-c99e-4c36-916e-1d7f6e28a595 | 2026-09-22 12:07 | 2026-09-22 12:07 | 2026-09-22 12:07 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 4.3000 | 4.2500 | 4.4000 | 354.0050 | 13760.00 | 12470.00 | 1290.00 | 32 | 6 | 3652 | 6561 | 0.556622466087487 | 0.367421711278689 | 0.368729261953166 | false | false | false | true | ||||||||||||||||
| 8e410822-8b85-44d5-a7b5-989d36376ec4 | 2026-09-22 11:56 | 2026-09-22 11:56 | 2026-09-22 11:56 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 4.9500 | 4.9000 | 5.1000 | 355.3500 | 12375.00 | 0.00 | 12375.00 | 25 | 6 | 3556 | 6561 | 0.541990550221003 | 0.366164198180942 | 0.367007408587788 | false | false | false | true | ||||||||||||||||
| 447a019e-ced1-4cb8-80ed-9b172a3e04ee | 2026-09-22 09:36 | 2026-09-22 09:36 | 2026-09-22 09:36 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 8.0000 | 7.6500 | 8.5000 | 360.2700 | 84800.00 | 84000.00 | 800.00 | 106 | 6 | 862 | 6561 | 0.131382411217802 | 0.378127390698728 | 0.374099043870461 | false | false | false | true | ||||||||||||||||
| 95e126d8-c579-4df2-8eff-6e8fcf042b8e | 2026-09-21 15:33 | 2026-09-21 15:33 | 2026-09-21 15:33 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 6.0000 | 5.9000 | 6.0000 | 356.0000 | 64200.00 | 64200.00 | 0.00 | 107 | 8 | 7992 | 6011 | 1.32956246880719 | 0.344268470900923 | 0.344268470900923 | true | false | false | true | ||||||||||||||||
| ae03b9a8-0d5a-41ef-bb04-f037f9b56b72 | 2026-09-21 13:00 | 2026-09-21 12:59 | 2026-09-21 12:59 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 5.3500 | 5.3000 | 5.4500 | 355.4700 | 12840.00 | 0.00 | 12840.00 | 24 | 6 | 7069 | 6011 | 1.1760106471469 | 0.339247299513245 | 0.339247299513245 | false | false | false | true | ||||||||||||||||
| 6f8cd205-52b2-40b0-b92f-ae276f965916 | 2026-09-21 11:08 | 2026-09-21 11:08 | 2026-09-21 11:08 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 5.0000 | 4.9500 | 5.2000 | 354.7150 | 16500.00 | 0.00 | 16500.00 | 33 | 9 | 6310 | 6011 | 1.04974213941108 | 0.341862600352183 | 0.341862600352183 | true | false | false | true | ||||||||||||||||
| b33d68be-998b-4cdc-bc67-a27c16a8891a | 2026-09-21 10:36 | 2026-09-21 10:36 | 2026-09-21 10:36 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 6.5000 | 6.4000 | 6.5000 | 357.3300 | 66950.00 | 66950.00 | 0.00 | 103 | 5 | 5714 | 6011 | 0.950590583929463 | 0.347194399936117 | 0.347194399936117 | true | false | false | true | ||||||||||||||||
| dfe005dd-6300-4685-9b6f-01ff24a0a973 | 2026-09-21 10:23 | 2026-09-21 10:23 | 2026-09-21 10:23 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 6.5000 | 6.4000 | 6.6000 | 357.0000 | 67600.00 | 14950.00 | 0.00 | 104 | 7 | 5334 | 6011 | 0.887373149226418 | 0.343186369390982 | 0.343186369390982 | false | false | false | true | ||||||||||||||||
| d28784a3-8156-4318-9923-050cb53a3729 | 2026-09-21 10:22 | 2026-09-21 10:22 | 2026-09-21 10:22 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 6.3000 | 6.3000 | 6.4000 | 357.0000 | 18900.00 | 0.00 | 18900.00 | 30 | 5 | 5200 | 6011 | 0.865080685410082 | 0.344215403539104 | 0.344215403539104 | false | false | false | true | ||||||||||||||||
| e8ce2ca7-e77f-4adb-a665-b26b29f78e47 | 2026-09-21 10:19 | 2026-09-21 10:19 | 2026-09-21 10:19 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 6.0000 | 5.8500 | 6.0000 | 356.5300 | 15000.00 | 15000.00 | 0.00 | 25 | 11 | 4870 | 6011 | 0.810181334220596 | 0.344268470900923 | 0.344268470900923 | true | false | false | true | ||||||||||||||||
| 2bc6444a-04e4-44ee-8751-4c9e84144680 | 2026-09-21 10:12 | 2026-09-21 10:12 | 2026-09-21 10:12 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 5.5000 | 5.3000 | 5.5000 | 355.6000 | 56650.00 | 56650.00 | 0.00 | 103 | 8 | 4231 | 6011 | 0.703876226917318 | 0.344734511156492 | 0.344734511156492 | true | false | false | true | ||||||||||||||||
| 119e29a9-af10-4d1c-a05f-175b98d62d95 | 2026-09-21 10:10 | 2026-09-21 10:10 | 2026-09-21 10:10 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 5.0000 | 4.9500 | 5.0500 | 354.6150 | 23500.00 | 5500.00 | 12500.00 | 47 | 5 | 4024 | 6011 | 0.669439361171186 | 0.345248617329106 | 0.345248617329106 | false | false | false | true | ||||||||||||||||
| 9cbd67f9-24a7-441b-92ac-b7d559d1e060 | 2026-09-21 10:08 | 2026-09-21 10:08 | 2026-09-21 10:08 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 5.1500 | 5.1500 | 5.2500 | 354.9250 | 10815.00 | 0.00 | 10815.00 | 21 | 6 | 3894 | 6011 | 0.647812344035934 | 0.345325273707777 | 0.344809585379019 | true | false | false | true | ||||||||||||||||
| 62a2e224-edd7-4e86-a7c1-ec0d71724bda | 2026-09-16 15:01 | 2026-09-16 15:01 | 2026-09-16 15:01 | GOOGL | GOOGL260925C00355000 | call | 355.0000 | 2026-09-25 | 2.4000 | 2.3600 | 2.5600 | 342.9350 | 383040.00 | 7920.00 | 375120.00 | 1596 | 48 | 2436 | 3022 | 0.806088682991396 | 0.304829082199177 | 0.30622187550962 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:10:48.215993Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:57:38.128984Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:12:44.237245Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:00:55.569269Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:37:27.552956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:02:00.389820Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:37:14.719915Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:24:21.810098Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:24:21.810098Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:20:57.602674Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011961160000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |