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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = IBIT×

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

de869174-4aec-4add-9fee-d26b9b31b807	2026-09-28 15:03	2026-09-28 15:03	2026-09-28 15:03	IBIT	IBIT270115P00047000	put	47.0000	2027-01-15	3.5500	3.5000	3.5500	47.4750	44375.00	44375.00	0.00	125	18	151	2582	0.0584817970565453	0.398161632136783	0.398161632136783	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	64762757065.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T19:04:54.976253Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
046bc39a-c9a7-44d1-9a1c-629babcf5033	2026-09-28 15:01	2026-09-28 15:01	2026-09-28 15:01	IBIT	IBIT261218C00055000	call	55.0000	2026-12-18	1.3200	1.3000	1.3200	47.5033	21384.00	21384.00	0.00	162	5	1811	54881	0.0329986698493103	0.402289819841	0.402289819841	false	false	false	true
0571bcbe-4051-4991-ae49-9396a817b158	2026-09-28 15:00	2026-09-28 15:00	2026-09-28 15:00	IBIT	IBIT261005C00050000	call	50.0000	2026-10-05	0.1900	0.1800	0.1900	47.5600	47500.00	47500.00	0.00	2500	35	3577	4723	0.757357611687487	0.34949757564836	0.34949757564836	false	false	false	true
548e08ce-73b7-4979-9a5a-2aef6b11cf2f	2026-09-28 14:59	2026-09-28 14:59	2026-09-28 14:59	IBIT	IBIT261218C00050000	call	50.0000	2026-12-18	2.7200	2.7100	2.7200	47.5768	54400.00	54400.00	0.00	200	12	983	34777	0.0282658078615177	0.396643812650247	0.396643812650247	false	false	false
524a7f58-9085-45fd-b824-c4347f43f5f0	2026-09-28 14:59	2026-09-28 14:59	2026-09-28 14:59	IBIT	IBIT261120P00040000	put	40.0000	2026-11-20	0.5100	0.5000	0.5200	47.5700	10098.00	0.00	10047.00	198	32	1088	38169	0.0285048075663497	0.434740661288742	0.434740661288742	false	false	false	true
d397355f-adec-41a0-b2b8-a1dd7d0e4ff3	2026-09-28 14:59	2026-09-28 14:59	2026-09-28 14:59	IBIT	IBIT261120P00046000	put	46.0000	2026-11-20	1.9200	1.9100	1.9200	47.5700	24000.00	24000.00	0.00	125	8	1426	2282	0.624890446976337	0.387695703621796	0.387695703621796	false	false	false	true
23042823-1780-41a5-8ec8-8493fcae29cc	2026-09-28 14:53	2026-09-28 14:52	2026-09-28 14:52	IBIT	IBIT261120C00050000	call	50.0000	2026-11-20	1.9100	1.8900	1.9100	47.5350	21965.00	21965.00	0.00	115	6	2552	25987	0.09820294762766	0.387614448746713	0.387614448746713	false	false	false	true
f5ddf662-b53a-4109-9ac2-5f3e70118339	2026-09-28 14:52	2026-09-28 14:52	2026-09-28 14:52	IBIT	IBIT261120C00050000	call	50.0000	2026-11-20	1.9000	1.8900	1.9000	47.5350	30210.00	30210.00	0.00	159	16	2247	25987	0.086466310078116	0.38619422605622	0.38619422605622	false	false	false	true
a5eeb03d-83a7-4e31-aa6a-565da12cc425	2026-09-28 14:52	2026-09-28 14:52	2026-09-28 14:52	IBIT	IBIT261120C00050000	call	50.0000	2026-11-20	1.9000	1.8900	1.9000	47.5350	18050.00	18050.00	0.00	95	6	2437	25987	0.0937776580597991	0.38619422605622	0.38619422605622	false	false	false	true
1b3770a3-8bd0-4f00-9789-e7c664d7f530	2026-09-28 14:52	2026-09-28 14:52	2026-09-28 14:52	IBIT	IBIT261120C00050000	call	50.0000	2026-11-20	1.9000	1.8900	1.9000	47.5350	17860.00	17860.00	0.00	94	10	2341	25987	0.0900835032901066	0.38619422605622	0.38619422605622	false	false	false	true
5c6efa6c-e941-4958-8210-db1caf2c2d95	2026-09-28 14:52	2026-09-28 14:52	2026-09-28 14:52	IBIT	IBIT261120P00036000	put	36.0000	2026-11-20	0.2600	0.2600	0.2700	47.5150	16094.00	0.00	16094.00	619	15	4078	28921	0.14100480619619	0.511593758896868	0.511593758896868	false	false	false	true
938a8f09-c296-4f15-ba8a-397b5cee4466	2026-09-28 14:51	2026-09-28 14:51	2026-09-28 14:51	IBIT	IBIT261120C00052000	call	52.0000	2026-11-20	1.2900	1.2800	1.3000	47.4963	15093.00	13674.00	0.00	117	14	577	9361	0.0616387138126269	0.387683378071834	0.387683378071834	false	false	false
7264fd67-7ea8-4d9e-bb56-2fbf6f2bb4fa	2026-09-28 14:16	2026-09-28 14:16	2026-09-28 14:16	IBIT	IBIT261016C00048000	call	48.0000	2026-10-16	1.3300	1.3300	1.3400	47.5250	12635.00	0.00	12635.00	95	16	2478	54455	0.0455054632265173	0.357817871468544	0.357817871468544	false	false	false
5a0e03a7-2481-4672-bcac-9fb4ec65d6e8	2026-09-28 14:14	2026-09-28 14:14	2026-09-28 14:14	IBIT	IBIT261120C00053000	call	53.0000	2026-11-20	1.0600	1.0600	1.0800	47.5326	11130.00	0.00	11130.00	105	11	303	9171	0.033038927052666	0.387303883148865	0.387303883148865	false	false	false
a7d422f2-3fd3-4f23-8976-768036a964c3	2026-09-28 14:06	2026-09-28 14:06	2026-09-28 14:06	IBIT	IBIT261023C00048500	call	48.5000	2026-10-23	1.4100	1.3900	1.4300	47.0000	84600.00	37224.00	47376.00	600	37	925	2805	0.329768270944742	0.360030804956154	0.360030804956154	false	false	false
db1f0f25-9f71-46a4-a079-7d1f7a94e840	2026-09-28 14:06	2026-09-28 14:05	2026-09-28 14:05	IBIT	IBIT261023C00048000	call	48.0000	2026-10-23	1.6100	1.5900	1.6200	47.0000	25760.00	20769.00	161.00	160	33	483	1703	0.283617146212566	0.356734041510288	0.356734041510288	false	false	false
ccc73e9f-e81d-4128-a2a2-1a98c153853b	2026-09-28 13:51	2026-09-28 13:51	2026-09-28 13:51	IBIT	IBIT260930P00047500	put	47.5000	2026-09-30	0.4900	0.4900	0.5000	47.4800	24500.00	0.00	24500.00	500	16	4139	894	4.62975391498881	0.346049088821372	0.346049088821372	false	false	false	true
f1f2e986-fca6-4937-b885-73ffabbeaac9	2026-09-28 13:50	2026-09-28 13:50	2026-09-28 13:50	IBIT	IBIT261120P00044000	put	44.0000	2026-11-20	1.2700	1.2500	1.2700	47.5000	12700.00	12700.00	0.00	100	10	4959	18220	0.272173435784852	0.397661853501719	0.397661853501719	false	false	false	true
d7f2a480-bd13-4f68-8007-85b2af1c27c0	2026-09-28 13:42	2026-09-28 13:41	2026-09-28 13:41	IBIT	IBIT270219P00032000	put	32.0000	2027-02-19	0.5000	0.5000	0.5200	47.5501	24150.00	0.00	24150.00	483	23	484	245	1.97551020408163	0.492331391721694	0.492331391721694	false	false	false	true
c24bac23-c205-40ea-a728-9751290c3979	2026-09-28 13:32	2026-09-28 13:32	2026-09-28 13:32	IBIT	IBIT270115P00040000	put	40.0000	2027-01-15	1.2000	1.2000	1.2200	47.5500	11040.00	0.00	11040.00	92	13	347	23646	0.0146747864332234	0.424279717882211	0.424279717882211	false	false	false	true
15932d12-00d1-468a-bbf7-955a4912dde3	2026-09-28 13:30	2026-09-28 13:30	2026-09-28 13:30	IBIT	IBIT270115P00045000	put	45.0000	2027-01-15	2.6600	2.6600	2.6900	47.4950	26334.00	0.00	26334.00	99	9	281	27942	0.0100565457018109	0.401178172154258	0.401178172154258	false	false	false	true
36845b32-f585-41c7-bc31-10ae54251d71	2026-09-28 13:29	2026-09-28 13:29	2026-09-28 13:29	IBIT	IBIT261009C00050000	call	50.0000	2026-10-09	0.3700	0.3600	0.3800	47.5012	17649.00	222.00	17427.00	477	38	2595	4084	0.635406464250735	0.361817347316157	0.361944008292709	false	false	false
15cb8a40-68c6-4dc9-bd2b-a4356fddbdb1	2026-09-28 13:28	2026-09-28 13:28	2026-09-28 13:28	IBIT	IBIT260930C00047500	call	47.5000	2026-09-30	0.5100	0.5000	0.5200	47.4827	45135.00	27744.00	17391.00	885	55	4433	3158	1.40373654211526	0.365284348744299	0.366110483539251	false	false	false
5b9adb76-9c25-4b8f-b97e-a36ffe7bc922	2026-09-28 13:19	2026-09-28 13:19	2026-09-28 13:19	IBIT	IBIT261130P00050000	put	50.0000	2026-11-30	4.2500	4.2000	4.2500	47.5800	74800.00	74800.00	0.00	176	13	200	550	0.363636363636364	0.387123069747249	0.387123069747249	false	false	false	true
b7520283-90b8-4091-a13f-24d4d3f05650	2026-09-28 13:19	2026-09-28 13:19	2026-09-28 13:19	IBIT	IBIT270115P00035000	put	35.0000	2027-01-15	0.5400	0.5300	0.5400	47.5900	78894.00	78894.00	0.00	1461	20	2234	44063	0.0507001338991898	0.473049338399921	0.473049338399921	false	false	false
fee97bee-4f21-47aa-a67f-b20fcf43589e	2026-09-28 13:19	2026-09-28 13:19	2026-09-28 13:19	IBIT	IBIT270115P00035000	put	35.0000	2027-01-15	0.5300	0.5200	0.5400	47.5900	30475.00	0.00	26818.00	575	23	773	44063	0.0175430633411252	0.470583339045063	0.470583339045063	false	false	false	true
12b6f894-c428-453f-9823-12a0f073cff0	2026-09-28 13:17	2026-09-28 13:17	2026-09-28 13:17	IBIT	IBIT290119C00060000	call	60.0000	2029-01-19	12.1000	11.8000	12.1000	47.7250	30250.00	30250.00	0.00	25	5	230	423	0.543735224586288	0.496161488400306	0.496161488400306	false	false	false
c821c2d1-0fa1-4c9c-b069-5dd09fb45ce6	2026-09-28 13:13	2026-09-28 13:13	2026-09-28 13:13	IBIT	IBIT261030P00048000	put	48.0000	2026-10-30	2.1700	2.1500	2.1800	47.6300	13454.00	13237.00	217.00	62	5	232	21725	0.0106789413118527	0.367668051985619	0.367668051985619	false	false	false	true
7d406353-f309-4e3a-9f68-94dd4802cb30	2026-09-28 13:13	2026-09-28 13:13	2026-09-28 13:13	IBIT	IBIT261120P00048000	put	48.0000	2026-11-20	2.8400	2.8200	2.8500	47.6344	12780.00	12496.00	0.00	45	10	123	4250	0.0289411764705882	0.38712693774993	0.38712693774993	false	false	false	true
9bf8869e-e6fb-4112-b405-a242895d6d17	2026-09-28 12:56	2026-09-28 12:56	2026-09-28 12:56	IBIT	IBIT261009C00050000	call	50.0000	2026-10-09	0.3500	0.3400	0.3500	47.3900	18165.00	18165.00	0.00	519	7	2079	4084	0.509059745347698	0.36365882745405	0.36365882745405	false	false	false	true
c5e57641-59e8-42d0-9e00-6bfda5494db0	2026-09-28 12:51	2026-09-28 12:51	2026-09-28 12:51	IBIT	IBIT280616C00100000	call	100.0000	2028-06-16	3.1000	3.0000	3.2000	47.3300	18290.00	0.00	0.00	59	7	306	33782	0.00905807826653247	0.48534390795302	0.48534390795302	false	false	false	true
8168c08e-a40c-48c6-81ad-7a36565b4210	2026-09-28 12:50	2026-09-28 12:50	2026-09-28 12:50	IBIT	IBIT270115P00040000	put	40.0000	2027-01-15	1.2200	1.2200	1.2400	47.3300	15616.00	0.00	15616.00	128	11	248	23646	0.010488031802419	0.421364858683155	0.421364858683155	false	false	false	true
5bb5fdf7-3324-4b41-bdff-d0bac1856fc7	2026-09-28 12:49	2026-09-28 12:49	2026-09-28 12:49	IBIT	IBIT261218C00049000	call	49.0000	2026-12-18	3.0000	3.0000	3.0500	47.3201	15600.00	0.00	15600.00	52	21	554	4455	0.124354657687991	0.397745930021925	0.397745930021925	false	false	false	true
21bdef9e-0ba7-4649-b742-2b78e068602f	2026-09-28 12:43	2026-09-28 12:43	2026-09-28 12:43	IBIT	IBIT261009C00050000	call	50.0000	2026-10-09	0.3400	0.3400	0.3500	47.0000	18190.00	0.00	18190.00	535	24	1560	4084	0.381978452497551	0.360778056524732	0.360778056524732	false	false	false
9b9a0ba2-75e8-4c59-bcf0-fe63ed19c16c	2026-09-28 12:42	2026-09-28 12:42	2026-09-28 12:42	IBIT	IBIT261218P00041000	put	41.0000	2026-12-18	1.0800	1.0800	1.1000	47.0000	11880.00	0.00	11880.00	110	16	323	3636	0.0888338833883388	0.420110828298569	0.420110828298569	false	false	false	true
d9cd46b3-fcfd-44ab-aac7-002d009f778b	2026-09-28 12:41	2026-09-28 12:41	2026-09-28 12:41	IBIT	IBIT270115P00038000	put	38.0000	2027-01-15	0.8700	0.8500	0.8700	47.0000	42630.00	42630.00	0.00	490	25	1131	14579	0.0775773372659305	0.437444048725342	0.437444048725342	false	false	false
271b5b59-27d8-4a0d-b6be-8017019807f5	2026-09-28 12:41	2026-09-28 12:41	2026-09-28 12:41	IBIT	IBIT270115P00037000	put	37.0000	2027-01-15	0.7400	0.7200	0.7400	47.0000	10138.00	10138.00	0.00	137	15	139	10662	0.0130369536672294	0.446962061978674	0.446962061978674	false	false	false	true
0860f512-87d9-4449-9e82-a4a7c0a2a20d	2026-09-28 12:39	2026-09-28 12:39	2026-09-28 12:39	IBIT	IBIT271217C00075000	call	75.0000	2027-12-17	3.4000	3.3000	3.4000	47.4700	35360.00	35360.00	0.00	104	6	225	3178	0.0707992448080554	0.450924215078496	0.450924215078496	false	false	false
265550e1-a13c-4c8a-ba7b-46ceeb399fa3	2026-09-28 12:39	2026-09-28 12:39	2026-09-28 12:39	IBIT	IBIT271217C00041000	call	41.0000	2027-12-17	13.6800	13.6000	13.9500	47.4651	41031.00	0.00	41031.00	30	8	30	312	0.0961538461538462	0.453467904964921	0.460003972889526	false	false	false
933c5c86-f9de-49aa-80c9-55da43e83065	2026-09-28 12:37	2026-09-28 12:36	2026-09-28 12:36	IBIT	IBIT261002C00048500	call	48.5000	2026-10-02	0.3800	0.3700	0.3900	47.5300	33630.00	494.00	11704.00	885	31	3368	11693	0.288035576840845	0.380231012984003	0.380231012984003	false	false	false
4e5ace3f-4a70-43da-a090-64ca568dd8b2	2026-09-28 12:36	2026-09-28 12:36	2026-09-28 12:36	IBIT	IBIT261016P00047000	put	47.0000	2026-10-16	1.2100	1.2000	1.2200	47.5300	10890.00	0.00	847.00	90	5	1141	2202	0.518165304268847	0.358965828886868	0.358965828886868	false	false	false	true
fd01b0f8-41dc-44fd-bb2c-d827e0cc8c11	2026-09-28 12:36	2026-09-28 12:36	2026-09-28 12:36	IBIT	IBIT261218P00042000	put	42.0000	2026-12-18	1.2700	1.2700	1.2800	47.5376	14097.00	0.00	13970.00	111	10	158	13691	0.0115404280184063	0.413799029387129	0.413799029387129	true	false	false	true
88e19e3c-d1e0-4c2d-b594-3ae3e9ac76be	2026-09-28 12:36	2026-09-28 12:36	2026-09-28 12:36	IBIT	IBIT261120C00051000	call	51.0000	2026-11-20	1.6000	1.6000	1.6200	47.5400	16000.00	0.00	16000.00	100	14	832	4383	0.189824321241159	0.389906231971461	0.389906231971461	false	false	false
2265d655-62c0-4a3f-af48-65eea1667f7b	2026-09-28 12:36	2026-09-28 12:36	2026-09-28 12:36	IBIT	IBIT261030P00042500	put	42.5000	2026-10-30	0.4600	0.4600	0.4700	47.5384	18400.00	0.00	18400.00	400	17	831	2873	0.289244691959624	0.399413058045753	0.399413058045753	true	false	false	true
1794140b-0002-46e2-a3e2-8d05350c4f60	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	IBIT	IBIT270115P00036000	put	36.0000	2027-01-15	0.6100	0.5900	0.6100	47.0000	12627.00	12627.00	0.00	207	18	218	3543	0.06152977702512	0.456712918767099	0.456712918767099	false	false	false	true
08c2ed73-bc29-4630-a76b-6b736cd60717	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	IBIT	IBIT270115P00038000	put	38.0000	2027-01-15	0.8400	0.8200	0.8400	47.0000	46872.00	46872.00	0.00	558	29	641	14579	0.0439673502983744	0.436277654681376	0.436277654681376	false	false	false	true
2fd70501-d8d5-4a78-bf6f-79e0b17e5331	2026-09-28 12:27	2026-09-28 12:27	2026-09-28 12:27	IBIT	IBIT261002C00047000	call	47.0000	2026-10-02	1.1300	1.1000	1.1300	47.5977	56500.00	56500.00	0.00	500	7	1994	2452	0.813213703099511	0.396074211137401	0.396074211137401	false	false	false
9290426b-e682-4d84-9746-ea87a773bdfe	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	IBIT	IBIT260928C00047500	call	47.5000	2026-09-28	0.2300	0.2200	0.2400	47.5914	11982.00	11960.00	22.00	521	15	6487	2275	2.85142857142857	0.471705565058075	0.444957326075485	false	false	false
cc4a8672-c31a-4bc6-b010-98baeb8a7500	2026-09-28 12:25	2026-09-28 12:25	2026-09-28 12:25	IBIT	IBIT261016C00047500	call	47.5000	2026-10-16	1.5600	1.5400	1.5600	47.4923	23088.00	23088.00	0.00	148	7	910	743	1.22476446837147	0.360779775575722	0.360779775575722	false	false	false	true
56192dd8-1826-4771-a27e-f23cf7ba64d6	2026-09-28 12:25	2026-09-28 12:24	2026-09-28 12:24	IBIT	IBIT260930C00047500	call	47.5000	2026-09-30	0.5300	0.5200	0.5300	47.5099	15900.00	15900.00	0.00	300	28	2329	3158	0.737492083597213	0.370528260756708	0.370528260756708	false	false	false