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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

3161ba4a-d2b0-4483-a717-9b672dd3186c	2026-10-02 10:54	2026-10-02 10:54	2026-10-02 10:54	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	14.2600	14.1000	14.4000	7737.4500	64180.00	42900.00	14180.00	45	19	30007	627	47.8580542264753	0.175820920822052	0.174478103871849	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T14:56:26.560127Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
80401d3d-7434-4daf-899d-4a1f06ce06c3	2026-10-02 10:54	2026-10-02 10:54	2026-10-02 10:54	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	15.3200	15.1000	15.4000	7739.2200	18380.00	15340.00	1520.00	12	10	27307	805	33.9217391304348	0.166939539249848	0.163819651411997	false	false	false	true
f63f1dee-7269-4431-83c2-ed21655023bf	2026-10-02 10:54	2026-10-02 10:54	2026-10-02 10:54	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	7.3100	7.3000	7.5000	7740.3200	16090.00	750.00	15340.00	22	5	51955	9660	5.37836438923395	0.156219267836178	0.153385524831093	false	false	false	true
9dda64f4-27a4-4457-9411-5cb8068bfe2f	2026-10-02 10:54	2026-10-02 10:54	2026-10-02 10:54	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	7.8600	7.7000	8.1000	7741.2600	18870.00	810.00	10940.00	24	9	51865	9660	5.36904761904762	0.158212235581342	0.155410774023557	false	false	false	true
60ee4d74-9d30-45f5-9662-4c89579fbd25	2026-10-02 10:54	2026-10-02 10:54	2026-10-02 10:54	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	11.6300	11.6000	11.8000	7740.9300	15120.00	1180.00	12770.00	13	10	29348	627	46.8070175438597	0.164425383317988	0.163082067540176	false	false	false	true
7b756899-43d8-4636-bfcd-f0785825946a	2026-10-02 10:54	2026-10-02 10:54	2026-10-02 10:54	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	7.9300	7.8000	8.0000	7741.2700	11900.00	4000.00	7110.00	15	5	51707	9660	5.35269151138716	0.15805774486095	0.156658526579104	true	false	false	true
5a04f03e-4658-4590-bbd5-258244307d34	2026-10-02 10:53	2026-10-02 10:53	2026-10-02 10:53	SPXW	SPXW261002C07770000	call	7770.0000	2026-10-02	2.5500	2.5500	2.6500	7740.8200	15310.00	0.00	14790.00	60	5	35594	4210	8.45463182897862	0.158877119080388	0.158877119080388	false	false	false	true
c540e8d6-bbeb-4481-ba08-7fdc56d98ba0	2026-10-02 10:53	2026-10-02 10:53	2026-10-02 10:53	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	12.2000	12.0000	12.4000	7740.0800	23180.00	14640.00	6110.00	19	10	28990	627	46.2360446570973	0.16672480758845	0.165383574003619	false	false	false	true
44277f99-8090-442c-8e73-f35b8012d033	2026-10-02 10:53	2026-10-02 10:53	2026-10-02 10:53	SPXW	SPXW261002P07750000	put	7750.0000	2026-10-02	18.0200	18.0000	18.1000	7739.7800	23430.00	5430.00	18000.00	13	6	19556	2330	8.3931330472103	0.166774767237518	0.165362613995608	false	false	false	true
dc05e779-dcb2-4b2f-84a9-ac4b28d17b24	2026-10-02 10:53	2026-10-02 10:53	2026-10-02 10:53	SPXW	SPXW261002P07725000	put	7725.0000	2026-10-02	6.7700	6.6000	7.0000	7740.5100	15580.00	1380.00	12830.00	23	21	25579	2308	11.0827556325823	0.178510330031465	0.173998906915082	false	false	false	true
fadcff25-6ee9-40e1-9c25-ba3a4fd03a44	2026-10-02 10:53	2026-10-02 10:53	2026-10-02 10:53	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	13.6300	13.6000	13.8000	7741.4400	27250.00	0.00	27250.00	20	6	26491	805	32.9080745341615	0.159924623555472	0.159924623555472	false	false	false	true
ca74bd4c-541f-46ef-9bf5-9e352c17ff3e	2026-10-02 10:53	2026-10-02 10:53	2026-10-02 10:53	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	13.9800	13.9000	14.2000	7740.9900	244670.00	1420.00	229250.00	175	33	26368	805	32.7552795031056	0.162592428096744	0.159283289880187	false	false	false	true
39033ad9-f45a-4d7e-968c-28f8acc6a5fc	2026-10-02 10:53	2026-10-02 10:52	2026-10-02 10:52	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	12.2200	12.1000	12.4000	7740.5500	51340.00	33000.00	17120.00	42	14	28268	627	45.0845295055821	0.16966843453447	0.168328240001113	false	false	false	true
199fe563-1b5e-434e-85ad-f8ade5803e35	2026-10-02 10:53	2026-10-02 10:52	2026-10-02 10:52	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	11.9400	11.9000	12.1000	7740.6200	14330.00	1200.00	8330.00	12	6	28220	627	45.0079744816587	0.166102457618928	0.166102457618928	false	false	false	true
76d8f934-fda5-493a-804b-0538eee1a8ad	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	11.9200	11.9000	12.1000	7740.6300	13110.00	0.00	11910.00	11	7	28145	627	44.8883572567783	0.166542901679193	0.16481009171923	false	false	false	true
5242babd-330f-4fc8-9ae7-6489343bd9cd	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	SPXW	SPXW261002P07730000	put	7730.0000	2026-10-02	8.2200	8.1000	8.3000	7740.6800	35360.00	8300.00	21320.00	43	7	26428	487	54.2669404517454	0.174481827525543	0.173064357611543	false	false	false	true
2a5b910b-1d9a-4cbe-81c2-bd665ee8a734	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	7.9900	7.9000	8.1000	7741.2900	38360.00	800.00	37560.00	48	13	51016	9660	5.28115942028986	0.157623797025498	0.157623797025498	false	false	false	true
211e49a3-cabe-4680-9185-def985e3db23	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	12.0600	12.0000	12.1000	7740.6800	16880.00	9680.00	7200.00	14	7	28129	627	44.8628389154705	0.167808668601146	0.167808668601146	false	false	false	true
d17d7a53-56ed-40c8-b5f7-69a5f33c218a	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	SPXW	SPXW261002C07745000	call	7745.0000	2026-10-02	10.7100	10.6000	10.8000	7743.0000	12850.00	7540.00	5310.00	12	9	28050	1571	17.8548695098663	0.156441581388336	0.15510023020621	false	false	false	true
85d7a21a-b488-42af-8560-ef2d0c769c36	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	11.2300	11.2000	11.4000	7743.0000	39310.00	5700.00	32480.00	35	8	27996	627	44.6507177033493	0.171804330504843	0.173150044370531	false	false	false	true
bdfd6ba1-15f4-4763-a8b9-a13a3a229c7f	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	SPXW	SPXW261002P07750000	put	7750.0000	2026-10-02	15.9200	15.8000	16.1000	7742.5100	19100.00	1600.00	15900.00	12	5	19086	2330	8.19141630901288	0.160475203358346	0.160475203358346	false	false	false	true
5c4e942d-667c-4b6b-8129-ea8db3712fe6	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	SPXW	SPXW261005C07730000	call	7730.0000	2026-10-05	32.0600	32.1000	32.3000	7743.2800	96180.00	0.00	96180.00	30	11	1089	2120	0.513679245283019	0.0833443227220723	0.0833443227220723	false	false	false	true
4607c185-f198-43f6-886d-20a1d6d43af7	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	13.1600	13.1000	13.3000	7743.2800	21060.00	2640.00	7860.00	16	5	25298	805	31.4260869565217	0.167870015563638	0.164798634406444	false	false	false	true
66f97ec1-6ba6-4c41-8638-96aa97d577f0	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	11.6100	11.6000	11.7000	7745.2700	10450.00	1170.00	9280.00	9	5	25045	805	31.111801242236	0.159468165317753	0.158130830051685	false	false	false	true
cc7ddc7c-1b7e-4b88-a8eb-e09bb9cbfef4	2026-10-02 10:52	2026-10-02 10:51	2026-10-02 10:51	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	8.9500	8.9000	9.1000	7746.5700	18800.00	0.00	18800.00	21	6	27430	627	43.7480063795853	0.161500348565247	0.16012918789316	false	false	false	true
eebd76c6-90fb-42b5-b277-e8146a0d59ec	2026-10-02 10:51	2026-10-02 10:51	2026-10-02 10:51	SPXW	SPXW261002C07745000	call	7745.0000	2026-10-02	12.0100	11.9000	12.2000	7746.9500	10810.00	0.00	9600.00	9	5	27730	1571	17.6511775938892	0.14695577409457	0.145615741841431	false	false	false	true
bc8277b1-da47-4f05-be76-0044a1095e94	2026-10-02 10:51	2026-10-02 10:51	2026-10-02 10:51	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	9.5600	9.5000	9.7000	7746.9500	41100.00	0.00	41100.00	43	23	50312	9660	5.20828157349897	0.146553053439564	0.14521016444526	false	false	false	true
4a35a04e-fec0-4db8-a4bd-9d72e58fa0d6	2026-10-02 10:51	2026-10-02 10:51	2026-10-02 10:51	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	10.2200	10.2000	10.4000	7747.0900	18390.00	2060.00	15300.00	18	6	50200	9660	5.19668737060041	0.155021300310772	0.153680345997183	false	false	false	true
e9dff345-4dd2-4c14-ae9d-b0b8ec97dac3	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002P07735000	put	7735.0000	2026-10-02	7.6200	7.6000	7.8000	7746.4500	46470.00	0.00	46470.00	61	17	19859	711	27.9310829817159	0.169249180360467	0.167820716133523	false	false	false	true
4b2f8556-9ed9-474b-b5ab-ee2cf14d702f	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	9.4900	9.3000	9.5000	7746.4500	33210.00	29450.00	2820.00	35	6	26857	627	42.8341307814992	0.165076821750623	0.165988944846682	false	false	false	true
8713bec8-8511-4d30-a0da-4de9f92e9434	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	11.8100	11.8000	12.0000	7746.0000	172450.00	0.00	152220.00	146	34	24567	805	30.5180124223602	0.166554763170958	0.165219603209448	false	false	false	true
ccc7fbe7-1c20-47bd-82d1-01ced0a49455	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002C07745000	call	7745.0000	2026-10-02	12.6000	12.4000	12.7000	7747.0400	11340.00	2520.00	8820.00	9	6	27520	1571	17.5175047740293	0.15411338348664	0.151441657522812	false	false	false	true
112ade4d-be24-4255-9b41-905cd132ee06	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002P07750000	put	7750.0000	2026-10-02	13.7000	13.7000	13.8000	7746.7800	30150.00	1380.00	28770.00	22	6	18166	2330	7.79656652360515	0.162969748593888	0.161629798759464	false	false	false	true
93625006-2bee-4814-b089-7d2a00743fd1	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002P07700000	put	7700.0000	2026-10-02	1.9500	1.9000	2.0000	7745.4400	13070.00	200.00	11505.00	67	5	49410	4177	11.8290639214747	0.199179027523827	0.197759798165015	false	false	false	true
163bd7fd-e36c-4111-8639-7170f42c170e	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	9.5400	9.5000	9.6000	7744.8500	12400.00	4800.00	7600.00	13	5	49890	9660	5.16459627329193	0.158894567985125	0.157542652948762	false	false	false	true
893728fb-5f05-478e-af23-a13344a1f917	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	10.1100	10.0000	10.2000	7746.1800	13140.00	2040.00	11100.00	13	6	26475	627	42.2248803827751	0.175235929135641	0.172517191785639	false	false	false	true
2aecdb15-aefd-4943-b11e-17de9098a721	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	9.5300	9.4000	9.6000	7746.3000	11440.00	3840.00	5700.00	12	6	49819	9660	5.15724637681159	0.150221903052315	0.148878541201959	false	false	false	true
7948ae47-f8cc-4560-a4a9-50925383a0a8	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002P07750000	put	7750.0000	2026-10-02	14.5200	14.3000	14.6000	7746.3000	14520.00	5820.00	8700.00	10	7	17977	2330	7.71545064377682	0.170151677226192	0.168810671555237	false	false	false	true
5b88d7dd-1b85-4eb8-9870-d5fc7ff95642	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	12.0600	12.0000	12.1000	7746.3000	31350.00	18150.00	13200.00	26	11	24161	805	30.0136645962733	0.171049028734186	0.169714287146003	false	false	false	true
11a8d020-564a-452e-a815-86c998150ace	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	9.1300	9.1000	9.3000	7747.5300	34710.00	11040.00	22750.00	38	10	26330	627	41.993620414673	0.169152930537146	0.169157425856966	false	false	false	true
b97d6dfc-42b1-46ea-bab2-2b1b82d2003b	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002C07755000	call	7755.0000	2026-10-02	7.8200	7.8000	8.0000	7747.5400	10170.00	1580.00	7800.00	13	5	38335	3267	11.7340067340067	0.148664231139254	0.147286136648092	false	false	false	true
805f3650-bb59-4c61-8457-a9cb4d22fd4d	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002C07755000	call	7755.0000	2026-10-02	8.0000	7.9000	8.1000	7748.5700	10400.00	810.00	9590.00	13	7	38097	3267	11.6611570247934	0.145690231226387	0.14295541603104	false	false	false	true
90286e55-596e-48e0-be94-4c69dcd45966	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPXW	SPXW261002C07755000	call	7755.0000	2026-10-02	8.5000	8.4000	8.6000	7749.8000	28060.00	1710.00	2550.00	33	6	38065	3267	11.6513621059076	0.145278127072716	0.144097895323194	false	false	false	true
577ee47f-d037-4eb7-9870-0b18d09e1d3d	2026-10-02 10:48	2026-10-02 10:48	2026-10-02 10:48	SPXW	SPXW261002P07750000	put	7750.0000	2026-10-02	11.2600	11.2000	11.4000	7751.5300	10130.00	0.00	4480.00	9	6	17252	2330	7.40429184549356	0.161329256181896	0.161329256181896	false	false	false	true
50627ae0-746a-4b04-a741-5a0bc58e0c7d	2026-10-02 10:48	2026-10-02 10:48	2026-10-02 10:48	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	12.3400	12.3000	12.5000	7752.7700	16040.00	0.00	16040.00	13	6	48760	9660	5.04761904761905	0.144202316947018	0.142870167352307	false	false	false	true
e305c232-9268-4900-8bf1-8eab7764b33b	2026-10-02 10:48	2026-10-02 10:48	2026-10-02 10:48	SPXW	SPXW261002P07735000	put	7735.0000	2026-10-02	6.0000	5.9000	6.1000	7751.2500	59950.00	0.00	59950.00	100	20	19203	711	27.0084388185654	0.166674658688947	0.166674658688947	false	false	false	true
c107d7e8-8afe-43a7-8e3d-c20aef18aa56	2026-10-02 10:47	2026-10-02 10:47	2026-10-02 10:47	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	11.9800	11.9000	12.0000	7750.9800	22770.00	19200.00	3570.00	19	7	48043	9660	4.97339544513458	0.151308198044462	0.149980627713568	false	false	false	true
83197d0e-b981-4431-ae4f-cc738cdea0e7	2026-10-02 10:47	2026-10-02 10:47	2026-10-02 10:47	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	12.0000	11.9000	12.0000	7750.7300	202750.00	196800.00	5950.00	169	42	48000	9660	4.96894409937888	0.153009509344978	0.151682430361308	false	false	false	true
5b1faad5-204f-4b08-99fa-0349a3250780	2026-10-02 10:47	2026-10-02 10:47	2026-10-02 10:47	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	8.4600	8.3000	8.5000	7749.2800	15220.00	8500.00	5040.00	18	11	25350	627	40.4306220095694	0.16817346168537	0.166785898574322	false	false	false	true
4706091a-278f-47cb-813c-4d10d20509c3	2026-10-02 10:47	2026-10-02 10:47	2026-10-02 10:47	SPXW	SPXW261002P07725000	put	7725.0000	2026-10-02	4.6300	4.5000	4.7000	7749.0400	11120.00	5140.00	5980.00	24	24	23639	2308	10.2422010398614	0.179181980353562	0.177465946328506	false	false	false	true