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: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

0fd4220f-3328-4071-962e-16bbbe8d805c	2026-08-31 13:04	2026-08-31 13:04	2026-08-31 13:04	SPXW	SPXW260903C07750000	call	7750.0000	2026-09-03	4.8800	4.7000	5.1000	7674.3200	122120.00	0.00	115620.00	250	28	533	394	1.35279187817259	0.0980221600108816	0.0967430434997422	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-31T17:08:52.274087Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
1902bb46-afac-4096-90c8-53fcf3606778	2026-08-31 13:05	2026-08-31 13:05	2026-08-31 13:05	SPXW	SPXW260901C07705000	call	7705.0000	2026-09-01	6.1000	6.0000	6.2000	7675.5200	122000.00	44530.00	77470.00	200	20	1260	312	4.03846153846154	0.10371927135323	0.10371927135323	false	false	false	true	false
bdf4bfd9-6957-48de-be58-77156d354803	2026-08-31 13:16	2026-08-31 13:15	2026-08-31 13:15	SPXW	SPXW260918P07700000	put	7700.0000	2026-09-18	85.0000	85.0000	85.2000	7676.8300	629000.00	0.00	629000.00	74	7	1254	1049	1.1954242135367	0.118401699629446	0.118484521576428	false	false	false	true	false
1d5fbc1c-882c-40db-a188-0587f4566314	2026-08-31 13:16	2026-08-31 13:16	2026-08-31 13:16	SPXW	SPXW260902C07680000	call	7680.0000	2026-09-02	22.5000	22.2000	22.6000	7677.5400	225000.00	150750.00	74250.00	100	14	517	277	1.86642599277978	0.101084383506141	0.101084383506141	false	false	false	true	false
b78c9da0-60e8-44d0-bebf-e89cabbf16cf	2026-08-31 13:17	2026-08-31 13:17	2026-08-31 13:17	SPXW	SPXW260902P07585000	put	7585.0000	2026-09-02	3.6000	3.4000	3.6000	7677.9800	100800.00	100800.00	0.00	280	14	919	117	7.85470085470085	0.131716781642029	0.131716781642029	true	false	false	true	false
38b686cd-a160-4ce9-b03b-ed8f7f66d123	2026-08-31 13:18	2026-08-31 13:18	2026-08-31 13:18	SPXW	SPXW260930P07550000	put	7550.0000	2026-09-30	60.0000	59.7000	60.2000	7676.8200	3180000.00	2040000.00	978000.00	530	10	704	3606	0.195230171935663	0.138780619598541	0.138780619598541	false	false	false	true	false
883d26fe-66cc-4ac5-af16-387bc00343df	2026-08-31 13:21	2026-08-31 13:21	2026-08-31 13:21	SPXW	SPXW260831P07675000	put	7675.0000	2026-08-31	6.2000	6.1000	6.3000	7675.2700	124000.00	97340.00	26660.00	200	37	64168	2190	29.3004566210046	0.120072467354695	0.120072467354695	false	false	false	true	false
f636c7d2-09aa-4ac3-bae6-9d9a355cbf12	2026-08-31 13:31	2026-08-31 13:31	2026-08-31 13:31	SPXW	SPXW260901C07680000	call	7680.0000	2026-09-01	13.2000	13.1000	13.2000	7670.0200	162360.00	162360.00	0.00	123	9	4410	101	43.6633663366337	0.108592286049469	0.108592286049469	false	false	false	true	false
460ed25a-bc64-4622-9ea6-1fe215183643	2026-08-31 13:32	2026-08-31 13:32	2026-08-31 13:32	SPXW	SPXW260831P07705000	put	7705.0000	2026-08-31	34.0000	34.0000	34.2000	7671.3800	122400.00	0.00	122400.00	36	6	2433	930	2.61612903225806	0.161179037852532	0.161179037852532	false	false	false	true	false
33d85759-7ff5-4ef0-8cab-7a7b6b72b1fe	2026-08-31 13:46	2026-08-31 13:45	2026-08-31 13:45	SPXW	SPXW260918C07800000	call	7800.0000	2026-09-18	30.5000	30.2000	30.5000	7660.0000	115900.00	115900.00	0.00	38	7	366	4298	0.0851558864588181	0.103694862059762	0.103694862059762	false	false	false	true	false
14596059-4c2f-46a0-90c7-aecc1677a9ce	2026-08-31 13:46	2026-08-31 13:46	2026-08-31 13:46	SPXW	SPXW260901C07675000	call	7675.0000	2026-09-01	20.0500	19.9000	20.4000	7660.0000	376950.00	136000.00	240950.00	188	31	7477	343	21.798833819242	0.106532952442471	0.105273253982155	false	false	false	true	false
c2b1921d-7fde-481c-9c86-2f205e53b13d	2026-08-31 13:46	2026-08-31 13:46	2026-08-31 13:46	SPXW	SPXW260901C07675000	call	7675.0000	2026-09-01	19.9000	19.8000	20.1000	7660.0000	398000.00	288550.00	109450.00	200	18	7677	343	22.3819241982507	0.104713464257527	0.104713464257527	false	false	false	true	false
40afde54-0045-4c0b-aea3-c4be2b94f955	2026-08-31 13:50	2026-08-31 13:50	2026-08-31 13:50	SPXW	SPXW260904C07680000	call	7680.0000	2026-09-04	40.4000	40.2000	40.4000	7660.0000	121200.00	121200.00	0.00	30	9	1684	349	4.82521489971347	0.11494337892993	0.11494337892993	true	false	false	true	false
3c8883de-ec38-46dc-b5e8-049423b9866e	2026-08-31 13:50	2026-08-31 13:50	2026-08-31 13:50	SPXW	SPXW260904C07680000	call	7680.0000	2026-09-04	40.6000	40.4000	40.6000	7660.0000	101500.00	101500.00	0.00	25	7	1739	349	4.98280802292264	0.115568641309528	0.115568641309528	true	false	false	true	false
713fc0f9-4b52-4710-804c-28bdc4e60126	2026-08-31 13:53	2026-08-31 13:53	2026-08-31 13:53	SPXW	SPXW260831C07680000	call	7680.0000	2026-08-31	9.5000	9.4000	9.6000	7665.0000	112100.00	5700.00	0.00	118	6	96286	384	250.744791666667	0.146545478223053	0.146545478223053	false	false	false	true	false
608a111e-a942-4e8c-ad5e-bd4fb4884a0a	2026-08-31 14:00	2026-08-31 14:00	2026-08-31 14:00	SPXW	SPXW260901P07680000	put	7680.0000	2026-09-01	16.3000	16.1000	16.6000	7660.0000	187450.00	91280.00	96170.00	115	11	3238	363	8.92011019283747	0.109630960179056	0.109630960179056	false	false	false	true	false
0111aab2-ea3c-4421-9064-c8b557cf9322	2026-08-31 14:00	2026-08-31 14:00	2026-08-31 14:00	SPXW	SPXW260902P07680000	put	7680.0000	2026-09-02	22.0000	21.9000	22.0000	7660.0000	103400.00	103400.00	0.00	47	7	430	197	2.18274111675127	0.105968486541362	0.105968486541362	false	false	false	true	false
92bb7d69-4d24-4b66-8e95-b0cab27b7fd5	2026-08-31 14:10	2026-08-31 14:10	2026-08-31 14:10	SPXW	SPXW260901P07680000	put	7680.0000	2026-09-01	15.9000	15.7000	16.0000	7660.0000	198750.00	119250.00	79500.00	125	13	3713	363	10.228650137741	0.110945273067596	0.110945273067596	true	false	false	true	false
c7be759c-7102-4df6-9d2d-10074edf55f1	2026-08-31 14:20	2026-08-31 14:20	2026-08-31 14:20	SPXW	SPXW260901C07685000	call	7685.0000	2026-09-01	17.3000	17.2000	17.4000	7665.0000	193760.00	50170.00	0.00	112	7	3460	63	54.9206349206349	0.103519082867703	0.103519082867703	false	false	false	true	false
d48a15cb-eac7-4e57-9627-dc6369d0790a	2026-08-31 14:25	2026-08-31 14:25	2026-08-31 14:25	SPXW	SPXW260903C07750000	call	7750.0000	2026-09-03	5.9700	5.9000	6.2000	7683.4100	149360.00	0.00	149360.00	250	20	1068	394	2.71065989847716	0.0955013663956417	0.0949315440971185	false	false	false	true	false
2cb9c9e3-d5cb-47e3-b251-d47d668d6c4a	2026-08-31 14:26	2026-08-31 14:26	2026-08-31 14:26	SPXW	SPXW260831P07680000	put	7680.0000	2026-08-31	4.8400	4.8000	5.0000	7680.6000	123400.00	0.00	111640.00	255	59	72882	1920	37.959375	0.127817733361009	0.125365873911389	true	false	false	true	false
fe73c84a-5749-481e-b6cc-1643997c82a4	2026-08-31 14:34	2026-08-31 14:33	2026-08-31 14:33	SPXW	SPXW260831P07705000	put	7705.0000	2026-08-31	25.5000	25.2000	25.5000	7679.9200	127500.00	127500.00	0.00	50	7	3240	930	3.48387096774194	0.167816324338006	0.167816324338006	false	false	false	true	false
23d9e42c-7a73-4252-8c8c-7ebbd7300da0	2026-08-31 14:34	2026-08-31 14:34	2026-08-31 14:34	SPXW	SPXW260903C07750000	call	7750.0000	2026-09-03	5.3000	5.3000	5.5000	7679.0800	132500.00	0.00	132500.00	250	11	1326	394	3.36548223350254	0.0954973299027803	0.0954973299027803	false	false	false	true	false
ba201953-b88e-437b-9d11-39ea3740e49c	2026-08-31 14:34	2026-08-31 14:34	2026-08-31 14:34	SPXW	SPXW260901P07680000	put	7680.0000	2026-09-01	18.0000	17.9000	18.0000	7678.4000	203400.00	203400.00	0.00	113	15	4498	363	12.3911845730028	0.109770190692837	0.109770190692837	false	false	false	true	false
d0217407-760c-4d0a-a8b0-5660594a079b	2026-08-31 14:35	2026-08-31 14:35	2026-08-31 14:35	SPXW	SPXW260831P07675000	put	7675.0000	2026-08-31	3.8100	3.6000	3.9000	7677.3800	104770.00	95880.00	7030.00	275	58	93003	2190	42.4671232876712	0.126391517097175	0.129010359806337	false	false	false	true	false
60f42129-eed9-4610-a8ae-a4b4254fe5fe	2026-08-31 14:35	2026-08-31 14:35	2026-08-31 14:35	SPXW	SPXW260831P07675000	put	7675.0000	2026-08-31	3.8000	3.7000	3.9000	7677.8200	147440.00	117040.00	0.00	388	26	93823	2190	42.8415525114155	0.132991390888411	0.131370008068032	false	false	false	true	false
3b27bf7e-0fe7-4d41-a52f-97e9b57fdbab	2026-08-31 14:36	2026-08-31 14:35	2026-08-31 14:35	SPXW	SPXW260831P07680000	put	7680.0000	2026-08-31	7.5900	7.3000	7.7000	7676.2300	282470.00	36310.00	243200.00	372	38	79400	1920	41.3541666666667	0.137627496376107	0.142985002581432	false	false	false	true	false
7ee3db94-5fea-45a4-9c38-6d8487cdfa56	2026-08-31 14:36	2026-08-31 14:35	2026-08-31 14:35	SPXW	SPXW260831P07670000	put	7670.0000	2026-08-31	3.4600	3.2000	3.6000	7675.6600	147030.00	89010.00	57670.00	425	178	110915	1788	62.0329977628635	0.148006374200092	0.152967344743328	false	false	false	true	false
ecd18c13-872a-486a-91cd-2e817cc8b891	2026-08-31 14:36	2026-08-31 14:36	2026-08-31 14:36	SPXW	SPXW260831P07705000	put	7705.0000	2026-08-31	30.7000	30.6000	31.0000	7674.7200	153500.00	113590.00	39910.00	50	7	3370	930	3.62365591397849	0.19768846552278	0.19768846552278	false	false	false	true	false
7e168a1d-92a1-44f1-a1f3-9e54fb580dd9	2026-08-31 14:38	2026-08-31 14:37	2026-08-31 14:37	SPXW	SPXW260904C07705000	call	7705.0000	2026-09-04	23.2000	23.0000	23.3000	7674.2600	116000.00	116000.00	0.00	50	10	176	331	0.531722054380665	0.109806659118391	0.109806659118391	false	false	false	true	false
b716f113-c6ff-46bd-9dd5-98e2afc9f6b6	2026-08-31 14:38	2026-08-31 14:38	2026-08-31 14:38	SPXW	SPXW260831P07665000	put	7665.0000	2026-08-31	2.8600	2.6000	3.0000	7673.4500	108300.00	47925.00	58935.00	379	177	81750	993	82.3262839879154	0.161166295682344	0.162282923218387	false	false	false	true	false
ac1936a6-f87c-42b3-b111-98dd8fa95325	2026-08-31 14:38	2026-08-31 14:38	2026-08-31 14:38	SPXW	SPXW260831P07675000	put	7675.0000	2026-08-31	7.1100	6.9000	7.2000	7672.3700	104560.00	103860.00	0.00	147	22	99211	2190	45.3018264840183	0.147432608952461	0.152771727068279	false	false	false	true	false
f63dea49-ce9f-4f0e-ab72-4587488fee58	2026-08-31 14:38	2026-08-31 14:38	2026-08-31 14:38	SPXW	SPXW260831P07670000	put	7670.0000	2026-08-31	5.8900	5.6000	6.2000	7671.4000	136060.00	133190.00	2270.00	231	173	115248	1788	64.4563758389262	0.168194312914548	0.170834217248291	false	false	false	true	false
6d4c34ca-c8a8-4521-b36a-616a7e5aadf6	2026-08-31 14:39	2026-08-31 14:38	2026-08-31 14:38	SPXW	SPXW260903C07585000	call	7585.0000	2026-09-03	94.9300	90.8000	99.3000	7671.0600	189850.00	142500.00	47350.00	20	5	181	81	2.23456790123457	0.121021258459078	0.122906535916125	false	false	false	true	false
12efd27e-b46f-4417-a586-3f670c5d0fef	2026-08-31 14:39	2026-08-31 14:39	2026-08-31 14:39	SPXW	SPXW260831P07705000	put	7705.0000	2026-08-31	32.8000	32.6000	33.1000	7672.6000	164000.00	65600.00	98400.00	50	8	3490	930	3.75268817204301	0.210310774664785	0.210310774664785	false	false	false	true	false
0423fba3-cad0-42b8-b00a-11d3dd2f7b59	2026-08-31 14:41	2026-08-31 14:41	2026-08-31 14:41	SPXW	SPXW260831P07680000	put	7680.0000	2026-08-31	10.3000	10.2000	10.5000	7672.9100	186450.00	78300.00	108150.00	181	12	82611	1920	43.0265625	0.164330454827537	0.170247160392367	false	false	false	true	false
8b49d05a-57d8-4f83-86f4-66f22c44b3e8	2026-08-31 14:43	2026-08-31 14:43	2026-08-31 14:43	SPXW	SPXW260911P07675000	put	7675.0000	2026-09-11	57.2000	56.8000	57.2000	7669.7800	211640.00	211640.00	0.00	37	6	294	2226	0.132075471698113	0.1111209266837	0.1111209266837	false	false	false	true	false
3c644b16-1176-440a-a488-3dbb5f32b110	2026-08-31 14:48	2026-08-31 14:48	2026-08-31 14:48	SPXW	SPXW260918P07600000	put	7600.0000	2026-09-18	52.3700	52.0000	52.5000	7671.6300	261860.00	261860.00	0.00	50	6	563	3423	0.164475606193398	0.131327768957996	0.131487217672198	false	false	false	true	false
5a7f5859-e900-4823-b833-98bc2c79e235	2026-08-31 14:52	2026-08-31 14:52	2026-08-31 14:52	SPXW	SPXW260918P07600000	put	7600.0000	2026-09-18	52.3000	52.0000	52.4000	7671.8500	261500.00	261500.00	0.00	50	5	613	3423	0.179082676015191	0.131448474261178	0.131448474261178	false	false	false	true	false
303bea57-7216-452e-9459-de5862068c06	2026-08-31 14:56	2026-08-31 14:56	2026-08-31 14:56	SPXW	SPXW260903C07585000	call	7585.0000	2026-09-03	98.1000	97.3000	98.4000	7674.4100	147150.00	147150.00	0.00	15	7	203	81	2.50617283950617	0.124388641207862	0.124388641207862	false	false	false	true	false
a5fa2ced-bc49-45d3-a8f9-40f332d4871a	2026-08-31 15:02	2026-08-31 15:02	2026-08-31 15:02	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	6.0300	5.9000	6.2000	7677.2300	129000.00	31200.00	97800.00	214	47	101439	734	138.200272479564	0.152984497366272	0.149798310501848	false	false	false	true	false
9918030f-2c65-4fbf-86f5-a275b069f6ff	2026-08-31 15:06	2026-08-31 15:06	2026-08-31 15:06	SPXW	SPXW260902P07630000	put	7630.0000	2026-09-02	9.0500	9.0000	9.3000	7674.4400	144820.00	0.00	144820.00	160	18	698	466	1.49785407725322	0.114445567973657	0.11387526176062	false	false	false	true	false
15cd83f2-5fd9-46be-ad87-3ce5f3438f98	2026-08-31 15:21	2026-08-31 15:20	2026-08-31 15:20	SPXW	SPXW260930P06500000	put	6500.0000	2026-09-30	4.8500	4.8000	4.9000	7677.8400	2910000.00	0.00	0.00	6000	14	6025	11501	0.523867489783497	0.293832769439584	0.293832769439584	false	false	false	true	false
84ffbca8-f515-4a3e-a500-e6ed56650245	2026-08-31 15:22	2026-08-31 15:21	2026-08-31 15:21	SPXW	SPXW260831P07690000	put	7690.0000	2026-08-31	13.0000	12.9000	13.0000	7677.6700	118300.00	118300.00	0.00	91	9	19252	1258	15.3036565977742	0.165501110215632	0.165501110215632	false	false	false	true	false
3507eb25-b80e-4f9b-be7e-f8ab0ee80189	2026-08-31 15:24	2026-08-31 15:23	2026-08-31 15:23	SPXW	SPXW260902C07670000	call	7670.0000	2026-09-02	29.5000	29.3000	29.6000	7680.6400	295000.00	295000.00	0.00	100	7	825	52	15.8653846153846	0.100832618479493	0.100832618479493	false	false	false	true	false
c75d933d-f34a-4643-ac37-b97ef54c4609	2026-08-31 15:27	2026-08-31 15:26	2026-08-31 15:26	SPXW	SPXW260831C07680000	call	7680.0000	2026-08-31	5.1800	5.1000	5.4000	7681.5900	104050.00	0.00	91570.00	201	39	146852	384	382.427083333333	0.178645975740721	0.174491624476794	true	false	false	true	false
217dc244-7f7e-4889-ad98-6ebf05cf93d0	2026-08-31 15:28	2026-08-31 15:28	2026-08-31 15:28	SPXW	SPXW260831P07690000	put	7690.0000	2026-08-31	8.2800	8.1000	8.4000	7683.4100	113460.00	74520.00	33200.00	137	59	20057	1258	15.9435612082671	0.173449075428059	0.178602786763524	true	false	false	true	false
c21be839-8372-4854-b16a-5893f25055e8	2026-08-31 15:33	2026-08-31 15:33	2026-08-31 15:33	SPXW	SPXW260903C07715000	call	7715.0000	2026-09-03	14.3000	14.2000	14.5000	7679.9700	118690.00	0.00	118690.00	83	10	246	358	0.687150837988827	0.0991122802900408	0.0991122802900408	true	false	false	true	false
410890d8-412a-4ea2-854d-ee17a3028b61	2026-08-31 15:41	2026-08-31 15:41	2026-08-31 15:41	SPXW	SPXW260901P07680000	put	7680.0000	2026-09-01	14.0000	14.0000	14.1000	7684.2900	134400.00	0.00	134400.00	96	9	6104	363	16.8154269972452	0.102384695745415	0.102384695745415	false	false	false	true	false
45114eda-4cd3-4c9a-999c-42ebe946bd06	2026-08-31 15:42	2026-08-31 15:42	2026-08-31 15:42	SPXW	SPXW260901P07680000	put	7680.0000	2026-09-01	14.0000	13.9000	14.1000	7684.7300	279980.00	0.00	279980.00	200	6	6336	363	17.4545454545455	0.103623325032539	0.102994361662446	false	false	false	true	false