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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

53914a72-d9fe-4381-84ad-d37cd51e8056	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	2.2000	2.0500	2.4000	7669.0600	13000.00	6015.00	6075.00	59	37	95528	1738	54.9643268124281	0.203771596744524	0.20403907417333	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T19:58:45.768472Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
cc2d8d31-f918-4eae-9199-110edbc5e0bd	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	1.9300	1.6500	2.2000	7669.3600	53325.00	21340.00	25635.00	276	170	95314	1738	54.8411967779056	0.168060350510917	0.177053137322666	false	false	false	true
b84484d5-31e9-4aff-89e4-f728001346b4	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.8900	4.7000	5.1000	7669.3600	10270.00	4010.00	5770.00	21	10	72453	2224	32.5777877697842	0	0	false	false	false	true
de10c8c6-1284-410a-80fd-04d155da9fa9	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	2.0100	1.9000	2.1000	7669.6200	16865.00	15280.00	390.00	84	35	94878	1738	54.590333716916	0.191122485751665	0.207513713038136	false	false	false	true
0606fe8b-91f4-4589-9703-23479b7f0af7	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	5.0300	4.5000	5.3000	7669.6200	22140.00	21190.00	950.00	44	25	72230	2224	32.4775179856115	0	0	false	false	false	true
03bb7197-eaf7-4fdb-bfa8-76f8695221b7	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	1.8300	1.6000	1.9500	7669.6200	27600.00	21005.00	4865.00	151	56	94786	1738	54.5373993095512	0.147599755346206	0.185656564638732	false	false	false	true
e3710a24-5931-45cb-8a98-522f51b9a2e8	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	1.9600	1.8000	2.1500	7669.0100	21215.00	10320.00	8045.00	108	53	94200	1738	54.2002301495972	0.162871629953316	0.140037367456486	false	false	false	true
a06ed019-63c8-4293-a071-cf5581af3d61	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.9400	4.6000	5.1000	7669.2700	52350.00	41450.00	9920.00	106	40	71810	2224	32.2886690647482	0	0	false	false	false	true
36514ead-3203-4e37-a24e-4f775549973f	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	9.1600	8.8000	9.5000	7669.0100	18330.00	7400.00	10010.00	20	6	40263	1065	37.8056338028169	0	0	false	false	false	true
25479d14-b011-431e-ac03-cfa2dad0cb2e	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.9900	4.6000	5.4000	7669.0100	13480.00	6050.00	7430.00	27	24	71864	2224	32.3129496402878	0	0	false	false	false	true
9594b120-35ba-4b60-a951-95dced69fa8a	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.7800	4.5000	5.0000	7669.3900	28180.00	16230.00	9150.00	59	47	71702	2224	32.2401079136691	0	0	false	false	false	true
2bd43bda-5621-4716-ae0a-e636b42f3bd8	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	8.8700	8.5000	9.1000	7669.3700	18630.00	16860.00	1770.00	21	11	40184	1065	37.731455399061	0	0	false	false	false	true
a020a955-3c4f-410f-9cd1-fe7da681a104	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.5700	4.4000	5.1000	7669.5000	21040.00	11650.00	8910.00	46	27	71582	2224	32.1861510791367	0	0	true	false	false	true
215ca852-469c-424c-a710-e9a181b24af0	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.6300	4.3000	5.0000	7669.6400	11570.00	8820.00	2750.00	25	17	71489	2224	32.1443345323741	0	0	false	false	false	true
1f5dff37-2ca6-46b4-a0ee-df6460842a5a	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	9.2800	9.0000	9.5000	7669.6100	17630.00	14920.00	2710.00	19	6	40126	1065	37.6769953051643	0	0	false	false	false	true
9d75906b-9816-40f5-b37a-584b0bf9f75e	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	1.9200	1.7500	2.2000	7669.6400	21080.00	10240.00	6030.00	110	48	93415	1738	53.7485615650173	0.172589138889222	0.188674613333514	false	false	false	true
0f0f10cb-f23a-4571-ad56-f4561ecbb817	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	1.9900	1.3000	2.2500	7669.4600	74140.00	40995.00	31700.00	372	138	93012	1738	53.5166858457998	0.328049114381992	0.177307043746478	false	false	false	true
ef671d80-b0df-4702-8ee3-fb1e455eb0f5	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07670000	put	7670.0000	2026-10-01	1.4600	1.0000	2.0000	7673.3500	25585.00	25265.00	320.00	175	74	92585	1738	53.271001150748	0.262013281865349	0.256287931139143	false	false	false	true
e7078fc3-6c6d-4c81-aafd-e2202b5d6755	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	7.7800	6.2000	9.8000	7673.3500	41250.00	40440.00	810.00	53	22	39851	1065	37.418779342723	0.24287920935847	0.414653615950346	false	false	false	true
8af7b60f-f135-488f-9691-f7db5b619d26	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	4.0100	2.8000	5.0000	7673.3500	49300.00	49300.00	0.00	123	54	70979	2224	31.9150179856115	0.241723425550439	0.405228111648509	false	false	false	true
147b537a-e5cd-4e29-b52f-0fb318f9b74c	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	3.0000	2.6500	3.0000	7673.3500	31165.00	30900.00	265.00	104	27	70813	2224	31.8403776978417	0.180150445736797	0.219554635003887	false	false	false	true
d12e8cd4-5d32-4765-87b3-1cdd2f1d9e23	2026-10-01 15:55	2026-10-01 15:54	2026-10-01 15:54	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	2.5600	2.4500	2.6500	7673.6500	12785.00	5415.00	7370.00	50	16	70590	2224	31.7401079136691	0.183808753580017	0.189638375967445	false	false	false	true
585cf787-e2a4-436a-aee0-03b08eca4e88	2026-10-01 15:55	2026-10-01 15:54	2026-10-01 15:54	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	5.5400	5.4000	5.6000	7673.7200	14960.00	7260.00	5500.00	27	22	39609	1065	37.1915492957746	0	0	false	false	false	true
04a6afb7-5f19-42c6-b94a-2c5d7dd7b2ca	2026-10-01 15:55	2026-10-01 15:54	2026-10-01 15:54	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	5.8500	5.6000	6.0000	7673.6500	15220.00	8250.00	5220.00	26	20	39659	1065	37.2384976525822	0	0	false	false	false	true
f9feb2bd-734f-4db9-b47a-856a3a298ca9	2026-10-01 15:54	2026-10-01 15:54	2026-10-01 15:54	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	2.0400	1.9000	2.2500	7674.0600	20985.00	7900.00	12665.00	103	54	70178	2224	31.5548561151079	0.241287445986635	0.171025264111135	false	false	false	true
ddca07b9-5638-464e-bcf4-c4e46c74a227	2026-10-01 15:54	2026-10-01 15:54	2026-10-01 15:54	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	2.0100	1.8000	2.1500	7675.6600	16455.00	16085.00	0.00	82	38	70068	2224	31.5053956834532	0.225553573197704	0.257007894834978	false	false	false	true
8a40b2d4-6739-47e2-9588-f7cf41c42680	2026-10-01 15:54	2026-10-01 15:54	2026-10-01 15:54	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	5.0400	4.5000	5.3000	7675.6600	23670.00	23670.00	0.00	47	19	39302	1065	36.9032863849765	0.226832268160121	0.267632133363852	false	false	false	true
26b187a1-f0e5-450c-a930-b955c94e1df0	2026-10-01 15:54	2026-10-01 15:54	2026-10-01 15:54	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	5.1900	4.9500	5.4000	7675.6600	20230.00	10920.00	8790.00	39	19	39345	1065	36.943661971831	0.212246120806957	0.254827084409963	false	false	false	true
ea74e2b4-6703-4dd8-b539-21a24a2a0b85	2026-10-01 15:54	2026-10-01 15:54	2026-10-01 15:54	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	1.6100	1.4000	1.6500	7676.0800	24585.00	13075.00	11360.00	153	47	69384	2224	31.1978417266187	0.200962650962821	0.221627178469423	false	false	false	true
7174919a-0a85-492b-9158-433e6399c641	2026-10-01 15:54	2026-10-01 15:54	2026-10-01 15:54	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	1.7100	1.6000	1.7500	7676.0800	48455.00	8540.00	39065.00	284	50	69673	2224	31.3277877697842	0.221627178469423	0.232512803276415	false	false	false	true
0142707e-c8b8-412a-9f5d-4030149b5766	2026-10-01 15:54	2026-10-01 15:54	2026-10-01 15:54	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	4.2800	3.9000	4.5000	7676.0800	14120.00	9000.00	3840.00	33	17	39033	1065	36.6507042253521	0.112223653396405	0.186070605836004	false	false	false	true
96d77931-e263-4197-9622-1e0e1ed1a807	2026-10-01 15:54	2026-10-01 15:54	2026-10-01 15:54	SPXW	SPXW261001P07675000	put	7675.0000	2026-10-01	1.4900	1.3500	1.5250	7676.8600	12785.00	11655.00	840.00	86	45	69155	2224	31.0948741007194	0.22631268573284	0.226666738693073	false	false	false	true
b9856b37-604f-4dc6-b1ce-28a97aa535d3	2026-10-01 15:54	2026-10-01 15:53	2026-10-01 15:53	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	3.1800	3.0000	3.3000	7677.7700	26730.00	23050.00	3680.00	84	28	37832	1065	35.5230046948357	0.163436889211984	0.181465783589249	false	false	false	true
ad6bab14-130f-4fd8-97b4-110b223d90ed	2026-10-01 15:54	2026-10-01 15:53	2026-10-01 15:53	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	3.0000	2.9000	3.1000	7677.8000	16480.00	11680.00	3000.00	55	19	37738	1065	35.4347417840376	0.156127479572009	0.161675329179431	false	false	false	true
556d5614-5001-4ce7-8273-9145cd293066	2026-10-01 15:53	2026-10-01 15:53	2026-10-01 15:53	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	2.8100	2.7000	2.9000	7678.3700	12355.00	8240.00	2180.00	44	22	36784	1065	34.5389671361502	0.175240080163179	0.180424788299334	false	false	false	true
f2a15c6c-c915-42bd-bbba-4101b83654fa	2026-10-01 15:53	2026-10-01 15:53	2026-10-01 15:53	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	2.9800	2.8500	3.0000	7678.5900	23225.00	22940.00	285.00	78	32	36692	1065	34.4525821596244	0.192513472571345	0.207204047318163	false	false	false	true
231e1a49-110d-4094-adb4-295fd6c296b4	2026-10-01 15:53	2026-10-01 15:53	2026-10-01 15:53	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	6.0000	5.8000	6.1000	7678.8500	14990.00	13810.00	0.00	25	6	138289	1662	83.2063778580024	0.330506006616197	0.350598566937408	false	false	false	true
8ff68a06-937e-49ed-8d55-92dd314809f4	2026-10-01 15:53	2026-10-01 15:53	2026-10-01 15:53	SPXW	SPXW261001C07670000	call	7670.0000	2026-10-01	10.2700	10.0000	10.4000	7679.0300	15410.00	15410.00	0.00	15	5	127476	929	137.218514531755	0.382779852421741	0.382779852421741	false	false	false	true
1b806b44-ca43-48cb-a070-24dc525c49f9	2026-10-01 15:52	2026-10-01 15:52	2026-10-01 15:52	SPXW	SPXW261001C07680000	call	7680.0000	2026-10-01	3.8700	3.6000	3.9000	7681.0100	19360.00	19360.00	0.00	50	10	163944	862	190.190255220418	0.288825347887254	0.297729626390986	false	false	false	true
799d0cd9-791a-470b-8d2c-a63a675d5505	2026-10-01 15:52	2026-10-01 15:52	2026-10-01 15:52	SPXW	SPXW261001C07680000	call	7680.0000	2026-10-01	3.3700	3.1000	3.5000	7680.0500	11800.00	11160.00	310.00	35	5	163565	862	189.750580046404	0.277231965267016	0.294708043096248	false	false	false	true
5f95c542-4855-41f2-9eb6-93d6dc50871d	2026-10-01 15:52	2026-10-01 15:52	2026-10-01 15:52	SPXW	SPXW261001C07680000	call	7680.0000	2026-10-01	3.1800	3.0000	3.3000	7679.6400	11140.00	2190.00	0.00	35	6	163254	862	189.389791183295	0.282950796502395	0.29159911248583	false	false	false	true
6b308d6a-e168-4381-bfe0-45e07842fefb	2026-10-01 15:52	2026-10-01 15:52	2026-10-01 15:52	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	2.5200	2.4000	2.6500	7681.0300	11855.00	11855.00	0.00	47	15	34277	1065	32.1849765258216	0.255400278592985	0.268334974963551	false	false	false	true
5b3999d7-190f-4077-bbc1-fcc8a351bbb5	2026-10-01 15:52	2026-10-01 15:52	2026-10-01 15:52	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	2.2100	2.1500	2.3500	7681.1500	12150.00	9515.00	2415.00	55	31	34222	1065	32.1333333333333	0.233765518845141	0.234019106126891	false	false	false	true
b5663a93-bd06-4000-ba64-d602cd174c11	2026-10-01 15:52	2026-10-01 15:52	2026-10-01 15:52	SPXW	SPXW261001P07680000	put	7680.0000	2026-10-01	2.0000	1.9000	2.0000	7682.0500	18970.00	18970.00	0.00	95	32	33951	1065	31.8788732394366	0.242594751487823	0.24700938302564	false	false	false	true
c84f10d6-4db4-48c8-98c5-765667bfd031	2026-10-01 15:52	2026-10-01 15:52	2026-10-01 15:52	SPXW	SPXW261001C07685000	call	7685.0000	2026-10-01	1.8200	1.7500	1.9000	7682.0300	18390.00	14425.00	185.00	101	13	128279	1038	123.582851637765	0.257748615709554	0.262286967864548	false	false	false	true
9ec8f744-62a5-4245-93e0-7e7df274bec0	2026-10-01 15:52	2026-10-01 15:52	2026-10-01 15:52	SPXW	SPXW261001C07675000	call	7675.0000	2026-10-01	8.0400	7.8000	8.2000	7682.2600	12060.00	3280.00	7980.00	15	7	137676	1662	82.8375451263538	0.260669671670507	0.23337990382359	false	false	false	true
b6c3a730-1247-4af3-ad68-63b266d84697	2026-10-01 15:51	2026-10-01 15:51	2026-10-01 15:51	SPXW	SPXW261001C07680000	call	7680.0000	2026-10-01	4.5900	4.4000	4.7000	7682.6700	12840.00	9260.00	3130.00	28	12	161950	862	187.877030162413	0.233844852307478	0.242926446951126	false	false	false	true
94ca6a29-2258-4868-b2b2-f2941455d0e3	2026-10-01 15:51	2026-10-01 15:51	2026-10-01 15:51	SPXW	SPXW261001C07680000	call	7680.0000	2026-10-01	5.6400	5.3000	5.7000	7683.9800	22560.00	19320.00	3240.00	40	17	161414	862	187.255220417633	0.219533278425239	0.268034849345411	false	false	false	true
8b538a59-ef3e-41d1-83f4-8af519d1b5ab	2026-10-01 15:51	2026-10-01 15:51	2026-10-01 15:51	SPXW	SPXW261001C07680000	call	7680.0000	2026-10-01	6.0800	5.8000	6.2000	7684.4100	142300.00	131560.00	10740.00	234	43	161323	862	187.149651972158	0.260834752382896	0.249098474879195	false	false	false	true
2c0d115a-c723-4356-9570-037342f88d98	2026-10-01 15:51	2026-10-01 15:51	2026-10-01 15:51	SPXW	SPXW261001C07685000	call	7685.0000	2026-10-01	3.0200	2.8500	3.2000	7684.5300	11160.00	4950.00	5920.00	37	24	126207	1038	121.586705202312	0.252640809903802	0.266247001532757	true	false	false	true