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 | expiry |
|---|
| 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 |
|---|
| fa7768d4-a1d3-4449-b9b1-8b322893550e | 2026-08-21 10:18 | 2026-08-21 10:18 | 2026-08-21 10:18 | HIVE | HIVE281215C00010000 | call | 10.0000 | 2028-12-15 | 0.9500 | 0.9500 | 1.2500 | 3.0850 | 21945.00 | 0.00 | 21945.00 | 231 | 9 | 3953 | 4052 | 0.975567620927937 | 0.991519361197584 | 0.991519361197584 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 820089241.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fbee8a0f-8f6e-48cc-8f0e-3988ba0de7c5 | 2026-08-21 10:18 | 2026-08-21 10:18 | 2026-08-21 10:18 | HIVE | HIVE281215C00010000 | call | 10.0000 | 2028-12-15 | 0.9500 | 0.9500 | 1.2500 | 3.0900 | 35340.00 | 0.00 | 35340.00 | 372 | 9 | 3722 | 4052 | 0.918558736426456 | 0.990142830959892 | 0.990142830959892 | true | false | false | true | ||||||||||||||||
| 52bebd17-600f-4ff3-adfd-f8374f50a5ae | 2026-08-21 10:18 | 2026-08-21 10:18 | 2026-08-21 10:18 | HIVE | HIVE281215C00010000 | call | 10.0000 | 2028-12-15 | 0.9500 | 0.9500 | 1.2500 | 3.0900 | 21090.00 | 0.00 | 21090.00 | 222 | 8 | 3350 | 4052 | 0.82675222112537 | 0.990142830959892 | 0.990142830959892 | true | false | false | true | ||||||||||||||||
| 240f209a-c6c3-4888-ad12-c2faa23d1d78 | 2026-08-21 10:15 | 2026-08-21 10:15 | 2026-08-21 10:15 | HIVE | HIVE281215C00010000 | call | 10.0000 | 2028-12-15 | 0.9500 | 0.9500 | 1.2000 | 3.1150 | 22135.00 | 0.00 | 22135.00 | 233 | 10 | 2828 | 4052 | 0.697926949654492 | 0.983309426728092 | 0.983309426728092 | false | false | false | true | ||||||||||||||||
| 9b430389-9fc4-4024-81d1-27eb205ceef4 | 2026-08-21 10:15 | 2026-08-21 10:14 | 2026-08-21 10:14 | HIVE | HIVE281215C00010000 | call | 10.0000 | 2028-12-15 | 0.9500 | 0.9500 | 1.2500 | 3.1150 | 29925.00 | 0.00 | 29925.00 | 315 | 5 | 2154 | 4052 | 0.531589338598223 | 0.983309426728092 | 0.983309426728092 | false | false | false | true | ||||||||||||||||
| 8eeca665-80a3-4a37-980d-c83057a4adb5 | 2026-08-21 10:15 | 2026-08-21 10:14 | 2026-08-21 10:14 | HIVE | HIVE281215C00010000 | call | 10.0000 | 2028-12-15 | 0.9500 | 0.9500 | 1.1000 | 3.1150 | 28025.00 | 0.00 | 28025.00 | 295 | 11 | 2449 | 4052 | 0.604392892398815 | 0.981952486534627 | 0.983309426728092 | true | false | false | true | ||||||||||||||||
| e639f77a-b4cc-4fe1-b212-ec3175fd1233 | 2026-08-21 10:15 | 2026-08-21 10:14 | 2026-08-21 10:14 | HIVE | HIVE281215C00010000 | call | 10.0000 | 2028-12-15 | 0.9500 | 0.9500 | 1.0500 | 3.1150 | 23750.00 | 0.00 | 23750.00 | 250 | 6 | 1444 | 4052 | 0.356367226061204 | 0.983309426728092 | 0.983309426728092 | true | false | false | true | ||||||||||||||||
| e449850d-8de5-4414-91ee-2b97bc2fb325 | 2026-08-21 10:15 | 2026-08-21 10:14 | 2026-08-21 10:14 | HIVE | HIVE281215C00010000 | call | 10.0000 | 2028-12-15 | 0.9500 | 0.9500 | 1.2000 | 3.1150 | 37525.00 | 0.00 | 37525.00 | 395 | 10 | 1839 | 4052 | 0.453849950641658 | 0.983309426728092 | 0.983309426728092 | true | false | false | true | ||||||||||||||||
| 39a05ace-3d9d-4102-af19-cadc35a7207a | 2026-08-21 10:15 | 2026-08-21 10:14 | 2026-08-21 10:14 | HIVE | HIVE281215C00010000 | call | 10.0000 | 2028-12-15 | 0.9500 | 0.9500 | 1.3000 | 3.1150 | 26790.00 | 0.00 | 26790.00 | 282 | 5 | 918 | 4052 | 0.226554787759131 | 0.983309426728092 | 0.983309426728092 | true | false | false | true | ||||||||||||||||
| d031b7d5-6861-4053-9f03-5224f7dd597a | 2026-08-21 10:14 | 2026-08-21 10:14 | 2026-08-21 10:14 | HIVE | HIVE281215C00010000 | call | 10.0000 | 2028-12-15 | 0.9500 | 0.9500 | 1.3000 | 3.1200 | 17005.00 | 0.00 | 17005.00 | 179 | 7 | 636 | 4052 | 0.156959526159921 | 0.981952486534627 | 0.981952486534627 | true | false | false | true | ||||||||||||||||
| 9ddbd656-bc78-4a8b-b6a3-b50169f70351 | 2026-08-21 10:09 | 2026-08-21 10:09 | 2026-08-21 10:09 | HIVE | HIVE281215C00010000 | call | 10.0000 | 2028-12-15 | 1.0000 | 1.0000 | 1.3500 | 3.1800 | 19800.00 | 0.00 | 19800.00 | 198 | 8 | 457 | 4052 | 0.112783810463968 | 0.99181271145907 | 0.99181271145907 | true | false | false | true | ||||||||||||||||
| 8a7f7405-4f8b-42f0-8092-e73fb4998d00 | 2026-08-21 10:09 | 2026-08-21 10:09 | 2026-08-21 10:09 | HIVE | HIVE281215C00010000 | call | 10.0000 | 2028-12-15 | 1.0000 | 1.0000 | 1.3500 | 3.1750 | 25700.00 | 0.00 | 25700.00 | 257 | 9 | 259 | 4052 | 0.0639190523198421 | 0.99317391164005 | 0.99317391164005 | true | false | false | true | ||||||||||||||||
| e59ad0ec-a576-41b6-ad6f-2eaca3ba30e6 | 2026-08-19 10:53 | 2026-08-19 10:53 | 2026-08-19 10:53 | HIVE | HIVE281215C00010000 | call | 10.0000 | 2028-12-15 | 0.7500 | 0.7500 | 1.1500 | 2.7300 | 111225.00 | 0.00 | 111225.00 | 1483 | 18 | 1492 | 1865 | 0.8 | 0.977513255158764 | 0.976824316035649 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 820089241.00 |
| 2026-11-13 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 820089241.00 |
| 2026-11-13 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 820089241.00 |
| 2026-11-13 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 820089241.00 |
| 2026-11-13 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 820089241.00 |
| 2026-11-13 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 820089241.00 |
| 2026-11-13 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 820089241.00 |
| 2026-11-13 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 820089241.00 |
| 2026-11-13 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 820089241.00 |
| 2026-11-13 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 820089241.00 |
| 2026-11-13 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 820089241.00 |
| 2026-11-13 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 820089241.00 |
| 2026-11-13 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |