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_alerts375,978 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 | price |
|---|
| 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 |
|---|
| b64429d4-9516-4b2c-af9a-d58d96aad4bb | 2026-08-18 15:57 | 2026-08-18 15:57 | 2026-08-18 15:57 | RNG | RNG260828C00066000 | call | 66.0000 | 2026-08-28 | 2.0000 | 2.0000 | 2.4500 | 65.0000 | 19400.00 | 0.00 | 19400.00 | 97 | 10 | 111 | 4 | 27.75 | 0.548956538886622 | 0.548956538886622 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 5332632648.00 | 2026-11-02 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:30:09.852702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 428c0a15-dab6-48ef-b52f-bcce9038e66d | 2026-08-27 10:23 | 2026-08-27 10:22 | 2026-08-27 10:22 | RNG | RNG260904P00069000 | put | 69.0000 | 2026-09-04 | 2.9500 | 2.6000 | 3.2000 | 67.7550 | 10325.00 | 7375.00 | 2950.00 | 35 | 5 | 65 | 0 | 0 | 0.571817604454396 | 0.571817604454396 | false | false | false | true | false | |||||||||||||||
| f1dab18f-70cd-4cb6-9a7c-2688bd84dcd2 | 2026-08-27 14:27 | 2026-08-27 14:27 | 2026-08-27 14:27 | RNG | RNG270115P00050000 | put | 50.0000 | 2027-01-15 | 2.6000 | 2.5500 | 2.7500 | 68.2200 | 26520.00 | 0.00 | 13000.00 | 102 | 20 | 388 | 1088 | 0.356617647058824 | 0.63534791235217 | 0.63534791235217 | false | false | false | true | false | |||||||||||||||
| dc76df08-6781-4d86-a27b-a4429a806dbf | 2026-09-03 09:35 | 2026-09-03 09:34 | 2026-09-03 09:34 | RNG | RNG280121C00100000 | call | 100.0000 | 2028-01-21 | 15.0000 | 12.5000 | 15.0000 | 76.8900 | 150000.00 | 150000.00 | 0.00 | 100 | 5 | 100 | 0 | 0 | 0.575287527478941 | 0.575287527478941 | false | false | false | true | false | |||||||||||||||
| a459c226-b28e-466d-a214-7c8438bacd51 | 2026-09-03 12:40 | 2026-09-03 12:39 | 2026-09-03 12:39 | RNG | RNG261002P00065000 | put | 65.0000 | 2026-10-02 | 0.7000 | 0.7000 | 1.1000 | 76.7300 | 23730.00 | 0.00 | 23730.00 | 339 | 20 | 341 | 0 | 0 | 0.535026284860977 | 0.535026284860977 | false | false | false | true | false | |||||||||||||||
| 9a9afd88-e0b7-4729-8c15-3b2a93c32513 | 2026-09-03 12:40 | 2026-09-03 12:39 | 2026-09-03 12:39 | RNG | RNG261002P00065000 | put | 65.0000 | 2026-10-02 | 0.7000 | 0.6500 | 1.1000 | 76.7300 | 17780.00 | 0.00 | 16240.00 | 254 | 28 | 595 | 0 | 0 | 0.535026284860977 | 0.535026284860977 | false | false | false | true | false | |||||||||||||||
| 2ae36a6d-74d7-47b3-80e8-9e39920fac11 | 2026-09-04 11:12 | 2026-09-04 11:11 | 2026-09-04 11:11 | RNG | RNG280121C00080000 | call | 80.0000 | 2028-01-21 | 19.6000 | 18.0000 | 21.5000 | 74.6050 | 1117200.00 | 0.00 | 1117200.00 | 570 | 1 | 570 | 156 | 3.65384615384615 | 0.579117904536244 | 0.579117904536244 | false | true | false | true | true | |||||||||||||||
| 42144d2b-e58c-4b13-b3b4-ab38a83f85be | 2026-09-08 10:11 | 2026-09-08 10:11 | 2026-09-08 10:11 | RNG | RNG260918C00060000 | call | 60.0000 | 2026-09-18 | 9.9900 | 9.5000 | 10.6000 | 69.6600 | 76915.00 | 0.00 | 76915.00 | 77 | 22 | 77 | 201 | 0.383084577114428 | 0.686356766929005 | 0.686356766929005 | false | false | false | true | false | |||||||||||||||
| cca81cc7-0e4b-4250-aebb-b1d82ff47e29 | 2026-09-11 10:15 | 2026-09-11 10:15 | 2026-09-11 10:15 | RNG | RNG260911P00068000 | put | 68.0000 | 2026-09-11 | 0.5500 | 0.2500 | 0.6000 | 68.3450 | 10835.00 | 10835.00 | 0.00 | 197 | 12 | 197 | 7 | 28.1428571428571 | 1.01955468118166 | 1.01955468118166 | false | false | false | true | false | |||||||||||||||
| ac7ec5e4-a0b7-48e2-8bc0-0bf7cc82d405 | 2026-09-16 13:56 | 2026-09-16 13:56 | 2026-09-16 13:56 | RNG | RNG270416C00075000 | call | 75.0000 | 2027-04-16 | 13.0000 | 11.9000 | 14.3000 | 74.0000 | 741000.00 | 0.00 | 741000.00 | 570 | 1 | 570 | 3 | 190 | 0.545724291933006 | 0.545724291933006 | false | true | false | true | true | |||||||||||||||
| 110e5036-51bd-4839-be0e-b3b33abe46c9 | 2026-09-17 13:03 | 2026-09-17 13:03 | 2026-09-17 13:03 | RNG | RNG261009P00065000 | put | 65.0000 | 2026-10-09 | 0.7000 | 0.6000 | 0.9000 | 74.2300 | 42840.00 | 1610.00 | 41230.00 | 612 | 42 | 1168 | 2 | 584 | 0.522131305970354 | 0.530699795548603 | false | false | false | true | false | |||||||||||||||
| fb543016-5505-4c54-b0e1-3283e1df4533 | 2026-09-18 14:42 | 2026-09-18 14:42 | 2026-09-18 14:42 | RNG | RNG261016C00065000 | call | 65.0000 | 2026-10-16 | 8.9000 | 8.9000 | 9.8000 | 72.4600 | 106800.00 | 0.00 | 106800.00 | 120 | 11 | 123 | 137 | 0.897810218978102 | 0.521039439286635 | 0.521039439286635 | false | false | false | true | false | |||||||||||||||
| 2dfe5442-ed57-44cd-8c21-d2672f180807 | 2026-09-21 10:03 | 2026-09-21 10:03 | 2026-09-21 10:03 | RNG | RNG260925C00079000 | call | 79.0000 | 2026-09-25 | 0.8000 | 0.0500 | 0.8000 | 74.9950 | 23997.00 | 23997.00 | 0.00 | 300 | 30 | 300 | 14 | 21.4285714285714 | 0.700029260756192 | 0.700029260756192 | false | false | false | true | false | |||||||||||||||
| c703ef6e-0691-4e08-b212-118b6599bb43 | 2026-09-21 12:39 | 2026-09-21 12:38 | 2026-09-21 12:38 | RNG | RNG280121P00075000 | put | 75.0000 | 2028-01-21 | 17.6100 | 15.0000 | 18.4000 | 75.7950 | 44025.00 | 40495.00 | 3530.00 | 25 | 6 | 37 | 15 | 2.46666666666667 | 0.613827514755906 | 0.612237220247953 | false | false | false | true | false | |||||||||||||||
| ede77be8-9cbb-4e51-bdfc-5edfc778fb01 | 2026-09-21 13:50 | 2026-09-21 13:49 | 2026-09-21 13:49 | RNG | RNG280121P00075000 | put | 75.0000 | 2028-01-21 | 17.5300 | 17.5000 | 18.1000 | 76.4300 | 28050.00 | 0.00 | 28050.00 | 16 | 5 | 63 | 15 | 4.2 | 0.617122490839955 | 0.615535796163101 | false | false | false | true | false | |||||||||||||||
| 8f5c866b-0945-42f9-97b8-04dd9936ce8c | 2026-09-21 14:20 | 2026-09-21 14:20 | 2026-09-21 14:20 | RNG | RNG270115P00050000 | put | 50.0000 | 2027-01-15 | 1.1000 | 1.1000 | 1.2500 | 76.5000 | 45650.00 | 0.00 | 45650.00 | 415 | 7 | 618 | 1588 | 0.389168765743073 | 0.625913235915406 | 0.625913235915406 | false | false | false | true | false | |||||||||||||||
| a42819f5-874a-44e8-8a9d-39bf8e5b9569 | 2026-09-23 15:40 | 2026-09-23 15:39 | 2026-09-23 15:39 | RNG | RNG261023C00083000 | call | 83.0000 | 2026-10-23 | 3.6000 | 2.8500 | 3.6000 | 79.2450 | 39960.00 | 39960.00 | 0.00 | 111 | 20 | 6113 | 0 | 0 | 0.557317541894698 | 0.557317541894698 | false | false | false | true | false | |||||||||||||||
| d641e067-7be5-454d-966a-813cd17d634e | 2026-09-23 15:48 | 2026-09-23 15:48 | 2026-09-23 15:48 | RNG | RNG261023P00078000 | put | 78.0000 | 2026-10-23 | 4.9000 | 4.9000 | 5.5000 | 79.2150 | 156800.00 | 0.00 | 156800.00 | 320 | 17 | 5207 | 0 | 0 | 0.625173618594098 | 0.625173618594098 | false | false | false | true | false | |||||||||||||||
| 97649d3a-03f3-4ef2-a360-ced07eac0f9d | 2026-09-23 15:48 | 2026-09-23 15:48 | 2026-09-23 15:48 | RNG | RNG261023P00078000 | put | 78.0000 | 2026-10-23 | 4.9000 | 4.9000 | 5.5000 | 79.2150 | 58800.00 | 0.00 | 58800.00 | 120 | 6 | 5327 | 0 | 0 | 0.625173618594098 | 0.625173618594098 | false | false | false | true | false | |||||||||||||||
| 822a33db-8621-4ea7-9619-ca6011833487 | 2026-09-23 15:48 | 2026-09-23 15:48 | 2026-09-23 15:48 | RNG | RNG261023P00078000 | put | 78.0000 | 2026-10-23 | 4.9000 | 4.9000 | 5.3000 | 79.2150 | 88200.00 | 0.00 | 88200.00 | 180 | 9 | 5507 | 0 | 0 | 0.625173618594098 | 0.625173618594098 | false | false | false | true | false | |||||||||||||||
| 9e5eeb39-c0bf-4949-8776-fc1a43ee7f47 | 2026-09-23 15:59 | 2026-09-23 15:59 | 2026-09-23 15:59 | RNG | RNG261120P00070000 | put | 70.0000 | 2026-11-20 | 3.8000 | 3.2000 | 3.8000 | 79.0000 | 38000.00 | 38000.00 | 0.00 | 100 | 5 | 102 | 3 | 34 | 0.653950913038086 | 0.654461467149719 | true | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5332632648.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5332632648.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5332632648.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5332632648.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5332632648.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Technology |
| 5332632648.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:23:10.886670Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5332632648.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:14:21.867252Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5332632648.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:26:53.669819Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Technology |
| 5422591329.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5514024743.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5298713801.00 |
| 2026-11-02 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5699841035.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:04:59.983035Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5699841035.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:41:29.676906Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5699841035.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:50:05.863152Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5699841035.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:20:26.028708Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5842152720.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:42:45.926021Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5842152720.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:51:14.662813Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5842152720.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:51:14.662813Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5842152720.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:51:14.662813Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5842152720.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |