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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = SPX×

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

6df75c1b-62c4-40f8-a3fc-29cb0af4b067	2026-09-25 12:56	2026-09-25 12:56	2026-09-25 12:56	SPX	SPX261218C07710000	call	7710.0000	2026-12-18	254.8600	254.6000	255.4000	7739.5700	127430.00	25480.00	101950.00	5	5	156	3654	0.0426929392446634	0.134825255806385	0.134755730561366	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T16:59:29.985705Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
16899e7e-4c06-4838-8f66-aaa2ad0a2897	2026-09-25 12:55	2026-09-25 12:55	2026-09-25 12:55	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.8000	7738.7800	14950.00	0.00	14950.00	23	7	381	8292	0.0459479015918958	0.126599493821699	0.126599493821699	false	false	false	true
6ab6725a-dcf1-4b3a-9ebf-e2786de0f902	2026-09-25 12:55	2026-09-25 12:55	2026-09-25 12:55	SPX	SPX261218C07710000	call	7710.0000	2026-12-18	254.3000	254.1000	254.7000	7738.8900	152580.00	50860.00	101720.00	6	6	144	3654	0.0394088669950739	0.134689669680174	0.134689669680174	false	false	false
dc93bf5c-2fb2-4b94-8b3f-64fe915d95f6	2026-09-25 12:55	2026-09-25 12:55	2026-09-25 12:55	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.8000	7739.0300	11050.00	0.00	11050.00	17	6	358	8292	0.043174143753015	0.126583630274724	0.126583630274724	false	false	false	true
94738b36-3554-47f0-87ae-83183c926d40	2026-09-25 12:55	2026-09-25 12:55	2026-09-25 12:55	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.8000	7738.2400	13650.00	0.00	13650.00	21	5	341	8292	0.0411239749155813	0.126633760169653	0.126633760169653	false	false	false	true
3d31daf5-0e16-4735-a4a0-dcd56a3eb3e6	2026-09-25 12:54	2026-09-25 12:54	2026-09-25 12:54	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.8000	7738.4500	18850.00	0.00	18850.00	29	6	320	8292	0.0385914134105162	0.126620434191149	0.126620434191149	false	false	false	true
e6d43b3a-3440-4296-a8a6-ffd8583614a4	2026-09-25 12:54	2026-09-25 12:53	2026-09-25 12:53	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7737.3900	18200.00	0.00	18200.00	28	6	254	8292	0.0306319343945972	0.126687700949885	0.126687700949885	false	false	false	true
c074924f-afe7-485c-a0f1-aa87b31a6a8c	2026-09-25 12:53	2026-09-25 12:53	2026-09-25 12:53	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7738.1900	13000.00	0.00	13000.00	20	5	202	8292	0.0243608297153883	0.126636933054796	0.126636933054796	false	false	false	true
8e8aec02-9d84-47c6-9e82-d6c741edaf45	2026-09-25 12:53	2026-09-25 12:53	2026-09-25 12:53	SPX	SPX261218C07710000	call	7710.0000	2026-12-18	253.6400	253.3000	254.2000	7737.7700	177550.00	50730.00	25370.00	7	7	123	3654	0.0336617405582923	0.13473570407255	0.13473570407255	false	false	false
42b573ea-1d62-4626-a319-cfa4088f9437	2026-09-25 12:52	2026-09-25 12:51	2026-09-25 12:51	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7737.3200	15600.00	0.00	15600.00	24	7	121	8292	0.0145923781958514	0.126692143295927	0.126692143295927	false	false	false	true
b49ec946-a31c-4174-a344-450083dd0d2e	2026-09-25 12:51	2026-09-25 12:51	2026-09-25 12:51	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7736.2100	14300.00	0.00	14300.00	22	6	97	8292	0.0116980221900627	0.126762589551765	0.126762589551765	false	false	false	true
90a80d3f-33fe-44b1-a4b2-8738cfdc9a00	2026-09-25 12:51	2026-09-25 12:51	2026-09-25 12:51	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7736.7000	14950.00	0.00	14950.00	23	5	75	8292	0.00904486251808972	0.126731490880216	0.126731490880216	false	false	false	true
9fe5dc7c-27ab-4d1c-9fae-e933b263d50a	2026-09-25 12:51	2026-09-25 12:51	2026-09-25 12:51	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7737.1100	11050.00	0.00	11050.00	17	5	52	8292	0.00627110467920888	0.126705470483962	0.126705470483962	false	false	false	true
3ab01bb3-37df-4f31-a954-a083c607e777	2026-09-25 12:50	2026-09-25 12:50	2026-09-25 12:50	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7736.4000	22750.00	0.00	22750.00	35	5	35	8292	0.00422093584177521	0.126750530737797	0.126750530737797	false	false	false	true
dd35d944-bab4-4dbe-b8e5-c7bb15db9ece	2026-09-25 12:46	2026-09-25 12:46	2026-09-25 12:46	SPX	SPX261016P07650000	put	7650.0000	2026-10-16	50.4000	49.8000	50.6000	7739.8300	1552320.00	846720.00	705600.00	308	15	1296	12970	0.099922898997687	0.128567225779444	0.128596128563166	false	false	false
d4e15648-4e6a-4dd2-8159-6e3aaa151e9c	2026-09-25 12:46	2026-09-25 12:46	2026-09-25 12:46	SPX	SPX261218C07710000	call	7710.0000	2026-12-18	255.0600	254.6000	255.9000	7739.9100	127530.00	25510.00	25510.00	5	5	93	3654	0.0254515599343186	0.134823445730864	0.134823445730864	false	false	false
11982182-a88a-4c4b-830f-d9ebe36ba8c5	2026-09-25 12:36	2026-09-25 12:36	2026-09-25 12:36	SPX	SPX270219P07625000	put	7625.0000	2027-02-19	196.9000	196.1000	197.4000	7738.0800	275660.00	275660.00	0.00	14	6	30	3490	0.00859598853868195	0.157711628507037	0.157694152422946	false	false	false
46a495b0-9cad-4d87-8bf6-d088dea88813	2026-09-25 12:34	2026-09-25 12:34	2026-09-25 12:34	SPX	SPX261016P07670000	put	7670.0000	2026-10-16	53.3000	52.5000	53.3000	7747.3500	490360.00	490360.00	0.00	92	5	103	474	0.217299578059072	0.126508535653245	0.126508535653245	false	false	false	true
2bec24d7-1dfb-4f8a-9710-0d42929b32e1	2026-09-25 12:27	2026-09-25 12:27	2026-09-25 12:27	SPX	SPX270115P07200000	put	7200.0000	2027-01-15	87.1000	87.1000	88.1000	7720.0000	130650.00	0.00	130650.00	15	8	864	5999	0.144024004000667	0.186631236407672	0.186631236407672	false	false	false	true
fce7a29c-9b26-461c-ba69-3289d76e5e3b	2026-09-25 12:24	2026-09-25 12:24	2026-09-25 12:24	SPX	SPX261016P07505000	put	7505.0000	2026-10-16	27.0000	27.0000	27.8000	7733.6500	297000.00	0.00	297000.00	110	6	116	382	0.303664921465969	0.148797923758288	0.148797923758288	false	false	false	true
b172998e-f9ea-40ed-afea-17787bbfae63	2026-09-25 12:14	2026-09-25 12:14	2026-09-25 12:14	SPX	SPX261120C08100000	call	8100.0000	2026-11-20	37.5000	37.0000	37.9000	7743.4100	75000.00	26250.00	33750.00	20	6	93	14413	0.00645250815236245	0.113682993844983	0.113704156830146	false	false	false
57994b83-847a-4d67-bf46-04449fc52f52	2026-09-25 12:13	2026-09-25 12:13	2026-09-25 12:13	SPX	SPX270617C08950000	call	8950.0000	2027-06-17	69.8000	69.1000	69.8000	7725.0000	774780.00	774780.00	0.00	111	5	3000	1487	2.01748486886348	0.127200052498116	0.127200052498116	false	false	false
caa859fc-f049-40ef-879a-16def97a75f9	2026-09-25 12:13	2026-09-25 12:13	2026-09-25 12:13	SPX	SPX261218P07800000	put	7800.0000	2026-12-18	196.0000	197.0000	198.1000	7725.0000	588000.00	0.00	0.00	30	10	486	21709	0.022387028421392	0.139674058566076	0.139674058566076	false	false	false	true
93f0c0db-85fd-4539-839a-625b73cfdf1c	2026-09-25 12:13	2026-09-25 12:13	2026-09-25 12:13	SPX	SPX261218C07800000	call	7800.0000	2026-12-18	206.0000	203.9000	205.2000	7725.0000	618000.00	0.00	0.00	30	10	490	32995	0.0148507349598424	0.13167058010004	0.13167058010004	false	false	false	true
7f372494-aef9-48b1-9903-031406138295	2026-09-25 12:03	2026-09-25 12:03	2026-09-25 12:03	SPX	SPX261016C07710000	call	7710.0000	2026-10-16	113.0000	112.6000	113.7000	7739.9400	293800.00	226000.00	67800.00	26	6	89	483	0.184265010351967	0.117933308047082	0.117933308047082	false	false	false
814c5731-99de-4a38-8068-b7b6fbfb69d0	2026-09-25 11:57	2026-09-25 11:57	2026-09-25 11:57	SPX	SPX261218P07780000	put	7780.0000	2026-12-18	202.6000	200.5000	201.4000	7720.1100	2107040.00	0.00	0.00	104	8	975	3167	0.307862330281023	0.142531632871915	0.142531632871915	false	false	false	true
802d156a-10df-480f-bcd0-b6c79e28b270	2026-09-25 11:57	2026-09-25 11:57	2026-09-25 11:57	SPX	SPX261218C07780000	call	7780.0000	2026-12-18	200.6000	201.8000	202.8000	7720.1100	2086240.00	0.00	0.00	104	8	975	3464	0.281466512702079	0.130556997245051	0.130556997245051	false	false	false	true
b1fc7ed3-9171-4f9a-a746-3033b72fef46	2026-09-25 11:38	2026-09-25 11:38	2026-09-25 11:38	SPX	SPX270319C08400000	call	8400.0000	2027-03-19	91.4000	90.6000	91.4000	7695.0000	63980.00	63980.00	0.00	7	6	1046	11829	0.0884267478231465	0.124764695457972	0.124764695457972	false	false	false	true
5288790d-7621-4ad8-a2cb-90df7890f810	2026-09-25 11:34	2026-09-25 11:34	2026-09-25 11:34	SPX	SPX270219P07500000	put	7500.0000	2027-02-19	172.2000	171.1000	172.2000	7725.0300	6009780.00	6009780.00	0.00	349	8	424	2792	0.151862464183381	0.166912667706047	0.166912667706047	false	false	false
e4589dc5-a012-4abc-8800-aeda4ec24289	2026-09-25 11:33	2026-09-25 11:33	2026-09-25 11:33	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	169.0000	168.7000	169.5000	7705.0000	253500.00	0.00	253500.00	15	5	248	5078	0.0488381252461599	0.129668019974213	0.129668019974213	false	false	false
a6097d72-abcc-4eca-98fa-020d5d84965e	2026-09-25 11:21	2026-09-25 11:21	2026-09-25 11:21	SPX	SPX261016P07550000	put	7550.0000	2026-10-16	37.1000	36.4000	37.1000	7719.6100	148400.00	148400.00	0.00	40	6	180	6247	0.0288138306387066	0.144182097746192	0.144182097746192	false	false	false	true
9c4e5bff-19b1-47b7-b477-0e49cedfcac9	2026-09-25 11:21	2026-09-25 11:21	2026-09-25 11:21	SPX	SPX270319C08400000	call	8400.0000	2027-03-19	92.5000	92.5000	93.2000	7719.6800	111000.00	0.00	111000.00	12	5	526	11829	0.044466987911066	0.124862608420456	0.124862608420456	false	false	false
097b7d16-dee3-4286-8342-3925b6f3a09c	2026-09-25 11:04	2026-09-25 11:04	2026-09-25 11:04	SPX	SPX261120P07750000	put	7750.0000	2026-11-20	157.3000	152.3000	153.7000	7725.7400	235950.00	235950.00	0.00	15	3	20	5286	0.00378357926598562	0.140616236840646	0.140767185278042	false	true	false	true
e87b004e-45d2-437d-8c81-fc67e4d115fd	2026-09-25 10:58	2026-09-25 10:58	2026-09-25 10:58	SPX	SPX261016P07500000	put	7500.0000	2026-10-16	31.0000	31.0000	31.6000	7713.4900	37200.00	0.00	37200.00	12	7	210	36195	0.00580190634065479	0.151233602256768	0.151233602256768	false	false	false	true
d78462dd-d8ae-4710-810e-e2547decab10	2026-09-25 10:41	2026-09-25 10:41	2026-09-25 10:41	SPX	SPX270115C08000000	call	8000.0000	2027-01-15	136.5000	136.3000	137.3000	7707.9600	218400.00	54600.00	163800.00	16	10	56	62021	0.000902919978716886	0.125964379871392	0.125964379871392	false	false	false
dcdb7d17-54e4-4a05-aef7-42cce99852ad	2026-09-25 10:40	2026-09-25 10:40	2026-09-25 10:40	SPX	SPX261218P07765000	put	7765.0000	2026-12-18	200.4500	200.2000	201.1000	7712.0400	11626100.00	0.00	0.00	580	8	1273	2626	0.484767707539985	0.14352157349799	0.14352157349799	false	false	false	true
d9ec282f-a728-414f-819c-8ef0af627090	2026-09-25 10:40	2026-09-25 10:40	2026-09-25 10:40	SPX	SPX261120C07800000	call	7800.0000	2026-11-20	135.1900	134.2000	135.2000	7712.0400	13519000.00	0.00	0.00	1000	8	2755	8007	0.344073935306607	0.127062840703208	0.127062840703208	false	false	false
d82fe048-41d2-4563-9090-bad70965a169	2026-09-25 10:40	2026-09-25 10:40	2026-09-25 10:40	SPX	SPX261218C07765000	call	7765.0000	2026-12-18	207.9500	207.1000	208.1000	7712.0400	12061100.00	0.00	0.00	580	8	1273	2566	0.496102883865939	0.133368549208342	0.133368549208342	false	false	false
76a8594d-b4d1-4047-ba46-15fd56af3cb7	2026-09-25 10:37	2026-09-25 10:36	2026-09-25 10:36	SPX	SPX261120P06100000	put	6100.0000	2026-11-20	9.1000	9.1000	9.4000	7709.2500	17290.00	0.00	17290.00	19	5	250	3141	0.0795924864692773	0.320603840290338	0.320603840290338	false	false	false	true
ea074b06-d141-4774-8d53-c711137e5b46	2026-09-25 10:35	2026-09-25 10:35	2026-09-25 10:35	SPX	SPX261120C08400000	call	8400.0000	2026-11-20	5.0000	4.9000	5.3000	7708.3800	1000000.00	0.00	0.00	2000	12	2000	10156	0.196927924379677	0.112542168716894	0.112542168716894	false	false	false	true
c74ab354-dd2b-42f2-a2a3-0ea5df4f5be4	2026-09-25 10:35	2026-09-25 10:35	2026-09-25 10:35	SPX	SPX261120P06300000	put	6300.0000	2026-11-20	12.0000	11.6000	12.1000	7708.3800	2400000.00	0.00	0.00	2000	12	2004	19329	0.103678410678255	0.297770309763048	0.297770309763048	false	false	false	true
823cfb38-60e6-42fb-9455-8144262f150c	2026-09-25 10:35	2026-09-25 10:35	2026-09-25 10:35	SPX	SPX261218C07950000	call	7950.0000	2026-12-18	113.1500	113.1000	114.2000	7708.3800	11315000.00	0.00	0.00	1000	12	1059	5710	0.185464098073555	0.123281689384462	0.123281689384462	false	false	false
587ac360-4651-4130-80de-4e47c170b7f5	2026-09-25 10:35	2026-09-25 10:35	2026-09-25 10:35	SPX	SPX261218C07765000	call	7765.0000	2026-12-18	205.5000	205.3000	206.4000	7708.3800	7192500.00	0.00	0.00	350	12	693	2566	0.270070148090413	0.133020431451817	0.133020431451817	false	false	false
11ab02ef-c67d-4c9d-acb0-6314dbfe1c5c	2026-09-25 10:35	2026-09-25 10:35	2026-09-25 10:35	SPX	SPX261218P07765000	put	7765.0000	2026-12-18	203.5000	202.2000	203.2000	7708.3800	7122500.00	0.00	0.00	350	12	693	2626	0.263899466869764	0.144423234252124	0.144423234252124	false	false	false	true
e0bb26c5-1f19-45ef-a7b0-af504954991b	2026-09-25 10:28	2026-09-25 10:28	2026-09-25 10:28	SPX	SPX261218P07760000	put	7760.0000	2026-12-18	200.1100	201.2000	202.0000	7706.0200	2101155.00	0.00	0.00	105	7	351	1794	0.195652173913043	0.143041422141025	0.143041422141025	false	false	false	true
86dc1a67-1d40-40f8-b36d-e90319879158	2026-09-25 10:28	2026-09-25 10:28	2026-09-25 10:28	SPX	SPX270820C08950000	call	8950.0000	2027-08-20	107.8600	107.2000	108.1000	7706.0200	5393000.00	0.00	0.00	500	7	500	1680	0.297619047619048	0.131888820205844	0.131888820205844	false	false	false	true
97f52a54-2e99-45d6-b3b3-2df252c172a9	2026-09-25 10:27	2026-09-25 10:27	2026-09-25 10:27	SPX	SPX270617C08950000	call	8950.0000	2027-06-17	63.0000	62.6000	63.7000	7706.9900	17640000.00	0.00	17640000.00	2800	10	2800	1487	1.88298587760592	0.126904212717413	0.126904212717413	false	true	false
633437ec-501c-4b85-a430-7a27e014726c	2026-09-25 10:27	2026-09-25 10:27	2026-09-25 10:27	SPX	SPX270115P07100000	put	7100.0000	2027-01-15	83.9000	83.9000	84.0000	7707.8500	1258500.00	0.00	1258500.00	150	5	178	7181	0.0247876340342571	0.196692342535627	0.196641354900836	false	false	false
3874cae2-3781-4434-9c52-7a5d33dca2fc	2026-09-25 10:17	2026-09-25 10:17	2026-09-25 10:17	SPX	SPX261016P07475000	put	7475.0000	2026-10-16	32.4000	32.0000	32.6000	7695.4300	32400.00	32400.00	0.00	10	7	10	3507	0.00285143997718848	0.157116743162964	0.157116743162964	false	false	false	true
1af91f96-c681-462d-8229-2cd955a91b13	2026-09-25 10:15	2026-09-25 10:15	2026-09-25 10:15	SPX	SPX261016P07375000	put	7375.0000	2026-10-16	22.1000	21.8000	22.3000	7696.6900	22100.00	22100.00	0.00	10	6	38	2456	0.0154723127035831	0.17302164797412	0.17302164797412	false	false	false	true