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_alerts658,639 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 |
|---|
| 5ff42425-a550-485e-a018-6ac793df3332 | 2026-08-17 14:22 | 2026-08-17 14:22 | 2026-08-17 14:22 | BULL | BULL260821C00008500 | call | 8.5000 | 2026-08-21 | 0.2300 | 0.2200 | 0.2500 | 8.2000 | 35496.00 | 0.00 | 30482.00 | 1529 | 37 | 3892 | 5275 | 0.73781990521327 | 1.0543688558111 | 1.03007332246017 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3984070552.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5b25410f-64a7-4218-90e8-2bce7cbe4fcd | 2026-08-18 10:29 | 2026-08-18 10:29 | 2026-08-18 10:29 | BULL | BULL260821C00008500 | call | 8.5000 | 2026-08-21 | 0.1600 | 0.1500 | 0.1600 | 8.0050 | 15440.00 | 15440.00 | 0.00 | 965 | 26 | 1572 | 7831 | 0.200740646149917 | 1.18337713052208 | 1.18337713052208 | false | false | false | true | ||||||||||||||||
| 49314a50-cbf3-4381-a8a3-3d7bba588833 | 2026-08-19 15:18 | 2026-08-19 15:18 | 2026-08-19 15:18 | BULL | BULL260821C00008500 | call | 8.5000 | 2026-08-21 | 0.3900 | 0.3800 | 0.4000 | 8.5200 | 20397.00 | 19890.00 | 507.00 | 523 | 5 | 8579 | 9030 | 0.950055370985604 | 1.50912540246174 | 1.50912540246174 | false | false | false | true | ||||||||||||||||
| 6080bb19-99ae-4d84-b86b-7a7d5280949e | 2026-08-19 15:30 | 2026-08-19 15:30 | 2026-08-19 15:30 | BULL | BULL260821C00008500 | call | 8.5000 | 2026-08-21 | 0.4000 | 0.4000 | 0.4100 | 8.5350 | 12000.00 | 0.00 | 12000.00 | 300 | 30 | 9761 | 9030 | 1.08095238095238 | 1.51702537935334 | 1.51702537935334 | false | false | false | true | ||||||||||||||||
| b5ef3f2e-e825-43f9-af43-9b17a608426a | 2026-08-19 15:56 | 2026-08-19 15:56 | 2026-08-19 15:56 | BULL | BULL260821C00008500 | call | 8.5000 | 2026-08-21 | 0.4700 | 0.4600 | 0.4700 | 8.6300 | 23500.00 | 23500.00 | 0.00 | 500 | 10 | 12574 | 9030 | 1.39246954595792 | 1.59669083751752 | 1.58522338969343 | false | false | false | true | ||||||||||||||||
| 4e3fbd8f-6718-45d4-a1e3-5b1118b98190 | 2026-08-20 09:30 | 2026-08-20 09:30 | 2026-08-20 09:30 | BULL | BULL260821C00008500 | call | 8.5000 | 2026-08-21 | 1.3000 | 1.2400 | 1.3000 | 9.7500 | 41210.00 | 41210.00 | 0.00 | 317 | 5 | 577 | 13553 | 0.0425735999409725 | 2.08224963275757 | 2.08224963275757 | false | false | false | true | ||||||||||||||||
| 19404a38-5569-436a-8118-50a5e2406fab | 2026-08-20 09:31 | 2026-08-20 09:31 | 2026-08-20 09:31 | BULL | BULL260821C00008500 | call | 8.5000 | 2026-08-21 | 1.0700 | 1.0200 | 1.1200 | 9.5600 | 10700.00 | 4280.00 | 6420.00 | 100 | 5 | 1181 | 13553 | 0.0871393787353354 | 1.26724694829543 | 1.26724694829543 | false | false | false | true | ||||||||||||||||
| 672aed67-55dd-45f3-9e44-40ed7fa7ca58 | 2026-08-20 09:50 | 2026-08-20 09:50 | 2026-08-20 09:50 | BULL | BULL260821C00008500 | call | 8.5000 | 2026-08-21 | 1.2500 | 1.2500 | 1.3500 | 9.7950 | 24375.00 | 0.00 | 24375.00 | 195 | 5 | 4597 | 13553 | 0.339186895890209 | 2.18923018093227 | 2.18923018093227 | false | false | false | true | ||||||||||||||||
| ea970f8d-3ebd-4876-8ac9-87837716068d | 2026-08-21 15:49 | 2026-08-21 15:49 | 2026-08-21 15:49 | BULL | BULL260821C00008500 | call | 8.5000 | 2026-08-21 | 0.4500 | 0.4400 | 0.5300 | 8.9750 | 13112.00 | 0.00 | 1232.00 | 292 | 8 | 2874 | 9947 | 0.288931336081231 | 3.46433121527936 | 13.5289745906853 | false | false | false | true | ||||||||||||||||
| c44f6f86-2888-43b6-9920-e35b444b0ad8 | 2026-08-21 15:49 | 2026-08-21 15:49 | 2026-08-21 15:49 | BULL | BULL260821C00008500 | call | 8.5000 | 2026-08-21 | 0.4400 | 0.4400 | 0.5300 | 8.9501 | 13288.00 | 0.00 | 13288.00 | 302 | 8 | 3482 | 9947 | 0.350055293053182 | 15.3741577271241 | 15.3741577271241 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |