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

bdff35e6-a03c-46a3-9bf4-17b3a3830e7d	2026-09-28 12:24	2026-09-28 12:24	2026-09-28 12:24	IBIT	IBIT261002P00047000	put	47.0000	2026-10-02	0.5100	0.5100	0.5200	47.4900	25699.00	10348.00	15351.00	500	21	2043	7642	0.267338393090814	0.373847841719572	0.379112702814834	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-28T16:25:44.498264Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
f1adbe72-5977-456d-b805-707532001cbe	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	IBIT	IBIT261002C00049000	call	49.0000	2026-10-02	0.2400	0.2300	0.2400	47.4500	18936.00	18936.00	0.00	789	39	4556	18009	0.25298461880171	0.385598789396698	0.385598789396698	false	false	false
bfde7b4b-5cb7-487d-bf4d-4ae7db0746bb	2026-09-28 12:22	2026-09-28 12:22	2026-09-28 12:22	IBIT	IBIT260930P00047500	put	47.5000	2026-09-30	0.5500	0.5400	0.5500	47.4200	22000.00	22000.00	0.00	400	28	935	894	1.04586129753915	0.367154880313747	0.367154880313747	false	false	false	true
b7bb310d-4072-4d6c-9386-c24658e62ce7	2026-09-28 12:21	2026-09-28 12:21	2026-09-28 12:21	IBIT	IBIT281215P00025000	put	25.0000	2028-12-15	2.5700	2.5600	2.7300	47.4300	35981.00	257.00	11052.00	140	5	140	2580	0.0542635658914729	0.556413582327315	0.556492996291292	false	false	false	true
37ad4f61-3405-4b83-8332-77cb432c7988	2026-09-28 12:15	2026-09-28 12:15	2026-09-28 12:15	IBIT	IBIT261120C00057000	call	57.0000	2026-11-20	0.4800	0.4800	0.4900	47.2160	11040.00	0.00	11040.00	230	14	1589	35581	0.0446586661420421	0.40885088204433	0.40885088204433	false	false	false
300f86f5-bf27-4855-a385-1ad41143e478	2026-09-28 12:07	2026-09-28 12:07	2026-09-28 12:07	IBIT	IBIT261120C00044000	call	44.0000	2026-11-20	4.8000	4.8000	4.8500	47.1800	24000.00	0.00	24000.00	50	10	3446	6120	0.563071895424837	0.396770440247728	0.396770440247728	false	false	false	true
85461fe2-9f70-4b61-9ddc-3156e25fb90b	2026-09-28 11:55	2026-09-28 11:55	2026-09-28 11:55	IBIT	IBIT261002C00047000	call	47.0000	2026-10-02	0.8700	0.8600	0.8700	47.1768	30102.00	30102.00	0.00	346	5	1027	2452	0.41884176182708	0.390211531655079	0.390211531655079	true	false	false	true
554b1a48-3845-41d5-8984-a68c4e3bf93d	2026-09-28 11:53	2026-09-28 11:53	2026-09-28 11:53	IBIT	IBIT261120C00055000	call	55.0000	2026-11-20	0.6700	0.6600	0.6700	47.1150	40602.00	40602.00	0.00	606	32	1776	12951	0.13713226777855	0.399105924532222	0.399105924532222	false	false	false
ebcfe853-ee8c-4413-adb9-3816abb6ef12	2026-09-28 11:43	2026-09-28 11:43	2026-09-28 11:43	IBIT	IBIT261130P00035000	put	35.0000	2026-11-30	0.2700	0.2600	0.2700	47.1050	13311.00	13311.00	0.00	493	24	498	3562	0.139809096013476	0.50196463954819	0.50196463954819	false	false	false	true
cff897aa-8e05-4b4c-9fac-391137e41398	2026-09-28 11:39	2026-09-28 11:39	2026-09-28 11:39	IBIT	IBIT261016P00047000	put	47.0000	2026-10-16	1.3600	1.3500	1.3700	47.1550	10336.00	9792.00	0.00	76	6	1006	2202	0.45685740236149	0.355528206774349	0.355528206774349	false	false	false	true
467b9e81-6e5a-4d0d-93f0-89fa2800ddb0	2026-09-28 11:37	2026-09-28 11:37	2026-09-28 11:37	IBIT	IBIT261130P00043000	put	43.0000	2026-11-30	1.2600	1.2600	1.2700	47.1000	20160.00	0.00	20160.00	160	23	161	4295	0.0374854481955763	0.398263846278271	0.398263846278271	false	false	false	true
836eefdc-316c-4196-9098-7deecaea3eec	2026-09-28 11:35	2026-09-28 11:35	2026-09-28 11:35	IBIT	IBIT260928P00047000	put	47.0000	2026-09-28	0.1600	0.1500	0.1600	47.0350	11200.00	11200.00	0.00	700	48	9621	3853	2.49701531274332	0.421428102675778	0.421428102675778	true	false	false	true
a8d84de2-8623-48fb-ac9c-d26d7589b4f8	2026-09-28 11:33	2026-09-28 11:33	2026-09-28 11:33	IBIT	IBIT261016C00049000	call	49.0000	2026-10-16	0.7700	0.7600	0.7700	47.0300	11858.00	11858.00	0.00	154	7	429	20429	0.0209995594498018	0.359499742193382	0.359499742193382	false	false	false
fe37e3f5-520b-413c-b1f7-271bf4703f8e	2026-09-28 11:28	2026-09-28 11:27	2026-09-28 11:27	IBIT	IBIT270319P00050000	put	50.0000	2027-03-19	6.3000	6.3000	6.4000	47.0000	31500.00	0.00	31500.00	50	6	50	180	0.277777777777778	0.400355177716689	0.400355177716689	false	false	false	true
8538ee25-ca02-4158-a9e3-2a673263cfee	2026-09-28 11:27	2026-09-28 11:27	2026-09-28 11:27	IBIT	IBIT261016P00046500	put	46.5000	2026-10-16	1.2200	1.2100	1.2200	46.9900	16592.00	16592.00	0.00	136	14	683	1097	0.62260711030082	0.361029492605016	0.361029492605016	false	false	false	true
3e0bf8e5-6372-4c79-9c12-33b6a0def60f	2026-09-28 11:24	2026-09-28 11:23	2026-09-28 11:23	IBIT	IBIT271217C00043000	call	43.0000	2027-12-17	12.1000	12.1000	12.3500	46.0000	30251.00	0.00	30251.00	25	7	26	710	0.0366197183098592	0.448422057813113	0.448422057813113	false	false	false
d47a353c-68bf-4b0a-ba5f-3d908ad160c7	2026-09-28 11:22	2026-09-28 11:22	2026-09-28 11:22	IBIT	IBIT261016P00048500	put	48.5000	2026-10-16	2.3800	2.3600	2.3800	46.0000	14518.00	14518.00	0.00	61	13	129	871	0.148105625717566	0.360434382048239	0.360434382048239	true	false	false	true
6ec6651b-8d21-4789-8658-19cc08ce711a	2026-09-28 11:22	2026-09-28 11:22	2026-09-28 11:22	IBIT	IBIT261023P00047000	put	47.0000	2026-10-23	1.7500	1.7400	1.7500	46.0000	11725.00	11725.00	0.00	67	7	236	658	0.358662613981763	0.362137688706817	0.362137688706817	true	false	false	true
ff2ab479-e60f-485a-965e-b10a32a14fe7	2026-09-28 11:21	2026-09-28 11:21	2026-09-28 11:21	IBIT	IBIT261009P00044500	put	44.5000	2026-10-09	0.3500	0.3400	0.3500	46.0000	17570.00	17570.00	0.00	502	22	595	1632	0.364583333333333	0.378035018884587	0.378035018884587	false	false	false	true
c5fb2a2b-8683-49e9-8c48-6f721db2c49e	2026-09-28 11:20	2026-09-28 11:20	2026-09-28 11:20	IBIT	IBIT261130P00030000	put	30.0000	2026-11-30	0.1500	0.1500	0.1700	46.0000	14325.00	0.00	14325.00	955	44	1580	5214	0.303030303030303	0.620733859753679	0.620733859753679	false	false	false	true
2fb1c5a5-cb72-4043-ad28-7f382953f7e0	2026-09-28 11:17	2026-09-28 11:17	2026-09-28 11:17	IBIT	IBIT260930P00046500	put	46.5000	2026-09-30	0.3500	0.3400	0.3500	46.0000	17500.00	17500.00	0.00	500	32	1689	2125	0.794823529411765	0.387254097180088	0.387254097180088	false	false	false	true
6a1e133d-0211-43ff-a6e6-3ac3b89feaa4	2026-09-28 11:16	2026-09-28 11:16	2026-09-28 11:16	IBIT	IBIT270319P00033000	put	33.0000	2027-03-19	0.7200	0.7000	0.7250	46.0000	16200.00	16200.00	0.00	225	23	225	1404	0.16025641025641	0.461123507614603	0.461123507614603	false	false	false	true
554b1209-99d2-47e9-ad7b-205871502838	2026-09-28 11:14	2026-09-28 11:13	2026-09-28 11:13	IBIT	IBIT261016P00046000	put	46.0000	2026-10-16	1.0300	1.0200	1.0400	46.0000	10506.00	9888.00	0.00	102	11	707	13810	0.0511947863866763	0.365530909871803	0.365530909871803	false	false	false	true
68639b71-52ae-4961-b332-2739ddd7fddc	2026-09-28 11:13	2026-09-28 11:13	2026-09-28 11:13	IBIT	IBIT261009C00047500	call	47.5000	2026-10-09	0.9800	0.9700	0.9800	46.0000	11858.00	11858.00	0.00	121	17	2086	3818	0.546359350445259	0.365434618283874	0.365434618283874	false	false	false
e773b654-daa3-44cb-86a7-1e81767e6e73	2026-09-28 11:13	2026-09-28 11:13	2026-09-28 11:13	IBIT	IBIT261012C00049000	call	49.0000	2026-10-12	0.5900	0.5800	0.6300	46.9900	22243.00	13275.00	8968.00	377	7	382	0	0	0.358011892193436	0.358011892193436	false	false	false	true
878e28ab-eae5-468b-bdcd-604761b755df	2026-09-28 11:13	2026-09-28 11:13	2026-09-28 11:13	IBIT	IBIT261030C00050000	call	50.0000	2026-10-30	1.0300	1.0300	1.0500	46.9900	18025.00	0.00	18025.00	175	18	558	7094	0.0786580208627009	0.377152216998331	0.377152216998331	false	false	false
0f174c95-afcf-4c91-9c7c-b4fdc8ae0361	2026-09-28 11:12	2026-09-28 11:12	2026-09-28 11:12	IBIT	IBIT261120P00035000	put	35.0000	2026-11-20	0.2500	0.2500	0.2600	46.9551	15000.00	0.00	15000.00	600	19	932	22785	0.0409041035769146	0.531708402409913	0.531708402409913	false	false	false	true
9520c510-2f6a-4471-92a8-91601ecf330a	2026-09-28 11:11	2026-09-28 11:11	2026-09-28 11:11	IBIT	IBIT261023C00055000	call	55.0000	2026-10-23	0.1500	0.1500	0.1600	47.0450	12915.00	0.00	12915.00	861	26	1629	2056	0.792315175097276	0.38965581682054	0.38965581682054	false	false	false	true
32ae1c6b-acb0-46ad-b553-0c0bb205b242	2026-09-28 11:10	2026-09-28 11:10	2026-09-28 11:10	IBIT	IBIT261218C00050000	call	50.0000	2026-12-18	2.5500	2.5200	2.5500	47.1250	10200.00	10200.00	0.00	40	7	482	34777	0.0138597348822498	0.40001265160306	0.40001265160306	false	false	false	true
01d3117c-896e-4471-a336-46c350d70226	2026-09-28 11:09	2026-09-28 11:09	2026-09-28 11:09	IBIT	IBIT261106C00050000	call	50.0000	2026-11-06	1.3700	1.2900	1.3700	47.0250	13700.00	13700.00	0.00	100	6	127	139	0.913669064748201	0.39794888182346	0.39794888182346	false	false	false	true
434296f7-219e-435e-a7c8-e763077ef1dd	2026-09-28 11:06	2026-09-28 11:06	2026-09-28 11:06	IBIT	IBIT261016C00052000	call	52.0000	2026-10-16	0.2400	0.2400	0.2500	46.9900	11760.00	0.00	11760.00	490	10	565	14643	0.0385849894147374	0.377737314162542	0.377737314162542	false	false	false
88a1172c-62fc-42fc-8863-86ea83e97b27	2026-09-28 11:01	2026-09-28 11:01	2026-09-28 11:01	IBIT	IBIT261016C00048000	call	48.0000	2026-10-16	1.1300	1.1200	1.1300	46.9850	11300.00	11300.00	0.00	100	13	1539	54455	0.0282618675970985	0.368024727188876	0.368024727188876	true	false	false
dbe3da3a-8e2b-4237-ab48-eb9185c54aea	2026-09-28 10:56	2026-09-28 10:56	2026-09-28 10:56	IBIT	IBIT261030P00042500	put	42.5000	2026-10-30	0.5700	0.5600	0.5800	46.8800	22629.00	22401.00	0.00	397	11	431	2873	0.150017403411069	0.399972259703218	0.399972259703218	true	false	false	true
d4eba9b9-1fa5-4890-b777-f4dd39219a15	2026-09-28 10:53	2026-09-28 10:53	2026-09-28 10:53	IBIT	IBIT280616C00050000	call	50.0000	2028-06-16	11.7000	11.5500	11.9500	46.7101	35100.00	0.00	32760.00	30	6	73	8190	0.00891330891330891	0.475252537302387	0.476097393462244	false	false	false
4f9d95c5-70b0-4d20-a0d8-5c4e12dce51e	2026-09-28 10:52	2026-09-28 10:52	2026-09-28 10:52	IBIT	IBIT261023C00044000	call	44.0000	2026-10-23	3.6000	3.6000	3.7000	46.8199	36005.00	0.00	35640.00	100	6	101	1554	0.064993564993565	0.369854743145128	0.382996295860196	false	false	false	true
d9fc271f-4398-437c-874e-6f9188a582dd	2026-09-28 10:51	2026-09-28 10:51	2026-09-28 10:51	IBIT	IBIT261218P00035000	put	35.0000	2026-12-18	0.4000	0.3800	0.4000	46.9184	32880.00	32880.00	0.00	822	42	824	22974	0.035866631844694	0.485990002639027	0.485990002639027	false	false	false	true
af08be86-5c61-4f51-9308-67cbb0f52df1	2026-09-28 10:50	2026-09-28 10:50	2026-09-28 10:50	IBIT	IBIT261002C00047500	call	47.5000	2026-10-02	0.5700	0.5700	0.5800	46.9680	12711.00	0.00	12711.00	223	24	2462	13062	0.188485683662533	0.405491531309241	0.405491531309241	false	false	false
6f240751-4579-427b-b4a2-d67fd00df124	2026-09-28 10:48	2026-09-28 10:48	2026-09-28 10:48	IBIT	IBIT261002C00047500	call	47.5000	2026-10-02	0.5600	0.5400	0.5600	46.0000	19824.00	19824.00	0.00	354	20	2237	13062	0.171260143928954	0.409363647291911	0.409363647291911	false	false	false
581d56f8-0d3c-4649-b0e9-0b1938c3bac6	2026-09-28 10:48	2026-09-28 10:48	2026-09-28 10:48	IBIT	IBIT270319P00035000	put	35.0000	2027-03-19	0.9500	0.9200	0.9500	46.0000	19000.00	19000.00	0.00	200	21	200	18128	0.0110326566637246	0.441940014566333	0.441940014566333	false	false	false	true
3cff3dbc-0551-45c5-bc28-c2074dab7452	2026-09-28 10:47	2026-09-28 10:47	2026-09-28 10:47	IBIT	IBIT270115C00050000	call	50.0000	2027-01-15	3.0500	3.0500	3.1000	46.9400	30500.00	0.00	30500.00	100	5	711	58906	0.0120700777509931	0.395990387929714	0.395990387929714	false	false	false
320e548b-f702-4d6d-a37e-320db389f1aa	2026-09-28 10:47	2026-09-28 10:47	2026-09-28 10:47	IBIT	IBIT270219P00039000	put	39.0000	2027-02-19	1.4200	1.3900	1.4200	46.9400	39902.00	39902.00	0.00	281	32	353	221	1.5972850678733	0.420304876804716	0.420304876804716	false	false	false	true
5f1700d3-28a1-4980-bd19-8d8de6d89b1d	2026-09-28 10:47	2026-09-28 10:47	2026-09-28 10:47	IBIT	IBIT270115C00050000	call	50.0000	2027-01-15	3.0500	3.0500	3.1000	46.9382	30500.00	0.00	30500.00	100	6	611	58906	0.0103724578141446	0.396070264841139	0.396070264841139	false	false	false
4e16c5e1-7bfa-4a53-b63b-ff6b04f60dd5	2026-09-28 10:46	2026-09-28 10:46	2026-09-28 10:46	IBIT	IBIT261218C00051000	call	51.0000	2026-12-18	2.1200	2.1200	2.1500	46.0000	26076.00	0.00	26076.00	123	11	228	11028	0.0206746463547334	0.39684227524769	0.39684227524769	false	false	false
69839de0-8464-40da-ade0-73553c4bde99	2026-09-28 10:46	2026-09-28 10:46	2026-09-28 10:46	IBIT	IBIT261002C00047500	call	47.5000	2026-10-02	0.5600	0.5600	0.5700	46.0000	10584.00	0.00	10584.00	189	20	1860	13062	0.142397795130914	0.406194752735785	0.406194752735785	false	false	false
234d2be4-a04c-4abf-89ae-321a2f86c533	2026-09-28 10:46	2026-09-28 10:46	2026-09-28 10:46	IBIT	IBIT261002C00047500	call	47.5000	2026-10-02	0.5600	0.5600	0.5700	46.0000	14112.00	0.00	14112.00	252	12	1671	13062	0.127928341754708	0.406194752735785	0.406194752735785	false	false	false
8d308455-86a4-43e8-8cb2-2d52ef7539a0	2026-09-28 10:44	2026-09-28 10:44	2026-09-28 10:44	IBIT	IBIT261218P00048000	put	48.0000	2026-12-18	3.8100	3.8000	3.8500	46.9200	76122.00	0.00	76122.00	200	8	201	1409	0.142654364797729	0.392093342450035	0.392093342450035	false	false	false	true
a2fa213b-ed52-45cd-b17f-b2cc49bb6321	2026-09-28 10:43	2026-09-28 10:43	2026-09-28 10:43	IBIT	IBIT261120C00052000	call	52.0000	2026-11-20	1.1900	1.1700	1.2000	46.9900	17925.00	10190.00	7735.00	150	9	327	9361	0.034932165366948	0.39591400392641	0.39591400392641	false	false	false
ae79cd7c-1426-4d52-9c30-b66edf9e8bb7	2026-09-28 10:43	2026-09-28 10:43	2026-09-28 10:43	IBIT	IBIT270115C00050000	call	50.0000	2027-01-15	3.0500	3.0500	3.1000	46.9450	30500.00	0.00	30500.00	100	12	340	58906	0.00577190778528503	0.395768489362203	0.395768489362203	false	false	false
46fd77b1-c4ee-45ea-b86e-2a5c78b0ec5a	2026-09-28 10:43	2026-09-28 10:43	2026-09-28 10:43	IBIT	IBIT261002P00047500	put	47.5000	2026-10-02	1.0600	1.0500	1.0700	46.9800	11024.00	10918.00	0.00	104	8	499	12864	0.0387904228855721	0.398227473670515	0.398227473670515	false	false	false	true
50f8c97e-0c52-4135-9fca-e9426efac9fe	2026-09-28 10:43	2026-09-28 10:43	2026-09-28 10:43	IBIT	IBIT261016P00045500	put	45.5000	2026-10-16	0.8500	0.8400	0.8600	46.9900	11390.00	10710.00	0.00	134	11	293	1093	0.268069533394328	0.369199005179462	0.369199005179462	true	false	false	true