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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×option_symbol = SPXW260930P07700000×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	expiry

b65aaf0c-1a91-4255-b30b-8db2c926face	2026-08-18 10:27	2026-08-18 10:27	2026-08-18 10:27	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	123.3800	123.4000	124.0000	7707.9800	24676000.00	0.00	0.00	2000	10	2013	21599	0.0931987592018149	0.13649732086589	0.13649732086589	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e9edc10a-46d4-4f26-bd7c-9ef2e7da25dd	2026-08-27 10:01	2026-08-27 10:01	2026-08-27 10:01	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	103.4500	103.2000	103.6000	7704.6000	5172500.00	0.00	0.00	500	6	502	21793	0.0230349194695544	0.126775447169356	0.126775447169356	false	false	false
e7eb7c01-604f-4fff-a2cd-8eaa9d3feda6	2026-08-28 11:07	2026-08-28 11:07	2026-08-28 11:07	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	76.8000	76.8000	77.3000	7765.1700	145920.00	0.00	145920.00	19	5	653	22010	0.0296683325761018	0.126313434011145	0.126313434011145	false	false	false
82d1b358-3921-4402-b3ef-f7cbbe3d87fd	2026-09-11 09:44	2026-09-11 09:44	2026-09-11 09:44	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	93.9000	94.2000	94.8000	7667.2500	28170000.00	0.00	0.00	3000	14	3002	8475	0.354218289085546	0.121780412730236	0.121780412730236	false	false	false
35bb8ac7-301f-4f27-967e-dd01aa40497a	2026-09-21 14:50	2026-09-21 14:50	2026-09-21 14:50	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	24.2000	24.1000	24.2000	7750.0000	116160.00	116160.00	0.00	48	6	987	7524	0.131180223285486	0.115270155701815	0.115270155701815	false	false	false
4bbc828a-ed06-4ea2-9ecf-60ff7ef09f74	2026-09-23 10:28	2026-09-23 10:28	2026-09-23 10:28	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	36.2000	36.2000	36.4000	7715.8900	94120.00	0.00	94120.00	26	6	269	8322	0.0323239605863975	0.108682498503886	0.108682498503886	false	false	false
b918890b-ec39-4c94-b999-c8188fa8e2b6	2026-09-23 10:49	2026-09-23 10:49	2026-09-23 10:49	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	33.0000	32.8000	33.0000	7722.2100	498300.00	498300.00	0.00	151	8	574	8322	0.0689738043739486	0.107241271723114	0.107241271723114	false	false	false
971d35ba-197d-4e57-acf9-2728cfdc3c55	2026-09-23 10:49	2026-09-23 10:49	2026-09-23 10:49	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	32.9000	32.7000	32.9000	7722.1000	131600.00	131600.00	0.00	40	7	374	8322	0.0449411199230954	0.106892722856466	0.106892722856466	false	false	false
7b8272df-b72e-4a2e-850a-c9a48b6592b6	2026-09-23 10:49	2026-09-23 10:49	2026-09-23 10:49	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	33.0000	32.7000	33.1000	7722.2100	141900.00	141900.00	0.00	43	10	417	8322	0.0501081470800288	0.107241271723114	0.107241271723114	false	false	false
710abb8b-c1f0-4129-b23d-6c5391dbbd17	2026-09-23 10:49	2026-09-23 10:49	2026-09-23 10:49	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	33.2000	33.1000	33.3000	7722.4400	33200.00	0.00	0.00	10	5	584	8322	0.0701754385964912	0.107948029695539	0.107948029695539	false	false	false
43cccf23-aad3-4c33-9012-6c9714165ca1	2026-09-23 13:56	2026-09-23 13:56	2026-09-23 13:56	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	37.3000	37.3000	37.5000	7714.0800	93250.00	0.00	93250.00	25	8	2000	8322	0.240326844508532	0.10946799190148	0.10946799190148	false	false	false
35b8203c-a5da-4aa5-a0e7-4b67895c4274	2026-09-23 14:02	2026-09-23 14:02	2026-09-23 14:02	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	35.9900	35.9000	36.2000	7717.3100	89970.00	0.00	89970.00	25	7	2154	8322	0.258832011535689	0.109633186147412	0.109633186147412	false	false	false
2b1dd62d-cb52-4399-8c9b-14c06748282d	2026-09-24 09:39	2026-09-24 09:39	2026-09-24 09:39	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	52.3000	52.2000	52.3000	7678.6300	146440.00	146440.00	0.00	28	10	494	9135	0.0540777230432403	0.111032500481685	0.111032500481685	false	false	false
3445e950-5cb9-4010-b8ee-2d27cb8bddf4	2026-09-25 11:39	2026-09-25 11:39	2026-09-25 11:39	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	32.3000	32.0000	32.4000	7690.0000	58140.00	58140.00	0.00	18	6	1116	10034	0.111221845724537	0.11147885402059	0.11147885402059	false	false	false
0e2c1b51-8d67-4801-83b4-41db447b97d0	2026-09-25 15:02	2026-09-25 15:02	2026-09-25 15:02	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	21.5000	21.4000	21.6000	7715.0000	10750.00	8600.00	0.00	5	5	1876	10034	0.186964321307554	0.105667894017977	0.105667894017977	false	false	false
8853b695-14e8-4b2b-930c-41b0850cde3f	2026-09-28 12:22	2026-09-28 12:21	2026-09-28 12:21	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	29.6000	29.4000	29.6000	7702.9100	29600.00	29600.00	0.00	10	5	919	10112	0.0908821202531646	0.140075637515373	0.140075637515373	false	false	false
4289f90a-003f-4d3e-b291-e3d94813d9ad	2026-09-29 09:47	2026-09-29 09:47	2026-09-29 09:47	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	36.0000	36.0000	36.1000	7681.1700	151200.00	0.00	151200.00	42	5	283	10280	0.0275291828793774	0.162092781686924	0.162092781686924	false	false	false
6ec58de4-a045-4aef-92f4-5885e80e3ec4	2026-09-29 09:48	2026-09-29 09:48	2026-09-29 09:48	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	36.5000	36.2000	36.6000	7680.2200	365000.00	94900.00	270100.00	100	7	383	10280	0.0372568093385214	0.16157806596545	0.16157806596545	false	false	false
10d59e0f-29e8-4bc8-aa89-505515360e9e	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	43.9700	43.7000	46.7000	7665.8500	48370.00	0.00	48370.00	11	5	3169	10280	0.308268482490272	0.14790130657298	0.14790130657298	false	false	false
e23939d6-ccb2-4611-9c3c-7f118b9d05bf	2026-09-29 15:00	2026-09-29 15:00	2026-09-29 15:00	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	33.7000	33.7000	33.8000	7678.0500	23590.00	0.00	23590.00	7	7	3754	10280	0.365175097276265	0.134078512971969	0.134078512971969	false	false	false
7e2d8ad1-1cb1-4c8f-a2b3-dcaf9ef1e12b	2026-09-29 15:18	2026-09-29 15:18	2026-09-29 15:18	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	36.0000	36.0000	36.2000	7672.9900	100800.00	0.00	100800.00	28	10	3952	10280	0.38443579766537	0.126357854337346	0.126456778688004	false	false	false
354d3ce6-5f87-48a9-9822-b1225c427ca2	2026-09-29 15:18	2026-09-29 15:18	2026-09-29 15:18	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	35.8000	35.8000	35.9000	7673.0400	85920.00	0.00	85920.00	24	8	3992	10280	0.388326848249027	0.125280839565052	0.125280839565052	false	false	false
6cce5533-3aa2-4903-994b-b2ee74e67fdf	2026-09-30 09:35	2026-09-30 09:35	2026-09-30 09:35	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	16.6000	16.6000	16.8000	7694.9900	33200.00	0.00	33200.00	20	6	1369	10638	0.128689603308893	0.169454963410394	0.169454963410394	false	false	false
44238009-1659-4946-9878-8f1856777d95	2026-09-30 09:37	2026-09-30 09:36	2026-09-30 09:36	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	16.5000	16.3000	16.6000	7694.9500	16500.00	8250.00	1650.00	10	5	1648	10638	0.154916337657454	0.16834025448182	0.16834025448182	false	false	false
dfdff8b1-2ea4-4fd3-b90a-d02ec132d0e3	2026-09-30 09:37	2026-09-30 09:37	2026-09-30 09:37	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	16.9000	16.7000	16.9000	7695.5600	16900.00	16900.00	0.00	10	5	1758	10638	0.165256627185561	0.177382857036464	0.177382857036464	false	false	false
6fc537b1-b0b6-4354-b206-2c61b481437d	2026-09-30 09:37	2026-09-30 09:37	2026-09-30 09:37	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	15.7000	15.5000	15.7000	7697.0700	15700.00	15700.00	0.00	10	6	1796	10638	0.168828727204362	0.17271543060949	0.17271543060949	false	false	false
11e5ab86-87e6-42b8-b7f8-8fc326b02411	2026-09-30 09:38	2026-09-30 09:38	2026-09-30 09:38	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	17.6000	17.5000	17.7000	7694.2200	19360.00	17600.00	0.00	11	5	1926	10638	0.181049069373942	0.177072577299684	0.177072577299684	false	false	false
3180980b-8505-404b-ad5d-200da876a3f5	2026-09-30 09:38	2026-09-30 09:38	2026-09-30 09:38	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	18.8000	18.8000	18.9000	7693.2100	18800.00	0.00	18800.00	10	6	2046	10638	0.192329385222786	0.184863047374676	0.184863047374676	false	false	false
08c96a87-64c5-4fe9-acbe-19ad4721a3b1	2026-09-30 09:39	2026-09-30 09:39	2026-09-30 09:39	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	17.6000	17.4000	17.6000	7694.3100	17600.00	17600.00	0.00	10	7	2237	10638	0.210283887948863	0.177923497515827	0.177923497515827	false	false	false
4eb57ef8-1a3d-488c-8b3a-c3a8f8f97e9b	2026-09-30 09:39	2026-09-30 09:39	2026-09-30 09:39	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	15.6000	15.6000	15.7000	7696.3600	15600.00	0.00	15600.00	10	5	2333	10638	0.219308140627938	0.167364136850223	0.167364136850223	false	false	false
17708a0c-3e88-42ac-b85a-0fa8f578c1db	2026-09-30 09:41	2026-09-30 09:41	2026-09-30 09:41	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	16.4100	16.4000	16.5000	7695.3500	29530.00	1650.00	27880.00	18	6	2743	10638	0.257849219778154	0.170795617467346	0.172022198744889	false	false	false
9dd73d44-667e-48f7-ae7d-56ac3026afde	2026-09-30 09:44	2026-09-30 09:44	2026-09-30 09:44	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	15.7200	15.6000	15.8000	7675.0000	14150.00	11010.00	3140.00	9	5	3345	10638	0.31443880428652	0.174348395742411	0.174348395742411	false	false	false
f5c09dc0-447a-4d7e-8d4c-f5e37a69be9d	2026-09-30 09:44	2026-09-30 09:44	2026-09-30 09:44	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	16.0000	15.9000	16.0000	7675.0000	36800.00	36800.00	0.00	23	7	3432	10638	0.322617033276932	0.174500736130172	0.174500736130172	false	false	false
fa9ba5e7-1b26-4ae6-af88-628d7cf87131	2026-09-30 09:45	2026-09-30 09:45	2026-09-30 09:45	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	18.2000	18.1000	18.3000	7670.0000	12740.00	0.00	0.00	7	6	3928	10638	0.369242338785486	0.172117132382897	0.172117132382897	false	false	false
e64a73d3-58f5-4485-ab1c-ae3b935267f1	2026-09-30 09:46	2026-09-30 09:46	2026-09-30 09:46	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	19.2000	19.0000	19.2000	7690.9100	19200.00	19200.00	0.00	10	5	4008	10638	0.376762549351382	0.175021689161531	0.175021689161531	false	false	false
262a8c0c-744f-4256-84c9-a8b87725b9bd	2026-09-30 09:46	2026-09-30 09:46	2026-09-30 09:46	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	18.5000	18.5000	18.7000	7690.7400	42550.00	0.00	42550.00	23	6	4032	10638	0.379018612521151	0.164908424584588	0.164908424584588	false	false	false
1a02c093-2bfb-4362-b5b4-d258eb07943a	2026-09-30 09:46	2026-09-30 09:46	2026-09-30 09:46	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	19.2000	19.0000	19.2000	7690.6600	19200.00	19200.00	0.00	10	5	4093	10638	0.384752773077646	0.173215100710915	0.173215100710915	false	false	false
8c3f1ffd-9891-4045-99a4-848007466df7	2026-09-30 09:46	2026-09-30 09:46	2026-09-30 09:46	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	18.8000	18.6000	18.8000	7690.2500	28200.00	28200.00	0.00	15	6	4114	10638	0.386726828351194	0.165018902374232	0.165018902374232	false	false	false
42770e76-2292-44e6-8850-3055c907ae79	2026-09-30 09:47	2026-09-30 09:46	2026-09-30 09:46	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	19.7000	19.5000	19.7000	7690.9400	37430.00	37430.00	0.00	19	8	4195	10638	0.394341041549163	0.181720864444796	0.181720864444796	false	false	false
377f9946-4a20-4800-8492-402503788db8	2026-09-30 09:47	2026-09-30 09:46	2026-09-30 09:46	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	19.3000	19.1500	19.3000	7691.3300	34740.00	34740.00	0.00	18	5	4218	10638	0.396503102086858	0.179612615245697	0.179612615245697	false	false	false
39497575-a278-49e1-a99d-5249f6b9355f	2026-09-30 09:49	2026-09-30 09:49	2026-09-30 09:49	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	14.5000	14.5000	14.6000	7675.0000	10150.00	0.00	10150.00	7	5	4569	10638	0.429498025944726	0.160633693454054	0.160633693454054	false	false	false
89358a3b-0ceb-498d-bd17-b6b025e38c91	2026-09-30 09:50	2026-09-30 09:50	2026-09-30 09:50	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	13.7000	13.7000	13.8000	7680.0000	67130.00	0.00	67130.00	49	16	4821	10638	0.453186689227298	0.167492234365157	0.167492234365157	false	false	false
5eb993e9-a848-4fde-9fdc-ba55a5e89fa5	2026-09-30 09:50	2026-09-30 09:50	2026-09-30 09:50	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	13.0000	13.0000	13.1000	7680.0000	16900.00	0.00	16900.00	13	5	4898	10638	0.460424891896973	0.168831852690022	0.168831852690022	false	false	false
035beb24-0f5a-4770-b668-f6ee9130d8e9	2026-09-30 09:50	2026-09-30 09:50	2026-09-30 09:50	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	14.4000	14.4000	14.5000	7680.0000	17280.00	0.00	17280.00	12	5	5383	10638	0.506016168452717	0.176786868268537	0.176786868268537	false	false	false
3d057e2e-3d98-42c3-a85f-42b2b80caeea	2026-09-30 09:51	2026-09-30 09:51	2026-09-30 09:51	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	13.4000	13.3000	13.5000	7680.0000	25460.00	0.00	21440.00	19	5	5551	10638	0.521808610641098	0.169308470596159	0.169308470596159	false	false	false
fe346aa3-2bd6-462a-8bc2-d93d77801d39	2026-09-30 09:52	2026-09-30 09:52	2026-09-30 09:52	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	15.0000	14.9000	15.0000	7675.0000	42000.00	42000.00	0.00	28	7	5909	10638	0.555461552923482	0.180341386273905	0.180341386273905	false	false	false
947a95f8-5de7-4850-8733-300f80556932	2026-09-30 09:52	2026-09-30 09:52	2026-09-30 09:52	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	16.0000	15.9000	16.0000	7675.0000	11200.00	11200.00	0.00	7	5	6103	10638	0.573698063545779	0.192686888483417	0.192686888483417	false	false	false
5bde9642-a50d-4cf8-896f-e3fd10eb50af	2026-09-30 09:53	2026-09-30 09:53	2026-09-30 09:53	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	17.0000	16.9000	17.0000	7695.9800	25500.00	25500.00	0.00	15	5	6459	10638	0.607163000564016	0.185148860280035	0.185148860280035	false	false	false
ca99941e-1cb7-4902-8c5b-ac3e0de9e32e	2026-09-30 09:53	2026-09-30 09:53	2026-09-30 09:53	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	17.1000	17.0000	17.2000	7695.0300	17100.00	0.00	0.00	10	6	6576	10638	0.618161308516638	0.180042528138663	0.180042528138663	false	false	false
80cb8955-201c-48e1-86c1-c3a890985a76	2026-09-30 09:55	2026-09-30 09:54	2026-09-30 09:54	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	12.7900	12.7000	12.9000	7701.2500	11510.00	0.00	11510.00	9	6	7110	10638	0.668358714043993	0.166214754167239	0.165754033444441	false	false	false