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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:sector = Financial Services×ticker = XP×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

1a79fa6d-6ba0-419f-8524-d13e21dcca16	2026-08-17 11:57	2026-08-17 11:57	2026-08-17 11:57	XP	XP260821C00015500	call	15.5000	2026-08-21	0.5200	0.5000	0.6000	15.6350	10088.00	0.00	10088.00	194	5	202	113	1.78761061946903	0.685852593007583	0.685852593007583	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	8139142289.00	2026-11-16	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
2d8b7a09-1ccb-49d9-b022-8d0744161acc	2026-08-17 14:00	2026-08-17 13:59	2026-08-17 13:59	XP	XP260821P00015000	put	15.0000	2026-08-21	0.2900	0.2500	0.3000	15.0000	29000.00	29000.00	0.00	1000	21	1147	586	1.95733788395904	0.801585174511501	0.801585174511501	false	false	false	true
cbdb159e-6a0e-4496-ae6a-31b3d201160f	2026-08-17 14:44	2026-08-17 14:44	2026-08-17 14:44	XP	XP270115C00015000	call	15.0000	2027-01-15	2.3000	2.1500	2.4000	15.6200	26220.00	25990.00	230.00	114	10	116	293	0.395904436860068	0.473102968495138	0.473102968495138	false	false	false	true
f3f6cf91-9e8c-41b8-926b-39bdf539a80e	2026-08-18 09:50	2026-08-18 09:50	2026-08-18 09:50	XP	XP261002C00014500	call	14.5000	2026-10-02	2.0000	1.9000	2.0000	16.1550	10200.00	10200.00	0.00	51	14	101	65	1.55384615384615	0.413349628047215	0.413349628047215	false	false	false	true
ff842dfe-b289-4528-b7f1-03b9d473d353	2026-08-18 12:50	2026-08-18 12:50	2026-08-18 12:50	XP	XP260918C00017000	call	17.0000	2026-09-18	0.3000	0.3000	0.3500	15.9150	249810.00	0.00	249810.00	8327	2	8427	2113	3.98816848083294	0.36532742891933	0.36532742891933	false	true	true	false
c263a5e7-1f66-4c98-8c69-12df627ffd3c	2026-08-19 14:02	2026-08-19 14:01	2026-08-19 14:01	XP	XP260918P00017000	put	17.0000	2026-09-18	1.1500	1.0000	1.3500	16.2650	43470.00	28635.00	14835.00	378	5	407	146	2.78767123287671	0.400785163161018	0.400785163161018	false	false	false	true
ed786100-c018-4dad-ae95-1108bfe7f4eb	2026-08-21 10:55	2026-08-21 10:55	2026-08-21 10:55	XP	XP260918P00019000	put	19.0000	2026-09-18	2.4000	2.3000	3.7000	16.7450	98640.00	64800.00	33840.00	411	5	411	23	17.8695652173913	0.459981077958249	0.459981077958249	false	false	false	true
ad839ae9-1d3f-4958-9058-374f0ece66a8	2026-08-24 10:42	2026-08-24 10:42	2026-08-24 10:42	XP	XP260918C00018000	call	18.0000	2026-09-18	0.4500	0.3500	0.4500	17.3600	22005.00	22005.00	0.00	489	9	657	4537	0.144809345382411	0.383917358237475	0.383917358237475	true	false	false	true
098dddfb-17eb-45d5-9f47-38063e0bc277	2026-08-24 13:20	2026-08-24 13:19	2026-08-24 13:19	XP	XP270219P00019000	put	19.0000	2027-02-19	3.3000	3.3000	3.4000	17.2500	18814.00	0.00	18814.00	57	9	71	48	1.47916666666667	0.51117502050605	0.51117502050605	false	false	false	true
3a6a5231-ee46-4947-abc4-02b97f251e82	2026-08-24 13:31	2026-08-24 13:31	2026-08-24 13:31	XP	XP270219P00017000	put	17.0000	2027-02-19	2.1600	2.0000	2.2500	17.2150	12942.00	1505.00	11437.00	60	9	126	51	2.47058823529412	0.512062587231352	0.512062587231352	false	false	false	true
23b80764-d9ba-4535-8d17-67cf7201119a	2026-08-24 14:39	2026-08-24 14:39	2026-08-24 14:39	XP	XP261120P00017000	put	17.0000	2026-11-20	1.5500	1.5500	1.6000	17.1350	10385.00	0.00	10385.00	67	16	420	70	6	0.509967208578467	0.509967208578467	false	false	false	true
da7e5abd-b822-4306-ad8e-26bc4a801218	2026-08-25 11:06	2026-08-25 11:06	2026-08-25 11:06	XP	XP261016P00017000	put	17.0000	2026-10-16	1.1000	0.9000	1.1500	17.1550	20240.00	110.00	20130.00	184	6	184	16	11.5	0.476128327004566	0.476128327004566	false	false	false	true
eb7b7884-cbb9-4a6a-a0ed-7425777b0612	2026-08-25 11:24	2026-08-25 11:24	2026-08-25 11:24	XP	XP261120P00018000	put	18.0000	2026-11-20	2.1000	2.0000	2.1500	17.1600	15120.00	10500.00	4620.00	72	12	72	997	0.0722166499498496	0.512516907344605	0.512516907344605	false	false	false	true
c23b22ed-646a-42bd-805e-5643636a0899	2026-08-25 11:57	2026-08-25 11:57	2026-08-25 11:57	XP	XP280121P00020000	put	20.0000	2028-01-21	5.2000	4.5000	5.4500	17.4150	244400.00	244400.00	0.00	470	10	470	94	5	0.527365139796906	0.527365139796906	false	false	false	true
4232469b-26a7-4f5a-8f9c-df7abcd07755	2026-08-25 11:57	2026-08-25 11:57	2026-08-25 11:57	XP	XP280121P00020000	put	20.0000	2028-01-21	5.2000	4.5000	5.2000	17.4150	11960.00	11960.00	0.00	23	5	493	94	5.24468085106383	0.527365139796906	0.527365139796906	false	false	false	true
6aefce70-c105-451e-8870-9127f0c24c41	2026-08-25 14:52	2026-08-25 14:52	2026-08-25 14:52	XP	XP260918C00017000	call	17.0000	2026-09-18	1.0000	0.9500	1.0500	17.5700	39905.00	12800.00	27105.00	399	31	401	5861	0.06841835864187	0.367297505974261	0.367297505974261	false	false	false	true
54715aa7-9b6b-4d53-95e0-c2017ee7135d	2026-08-25 14:52	2026-08-25 14:52	2026-08-25 14:52	XP	XP260918C00017000	call	17.0000	2026-09-18	1.0000	1.0000	1.0500	17.5600	15400.00	0.00	15400.00	154	25	555	5861	0.0946937382699198	0.371321787424605	0.371321787424605	false	false	false	true
3187997d-5ca8-491a-b67b-d60eda2a2ab9	2026-08-26 11:54	2026-08-26 11:54	2026-08-26 11:54	XP	XP270219P00020000	put	20.0000	2027-02-19	3.6000	2.1500	4.0000	17.8100	13320.00	5400.00	7920.00	37	9	37	6	6.16666666666667	0.502006784803717	0.502006784803717	false	false	false	true
53937624-1538-4bb6-b399-e8d5632f98f9	2026-08-26 12:11	2026-08-26 12:11	2026-08-26 12:11	XP	XP261016P00019000	put	19.0000	2026-10-16	1.9000	1.8000	1.9500	17.8450	14250.00	9500.00	4560.00	75	14	75	1	75	0.477314649947221	0.477314649947221	false	false	false	true
16c4be1f-f709-4fcc-8f9a-43ab2cfeffa4	2026-08-26 12:19	2026-08-26 12:19	2026-08-26 12:19	XP	XP270219P00019000	put	19.0000	2027-02-19	2.9000	2.9000	3.1000	17.8300	52857.00	0.00	52857.00	182	15	195	134	1.45522388059702	0.490867774263056	0.490867774263056	false	false	false	true
7d347f04-5208-4647-b84e-5f46bf1983b9	2026-08-26 14:54	2026-08-26 14:54	2026-08-26 14:54	XP	XP270115C00025000	call	25.0000	2027-01-15	0.4000	0.3500	0.4000	17.8700	35996.00	35996.00	0.00	900	48	1000	21636	0.0462192641893141	0.461437419143303	0.461138575117889	false	false	false	true
3eb68627-deef-4dcb-96ef-8ad629fc9711	2026-08-27 10:13	2026-08-27 10:13	2026-08-27 10:13	XP	XP261120P00019000	put	19.0000	2026-11-20	2.4500	2.3000	2.5500	17.6900	22295.00	4655.00	17640.00	91	5	91	190	0.478947368421053	0.520194558340735	0.520194558340735	false	false	false	true
ad05e480-26a5-427f-b8e6-d4373d171b4b	2026-08-27 10:14	2026-08-27 10:14	2026-08-27 10:14	XP	XP261016P00019000	put	19.0000	2026-10-16	2.0000	1.7500	2.3000	17.6900	12200.00	10000.00	2200.00	61	7	61	76	0.802631578947368	0.484235976683902	0.484235976683902	false	false	false	true
c61b3104-f68e-41fb-9ed8-7ab81867352f	2026-08-27 11:58	2026-08-27 11:58	2026-08-27 11:58	XP	XP261120P00018000	put	18.0000	2026-11-20	1.9000	1.7500	1.9500	17.6400	18810.00	9500.00	9310.00	99	18	193	1069	0.180542563143124	0.527375563844526	0.528065677051782	false	false	false	true
b944a19c-90f4-4bc3-860d-ebbe04e7005d	2026-08-27 12:02	2026-08-27 12:02	2026-08-27 12:02	XP	XP270219P00020000	put	20.0000	2027-02-19	3.7000	3.5000	3.8000	17.6200	25530.00	7030.00	18500.00	69	5	94	133	0.706766917293233	0.502193277175128	0.502193277175128	false	false	false	true
f045c913-a9be-447f-b060-f2b31cbc12bc	2026-08-31 12:09	2026-08-31 12:09	2026-08-31 12:09	XP	XP270115P00021000	put	21.0000	2027-01-15	3.8000	3.8000	3.9000	18.3950	43714.00	0.00	43714.00	115	15	119	1	119	0.518884246919486	0.518884246919486	false	false	false	true
d3bae909-7709-4748-8a1a-2b9e04a5f51e	2026-08-31 15:53	2026-08-31 15:53	2026-08-31 15:53	XP	XP260918C00018500	call	18.5000	2026-09-18	0.5500	0.5000	0.5500	18.3850	41910.00	41910.00	0.00	762	6	1546	11	140.545454545455	0.361014681286147	0.361014681286147	false	false	false	true
940ed84d-9555-4db9-8653-03a7d1f42723	2026-09-01 10:34	2026-09-01 10:34	2026-09-01 10:34	XP	XP270115C00022000	call	22.0000	2027-01-15	1.2000	1.0000	1.2500	19.0250	16560.00	6000.00	10560.00	138	6	138	14251	0.00968353098028209	0.463240054494615	0.463240054494615	false	false	false	true
a191e0cd-6372-41c4-b40a-6d7f2bd0a3d1	2026-09-01 13:33	2026-09-01 13:33	2026-09-01 13:33	XP	XP270115C00020000	call	20.0000	2027-01-15	1.7500	1.7500	1.8500	18.8900	10150.00	0.00	10150.00	58	12	378	40920	0.0092375366568915	0.455363954450151	0.455363954450151	false	false	false	true
283a88e2-9e2e-408f-80c1-d8d00a7bdbbd	2026-09-02 10:36	2026-09-02 10:36	2026-09-02 10:36	XP	XP260918C00020500	call	20.5000	2026-09-18	0.4000	0.3000	0.4500	19.8700	24233.00	24233.00	0.00	606	41	606	0	0	0.398485041834132	0.389035392077855	true	false	false	true
db224d93-43e5-46af-9c78-d478c4818cff	2026-09-02 10:59	2026-09-02 10:59	2026-09-02 10:59	XP	XP261016C00022000	call	22.0000	2026-10-16	0.6000	0.5000	0.6500	19.8000	41820.00	37740.00	4080.00	697	20	698	1	698	0.490706301330742	0.48817237390315	true	false	false	true
74621081-d7cd-4862-b8a3-0dace6696ddf	2026-09-02 12:16	2026-09-02 12:16	2026-09-02 12:16	XP	XP270115C00020000	call	20.0000	2027-01-15	2.4000	2.3000	2.4000	19.7950	33600.00	33600.00	0.00	140	7	802	40992	0.0195647931303669	0.496045933506528	0.496045933506528	false	false	false	true
d3e0c382-ceb4-4b48-acec-285ad0cf65d1	2026-09-02 12:18	2026-09-02 12:18	2026-09-02 12:18	XP	XP261120P00020000	put	20.0000	2026-11-20	2.0000	1.9000	2.1000	19.8250	38600.00	1000.00	37600.00	193	22	835	39	21.4102564102564	0.544096946954407	0.544096946954407	false	false	false	true
0034c4c7-4091-4f60-915d-737fd5522bd6	2026-09-02 12:42	2026-09-02 12:42	2026-09-02 12:42	XP	XP270219C00021000	call	21.0000	2027-02-19	2.2000	1.9500	2.2000	19.8000	240460.00	240460.00	0.00	1093	7	1951	69	28.2753623188406	0.474832050125345	0.474832050125345	false	false	false	true
e224d7f0-a5bf-42eb-90ae-88695a3d1ace	2026-09-02 12:44	2026-09-02 12:43	2026-09-02 12:43	XP	XP270219C00021000	call	21.0000	2027-02-19	2.2000	2.1000	2.2000	19.8200	285560.00	285560.00	0.00	1298	9	3250	69	47.1014492753623	0.472927645430001	0.472927645430001	false	false	false	true
5b9b46a9-852c-4e82-94a4-1831b648f17d	2026-09-02 12:45	2026-09-02 12:45	2026-09-02 12:45	XP	XP260925C00021500	call	21.5000	2026-09-25	0.2500	0.2500	0.4000	19.7950	12028.00	0.00	12028.00	481	24	967	15	64.4666666666667	0.400734443734761	0.400734443734761	false	false	false	true
404c9239-738c-41b8-8ff2-b8cd4f70d532	2026-09-02 13:08	2026-09-02 13:08	2026-09-02 13:08	XP	XP270219C00021000	call	21.0000	2027-02-19	2.1500	2.1500	2.2500	19.8250	116315.00	0.00	116315.00	541	36	3825	69	55.4347826086956	0.463183267561339	0.463183267561339	false	false	false	true
86f3f6b7-b50a-4ab5-986d-31dc495cfac1	2026-09-02 13:53	2026-09-02 13:53	2026-09-02 13:53	XP	XP261120P00020000	put	20.0000	2026-11-20	2.0500	2.0000	2.1500	19.7750	183463.00	37298.00	73800.00	895	32	1830	39	46.9230769230769	0.554712303738492	0.55161184038801	false	false	false	true
9a5e9a2e-a055-40c1-8a69-e24b05054a0b	2026-09-02 15:16	2026-09-02 15:16	2026-09-02 15:16	XP	XP270219C00021000	call	21.0000	2027-02-19	2.2500	2.2500	2.3000	20.0000	28800.00	0.00	28800.00	128	19	4173	69	60.4782608695652	0.464930419348942	0.464930419348942	false	false	false	true
10b7df60-b17e-4580-b3a3-64fd4bd861c0	2026-09-03 09:42	2026-09-03 09:41	2026-09-03 09:41	XP	XP261120C00021000	call	21.0000	2026-11-20	1.8700	1.7500	1.9500	20.2900	1870000.00	760000.00	0.00	10000	2	10000	36191	0.276311790224089	0.570591884657632	0.570591884657632	false	true	false	true
ea424c19-af5b-4e94-949b-ff3be1ef4d76	2026-09-03 09:45	2026-09-03 09:45	2026-09-03 09:45	XP	XP260918C00021000	call	21.0000	2026-09-18	0.4000	0.3500	0.4500	20.4100	38333.00	5280.00	33053.00	958	36	1068	118	9.05084745762712	0.382816747061681	0.382816747061681	false	false	false	true
d7c85a0d-e210-4a70-b5fa-d7e15d28e842	2026-09-03 13:12	2026-09-03 13:12	2026-09-03 13:12	XP	XP260918C00020000	call	20.0000	2026-09-18	0.5500	0.5500	0.7000	19.9200	11000.00	0.00	11000.00	200	18	224	62	3.61290322580645	0.355908143669715	0.355908143669715	false	false	false	true
275a2e73-4c66-41c3-8e39-631360d7b144	2026-09-04 09:42	2026-09-04 09:42	2026-09-04 09:42	XP	XP261120C00020000	call	20.0000	2026-11-20	1.9500	1.7500	1.9500	19.7200	51480.00	51480.00	0.00	264	7	1414	197	7.17766497461929	0.557762862747545	0.555503613766282	false	false	false	true
1594d427-3c1a-4cc2-b073-78fa5eba6ccb	2026-09-04 09:42	2026-09-04 09:42	2026-09-04 09:42	XP	XP261120C00020000	call	20.0000	2026-11-20	1.9500	1.7500	2.0000	19.7050	224229.00	205509.00	18720.00	1150	54	1150	197	5.83756345177665	0.563023971583988	0.557762862747545	false	false	false	true
6af68fb5-45f2-4ac8-815b-c391768a7e9d	2026-09-04 10:06	2026-09-04 10:06	2026-09-04 10:06	XP	XP261120P00020000	put	20.0000	2026-11-20	2.0000	1.9000	2.0000	19.8100	12800.00	12800.00	0.00	64	6	64	1895	0.0337730870712401	0.548396428269026	0.548396428269026	false	false	false	true
43e255a5-275e-4154-93d0-e44ca9bf2136	2026-09-04 11:04	2026-09-04 11:04	2026-09-04 11:04	XP	XP261016P00019000	put	19.0000	2026-10-16	0.7500	0.7500	0.8500	19.9500	41325.00	0.00	41325.00	551	26	557	287	1.94076655052265	0.4557742076413	0.4557742076413	false	false	false	true
b4454922-fc70-4adb-9dbc-33c2537d362b	2026-09-09 10:53	2026-09-09 10:53	2026-09-09 10:53	XP	XP270115C00022000	call	22.0000	2027-01-15	1.2500	1.1000	1.2500	19.0450	12500.00	12500.00	0.00	100	6	116	14404	0.0080533185226326	0.490482756140441	0.490482756140441	false	false	false	true
a83dd55e-59b3-477a-b7e9-76b06ffa40d9	2026-09-09 10:54	2026-09-09 10:54	2026-09-09 10:54	XP	XP270115C00022000	call	22.0000	2027-01-15	1.2500	1.0500	1.2500	19.0550	12500.00	12500.00	0.00	100	6	216	14404	0.0149958344904193	0.489599267860759	0.489599267860759	false	false	false	true
ba2168ac-0740-4ee5-8cd1-d856554e85f6	2026-09-09 15:06	2026-09-09 15:06	2026-09-09 15:06	XP	XP261120C00020000	call	20.0000	2026-11-20	1.6000	1.5000	1.6000	19.1050	15973.00	15973.00	0.00	100	7	3610	3077	1.17322066948326	0.567447273960956	0.557134564319692	false	false	false	true
ebbd7809-43d8-465c-9c00-0e169a06b467	2026-09-10 11:13	2026-09-10 11:13	2026-09-10 11:13	XP	XP270115C00030000	call	30.0000	2027-01-15	0.3500	0.2000	0.4500	19.9850	35000.00	28000.00	7000.00	1000	52	1000	9094	0.109962612711678	0.519091808500227	0.519091808500227	true	false	false	true