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_alerts609,118 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 |
|---|
| c245823b-6102-4524-83f6-bdf7094ae1b2 | 2026-09-25 13:44 | 2026-09-25 13:44 | 2026-09-25 13:44 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 49.1500 | 48.4500 | 49.1500 | 451.1598 | 201515.00 | 196600.00 | 0.00 | 41 | 18 | 44 | 6132 | 0.00717547292889759 | 0.339428008329438 | 0.33903550122027 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Technology | 2337090974791.00 | 2026-10-15 | 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 |
| de70555f-e809-4ead-9c09-2e57c0d70d80 | 2026-09-16 14:49 | 2026-09-16 14:48 | 2026-09-16 14:48 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 30.1500 | 30.1500 | 30.2500 | 418.2700 | 536670.00 | 0.00 | 162810.00 | 178 | 51 | 1568 | 4616 | 0.339688041594454 | 0.343049320582656 | 0.343049320582656 | false | false | false | true | ||||||||||||||||
| 85ba5610-6a9d-46ee-97eb-b27e81957c70 | 2026-09-16 14:48 | 2026-09-16 14:48 | 2026-09-16 14:48 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 30.0000 | 30.0000 | 30.2000 | 417.9400 | 594000.00 | 0.00 | 240000.00 | 198 | 90 | 1293 | 4616 | 0.280112651646447 | 0.344075960718121 | 0.343420755257173 | false | false | false | true | ||||||||||||||||
| bd0fbe58-dfe1-4694-b5a1-fff52f226d09 | 2026-09-16 14:47 | 2026-09-16 14:47 | 2026-09-16 14:47 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 30.4000 | 30.1500 | 30.4500 | 418.5700 | 255360.00 | 231040.00 | 0.00 | 84 | 19 | 1095 | 4616 | 0.237218370883882 | 0.34406497914623 | 0.34406497914623 | true | false | false | true | ||||||||||||||||
| 9dd75090-0b70-4922-a465-0fa7b6f59196 | 2026-09-16 14:47 | 2026-09-16 14:47 | 2026-09-16 14:47 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 30.2000 | 30.2000 | 30.3500 | 418.3800 | 178180.00 | 0.00 | 178180.00 | 59 | 29 | 1011 | 4616 | 0.219020797227036 | 0.342923964512988 | 0.342923964512988 | false | false | false | true | ||||||||||||||||
| bedc5c16-14a7-434a-9082-63ed1e068ae8 | 2026-09-16 14:47 | 2026-09-16 14:47 | 2026-09-16 14:47 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 30.0000 | 30.0000 | 30.2000 | 418.0350 | 171000.00 | 0.00 | 171000.00 | 57 | 27 | 948 | 4616 | 0.205372616984402 | 0.3427978011231 | 0.3427978011231 | false | false | false | true | ||||||||||||||||
| 82ba0146-c74e-4be6-86a8-6d5064018f15 | 2026-09-16 14:47 | 2026-09-16 14:47 | 2026-09-16 14:47 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 30.0000 | 30.0000 | 30.1500 | 418.1300 | 288000.00 | 0.00 | 171000.00 | 96 | 40 | 891 | 4616 | 0.193024263431542 | 0.34217434782311 | 0.34217434782311 | false | false | false | true | ||||||||||||||||
| 3bab53e2-469b-48bd-9a9f-30a419d653f6 | 2026-09-16 14:46 | 2026-09-16 14:46 | 2026-09-16 14:46 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 30.1500 | 30.0000 | 30.2500 | 418.2350 | 211050.00 | 195975.00 | 6030.00 | 70 | 22 | 765 | 4616 | 0.165727902946274 | 0.343279395581445 | 0.343279395581445 | true | false | false | true | ||||||||||||||||
| e6cd59ce-1466-4a05-a588-8e08580b5f90 | 2026-09-16 14:46 | 2026-09-16 14:46 | 2026-09-16 14:46 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 30.1000 | 30.1000 | 30.1500 | 418.2350 | 120400.00 | 0.00 | 120400.00 | 40 | 18 | 695 | 4616 | 0.150563258232236 | 0.342681151777401 | 0.342681151777401 | false | false | false | true | ||||||||||||||||
| 04a44b1d-8139-404a-9a53-639514f1bfa8 | 2026-09-16 14:46 | 2026-09-16 14:46 | 2026-09-16 14:46 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 30.1000 | 30.1000 | 30.1500 | 418.2050 | 168560.00 | 0.00 | 57190.00 | 56 | 22 | 655 | 4616 | 0.141897746967071 | 0.342878290298573 | 0.342878290298573 | false | false | false | true | ||||||||||||||||
| efa130c7-504f-4375-a8e8-aaa7c6c7b6ae | 2026-09-16 14:46 | 2026-09-16 14:46 | 2026-09-16 14:46 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 30.0500 | 29.9000 | 30.1500 | 418.2050 | 102170.00 | 3005.00 | 99165.00 | 34 | 17 | 599 | 4616 | 0.129766031195841 | 0.342280038525885 | 0.342280038525885 | true | false | false | true | ||||||||||||||||
| f42ca3fb-48c2-492a-b541-99f1f8cb9613 | 2026-09-16 14:46 | 2026-09-16 14:46 | 2026-09-16 14:46 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 30.0000 | 30.0000 | 30.0500 | 418.2000 | 195000.00 | 0.00 | 84000.00 | 65 | 29 | 457 | 4616 | 0.0990034662045061 | 0.341714639878834 | 0.341714639878834 | false | false | false | true | ||||||||||||||||
| 01cccfc5-917e-494f-861c-b118b15dd0e2 | 2026-09-16 14:46 | 2026-09-16 14:46 | 2026-09-16 14:46 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 29.9500 | 29.9500 | 30.2500 | 417.9000 | 293510.00 | 0.00 | 140765.00 | 98 | 40 | 344 | 4616 | 0.0745233968804159 | 0.343084512127647 | 0.343084512127647 | false | false | false | true | ||||||||||||||||
| 2f7c22c4-4fc7-4594-aed1-60881e7f9120 | 2026-09-16 14:46 | 2026-09-16 14:45 | 2026-09-16 14:45 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 29.8000 | 29.8000 | 30.0000 | 418.1750 | 137080.00 | 0.00 | 128140.00 | 46 | 22 | 227 | 4616 | 0.0491767764298094 | 0.339485877123423 | 0.339485877123423 | true | false | false | true | ||||||||||||||||
| d151ae8b-a437-46f5-ac4b-7707cc70907f | 2026-09-16 14:45 | 2026-09-16 14:45 | 2026-09-16 14:45 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 30.2000 | 30.2000 | 30.5000 | 418.0250 | 531520.00 | 0.00 | 66440.00 | 176 | 63 | 181 | 4616 | 0.03921143847487 | 0.345256773411833 | 0.345256773411833 | false | false | false | true | ||||||||||||||||
| f122477f-3870-4c5f-b0d5-fdbcb6a42aea | 2026-09-04 12:43 | 2026-09-04 12:42 | 2026-09-04 12:42 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 38.2600 | 37.8000 | 38.3000 | 427.6200 | 107140.00 | 30640.00 | 76500.00 | 28 | 5 | 94 | 4673 | 0.0201155574577359 | 0.351621528751078 | 0.352185392370204 | false | false | false | true | ||||||||||||||||
| d8e32729-747c-46f1-aff2-e9a124f4edb4 | 2026-09-01 13:55 | 2026-09-01 13:55 | 2026-09-01 13:55 | TSM | TSM261218C00420000 | call | 420.0000 | 2026-12-18 | 30.3000 | 29.8500 | 30.9500 | 413.0200 | 1030242.00 | 27310.00 | 1002932.00 | 340 | 58 | 343 | 4483 | 0.0765112647780504 | 0.349227324890077 | 0.349227324890077 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2166506828499.00 |
| 2026-10-15 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Technology |
| 2168010914921.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Technology |
| 2168010914921.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:15:43.135015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |