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_alerts566,287 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 |
|---|
| 25468b11-5b43-44f4-9a95-4e2acce79768 | 2026-09-24 14:05 | 2026-09-24 14:05 | 2026-09-24 14:05 | ENVX | ENVX280121P00003000 | put | 3.0000 | 2028-01-21 | 1.1900 | 1.1800 | 1.1900 | 2.9550 | 20230.00 | 20230.00 | 0.00 | 170 | 14 | 1200 | 5853 | 0.205023065094823 | 1.0041804662115 | 1.0041804662115 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 645178693.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T18:09:26.312126Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| cf74ec82-f843-4aca-bd76-169e7e057a21 | 2026-09-21 14:53 | 2026-09-21 14:53 | 2026-09-21 14:53 | ENVX | ENVX280121P00003000 | put | 3.0000 | 2028-01-21 | 1.2000 | 1.1800 | 1.2000 | 2.9850 | 12000.00 | 12000.00 | 0.00 | 100 | 15 | 280 | 5528 | 0.0506512301013025 | 1.01564296291763 | 1.01564296291763 | false | false | false | true | false | |||||||||||||||
| 85e7c2ff-c3cd-47a0-afc0-b9b77d1bbf7e | 2026-09-18 15:21 | 2026-09-18 15:21 | 2026-09-18 15:21 | ENVX | ENVX280121P00003000 | put | 3.0000 | 2028-01-21 | 1.2300 | 1.1800 | 1.2300 | 2.9100 | 18450.00 | 18450.00 | 0.00 | 150 | 19 | 270 | 5393 | 0.0500648989430744 | 1.02010514911619 | 1.02010514911619 | false | false | false | true | false | |||||||||||||||
| c1551202-71ae-433e-abec-d65bb41f122c | 2026-09-16 15:05 | 2026-09-16 15:05 | 2026-09-16 15:05 | ENVX | ENVX280121P00003000 | put | 3.0000 | 2028-01-21 | 1.2300 | 1.1900 | 1.2300 | 2.8900 | 34440.00 | 34440.00 | 0.00 | 280 | 6 | 804 | 5393 | 0.149082143519377 | 1.01364595597263 | 1.01364595597263 | false | false | false | true | false | |||||||||||||||
| d5ea0dae-6c50-4c88-aa58-8f69ee7f252c | 2026-09-15 11:48 | 2026-09-15 11:48 | 2026-09-15 11:48 | ENVX | ENVX280121P00003000 | put | 3.0000 | 2028-01-21 | 1.2500 | 1.2200 | 1.3300 | 2.9250 | 12500.00 | 9250.00 | 3250.00 | 100 | 24 | 100 | 5318 | 0.0188040616773223 | 1.03877650820241 | 1.03877650820241 | false | false | false | true | false | |||||||||||||||
| ff3ef499-7410-47b9-af56-6983142f5fb0 | 2026-09-10 12:34 | 2026-09-10 12:34 | 2026-09-10 12:34 | ENVX | ENVX280121P00003000 | put | 3.0000 | 2028-01-21 | 1.2400 | 1.2000 | 1.2500 | 3.1650 | 31124.00 | 31000.00 | 124.00 | 251 | 33 | 252 | 5080 | 0.0496062992125984 | 1.07352568768097 | 1.07352568768097 | false | false | false | true | false | |||||||||||||||
| cc0d2938-6632-42d4-b1fd-f8823efd93ed | 2026-09-08 11:57 | 2026-09-08 11:57 | 2026-09-08 11:57 | ENVX | ENVX280121P00003000 | put | 3.0000 | 2028-01-21 | 1.1700 | 1.1400 | 1.1700 | 3.5250 | 29250.00 | 29250.00 | 0.00 | 250 | 14 | 691 | 2416 | 0.286009933774834 | 1.06224086636198 | 1.06224086636198 | false | false | false | true | false | |||||||||||||||
| af78fbff-fa51-4bdb-8a00-83fa89304a10 | 2026-08-24 15:25 | 2026-08-24 15:25 | 2026-08-24 15:25 | ENVX | ENVX280121P00003000 | put | 3.0000 | 2028-01-21 | 1.2600 | 1.2400 | 1.2600 | 3.2550 | 18900.00 | 18900.00 | 0.00 | 150 | 8 | 355 | 1996 | 0.177855711422846 | 1.08975226241911 | 1.08975226241911 | false | false | false | true | false | |||||||||||||||
| 8f983cb0-c15a-4b92-9974-7add93095206 | 2026-08-24 14:04 | 2026-08-24 14:04 | 2026-08-24 14:04 | ENVX | ENVX280121P00003000 | put | 3.0000 | 2028-01-21 | 1.2500 | 1.2400 | 1.2600 | 3.2450 | 12625.00 | 12375.00 | 125.00 | 101 | 32 | 205 | 1996 | 0.102705410821643 | 1.0791866670941 | 1.0791866670941 | false | false | false | true | false | |||||||||||||||
| a20dc32e-35b5-40a2-83ea-456f99ddf37a | 2026-08-24 13:57 | 2026-08-24 13:56 | 2026-08-24 13:56 | ENVX | ENVX280121P00003000 | put | 3.0000 | 2028-01-21 | 1.2500 | 1.2400 | 1.2500 | 3.2350 | 12500.00 | 12500.00 | 0.00 | 100 | 25 | 104 | 1996 | 0.0521042084168337 | 1.07722801264577 | 1.07722801264577 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 653956634.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:53:27.633876Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 656151120.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 640789722.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:16:52.058969Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 662734576.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:54:17.138635Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 662734576.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T16:37:06.868856Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 662734576.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 662734576.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:47:47.207382Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 662734576.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 662734576.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |