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_alerts728,802 rows| 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 |
|---|
| a302dd95-0449-4189-bedc-475cc2ac053a | 2026-09-23 15:01 | 2026-09-23 15:01 | 2026-09-23 15:01 | MU | MU261016C01140000 | call | 1140.0000 | 2026-10-16 | 44.3400 | 44.0500 | 44.7000 | 1070.7100 | 26605.00 | 13305.00 | 13300.00 | 6 | 6 | 80 | 706 | 0.113314447592068 | 0.660410918056416 | 0.659440859947456 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 1210573930694.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T19:05:07.702473Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| c3502140-9877-4d8b-9232-8668ab13085a | 2026-09-25 10:29 | 2026-09-25 10:29 | 2026-09-25 10:29 | MU | MU261016C01140000 | call | 1140.0000 | 2026-10-16 | 42.6100 | 42.5000 | 43.2500 | 1077.5550 | 63920.00 | 0.00 | 63920.00 | 15 | 12 | 45 | 685 | 0.0656934306569343 | 0.646619402658269 | 0.646619402658269 | false | false | false | |||||||||||||||||
| 54f190c2-0c3d-46d1-883f-d31cad1f9fd1 | 2026-09-25 10:42 | 2026-09-25 10:42 | 2026-09-25 10:42 | MU | MU261016C01140000 | call | 1140.0000 | 2026-10-16 | 43.4100 | 43.2500 | 44.0500 | 1081.3200 | 26046.00 | 0.00 | 26046.00 | 6 | 6 | 102 | 685 | 0.148905109489051 | 0.639468962162483 | 0.639468962162483 | false | false | false | |||||||||||||||||
| d3b87131-cc19-4335-a220-e200179808c8 | 2026-09-25 11:46 | 2026-09-25 11:46 | 2026-09-25 11:46 | MU | MU261016C01140000 | call | 1140.0000 | 2026-10-16 | 40.9400 | 40.5000 | 41.6000 | 1077.0643 | 102352.00 | 0.00 | 102352.00 | 25 | 10 | 236 | 685 | 0.344525547445255 | 0.631718120156551 | 0.631718120156551 | false | false | false | |||||||||||||||||
| 1369777a-215b-4e42-b260-cef17f29e5dd | 2026-09-25 12:49 | 2026-09-25 12:49 | 2026-09-25 12:49 | MU | MU261016C01140000 | call | 1140.0000 | 2026-10-16 | 40.5200 | 40.0500 | 41.4000 | 1077.4525 | 101304.00 | 0.00 | 101304.00 | 25 | 8 | 334 | 685 | 0.487591240875912 | 0.625852937252359 | 0.625852937252359 | false | false | false | |||||||||||||||||
| c930c1b0-3574-4aa9-b91c-0301146061d8 | 2026-09-30 15:56 | 2026-09-30 15:56 | 2026-09-30 15:56 | MU | MU261016C01140000 | call | 1140.0000 | 2026-10-16 | 31.1100 | 31.0500 | 31.2500 | 1064.5400 | 24885.00 | 3110.00 | 21775.00 | 8 | 5 | 290 | 457 | 0.634573304157549 | 0.663533892710083 | 0.662922010400188 | true | false | false | |||||||||||||||||
| 0e874137-32d9-439a-be73-7dacb3fe7b49 | 2026-09-30 15:56 | 2026-09-30 15:56 | 2026-09-30 15:56 | MU | MU261016C01140000 | call | 1140.0000 | 2026-10-16 | 31.1000 | 31.0000 | 31.3500 | 1064.3848 | 18659.00 | 3123.00 | 15536.00 | 6 | 5 | 301 | 457 | 0.658643326039387 | 0.665221505160099 | 0.66369103203505 | true | false | false | |||||||||||||||||
| 1034da64-b25d-4ce9-b7c2-83609d034d07 | 2026-09-30 15:56 | 2026-09-30 15:56 | 2026-09-30 15:56 | MU | MU261016C01140000 | call | 1140.0000 | 2026-10-16 | 31.1400 | 31.0500 | 31.5000 | 1065.1350 | 15570.00 | 3134.00 | 12436.00 | 5 | 5 | 331 | 457 | 0.724288840262582 | 0.663373822028459 | 0.660564172410432 | true | false | false | |||||||||||||||||
| 7a3ddc90-2496-460a-873b-ed46b0f62309 | 2026-09-30 15:56 | 2026-09-30 15:56 | 2026-09-30 15:56 | MU | MU261016C01140000 | call | 1140.0000 | 2026-10-16 | 31.0000 | 30.9500 | 31.0000 | 1065.1450 | 120890.00 | 86800.00 | 6190.00 | 39 | 37 | 379 | 457 | 0.829321663019694 | 0.659177812552034 | 0.65856639996423 | false | false | false | |||||||||||||||||
| 1d25d909-811d-4f35-9528-1a366a08dea6 | 2026-10-01 09:44 | 2026-10-01 09:44 | 2026-10-01 09:44 | MU | MU261016C01140000 | call | 1140.0000 | 2026-10-16 | 17.7300 | 17.1000 | 18.0000 | 1051.7587 | 28375.00 | 15995.00 | 12380.00 | 16 | 9 | 38 | 628 | 0.0605095541401274 | 0.560092076958967 | 0.557442226940935 | true | false | false | |||||||||||||||||
| 53fee051-cd1c-4af6-be6d-f1f4c3f1e7a2 | 2026-10-02 15:57 | 2026-10-02 15:56 | 2026-10-02 15:56 | MU | MU261016C01140000 | call | 1140.0000 | 2026-10-16 | 16.5700 | 16.5000 | 16.5500 | 1074.9800 | 44750.00 | 44750.00 | 0.00 | 27 | 7 | 2405 | 750 | 3.20666666666667 | 0.470231158465458 | 0.469528746599055 | true | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:33:57.900979Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:43:48.295772Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:51:49.898119Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:52:03.026935Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:59:18.109572Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:59:18.109572Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:59:18.109572Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:59:18.109572Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1239384749976.00 |
| 2026-12-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:44:24.931446Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1213973404078.00 |
| 2026-12-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T19:58:04.178377Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |