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 |
|---|
| 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 |
|---|
| 1c205773-8b20-483e-9a3c-a637b3c78b1f | 2026-09-18 15:31 | 2026-09-18 15:31 | 2026-09-18 15:31 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 0.7000 | 0.5000 | 0.7000 | 104.6425 | 19740.00 | 19740.00 | 0.00 | 282 | 5 | 6566 | 2835 | 2.31604938271605 | 2.81215633480015 | 2.81215633480015 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 34702285919.00 | 2026-12-01 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 3c62972d-5259-4340-afdc-69e6f0da58b7 | 2026-09-18 15:02 | 2026-09-18 15:02 | 2026-09-18 15:02 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 2.9500 | 2.3000 | 3.0000 | 108.0250 | 23340.00 | 23340.00 | 0.00 | 79 | 5 | 5042 | 2835 | 1.77848324514991 | 1.66041989463462 | 1.66041989463462 | false | false | false | true | ||||||||||||||||
| 60e66978-4509-4640-972d-27ff517c267a | 2026-09-18 14:48 | 2026-09-18 14:48 | 2026-09-18 14:48 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 2.4500 | 2.0500 | 2.5000 | 107.5550 | 17890.00 | 17890.00 | 0.00 | 73 | 5 | 4541 | 2835 | 1.60176366843034 | 1.17816798194963 | 0 | false | false | false | true | ||||||||||||||||
| f03ab914-893b-4e3a-81ca-be6e44c8d1f2 | 2026-09-18 14:37 | 2026-09-18 14:36 | 2026-09-18 14:36 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 1.0000 | 0.9000 | 1.0000 | 105.1900 | 10000.00 | 10000.00 | 0.00 | 100 | 7 | 3865 | 2835 | 1.36331569664903 | 1.7105029165022 | 1.7105029165022 | false | false | false | true | ||||||||||||||||
| 2cb27a33-cff4-4d30-9156-ccfc39867caf | 2026-09-18 14:04 | 2026-09-18 14:04 | 2026-09-18 14:04 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 0.3500 | 0.2000 | 0.4500 | 103.8100 | 10280.00 | 515.00 | 0.00 | 294 | 6 | 2540 | 2835 | 0.895943562610229 | 1.27231910531865 | 1.31098712453864 | true | false | false | true | ||||||||||||||||
| 4316fb81-19a6-4567-bdfb-bbf547d59d18 | 2026-09-17 10:05 | 2026-09-17 10:05 | 2026-09-17 10:05 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 1.0000 | 0.8000 | 1.1000 | 103.1550 | 42500.00 | 26900.00 | 15600.00 | 425 | 5 | 575 | 2537 | 0.226645644461963 | 0.813433442566682 | 0.813433442566682 | false | false | false | true | ||||||||||||||||
| 09391964-7dc3-4c15-bfc3-e5f425e48fa2 | 2026-09-08 12:55 | 2026-09-08 12:54 | 2026-09-08 12:54 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 2.4000 | 2.1000 | 2.7000 | 100.6470 | 24000.00 | 7200.00 | 13920.00 | 100 | 14 | 2497 | 1307 | 1.91048201989288 | 0.616908367735968 | 0.616908367735968 | false | false | false | true | ||||||||||||||||
| d3461e19-92cb-42a5-a15b-087e2af4c5f9 | 2026-09-08 12:34 | 2026-09-08 12:34 | 2026-09-08 12:34 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 2.3500 | 2.3000 | 2.8500 | 100.4700 | 11515.00 | 0.00 | 11515.00 | 49 | 6 | 2143 | 1307 | 1.63963274674828 | 0.619084488592119 | 0.619084488592119 | false | false | false | true | ||||||||||||||||
| a086cdb8-5591-4b9f-86dd-16e14026c37d | 2026-09-08 12:08 | 2026-09-08 12:08 | 2026-09-08 12:08 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 2.9000 | 2.9000 | 3.2000 | 101.3900 | 145870.00 | 0.00 | 145870.00 | 503 | 5 | 1817 | 1307 | 1.39020657995409 | 0.65115314907577 | 0.65115314907577 | true | false | false | true | ||||||||||||||||
| b3226507-e2e7-4b74-8369-c33f8926b92e | 2026-09-08 11:15 | 2026-09-08 11:15 | 2026-09-08 11:15 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 2.7500 | 2.7000 | 2.9000 | 100.9650 | 13750.00 | 0.00 | 13750.00 | 50 | 6 | 540 | 1307 | 0.413159908186687 | 0.653592568335922 | 0.653592568335922 | false | false | false | true | ||||||||||||||||
| e61d38ab-b2b8-4741-bc96-02720ffe375a | 2026-09-04 15:06 | 2026-09-04 15:06 | 2026-09-04 15:06 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 2.0500 | 1.9500 | 2.1500 | 98.5800 | 14145.00 | 13325.00 | 0.00 | 69 | 17 | 353 | 891 | 0.396184062850729 | 0.567677327958929 | 0.567677327958929 | false | false | false | true | ||||||||||||||||
| 96ff6a12-fb33-4d10-b6ba-4a73d048c8b3 | 2026-09-01 15:27 | 2026-09-01 15:26 | 2026-09-01 15:26 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 1.5100 | 1.3000 | 1.5500 | 94.4200 | 15130.00 | 15130.00 | 0.00 | 100 | 13 | 134 | 812 | 0.165024630541872 | 0.603352235767927 | 0.595248570840974 | false | false | false | true | ||||||||||||||||
| 73de0656-d64c-4f36-9955-917180344706 | 2026-08-26 10:48 | 2026-08-26 10:48 | 2026-08-26 10:48 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 11.6900 | 11.2000 | 12.2000 | 109.0300 | 70120.00 | 59590.00 | 10530.00 | 60 | 23 | 99 | 636 | 0.155660377358491 | 0.88873617042603 | 0.880530085522391 | false | false | false | true | ||||||||||||||||
| d9210bd0-4d0e-4201-af9d-f18dcfedb7e6 | 2026-08-25 12:30 | 2026-08-25 12:30 | 2026-08-25 12:30 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 8.5000 | 8.1000 | 8.6000 | 103.1300 | 40800.00 | 850.00 | 11900.00 | 48 | 5 | 80 | 569 | 0.140597539543058 | 0.874860995279401 | 0.874860995279401 | false | false | false | true | ||||||||||||||||
| e2dce9db-a504-42de-84da-a28118d0ad23 | 2026-08-24 11:47 | 2026-08-24 11:47 | 2026-08-24 11:47 | P | P260918C00105000 | call | 105.0000 | 2026-09-18 | 8.5000 | 8.0000 | 8.5000 | 102.7500 | 40800.00 | 40800.00 | 0.00 | 48 | 16 | 74 | 506 | 0.146245059288538 | 0.874941646776525 | 0.874941646776525 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 34702285919.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 34702285919.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 34702285919.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 34702285919.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 34652301831.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:07:38.635762Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 31250051599.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:11:09.796111Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 31250051599.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:42:24.738421Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 31250051599.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 31250051599.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:26:49.659255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 31250051599.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 31250051599.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T19:44:53.190071Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 31250051599.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:02:19.815281Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 31250051599.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 31250051599.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:49:37.820281Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |