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 | 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 |
|---|
| 8136b84b-7751-4cb1-a77d-1513a691d24a | 2026-08-18 10:46 | 2026-08-18 10:46 | 2026-08-18 10:46 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 0.7100 | 0.6900 | 0.7100 | 14.5150 | 16259.00 | 16259.00 | 0.00 | 229 | 44 | 394 | 17527 | 0.0224796028983853 | 0.531419865960497 | 0.532777037073454 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 22901017342.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8811fec9-a87c-4ce7-9d3e-f755690354fe | 2026-08-20 09:52 | 2026-08-20 09:52 | 2026-08-20 09:52 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 1.3400 | 1.3400 | 1.3500 | 15.6850 | 79864.00 | 0.00 | 27604.00 | 596 | 18 | 615 | 17714 | 0.0347183019080953 | 0.540369232182772 | 0.540369232182772 | false | false | false | true | ||||||||||||||||
| 9c6e6b65-aef0-4181-996e-47dcd845e3f0 | 2026-08-20 09:52 | 2026-08-20 09:52 | 2026-08-20 09:52 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 1.3800 | 1.3300 | 1.3800 | 15.7300 | 26496.00 | 26496.00 | 0.00 | 192 | 5 | 855 | 17714 | 0.0482669075307666 | 0.546836012560759 | 0.546836012560759 | false | false | false | true | ||||||||||||||||
| 8b809f4a-29de-4f6f-80a2-d59891aee10e | 2026-08-20 11:57 | 2026-08-20 11:57 | 2026-08-20 11:57 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 1.5100 | 1.4800 | 1.5100 | 15.9000 | 11778.00 | 11778.00 | 0.00 | 78 | 12 | 1039 | 17714 | 0.0586541718414813 | 0.556910565151898 | 0.556910565151898 | false | false | false | true | ||||||||||||||||
| 04e9e8a7-d250-4cca-ab5d-acbb7b3c0837 | 2026-08-21 09:54 | 2026-08-21 09:54 | 2026-08-21 09:54 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 2.0800 | 1.9300 | 2.0900 | 16.6300 | 41538.00 | 41538.00 | 0.00 | 200 | 22 | 1156 | 18134 | 0.0637476563361641 | 0.601374189900984 | 0.594304494224898 | false | false | false | true | ||||||||||||||||
| ef928844-c4a0-4a13-8ce9-b648d8c2d251 | 2026-08-21 09:57 | 2026-08-21 09:57 | 2026-08-21 09:57 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 2.1000 | 2.0500 | 2.1000 | 16.6650 | 10495.00 | 10495.00 | 0.00 | 50 | 7 | 1442 | 18134 | 0.0795191353259071 | 0.589378310129881 | 0.589378310129881 | false | false | false | true | ||||||||||||||||
| 383124fe-b63d-40e0-9988-40d66cc96c8e | 2026-08-21 09:59 | 2026-08-21 09:59 | 2026-08-21 09:59 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 2.1100 | 2.0000 | 2.1200 | 16.6700 | 42260.00 | 42260.00 | 0.00 | 200 | 26 | 1892 | 18134 | 0.104334399470608 | 0.603633029863527 | 0.593774794283787 | false | false | false | true | ||||||||||||||||
| 7658f302-fd40-4df1-b2e9-13d3cfebc062 | 2026-08-21 10:00 | 2026-08-21 10:00 | 2026-08-21 10:00 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 2.2100 | 2.0400 | 2.2200 | 16.7350 | 44290.00 | 19980.00 | 0.00 | 200 | 10 | 2092 | 18134 | 0.115363405757141 | 0.636360250233974 | 0.636360250233974 | false | false | false | true | ||||||||||||||||
| 6fb405be-9b4c-4707-98f8-5dbfc8f81a13 | 2026-08-21 10:03 | 2026-08-21 10:03 | 2026-08-21 10:03 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 2.2100 | 2.0800 | 2.2100 | 16.7200 | 44200.00 | 44200.00 | 0.00 | 200 | 18 | 3092 | 18134 | 0.170508437189809 | 0.637397032903743 | 0.637397032903743 | false | false | false | true | ||||||||||||||||
| 1d31e289-3d99-472f-a16e-273672927e76 | 2026-08-21 10:04 | 2026-08-21 10:04 | 2026-08-21 10:04 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 2.2400 | 2.0800 | 2.2400 | 16.7650 | 44800.00 | 44800.00 | 0.00 | 200 | 10 | 3492 | 18134 | 0.192566449762876 | 0.634217425664918 | 0.634217425664918 | false | false | false | true | ||||||||||||||||
| e3151c76-b2e6-4e7f-bd0d-24303946a153 | 2026-08-21 10:04 | 2026-08-21 10:04 | 2026-08-21 10:04 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 2.2200 | 2.0800 | 2.2200 | 16.7850 | 30192.00 | 30192.00 | 0.00 | 136 | 14 | 3628 | 18134 | 0.200066174037719 | 0.608801521259232 | 0.608801521259232 | false | false | false | true | ||||||||||||||||
| 3f2c986b-402f-4389-bf56-f38bd154bf7b | 2026-08-21 10:04 | 2026-08-21 10:04 | 2026-08-21 10:04 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 2.2200 | 2.0800 | 2.2200 | 16.7850 | 14177.00 | 14177.00 | 0.00 | 64 | 7 | 3692 | 18134 | 0.20359545604941 | 0.601537867676836 | 0.608801521259232 | true | false | false | true | ||||||||||||||||
| 5cea7085-31ca-44c4-9f22-1041ea256ef0 | 2026-08-21 10:31 | 2026-08-21 10:30 | 2026-08-21 10:30 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 2.0600 | 1.9700 | 2.0600 | 16.5650 | 23690.00 | 23690.00 | 0.00 | 115 | 9 | 4371 | 18134 | 0.241038932392191 | 0.614857856502299 | 0.614857856502299 | false | false | false | true | ||||||||||||||||
| 9ef90189-3109-4d75-9db8-a7cd53ccbcac | 2026-08-21 15:40 | 2026-08-21 15:40 | 2026-08-21 15:40 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 2.4500 | 2.4300 | 2.4500 | 17.1350 | 10535.00 | 10535.00 | 0.00 | 43 | 5 | 4664 | 18134 | 0.257196426601963 | 0.569632536542801 | 0.569632536542801 | false | false | false | true | ||||||||||||||||
| c74f99d2-0b19-4840-a111-9b3f5ca4e567 | 2026-08-28 14:40 | 2026-08-28 14:39 | 2026-08-28 14:39 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 1.2300 | 1.2000 | 1.2300 | 15.7450 | 39360.00 | 39360.00 | 0.00 | 320 | 26 | 548 | 19862 | 0.027590373577686 | 0.531396765786862 | 0.531396765786862 | false | false | false | true | ||||||||||||||||
| d24f31d2-858a-48d5-b7b1-7859b6a676cf | 2026-08-28 14:57 | 2026-08-28 14:57 | 2026-08-28 14:57 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 1.2500 | 1.2000 | 1.2600 | 15.7850 | 47500.00 | 47500.00 | 0.00 | 380 | 8 | 965 | 19862 | 0.048585238143188 | 0.52600365074626 | 0.52600365074626 | false | false | false | true | ||||||||||||||||
| b6e5f8a4-5f00-4c6f-9151-a569c4aa4f4e | 2026-09-17 10:08 | 2026-09-17 10:08 | 2026-09-17 10:08 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 0.9000 | 0.7700 | 0.9600 | 15.8600 | 12648.00 | 8910.00 | 3738.00 | 141 | 5 | 893 | 21584 | 0.0413732394366197 | 0.87708296656923 | 1.19625975263791 | false | false | false | true | ||||||||||||||||
| a7ca968e-50a2-407c-af32-0c7bdab35210 | 2026-09-17 10:13 | 2026-09-17 10:13 | 2026-09-17 10:13 | RIVN | RIVN260918C00015000 | call | 15.0000 | 2026-09-18 | 0.9900 | 0.9400 | 1.0300 | 15.9500 | 26829.00 | 10791.00 | 16038.00 | 271 | 5 | 1232 | 21584 | 0.0570793180133432 | 0.939379106521397 | 0.939379106521397 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T18:46:22.896033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22901017342.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T19:10:32.565799Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22236801202.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22236801202.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |