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 = Technology×ticker = IOT×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

c475916d-8b57-4035-bd0b-6b5ec953b378	2026-09-22 12:09	2026-09-22 12:09	2026-09-22 12:09	IOT	IOT261002C00041000	call	41.0000	2026-10-02	0.4000	0.3500	0.4000	38.0600	15960.00	15960.00	0.00	399	22	406	1050	0.386666666666667	0.535170101491374	0.535170101491374	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	14549246357.00	2026-12-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T16:12:44.237245Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
eaaf8408-ac01-4af0-8b7a-dec368854aca	2026-09-21 13:52	2026-09-21 13:52	2026-09-21 13:52	IOT	IOT261120C00047000	call	47.0000	2026-11-20	0.7500	0.7500	1.3000	38.3500	14325.00	0.00	14325.00	191	11	218	1693	0.128765505020673	0.499085769665093	0.499085769665093	false	false	false	true
49629ffe-cd1e-4fc8-9c20-2c6028b6b4b1	2026-09-18 15:49	2026-09-18 15:49	2026-09-18 15:49	IOT	IOT261120P00033000	put	33.0000	2026-11-20	0.9000	0.8500	1.0000	39.7050	20520.00	0.00	20250.00	228	26	237	15	15.8	0.545635721527649	0.545635721527649	false	false	false	true	false
9d972757-a22b-4b20-9bc5-58068d67af5f	2026-09-18 15:10	2026-09-18 15:10	2026-09-18 15:10	IOT	IOT270115P00035000	put	35.0000	2027-01-15	2.7600	2.6000	2.9000	39.4250	13813.00	1375.00	12438.00	50	5	441	893	0.493840985442329	0.574476423161667	0.583630755897184	false	false	false	true
e76f9472-59ff-4ddb-9d19-27006ba526fb	2026-09-18 10:45	2026-09-18 10:45	2026-09-18 10:45	IOT	IOT261218P00034000	put	34.0000	2026-12-18	2.3100	2.1500	2.4000	39.0250	386001.00	386001.00	0.00	1671	2	1671	176	9.49431818181818	0.625130700801548	0.625130700801548	false	true	true	false
1a3d5335-7ff2-4ad6-8962-434289de01c3	2026-09-18 09:58	2026-09-18 09:58	2026-09-18 09:58	IOT	IOT270115C00045000	call	45.0000	2027-01-15	3.1000	3.1000	4.2000	39.1900	465000.00	0.00	465000.00	1500	17	1500	3838	0.390828556539865	0.559537662417785	0.559537662417785	false	false	false	true
1f6760bb-bd4b-4c12-8af2-47b70afe2599	2026-09-18 09:33	2026-09-18 09:33	2026-09-18 09:33	IOT	IOT270115P00035000	put	35.0000	2027-01-15	2.9000	2.8500	2.9000	39.4900	21460.00	21460.00	0.00	74	7	180	893	0.201567749160134	0.596499169050051	0.596499169050051	false	false	false	true
10910469-690b-466a-882d-5cbcd020a77e	2026-09-17 15:28	2026-09-17 15:28	2026-09-17 15:28	IOT	IOT260918C00040500	call	40.5000	2026-09-18	0.3300	0.3000	0.5500	40.1100	16106.00	0.00	16106.00	488	6	1069	104	10.2788461538462	0.605750046692556	0.605750046692556	false	false	false	true
54b150a8-1e72-44ac-a882-36d2c3055e01	2026-09-17 13:22	2026-09-17 13:21	2026-09-17 13:21	IOT	IOT261218C00037000	call	37.0000	2026-12-18	6.4000	6.4000	7.5000	39.8400	128000.00	0.00	128000.00	200	5	200	250	0.8	0.604020532594313	0.604020532594313	false	false	false	true	false
8c71e5ad-989e-4c58-bbd6-b53761948ca7	2026-09-17 13:07	2026-09-17 13:07	2026-09-17 13:07	IOT	IOT261016C00041000	call	41.0000	2026-10-16	2.0000	1.9000	2.0000	39.7700	10000.00	10000.00	0.00	50	6	73	593	0.123102866779089	0.554688390109627	0.554688390109627	false	false	false	true
5beb4948-8b1e-4d91-b118-44c52999297d	2026-09-15 12:00	2026-09-15 11:59	2026-09-15 11:59	IOT	IOT261218P00038000	put	38.0000	2026-12-18	2.9000	2.8000	2.9000	42.7100	12470.00	12470.00	0.00	43	18	44	318	0.138364779874214	0.624878703805185	0.624878703805185	false	false	false	true
5bac5272-53b8-4992-bc10-25bd1087a175	2026-09-15 10:13	2026-09-15 10:13	2026-09-15 10:13	IOT	IOT270115P00043000	put	43.0000	2027-01-15	6.0000	5.4000	6.1000	41.8800	19800.00	4200.00	15600.00	33	5	33	47	0.702127659574468	0.592880589353581	0.592880589353581	false	false	false	true
74d29276-0d77-4b03-96d4-97fe8155f9ef	2026-09-14 13:23	2026-09-14 13:23	2026-09-14 13:23	IOT	IOT261120C00040000	call	40.0000	2026-11-20	5.4000	5.3000	5.5000	42.3300	14043.00	0.00	10803.00	26	6	88	139	0.633093525179856	0.567877081251263	0.566912502459846	false	false	false	true
e7fa9f2c-aa84-435f-8b25-ef18cb3a4e73	2026-09-11 10:36	2026-09-11 10:36	2026-09-11 10:36	IOT	IOT261218C00039000	call	39.0000	2026-12-18	5.0000	4.7000	5.1000	38.7300	10500.00	2500.00	8000.00	21	6	24	29	0.827586206896552	0.618495084118338	0.618495084118338	false	false	false	true
bc7111e9-bdf2-45dd-ad5a-9452b96b644f	2026-09-11 10:30	2026-09-11 10:30	2026-09-11 10:30	IOT	IOT261218P00035000	put	35.0000	2026-12-18	2.9500	2.5500	3.1000	38.5300	39825.00	1770.00	38055.00	135	10	135	835	0.161676646706587	0.61789799480892	0.61789799480892	false	false	false	true
c8797e1f-675f-4014-ad14-141940226383	2026-09-09 14:44	2026-09-09 14:44	2026-09-09 14:44	IOT	IOT261002C00039000	call	39.0000	2026-10-02	2.0900	2.0000	2.1000	38.6200	12540.00	12540.00	0.00	60	5	104	114	0.912280701754386	0.575038588615079	0.575038588615079	false	false	false	true
f0edb64d-96e4-430b-9fe8-662705845864	2026-09-09 11:17	2026-09-09 11:17	2026-09-09 11:17	IOT	IOT261218P00038000	put	38.0000	2026-12-18	4.7000	4.4000	4.8000	38.1000	125485.00	84595.00	40890.00	267	37	267	82	3.25609756097561	0.630831965151362	0.629758762968188	false	false	false	true
6e79683b-2e7e-4111-a9f0-0b83591dfd31	2026-09-09 10:57	2026-09-09 10:57	2026-09-09 10:57	IOT	IOT261009P00039000	put	39.0000	2026-10-09	3.0000	3.0000	3.2000	37.9700	12000.00	0.00	12000.00	40	11	41	2	20.5	0.574088895644696	0.574088895644696	true	false	false	true	false
83758625-598a-4a7f-8e66-45747fc8fe76	2026-09-09 10:50	2026-09-09 10:50	2026-09-09 10:50	IOT	IOT261218P00034000	put	34.0000	2026-12-18	2.7000	2.6000	2.7000	38.1800	41580.00	41580.00	0.00	154	19	159	29	5.48275862068965	0.620307206424024	0.620307206424024	false	false	false	true
0bd6f8d9-06b7-432b-b329-131fae7b4e1c	2026-09-08 13:27	2026-09-08 13:27	2026-09-08 13:27	IOT	IOT261120C00047000	call	47.0000	2026-11-20	1.6000	1.5500	1.6000	39.5900	29920.00	29920.00	0.00	187	27	207	1550	0.133548387096774	0.551165393996765	0.551165393996765	false	false	false	true
51795d2a-c354-420f-8359-adaa1a2ceb0b	2026-09-08 11:36	2026-09-08 11:36	2026-09-08 11:36	IOT	IOT260918P00040000	put	40.0000	2026-09-18	1.7000	1.5500	1.7000	39.7400	76310.00	76310.00	0.00	449	37	463	282	1.64184397163121	0.603877057529448	0.603877057529448	false	false	false	true
26f5327a-5db0-4774-b887-7542e2d1b946	2026-09-08 10:41	2026-09-08 10:41	2026-09-08 10:41	IOT	IOT260911C00040000	call	40.0000	2026-09-11	1.0500	1.0500	1.2500	40.1200	34970.00	110.00	34860.00	333	19	522	2088	0.25	0.678214910958531	0.712794233908778	false	false	false	true	false
2086ced9-b966-4a1c-aecd-d95735b41cac	2026-09-08 09:50	2026-09-08 09:50	2026-09-08 09:50	IOT	IOT261218C00047000	call	47.0000	2026-12-18	2.9000	2.1000	3.1000	40.3600	16525.00	580.00	15945.00	57	9	57	218	0.261467889908257	0.600155861627119	0.592091794316337	false	false	false	true
9ee12355-bb49-4b24-9494-b56a4f4cbcc0	2026-09-04 13:42	2026-09-04 13:42	2026-09-04 13:42	IOT	IOT260904C00039500	call	39.5000	2026-09-04	0.3500	0.2000	0.3500	39.4350	31102.00	31102.00	0.00	889	44	1063	205	5.18536585365854	1.49771773119542	1.49771773119542	false	false	false	true
1a23d2bb-abe5-47b1-8723-c2a4c319c204	2026-09-04 13:20	2026-09-04 13:20	2026-09-04 13:20	IOT	IOT270416C00045000	call	45.0000	2027-04-16	5.6000	5.6000	6.5000	39.6150	892080.00	0.00	892080.00	1593	34	2407	6	401.166666666667	0.583528026134424	0.583528026134424	false	false	false	true
455847e1-bb3b-4894-a235-a149fe32e0c4	2026-09-04 12:53	2026-09-04 12:53	2026-09-04 12:53	IOT	IOT270115P00040000	put	40.0000	2027-01-15	5.3000	5.1000	5.4000	40.0000	11130.00	3710.00	7420.00	21	6	41	131	0.312977099236641	0.586623912495622	0.586623912495622	false	false	false	true
dcf0ca91-b794-4f0d-a889-b67873df0985	2026-09-04 12:20	2026-09-04 12:20	2026-09-04 12:20	IOT	IOT260904C00041000	call	41.0000	2026-09-04	0.3000	0.3000	0.5500	40.6125	22530.00	0.00	22530.00	751	39	2989	207	14.43961352657	1.40704970895696	1.40704970895696	false	false	false	true
6f7eba7d-852a-47e3-acc4-b3d6e82d7665	2026-09-04 12:16	2026-09-04 12:16	2026-09-04 12:16	IOT	IOT261016C00043000	call	43.0000	2026-10-16	2.1400	2.0000	2.1500	40.7600	10704.00	10704.00	0.00	50	9	380	283	1.34275618374558	0.53930237641858	0.53930237641858	false	false	false	true
6c61da31-3b37-4e19-8024-1bf09e3635f1	2026-09-04 12:05	2026-09-04 12:05	2026-09-04 12:05	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.4000	6.5000	41.1050	40300.00	40300.00	0.00	62	12	764	6	127.333333333333	0.593526241944574	0.593526241944574	false	false	false	true
549f840a-9166-48b4-b45c-83ecb72874c0	2026-09-04 12:05	2026-09-04 12:05	2026-09-04 12:05	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.4000	6.5000	41.1000	29900.00	29900.00	0.00	46	8	690	6	115	0.593736004152921	0.593736004152921	false	false	false	true	false
0bde0c62-5648-4d02-baa9-f92ad2725399	2026-09-04 12:05	2026-09-04 12:05	2026-09-04 12:05	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.4000	6.5000	41.0450	27950.00	27950.00	0.00	43	7	628	6	104.666666666667	0.596043584048211	0.596043584048211	false	false	false	true
1f03cb46-3b18-4da7-96ab-1dae5a6604ae	2026-09-04 12:05	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.4000	6.5000	41.0600	37050.00	37050.00	0.00	57	11	585	6	97.5	0.59541420760196	0.59541420760196	false	false	false	true	false
8ffabe5a-ffb8-4804-a102-237d3ccbb20e	2026-09-04 12:04	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT260904C00041000	call	41.0000	2026-09-04	0.6000	0.3500	0.6500	41.0300	29982.00	10542.00	19440.00	500	33	2219	207	10.719806763285	1.77304847315209	1.68863769265808	false	false	false	true
6c9d8527-b42d-4760-bbfd-02b71f20ac45	2026-09-04 12:04	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.4000	6.5000	41.0300	33150.00	33150.00	0.00	51	9	490	6	81.6666666666667	0.599085982972688	0.596672988909449	false	false	false	true
be7e76de-306c-46c9-884c-62eb6257c700	2026-09-04 12:04	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.4000	6.5000	40.9950	33150.00	33150.00	0.00	51	9	363	6	60.5	0.597931886588112	0.59814171456169	false	false	false	true	false
aebe2327-bd4d-4684-9ad7-31c31e08426b	2026-09-04 12:04	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.3000	6.5000	41.0000	26000.00	26000.00	0.00	40	8	312	6	52	0.597931886588112	0.597931886588112	false	false	false	true	false
adf83ed2-a1ae-487a-9d4f-67679891a007	2026-09-04 12:04	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.3000	6.5000	40.9100	33150.00	33150.00	0.00	51	9	272	6	45.3333333333333	0.601709331767837	0.601709331767837	false	false	false	true
065207bf-0109-442a-b724-82566768aae1	2026-09-04 12:04	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT260904C00041000	call	41.0000	2026-09-04	0.5000	0.3500	0.5000	40.9100	37480.00	30030.00	0.00	750	46	1719	207	8.30434782608696	1.57153328543807	1.57158896563108	false	false	false	true
ba15fa3a-1d99-4046-b0cb-3209dd83e1e7	2026-09-04 12:04	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.3000	6.5000	40.9050	33150.00	33150.00	0.00	51	9	221	6	36.8333333333333	0.601919224877095	0.601919224877095	false	false	false	true
254c1585-6dc5-444b-8bb8-53f8d6d3aa3b	2026-09-04 12:03	2026-09-04 12:03	2026-09-04 12:03	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	5.8000	6.5000	40.8500	109850.00	109850.00	0.00	169	36	170	6	28.3333333333333	0.604560017409903	0.604228308786983	false	false	false	true
90c5b2bd-14d9-4c04-970f-d3ce2364d7f6	2026-09-04 11:13	2026-09-04 11:13	2026-09-04 11:13	IOT	IOT261016C00043000	call	43.0000	2026-10-16	1.9400	1.7500	2.1000	40.4631	58180.00	58180.00	0.00	300	6	315	283	1.113074204947	0.529076385623426	0.529076385623426	false	false	false	true
929e2ff2-ea19-4971-a72a-51e6986106a5	2026-09-04 10:42	2026-09-04 10:42	2026-09-04 10:42	IOT	IOT260911C00037000	call	37.0000	2026-09-11	4.0000	3.6000	4.6000	40.7500	24000.00	0.00	24000.00	60	6	70	38	1.84210526315789	0.627710968477083	0.627710968477083	false	false	false	true
abc003e9-474f-427a-a517-027340c4d8b1	2026-09-04 09:43	2026-09-04 09:43	2026-09-04 09:43	IOT	IOT260904C00043000	call	43.0000	2026-09-04	0.3000	0.2500	0.7500	41.4800	22517.00	150.00	22367.00	750	26	1597	504	3.16865079365079	1.890956911339	1.890956911339	false	false	false	true
c230f234-1a4b-4cda-9e1a-a19d99bc2996	2026-09-04 09:37	2026-09-04 09:37	2026-09-04 09:37	IOT	IOT260904C00043000	call	43.0000	2026-09-04	0.7700	0.4000	0.8500	42.2700	57677.00	57677.00	0.00	750	5	812	504	1.61111111111111	2.54079477413723	2.23168165424719	false	false	false	true
72a995d1-2241-49ef-badd-d9539b3bab39	2026-09-04 09:36	2026-09-04 09:36	2026-09-04 09:36	IOT	IOT260918C00038500	call	38.5000	2026-09-18	3.2000	3.2000	4.0000	41.5900	20800.00	0.00	20800.00	65	5	72	431	0.167053364269142	0.259663432408461	0.259663432408461	false	false	false	true
5b4f02a3-1e82-4fc8-8a86-6b55dc866a5a	2026-09-04 09:31	2026-09-04 09:31	2026-09-04 09:31	IOT	IOT260904C00040000	call	40.0000	2026-09-04	4.0900	3.6000	4.1000	43.8475	28660.00	28660.00	0.00	70	24	106	2265	0.0467991169977925	2.68184611407575	3.11697232779823	false	false	false	true
bda1a010-c8da-4c8d-80ec-d7966e9aded3	2026-09-03 15:57	2026-09-03 15:57	2026-09-03 15:57	IOT	IOT260904C00042000	call	42.0000	2026-09-04	1.3000	1.2000	1.4500	38.7200	26260.00	20670.00	5590.00	202	14	2050	218	9.40366972477064	3.11205292592676	3.11205292592676	false	false	false	true
2c16d88f-1b07-433f-8240-c278b209f03e	2026-09-03 15:53	2026-09-03 15:53	2026-09-03 15:53	IOT	IOT260911C00040000	call	40.0000	2026-09-11	2.2600	2.1000	2.3000	38.6800	22580.00	22580.00	0.00	100	5	3281	81	40.5061728395062	1.24970790307245	1.22773889794874	false	false	false	true
eada9310-cfda-4b74-bb39-f839710cae8d	2026-09-03 15:52	2026-09-03 15:52	2026-09-03 15:52	IOT	IOT260904C00040000	call	40.0000	2026-09-04	1.9700	1.8500	2.0000	38.6700	14795.00	10200.00	4595.00	75	6	2303	94	24.5	3.05628690023428	3.18109792285459	true	false	false	true	false
472601e4-d00d-46cc-aeaf-5cf923ad6a0d	2026-09-03 15:45	2026-09-03 15:44	2026-09-03 15:44	IOT	IOT260904C00042000	call	42.0000	2026-09-04	1.1300	1.0000	1.1500	38.4400	31165.00	31165.00	0.00	276	9	1674	218	7.67889908256881	2.96192198220906	3.0320060074986	false	false	false	true