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_alerts523,327 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 |
|---|
| 1ac380a0-000f-40e8-a481-38f52d4f7367 | 2026-09-21 12:26 | 2026-09-21 12:25 | 2026-09-21 12:25 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 11.7500 | 11.6000 | 11.8000 | 726.7848 | 37600.00 | 37600.00 | 0.00 | 32 | 15 | 7880 | 2413 | 3.26564442602569 | 0.571293346981409 | 0.569744872727722 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:29:13.911862Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 70a74f0c-e342-403a-b2bc-b93ce1db6f03 | 2026-09-21 12:25 | 2026-09-21 12:24 | 2026-09-21 12:24 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 11.8000 | 11.7500 | 11.9500 | 726.7650 | 15340.00 | 0.00 | 15340.00 | 13 | 8 | 7836 | 2413 | 3.24740986324078 | 0.571718192556887 | 0.571718192556887 | false | false | false | true | ||||||||||||||||
| 572f7f9f-ebf2-45e5-a21e-15b3800f8083 | 2026-09-21 12:22 | 2026-09-21 12:22 | 2026-09-21 12:22 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 12.2000 | 12.1000 | 12.2000 | 727.3500 | 147620.00 | 147620.00 | 0.00 | 121 | 5 | 7637 | 2413 | 3.16493990882719 | 0.576568988211482 | 0.577388287992974 | false | false | false | true | ||||||||||||||||
| e7df1c77-979b-4336-9920-5ac7e2712313 | 2026-09-21 12:20 | 2026-09-21 12:20 | 2026-09-21 12:20 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 12.0000 | 11.9500 | 12.0000 | 726.0000 | 18000.00 | 18000.00 | 0.00 | 15 | 12 | 7261 | 2413 | 3.00911728139246 | 0.579010826081146 | 0.579010826081146 | false | false | false | true | ||||||||||||||||
| c7c97549-cb23-4300-a222-e816b5087e5a | 2026-09-21 12:16 | 2026-09-21 12:15 | 2026-09-21 12:15 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 11.5000 | 11.4000 | 11.5000 | 726.1100 | 11500.00 | 11500.00 | 0.00 | 10 | 5 | 7175 | 2413 | 2.97347699958558 | 0.572389914510352 | 0.57025468301623 | false | false | false | true | ||||||||||||||||
| ef37f349-aa8f-48c0-903a-56427c6446af | 2026-09-21 12:10 | 2026-09-21 12:10 | 2026-09-21 12:10 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 10.0000 | 9.9000 | 10.0000 | 723.4400 | 15000.00 | 15000.00 | 0.00 | 15 | 12 | 7029 | 2413 | 2.91297140489018 | 0.552985305292746 | 0.552985305292746 | false | false | false | true | ||||||||||||||||
| b0341ab4-9dc3-42f9-ae81-e36d096875c9 | 2026-09-21 12:03 | 2026-09-21 12:03 | 2026-09-21 12:03 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 10.0000 | 9.9500 | 10.0000 | 723.1600 | 52000.00 | 52000.00 | 0.00 | 52 | 16 | 6838 | 2413 | 2.83381682552839 | 0.556548397954385 | 0.556548397954385 | false | false | false | true | ||||||||||||||||
| ddc445a2-2243-4d4f-bd11-51419dfce428 | 2026-09-21 12:01 | 2026-09-21 12:01 | 2026-09-21 12:01 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 9.7700 | 9.7000 | 9.8000 | 722.3700 | 24437.00 | 22483.00 | 1954.00 | 25 | 6 | 6662 | 2413 | 2.76087857438873 | 0.558467410979824 | 0.558385174371956 | false | false | false | true | ||||||||||||||||
| b552b4d9-4afe-4082-b95f-443712c6928f | 2026-09-21 11:57 | 2026-09-21 11:57 | 2026-09-21 11:57 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 8.9500 | 8.9500 | 9.1000 | 720.4000 | 15215.00 | 0.00 | 15215.00 | 17 | 7 | 6488 | 2413 | 2.68876916701202 | 0.553028403515182 | 0.553272145763647 | false | false | false | true | false | |||||||||||||||
| ad5e5da3-0354-46f8-9c43-69d5e3ef7d6a | 2026-09-21 11:54 | 2026-09-21 11:54 | 2026-09-21 11:54 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 9.7000 | 9.7000 | 9.8000 | 721.6951 | 12610.00 | 0.00 | 12610.00 | 13 | 13 | 6408 | 2413 | 2.65561541649399 | 0.564347728621462 | 0.564347728621462 | false | false | false | true | false | |||||||||||||||
| 26a5f0f3-ec95-45c6-8376-fac1ad489caf | 2026-09-21 11:48 | 2026-09-21 11:48 | 2026-09-21 11:48 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 8.0500 | 8.0500 | 8.2000 | 718.1000 | 15295.00 | 0.00 | 15295.00 | 19 | 7 | 6294 | 2413 | 2.6083713220058 | 0.547528638472548 | 0.547528638472548 | true | false | false | true | false | |||||||||||||||
| 1811906d-46c3-4c1a-b3f6-e867419e1499 | 2026-09-21 11:41 | 2026-09-21 11:41 | 2026-09-21 11:41 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 7.5000 | 7.3500 | 7.5000 | 716.7200 | 10495.00 | 10495.00 | 0.00 | 14 | 11 | 5994 | 2413 | 2.4840447575632 | 0.542023292326868 | 0.542682065692375 | true | false | false | true | false | |||||||||||||||
| cb663df9-87e6-43e8-8590-a88c5507b7c8 | 2026-09-21 11:39 | 2026-09-21 11:39 | 2026-09-21 11:39 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 7.3700 | 7.3500 | 7.4500 | 716.0000 | 17680.00 | 0.00 | 17680.00 | 24 | 5 | 5899 | 2413 | 2.44467467882304 | 0.541572873989314 | 0.540458430656074 | false | false | false | true | false | |||||||||||||||
| 282e2f28-293f-4560-84f3-23c193230c48 | 2026-09-21 11:36 | 2026-09-21 11:36 | 2026-09-21 11:36 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 7.0000 | 6.9500 | 7.0000 | 715.0000 | 11200.00 | 11200.00 | 0.00 | 16 | 5 | 5763 | 2413 | 2.3883133029424 | 0.540860280156167 | 0.540860280156167 | false | false | false | true | false | |||||||||||||||
| 412762f4-e47b-4838-9e84-6eef638d97bd | 2026-09-21 11:17 | 2026-09-21 11:17 | 2026-09-21 11:17 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 6.1000 | 5.9500 | 6.1000 | 711.5750 | 31100.00 | 31100.00 | 0.00 | 51 | 14 | 5521 | 2413 | 2.28802320762536 | 0.543474819171014 | 0.543891040976576 | false | false | false | true | ||||||||||||||||
| 7f21aa18-6c15-45ef-895d-9f8c5b4e7bc2 | 2026-09-21 10:19 | 2026-09-21 10:19 | 2026-09-21 10:19 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 6.0000 | 6.0000 | 6.1000 | 711.0600 | 13800.00 | 0.00 | 13800.00 | 23 | 9 | 2484 | 2413 | 1.02942395358475 | 0.545210310186434 | 0.545210310186434 | false | false | false | true | false | |||||||||||||||
| c0b3c870-063a-493f-8b2e-677aef3142e9 | 2026-09-21 10:16 | 2026-09-21 10:16 | 2026-09-21 10:16 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 7.2000 | 7.1000 | 7.2000 | 714.0000 | 21600.00 | 21600.00 | 0.00 | 30 | 5 | 2234 | 2413 | 0.925818483215914 | 0.552761435179241 | 0.552761435179241 | false | false | false | true | ||||||||||||||||
| ea1deb3b-15a8-4a08-8694-ff3aeda69038 | 2026-09-21 10:14 | 2026-09-21 10:14 | 2026-09-21 10:14 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 6.2000 | 6.2000 | 6.3500 | 712.0000 | 39080.00 | 1250.00 | 37205.00 | 63 | 5 | 2137 | 2413 | 0.885619560712806 | 0.543152714877419 | 0.545216598578835 | false | false | false | true | ||||||||||||||||
| 8c1190fd-020a-43cd-87ae-036c7b4a1e0f | 2026-09-21 10:07 | 2026-09-21 10:06 | 2026-09-21 10:06 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 6.5000 | 6.5000 | 6.6500 | 712.4800 | 26000.00 | 0.00 | 26000.00 | 40 | 7 | 1689 | 2413 | 0.699958557811852 | 0.550589055793195 | 0.550589055793195 | false | false | false | true | ||||||||||||||||
| 7ed796ed-2f0b-461e-82f3-029abfdb2c62 | 2026-09-21 10:04 | 2026-09-21 10:04 | 2026-09-21 10:04 | META | META260925C00740000 | call | 740.0000 | 2026-09-25 | 6.5200 | 6.4500 | 6.6000 | 712.6300 | 26069.00 | 8489.00 | 17580.00 | 40 | 5 | 1113 | 2413 | 0.461251554082056 | 0.547428864487518 | 0.549768426853689 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:21:14.001426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:17:17.704519Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:10:34.961716Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:04:05.802260Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:04:05.802260Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:00:04.115943Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:56:02.019393Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:49:21.879731Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:43:39.846801Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:39:42.073830Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:36:47.844885Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:19:12.034191Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.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 |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:16:37.999315Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:16:37.999315Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:08:15.762043Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:04:59.983035Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |