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_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 | 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 |
|---|
| fef43350-fbf2-4bc8-9fde-216f44b84227 | 2026-08-18 10:34 | 2026-08-18 10:34 | 2026-08-18 10:34 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 33.0000 | 32.9500 | 33.2500 | 545.7685 | 194710.00 | 6610.00 | 188100.00 | 59 | 14 | 208 | 3840 | 0.0541666666666667 | 0.404919052811043 | 0.405327000603369 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1467733535590.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a1b8364b-c732-4d61-8cd3-09b37988db8e | 2026-08-19 15:36 | 2026-08-19 15:36 | 2026-08-19 15:36 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 33.9000 | 33.6000 | 34.0500 | 547.3700 | 288150.00 | 274590.00 | 13560.00 | 85 | 7 | 720 | 4133 | 0.174207597386886 | 0.408779883421384 | 0.408779883421384 | false | false | false | true | ||||||||||||||||
| 82959a2c-a4c4-4dd3-bd17-22810d75c42e | 2026-08-20 11:51 | 2026-08-20 11:50 | 2026-08-20 11:50 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 32.4000 | 32.4000 | 32.5500 | 543.7550 | 162000.00 | 0.00 | 32400.00 | 50 | 6 | 199 | 4349 | 0.0457576454357324 | 0.410764465058001 | 0.410764465058001 | false | false | false | true | ||||||||||||||||
| 7c678088-7364-4606-80b4-bdf542e35284 | 2026-08-20 11:51 | 2026-08-20 11:50 | 2026-08-20 11:50 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 32.4000 | 32.4000 | 32.4000 | 543.7550 | 162000.00 | 0.00 | 0.00 | 50 | 5 | 249 | 4349 | 0.0572545412738561 | 0.410764465058001 | 0.410764465058001 | false | false | false | true | ||||||||||||||||
| 69d77d34-7957-4d50-a4b0-4929842dc995 | 2026-08-20 11:51 | 2026-08-20 11:50 | 2026-08-20 11:50 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 32.4000 | 32.1000 | 32.4000 | 543.8300 | 162000.00 | 32400.00 | 0.00 | 50 | 5 | 349 | 4349 | 0.0802483329501035 | 0.410514088053963 | 0.410514088053963 | false | false | false | true | ||||||||||||||||
| 0bb93818-7f0b-4600-b2b5-69de2458b762 | 2026-08-20 11:51 | 2026-08-20 11:50 | 2026-08-20 11:50 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 32.4000 | 32.1000 | 32.4500 | 543.8300 | 162000.00 | 32400.00 | 29160.00 | 50 | 6 | 299 | 4349 | 0.0687514371119798 | 0.410514088053963 | 0.410514088053963 | false | false | false | true | ||||||||||||||||
| 390d408d-8c38-4c8a-bb1e-6b5847b47d0f | 2026-08-20 13:25 | 2026-08-20 13:24 | 2026-08-20 13:24 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 31.9000 | 31.7000 | 31.9500 | 542.3240 | 159500.00 | 31900.00 | 127600.00 | 50 | 6 | 530 | 4349 | 0.121867095884111 | 0.411375748053475 | 0.411375748053475 | false | false | false | true | ||||||||||||||||
| dd4aa99a-2002-4e0e-9c79-80e36bf85e66 | 2026-08-20 13:25 | 2026-08-20 13:24 | 2026-08-20 13:24 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 31.9000 | 31.7000 | 32.0000 | 542.3240 | 165880.00 | 12760.00 | 89320.00 | 52 | 20 | 582 | 4349 | 0.13382386755576 | 0.411375748053475 | 0.411375748053475 | true | false | false | true | ||||||||||||||||
| 3a5279c1-7648-459a-a41b-83335076d861 | 2026-08-20 13:25 | 2026-08-20 13:25 | 2026-08-20 13:25 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 32.0000 | 31.8000 | 32.0000 | 542.2750 | 307200.00 | 307200.00 | 0.00 | 96 | 5 | 697 | 4349 | 0.160266727983444 | 0.412371585565061 | 0.412371585565061 | true | false | false | true | ||||||||||||||||
| ea15735b-93fb-4d3d-bb73-e563b982823b | 2026-09-04 09:36 | 2026-09-04 09:36 | 2026-09-04 09:36 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 59.5000 | 59.5000 | 61.1000 | 610.3492 | 119004.00 | 0.00 | 95204.00 | 20 | 5 | 22 | 4666 | 0.00471495927989713 | 0.394658632753382 | 0.394737375248404 | false | false | false | true | ||||||||||||||||
| 82329796-6d40-4451-a01b-1c76a9886653 | 2026-09-09 11:05 | 2026-09-09 11:04 | 2026-09-09 11:04 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 93.0000 | 92.4500 | 93.0000 | 655.1600 | 1860000.00 | 102300.00 | 0.00 | 200 | 7 | 768 | 4597 | 0.167065477485316 | 0.437668692263048 | 0.437668692263048 | false | false | false | true | ||||||||||||||||
| 17b93880-b85b-4844-a5fa-017c93dfac33 | 2026-09-10 09:39 | 2026-09-10 09:39 | 2026-09-10 09:39 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 95.0000 | 91.8500 | 95.0000 | 659.2494 | 731500.00 | 731500.00 | 0.00 | 77 | 6 | 126 | 4505 | 0.027968923418424 | 0.432007910773716 | 0.432007910773716 | false | false | false | true | ||||||||||||||||
| 07695b30-af02-4822-b9b0-bec690fac983 | 2026-09-14 09:45 | 2026-09-14 09:45 | 2026-09-14 09:45 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 96.0000 | 93.6500 | 96.0000 | 662.0000 | 470400.00 | 470400.00 | 0.00 | 49 | 18 | 58 | 4442 | 0.0130571814497974 | 0.432908295636402 | 0.431483875603467 | true | false | false | true | ||||||||||||||||
| 5e249dbd-dfb1-44d3-a2ab-1d32bffc3da7 | 2026-09-14 13:27 | 2026-09-14 13:27 | 2026-09-14 13:27 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 97.0000 | 95.4500 | 97.0000 | 665.6400 | 378300.00 | 378300.00 | 0.00 | 39 | 14 | 378 | 4442 | 0.085096803241783 | 0.422394567069521 | 0.422394567069521 | false | false | false | true | ||||||||||||||||
| 0da425c7-90af-44e6-ac0e-34bb9554d940 | 2026-09-14 13:27 | 2026-09-14 13:27 | 2026-09-14 13:27 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 97.0000 | 95.4500 | 97.0000 | 665.4700 | 106700.00 | 106700.00 | 0.00 | 11 | 6 | 339 | 4442 | 0.0763169743358847 | 0.423523735242568 | 0.423523735242568 | false | false | false | true | ||||||||||||||||
| a196ff9d-c5eb-4048-b6e6-c1d45d9c162f | 2026-09-16 10:07 | 2026-09-16 10:07 | 2026-09-16 10:07 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 108.0000 | 106.2000 | 108.0000 | 679.8500 | 540000.00 | 108000.00 | 0.00 | 50 | 20 | 140 | 4059 | 0.0344912540034491 | 0.425370660768761 | 0.425370660768761 | false | false | false | true | ||||||||||||||||
| 9f4da366-ab49-4ff7-b4ae-948b0362e36c | 2026-09-16 10:56 | 2026-09-16 10:56 | 2026-09-16 10:56 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 107.7500 | 106.0500 | 108.0000 | 679.1200 | 172400.00 | 107970.00 | 64430.00 | 16 | 7 | 158 | 4059 | 0.0389258438038926 | 0.430733641333146 | 0.424523872538658 | true | false | false | true | ||||||||||||||||
| 470bf927-fe3f-4cdc-8d70-9fdc8015d69a | 2026-09-17 10:16 | 2026-09-17 10:16 | 2026-09-17 10:16 | META | META261218C00600000 | call | 600.0000 | 2026-12-18 | 103.1000 | 101.4000 | 104.5500 | 673.4150 | 164965.00 | 82765.00 | 82200.00 | 16 | 6 | 26 | 3952 | 0.00657894736842105 | 0.431511433788299 | 0.422066964654319 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:37:16.307537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:42:34.192825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1484735076395.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1484735076395.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1504581232976.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |