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.
uw_flow_alerts523,327 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 |
|---|
| 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 | ||||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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-09-11T18:02:32.717866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |