Options flow alerts (market-wide)

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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = premarket×ticker = SPOT×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

7d265aaf-b0ae-46f1-a0dc-de8ed83ffc34	2026-09-29 14:12	2026-09-29 14:12	2026-09-29 14:12	SPOT	SPOT270115C00610000	call	610.0000	2027-01-15	14.4000	13.4500	14.4000	496.0550	30240.00	30240.00	0.00	21	9	26	179	0.145251396648045	0.428414877099746	0.428414877099746	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Communication Services	101611285279.00	2026-10-22	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T18:13:55.161028Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
d883a76a-aea9-435a-9bb1-bcecfcc02f1e	2026-09-29 13:48	2026-09-29 13:48	2026-09-29 13:48	SPOT	SPOT270115P00450000	put	450.0000	2027-01-15	23.2000	22.3000	23.2000	495.4000	71920.00	71920.00	0.00	31	11	39	728	0.0535714285714286	0.434288368790813	0.434288368790813	false	false	false	true
35796856-da9d-48cd-9ca2-3c93c122d824	2026-09-29 13:25	2026-09-29 13:25	2026-09-29 13:25	SPOT	SPOT261009C00480000	call	480.0000	2026-10-09	22.2400	19.8500	22.2500	494.7000	15565.00	13345.00	2220.00	7	6	7	19	0.368421052631579	0.423408808903327	0.410862232115313	true	false	false	true
09fbb560-4043-4e00-b03e-fd9db6b5f1db	2026-09-29 13:25	2026-09-29 13:25	2026-09-29 13:25	SPOT	SPOT261002C00485000	call	485.0000	2026-10-02	14.1200	11.0000	14.1500	494.2400	21185.00	18365.00	2820.00	15	7	15	4	3.75	0.488532999358662	0.488532999358662	true	false	false	true
f7758ba3-03ab-4721-9a2d-f765d3fcb709	2026-09-29 13:23	2026-09-29 13:23	2026-09-29 13:23	SPOT	SPOT261218C00500000	call	500.0000	2026-12-18	40.1300	38.1500	40.1500	494.2300	44140.00	24090.00	20050.00	11	8	24	255	0.0941176470588235	0.448296789529882	0.44119178665552	false	false	false	true
ae736450-67cc-4868-a32e-d5e3c97063c8	2026-09-29 13:23	2026-09-29 13:23	2026-09-29 13:23	SPOT	SPOT261016C00482500	call	482.5000	2026-10-16	23.7600	21.2500	23.8000	494.2300	47510.00	42840.00	4670.00	20	7	22	0	0	0.417322700533444	0.387109091319356	true	false	false	true	false
a05feff4-6e6d-4a4b-914e-370f7dbef91a	2026-09-29 13:23	2026-09-29 13:23	2026-09-29 13:23	SPOT	SPOT261218C00490000	call	490.0000	2026-12-18	45.0500	42.2500	45.0500	493.0100	63070.00	63070.00	0.00	14	6	15	29	0.517241379310345	0.451164404089518	0.451164404089518	false	false	false	true
683c67d9-b6cc-4a40-84c3-1eca04dcf3c2	2026-09-29 13:23	2026-09-29 13:23	2026-09-29 13:23	SPOT	SPOT261002C00495000	call	495.0000	2026-10-02	7.9500	6.5000	7.9500	493.0100	62773.00	61983.00	790.00	79	23	96	38	2.52631578947368	0.494484655380048	0.491675469393344	false	false	false	true
2f985592-2ee1-47a3-a9dd-46c248c5cdaa	2026-09-29 13:23	2026-09-29 13:23	2026-09-29 13:23	SPOT	SPOT261002C00487500	call	487.5000	2026-10-02	11.8800	10.2000	12.0500	494.2300	26125.00	18040.00	8085.00	22	5	22	0	0	0.503692471515137	0.428914333566388	false	false	false	true
e2e1ab43-d2e3-491a-86b7-c29d038835e7	2026-09-29 12:39	2026-09-29 12:39	2026-09-29 12:39	SPOT	SPOT261120P00360000	put	360.0000	2026-11-20	1.6200	1.4600	1.7500	493.0000	12636.00	648.00	11988.00	78	15	119	0	0	0.510938228695271	0.510938228695271	false	false	false	true	false
4caeea65-5e5d-42f9-b6e9-3afca54f8b82	2026-09-29 12:19	2026-09-29 12:19	2026-09-29 12:19	SPOT	SPOT261016C00495000	call	495.0000	2026-10-16	15.8100	15.5500	17.0500	491.7000	34780.00	6335.00	26860.00	22	12	24	31	0.774193548387097	0.397640880799429	0.399748388611013	false	false	false	true
072a1fda-48f0-414d-8393-06b4c3761729	2026-09-29 10:30	2026-09-29 10:30	2026-09-29 10:30	SPOT	SPOT280121P00540000	put	540.0000	2028-01-21	114.1500	111.0000	114.4500	492.2900	376695.00	342450.00	34245.00	33	8	43	29	1.48275862068966	0.475156071407548	0.474911834458785	false	false	false	true
acdd0476-e7de-4d59-9800-b958a2259d1d	2026-09-29 10:08	2026-09-29 10:08	2026-09-29 10:08	SPOT	SPOT280121C00800000	call	800.0000	2028-01-21	37.0000	37.0000	41.8000	490.7250	77700.00	0.00	77700.00	21	6	21	913	0.0230010952902519	0.458325188323301	0.458325188323301	false	false	false	true
cd35da0b-cf61-4615-a084-7d02a1690a6d	2026-09-29 10:03	2026-09-29 10:03	2026-09-29 10:03	SPOT	SPOT261016C00470000	call	470.0000	2026-10-16	29.7300	28.0000	29.9000	490.3900	107010.00	89240.00	17770.00	36	8	64	49	1.30612244897959	0.414680447086099	0.410060672366015	false	false	false	true
bd73b769-f7a2-4a6c-97e1-92a55cbc4535	2026-09-29 10:03	2026-09-29 10:03	2026-09-29 10:03	SPOT	SPOT261016C00475000	call	475.0000	2026-10-16	26.3500	24.5500	26.4000	490.3900	26345.00	21095.00	5250.00	10	7	10	18	0.555555555555556	0.415765399174396	0.410449869918382	true	false	false	true
9b77696e-dc23-487f-a365-efee084c00c3	2026-09-29 10:01	2026-09-29 10:01	2026-09-29 10:01	SPOT	SPOT261016C00470000	call	470.0000	2026-10-16	29.1000	27.6000	29.9500	489.8800	49465.00	20385.00	29080.00	17	11	18	49	0.36734693877551	0.40622007657864	0.40622007657864	false	false	false	true
8e7639d3-816e-4018-bc5c-fb1421dea41a	2026-09-29 09:59	2026-09-29 09:59	2026-09-29 09:59	SPOT	SPOT281215C00720000	call	720.0000	2028-12-15	86.0000	86.0000	92.0000	489.0000	111800.00	0.00	111800.00	13	8	13	2	6.5	0.461489944575255	0.461941439265344	false	false	false	true
2766cd1b-9623-46dd-8057-86640a816362	2026-09-29 09:58	2026-09-29 09:58	2026-09-29 09:58	SPOT	SPOT261218P00470000	put	470.0000	2026-12-18	29.1600	24.4000	29.7500	489.0000	20415.00	17505.00	2910.00	7	5	7	586	0.0119453924914676	0.448205460935235	0.447625470827853	false	false	false	true
f5c93a04-a680-4279-b395-f31388fb6442	2026-09-29 09:41	2026-09-29 09:41	2026-09-29 09:41	SPOT	SPOT270416P00510000	put	510.0000	2027-04-16	68.0500	63.0000	68.0500	490.8950	244980.00	244980.00	0.00	36	15	36	9	4	0.446840293054603	0.446840293054603	false	false	false	true	false
36a1fc10-3d2f-460d-a96c-4e611ef1a108	2026-09-28 15:22	2026-09-28 15:22	2026-09-28 15:22	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	11.7000	11.3000	12.2500	498.2600	70201.00	0.00	70201.00	60	18	1041	278	3.74460431654676	0.51401968001507	0.51401968001507	false	false	false	true
e51e0fb7-0091-4710-af08-cf62b381bd41	2026-09-28 15:21	2026-09-28 15:21	2026-09-28 15:21	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	11.6000	11.2500	12.1000	497.6500	45240.00	0.00	45240.00	39	8	981	278	3.52877697841727	0.515351765266232	0.515351765266232	false	false	false	true
e5b31d9b-ed47-4dc5-98a7-4014a82bab7b	2026-09-28 15:03	2026-09-28 15:03	2026-09-28 15:03	SPOT	SPOT261016C00502500	call	502.5000	2026-10-16	17.3500	17.3500	18.3500	500.4100	58990.00	0.00	58990.00	34	13	49	19	2.57894736842105	0.403225853158688	0.403225853158688	false	false	false	true
9a845bc7-5030-4385-afbe-63d42505153f	2026-09-28 15:03	2026-09-28 15:03	2026-09-28 15:03	SPOT	SPOT261016C00500000	call	500.0000	2026-10-16	18.5500	18.5500	19.8000	500.4100	79765.00	0.00	79765.00	43	17	48	804	0.0597014925373134	0.403079297933112	0.403079297933112	false	false	false	true
a757d401-71c2-40bc-92e6-6348c9ec521e	2026-09-28 14:58	2026-09-28 14:58	2026-09-28 14:58	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.5500	12.1000	12.5500	500.8050	17570.00	13805.00	0.00	14	5	862	278	3.10071942446043	0.516904070367086	0.516904070367086	false	false	false	true
481633d0-2b17-4fba-a8d3-eb83e03ed5b4	2026-09-28 14:58	2026-09-28 14:58	2026-09-28 14:58	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.6000	12.1000	13.0000	500.8050	21420.00	21420.00	0.00	17	5	834	278	3	0.517898401930785	0.517898401930785	false	false	false	true
074fe86c-eaa8-4307-8784-e713b9cbe168	2026-09-28 14:57	2026-09-28 14:57	2026-09-28 14:57	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.5000	8.5000	8.8500	500.8050	13600.00	0.00	13600.00	16	6	890	939	0.947816826411076	0.515829142378499	0.515829142378499	false	false	false	true
aba12db1-efdf-4ce3-8cc9-3b5e1904dd0a	2026-09-28 14:57	2026-09-28 14:57	2026-09-28 14:57	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.6000	8.3500	8.9000	500.8050	24080.00	0.00	24080.00	28	5	807	939	0.859424920127795	0.518160613571643	0.518160613571643	false	false	false	true
704ba027-0d1e-4d11-aad7-77f851066495	2026-09-28 14:57	2026-09-28 14:57	2026-09-28 14:57	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.7000	8.1500	8.9000	500.8050	36540.00	10440.00	5220.00	42	6	849	939	0.904153354632588	0.520484114828764	0.520484114828764	false	false	false	true
f5033778-eea9-4f9d-b9f0-b03cbf44e66a	2026-09-28 14:57	2026-09-28 14:57	2026-09-28 14:57	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.5500	8.5000	9.0000	500.8050	37620.00	0.00	37620.00	44	5	621	939	0.661341853035144	0.516995884449957	0.516995884449957	false	false	false	true
9e65f1b7-0eb3-4a09-9a93-547130d00215	2026-09-28 14:57	2026-09-28 14:57	2026-09-28 14:57	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.7000	8.5000	8.9500	500.8050	32190.00	0.00	32190.00	37	5	740	939	0.788072417465389	0.520484114828764	0.520484114828764	false	false	false	true
79ebcddc-5fbf-463b-982a-a1e27cded0b3	2026-09-28 14:57	2026-09-28 14:57	2026-09-28 14:57	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.6500	8.5000	9.0000	500.8050	70900.00	870.00	35320.00	82	11	703	939	0.748668796592119	0.520484114828764	0.518160613571643	false	false	false	true
f18f1b12-8c46-4534-b1c6-cbab92aa76bb	2026-09-28 14:57	2026-09-28 14:57	2026-09-28 14:57	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.5100	12.4000	12.9500	500.8050	27520.00	5010.00	13795.00	22	7	737	278	2.65107913669065	0.516904070367086	0.514913028789392	true	false	false	true
12fa911e-64c9-4f89-bc4a-43c2f967d4d8	2026-09-28 14:57	2026-09-28 14:57	2026-09-28 14:57	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.6000	12.5500	13.2500	501.1400	59220.00	28980.00	30240.00	47	5	662	278	2.38129496402878	0.5160030867963	0.5160030867963	false	false	false	true
3cada725-4af0-4599-833f-850f36bdf8c2	2026-09-28 14:57	2026-09-28 14:57	2026-09-28 14:57	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.6500	12.3000	13.2000	501.1200	61990.00	36690.00	25300.00	49	8	567	278	2.03956834532374	0.51710827102078	0.518099505613442	true	false	false	true
594a1cab-3b49-4cc3-8187-51de81edafbd	2026-09-28 14:48	2026-09-28 14:48	2026-09-28 14:48	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.5500	12.2500	12.5500	500.8950	47690.00	47690.00	0.00	38	5	473	278	1.70143884892086	0.51639539691565	0.51639539691565	true	false	false	true
c6d7fd16-9dd6-4179-9e43-0d1e60cbcf04	2026-09-28 14:48	2026-09-28 14:48	2026-09-28 14:48	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.5000	12.0750	12.8000	500.8950	87500.00	72500.00	5000.00	70	13	374	278	1.34532374100719	0.515400716157015	0.515400716157015	true	false	false	true
8d0cad47-8af1-4fec-8244-53a73161cbc7	2026-09-28 14:48	2026-09-28 14:48	2026-09-28 14:48	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.6500	8.2500	8.6500	500.8950	27680.00	21625.00	0.00	32	6	442	939	0.470713525026624	0.518878882590014	0.518878882590014	true	false	false	true
7dd7863e-c41e-4edf-a01e-73359450440f	2026-09-28 14:47	2026-09-28 14:47	2026-09-28 14:47	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.5500	8.3000	8.9500	501.2300	20520.00	6840.00	13680.00	24	5	410	939	0.436634717784878	0.51490201593967	0.51490201593967	false	false	false	true
e102899e-d39f-46b8-8916-162542d29478	2026-09-28 14:47	2026-09-28 14:47	2026-09-28 14:47	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.7500	8.7500	9.0500	501.3800	36750.00	0.00	19250.00	42	5	348	939	0.370607028753994	0.51879626061739	0.51879626061739	false	false	false	true
54dbc3ee-eb04-44d2-be52-f7db5c32a35c	2026-09-28 14:47	2026-09-28 14:46	2026-09-28 14:46	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.7500	8.5000	9.0500	501.4350	38500.00	0.00	26250.00	44	6	291	939	0.309904153354633	0.518523948688619	0.518523948688619	false	false	false	true
9f9a160c-f70b-4097-9f49-e5f395263ab6	2026-09-28 14:47	2026-09-28 14:46	2026-09-28 14:46	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.7000	12.4500	12.7000	501.4350	62230.00	52070.00	0.00	49	8	251	278	0.902877697841727	0.516313610811886	0.516313610811886	false	false	false	true
6d6f2337-1630-48e2-91a2-6928d1e3e8f7	2026-09-28 14:46	2026-09-28 14:46	2026-09-28 14:46	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.7500	8.6500	9.1000	501.4350	22750.00	0.00	22750.00	26	5	237	939	0.252396166134185	0.518523948688619	0.518523948688619	false	false	false	true
a2f307e3-f499-4770-9804-d96fce3ecfe6	2026-09-28 14:46	2026-09-28 14:46	2026-09-28 14:46	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.7000	12.4500	12.9500	501.4350	44450.00	12700.00	12700.00	35	5	202	278	0.726618705035971	0.516313610811886	0.516313610811886	false	false	false	true
6c3f1adf-f3a0-41a5-9d01-88ca8613955f	2026-09-28 14:46	2026-09-28 14:46	2026-09-28 14:46	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.7400	12.3000	13.1500	501.5025	38225.00	21650.00	0.00	30	10	167	278	0.600719424460432	0.51691943811103	0.514941455470087	true	false	false	true
868fe91a-0c2a-4ea4-a27d-6a62741fa634	2026-09-28 14:46	2026-09-28 14:46	2026-09-28 14:46	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.7500	8.7500	9.1000	501.5025	21875.00	0.00	16625.00	25	5	187	939	0.199148029818956	0.518189742211286	0.518189742211286	false	false	false	true
2ddc3689-d814-4d29-b424-c9b7a09bc7c0	2026-09-28 14:46	2026-09-28 14:46	2026-09-28 14:46	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.7500	12.2500	12.7500	501.4300	53550.00	53550.00	0.00	42	5	137	278	0.492805755395683	0.517330924880042	0.517330924880042	false	false	false	true
2734bf25-153d-4842-902e-05eff115bdda	2026-09-28 14:46	2026-09-28 14:46	2026-09-28 14:46	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.7500	8.5500	9.1000	501.6000	31500.00	0.00	31500.00	36	6	162	939	0.172523961661342	0.517706988747356	0.517706988747356	false	false	false	true
afbee70d-5db9-40f3-abb2-90f7d8c96614	2026-09-28 14:46	2026-09-28 14:46	2026-09-28 14:46	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.7000	12.2500	12.9500	501.4900	53340.00	53340.00	0.00	42	5	95	278	0.341726618705036	0.516001716776635	0.516001716776635	false	false	false	true
80068512-b01a-4a3b-a078-02d53a69c2e4	2026-09-28 14:45	2026-09-28 14:45	2026-09-28 14:45	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.7000	8.4000	9.1500	501.9300	18270.00	870.00	17400.00	21	5	126	939	0.134185303514377	0.514920824437686	0.514920824437686	false	false	false	true
c83ab473-daf0-4946-92d3-715c0f6ff9fe	2026-09-28 14:45	2026-09-28 14:45	2026-09-28 14:45	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	13.0500	12.3500	13.0500	501.7300	33930.00	33930.00	0.00	26	11	26	278	0.0935251798561151	0.521537341966134	0.521537341966134	false	false	false	true