Simplify AnalyticsOptions 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
| 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 |
| 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 |