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_alerts728,802 rows| iduuid | created_at ↓timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strike |
|---|
| 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 |
|---|
| 15a2c8e8-42bd-463d-98c3-626f80e4b33c | 2026-09-29 15:55 | 2026-09-29 15:55 | 2026-09-29 15:55 | TTD | TTD261002P00013000 | put | 13.0000 | 2026-10-02 | 1.0900 | 0.7800 | 1.1300 | 11.9800 | 185444.00 | 131236.00 | 21699.00 | 1705 | 61 | 2436 | 1588 | 1.53400503778338 | 0.85935426558411 | 0.820082808756398 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5142597358.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T19:57:26.018295Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 54d4881e-db29-4fed-b736-fe916847bc1a | 2026-09-28 13:14 | 2026-09-28 13:14 | 2026-09-28 13:14 | TTD | TTD280121P00007500 | put | 7.5000 | 2028-01-21 | 1.0600 | 1.0600 | 1.0700 | 12.3150 | 26758.00 | 4922.00 | 21836.00 | 252 | 16 | 492 | 326 | 1.50920245398773 | 0.7140192181885 | 0.710793964500213 | false | false | ||||||||||||||||||
| 19edfc66-4c1b-42e9-b488-5888b06071b8 | 2026-09-15 14:20 | 2026-09-15 14:20 | 2026-09-15 14:20 | TTD | TTD261016C00015000 | call | 15.0000 | 2026-10-16 | 1.1600 | 1.1600 | 1.2000 | 15.2400 | 11602.00 | 0.00 | 11602.00 | 100 | 7 | 1244 | 9995 | 0.124462231115558 | 0.580534540303565 | 0.580534540303565 | false | false | ||||||||||||||||||
| 840d4fca-4ab0-48f4-a810-185eacdcc6d0 | 2026-09-14 10:08 | 2026-09-14 10:08 | 2026-09-14 10:08 | TTD | TTD260918C00015000 | call | 15.0000 | 2026-09-18 | 0.1600 | 0.1600 | 0.1800 | 14.4300 | 16002.00 | 0.00 | 15968.00 | 1000 | 9 | 3188 | 16586 | 0.192210297841553 | 0.632460959537728 | 0.632460959537728 | false | false | ||||||||||||||||||
| 8b1e4435-6919-4b91-b44c-20bc3f54bc23 | 2026-09-11 14:51 | 2026-09-11 14:51 | 2026-09-11 14:51 | TTD | TTD261218C00012500 | call | 12.5000 | 2026-12-18 | 3.1000 | 3.0000 | 3.1000 | 14.3399 | 61950.00 | 61950.00 | 0.00 | 200 | 25 | 311 | 874 | 0.3558352402746 | 0.716334954510721 | 0.709471294209632 | false | false | ||||||||||||||||||
| 52267ff0-2bf8-418d-b04c-3fa88b9d782d | 2026-09-04 13:22 | 2026-09-04 13:22 | 2026-09-04 13:22 | TTD | TTD261218C00015000 | call | 15.0000 | 2026-12-18 | 1.9800 | 1.9700 | 2.0000 | 14.4500 | 39353.00 | 0.00 | 39353.00 | 199 | 18 | 519 | 3699 | 0.140308191403082 | 0.694029146380437 | 0.69166289784062 | false | false | ||||||||||||||||||
| 23161c8e-8b97-47f4-9c67-d952a382167e | 2026-09-03 13:49 | 2026-09-03 13:49 | 2026-09-03 13:49 | TTD | TTD270319C00015000 | call | 15.0000 | 2027-03-19 | 3.1900 | 3.1500 | 3.2500 | 14.9850 | 505345.00 | 448310.00 | 55755.00 | 1582 | 41 | 1653 | 3112 | 0.531169665809769 | 0.71201878740192 | 0.71201878740192 | false | false | ||||||||||||||||||
| d50fde33-e084-40a0-a51c-c7eedfa98b07 | 2026-09-03 10:08 | 2026-09-03 10:08 | 2026-09-03 10:08 | TTD | TTD270115C00017500 | call | 17.5000 | 2027-01-15 | 1.6500 | 1.6000 | 1.7400 | 14.9700 | 16653.00 | 12540.00 | 4113.00 | 101 | 27 | 369 | 8145 | 0.0453038674033149 | 0.684088744771799 | 0.684088744771799 | false | false | ||||||||||||||||||
| 7c09903d-ec06-47b0-94d6-76b9d13735ac | 2026-09-02 10:14 | 2026-09-02 10:14 | 2026-09-02 10:14 | TTD | TTD260911C00012000 | call | 12.0000 | 2026-09-11 | 2.1100 | 2.1000 | 2.1100 | 14.1000 | 143171.00 | 122591.00 | 20580.00 | 679 | 9 | 682 | 68 | 10.0294117647059 | 0.931168981300147 | 0.931168981300147 | false | false | ||||||||||||||||||
| f4048c12-376d-4d07-b676-024e9866d22b | 2026-09-02 09:59 | 2026-09-02 09:59 | 2026-09-02 09:59 | TTD | TTD260904C00014000 | call | 14.0000 | 2026-09-04 | 0.4300 | 0.4300 | 0.4600 | 14.2550 | 10752.00 | 0.00 | 10752.00 | 250 | 11 | 2859 | 6465 | 0.442227378190255 | 0.702818120544068 | 0.702818120544068 | false | false | ||||||||||||||||||
| eca2923f-2a1e-4a9f-8e6b-348a891a45aa | 2026-09-01 12:23 | 2026-09-01 12:23 | 2026-09-01 12:23 | TTD | TTD270617C00015000 | call | 15.0000 | 2027-06-17 | 3.1000 | 3.0000 | 3.1500 | 13.7250 | 77440.00 | 71240.00 | 6200.00 | 250 | 17 | 286 | 1630 | 0.175460122699386 | 0.705972411420847 | 0.705972411420847 | true | false | ||||||||||||||||||
| 04d2180f-a2ed-4a17-b0f7-986fefbe32ed | 2026-08-31 12:17 | 2026-08-31 12:17 | 2026-08-31 12:17 | TTD | TTD270319C00020000 | call | 20.0000 | 2027-03-19 | 1.2900 | 1.2400 | 1.3000 | 13.7900 | 27150.00 | 27150.00 | 0.00 | 210 | 8 | 342 | 9190 | 0.0372143634385201 | 0.714051930510812 | 0.706067438561655 | false | false | ||||||||||||||||||
| 9054ff35-64b0-47cd-9edf-b194f3797b7b | 2026-08-28 11:04 | 2026-08-28 11:04 | 2026-08-28 11:04 | TTD | TTD270617P00010000 | put | 10.0000 | 2027-06-17 | 1.2500 | 1.2500 | 1.3400 | 13.7900 | 26200.00 | 0.00 | 26074.00 | 209 | 13 | 559 | 1340 | 0.417164179104478 | 0.6993843087413 | 0.696400265749577 | false | false | ||||||||||||||||||
| a8f37920-b89b-4f49-8d90-ec076abc2261 | 2026-08-26 15:34 | 2026-08-26 15:34 | 2026-08-26 15:34 | TTD | TTD270115C00015000 | call | 15.0000 | 2027-01-15 | 1.6200 | 1.5900 | 1.6300 | 13.0700 | 16242.00 | 11573.00 | 0.00 | 100 | 15 | 587 | 5385 | 0.109006499535747 | 0.6954240279154 | 0.688530187248435 | false | false | ||||||||||||||||||
| 923f39ae-20d8-41a2-9829-d54308f5e967 | 2026-08-20 13:06 | 2026-08-20 13:06 | 2026-08-20 13:06 | TTD | TTD261016C00015000 | call | 15.0000 | 2026-10-16 | 0.5800 | 0.5800 | 0.6100 | 13.1701 | 33061.00 | 0.00 | 33061.00 | 570 | 17 | 1899 | 7069 | 0.268637713962371 | 0.575810830663528 | 0.570534315830198 | true | false | ||||||||||||||||||
| 22392348-2050-41c6-a1bb-4836c81ef4e6 | 2026-08-18 09:58 | 2026-08-18 09:58 | 2026-08-18 09:58 | TTD | TTD260904C00013500 | call | 13.5000 | 2026-09-04 | 0.7100 | 0.6900 | 0.7900 | 13.6401 | 73095.00 | 12390.00 | 60705.00 | 1032 | 8 | 1506 | 1732 | 0.869515011547344 | 0.535399940485874 | 0.526771172003236 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5266361112.00 |
| 2026-11-05 |
| 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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:42:39.046957Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:14:09.812180Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T17:55:09.170571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:10:05.195539Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:25:30.485375Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:11:00.326314Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:27:11.873526Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6388770328.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |