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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:sector = Consumer Defensive×ticker = AGRO×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate	pricenumeric	bidnumeric	asknumeric	underlying_pricenumeric	total_premiumnumeric	total_ask_side_premnumeric	total_bid_side_premnumeric	total_sizebigint	trade_countinteger	volumebigint	open_interestbigint	volume_oi_rationumeric	iv_startnumeric	iv_endnumeric	has_sweepboolean	has_floorboolean	has_multilegboolean	has_singlelegboolean	all_opening_tradesboolean	alert_ruletext	rule_iduuid	expiry_countinteger	issue_typetext	sectortext	marketcapnumeric	next_earnings_datedate	er_timetext	missing_periscopeboolean	sourcetext	endpointtext	request_paramsjsonb	as_ofdate	vintage_tstimestamp with time zone	retrieved_attimestamp with time zone
fb3147b8-8902-4d06-afc6-2430e3bf7cb8	2026-09-18 13:48	2026-09-18 13:48	2026-09-18 13:48	AGRO	AGRO270319P00010000	put	10.0000	2027-03-19	0.9000	0.9000	1.1000	11.5700	68400.00	0.00	68400.00	760	20	763	253	3.01581027667984	0.548567460335015	0.548567460335015	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	1633929968.00	2026-11-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T17:59:53.998874Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
be10cc83-038a-4c5b-8c41-cc3082177619	2026-09-15 11:15	2026-09-15 11:15	2026-09-15 11:15	AGRO	AGRO260918P00012500	put	12.5000	2026-09-18	1.0500	1.0500	1.1000	11.5100	11760.00	0.00	11760.00	112	5	268	946	0.283298097251586	0.834993399526548	0.834993399526548	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	1670999932.00	2026-11-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"}	2026-09-15	2026-09-15 21:15	2026-09-15 21:15
ee2d9e71-fd38-461a-ad03-0c1b6ac84fc9	2026-09-11 14:07	2026-09-11 14:07	2026-09-11 14:07	AGRO	AGRO261218C00012500	call	12.5000	2026-12-18	1.0000	0.9000	1.0500	11.7800	20000.00	2200.00	17800.00	200	15	900	6636	0.135623869801085	0.512859949641079	0.512859949641079	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	1670999932.00	2026-11-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
21ebff14-4800-43d7-b3c8-41472960eb10	2026-09-11 13:43	2026-09-11 13:43	2026-09-11 13:43	AGRO	AGRO261218C00012500	call	12.5000	2026-12-18	1.0000	0.9500	1.0500	11.8405	20000.00	2200.00	17800.00	200	5	499	6636	0.0751959011452682	0.500922873782396	0.500922873782396	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	1670999932.00	2026-11-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
77800824-2cd7-49e4-aa8f-e2a77330dfb8	2026-09-10 15:51	2026-09-10 15:51	2026-09-10 15:51	AGRO	AGRO261218C00012500	call	12.5000	2026-12-18	1.3500	1.3500	1.7000	12.3700	27000.00	0.00	27000.00	200	9	530	7128	0.074354657687991	0.528000657274224	0.528000657274224	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	1670999932.00	2026-11-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-11T13:30:31.573730Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
52503723-f383-499c-9927-409840f91985	2026-09-04 10:57	2026-09-04 10:57	2026-09-04 10:57	AGRO	AGRO261218C00012500	call	12.5000	2026-12-18	1.1500	1.1000	1.1500	11.8350	23000.00	23000.00	0.00	200	19	258	6530	0.039509954058193	0.541200771208333	0.541200771208333	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	1670999932.00	2026-11-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
03c966c3-ccac-4bf5-bff0-7cb6c77b106b	2026-09-03 10:20	2026-09-03 10:20	2026-09-03 10:20	AGRO	AGRO261218C00012500	call	12.5000	2026-12-18	0.9500	0.9500	1.0000	11.4800	18050.00	0.00	18050.00	190	8	800	6996	0.114351057747284	0.527665966479548	0.527665966479548	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	1670999932.00	2026-11-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e70f67e5-16ad-4f6d-a1fe-8e403d590133	2026-09-02 10:22	2026-09-02 10:22	2026-09-02 10:22	AGRO	AGRO261016C00012500	call	12.5000	2026-10-16	0.5400	0.5000	0.6500	11.6150	27010.00	0.00	27010.00	500	5	500	574	0.871080139372822	0.543474417340405	0.543474417340405	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	1670999932.00	2026-11-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-02T14:25:30.485375Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
2da93df0-1a1a-4644-9d1e-61811257718e	2026-08-24 10:23	2026-08-24 10:23	2026-08-24 10:23	AGRO	AGRO261218P00012500	put	12.5000	2026-12-18	2.1000	1.9500	2.1000	11.4850	12810.00	12810.00	0.00	61	6	71	235	0.302127659574468	0.612857600222054	0.612857600222054	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	1670999932.00	2026-11-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T14:35:34.147296Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
9a5be3bb-df1c-4ea3-9bb5-0d6344ea0c58	2026-08-21 11:48	2026-08-21 11:48	2026-08-21 11:48	AGRO	AGRO261218C00012500	call	12.5000	2026-12-18	1.0000	0.7500	1.0000	11.1600	19900.00	19900.00	0.00	199	15	1098	5609	0.195756819397397	0.570332481677478	0.570332481677478	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	1670999932.00	2026-11-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c8f2deec-16c2-460b-8625-ad2edf54b0f5	2026-08-21 11:40	2026-08-21 11:40	2026-08-21 11:40	AGRO	AGRO261218C00012500	call	12.5000	2026-12-18	0.9500	0.9000	1.0000	11.1200	19000.00	17100.00	0.00	200	12	897	5609	0.159921554644322	0.557363427944819	0.557363427944819	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	1670999932.00	2026-11-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
97f3e809-1594-46af-a5fe-20ee8c2d3da1	2026-08-20 10:38	2026-08-20 10:38	2026-08-20 10:38	AGRO	AGRO260918C00012500	call	12.5000	2026-09-18	0.2600	0.1500	0.3000	10.8900	65000.00	65000.00	0.00	2500	2	2500	2297	1.08837614279495	0.613226669368781	0.613226669368781	false	true	false	true	false	LowHistoricVolumeFloor	b356ec2b-92e1-458a-934a-7719f71c40bc	1	Common Stock	Consumer Defensive	1670999932.00	2026-11-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45