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_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 | 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 |
|---|
| 36c0077a-32c4-478d-aac5-15535f1f1033 | 2026-08-24 09:48 | 2026-08-24 09:48 | 2026-08-24 09:48 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.9500 | 0.9100 | 0.9500 | 4.4650 | 28500.00 | 28500.00 | 0.00 | 300 | 13 | 1442 | 27578 | 0.0522880556965697 | 0.625078131869692 | 0.625078131869692 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Consumer Cyclical | 8568238882.00 | 2026-11-24 | 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 |
| d423918c-4213-4065-878a-803a9d85c08b | 2026-08-25 11:08 | 2026-08-25 11:08 | 2026-08-25 11:08 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.8800 | 0.8800 | 0.9000 | 4.4460 | 24024.00 | 0.00 | 24024.00 | 273 | 7 | 844 | 29229 | 0.0288754319340381 | 0.569116617871144 | 0.569116617871144 | false | false | false | true | ||||||||||||||||
| c4498019-078c-4c1a-9817-b194cd0e2030 | 2026-08-25 11:08 | 2026-08-25 11:08 | 2026-08-25 11:08 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.8800 | 0.8800 | 0.9000 | 4.4450 | 30536.00 | 0.00 | 30536.00 | 347 | 17 | 1191 | 29229 | 0.0407472031201889 | 0.569835448108064 | 0.569835448108064 | false | false | false | true | ||||||||||||||||
| 65b83ae1-59cf-4a0a-aa7d-b632e38747a0 | 2026-08-25 11:09 | 2026-08-25 11:08 | 2026-08-25 11:08 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.8800 | 0.8800 | 0.8900 | 4.4450 | 35288.00 | 0.00 | 35288.00 | 401 | 7 | 1979 | 29229 | 0.0677067296178453 | 0.569835448108064 | 0.569835448108064 | false | false | false | true | ||||||||||||||||
| 74724ff0-56a3-4de1-aadd-42c430abdce9 | 2026-08-25 11:09 | 2026-08-25 11:09 | 2026-08-25 11:09 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.8800 | 0.8700 | 0.8800 | 4.4450 | 18832.00 | 18832.00 | 0.00 | 214 | 16 | 2496 | 29229 | 0.0853946423072975 | 0.569835448108064 | 0.569835448108064 | false | false | false | true | ||||||||||||||||
| 6ca0da47-e58a-4fbb-a628-933fae003d59 | 2026-08-25 11:09 | 2026-08-25 11:09 | 2026-08-25 11:09 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.8800 | 0.8700 | 0.8800 | 4.4450 | 30272.00 | 22176.00 | 0.00 | 344 | 16 | 2866 | 29229 | 0.0980533032262479 | 0.569835448108064 | 0.569835448108064 | false | false | false | true | ||||||||||||||||
| b97c3bb3-f66d-4199-aa52-442d4c8a083f | 2026-08-25 11:09 | 2026-08-25 11:09 | 2026-08-25 11:09 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.8800 | 0.8800 | 0.8900 | 4.4421 | 22704.00 | 0.00 | 22704.00 | 258 | 6 | 3268 | 29229 | 0.111806767251702 | 0.57191753100106 | 0.57191753100106 | false | false | false | true | ||||||||||||||||
| 13d7b0ff-fd14-4e66-bf77-ab69a6e452cd | 2026-08-25 11:09 | 2026-08-25 11:09 | 2026-08-25 11:09 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.8800 | 0.8700 | 0.8800 | 4.4450 | 13200.00 | 13200.00 | 0.00 | 150 | 11 | 3530 | 29229 | 0.120770467686202 | 0.569835448108064 | 0.569835448108064 | false | false | false | true | ||||||||||||||||
| 8f749eed-3af3-47a2-be04-323a01b69427 | 2026-08-26 11:33 | 2026-08-26 11:33 | 2026-08-26 11:33 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.8500 | 0.8500 | 0.8600 | 4.4150 | 17935.00 | 0.00 | 17935.00 | 211 | 19 | 331 | 30628 | 0.0108071046101606 | 0.562715298009285 | 0.562715298009285 | false | false | false | true | ||||||||||||||||
| 2ada6ec8-3302-4545-98a1-24d794a1bee8 | 2026-08-26 11:33 | 2026-08-26 11:33 | 2026-08-26 11:33 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.8500 | 0.8500 | 0.8600 | 4.4150 | 19975.00 | 0.00 | 19975.00 | 235 | 9 | 566 | 30628 | 0.018479822384746 | 0.562715298009285 | 0.562715298009285 | false | false | false | true | ||||||||||||||||
| ce70cbad-0cf8-42a6-8d51-d163aee55e5b | 2026-08-26 11:34 | 2026-08-26 11:33 | 2026-08-26 11:33 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.8500 | 0.8400 | 0.8500 | 4.4138 | 40205.00 | 40205.00 | 0.00 | 473 | 14 | 1039 | 30628 | 0.0339232075225284 | 0.563571284970092 | 0.563571284970092 | false | false | false | true | ||||||||||||||||
| 7181b11f-e215-4f6e-b9b0-a1a0de666312 | 2026-08-26 11:34 | 2026-08-26 11:34 | 2026-08-26 11:34 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.8500 | 0.8400 | 0.8500 | 4.4150 | 10710.00 | 7140.00 | 0.00 | 126 | 6 | 1165 | 30628 | 0.038037090244221 | 0.562715298009285 | 0.562715298009285 | false | false | false | true | ||||||||||||||||
| 4cfbdc57-bdea-4092-b4e0-b1495c6e1157 | 2026-08-26 11:44 | 2026-08-26 11:44 | 2026-08-26 11:44 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.8500 | 0.8400 | 0.8500 | 4.4150 | 11050.00 | 11050.00 | 0.00 | 130 | 18 | 1933 | 30628 | 0.0631121849288233 | 0.562715298009285 | 0.562715298009285 | false | false | false | true | ||||||||||||||||
| c4556aec-84d2-44d9-ae21-239d8ae13fe1 | 2026-09-10 09:52 | 2026-09-10 09:52 | 2026-09-10 09:52 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.3700 | 0.3600 | 0.3700 | 3.6100 | 14800.00 | 14800.00 | 0.00 | 400 | 17 | 1687 | 36350 | 0.0464099037138927 | 0.588620753610999 | 0.588620753610999 | false | false | false | true | ||||||||||||||||
| f89948e4-deaa-45c8-b961-a68969e3f056 | 2026-09-10 10:35 | 2026-09-10 10:34 | 2026-09-10 10:34 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.3600 | 0.3500 | 0.3600 | 3.6050 | 11808.00 | 11808.00 | 0.00 | 328 | 15 | 2314 | 36350 | 0.0636588720770289 | 0.579547582841871 | 0.579547582841871 | false | false | false | true | ||||||||||||||||
| 42766787-9182-4084-b115-6fefc671855f | 2026-09-18 12:39 | 2026-09-18 12:39 | 2026-09-18 12:39 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.3400 | 0.3300 | 0.3400 | 3.6473 | 30872.00 | 30872.00 | 0.00 | 908 | 29 | 1257 | 38810 | 0.0323885596495748 | 0.550836787365364 | 0.550836787365364 | false | false | false | true | ||||||||||||||||
| b413554d-b690-4ccd-8ab2-c14bd299d92d | 2026-09-18 12:40 | 2026-09-18 12:40 | 2026-09-18 12:40 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.3400 | 0.3300 | 0.3400 | 3.6400 | 17000.00 | 17000.00 | 0.00 | 500 | 29 | 1757 | 38810 | 0.0452718371553723 | 0.554922968420587 | 0.554922968420587 | false | false | false | true | ||||||||||||||||
| 1e52d111-9652-430e-a493-05d1f32db06b | 2026-09-22 15:23 | 2026-09-22 15:23 | 2026-09-22 15:23 | NIO | NIO270115C00004000 | call | 4.0000 | 2027-01-15 | 0.3600 | 0.3500 | 0.3600 | 3.7177 | 18000.00 | 18000.00 | 0.00 | 500 | 10 | 1412 | 39506 | 0.0357414063686529 | 0.544789079130657 | 0.544789079130657 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:06:33.692120Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8568238882.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:36:53.026568Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 8544892182.00 |
| 2026-11-24 |
| 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 |
| ADR |
| Consumer Cyclical |
| 8544892182.00 |
| 2026-11-24 |
| 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 |
| ADR |
| Consumer Cyclical |
| 8684972381.00 |
| 2026-11-24 |
| 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 |