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.
Simplify Analyticsuw_flow_alerts474,253 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 |
|---|
| 4e373d79-5629-4dcb-9648-7e533bb86e26 | 2026-08-27 09:44 | 2026-08-27 09:44 | 2026-08-27 09:44 | CRM | CRM281215C00250000 | call | 250.0000 | 2028-12-15 | 71.5300 | 69.6500 | 71.6500 | 243.1300 | 57225.00 | 28630.00 | 28595.00 | 8 | 6 | 26 | 22 | 1.18181818181818 | 0.45280736850426 | 0.451834286483037 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 213510890000.00 | 2026-12-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T13:49:05.616113Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 55a5b56c-97dc-4480-842f-7b9096ed5a4e | 2026-08-27 09:42 | 2026-08-27 09:42 | 2026-08-27 09:42 | CRM | CRM261016C00250000 | call | 250.0000 | 2026-10-16 | 11.0300 | 10.6500 | 11.2500 | 240.5500 | 77210.00 | 27525.00 | 49685.00 | 70 | 9 | 365 | 963 | 0.379023883696781 | 0.410745649560457 | 0.407900770368482 | false | false | false | true | ||||||||||||||||
| f677f133-7eb2-41f9-98eb-cbee76d4cc6f | 2026-08-27 09:38 | 2026-08-27 09:38 | 2026-08-27 09:38 | CRM | CRM260918C00245000 | call | 245.0000 | 2026-09-18 | 7.4300 | 6.8500 | 7.5000 | 238.6200 | 131525.00 | 111675.00 | 19110.00 | 177 | 37 | 197 | 2187 | 0.0900777320530407 | 0.426907867538907 | 0.422560050569939 | true | false | false | true | ||||||||||||||||
| 13aee33d-9d5c-4d65-b76c-e341555859d3 | 2026-08-27 09:31 | 2026-08-27 09:31 | 2026-08-27 09:31 | CRM | CRM260828C00205000 | call | 205.0000 | 2026-08-28 | 30.2800 | 29.7500 | 31.9500 | 235.6500 | 99910.00 | 0.00 | 99910.00 | 33 | 12 | 57 | 3090 | 0.0184466019417476 | 1.21018871199841 | 2.15003267041034 | false | false | false | true | ||||||||||||||||
| 1077f8fc-4e5f-4a0b-b11e-db9917ec13c8 | 2026-08-26 10:33 | 2026-08-26 10:33 | 2026-08-26 10:33 | CRM | CRM260904C00205000 | call | 205.0000 | 2026-09-04 | 8.3500 | 7.8500 | 8.3500 | 203.5200 | 346511.00 | 346511.00 | 0.00 | 415 | 57 | 438 | 243 | 1.80246913580247 | 0.702443484894695 | 0.702443484894695 | false | false | false | true | ||||||||||||||||
| 8e0e3651-75ed-41dd-96f6-0cfd3ffef680 | 2026-08-25 13:19 | 2026-08-25 13:19 | 2026-08-25 13:19 | CRM | CRM260904C00210000 | call | 210.0000 | 2026-09-04 | 7.4000 | 7.2000 | 7.4000 | 206.1300 | 159826.00 | 159826.00 | 0.00 | 216 | 39 | 811 | 1775 | 0.456901408450704 | 0.663745686180196 | 0.663745686180196 | false | false | false | true | ||||||||||||||||
| 1b0ae571-fa22-45cc-8cce-c30a3a92dd75 | 2026-08-25 11:50 | 2026-08-25 11:50 | 2026-08-25 11:50 | CRM | CRM260918P00210000 | put | 210.0000 | 2026-09-18 | 12.6500 | 12.2000 | 12.9000 | 206.9200 | 68300.00 | 53160.00 | 15140.00 | 54 | 6 | 200 | 3868 | 0.0517063081695967 | 0.529707826163018 | 0.529806126193206 | false | false | false | true | ||||||||||||||||
| 1b8a4259-39ea-4290-a443-13ff74b96769 | 2026-08-24 14:27 | 2026-08-24 14:27 | 2026-08-24 14:27 | CRM | CRM261016C00240000 | call | 240.0000 | 2026-10-16 | 5.3500 | 5.2500 | 5.5000 | 209.9900 | 74389.00 | 5350.00 | 69039.00 | 139 | 11 | 237 | 750 | 0.316 | 0.461902375002894 | 0.461517945176834 | false | false | false | true | ||||||||||||||||
| 171048c7-399d-410e-a2a7-8900fdca81b5 | 2026-08-24 10:28 | 2026-08-24 10:27 | 2026-08-24 10:27 | CRM | CRM260918P00220000 | put | 220.0000 | 2026-09-18 | 16.3600 | 15.9500 | 16.4500 | 211.5100 | 63790.00 | 34440.00 | 29350.00 | 39 | 9 | 49 | 1245 | 0.0393574297188755 | 0.53517646181056 | 0.53517646181056 | false | false | false | true | ||||||||||||||||
| 9af93703-e050-439b-ba95-ecd3ae4563e3 | 2026-08-24 10:19 | 2026-08-24 10:19 | 2026-08-24 10:19 | CRM | CRM261120C00180000 | call | 180.0000 | 2026-11-20 | 38.4800 | 37.1500 | 40.3000 | 211.4100 | 192392.00 | 0.00 | 192392.00 | 50 | 11 | 964 | 2931 | 0.328897987035142 | 0.451439775979789 | 0.451439775979789 | false | false | false | true | ||||||||||||||||
| 37de495b-7fed-4c8f-b9bb-1b2aa7a1a3ff | 2026-08-24 10:17 | 2026-08-24 10:17 | 2026-08-24 10:17 | CRM | CRM261120C00180000 | call | 180.0000 | 2026-11-20 | 38.3300 | 37.1500 | 40.3000 | 211.2950 | 199326.00 | 0.00 | 199326.00 | 52 | 9 | 914 | 2931 | 0.311838962811327 | 0.449420403797309 | 0.449420403797309 | false | false | false | true | ||||||||||||||||
| c2dcaeb7-d5d8-46ff-b31b-a1cd2613e4a6 | 2026-08-24 10:14 | 2026-08-24 10:14 | 2026-08-24 10:14 | CRM | CRM261120C00180000 | call | 180.0000 | 2026-11-20 | 38.2100 | 37.1000 | 40.3000 | 211.1000 | 175774.00 | 0.00 | 175774.00 | 46 | 8 | 862 | 2931 | 0.29409757761856 | 0.44970066371414 | 0.44970066371414 | false | false | false | true | ||||||||||||||||
| 03f2c296-987c-4123-9562-6243fcb5e8b0 | 2026-08-24 10:12 | 2026-08-24 10:12 | 2026-08-24 10:12 | CRM | CRM261120C00180000 | call | 180.0000 | 2026-11-20 | 38.4200 | 37.8000 | 40.7500 | 211.3212 | 184418.00 | 0.00 | 184418.00 | 48 | 9 | 816 | 2931 | 0.278403275332651 | 0.451508009141724 | 0.451508009141724 | false | false | false | true | ||||||||||||||||
| 79f4d95a-006a-43d5-b77b-d2261cbdfc1c | 2026-08-24 09:55 | 2026-08-24 09:55 | 2026-08-24 09:55 | CRM | CRM260904P00210000 | put | 210.0000 | 2026-09-04 | 8.6000 | 8.0000 | 8.6000 | 211.9700 | 423968.00 | 423113.00 | 855.00 | 493 | 55 | 498 | 37 | 13.4594594594595 | 0.662185791921535 | 0.662185791921535 | false | false | false | true | ||||||||||||||||
| 5ca52f6a-71c4-402b-a853-52e971be4711 | 2026-08-20 10:39 | 2026-08-20 10:38 | 2026-08-20 10:38 | CRM | CRM260918C00210000 | call | 210.0000 | 2026-09-18 | 10.0400 | 9.8500 | 10.1000 | 206.0450 | 621460.00 | 361800.00 | 204385.00 | 619 | 13 | 2081 | 8492 | 0.245054168629298 | 0.499098027872751 | 0.498681137213113 | true | false | false | true | ||||||||||||||||
| b04301c1-e70d-4f2a-b492-9f0f249baa63 | 2026-08-20 10:08 | 2026-08-20 10:08 | 2026-08-20 10:08 | CRM | CRM260918P00170000 | put | 170.0000 | 2026-09-18 | 1.3400 | 1.3200 | 1.3600 | 205.3550 | 54304.00 | 28413.00 | 15118.00 | 405 | 10 | 1369 | 9568 | 0.14308110367893 | 0.534549782210822 | 0.532390747163633 | true | false | false | true | ||||||||||||||||
| 81ce8a53-0fe2-46e5-8023-094157bee1e0 | 2026-08-19 12:26 | 2026-08-19 12:26 | 2026-08-19 12:26 | CRM | CRM260828C00190000 | call | 190.0000 | 2026-08-28 | 20.0000 | 19.9000 | 20.4000 | 207.1400 | 68016.00 | 0.00 | 68016.00 | 34 | 5 | 79 | 1621 | 0.0487353485502776 | 0.706460528833894 | 0.706460528833894 | false | false | false | true | ||||||||||||||||
| e4aabe04-a530-4d22-a742-31b037d77043 | 2026-08-19 11:09 | 2026-08-19 11:09 | 2026-08-19 11:09 | CRM | CRM260821C00210000 | call | 210.0000 | 2026-08-21 | 1.4100 | 1.3800 | 1.5500 | 205.6800 | 141352.00 | 145.00 | 141207.00 | 1002 | 36 | 2693 | 7777 | 0.346277484891346 | 0.508535153218711 | 0.510905981037709 | false | false | false | true | ||||||||||||||||
| 4f40efb4-34f7-4794-bd32-8affe7b2e9a2 | 2026-08-19 10:54 | 2026-08-19 10:54 | 2026-08-19 10:54 | CRM | CRM260918C00210000 | call | 210.0000 | 2026-09-18 | 10.4500 | 10.0500 | 10.8000 | 205.6950 | 381423.00 | 379333.00 | 1045.00 | 365 | 37 | 460 | 8128 | 0.0565944881889764 | 0.514056517998812 | 0.514056517998812 | false | false | false | true | ||||||||||||||||
| afef8587-c13d-4f2b-bd8e-bc094bc0f482 | 2026-08-18 09:39 | 2026-08-18 09:38 | 2026-08-18 09:38 | CRM | CRM260918P00175000 | put | 175.0000 | 2026-09-18 | 3.7000 | 3.3000 | 3.9500 | 194.0000 | 396607.00 | 396237.00 | 370.00 | 1072 | 69 | 1392 | 6824 | 0.203985932004689 | 0.508176009382859 | 0.505594391356091 | false | false | false | true | ||||||||||||||||
| 675a887d-aa29-4d00-964a-b2cd1c9239ec | 2026-08-17 13:31 | 2026-08-17 13:31 | 2026-08-17 13:31 | CRM | CRM260918P00175000 | put | 175.0000 | 2026-09-18 | 4.4000 | 4.3000 | 4.4500 | 190.4000 | 72590.00 | 70390.00 | 2200.00 | 165 | 31 | 335 | 6656 | 0.0503305288461538 | 0.488773807053092 | 0.488773807053092 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T13:49:05.616113Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T13:49:05.616113Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T13:38:22.111482Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T17:31:01.749779Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:49:58.488781Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:35:34.147296Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:21:20.397116Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:21:20.397116Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:21:20.397116Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:21:20.397116Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 213510890000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |