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 | 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 |
|---|
| b0937f14-6660-4556-aaeb-e3659ab277f2 | 2026-09-10 09:48 | 2026-09-10 09:48 | 2026-09-10 09:48 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 3.5000 | 3.4000 | 3.5000 | 171.9000 | 10500.00 | 350.00 | 0.00 | 30 | 19 | 55 | 766 | 0.0718015665796345 | 0.683245010957706 | 0.683245010957706 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 42655640476.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T13:52:43.061304Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a2720d51-922f-4553-80c1-d44973973653 | 2026-09-11 10:31 | 2026-09-11 10:31 | 2026-09-11 10:31 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 5.6000 | 5.4500 | 6.1500 | 180.1950 | 15679.00 | 1119.00 | 14000.00 | 28 | 12 | 179 | 739 | 0.242219215155616 | 0.66244220113424 | 0.66580064702934 | false | false | false | true | ||||||||||||||||
| 15c56dac-58e2-48c9-bc79-407fab1656b8 | 2026-09-11 15:54 | 2026-09-11 15:54 | 2026-09-11 15:54 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 3.7500 | 3.5000 | 3.7500 | 174.8700 | 45000.00 | 45000.00 | 0.00 | 120 | 10 | 581 | 739 | 0.786197564276049 | 0.658108231955862 | 0.658108231955862 | false | false | false | true | ||||||||||||||||
| e30b6ed4-1ae7-4e50-a486-d0caf90356cd | 2026-09-14 13:26 | 2026-09-14 13:26 | 2026-09-14 13:26 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 10.9500 | 10.6500 | 10.9500 | 192.3700 | 10950.00 | 10950.00 | 0.00 | 10 | 8 | 455 | 991 | 0.459132189707366 | 0.72570578138638 | 0.72570578138638 | false | false | false | true | ||||||||||||||||
| d13b2d54-e945-46d5-9203-160fe3936ee3 | 2026-09-15 11:04 | 2026-09-15 11:04 | 2026-09-15 11:04 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 4.5500 | 4.3500 | 4.5500 | 178.0000 | 227500.00 | 227500.00 | 0.00 | 500 | 5 | 1387 | 1134 | 1.22310405643739 | 0.751009694199199 | 0.751009694199199 | false | false | false | true | ||||||||||||||||
| e594734a-ad39-403d-9076-e0aed7a62c97 | 2026-09-18 09:54 | 2026-09-18 09:54 | 2026-09-18 09:54 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 5.0500 | 4.7500 | 5.1500 | 185.4700 | 40400.00 | 5050.00 | 35350.00 | 80 | 44 | 1134 | 2130 | 0.532394366197183 | 0.677948135408731 | 0.677948135408731 | true | false | false | true | ||||||||||||||||
| 3c6e7375-b85a-4b64-98bb-fa9d311dc8ff | 2026-09-18 09:55 | 2026-09-18 09:55 | 2026-09-18 09:55 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 4.8000 | 4.8000 | 5.0000 | 185.1700 | 22566.00 | 0.00 | 22566.00 | 47 | 14 | 1208 | 2130 | 0.567136150234742 | 0.6645980555122 | 0.667427214387776 | true | false | false | true | ||||||||||||||||
| bffa353f-b4c5-4c96-b9b0-69ec8358bfc2 | 2026-09-18 09:56 | 2026-09-18 09:55 | 2026-09-18 09:55 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 4.6500 | 4.6000 | 4.8500 | 184.6700 | 19065.00 | 2325.00 | 16740.00 | 41 | 37 | 1270 | 2130 | 0.596244131455399 | 0.670748762375789 | 0.670748762375789 | false | false | false | true | ||||||||||||||||
| ed3cbc70-9d22-412b-b081-c73f1db6a752 | 2026-09-18 10:16 | 2026-09-18 10:16 | 2026-09-18 10:16 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 6.0000 | 5.8500 | 6.0500 | 187.7900 | 11994.00 | 10800.00 | 1194.00 | 20 | 7 | 4632 | 2130 | 2.17464788732394 | 0.668373104157907 | 0.666841462640203 | false | false | false | true | ||||||||||||||||
| e9b1d371-618e-431e-b543-7b0381e3833a | 2026-09-18 10:23 | 2026-09-18 10:23 | 2026-09-18 10:23 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 7.0000 | 6.9500 | 7.0000 | 189.6750 | 16800.00 | 16800.00 | 0.00 | 24 | 7 | 4888 | 2130 | 2.29483568075117 | 0.676496514582858 | 0.676496514582858 | false | false | false | true | ||||||||||||||||
| 259dfe7f-18bc-4fbc-9af1-c372320325f6 | 2026-09-18 10:31 | 2026-09-18 10:31 | 2026-09-18 10:31 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 7.0000 | 6.7000 | 7.2000 | 189.8900 | 42000.00 | 42000.00 | 0.00 | 60 | 8 | 5366 | 2130 | 2.51924882629108 | 0.665887799287418 | 0.665887799287418 | false | false | false | true | ||||||||||||||||
| b9916a02-7e92-44f3-87a3-a80dd4df20d8 | 2026-09-18 11:06 | 2026-09-18 11:06 | 2026-09-18 11:06 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 7.9500 | 7.9000 | 8.1000 | 191.8700 | 11925.00 | 3180.00 | 8745.00 | 15 | 8 | 5975 | 2130 | 2.80516431924883 | 0.654200233521605 | 0.654200233521605 | false | false | false | true | ||||||||||||||||
| 08fbd0b6-b8c2-40b4-a1c5-234c43865768 | 2026-09-18 12:32 | 2026-09-18 12:32 | 2026-09-18 12:32 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 10.0000 | 9.8000 | 10.1500 | 195.2000 | 31000.00 | 31000.00 | 0.00 | 31 | 7 | 6598 | 2130 | 3.09765258215962 | 0.658908358013302 | 0.658908358013302 | true | false | false | true | ||||||||||||||||
| ff48b129-8e61-4da7-9224-00903aabca38 | 2026-09-18 15:55 | 2026-09-18 15:54 | 2026-09-18 15:54 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 8.7000 | 8.7000 | 9.3000 | 193.0000 | 11310.00 | 0.00 | 11310.00 | 13 | 12 | 7636 | 2130 | 3.5849765258216 | 0.626110728802145 | 0.626110728802145 | true | false | false | true | ||||||||||||||||
| 4e162e39-3bf4-4db6-a652-bda5e9b655cf | 2026-09-24 13:38 | 2026-09-24 13:38 | 2026-09-24 13:38 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 8.1000 | 8.1000 | 9.2500 | 197.8400 | 20250.00 | 0.00 | 20250.00 | 25 | 5 | 268 | 3973 | 0.0674553234331739 | 0.57446270031452 | 0.57446270031452 | false | false | false | true | ||||||||||||||||
| 1a16e0e6-b4c4-4cf7-aa2f-baff83af9aff | 2026-09-25 14:14 | 2026-09-25 14:14 | 2026-09-25 14:14 | COIN | COIN260925C00190000 | call | 190.0000 | 2026-09-25 | 4.7500 | 4.5000 | 5.1000 | 194.6900 | 23750.00 | 0.00 | 23750.00 | 50 | 6 | 1870 | 3181 | 0.587865451116001 | 1.04180645804028 | 1.04180645804028 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42655640476.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:09:54.469160Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 43279488966.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 43279488966.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 43279488966.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 43279488966.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 43279488966.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 43279488966.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 43279488966.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 43279488966.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:45:45.480252Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 43279488966.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 44143964730.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:43:31.900788Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 43471099574.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:18:37.657539Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |