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_alerts523,327 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 |
|---|
| 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 |
|---|
| afdb86af-c920-4527-a66c-fbdc71e76de7 | 2026-09-28 14:07 | 2026-09-28 14:07 | 2026-09-28 14:07 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 6.2000 | 6.1500 | 6.3000 | 721.0000 | 56420.00 | 55800.00 | 620.00 | 91 | 14 | 1689 | 2991 | 0.56469408224674 | 0.387960641555394 | 0.387960641555394 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1578034063611.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T18:10:39.755253Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 83aefc14-d227-4a2d-aa22-4093ccc0e55a | 2026-09-28 14:07 | 2026-09-28 14:07 | 2026-09-28 14:07 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 6.2000 | 6.1500 | 6.2500 | 721.0000 | 93620.00 | 93000.00 | 620.00 | 151 | 17 | 1546 | 2991 | 0.516883985289201 | 0.388311807431898 | 0.388311807431898 | false | false | false | true | ||||||||||||||||
| cb1dd80d-f401-49cb-8f5d-04ce317307d8 | 2026-09-28 14:07 | 2026-09-28 14:07 | 2026-09-28 14:07 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 6.2000 | 6.1500 | 6.3500 | 721.0000 | 209560.00 | 19220.00 | 190340.00 | 338 | 26 | 1395 | 2991 | 0.466399197592778 | 0.388311807431898 | 0.388311807431898 | false | false | false | |||||||||||||||||
| 52980e11-579a-4d4c-86f7-a95b35fa7cdd | 2026-09-28 14:07 | 2026-09-28 14:07 | 2026-09-28 14:07 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 6.2000 | 6.1000 | 6.3500 | 721.0000 | 216380.00 | 6200.00 | 210180.00 | 349 | 32 | 1055 | 2991 | 0.352724841190237 | 0.388311807431898 | 0.388311807431898 | false | false | false | |||||||||||||||||
| acc632a5-2c59-41ce-9816-5d5a0d304811 | 2026-09-28 10:50 | 2026-09-28 10:50 | 2026-09-28 10:50 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 7.0000 | 7.0000 | 7.3000 | 718.7750 | 14700.00 | 0.00 | 14700.00 | 21 | 7 | 548 | 2991 | 0.183216315613507 | 0.394992701976123 | 0.394904490206947 | false | false | false | true | ||||||||||||||||
| 44b90eb0-9bd7-4bd2-870d-72ae933821a3 | 2026-09-28 09:30 | 2026-09-28 09:30 | 2026-09-28 09:30 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 4.7000 | 4.4500 | 4.7000 | 742.2950 | 15040.00 | 15040.00 | 0.00 | 32 | 8 | 33 | 2991 | 0.0110330992978937 | 0.430922007524694 | 0.430922007524694 | false | false | false | true | ||||||||||||||||
| d8f7c94d-ec2a-49d2-b59f-a5cc61538306 | 2026-09-25 15:15 | 2026-09-25 15:15 | 2026-09-25 15:15 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 3.7500 | 3.7000 | 3.7500 | 751.5000 | 18000.00 | 18000.00 | 0.00 | 48 | 11 | 2189 | 2648 | 0.82666163141994 | 0.402948809341327 | 0.402948809341327 | false | false | false | true | ||||||||||||||||
| 60946625-d071-45b0-b9b9-e124dfe09015 | 2026-09-25 14:35 | 2026-09-25 14:35 | 2026-09-25 14:35 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 3.7000 | 3.6000 | 3.7000 | 751.7099 | 24790.00 | 24790.00 | 0.00 | 67 | 12 | 2090 | 2648 | 0.789274924471299 | 0.40207555663083 | 0.40207555663083 | false | false | false | true | ||||||||||||||||
| 0126e510-d8dc-4d8f-87b8-0c3bc6f020f7 | 2026-09-25 13:36 | 2026-09-25 13:36 | 2026-09-25 13:36 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 3.7000 | 3.6500 | 3.8000 | 750.0000 | 111102.00 | 6660.00 | 104442.00 | 300 | 40 | 790 | 2648 | 0.29833836858006 | 0.399603239490609 | 0.398374164451327 | false | false | false | true | ||||||||||||||||
| d58073e7-d591-4a52-a114-c181d1078eba | 2026-09-25 11:11 | 2026-09-25 11:10 | 2026-09-25 11:10 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 3.8000 | 3.7500 | 3.8000 | 752.0450 | 10260.00 | 10260.00 | 0.00 | 27 | 7 | 283 | 2648 | 0.106873111782477 | 0.406224786823862 | 0.406224786823862 | false | false | false | true | ||||||||||||||||
| c1c1eef6-dda5-40d0-9c82-aadaa5836a3e | 2026-09-23 15:19 | 2026-09-23 15:19 | 2026-09-23 15:19 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 6.9200 | 6.9000 | 7.0000 | 747.9150 | 20756.00 | 4865.00 | 13806.00 | 30 | 8 | 984 | 1823 | 0.53976961053209 | 0.455828031457284 | 0.454679572079564 | false | false | false | true | ||||||||||||||||
| d68028c0-32c7-4358-9e56-18db00c79103 | 2026-09-23 13:33 | 2026-09-23 13:33 | 2026-09-23 13:33 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 7.0300 | 7.0000 | 7.1500 | 748.3200 | 19690.00 | 0.00 | 19690.00 | 28 | 7 | 705 | 1823 | 0.386725178277564 | 0.459503763491559 | 0.458359179676136 | false | false | false | true | ||||||||||||||||
| 458736e3-3dba-44cb-8646-feccc886b64a | 2026-09-23 13:33 | 2026-09-23 13:33 | 2026-09-23 13:33 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 7.0200 | 7.0000 | 7.1500 | 748.3850 | 27395.00 | 3525.00 | 23870.00 | 39 | 9 | 666 | 1823 | 0.365331870543061 | 0.459726190513562 | 0.458581341698993 | false | false | false | true | ||||||||||||||||
| 2778c89c-cb65-45a7-9226-c1c4383b3ea5 | 2026-09-22 09:32 | 2026-09-22 09:32 | 2026-09-22 09:32 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 8.1000 | 8.1000 | 8.4000 | 741.4600 | 40500.00 | 0.00 | 32400.00 | 50 | 18 | 63 | 1847 | 0.0341093665403357 | 0.449231328687638 | 0.449231328687638 | false | false | false | true | ||||||||||||||||
| 562dad0f-d87e-47dd-8723-17db811bb009 | 2026-09-21 14:24 | 2026-09-21 14:24 | 2026-09-21 14:24 | META | META261016P00670000 | put | 670.0000 | 2026-10-16 | 8.6500 | 8.5500 | 8.7000 | 746.2000 | 12110.00 | 10380.00 | 1730.00 | 14 | 7 | 2073 | 1700 | 1.21941176470588 | 0.468023926500972 | 0.468006806460982 | false | false | false | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:10:39.755253Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:10:39.755253Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:10:39.755253Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:52:34.097246Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:30:57.841770Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:17:13.698421Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:38:37.498256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:41:26.046305Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:11:41.812883Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:19:13.860823Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:39:01.188751Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:39:01.188751Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:32:27.895939Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |