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:ticker = SHOP×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

d6577d0c-c239-482f-9674-bf1c8b5bb86c	2026-08-31 09:43	2026-08-31 09:43	2026-08-31 09:43	SHOP	SHOP260918P00160000	put	160.0000	2026-09-18	14.5000	14.5000	15.3000	147.1400	50750.00	0.00	50750.00	35	35	44	657	0.0669710806697108	0.466828385928789	0.466828385928789	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	161815483760.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d09ae84b-3cee-4cc3-a577-6610836497ad	2026-08-31 09:44	2026-08-31 09:44	2026-08-31 09:44	SHOP	SHOP260925P00140000	put	140.0000	2026-09-25	3.7000	3.4000	3.8500	146.7600	65110.00	64375.00	735.00	176	26	176	307	0.57328990228013	0.44608691510518	0.442414796858088	false	false	false	true	false
d64fc5dd-337c-45b9-9a2b-8b90ef618515	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	SHOP	SHOP270917C00200000	call	200.0000	2027-09-17	18.0100	18.0000	18.7000	145.8300	59440.00	1835.00	57605.00	33	10	33	98	0.336734693877551	0.542416141107112	0.548440320807979	false	false	false	true	false
a2ad44d7-caf1-408a-ac3a-46a60ee2f66d	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	SHOP	SHOP270917C00210000	call	210.0000	2027-09-17	16.0300	15.9000	16.2500	145.7705	72140.00	36945.00	35195.00	45	10	49	106	0.462264150943396	0.542407404759526	0.543289721776726	false	false	false	true	false
10d455b7-e5b5-4ea7-b055-650271b9737b	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	SHOP	SHOP270917C00200000	call	200.0000	2027-09-17	17.9500	17.8500	18.3000	145.8700	52055.00	14360.00	37695.00	29	7	281	98	2.86734693877551	0.541271365287268	0.541271365287268	false	false	false	true	false
04f00c1b-aa6b-4c80-92cb-9dec5b84adcf	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	SHOP	SHOP270917C00200000	call	200.0000	2027-09-17	17.9900	17.9500	18.3000	145.9200	88145.00	34295.00	53850.00	49	5	212	98	2.16326530612245	0.540917399455911	0.54263909441951	false	false	false	true	false
2a13fc65-7251-4ee2-859c-11fa68988b80	2026-08-31 12:19	2026-08-31 12:19	2026-08-31 12:19	SHOP	SHOP280121P00165000	put	165.0000	2028-01-21	43.5600	43.3000	44.0500	146.8400	69695.00	4365.00	65330.00	16	8	46	117	0.393162393162393	0.545076679716453	0.546558670019266	false	false	false	true	false
cbce84ee-46c9-452d-8233-8f12e8cb333a	2026-09-01 09:39	2026-09-01 09:39	2026-09-01 09:39	SHOP	SHOP270319C00185000	call	185.0000	2027-03-19	10.3800	10.3500	11.7500	142.6900	69530.00	6360.00	63170.00	67	15	67	751	0.0892143808255659	0.532113750163502	0.533410024166604	false	false	false	true	false
af9fe06a-a93a-49c8-a71d-443a39a61436	2026-09-01 13:08	2026-09-01 13:08	2026-09-01 13:08	SHOP	SHOP271217C00185000	call	185.0000	2027-12-17	23.8600	23.7500	24.7000	141.0100	64420.00	19155.00	45265.00	27	6	50	55	0.909090909090909	0.553117503407525	0.554682101366166	false	false	false	true	false
f5ed1378-f55b-44b7-8041-c3d2bbfb06a9	2026-09-01 14:34	2026-09-01 14:34	2026-09-01 14:34	SHOP	SHOP260918P00140000	put	140.0000	2026-09-18	5.0200	4.9500	5.0500	139.8600	76335.00	60835.00	14000.00	152	19	520	1630	0.319018404907975	0.420125307251485	0.420125307251485	false	false	false	true	false
d7e72f57-e86f-4750-b6a6-b5f671e9292a	2026-09-01 14:38	2026-09-01 14:38	2026-09-01 14:38	SHOP	SHOP261120C00145000	call	145.0000	2026-11-20	12.4600	12.3000	12.5500	139.9500	300166.00	300166.00	0.00	241	12	293	1639	0.178767541183649	0.539507362439364	0.541803298605636	false	false	false	true	false
2933459f-76b1-4f04-9a6e-b8073f337018	2026-09-01 14:38	2026-09-01 14:38	2026-09-01 14:38	SHOP	SHOP261120P00135000	put	135.0000	2026-11-20	10.9400	10.8000	11.0500	139.9500	223160.00	101840.00	121320.00	204	12	289	276	1.04710144927536	0.539927864533188	0.540728891123996	false	false	false	true	false
00fe50b2-f2d8-4c96-951c-84e183d19881	2026-09-01 14:38	2026-09-01 14:38	2026-09-01 14:38	SHOP	SHOP261120C00145000	call	145.0000	2026-11-20	12.5000	12.3500	12.5500	139.9400	101250.00	95000.00	0.00	81	14	383	1639	0.233679072605247	0.542380490614615	0.542380490614615	true	false	false	true	false
42df976e-833d-4452-bed8-2de4e0377d2d	2026-09-01 14:39	2026-09-01 14:39	2026-09-01 14:39	SHOP	SHOP260918P00135000	put	135.0000	2026-09-18	2.9400	2.9400	3.0500	140.0100	351940.00	22936.00	329004.00	1196	29	1287	1662	0.774368231046931	0.43899946022209	0.440707564810639	true	false	false	true	false
1ef8613f-75a1-40a9-af94-189ba6cae3f4	2026-09-01 14:39	2026-09-01 14:39	2026-09-01 14:39	SHOP	SHOP260918P00134000	put	134.0000	2026-09-18	2.6600	2.6300	2.6600	140.0100	51072.00	51072.00	0.00	192	30	203	32	6.34375	0.442315314907814	0.441318232859592	true	false	false	true	false
9bb20d17-316e-4480-9749-060a92528b0a	2026-09-01 14:39	2026-09-01 14:39	2026-09-01 14:39	SHOP	SHOP261120P00120000	put	120.0000	2026-11-20	5.3700	5.2500	5.4500	139.9900	78910.00	31295.00	46545.00	147	8	167	794	0.210327455919395	0.555088678058501	0.552656584794819	true	false	false	true	false
6100526d-8b21-4663-ac97-b3b5695df7c2	2026-09-01 14:40	2026-09-01 14:40	2026-09-01 14:40	SHOP	SHOP260918C00140000	call	140.0000	2026-09-18	5.3000	5.1500	5.3000	139.9950	52470.00	52470.00	0.00	99	68	501	47586	0.0105283066448115	0.429976465547224	0.429976465547224	false	false	false	true	false
c90b99b7-63ce-4608-8f93-9fe13df5dcea	2026-09-01 14:59	2026-09-01 14:59	2026-09-01 14:59	SHOP	SHOP261120C00130000	call	130.0000	2026-11-20	20.4500	19.7000	20.7000	140.4300	59305.00	38855.00	20450.00	29	5	44	561	0.0784313725490196	0.555618648275042	0.555618648275042	false	false	false	true	false
ac0f9632-fcf5-45f8-81ec-d734cb6ab361	2026-09-01 15:53	2026-09-01 15:53	2026-09-01 15:53	SHOP	SHOP261120C00145000	call	145.0000	2026-11-20	12.5000	12.5000	13.0000	139.4600	83750.00	0.00	83750.00	67	15	474	1639	0.289200732153752	0.55014802764824	0.551698408559201	false	false	false	true	false
c0e9552a-58f0-4e1c-abb8-4970b252f9e3	2026-09-02 11:37	2026-09-02 11:36	2026-09-02 11:36	SHOP	SHOP261016P00150000	put	150.0000	2026-10-16	14.3500	13.1000	14.5500	139.7600	87525.00	87525.00	0.00	61	7	63	832	0.0757211538461538	0.438557037680579	0.438557037680579	true	false	false	true	false
8ba0121a-cd16-45ac-bb87-708ec4a2fe8e	2026-09-02 13:23	2026-09-02 13:22	2026-09-02 13:22	SHOP	SHOP281215P00070000	put	70.0000	2028-12-15	7.9600	7.9500	8.6000	140.6300	83620.00	820.00	82800.00	105	13	109	365	0.298630136986301	0.593686463583052	0.594551122269832	false	false	false	true	false
0bdeb6b5-7a0e-4646-82ef-9c6ddd4fca11	2026-09-02 15:12	2026-09-02 15:12	2026-09-02 15:12	SHOP	SHOP270319C00180000	call	180.0000	2027-03-19	10.5000	10.2000	11.1000	140.2000	84000.00	25200.00	58800.00	80	23	80	180	0.444444444444444	0.528975532051521	0.528975532051521	false	false	false	true	false
1ede17aa-defe-4910-b558-97113f4ddb6e	2026-09-03 09:30	2026-09-03 09:30	2026-09-03 09:30	SHOP	SHOP281215P00100000	put	100.0000	2028-12-15	18.5000	17.4000	18.5500	143.2600	199779.00	129504.00	70275.00	108	10	108	2358	0.0458015267175573	0.588614927362881	0.587664990158794	false	false	false	true	false
e23b6ee9-1106-4295-8802-40b9d4a88109	2026-09-03 12:57	2026-09-03 12:57	2026-09-03 12:57	SHOP	SHOP260911C00146000	call	146.0000	2026-09-11	2.6600	2.6500	2.6800	143.3200	65267.00	30552.00	2650.00	245	20	295	48	6.14583333333333	0.447784416769415	0.447784416769415	true	false	false	true	false
763cc38e-e3c7-4d50-8bf6-d66f1d363f63	2026-09-03 12:57	2026-09-03 12:57	2026-09-03 12:57	SHOP	SHOP260911P00144000	put	144.0000	2026-09-11	3.9500	3.9500	4.5000	143.3000	433030.00	2860.00	25690.00	1096	21	1518	31	48.9677419354839	0.432039913148498	0.448560177186012	false	false	false	true	false
e2e3ac15-1ffa-4cf3-b1b5-c57682a61954	2026-09-03 13:08	2026-09-03 13:08	2026-09-03 13:08	SHOP	SHOP281215P00120000	put	120.0000	2028-12-15	26.8500	25.6000	27.6000	143.8950	120825.00	24165.00	96660.00	45	11	45	1088	0.0413602941176471	0.575572254333459	0.575572254333459	false	false	false	true	false
54bdeca5-a7d3-492d-a8eb-b8725564cc28	2026-09-03 14:13	2026-09-03 14:13	2026-09-03 14:13	SHOP	SHOP260918C00145000	call	145.0000	2026-09-18	5.2100	5.1250	5.3500	144.8300	90205.00	90205.00	0.00	173	5	242	2830	0.0855123674911661	0.445979225572463	0.441705239886412	false	false	false	true	false
0ac019c7-2926-42a6-951f-210b536d3736	2026-09-03 14:39	2026-09-03 14:39	2026-09-03 14:39	SHOP	SHOP260918C00160000	call	160.0000	2026-09-18	1.0700	1.0100	1.0700	145.6500	66126.00	66126.00	0.00	618	8	4112	82020	0.0501341136308217	0.441710948056238	0.441710948056238	false	false	false	true	false
65701350-0b2f-4f1e-954d-1852b46046ad	2026-09-03 15:07	2026-09-03 15:07	2026-09-03 15:07	SHOP	SHOP260911C00147000	call	147.0000	2026-09-11	3.5800	3.5500	3.6500	146.2900	69875.00	23725.00	46150.00	195	11	220	217	1.01382488479263	0.45476327525854	0.45476327525854	false	false	false	true	false
62312d4a-0c9a-478c-9295-1d5ec3e3d841	2026-09-03 15:12	2026-09-03 15:12	2026-09-03 15:12	SHOP	SHOP260911P00145000	put	145.0000	2026-09-11	3.2700	3.2000	3.9000	146.0600	129630.00	68970.00	44490.00	397	11	947	90	10.5222222222222	0.452166384705076	0.449600100801974	false	false	false	true	false
fde8ff9a-4b43-4f79-9e15-7cfb6b6b55e2	2026-09-03 15:41	2026-09-03 15:41	2026-09-03 15:41	SHOP	SHOP261016C00140000	call	140.0000	2026-10-16	12.3500	12.2500	12.5000	145.7850	60515.00	41990.00	18525.00	49	6	121	558	0.216845878136201	0.449508142072002	0.449508142072002	false	false	false	true	false
e575e40e-62ea-4134-8bbc-fcec5d39eed1	2026-09-04 10:41	2026-09-04 10:41	2026-09-04 10:41	SHOP	SHOP281215P00165000	put	165.0000	2028-12-15	50.6000	50.6000	54.0000	148.8000	50600.00	0.00	50600.00	10	8	10	83	0.120481927710843	0.577234682955884	0.577234682955884	false	false	false	true	false
4ffee19d-9020-4afa-bb93-05da0f0eb4eb	2026-09-04 12:05	2026-09-04 12:05	2026-09-04 12:05	SHOP	SHOP261120P00145000	put	145.0000	2026-11-20	13.1000	13.0000	13.3000	147.1300	89080.00	87770.00	1310.00	68	13	175	298	0.587248322147651	0.552910517696455	0.552910517696455	false	false	false	true	false
b395f826-b26f-427a-a9f1-8df1586d4901	2026-09-04 12:05	2026-09-04 12:05	2026-09-04 12:05	SHOP	SHOP260918P00140000	put	140.0000	2026-09-18	2.3400	2.3400	2.5600	147.1300	89156.00	0.00	89156.00	381	40	456	1950	0.233846153846154	0.464735503520132	0.464735503520132	false	false	false	true	false
b1ed7def-9fa3-4eba-b979-db75e8085e3f	2026-09-04 12:19	2026-09-04 12:19	2026-09-04 12:19	SHOP	SHOP260911C00150000	call	150.0000	2026-09-11	2.9000	2.8800	3.0000	147.4100	317323.00	239493.00	77830.00	1093	39	1599	748	2.13770053475936	0.490706397238575	0.495727577124994	true	false	false	true	false
6464171d-8eb9-44b8-b726-f18a8b0b6edf	2026-09-04 12:55	2026-09-04 12:55	2026-09-04 12:55	SHOP	SHOP280121P00110000	put	110.0000	2028-01-21	14.9500	14.5000	15.0500	147.0900	79235.00	44850.00	22425.00	53	14	102	2202	0.0463215258855586	0.562243095269394	0.562243095269394	true	false	false	true	false
db285df0-643f-4218-8c32-05af711166d1	2026-09-04 13:01	2026-09-04 13:01	2026-09-04 13:01	SHOP	SHOP260911C00146000	call	146.0000	2026-09-11	4.6000	4.6000	5.1500	147.0200	98900.00	0.00	98900.00	215	6	240	420	0.571428571428571	0.495841489336392	0.495841489336392	false	false	false	true	false
b259ab29-f295-4270-8e59-0a8623b4d847	2026-09-04 13:01	2026-09-04 13:01	2026-09-04 13:01	SHOP	SHOP260911P00145000	put	145.0000	2026-09-11	2.9800	2.9700	3.0500	147.0200	98769.00	30300.00	68469.00	331	19	425	779	0.545571245186136	0.493824500003428	0.492803945335071	false	false	false	true	false
016ec46b-a579-4880-9111-e7a12bb9e250	2026-09-04 13:01	2026-09-04 13:01	2026-09-04 13:01	SHOP	SHOP260911P00147000	put	147.0000	2026-09-11	3.9500	3.9500	4.4500	147.0200	59250.00	0.00	59250.00	150	8	267	40	6.675	0.494451304246511	0.494451304246511	false	false	false	true	false
f75cbd2d-48bd-4acf-a480-0a315cdd5bb9	2026-09-04 14:00	2026-09-04 14:00	2026-09-04 14:00	SHOP	SHOP260918C00145000	call	145.0000	2026-09-18	6.1000	5.8500	6.4500	146.0600	107360.00	106750.00	610.00	176	22	279	2997	0.0930930930930931	0.479932361798575	0.478949334369215	false	false	false	true	false
e5c1dc19-7a09-48b7-905b-73ee559a139e	2026-09-04 14:27	2026-09-04 14:27	2026-09-04 14:27	SHOP	SHOP271217P00140000	put	140.0000	2027-12-17	28.3000	28.3000	29.1000	146.0800	50940.00	0.00	50940.00	18	7	18	137	0.131386861313869	0.560963164926741	0.560963164926741	false	false	false	true	false
0bbf9936-1dd7-4f3e-8a36-5de5a78a7db4	2026-09-04 15:20	2026-09-04 15:20	2026-09-04 15:20	SHOP	SHOP260911C00146000	call	146.0000	2026-09-11	3.8700	3.8000	4.0000	145.5200	92603.00	42658.00	49155.00	239	32	798	420	1.9	0.513620121794245	0.513620121794245	false	false	false	true	false
dc525722-19fc-433f-b8f6-e8c731da64a3	2026-09-08 09:38	2026-09-08 09:38	2026-09-08 09:38	SHOP	SHOP261016P00140000	put	140.0000	2026-10-16	10.4400	8.5000	10.7500	136.7300	50125.00	31345.00	18780.00	48	7	66	895	0.0737430167597765	0.511715578903612	0.503186923481148	true	false	false	true	false
fca94f13-ea2e-46af-a4a2-6752c798859c	2026-09-08 09:39	2026-09-08 09:39	2026-09-08 09:39	SHOP	SHOP261120C00135000	call	135.0000	2026-11-20	15.5000	15.5000	17.6000	136.2900	131750.00	0.00	131750.00	85	7	88	572	0.153846153846154	0.594901031076125	0.594901031076125	true	false	false	true	false
b6fa8f1c-e37e-4a51-9033-9e18b62eb06b	2026-09-08 09:46	2026-09-08 09:46	2026-09-08 09:46	SHOP	SHOP261023P00110000	put	110.0000	2026-10-23	1.1000	0.3300	2.8100	136.0200	1114990.00	0.00	1114990.00	10135	5	10135	0	0	0.542231861149355	0.542231861149355	false	false	false	true	false
64041904-5424-4ada-9e92-c7a2c5b91b5b	2026-09-08 10:01	2026-09-08 10:01	2026-09-08 10:01	SHOP	SHOP281215P00100000	put	100.0000	2028-12-15	19.3500	19.3500	19.9500	136.3300	112232.00	0.00	112232.00	58	13	79	2396	0.0329716193656093	0.567671696708194	0.567671696708194	false	false	false	true	false
92e24b36-5e15-4766-b32b-e1150d652937	2026-09-08 10:15	2026-09-08 10:14	2026-09-08 10:14	SHOP	SHOP260918P00135000	put	135.0000	2026-09-18	5.3000	5.0250	5.6000	134.4250	78970.00	14840.00	64130.00	149	13	211	2680	0.0787313432835821	0.57258547945934	0.571538282928161	true	false	false	true	false
48b63372-9e37-4076-b4f2-4ca732df12d2	2026-09-08 10:35	2026-09-08 10:35	2026-09-08 10:35	SHOP	SHOP261016P00110000	put	110.0000	2026-10-16	1.1300	1.1000	1.1300	133.0587	64636.00	64636.00	0.00	572	25	1278	17809	0.0717614689202089	0.506646401726276	0.506646401726276	false	false	false	true	false
71e237d8-283c-4f99-bd76-ba3554c203c6	2026-09-08 10:49	2026-09-08 10:49	2026-09-08 10:49	SHOP	SHOP261218P00125000	put	125.0000	2026-12-18	10.6000	10.3000	10.7000	133.2100	110200.00	60410.00	21170.00	104	22	116	1314	0.0882800608828006	0.555302751766962	0.55142438325455	true	false	false	true	false
ad2c1d70-1599-433b-bc64-189c68951f5f	2026-09-08 10:49	2026-09-08 10:49	2026-09-08 10:49	SHOP	SHOP261218P00125000	put	125.0000	2026-12-18	10.6000	10.6000	10.7500	133.3000	72080.00	0.00	72080.00	68	15	244	1314	0.185692541856925	0.556501882735079	0.556501882735079	false	false	false	true	false