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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 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 = 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

1e6b49df-f3fa-4599-b1d6-6fae19b3293c	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	2.2000	2.1000	2.4000	7670.0700	10765.00	2990.00	7775.00	49	12	113800	266	427.81954887218	0.241436847042883	0.230768732598545	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-29T19:57:26.018295Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
15ac9ae8-b55d-4d3a-b2a2-7ae1607a4c6c	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.8900	1.7500	2.0500	7670.0700	21525.00	13690.00	6515.00	114	50	118025	1317	89.6165527714503	0.140731713478104	0.2065419928837	false	false	false
10f15825-c096-4166-b5b3-db7190b99b29	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.9500	1.7000	2.2000	7670.0300	10325.00	4500.00	5825.00	53	38	118135	1317	89.7000759301443	0.215458789903107	0.194087716888121	false	false	false
90b36e0c-70a4-497c-8e67-2574a9fa506a	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.9500	1.6000	2.0000	7667.5800	24230.00	20955.00	3275.00	124	36	117842	1317	89.4776006074412	0	0	true	false	false	true
65c9a10f-e89b-4fa6-baf8-3fe02c680fa7	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.7100	0.6000	2.0000	7667.5800	41505.00	35595.00	5550.00	243	78	117655	1317	89.3356112376614	0.34103929062357	0	false	false	false	true
3d5a2a6f-ca34-44fd-a901-9efe3e604e6e	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	4.9100	4.6000	5.3000	7669.1300	11300.00	10300.00	1000.00	23	18	86421	1977	43.7132018209408	0	0	false	false	false	true
f3009cd2-87ea-4bc8-8430-4bbbdce016c0	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	3.9400	2.1500	4.5000	7675.0500	40930.00	40930.00	0.00	104	36	86224	1977	43.6135558927668	0.314466879870885	0.458122832073339	false	false	false
d1e43fd8-1c95-4a5d-8791-8c46a55f37da	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	SPXW	SPXW260929P07680000	put	7680.0000	2026-09-29	7.7300	4.8000	10.0000	7675.0500	21650.00	19940.00	1710.00	28	15	62898	1535	40.9758957654723	0.239662074034718	0.62448104202165	false	false	false
cfd05e12-fd4e-412d-904b-e781d5444e1d	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	2.3000	1.9500	2.5000	7674.7400	10815.00	10815.00	0.00	47	36	86011	1977	43.5058168942843	0.208479963207033	0.250884393253865	false	false	false
7ce905c7-ef38-4fe0-a6cb-c4d3dbadf67f	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	2.5700	2.0000	6.2000	7675.0500	11320.00	0.00	11320.00	44	20	113420	266	426.390977443609	0	0.321042994878372	false	false	false	true
2f705311-d43f-47a0-9dcb-bd963eb55c18	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	SPXW	SPXW260929P07670000	put	7670.0000	2026-09-29	1.0600	0.5500	1.5000	7675.0500	34470.00	34190.00	280.00	325	124	117342	1317	89.0979498861048	0.255945459352434	0.365908659584749	false	false	false
0dc66597-7ed8-4b8b-8295-a7ab76ac78d9	2026-09-29 15:55	2026-09-29 15:54	2026-09-29 15:55	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	1.7700	1.5000	2.3000	7674.7400	13260.00	0.00	13260.00	75	49	135077	1911	70.6839351125065	0.247451059700257	0.172104736342377	false	false	false
e18a0ac0-63e4-4006-bae6-140fa7f7a080	2026-09-29 15:55	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929P07685000	put	7685.0000	2026-09-29	10.1000	10.0000	10.5000	7675.1700	10100.00	0.00	10100.00	10	7	32254	1415	22.7943462897526	0.296744442241475	0.296744442241475	false	false	false
496d2fad-35a9-419c-8030-35f161a9e90c	2026-09-29 15:55	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260930C07670000	call	7670.0000	2026-09-30	24.0000	24.0000	24.3000	7674.6400	60000.00	0.00	60000.00	25	6	4190	316	13.2594936708861	0.131973198966721	0.131973198966721	false	false	false
4929cc09-e4d6-4a1c-89ae-4a1ee7553d34	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	2.4600	2.2000	3.2000	7676.8700	10575.00	3325.00	7250.00	43	26	134568	1911	70.4175824175824	0.159890819342886	0.103685583734597	false	false	false
30b05d9e-cab7-485b-9b94-2e20c85e3442	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	2.1500	1.8500	2.3500	7676.9400	23835.00	7930.00	15905.00	111	58	134703	1911	70.4882260596546	0.0959698202341373	0.0393878637262789	false	false	false
111788c9-31ee-4786-9305-9b4103cbb2fe	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	21.8000	21.6000	21.9000	7676.9400	21800.00	21800.00	0.00	10	7	8166	3758	2.1729643427355	0.127122712334351	0.127122712334351	false	false	false
0847eed9-df31-4ef4-865a-5b7efb46d4e3	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07680000	call	7680.0000	2026-09-29	0.9500	0.9000	1.0000	7676.9600	12540.00	4655.00	7885.00	132	30	163208	720	226.677777777778	0.221417867555232	0.221417867555232	false	false	false
36428c40-c174-4e4e-84d7-a0ce602a3542	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260930C07685000	call	7685.0000	2026-09-30	17.6000	17.5000	17.7000	7676.4300	44000.00	29920.00	0.00	25	5	4264	777	5.48777348777349	0.132418624755865	0.132418624755865	false	false	false
1b196880-4732-4248-938b-4a761d332f0b	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	3.5000	3.4000	3.6000	7676.4300	32880.00	30800.00	2080.00	94	16	134334	1911	70.2951334379906	0.271291202784347	0.281880102878421	false	false	false
c3c5d128-105a-4e37-91f8-b55edf19e875	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07680000	call	7680.0000	2026-09-29	1.0000	0.9500	1.0500	7676.8200	23665.00	22900.00	665.00	237	65	162694	720	225.963888888889	0.271419659480075	0.230178780499047	false	false	false
ea9034de-e5da-411a-992e-61622ad10244	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	2.9900	2.7000	3.1000	7675.4300	20910.00	19780.00	1130.00	70	40	133922	1911	70.0795395081109	0.274545672221479	0.295090338243561	false	false	false
e368586f-5ca8-4104-96d1-bdfe5c12971c	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	2.6800	2.3000	2.8500	7675.4300	14180.00	14180.00	0.00	53	22	133836	1911	70.0345368916797	0.218009137482184	0.269408557245241	false	false	false
9775b029-3030-4465-b21a-b602bf7100e4	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	3.3600	3.0000	3.5000	7675.3700	16130.00	13910.00	2220.00	48	20	134042	1911	70.1423338566196	0.31933854667847	0.298776281357608	true	false	false
83e7c5c4-f759-44fe-9e5e-964c6f52224e	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	1.5900	1.5000	1.9000	7675.4300	13790.00	0.00	13790.00	87	48	85249	1977	43.1203844208397	0.211131586180927	0.175095349790756	false	false	false
4a57d2c1-8f37-4023-ad6e-c8e8587f1903	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07680000	call	7680.0000	2026-09-29	0.7300	0.5500	0.8000	7675.4300	14145.00	14080.00	65.00	194	47	162304	720	225.422222222222	0.221024514342375	0.242310149177347	false	false	false
a7cd41d5-9d65-4e57-a578-3c2dd2e51ed8	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929P07680000	put	7680.0000	2026-09-29	5.0100	4.9000	5.1000	7674.9400	10530.00	1530.00	7000.00	21	9	62467	1535	40.6951140065147	0.114013834383802	0.114013834383802	false	false	false
4a9d29a2-51a2-42a6-aebe-08d780c0e38b	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW261002C07900000	call	7900.0000	2026-10-02	0.7500	0.7000	0.7500	7674.9400	13350.00	13350.00	0.00	178	7	14389	19306	0.745312338133223	0.152094857701993	0.152094857701993	false	false	false
3f380e34-e967-41d7-a8dd-a19e2bf81f69	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	2.4400	2.3000	2.5500	7674.9400	22465.00	19335.00	2645.00	92	53	133277	1911	69.742019884877	0.245704456506348	0.243689762141206	false	false	false
1627c80b-fafc-432d-978e-6c689524eae1	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	6.0000	5.9000	6.0000	7674.7900	15600.00	15600.00	0.00	26	10	112900	266	424.436090225564	0.302403938530114	0.302403938530114	false	false	false
0a93a1bd-0720-4c71-9c7e-7a63f524ba28	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260930P07670000	put	7670.0000	2026-09-30	18.0000	18.0000	18.1000	7674.7900	34200.00	0.00	34200.00	19	5	4245	617	6.88006482982172	0.129194603316449	0.129194603316449	false	false	false
ae7cda4e-b59b-42f9-ad88-d71da0896efa	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	2.2000	2.0500	2.3000	7674.5300	21160.00	21160.00	0.00	96	26	133074	1911	69.6357927786499	0.231353691483193	0.251306295030674	false	false	false
e7f6d4c5-8803-4f46-82b4-201326a691c0	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	5.2000	5.1000	5.3000	7674.6800	10910.00	0.00	10910.00	21	5	112825	266	424.154135338346	0.203873263070348	0.188533844134413	false	false	false
a7664d4b-4ebc-4684-8915-1fee840eb3a9	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	1.9800	1.8500	2.0500	7674.6800	16015.00	0.00	15825.00	81	29	132853	1911	69.5201465201465	0.217739675418076	0.202569803790177	false	false	false
7c2b30d6-2b4a-4d7f-b0ea-50cc47353d94	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	2.1500	2.0000	2.2500	7674.5800	10105.00	9285.00	820.00	47	16	132743	1911	69.4625850340136	0.220795549791252	0.240452154114773	false	false	false
b39177e9-c6d3-408b-95e9-dbb8c8fc4c45	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	2.1900	2.0500	2.3000	7674.5900	10740.00	230.00	10300.00	49	18	84381	1977	42.6813353566009	0.197231214028388	0.182681737751099	false	false	false
6b386cc4-cb99-475c-8e13-9aa1a4b37b4f	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	2.2900	2.1500	2.3500	7674.5900	16465.00	16250.00	215.00	72	43	132587	1911	69.3809523809524	0.231781662719715	0.246312851048931	false	false	false
7f629a8a-ae49-4cb5-8ea6-e6e3e259708a	2026-09-29 15:54	2026-09-29 15:53	2026-09-29 15:53	SPXW	SPXW260930P07675000	put	7675.0000	2026-09-30	20.5000	20.3000	20.6000	7674.6600	61500.00	61500.00	0.00	30	6	4229	4553	0.928838128706347	0.129505654028412	0.129505654028412	false	false	false
aed3f9c8-af36-45cd-8761-bdb2a7a101c6	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	6.0000	5.8000	6.1000	7674.9500	16800.00	3600.00	13200.00	28	8	112612	266	423.353383458647	0.269212099851723	0.269212099851723	false	false	false
714e43c8-8321-47c4-b432-d5a0f9574c04	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	2.2500	2.2000	2.2500	7674.7900	11700.00	11700.00	0.00	52	12	131922	1911	69.032967032967	0.218966913638559	0.218966913638559	false	false	false
57030e7d-ea40-49d4-9f6d-0bc686524f4b	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	2.2500	2.2000	2.3000	7674.7900	11470.00	4950.00	220.00	51	13	131973	1911	69.0596546310832	0.214308409125692	0.218966913638559	false	false	false
ea615d9b-3682-40e8-88b7-3557b46b97d8	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	2.1700	1.9500	2.2500	7674.3100	17330.00	13780.00	2055.00	80	36	131817	1911	68.978021978022	0.220474264711404	0.230144001726008	false	false	false
84000d9b-281e-4eb2-9904-9b08a3528175	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	5.5200	5.4000	5.7000	7674.3100	10490.00	9930.00	0.00	19	10	112504	266	422.947368421053	0.263522514864977	0.274607902542151	false	false	false
d1541ba0-a391-4ba7-969f-19167c2bd348	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	SPXW	SPXW260929C07675000	call	7675.0000	2026-09-29	1.9900	1.8000	2.1000	7673.8700	14740.00	14145.00	205.00	74	34	131711	1911	68.9225536368394	0.213693627308362	0.238150996103191	false	false	false
9a55bbb8-e615-4aaa-be3f-d762eddaf63b	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	SPXW	SPXW260929P07680000	put	7680.0000	2026-09-29	5.9300	5.9000	6.1000	7674.0100	10680.00	0.00	10080.00	18	8	62167	1535	40.499674267101	0.100985036103359	0.100985036103359	false	false	false	true
5cf9371a-7bf4-4b64-96f3-9147cc214856	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	SPXW	SPXW260929P07675000	put	7675.0000	2026-09-29	2.7500	2.7000	2.8000	7673.8800	19505.00	280.00	13725.00	71	15	83414	1977	42.192210419828	0.194869473912762	0.190227946434025	false	false	false
c4c3e1df-ace9-47c5-9dd5-2dab3f5ad7ce	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	SPXW	SPXW260929C07670000	call	7670.0000	2026-09-29	4.8000	4.6000	4.9000	7673.3200	16320.00	15360.00	0.00	34	6	112357	266	422.394736842105	0.254873925928407	0.254873925928407	false	false	false
df441ff6-1b06-4470-bcf4-79588cf60ce0	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	SPXW	SPXW260929P07685000	put	7685.0000	2026-09-29	11.3100	11.3000	11.7000	7673.4800	16960.00	0.00	16960.00	15	5	32098	1415	22.6840989399293	0.26272843093958	0.26272843093958	false	false	false
6cea3057-9fd6-4d7a-a08a-c4e31399b684	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	SPXW	SPXW260930P07665000	put	7665.0000	2026-09-30	16.6000	16.4000	16.6000	7674.4500	76360.00	76360.00	0.00	46	7	2958	875	3.38057142857143	0.133347506855428	0.133347506855428	false	false	false
2609da8a-a126-448b-bff3-e2e241f97fb5	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	SPXW	SPXW260929C07665000	call	7665.0000	2026-09-29	9.0000	8.7000	9.0000	7674.4400	19800.00	19800.00	0.00	22	5	81026	290	279.4	0.12214322413908	0.12214322413908	false	false	false	true