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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = SPXW×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate	price

faa9ad0a-d446-4dc7-b125-13dd23ebf0d5	2026-08-27 12:23	2026-08-27 12:22	2026-08-27 12:22	SPXW	SPXW261030P07500000	put	7500.0000	2026-10-30	88.5200	88.5000	89.0000	7722.4300	531120.00	0.00	531120.00	60	6	63	1264	0.0498417721518987	0.15430626222619	0.154214049390859	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-08-27T16:30:57.923324Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ddc58d4f-24be-49bb-a89d-037efe7ac864	2026-08-27 12:27	2026-08-27 12:26	2026-08-27 12:26	SPXW	SPXW260930C07750000	call	7750.0000	2026-09-30	107.2500	106.6000	108.4000	7723.0300	1072480.00	1018630.00	53850.00	100	14	200	15434	0.0129584035246858	0.113575346647949	0.114319881535962	false	false	false	true	false
a58f9fc1-9cf0-42c8-b883-92bf002434ed	2026-08-27 12:35	2026-08-27 12:35	2026-08-27 12:35	SPXW	SPXW260827P07750000	put	7750.0000	2026-08-27	21.8000	21.6000	21.9000	7729.1600	109000.00	17440.00	91560.00	50	13	2334	253	9.22529644268775	0.116504196197295	0.116504196197295	false	false	false	true	false
c8bab5b5-545e-4a45-b69f-aacbd5157241	2026-08-27 12:40	2026-08-27 12:40	2026-08-27 12:40	SPXW	SPXW260925P07730000	put	7730.0000	2026-09-25	92.6300	92.1000	94.4000	7733.5200	277890.00	148090.00	129800.00	30	5	56	39	1.43589743589744	0.121313785387161	0.121776963240565	false	false	false	true	false
a13e523f-8afe-42b7-8517-35685f2a4f82	2026-08-27 12:40	2026-08-27 12:40	2026-08-27 12:40	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	9.1100	9.0000	9.3000	7733.6900	141140.00	73800.00	49140.00	155	38	89642	2566	34.9345284489478	0.117031098921361	0.117036074686577	false	false	false	true	false
f8dc4f80-2d78-4574-a9a2-521609df1fa7	2026-08-27 12:41	2026-08-27 12:40	2026-08-27 12:40	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	9.6000	9.6000	9.8000	7734.0800	219920.00	980.00	218940.00	229	18	90336	2566	35.2049883086516	0.125267818268024	0.121850301918539	false	false	false	true	false
6eb34eae-9795-45ac-9c19-4db81b4d9f20	2026-08-27 12:43	2026-08-27 12:43	2026-08-27 12:43	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	10.2000	10.1000	10.2000	7735.2400	184620.00	184620.00	0.00	181	35	91905	2566	35.8164458300857	0.120957663666156	0.120957663666156	false	false	false	true	false
857e7573-ee29-4b24-9e65-66193f29268a	2026-08-27 12:44	2026-08-27 12:44	2026-08-27 12:44	SPXW	SPXW260828P07730000	put	7730.0000	2026-08-28	20.1000	19.9000	20.2000	7734.4100	100500.00	90450.00	0.00	50	7	957	423	2.26241134751773	0.140052336018494	0.140052336018494	false	false	false	true	false
f8e83fbf-1101-427c-90cf-c703baa7ac2d	2026-08-27 12:44	2026-08-27 12:44	2026-08-27 12:44	SPXW	SPXW260910C07820000	call	7820.0000	2026-09-10	26.1700	25.8000	27.1000	7734.6000	261660.00	201540.00	60120.00	100	10	219	23	9.52173913043478	0.0912508293287413	0.0910837586444736	false	false	false	true	false
5db00d75-d6a6-4edf-aa12-a6b75703ccf4	2026-08-27 12:44	2026-08-27 12:44	2026-08-27 12:44	SPXW	SPXW260910C07820000	call	7820.0000	2026-09-10	26.1200	25.9000	26.4000	7734.6000	449180.00	68120.00	381060.00	172	5	391	23	17	0.0914633752226226	0.0912736229324795	false	false	false	true	false
080c15dd-7b70-4aa3-8886-400e52da7000	2026-08-27 12:45	2026-08-27 12:45	2026-08-27 12:45	SPXW	SPXW260910C07820000	call	7820.0000	2026-09-10	26.5000	26.2000	26.8000	7734.8700	214650.00	166950.00	0.00	81	6	919	23	39.9565217391304	0.0918776334802661	0.0918776334802661	false	false	false	true	false
ce0e57cd-2384-4610-9f4c-636c4f4a381f	2026-08-27 12:45	2026-08-27 12:45	2026-08-27 12:45	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	10.5900	10.4000	10.7000	7735.6400	114410.00	20110.00	15860.00	108	13	92726	2566	36.1363990646921	0.124398172801245	0.124178201358816	false	false	false	true	false
ba6d33b7-fb14-4734-b3f9-a502c3f38164	2026-08-27 12:45	2026-08-27 12:45	2026-08-27 12:45	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	11.2100	11.1000	11.4000	7736.9900	117700.00	26040.00	91660.00	105	15	93098	2566	36.2813717848792	0.121368616138872	0.119545621075627	false	false	false	true	false
db4dbe12-eef4-4ac4-867c-88c7264a307b	2026-08-27 12:45	2026-08-27 12:45	2026-08-27 12:45	SPXW	SPXW260910C07820000	call	7820.0000	2026-09-10	27.1400	26.9000	27.3000	7736.6600	208980.00	114130.00	0.00	77	6	1208	23	52.5217391304348	0.0919813407351001	0.0919813407351001	false	false	false	true	false
5453bd82-7564-42b2-bede-3300bdcf9d54	2026-08-27 12:46	2026-08-27 12:46	2026-08-27 12:46	SPXW	SPXW260828P07730000	put	7730.0000	2026-08-28	19.2100	19.2000	19.4000	7736.2500	188290.00	0.00	174780.00	98	18	1232	423	2.91252955082742	0.140289738369779	0.13966561022207	false	false	false	true	false
4469c7a8-6746-48c9-b6cb-63c7b447eae6	2026-08-27 12:49	2026-08-27 12:49	2026-08-27 12:49	SPXW	SPXW260930C07500000	call	7500.0000	2026-09-30	298.4300	287.8000	302.2000	7736.1300	2984250.00	1219560.00	1764690.00	100	5	137	4419	0.0310024892509618	0.133127818068974	0.13696493965804	false	false	false	true	false
7f64d1cc-783a-435b-ab5f-33b2e8b123c1	2026-08-27 12:50	2026-08-27 12:50	2026-08-27 12:50	SPXW	SPXW261030C08250000	call	8250.0000	2026-10-30	19.8800	19.4000	21.7000	7734.1800	182870.00	174830.00	8040.00	92	8	1104	240	4.6	0.112360213792868	0.112838726058708	false	false	false	true	false
4348cdcd-d41e-42cf-9d78-24d60545a6ce	2026-08-27 13:00	2026-08-27 13:00	2026-08-27 13:00	SPXW	SPXW260901P07725000	put	7725.0000	2026-09-01	27.5000	27.4000	27.8000	7738.7000	382250.00	0.00	382250.00	139	7	422	214	1.97196261682243	0.0987811473946667	0.0987811473946667	false	false	false	true	false
78dcc4ec-7fd6-4f6c-ba32-1128d20565d6	2026-08-27 13:04	2026-08-27 13:04	2026-08-27 13:04	SPXW	SPXW260901P07740000	put	7740.0000	2026-09-01	33.6000	33.5000	33.8000	7738.2800	332640.00	137760.00	194880.00	99	7	252	186	1.35483870967742	0.0961381826087181	0.0961381826087181	false	false	false	true	false
d3fb249e-35bc-4994-b697-7eb307096c30	2026-08-27 13:07	2026-08-27 13:07	2026-08-27 13:07	SPXW	SPXW260828P07580000	put	7580.0000	2026-08-28	0.6900	0.7000	0.8000	7735.7200	207000.00	0.00	0.00	3000	10	4838	3910	1.23734015345269	0.196416028329171	0.196416028329171	false	false	false	true	false
cc1233c2-598a-4e59-bef3-a48f6e3ab380	2026-08-27 13:07	2026-08-27 13:07	2026-08-27 13:07	SPXW	SPXW260828P07550000	put	7550.0000	2026-08-28	0.4900	0.4500	0.5000	7735.7200	102900.00	0.00	0.00	2100	10	6961	6570	1.05951293759513	0.216977670360544	0.216977670360544	false	false	false	true	false
c8f87128-83ae-44a7-baa4-1a5949f46d79	2026-08-27 13:07	2026-08-27 13:07	2026-08-27 13:07	SPXW	SPXW260828P07640000	put	7640.0000	2026-08-28	2.3600	2.4500	2.5500	7735.7200	708000.00	0.00	0.00	3000	10	5572	2192	2.54197080291971	0.168499373180437	0.168499373180437	false	false	false	true	false
8136ba7e-5206-427f-81fb-78760c487385	2026-08-27 13:07	2026-08-27 13:07	2026-08-27 13:07	SPXW	SPXW260828P07620000	put	7620.0000	2026-08-28	1.5100	1.5500	1.6500	7735.7200	317100.00	0.00	0.00	2100	10	3977	936	4.24893162393162	0.176994359611478	0.176994359611478	false	false	false	true	false
6341a829-caeb-485a-8faa-e60aa4bb85a8	2026-08-27 13:07	2026-08-27 13:07	2026-08-27 13:07	SPXW	SPXW260828C07770000	call	7770.0000	2026-08-28	9.6800	8.7000	8.9000	7735.7200	193600.00	0.00	0.00	200	10	2195	1990	1.10301507537688	0.139472044404667	0.139472044404667	false	false	false	true	false
385b03dd-ba23-4e6d-ac95-8aceb818146c	2026-08-27 13:08	2026-08-27 13:08	2026-08-27 13:08	SPXW	SPXW260901P07740000	put	7740.0000	2026-09-01	33.0000	32.9000	33.2000	7739.7200	161700.00	135300.00	26400.00	49	6	460	186	2.47311827956989	0.096406724867186	0.096406724867186	false	false	false	true	false
a80bf50b-c258-4b2b-9d4b-a411c48653f9	2026-08-27 13:08	2026-08-27 13:08	2026-08-27 13:08	SPXW	SPXW260828P07730000	put	7730.0000	2026-08-28	17.6000	17.5000	17.8000	7739.4400	190080.00	133760.00	56320.00	108	11	2159	423	5.10401891252955	0.138384405543363	0.138384405543363	false	false	false	true	false
21e0cfc9-0c35-484e-b9db-c4f1f0e0d1ac	2026-08-27 13:10	2026-08-27 13:10	2026-08-27 13:10	SPXW	SPXW260901P07740000	put	7740.0000	2026-09-01	32.7000	32.6000	32.9000	7740.4500	225630.00	137340.00	88290.00	69	5	661	186	3.55376344086022	0.0965445023375923	0.0965445023375923	false	false	false	true	false
86e5772d-4f15-4bdd-9089-17f206a3b946	2026-08-27 13:10	2026-08-27 13:10	2026-08-27 13:10	SPXW	SPXW260828P07735000	put	7735.0000	2026-08-28	19.0000	18.9000	19.1000	7740.5500	131100.00	0.00	110200.00	69	19	1053	226	4.65929203539823	0.136362762486842	0.136362762486842	false	false	false	true	false
74e99a28-0510-4eef-b0b1-4b8df8992b91	2026-08-27 13:10	2026-08-27 13:10	2026-08-27 13:10	SPXW	SPXW260828C07770000	call	7770.0000	2026-08-28	10.5000	10.4000	10.7000	7740.9700	157500.00	0.00	157500.00	150	16	2370	1990	1.19095477386935	0.134381239225416	0.134381239225416	false	false	false	true	false
23631978-b55e-454f-aee9-ef4dfedfb95d	2026-08-27 13:12	2026-08-27 13:12	2026-08-27 13:12	SPXW	SPXW260901P07740000	put	7740.0000	2026-09-01	33.1000	32.9000	33.2000	7740.1200	327690.00	59580.00	268110.00	99	9	763	186	4.10215053763441	0.0972155984968467	0.0972155984968467	false	false	false	true	false
d80a7107-69fd-4176-8549-7807efc9b4db	2026-08-27 13:16	2026-08-27 13:16	2026-08-27 13:16	SPXW	SPXW260827P07740000	put	7740.0000	2026-08-27	6.1000	6.0000	6.2000	7739.0900	111020.00	71370.00	13420.00	182	31	14155	149	95	0.104359434413784	0.104359434413784	false	false	false	true	false
c3c07e0e-173e-4535-a0c1-3a5f211e1652	2026-08-27 13:18	2026-08-27 13:18	2026-08-27 13:18	SPXW	SPXW260901P07740000	put	7740.0000	2026-09-01	33.9900	33.7000	34.1000	7738.4000	339870.00	339870.00	0.00	100	14	969	186	5.20967741935484	0.0971307407841332	0.0974076496712154	false	false	false	true	false
7596421d-a09a-44ff-a9b3-3c983ddf0281	2026-08-27 13:29	2026-08-27 13:29	2026-08-27 13:29	SPXW	SPXW260901P07740000	put	7740.0000	2026-09-01	35.2000	34.9000	35.3000	7735.6200	352000.00	42240.00	309760.00	100	11	1192	186	6.40860215053763	0.096934514006801	0.096934514006801	false	false	false	true	false
9451d833-6e1b-4ce7-a234-9e74053ab7e9	2026-08-27 13:32	2026-08-27 13:32	2026-08-27 13:32	SPXW	SPXW260930C07825000	call	7825.0000	2026-09-30	76.8000	77.6000	77.9000	7737.1500	15360000.00	0.00	0.00	2000	10	2289	447	5.12080536912752	0.110124370399077	0.110124370399077	false	false	false	true	false
5c7c01d3-7f70-4628-9fa8-df78b0432625	2026-08-27 13:37	2026-08-27 13:37	2026-08-27 13:37	SPXW	SPXW260828P07730000	put	7730.0000	2026-08-28	19.0000	18.9000	19.2000	7736.2300	190000.00	0.00	161500.00	100	16	2756	423	6.51536643026005	0.138361227047649	0.138361227047649	false	false	false	true	false
c15be48e-b4de-40b1-8784-154d559dea4e	2026-08-27 13:44	2026-08-27 13:44	2026-08-27 13:44	SPXW	SPXW260831C07700000	call	7700.0000	2026-08-31	53.6000	53.5000	54.3000	7735.1200	134000.00	101840.00	32160.00	25	6	4399	6004	0.732678214523651	0.0953335081918945	0.0953335081918945	false	false	false	true	false
d9a35d2e-1365-4eb0-9d6b-88a990cd7e3f	2026-08-27 13:45	2026-08-27 13:45	2026-08-27 13:45	SPXW	SPXW260911P07700000	put	7700.0000	2026-09-11	49.5000	50.7000	51.0000	7733.6100	534600.00	0.00	0.00	108	7	525	2154	0.243732590529248	0.112144092311945	0.112144092311945	false	false	false	true	false
6332771b-b29b-4726-9bbd-d5e72644e148	2026-08-27 13:45	2026-08-27 13:45	2026-08-27 13:45	SPXW	SPXW260911C07700000	call	7700.0000	2026-09-11	96.0000	93.2000	93.6000	7733.6100	2572800.00	0.00	0.00	268	7	364	2140	0.170093457943925	0.113699171787012	0.113699171787012	false	false	false	true	false
5ac672d9-0ab0-4597-83b5-e1581ebaf45e	2026-08-27 13:45	2026-08-27 13:45	2026-08-27 13:45	SPXW	SPXW260904P07600000	put	7600.0000	2026-09-04	13.2000	13.6000	13.8000	7733.6100	195360.00	0.00	0.00	148	7	1042	2644	0.39409984871407	0.128838823017452	0.128838823017452	false	false	false	true	false
d1796438-f1d2-4f18-89c2-6611c9aafaca	2026-08-27 13:46	2026-08-27 13:46	2026-08-27 13:46	SPXW	SPXW260901P07740000	put	7740.0000	2026-09-01	36.4000	36.3000	36.7000	7733.0000	364000.00	309400.00	54600.00	100	11	1694	186	9.10752688172043	0.0965906284043598	0.0965906284043598	false	false	false	true	false
71cfd5f4-4c0d-45a9-b5ff-8b948daacfdc	2026-08-27 13:48	2026-08-27 13:47	2026-08-27 13:47	SPXW	SPXW260911P07655000	put	7655.0000	2026-09-11	38.2000	37.8000	38.3000	7732.5000	106960.00	106960.00	0.00	28	5	75	99	0.757575757575758	0.119858584071337	0.119858584071337	false	false	false	true	false
6cb0f93b-f175-4385-b786-f17d4edbecf8	2026-08-27 13:48	2026-08-27 13:48	2026-08-27 13:48	SPXW	SPXW260901C07735000	call	7735.0000	2026-09-01	33.6000	33.5000	33.9000	7731.5000	336000.00	228480.00	107520.00	100	12	302	93	3.24731182795699	0.0923771175991391	0.0923771175991391	false	false	false	true	false
44869b00-2dd3-4ed9-9fb4-147ffbb6e5d4	2026-08-27 13:49	2026-08-27 13:48	2026-08-27 13:48	SPXW	SPXW260901P07735000	put	7735.0000	2026-09-01	34.6000	34.3000	34.7000	7731.6000	346000.00	58820.00	287180.00	100	8	159	41	3.8780487804878	0.096681312110075	0.096681312110075	false	false	false	true	false
7e014936-7384-4b33-a095-7a66f5b66832	2026-08-27 13:53	2026-08-27 13:53	2026-08-27 13:53	SPXW	SPXW260901P07735000	put	7735.0000	2026-09-01	34.9000	34.8000	35.1000	7731.3800	254770.00	10470.00	244300.00	73	8	265	41	6.46341463414634	0.0972104054401796	0.0972104054401796	false	false	false	true	false
8c1f05a5-9930-45fa-83b4-0a2720913235	2026-08-27 13:53	2026-08-27 13:53	2026-08-27 13:53	SPXW	SPXW260827P07735000	put	7735.0000	2026-08-27	7.3500	7.3000	7.6000	7730.9500	132230.00	0.00	103370.00	180	27	41077	2113	19.4401325130147	0.107756298198754	0.105835057182517	true	false	false	true	false
a38586b6-1114-4c71-998c-5816e56ad7d6	2026-08-27 13:57	2026-08-27 13:57	2026-08-27 13:57	SPXW	SPXW260827C07735000	call	7735.0000	2026-08-27	3.8000	3.6000	3.9000	7732.5700	113550.00	47050.00	66500.00	299	42	109906	3669	29.9553011719815	0.101487972219159	0.103647970496039	false	false	false	true	false
3acfe46a-55a6-4853-9721-7e5d5381f070	2026-08-27 13:59	2026-08-27 13:58	2026-08-27 13:58	SPXW	SPXW260901P07620000	put	7620.0000	2026-09-01	7.2000	7.1000	7.4000	7730.2800	216000.00	166320.00	49680.00	300	14	531	416	1.27644230769231	0.116008704519311	0.116008704519311	false	false	false	true	false
f7f4d333-77d0-4d45-a7d9-154fc3f379ea	2026-08-27 14:01	2026-08-27 14:01	2026-08-27 14:01	SPXW	SPXW260827P07730000	put	7730.0000	2026-08-27	6.4100	6.2000	6.5000	7729.0500	153080.00	79580.00	41580.00	239	84	55084	148	372.189189189189	0.128619209050155	0.128353863958089	true	false	false	true	false
f5b8bf7e-0854-41c1-abaa-37b827b0fa90	2026-08-27 14:01	2026-08-27 14:01	2026-08-27 14:01	SPXW	SPXW260901C07735000	call	7735.0000	2026-09-01	31.6600	31.5000	32.0000	7728.0600	316610.00	0.00	316610.00	100	18	514	93	5.52688172043011	0.0921205384615797	0.091566033071159	false	false	false	true	false
43c93f4d-1dc6-4adb-858f-3e9ecc16becf	2026-08-27 14:01	2026-08-27 14:01	2026-08-27 14:01	SPXW	SPXW260827P07730000	put	7730.0000	2026-08-27	6.3400	6.2000	6.5000	7728.3700	124260.00	32760.00	87660.00	196	41	55803	148	377.047297297297	0.120621022499887	0.118446763028448	false	false	false	true	false