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:alert_rule = RepeatedHits×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	expiry

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
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
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
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
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
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
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
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
1fa7ba70-b801-4479-8a23-e6f1c6741c86	2026-09-28 14:45	2026-09-28 14:45	2026-09-28 14:45	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	8.7500	7.7000	11.1000	501.6150	42000.00	13125.00	6125.00	48	6	58	939	0.0617678381256656	0.517632717842773	0.517632717842773	false	false	false	true
d976cfbf-260f-45ef-b7f5-7b954afab931	2026-09-28 10:56	2026-09-28 10:56	2026-09-28 10:56	SPOT	SPOT261120C00540000	call	540.0000	2026-11-20	22.5500	21.1000	22.5500	501.7000	56375.00	56375.00	0.00	25	7	25	9	2.77777777777778	0.475744429167743	0.475744429167743	false	false	false	true
e3d8dfbd-5935-4529-9e2b-b57de196d7fc	2026-09-28 10:54	2026-09-28 10:54	2026-09-28 10:54	SPOT	SPOT261016C00565000	call	565.0000	2026-10-16	2.1100	2.1100	2.7500	501.5600	20045.00	0.00	20045.00	95	23	100	22	4.54545454545455	0.402191364674495	0.402191364674495	false	false	false	true
53a32815-51d2-4f8c-9025-8b469dfcb1fa	2026-09-28 10:54	2026-09-28 10:54	2026-09-28 10:54	SPOT	SPOT261016C00570000	call	570.0000	2026-10-16	1.7700	1.7700	2.2000	501.5600	34338.00	0.00	34338.00	194	46	195	687	0.283842794759825	0.405562727835226	0.405562727835226	false	false	false	true
6fac1657-365d-40ce-80ef-6a04091c40c2	2026-09-28 10:40	2026-09-28 10:39	2026-09-28 10:39	SPOT	SPOT270319C00600000	call	600.0000	2027-03-19	31.3500	31.3500	33.5000	501.0550	81510.00	0.00	81510.00	26	7	30	76	0.394736842105263	0.444337979636401	0.444337979636401	false	false	false	true
d181aab5-6219-4334-95ea-13aa5aa5f246	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SPOT	SPOT261030C00565000	call	565.0000	2026-10-30	13.0500	13.0000	15.9000	510.0000	18270.00	0.00	3915.00	14	5	17	115	0.147826086956522	0.496184346862711	0.496184346862711	false	false	false	true
12448fee-9e09-41f3-9ac9-98ab208745c0	2026-09-25 15:03	2026-09-25 15:03	2026-09-25 15:03	SPOT	SPOT261016C00550000	call	550.0000	2026-10-16	5.6000	5.2500	5.8000	507.0000	20720.00	20720.00	0.00	37	5	48	494	0.097165991902834	0.388280843919312	0.388280843919312	false	false	false	true