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 | expiry |
|---|
| 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 |
|---|
| efd641a1-a361-4553-a2b7-7c70c8d5201f | 2026-09-28 15:43 | 2026-09-28 15:43 | 2026-09-28 15:43 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 16.4000 | 16.0000 | 16.4500 | 509.1000 | 13120.00 | 1640.00 | 11480.00 | 8 | 8 | 193 | 4029 | 0.0479027053859519 | 0.323899828529684 | 0.323899828529684 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 3781236274927.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| d5bf8db7-58c8-4c19-9ca4-a2cd1e754072 | 2026-09-28 15:43 | 2026-09-28 15:43 | 2026-09-28 15:43 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 16.4000 | 16.4000 | 16.4500 | 508.9000 | 11480.00 | 0.00 | 11480.00 | 7 | 7 | 185 | 4029 | 0.0459171010176222 | 0.323470897764017 | 0.323470897764017 | false | false | false | true | ||||||||||||||||
| ac9d05f9-fabb-45fe-80a4-553c5b8ba2c3 | 2026-09-28 15:43 | 2026-09-28 15:42 | 2026-09-28 15:42 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 16.3500 | 16.3500 | 16.4500 | 509.1200 | 11445.00 | 0.00 | 11445.00 | 7 | 7 | 161 | 4029 | 0.0399602879126334 | 0.323464590378138 | 0.323464590378138 | false | false | false | true | ||||||||||||||||
| 79e102dc-f215-442d-950d-a0facfeb49b2 | 2026-09-28 15:43 | 2026-09-28 15:42 | 2026-09-28 15:42 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 16.3500 | 16.2000 | 16.4500 | 509.1500 | 14715.00 | 1635.00 | 13080.00 | 9 | 8 | 170 | 4029 | 0.0421940928270042 | 0.323528857051018 | 0.323528857051018 | false | false | false | true | ||||||||||||||||
| 1fd925e6-b4df-4d01-9093-95f48a991c18 | 2026-09-28 15:43 | 2026-09-28 15:42 | 2026-09-28 15:42 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 16.3500 | 16.3000 | 16.4000 | 509.1800 | 11445.00 | 0.00 | 1635.00 | 7 | 7 | 177 | 4029 | 0.0439314966492926 | 0.323593114057305 | 0.323593114057305 | true | false | false | true | ||||||||||||||||
| b50e320f-d7ef-43ec-ac54-278d86c39670 | 2026-09-28 15:42 | 2026-09-28 15:42 | 2026-09-28 15:42 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 16.3500 | 16.3000 | 16.4500 | 509.0600 | 21255.00 | 0.00 | 21255.00 | 13 | 12 | 153 | 4029 | 0.0379746835443038 | 0.323336028016408 | 0.323336028016408 | false | false | false | true | ||||||||||||||||
| 05a79d0e-d6d6-457c-a4bc-b989b8f151df | 2026-09-28 15:42 | 2026-09-28 15:42 | 2026-09-28 15:42 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 16.3500 | 16.2500 | 16.4000 | 509.1500 | 13080.00 | 1635.00 | 9810.00 | 8 | 8 | 140 | 4029 | 0.0347480764457682 | 0.323528857051018 | 0.323528857051018 | false | false | false | true | ||||||||||||||||
| 7d4f3807-68d8-4d16-989b-7e10fdc921b9 | 2026-09-28 15:42 | 2026-09-28 15:42 | 2026-09-28 15:42 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 16.3500 | 16.3500 | 16.5000 | 509.1800 | 13080.00 | 0.00 | 13080.00 | 8 | 8 | 124 | 4029 | 0.030776867709109 | 0.323593114057305 | 0.323593114057305 | false | false | false | true | ||||||||||||||||
| cf8ef25c-16e0-43c6-99ac-40834c0a5a9e | 2026-09-28 15:42 | 2026-09-28 15:42 | 2026-09-28 15:42 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 16.3000 | 16.3000 | 16.5000 | 509.1350 | 13040.00 | 0.00 | 13040.00 | 8 | 8 | 116 | 4029 | 0.0287912633407794 | 0.32301831462323 | 0.32301831462323 | false | false | false | true | ||||||||||||||||
| bcd730e5-b1f3-4429-a62a-8e5221422886 | 2026-09-28 15:41 | 2026-09-28 15:41 | 2026-09-28 15:41 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 16.3000 | 16.3000 | 16.6000 | 509.1800 | 13040.00 | 0.00 | 13040.00 | 8 | 8 | 107 | 4029 | 0.0265574584264085 | 0.322932656422783 | 0.323114659562013 | false | false | false | true | ||||||||||||||||
| 05c542f1-6e84-41a1-8bfb-669c83aad453 | 2026-09-28 15:41 | 2026-09-28 15:41 | 2026-09-28 15:41 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 16.3500 | 16.2000 | 16.4000 | 508.0000 | 13080.00 | 1635.00 | 11445.00 | 8 | 8 | 99 | 4029 | 0.0245718540580789 | 0.322993005690395 | 0.322993005690395 | false | false | false | true | ||||||||||||||||
| cf7b1727-34d3-4677-955e-b285825f49eb | 2026-09-28 15:40 | 2026-09-28 15:40 | 2026-09-28 15:40 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 16.3500 | 16.3500 | 16.4500 | 508.0000 | 13080.00 | 0.00 | 13080.00 | 8 | 8 | 79 | 4029 | 0.0196078431372549 | 0.323035898558023 | 0.323035898558023 | false | false | false | true | ||||||||||||||||
| 40cc4b12-f13c-4413-b5e8-14daabaa22a0 | 2026-09-25 10:09 | 2026-09-25 10:09 | 2026-09-25 10:09 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 15.6000 | 15.5000 | 16.2000 | 511.0000 | 106085.00 | 101405.00 | 4680.00 | 68 | 5 | 87 | 3993 | 0.0217881292261458 | 0.318412644832987 | 0.318412644832987 | false | false | false | true | ||||||||||||||||
| 5fab93da-4d25-4b57-a133-24f65906dd56 | 2026-09-22 10:34 | 2026-09-22 10:34 | 2026-09-22 10:34 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 18.9000 | 18.6500 | 19.1500 | 497.6100 | 15120.00 | 13230.00 | 0.00 | 8 | 8 | 22 | 3845 | 0.00572171651495449 | 0.316641555947668 | 0.316641555947668 | false | false | false | true | ||||||||||||||||
| 593d2632-4dd3-44dd-a6a5-b4bfa2bb667d | 2026-09-17 10:38 | 2026-09-17 10:38 | 2026-09-17 10:38 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 19.6500 | 19.6000 | 19.7000 | 498.2300 | 106090.00 | 0.00 | 106090.00 | 54 | 12 | 124 | 3850 | 0.0322077922077922 | 0.322228414322452 | 0.321787167345744 | false | false | false | true | ||||||||||||||||
| 600dd5b3-0062-4f50-a04c-66299c66f87f | 2026-09-15 11:10 | 2026-09-15 11:10 | 2026-09-15 11:10 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 19.0000 | 18.6500 | 19.0000 | 501.5500 | 100700.00 | 100700.00 | 0.00 | 53 | 6 | 549 | 3816 | 0.143867924528302 | 0.321893237192933 | 0.321893237192933 | false | false | false | true | ||||||||||||||||
| 21d96af5-f981-401f-b149-6c1e05d6333e | 2026-09-15 11:07 | 2026-09-15 11:07 | 2026-09-15 11:07 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 19.1500 | 19.0500 | 19.1500 | 501.0000 | 103410.00 | 103410.00 | 0.00 | 54 | 8 | 441 | 3816 | 0.115566037735849 | 0.322048638247184 | 0.322048638247184 | false | false | false | true | ||||||||||||||||
| 9755bc78-d635-4170-b1b7-6c7761b19927 | 2026-08-28 10:40 | 2026-08-28 10:40 | 2026-08-28 10:40 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 18.7500 | 18.7500 | 18.9500 | 510.9300 | 268125.00 | 0.00 | 268125.00 | 143 | 5 | 247 | 2710 | 0.0911439114391144 | 0.32465507298339 | 0.32465507298339 | false | false | false | true | ||||||||||||||||
| 87bba1e7-9bf7-41c0-a481-ca1bd657d7d6 | 2026-08-27 10:38 | 2026-08-27 10:37 | 2026-08-27 10:37 | MSFT | MSFT270319P00450000 | put | 450.0000 | 2027-03-19 | 20.7800 | 20.5250 | 21.2000 | 503.9600 | 135090.00 | 16600.00 | 118490.00 | 65 | 14 | 68 | 2642 | 0.0257380772142316 | 0.327502519174906 | 0.326247050194526 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3781236274927.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3781236274927.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3781236274927.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3781236274927.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3781236274927.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3781236274927.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3781236274927.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3781236274927.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3781236274927.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3781236274927.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:41:20.736872Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3781236274927.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:41:20.736872Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:09:41.700516Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:35:47.926453Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3696065268145.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:48:09.438351Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:09:54.469160Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:54:23.998586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:49:52.356548Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |