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_alerts566,287 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 |
|---|
| 7606f0f3-924d-4eef-899a-99971cfa12e4 | 2026-09-29 12:17 | 2026-09-29 12:16 | 2026-09-29 12:16 | AAPL | AAPL270115C00300000 | call | 300.0000 | 2027-01-15 | 41.3300 | 40.8500 | 41.3500 | 331.1200 | 152925.00 | 148825.00 | 4100.00 | 37 | 6 | 212 | 64530 | 0.0032852936618627 | 0.272613684140156 | 0.272613684140156 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 4807322892000.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T16:22:19.511373Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 3d577646-b90c-49e6-b99c-768f5fdaa0bd | 2026-09-22 13:51 | 2026-09-22 13:51 | 2026-09-22 13:51 | AAPL | AAPL270115C00300000 | call | 300.0000 | 2027-01-15 | 50.3000 | 49.3000 | 50.6500 | 341.2650 | 251500.00 | 90540.00 | 160960.00 | 50 | 6 | 371 | 64861 | 0.00571992414548033 | 0.281021480027014 | 0.28164099765981 | false | false | false | true | ||||||||||||||||
| 4480dda0-e6fd-4b41-83e0-57318f22bdc2 | 2026-09-22 10:49 | 2026-09-22 10:49 | 2026-09-22 10:49 | AAPL | AAPL270115C00300000 | call | 300.0000 | 2027-01-15 | 50.6500 | 50.4500 | 51.0000 | 341.6400 | 541950.00 | 10130.00 | 531820.00 | 107 | 5 | 202 | 64861 | 0.00311435223015371 | 0.282222362214272 | 0.281345086089657 | false | false | false | true | ||||||||||||||||
| 61d8dbbb-fef3-49e3-9d1f-0b6de8f353ad | 2026-09-22 10:28 | 2026-09-22 10:28 | 2026-09-22 10:28 | AAPL | AAPL270115C00300000 | call | 300.0000 | 2027-01-15 | 49.7000 | 49.3000 | 50.2000 | 340.5298 | 49700.00 | 39760.00 | 9940.00 | 10 | 10 | 80 | 64861 | 0.00123340682382325 | 0.2819244797701 | 0.2819244797701 | false | false | false | true | ||||||||||||||||
| 08b010ee-da86-43f1-8fb2-41bdd0051d1b | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | AAPL | AAPL270115C00300000 | call | 300.0000 | 2027-01-15 | 50.0000 | 48.5500 | 50.5000 | 340.7100 | 120000.00 | 120000.00 | 0.00 | 24 | 5 | 24 | 64861 | 0.000370022047146976 | 0.285049661050499 | 0.285049661050499 | false | false | false | true | ||||||||||||||||
| d8b24230-ab5e-4da0-ad08-b24a210e892d | 2026-09-21 10:06 | 2026-09-21 10:06 | 2026-09-21 10:06 | AAPL | AAPL270115C00300000 | call | 300.0000 | 2027-01-15 | 46.6500 | 46.5000 | 47.0500 | 336.7400 | 41985.00 | 32655.00 | 9330.00 | 9 | 5 | 29 | 64995 | 0.00044618816832064 | 0.28187175546309 | 0.28187175546309 | false | false | false | true | ||||||||||||||||
| 752c5192-0461-4632-a763-808ae4733f7d | 2026-09-09 14:24 | 2026-09-09 14:24 | 2026-09-09 14:24 | AAPL | AAPL270115C00300000 | call | 300.0000 | 2027-01-15 | 29.9000 | 29.8000 | 30.2000 | 313.2100 | 457488.00 | 209315.00 | 167443.00 | 153 | 37 | 620 | 65757 | 0.00942865398360631 | 0.279495301534127 | 0.279349012870219 | true | false | false | true | ||||||||||||||||
| 87cb93b0-1bf7-4562-b6da-2eb12a0dada1 | 2026-09-04 10:25 | 2026-09-04 10:25 | 2026-09-04 10:25 | AAPL | AAPL270115C00300000 | call | 300.0000 | 2027-01-15 | 35.4500 | 35.4500 | 35.5250 | 321.2250 | 177250.00 | 0.00 | 177250.00 | 50 | 7 | 167 | 65851 | 0.00253602830632792 | 0.275826130297819 | 0.275826130297819 | false | false | false | true | ||||||||||||||||
| 30f6546c-91b5-49cf-8a34-ec7074665f6f | 2026-08-21 10:35 | 2026-08-21 10:35 | 2026-08-21 10:35 | AAPL | AAPL270115C00300000 | call | 300.0000 | 2027-01-15 | 27.8700 | 27.8500 | 27.9000 | 308.1350 | 1315516.00 | 516150.00 | 799366.00 | 472 | 45 | 611 | 66283 | 0.00921804987704238 | 0.272575542803866 | 0.272575542803866 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:52:53.749956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:51:29.790694Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:31:31.654153Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:30:37.895663Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:06:26.378716Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:26:05.443569Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |