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 = HAL×

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

a1b056fc-1f01-4b01-917a-4e6715403696	2026-09-14 12:23	2026-09-14 12:23	2026-09-14 12:23	HAL	HAL260925C00036000	call	36.0000	2026-09-25	0.4600	0.4300	0.4700	34.8350	10166.00	2668.00	4186.00	221	5	248	576	0.430555555555556	0.37278385505512	0.37278385505512	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	29167894149.00	2026-10-20	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
720ad8d7-f247-4e2f-8219-052048bd363c	2026-09-11 15:52	2026-09-11 15:52	2026-09-11 15:52	HAL	HAL261218C00040000	call	40.0000	2026-12-18	1.2700	1.2300	1.2700	35.7400	73533.00	73533.00	0.00	579	39	1357	10087	0.13452959254486	0.358745727943993	0.358745727943993	false	false	false	true	false
b6482cb1-09a6-41d4-9058-7e749c0e5773	2026-09-11 15:51	2026-09-11 15:51	2026-09-11 15:51	HAL	HAL261218C00040000	call	40.0000	2026-12-18	1.2500	1.2300	1.2600	35.7200	90125.00	9375.00	5500.00	721	7	778	10087	0.0771289778923367	0.356942664486656	0.356700763178424	true	false	false	true	false
89cf1cba-b174-4d97-a256-ff7856c5a12a	2026-09-11 13:54	2026-09-11 13:54	2026-09-11 13:54	HAL	HAL261218C00037000	call	37.0000	2026-12-18	2.2400	2.1900	2.2400	35.6899	10965.00	8512.00	2453.00	49	10	62	1278	0.0485133020344288	0.358302680653416	0.359992471167276	true	false	false	true	false
b1043d9e-0ce2-4a53-b010-fa62aba0ba41	2026-09-11 13:54	2026-09-11 13:54	2026-09-11 13:54	HAL	HAL261218P00035000	put	35.0000	2026-12-18	2.2400	2.2400	2.2800	35.7000	21952.00	0.00	21952.00	98	13	99	974	0.101642710472279	0.376025566076668	0.376025566076668	false	false	false	true	false
4a224ca2-b4ef-4573-b0d9-cdd89117ba75	2026-09-11 13:12	2026-09-11 13:12	2026-09-11 13:12	HAL	HAL270115C00043000	call	43.0000	2027-01-15	0.8700	0.8700	0.9100	35.5050	13224.00	0.00	13224.00	152	21	153	81	1.88888888888889	0.352509816575387	0.352509816575387	false	false	false	true	false
0021c79a-5f07-470d-8e5f-07a5958d525d	2026-09-11 10:48	2026-09-11 10:48	2026-09-11 10:48	HAL	HAL260925P00035500	put	35.5000	2026-09-25	0.8400	0.7500	0.8400	35.7100	12348.00	12348.00	0.00	147	6	147	0	0	0.347538746380435	0.347538746380435	true	false	false	true	false
7ebfb229-ac77-467f-b3c3-06bcaf4bc918	2026-09-09 15:22	2026-09-09 15:22	2026-09-09 15:22	HAL	HAL261002C00041000	call	41.0000	2026-10-02	0.3300	0.2700	0.3300	37.3850	36036.00	36036.00	0.00	1092	48	1093	42	26.0238095238095	0.373533584873496	0.373533584873496	false	false	false	true	false
db822217-9af4-4933-ba6a-869cd77a03a5	2026-09-09 13:42	2026-09-09 13:42	2026-09-09 13:42	HAL	HAL270917P00040000	put	40.0000	2027-09-17	6.6000	6.4500	6.6000	37.1550	90420.00	90420.00	0.00	137	10	163	472	0.345338983050847	0.399948136650105	0.399948136650105	false	false	false	true	false
9e7a6488-8524-4239-863b-15152084c7d4	2026-09-08 11:53	2026-09-08 11:53	2026-09-08 11:53	HAL	HAL261120C00038000	call	38.0000	2026-11-20	2.1400	2.1300	2.2800	37.0100	13482.00	11984.00	1498.00	63	6	72	702	0.102564102564103	0.371258207611848	0.371258207611848	false	false	false	true	false
19d75ec2-667f-4eb5-b8f8-2f43097faad8	2026-09-08 10:52	2026-09-08 10:52	2026-09-08 10:52	HAL	HAL261016P00037000	put	37.0000	2026-10-16	1.5500	1.5000	1.5500	37.2300	19530.00	19530.00	0.00	126	36	136	649	0.209553158705701	0.363755855648146	0.363755855648146	false	false	false	true	false
3e1ea2ab-02a1-4005-834d-85e75aaf3c51	2026-09-08 10:38	2026-09-08 10:37	2026-09-08 10:37	HAL	HAL261218C00040000	call	40.0000	2026-12-18	1.8800	1.8400	1.8800	37.3300	19552.00	19552.00	0.00	104	22	105	10197	0.0102971462194763	0.354794196535305	0.354794196535305	false	false	false	true	false
e772a21d-23b3-4c01-9ef2-caec889ac8d5	2026-09-04 15:52	2026-09-04 15:52	2026-09-04 15:52	HAL	HAL270917C00042000	call	42.0000	2027-09-17	4.0000	4.0000	4.1500	37.0250	22400.00	0.00	22400.00	56	13	82	367	0.223433242506812	0.355018536836647	0.355018536836647	false	false	false	true	false
7797abc9-9188-441a-8772-def36584c543	2026-09-04 14:25	2026-09-04 14:25	2026-09-04 14:25	HAL	HAL270115P00037000	put	37.0000	2027-01-15	2.9600	2.9300	2.9600	36.9450	41440.00	41440.00	0.00	140	16	140	755	0.185430463576159	0.359043088704581	0.359043088704581	false	false	false	true	false
277c86f1-cd4d-453a-9584-997a2a525000	2026-09-04 12:08	2026-09-04 12:07	2026-09-04 12:07	HAL	HAL270115C00037000	call	37.0000	2027-01-15	3.5000	3.2500	3.5000	37.1600	10500.00	10500.00	0.00	30	9	34	45942	0.000740063558399721	0.357791310672056	0.357791310672056	false	false	false	true	false
dbda18d8-aaff-41da-bb2a-41156814073a	2026-09-04 09:46	2026-09-04 09:46	2026-09-04 09:46	HAL	HAL261218C00040000	call	40.0000	2026-12-18	1.7500	1.6400	1.9900	37.1600	227850.00	11369.00	116031.00	1302	45	1302	9661	0.134768657488873	0.337351026545465	0.338136517768056	true	false	false	true	false
9ec1ed7b-7880-48c8-8f4c-bb12450cde79	2026-09-03 15:39	2026-09-03 15:38	2026-09-03 15:38	HAL	HAL270917P00037000	put	37.0000	2027-09-17	4.7000	4.5500	4.7000	37.3650	15040.00	15040.00	0.00	32	7	75	181	0.414364640883978	0.384802757715043	0.384802757715043	false	false	false	true	false
c5358632-839c-4c3f-8963-13255150c4f2	2026-09-03 12:53	2026-09-03 12:53	2026-09-03 12:53	HAL	HAL261120P00037000	put	37.0000	2026-11-20	2.1600	2.1200	2.2100	37.2300	10368.00	6912.00	3456.00	48	10	66	47	1.40425531914894	0.355404593326657	0.355404593326657	false	false	false	true	false
a2a13257-39ee-4408-90d6-c828ec83b697	2026-09-03 12:19	2026-09-03 12:19	2026-09-03 12:19	HAL	HAL270617C00033000	call	33.0000	2027-06-17	7.5500	7.5500	7.8000	37.5100	104945.00	0.00	104945.00	139	6	139	69	2.01449275362319	0.342944425607324	0.342944425607324	false	false	false	true	false
2ad6ba95-9f06-46c5-96c9-cc23ac6e0a22	2026-09-03 11:48	2026-09-03 11:48	2026-09-03 11:48	HAL	HAL261120P00036000	put	36.0000	2026-11-20	1.5500	1.3500	1.5900	37.7400	29450.00	775.00	28675.00	190	26	192	16	12	0.360137859912635	0.360137859912635	true	false	false	true	false
2444e0a1-527b-472b-ab49-282a0d05b9dc	2026-09-03 10:37	2026-09-03 10:37	2026-09-03 10:37	HAL	HAL261016P00036000	put	36.0000	2026-10-16	0.8800	0.8800	0.9300	38.0200	17512.00	0.00	17512.00	199	14	199	449	0.443207126948775	0.348559203431783	0.348559203431783	false	false	false	true	false
ccb29a78-139e-4b07-9851-9c787ba415e5	2026-09-03 10:07	2026-09-03 10:07	2026-09-03 10:07	HAL	HAL261218P00030000	put	30.0000	2026-12-18	0.4300	0.4100	0.5100	37.7500	22102.00	0.00	22102.00	514	19	514	1290	0.398449612403101	0.388355725129777	0.388355725129777	false	false	false	true	false
83eae9f7-84c5-428a-8ae3-5d19f0b0b4d9	2026-09-02 13:46	2026-09-02 13:46	2026-09-02 13:46	HAL	HAL270319C00042000	call	42.0000	2027-03-19	2.5000	2.2300	2.6500	37.6150	10000.00	8250.00	1750.00	40	6	51	1100	0.0463636363636364	0.346134004789924	0.346134004789924	false	false	false	true	false
d2f1061f-5c5e-4b12-9c1e-f7d1fb26bdee	2026-09-01 14:11	2026-09-01 14:11	2026-09-01 14:11	HAL	HAL270917C00040000	call	40.0000	2027-09-17	4.6500	4.5000	4.7000	36.9850	19065.00	14415.00	4650.00	41	5	41	56	0.732142857142857	0.344188019205992	0.344188019205992	false	false	false	true	false
2ff76c40-8c0e-49d8-bcdc-077ef07a8f91	2026-09-01 11:33	2026-09-01 11:32	2026-09-01 11:32	HAL	HAL270115C00044000	call	44.0000	2027-01-15	1.1000	1.1000	1.1800	36.9700	10670.00	0.00	10670.00	97	15	211	89	2.37078651685393	0.346257332580764	0.346257332580764	false	false	false	true	false
bc09cf8e-9265-45d5-ba38-84f1482bd0aa	2026-09-01 11:31	2026-09-01 11:31	2026-09-01 11:31	HAL	HAL270115C00044000	call	44.0000	2027-01-15	1.1300	1.1000	1.2300	36.9400	11413.00	1017.00	791.00	101	21	101	89	1.13483146067416	0.35142306718014	0.35142306718014	false	false	false	true	false
7e0a4a59-4069-48a2-8bf1-65169a715cb6	2026-09-01 10:02	2026-09-01 10:02	2026-09-01 10:02	HAL	HAL261218P00035000	put	35.0000	2026-12-18	1.9500	1.6800	1.9600	36.9700	39000.00	39000.00	0.00	200	10	200	889	0.224971878515186	0.385871639794943	0.385871639794943	false	false	false	true	false
f3018990-38da-4e4e-8cb2-47c56517eab8	2026-08-31 15:21	2026-08-31 15:21	2026-08-31 15:21	HAL	HAL261120C00036000	call	36.0000	2026-11-20	3.0500	2.8600	3.1000	36.9000	19825.00	4575.00	15250.00	65	9	94	178	0.528089887640449	0.351760461944176	0.351760461944176	true	false	false	true	false
26c3dacd-bd12-4cb2-847d-d23cfde81b3d	2026-08-31 13:07	2026-08-31 13:07	2026-08-31 13:07	HAL	HAL270617P00033000	put	33.0000	2027-06-17	2.7800	2.6400	2.7800	36.7300	28627.00	28353.00	274.00	103	6	103	421	0.244655581947743	0.396357945687372	0.394358589963002	false	false	false	true	false
6f771866-c364-4277-9a34-bf77d2d2f432	2026-08-31 10:25	2026-08-31 10:25	2026-08-31 10:25	HAL	HAL260904C00038000	call	38.0000	2026-09-04	0.2900	0.2900	0.3500	37.2100	11455.00	0.00	11455.00	395	40	4127	622	6.63504823151125	0.381622608299214	0.381622608299214	false	false	false	true	false
5f03d724-9df0-4a6a-8d10-2cda87d80122	2026-08-31 10:14	2026-08-31 10:14	2026-08-31 10:14	HAL	HAL260925C00032000	call	32.0000	2026-09-25	5.3500	5.3500	6.2000	37.3150	39055.00	0.00	39055.00	73	7	73	15	4.86666666666667	0.743705911063414	0.743705911063414	false	false	false	true	false
b944f96d-ede1-404c-9934-c447c43b40f0	2026-08-31 10:08	2026-08-31 10:08	2026-08-31 10:08	HAL	HAL260904C00038000	call	38.0000	2026-09-04	0.4000	0.3200	0.4000	37.2400	18920.00	18920.00	0.00	473	41	1113	622	1.78938906752412	0.452648223665071	0.452648223665071	false	false	false	true	false
8a11335e-d98f-4834-b069-000b3644d27e	2026-08-31 10:08	2026-08-31 10:08	2026-08-31 10:08	HAL	HAL260904C00038000	call	38.0000	2026-09-04	0.3900	0.3200	0.3900	37.2700	32097.00	32097.00	0.00	823	9	1939	622	3.11736334405145	0.438471987867199	0.438471987867199	false	false	false	true	false
08046612-ac4d-4fb8-b8d3-70444b3524c2	2026-08-31 10:08	2026-08-31 10:08	2026-08-31 10:08	HAL	HAL260904C00038000	call	38.0000	2026-09-04	0.3800	0.3200	0.3900	37.3100	18050.00	18050.00	0.00	475	5	2414	622	3.88102893890675	0.421879801375198	0.421879801375198	false	false	false	true	false
fe3cffd4-f0c9-44cb-8b2d-d6c624c63033	2026-08-28 15:43	2026-08-28 15:43	2026-08-28 15:43	HAL	HAL261016C00035000	call	35.0000	2026-10-16	2.4300	2.4200	2.5700	36.1100	73259.00	247.00	73012.00	302	7	384	1784	0.2152466367713	0.325923902563235	0.337978017473528	false	false	false	true	false
4eb48b71-202a-485b-8d80-849e70c7c21a	2026-08-28 13:04	2026-08-28 13:04	2026-08-28 13:04	HAL	HAL260918C00035500	call	35.5000	2026-09-18	1.5000	1.3200	1.6900	36.1700	13500.00	13200.00	300.00	90	11	142	867	0.163783160322953	0.316956803750699	0.316956803750699	true	false	false	true	false
9fc63bd6-6263-4e35-a7ca-86acfd30cd50	2026-08-28 12:12	2026-08-28 12:12	2026-08-28 12:12	HAL	HAL260918C00035000	call	35.0000	2026-09-18	1.6300	1.4900	1.6900	35.9400	13855.00	13529.00	326.00	85	19	1016	29867	0.0340174774835102	0.307969959579802	0.307969959579802	true	false	false	true	false
333ace87-c78f-4004-85c4-38267698be81	2026-08-28 11:43	2026-08-28 11:43	2026-08-28 11:43	HAL	HAL260918C00037500	call	37.5000	2026-09-18	0.4500	0.4500	0.6300	35.0000	17100.00	0.00	17100.00	380	19	380	20	19	0.300641984025628	0.300641984025628	true	false	false	true	false
53b0d41c-1e42-4b35-9f6d-e852cdf46b14	2026-08-28 11:18	2026-08-28 11:18	2026-08-28 11:18	HAL	HAL280121P00032000	put	32.0000	2028-01-21	3.7000	3.4500	3.7000	36.0250	361610.00	346280.00	15330.00	978	29	989	1908	0.518343815513627	0.401026716026665	0.401026716026665	false	false	false	true	false
62edd7ad-4bcd-43e2-8abc-a7c56cfc3310	2026-08-28 10:37	2026-08-28 10:37	2026-08-28 10:37	HAL	HAL270115P00037000	put	37.0000	2027-01-15	3.5500	3.2500	3.7000	35.9500	13135.00	7455.00	5680.00	37	6	37	783	0.0472541507024266	0.369409308683687	0.369409308683687	false	false	false	true	false
3b90d861-2c31-4dfa-aa26-16020c182eed	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	HAL	HAL261120C00038000	call	38.0000	2026-11-20	1.7400	1.6500	1.7400	36.0250	10092.00	10092.00	0.00	58	5	358	16	22.375	0.351354230005917	0.351354230005917	false	false	false	true	false
42a82de2-55e1-4748-9690-2aefd3922f3b	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	HAL	HAL261120C00038000	call	38.0000	2026-11-20	1.7700	1.7000	1.7700	36.0500	10974.00	10974.00	0.00	62	5	300	16	18.75	0.354189311894783	0.354189311894783	false	false	false	true	false
085e0d06-7e84-4579-8f9b-99ec5191a878	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	HAL	HAL261120C00038000	call	38.0000	2026-11-20	1.7600	1.7000	1.7600	36.0400	10560.00	10560.00	0.00	60	5	238	16	14.875	0.353351590954791	0.353351590954791	false	false	false	true	false
b0f98b68-08e4-4e2d-aa7a-d61a27f02559	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	HAL	HAL261120C00038000	call	38.0000	2026-11-20	1.6600	1.6600	1.8300	36.0500	10458.00	0.00	7802.00	63	10	169	16	10.5625	0.337982009076238	0.337982009076238	false	false	false	true	false
e8335f66-b878-4aad-b11e-4647ed9bcf3e	2026-08-28 09:41	2026-08-28 09:40	2026-08-28 09:40	HAL	HAL260918C00034500	call	34.5000	2026-09-18	1.9600	1.4600	1.9700	35.6550	18792.00	18124.00	668.00	96	5	111	32	3.46875	0.414322589149653	0.276786277435417	true	false	false	true	false
dcf62b89-b61a-4743-97a1-85cc9fbddd4c	2026-08-28 09:41	2026-08-28 09:40	2026-08-28 09:40	HAL	HAL260918C00036000	call	36.0000	2026-09-18	1.1300	0.7500	1.1300	35.6550	34013.00	34013.00	0.00	301	9	301	4018	0.0749128919860627	0.393488684360706	0.367639294145488	true	false	false	true	false
48edc299-2e08-404d-a69c-b7053f259c42	2026-08-28 09:41	2026-08-28 09:40	2026-08-28 09:40	HAL	HAL260828C00035500	call	35.5000	2026-08-28	0.4000	0.1200	0.4500	35.6800	14085.00	14045.00	40.00	352	13	360	1867	0.192822710230316	1.08982438291932	0.923449486753768	true	false	false	true	false
0552851a-8c69-4ee5-ae03-aa1095052d33	2026-08-28 09:41	2026-08-28 09:40	2026-08-28 09:40	HAL	HAL261016C00039000	call	39.0000	2026-10-16	0.9000	0.5200	0.9100	35.6800	12760.00	12103.00	657.00	142	7	142	638	0.22257053291536	0.402816797611834	0.34869320192563	true	false	false	true	false
035aeb5f-d894-46b4-87d1-a4f1bdc83560	2026-08-28 09:41	2026-08-28 09:40	2026-08-28 09:40	HAL	HAL260918C00035000	call	35.0000	2026-09-18	1.5500	1.1700	1.5500	35.6800	139491.00	139035.00	456.00	900	20	903	29867	0.030234037566545	0.373593020273886	0.325885730048381	true	false	false	true	false
0e91a8e2-1d65-427b-87ab-e567e2771c92	2026-08-27 14:47	2026-08-27 14:47	2026-08-27 14:47	HAL	HAL261016C00037000	call	37.0000	2026-10-16	1.3500	1.2400	1.3500	35.8300	38880.00	38880.00	0.00	288	39	367	1157	0.317199654278306	0.335585305500764	0.335585305500764	false	false	false	true	false