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_alerts425,429 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 | expirydate |
|---|
| 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 |
|---|
| 4fd77681-f240-4084-b8c8-fd912e21c226 | 2026-08-27 12:35 | 2026-08-27 12:35 | 2026-08-27 12:35 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 2.8000 | 2.8000 | 2.9200 | 228.9100 | 687680.00 | 0.00 | 687680.00 | 2456 | 13 | 3149 | 657 | 4.79299847792998 | 0.350020299221191 | 0.350020299221191 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 5084136000000.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5a57ed64-ea31-4aa5-a0db-0e7b1cec3292 | 2026-08-27 14:12 | 2026-08-27 14:12 | 2026-08-27 14:12 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 3.1000 | 3.0500 | 3.1500 | 227.4600 | 760116.00 | 635810.00 | 306.00 | 2452 | 14 | 6033 | 657 | 9.18264840182648 | 0.350550626012918 | 0.350550626012918 | false | false | false | true | ||||||||||||||||
| 5fac5440-069c-4ad7-9dd3-4e94ecb799ff | 2026-09-15 14:52 | 2026-09-15 14:52 | 2026-09-15 14:52 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 5.0500 | 5.0500 | 5.1500 | 211.9893 | 252520.00 | 0.00 | 252520.00 | 500 | 40 | 2287 | 7558 | 0.302593278645144 | 0.3397335498163 | 0.3397335498163 | true | false | false | true | ||||||||||||||||
| 1bbb2235-0ec0-48bc-94cd-e028caedca4e | 2026-09-17 13:44 | 2026-09-17 13:44 | 2026-09-17 13:44 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 2.0300 | 2.0300 | 2.0600 | 219.3400 | 131950.00 | 0.00 | 131950.00 | 650 | 43 | 3497 | 8678 | 0.402973035261581 | 0.321587465530159 | 0.321845351489481 | true | false | false | true | ||||||||||||||||
| d9c60b02-3a76-4f07-9b02-b31fba71513a | 2026-09-21 10:48 | 2026-09-21 10:48 | 2026-09-21 10:48 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.9100 | 0.9000 | 0.9100 | 224.5850 | 34944.00 | 34853.00 | 0.00 | 384 | 25 | 2934 | 10154 | 0.288950167421706 | 0.356055457989067 | 0.356055457989067 | true | false | false | true | ||||||||||||||||
| da6078f2-5a9e-4f05-8ad7-dfc389854f1a | 2026-09-21 10:50 | 2026-09-21 10:50 | 2026-09-21 10:50 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.9200 | 0.9100 | 0.9400 | 224.4300 | 13248.00 | 0.00 | 13156.00 | 144 | 19 | 3587 | 10154 | 0.353259799093953 | 0.354841069277109 | 0.354841069277109 | false | false | false | true | ||||||||||||||||
| e3e9f00d-6448-4290-a272-f566042e77d8 | 2026-09-21 11:45 | 2026-09-21 11:45 | 2026-09-21 11:45 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.8500 | 0.8500 | 0.8700 | 225.1200 | 24310.00 | 0.00 | 24310.00 | 286 | 31 | 4527 | 10154 | 0.445834154027969 | 0.356857731406485 | 0.356857731406485 | false | false | false | true | ||||||||||||||||
| 75518df4-15fc-4832-9ffb-e8565a681d35 | 2026-09-21 11:47 | 2026-09-21 11:47 | 2026-09-21 11:47 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.8700 | 0.8500 | 0.8700 | 224.9800 | 43500.00 | 43500.00 | 0.00 | 500 | 45 | 5071 | 10154 | 0.499409099862123 | 0.357234736757948 | 0.357234736757948 | true | false | false | true | ||||||||||||||||
| b4346076-9e26-41c4-a4e0-deeaee7dccae | 2026-09-21 11:56 | 2026-09-21 11:56 | 2026-09-21 11:56 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.8600 | 0.8600 | 0.8800 | 224.8799 | 30702.00 | 0.00 | 30702.00 | 357 | 35 | 5441 | 10154 | 0.535847941697853 | 0.354426039105591 | 0.354426039105591 | false | false | false | true | ||||||||||||||||
| ac7f805c-108a-495e-bcce-6aab5a4d4efd | 2026-09-22 10:54 | 2026-09-22 10:54 | 2026-09-22 10:54 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.5000 | 0.5000 | 0.5200 | 228.1350 | 12500.00 | 0.00 | 12500.00 | 250 | 5 | 539 | 11733 | 0.0459388050796898 | 0.365660693474505 | 0.365660693474505 | false | false | false | true | ||||||||||||||||
| 19d95299-e872-4673-b110-f517f27913dd | 2026-09-22 15:27 | 2026-09-22 15:27 | 2026-09-22 15:27 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.4100 | 0.4100 | 0.4200 | 229.7600 | 189789.00 | 0.00 | 189789.00 | 4629 | 40 | 7481 | 11733 | 0.637603341004006 | 0.370715358080477 | 0.370715358080477 | false | false | false | true | ||||||||||||||||
| 7800e98c-5573-4f3a-8a38-037df76f611d | 2026-09-22 15:54 | 2026-09-22 15:53 | 2026-09-22 15:53 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.4100 | 0.4100 | 0.4200 | 229.0000 | 10250.00 | 0.00 | 10250.00 | 250 | 20 | 7821 | 11733 | 0.666581436972641 | 0.370448401290833 | 0.370451098148181 | false | false | false | true | ||||||||||||||||
| 0b6e3b82-a745-4e89-aacb-661a50e42041 | 2026-09-23 10:12 | 2026-09-23 10:12 | 2026-09-23 10:12 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.4400 | 0.4400 | 0.4600 | 226.7700 | 20020.00 | 0.00 | 20020.00 | 455 | 29 | 622 | 14213 | 0.0437627524097657 | 0.353075286368869 | 0.353075286368869 | false | false | false | true | ||||||||||||||||
| 914b3bce-71f2-4d16-a147-fdcd481e23e2 | 2026-09-23 10:13 | 2026-09-23 10:13 | 2026-09-23 10:13 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.4600 | 0.4500 | 0.4600 | 226.0000 | 23000.00 | 23000.00 | 0.00 | 500 | 29 | 1131 | 14213 | 0.0795750369380145 | 0.354695812035541 | 0.354695812035541 | true | false | false | true | ||||||||||||||||
| 093ee5fc-c269-4102-bd34-7e82b3a07b8f | 2026-09-23 10:23 | 2026-09-23 10:23 | 2026-09-23 10:23 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.5900 | 0.5700 | 0.5900 | 225.2400 | 144727.00 | 144727.00 | 0.00 | 2453 | 67 | 3915 | 14213 | 0.275452050939281 | 0.356265819112914 | 0.356265819112914 | false | false | false | true | ||||||||||||||||
| 7491dcaf-29cd-44b0-aff6-6e4945638fd7 | 2026-09-23 10:24 | 2026-09-23 10:24 | 2026-09-23 10:24 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.6000 | 0.6000 | 0.6100 | 225.2650 | 19800.00 | 0.00 | 19800.00 | 330 | 10 | 4294 | 14213 | 0.302117779497643 | 0.358305566880469 | 0.358305566880469 | false | false | false | true | ||||||||||||||||
| b3f71331-d640-43c3-a66d-2800c7d22416 | 2026-09-24 09:55 | 2026-09-24 09:54 | 2026-09-24 09:54 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.6600 | 0.6600 | 0.6700 | 222.5400 | 13200.00 | 0.00 | 13200.00 | 200 | 17 | 747 | 13840 | 0.0539739884393064 | 0.341689402578384 | 0.341689402578384 | false | false | false | true | ||||||||||||||||
| 7d7a58c6-30a5-429c-b5de-9624a16b123f | 2026-09-24 11:55 | 2026-09-24 11:55 | 2026-09-24 11:55 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.6000 | 0.6000 | 0.6200 | 222.4800 | 30000.00 | 0.00 | 30000.00 | 500 | 35 | 2395 | 13840 | 0.173049132947977 | 0.331184374745281 | 0.331184374745281 | false | false | false | true | ||||||||||||||||
| bbc81662-4840-4db7-9454-b74d1e1a5cab | 2026-09-24 12:54 | 2026-09-24 12:54 | 2026-09-24 12:54 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.4800 | 0.4700 | 0.4800 | 224.0000 | 13104.00 | 13104.00 | 0.00 | 273 | 7 | 3083 | 13840 | 0.222760115606936 | 0.338019202615084 | 0.338019202615084 | false | false | false | true | ||||||||||||||||
| 81c7d813-2f74-42c8-bf71-6a0226808486 | 2026-09-24 13:28 | 2026-09-24 13:28 | 2026-09-24 13:28 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.4900 | 0.4900 | 0.5100 | 224.0700 | 24500.00 | 0.00 | 24500.00 | 500 | 28 | 3756 | 13840 | 0.271387283236994 | 0.339861088637208 | 0.339861088637208 | true | false | false | true | ||||||||||||||||
| 6fdf79cd-91e1-4be8-ae12-d8cc1ece5e75 | 2026-09-24 14:39 | 2026-09-24 14:39 | 2026-09-24 14:39 | NVDA | NVDA261002P00210000 | put | 210.0000 | 2026-10-02 | 0.4800 | 0.4800 | 0.5000 | 224.2298 | 120000.00 | 0.00 | 120000.00 | 2500 | 8 | 6511 | 13840 | 0.470447976878613 | 0.340688429554309 | 0.340688429554309 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5286094000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:13:15.605683Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5479858000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:51:11.587541Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5479858000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:51:11.587541Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5479858000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:46:21.763749Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5479858000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:49:21.879731Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5479858000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:00:04.115943Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:27:59.988967Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5434791000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:13:13.809395Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5434791000000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:14:46.490149Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5434791000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5434791000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5434791000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:56:38.298983Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5434791000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:00:52.133329Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5434791000000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:56:09.107072Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5434791000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:30:31.713908Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5434791000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:42:17.809304Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |