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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = SPXW×

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

43a90a38-f8dd-43e4-988a-ad2e7dcf9f92	2026-09-21 16:03	2026-09-21 16:03	2026-09-21 16:03	SPXW	SPXW260923P07770000	put	7770.0000	2026-09-23	26.9200	26.8000	27.1000	7745.0000	69990.00	0.00	56490.00	26	6	935	18	51.9444444444444	0.109787035990741	0.109350327657722	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
8a870d26-e654-4117-ba7b-a470bdc3249e	2026-09-21 16:02	2026-09-21 16:01	2026-09-21 16:01	SPXW	SPXW260924C07800000	call	7800.0000	2026-09-24	15.3000	15.2000	15.5000	7745.0000	74970.00	48960.00	26010.00	49	10	1836	1363	1.3470286133529	0.102074629954573	0.102074629954573	false	false	false	true	false
0f14d4e5-f80c-450a-a56e-4f29110716ad	2026-09-21 16:02	2026-09-21 16:01	2026-09-21 16:01	SPXW	SPXW260922C07795000	call	7795.0000	2026-09-22	5.7000	5.6000	5.8000	7745.0000	27930.00	0.00	22230.00	49	10	3630	532	6.82330827067669	0.100692888343379	0.100692888343379	false	false	false	true	false
75d31d98-b24d-4751-bf69-1bbf62b51d6a	2026-09-21 16:01	2026-09-21 16:01	2026-09-21 16:01	SPXW	SPXW260922P07750000	put	7750.0000	2026-09-22	11.0000	10.9000	11.1000	7745.0000	22000.00	6600.00	0.00	20	7	10341	277	37.3321299638989	0.109488101263667	0.109488101263667	false	false	false	true	false
29f59012-47f8-4b40-971d-f95e5fbe702f	2026-09-21 16:01	2026-09-21 16:01	2026-09-21 16:01	SPXW	SPXW260923P07770000	put	7770.0000	2026-09-23	26.7700	26.4000	26.8000	7745.0000	69610.00	69610.00	0.00	26	7	902	18	50.1111111111111	0.108590655034649	0.108590655034649	false	false	false	true	false
02b15d1d-ed86-4fd8-b054-ae716f69e94c	2026-09-21 16:01	2026-09-21 16:01	2026-09-21 16:01	SPXW	SPXW261001P07620000	put	7620.0000	2026-10-01	15.4000	15.2000	15.5000	7745.0000	15400.00	15400.00	0.00	10	7	300	313	0.958466453674121	0.128619041917869	0.128619041917869	false	false	false	true	false
6ebabcb8-3d54-44c3-af1b-063102f43186	2026-09-21 16:01	2026-09-21 16:01	2026-09-21 16:01	SPXW	SPXW260922C07790000	call	7790.0000	2026-09-22	7.0000	7.0000	7.1000	7745.0000	42000.00	0.00	42000.00	60	7	4142	457	9.06345733041575	0.100841231486581	0.100841231486581	false	false	false	true	false
a97bf86c-7fda-42ab-9229-828ad3d4f22f	2026-09-21 16:00	2026-09-21 16:00	2026-09-21 16:00	SPXW	SPXW261030C07765000	call	7765.0000	2026-10-30	146.0000	146.0000	146.4000	7745.0000	365000.00	0.00	365000.00	25	7	100	206	0.485436893203884	0.127114728696971	0.127114728696971	false	false	false	true	false
9c2b3c84-0ae9-43ad-bb74-b17b3f08f88e	2026-09-21 16:00	2026-09-21 16:00	2026-09-21 16:00	SPXW	SPXW260925C07800000	call	7800.0000	2026-09-25	21.4000	21.3000	21.7000	7745.0000	34240.00	0.00	34240.00	16	5	9301	3996	2.32757757757758	0.107803376753517	0.107803376753517	false	false	false	true	false
4765b484-6872-4771-8614-49d868581026	2026-09-21 16:00	2026-09-21 16:00	2026-09-21 16:00	SPXW	SPXW260925P07700000	put	7700.0000	2026-09-25	13.8000	13.7000	13.9000	7745.0000	74520.00	8280.00	0.00	54	7	2791	2310	1.20822510822511	0.119863464874779	0.119863464874779	false	false	false	true	false
021023fc-3f42-48ad-8a16-4c3d4f12c316	2026-09-21 16:00	2026-09-21 16:00	2026-09-21 16:00	SPXW	SPXW260922P07765000	put	7765.0000	2026-09-22	16.7600	16.3000	16.9000	7745.0000	231280.00	122080.00	109200.00	138	22	3263	12	271.916666666667	0.104359746703149	0.105593434626967	false	false	false	true	false
4adee128-6d81-4dd1-8a72-9165e1fd3e39	2026-09-21 16:00	2026-09-21 16:00	2026-09-21 16:00	SPXW	SPXW260925C07800000	call	7800.0000	2026-09-25	21.8000	21.6000	21.8000	7745.0000	67580.00	67580.00	0.00	31	6	9280	3996	2.32232232232232	0.109116801827199	0.109116801827199	true	false	false	true	false
447a3b47-fc09-4daf-abfd-a20ebdb91a9a	2026-09-21 16:00	2026-09-21 16:00	2026-09-21 16:00	SPXW	SPXW260925C07800000	call	7800.0000	2026-09-25	21.7000	21.5000	21.8000	7745.0000	75950.00	75950.00	0.00	35	6	9171	3996	2.29504504504505	0.108788638177905	0.108788638177905	true	false	false	true	false
3d757e03-4d36-4f2a-b358-cae7ee4c9e76	2026-09-21 16:00	2026-09-21 16:00	2026-09-21 16:00	SPXW	SPXW260925C07800000	call	7800.0000	2026-09-25	21.8000	21.6000	21.9000	7745.0000	61040.00	61040.00	0.00	28	6	9248	3996	2.31431431431431	0.109116801827199	0.109116801827199	true	false	false	true	false
045c95ff-d2fb-42d2-b276-869792e2431b	2026-09-21 16:00	2026-09-21 16:00	2026-09-21 16:00	SPXW	SPXW260925C07800000	call	7800.0000	2026-09-25	21.7000	21.5000	21.7000	7745.0000	54250.00	54250.00	0.00	25	5	9220	3996	2.30730730730731	0.108788638177905	0.108788638177905	true	false	false	true	false
f1d717d8-6556-4d4b-af0c-07ef927bcd6a	2026-09-21 16:00	2026-09-21 16:00	2026-09-21 16:00	SPXW	SPXW260922P07770000	put	7770.0000	2026-09-22	19.1000	18.8000	19.1000	7745.0000	42010.00	42010.00	0.00	22	7	3738	27	138.444444444444	0.103167675688354	0.103787563409593	true	false	false	true	false
8fbdb903-5796-477c-b2a9-4332c270a330	2026-09-21 16:00	2026-09-21 16:00	2026-09-21 16:00	SPXW	SPXW260922P07770000	put	7770.0000	2026-09-22	18.7200	18.6000	19.1000	7745.0000	187230.00	108460.00	78770.00	100	13	3711	27	137.444444444444	0.102547747834678	0.101307768758695	false	false	false	true	false
41a5b6e7-bc05-4051-a914-551a1518b92e	2026-09-21 16:00	2026-09-21 16:00	2026-09-21 16:00	SPXW	SPXW260928C07800000	call	7800.0000	2026-09-28	27.2000	27.0000	27.3000	7745.0000	337280.00	337280.00	0.00	124	5	2902	1950	1.48820512820513	0.0934086922536328	0.0934086922536328	false	false	false	true	false
c4b256fc-491e-4b2b-892f-ea6063264322	2026-09-21 16:00	2026-09-21 16:00	2026-09-21 16:00	SPXW	SPXW260922C07840000	call	7840.0000	2026-09-22	0.9000	0.9000	1.0000	7745.0000	11790.00	0.00	11790.00	131	6	5208	571	9.12084063047285	0.109260566760286	0.109260566760286	false	false	false	true	false
f3007cf6-1ba4-4f80-84ef-ba1779bde9af	2026-09-21 16:00	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07765000	put	7765.0000	2026-09-21	0.4700	0.2000	0.6500	7745.0000	11995.00	10760.00	1175.00	254	62	90697	38	2386.76315789474	0.0755350130912148	0.650101104705228	false	false	false	true	false
92931ce1-7311-41ac-8630-039ce4234a81	2026-09-21 16:00	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260923P07770000	put	7770.0000	2026-09-23	25.6200	25.5000	26.0000	7745.0000	64060.00	0.00	64060.00	25	6	839	18	46.6111111111111	0.104018114461088	0.103581308120231	false	false	false	true	false
d866c87a-a700-4b78-9f10-0b3afdc7c407	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07770000	put	7770.0000	2026-09-21	5.0900	5.0000	5.2000	7745.0000	18840.00	510.00	18330.00	37	5	89574	41	2184.73170731707	0	0	false	false	false	true	false
020534e9-5191-4425-b29b-d9b16091578f	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260922C07840000	call	7840.0000	2026-09-22	0.9500	0.9500	1.0500	7745.0000	22800.00	0.00	22800.00	240	10	4501	571	7.88266199649737	0.109884480503131	0.109884480503131	false	false	false	true	false
732d45a2-7f2b-433d-bf4d-60ef7bb99a22	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07770000	put	7770.0000	2026-09-21	4.3000	4.0000	4.5000	7745.0000	10750.00	10750.00	0.00	25	6	89102	41	2173.21951219512	0	0	false	false	false	true	false
2ef6f60c-68a3-46c8-be15-02738c03a4ac	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921C07770000	call	7770.0000	2026-09-21	0.3000	0.2000	0.3500	7745.0000	23170.00	22650.00	520.00	785	80	200859	1320	152.165909090909	0.357623010953693	0.382534276977157	false	false	false	true	false
155a57cf-fec5-42b9-a8e0-b7a0b8eca1a5	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260930C08000000	call	8000.0000	2026-09-30	2.1500	2.1000	2.2000	7745.0000	10750.00	0.00	8600.00	50	5	1435	42378	0.0338619094813347	0.104796966017786	0.104796966017786	false	false	false	true	false
a683fca3-8e91-4ff2-b1a2-b66fc34031b7	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07770000	put	7770.0000	2026-09-21	4.3300	3.7000	5.0000	7745.0000	10380.00	7560.00	2820.00	24	16	88312	41	2153.9512195122	0.0885763857657738	0	false	false	false	true	false
2fe9208d-7872-4489-ac4b-01a0efe673fe	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07765000	put	7765.0000	2026-09-21	0.8100	0.6000	0.9500	7745.0000	17660.00	10480.00	5090.00	218	71	86566	38	2278.05263157895	0.306969482428272	0.232142851827457	true	false	false	true	false
123d945f-e98b-4f10-9609-2509206b2afc	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07770000	put	7770.0000	2026-09-21	5.1300	4.2000	5.6000	7745.0000	26660.00	14490.00	12170.00	52	15	88204	41	2151.31707317073	0.743635006217671	0.636732516782517	false	false	false	true	false
ec631196-a5dd-44b8-96ea-ed94f94fb877	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07770000	put	7770.0000	2026-09-21	4.9100	4.0000	5.1000	7745.0000	28450.00	28000.00	450.00	58	39	87996	41	2146.24390243902	0.447348897146519	0.426090491072944	false	false	false	true	false
b169cf2a-35ab-4ca8-905f-663a18ad1c85	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07770000	put	7770.0000	2026-09-21	5.0900	4.1000	5.6000	7745.0000	46850.00	29300.00	11960.00	92	40	88152	41	2150.0487804878	0.595943607871202	0.743635006217671	false	false	false	true	false
87a26f7d-acad-4d16-aa87-2bc13e625203	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07765000	put	7765.0000	2026-09-21	0.7900	0.7000	0.8500	7745.0000	12505.00	9520.00	2515.00	159	68	86284	38	2270.63157894737	0.310824439826443	0.281672341261629	false	false	false	true	false
ef3caafa-05dc-4702-9912-1d84c6bac50d	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07770000	put	7770.0000	2026-09-21	4.0000	3.7000	4.1000	7745.0000	39570.00	39200.00	370.00	99	29	87852	41	2142.73170731707	0.376600409732557	0.238081429434865	false	false	false	true	false
bbe203aa-6545-4266-8fe0-4a90e432dc41	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07770000	put	7770.0000	2026-09-21	3.7000	3.2000	3.7000	7745.0000	14800.00	14800.00	0.00	40	6	87656	41	2137.9512195122	0.571755310748719	0.571755310748719	false	false	false	true	false
a012d84e-ca99-4868-a518-a64dfeb6964c	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07770000	put	7770.0000	2026-09-21	3.5000	3.0000	3.7000	7745.0000	10850.00	10530.00	320.00	31	17	87616	41	2136.9756097561	0.520349232882733	0.441463822310184	false	false	false	true	false
1ed7918d-0148-4974-a53b-c5ecdc818c18	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07770000	put	7770.0000	2026-09-21	3.7000	3.4000	3.8000	7745.0000	28140.00	28140.00	0.00	76	5	87733	41	2139.82926829268	0.571755310748719	0.597204147416993	false	false	false	true	false
f1d616ee-a908-4e7b-88a7-f6b525ad3f1f	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07775000	put	7775.0000	2026-09-21	8.1600	6.8000	8.5000	7767.7600	23650.00	23650.00	0.00	29	13	43949	143	307.335664335664	0.739861783518664	0.906350123292665	false	false	false	true	false
ba77cc93-cc44-4195-b542-174ef2b563d9	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260921P07770000	put	7770.0000	2026-09-21	3.0900	2.4500	3.2000	7767.7600	15150.00	15150.00	0.00	49	24	87496	41	2134.0487804878	0.387622069383642	0.441336773166399	false	false	false	true	false
757cbbfc-a1f4-4849-9326-1cc06a2e0669	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SPXW	SPXW260928C07900000	call	7900.0000	2026-09-28	5.4000	5.2000	5.5000	7767.7600	18360.00	15660.00	2700.00	34	5	5810	584	9.9486301369863	0.0945749053561788	0.0945749053561788	false	false	false	true	false
4e9289b0-8b7d-41f5-96fd-33228fa3e23e	2026-09-21 15:59	2026-09-21 15:58	2026-09-21 15:58	SPXW	SPXW260921P07785000	put	7785.0000	2026-09-21	16.5000	16.5000	17.3000	7768.0300	16500.00	0.00	16500.00	10	5	4519	14	322.785714285714	1.03685823440338	0.859944767940745	false	false	false	true	false
0ba1312c-220b-447b-8c4c-938ad8b0bb8f	2026-09-21 15:59	2026-09-21 15:58	2026-09-21 15:58	SPXW	SPXW260921C07765000	call	7765.0000	2026-09-21	3.9000	3.6000	4.0000	7768.0800	10140.00	1170.00	8970.00	26	5	146404	944	155.088983050847	0.468624209008895	0.458566328349428	false	false	false	true	false
d95e482c-f9c7-48f8-9ef6-6d503004316b	2026-09-21 15:59	2026-09-21 15:58	2026-09-21 15:58	SPXW	SPXW260928P07600000	put	7600.0000	2026-09-28	6.4000	6.3000	6.4000	7767.5300	82560.00	82560.00	0.00	129	7	731	1692	0.432033096926714	0.12713397183192	0.12713397183192	false	false	false	true	false
7c4cffb8-c8e9-4734-a61f-37cc6eedeb41	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	SPXW	SPXW260922C07760000	call	7760.0000	2026-09-22	21.2000	21.2000	21.3000	7767.3600	78440.00	0.00	78440.00	37	5	9358	1025	9.12975609756097	0.103509514309929	0.103509514309929	false	false	false	true	false
bcea7d4f-8bad-41e2-92fa-09c5f90512fa	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	SPXW	SPXW260921P07770000	put	7770.0000	2026-09-21	3.0000	2.9500	3.0000	7767.7400	12600.00	12600.00	0.00	42	14	87039	41	2122.90243902439	0.319746863777914	0.319746863777914	false	false	false	true	false
b33bb041-c123-47f3-83a4-a14d5554b96f	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	SPXW	SPXW260921C07745000	call	7745.0000	2026-09-21	22.8000	22.8000	23.8000	7767.8300	27360.00	0.00	27360.00	12	5	130621	776	168.326030927835	1.44507845009167	1.44507845009167	false	false	false	true	false
beb313ac-2275-4a51-a871-d5082e6493ed	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	SPXW	SPXW260922C07770000	call	7770.0000	2026-09-22	16.4000	16.3000	16.4000	7768.0200	65600.00	65600.00	0.00	40	6	10387	318	32.6635220125786	0.104557949097429	0.104557949097429	false	false	false	true	false
987e5668-2397-401a-9468-16194720c55a	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	SPXW	SPXW260921P07770000	put	7770.0000	2026-09-21	2.0000	2.0000	2.0500	7768.0200	10000.00	0.00	10000.00	50	20	86719	41	2115.09756097561	0.083497737604477	0.083497737604477	false	false	false	true	false
4917e0c6-7308-4368-bd9f-5822065271af	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	SPXW	SPXW260921C07770000	call	7770.0000	2026-09-21	0.8400	0.7500	0.8500	7768.0200	32180.00	31220.00	960.00	381	49	194677	1320	147.482575757576	0.288170465310974	0.298312237936597	false	false	false	true	false
bc4a8b97-8a89-419b-aaef-4cea01558dad	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	SPXW	SPXW260922P07665000	put	7665.0000	2026-09-22	0.9500	0.9500	1.0500	7767.8700	10450.00	0.00	10450.00	110	7	1557	89	17.4943820224719	0.146486261882533	0.146486261882533	false	false	false	true	false
cbcc783b-2276-4ee5-9981-084641c3a5d0	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	SPXW	SPXW260925C07900000	call	7900.0000	2026-09-25	3.2000	3.1000	3.2000	7768.2300	25920.00	25920.00	0.00	81	6	3594	2631	1.36602052451539	0.110472127733948	0.110472127733948	false	false	false	true	false