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_alerts566,287 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 |
|---|
| 496dfc85-f32f-4882-95ce-f301395aefe6 | 2026-09-18 09:53 | 2026-09-18 09:53 | 2026-09-18 09:53 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 0.4600 | 0.4100 | 0.4600 | 144.5500 | 23000.00 | 23000.00 | 0.00 | 500 | 5 | 667 | 1377 | 0.484386347131445 | 0.965181774052673 | 0.965181774052673 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 56117000314.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| f4f35abb-36d0-405c-acb1-4a84170f83ba | 2026-09-18 12:33 | 2026-09-18 12:33 | 2026-09-18 12:33 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 0.7500 | 0.7000 | 0.7600 | 150.9500 | 16575.00 | 16500.00 | 75.00 | 221 | 21 | 2537 | 1377 | 1.84241103848947 | 0.903591723812874 | 0.90235306402316 | false | false | false | |||||||||||||||||
| 53bfab83-dd16-4391-8f61-d41e812726da | 2026-09-21 10:03 | 2026-09-21 10:03 | 2026-09-21 10:03 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.5300 | 2.5300 | 2.5900 | 166.7800 | 37950.00 | 0.00 | 37950.00 | 150 | 12 | 4737 | 2727 | 1.73707370737074 | 1.00841156142896 | 1.00841156142896 | true | false | false | |||||||||||||||||
| 6dbce42f-7c2a-4357-b122-e8c72cd511f8 | 2026-09-21 10:10 | 2026-09-21 10:09 | 2026-09-21 10:09 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.1900 | 2.1600 | 2.2300 | 165.7200 | 15327.00 | 654.00 | 14673.00 | 70 | 5 | 5384 | 2727 | 1.97433076640997 | 0.992896109089634 | 0.992896109089634 | false | false | false | |||||||||||||||||
| 49c320e8-709d-4e6d-9f1c-8a819a6f3f74 | 2026-09-21 10:22 | 2026-09-21 10:22 | 2026-09-21 10:22 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.0700 | 2.0700 | 2.1400 | 165.5900 | 10350.00 | 0.00 | 10350.00 | 50 | 11 | 5907 | 2727 | 2.16611661166117 | 0.97555189262965 | 0.97555189262965 | false | false | false | |||||||||||||||||
| bea76114-f013-408f-be9e-25a3931a8a55 | 2026-09-21 14:19 | 2026-09-21 14:19 | 2026-09-21 14:19 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.1700 | 2.1300 | 2.1800 | 166.4000 | 67487.00 | 67487.00 | 0.00 | 311 | 7 | 11720 | 2727 | 4.2977631096443 | 0.959399662691117 | 0.959399662691117 | false | false | false | |||||||||||||||||
| 2f8b4fd2-5555-4ffc-b125-8b899956f844 | 2026-09-21 14:22 | 2026-09-21 14:21 | 2026-09-21 14:21 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.2000 | 2.1600 | 2.2000 | 166.4000 | 22000.00 | 22000.00 | 0.00 | 100 | 19 | 11826 | 2727 | 4.33663366336634 | 0.965015240891179 | 0.965015240891179 | false | false | false | |||||||||||||||||
| 3d35360f-10ae-4442-9a37-6f9fd91561a0 | 2026-09-21 15:35 | 2026-09-21 15:35 | 2026-09-21 15:35 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.8500 | 2.8000 | 2.8500 | 168.6200 | 128250.00 | 5700.00 | 0.00 | 450 | 6 | 13332 | 2727 | 4.88888888888889 | 0.978903036230906 | 0.978903036230906 | true | false | false | |||||||||||||||||
| 13f06485-3c77-4b05-95b0-944109042324 | 2026-09-22 09:33 | 2026-09-22 09:32 | 2026-09-22 09:32 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.2500 | 2.2500 | 2.4000 | 168.9879 | 22500.00 | 0.00 | 22500.00 | 100 | 8 | 520 | 5162 | 0.100736148779543 | 0.99285613203557 | 0.99285613203557 | false | false | false | |||||||||||||||||
| d02566ff-ed8a-40a7-bb43-dd5247d7ddc3 | 2026-09-22 09:36 | 2026-09-22 09:36 | 2026-09-22 09:36 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.2100 | 2.2100 | 2.3000 | 168.9700 | 29614.00 | 0.00 | 29614.00 | 134 | 19 | 812 | 5162 | 0.157303370786517 | 0.985669350908613 | 0.985669350908613 | true | false | false | |||||||||||||||||
| cec82a8e-872b-48ff-bdca-09a6a8504ae5 | 2026-09-22 09:45 | 2026-09-22 09:45 | 2026-09-22 09:45 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.0300 | 2.0200 | 2.1000 | 168.0000 | 69223.00 | 0.00 | 69223.00 | 341 | 14 | 1615 | 5162 | 0.312863231305695 | 0.968536547487486 | 0.968536547487486 | true | false | false | |||||||||||||||||
| 1260a86c-129a-4b2c-a5d2-580250b8caa5 | 2026-09-22 10:01 | 2026-09-22 10:01 | 2026-09-22 10:01 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.2300 | 2.2300 | 2.2800 | 169.6700 | 30997.00 | 0.00 | 30997.00 | 139 | 6 | 5200 | 5162 | 1.00736148779543 | 0.953253181579591 | 0.953253181579591 | false | false | false | |||||||||||||||||
| 30e4714b-e3a9-4b37-92a8-02b03ff825d8 | 2026-09-22 10:04 | 2026-09-22 10:04 | 2026-09-22 10:04 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.0400 | 1.9700 | 2.0400 | 168.9350 | 40800.00 | 40800.00 | 0.00 | 200 | 14 | 5663 | 5162 | 1.09705540488183 | 0.952568486345094 | 0.952568486345094 | false | false | false | |||||||||||||||||
| b090c47a-58d9-4190-9b10-bd803acedaed | 2026-09-22 10:10 | 2026-09-22 10:10 | 2026-09-22 10:10 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.2900 | 2.2800 | 2.3500 | 169.5990 | 45753.00 | 0.00 | 45753.00 | 200 | 9 | 6595 | 5162 | 1.27760557923286 | 0.966938945828457 | 0.968927905861378 | false | false | false | |||||||||||||||||
| 6666c4ae-7bc1-42e1-9e6b-8c2f6091c9b6 | 2026-09-22 10:14 | 2026-09-22 10:14 | 2026-09-22 10:14 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.6900 | 2.6000 | 2.6900 | 170.6500 | 13449.00 | 13181.00 | 0.00 | 50 | 8 | 9180 | 5162 | 1.77838047268501 | 0.989668557117038 | 0.987787268230943 | false | false | false | |||||||||||||||||
| e89a74bf-ddbf-4f40-9fef-719d9aec026d | 2026-09-22 10:49 | 2026-09-22 10:49 | 2026-09-22 10:49 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 1.8900 | 1.8200 | 1.8900 | 168.5500 | 37798.00 | 37611.00 | 187.00 | 200 | 7 | 10785 | 5162 | 2.08930647036033 | 0.940469165648438 | 0.936198393916229 | false | false | false | |||||||||||||||||
| 572611c5-fa31-473c-9737-dc655bfd932c | 2026-09-22 12:12 | 2026-09-22 12:12 | 2026-09-22 12:12 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 1.8300 | 1.7700 | 1.8300 | 168.6300 | 36600.00 | 36600.00 | 0.00 | 200 | 5 | 12816 | 5162 | 2.48275862068966 | 0.923647356537251 | 0.923647356537251 | false | false | false | |||||||||||||||||
| 311a54c6-5530-4f11-9420-6141b4426e41 | 2026-09-22 13:58 | 2026-09-22 13:58 | 2026-09-22 13:58 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 2.0500 | 1.9800 | 2.0500 | 169.8100 | 10235.00 | 10235.00 | 0.00 | 50 | 6 | 14554 | 5162 | 2.81944982564897 | 0.909792603507722 | 0.909792603507722 | false | false | false | |||||||||||||||||
| 62b078b1-4d33-4e34-95bd-bdabda5732ef | 2026-09-22 15:33 | 2026-09-22 15:33 | 2026-09-22 15:33 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 1.6800 | 1.6800 | 1.7000 | 168.3279 | 16632.00 | 0.00 | 16632.00 | 99 | 18 | 15452 | 5162 | 2.99341340565672 | 0.905845846438847 | 0.905845846438847 | false | false | false | |||||||||||||||||
| 428bd6c1-abb2-489d-b2a3-7766c21682bf | 2026-09-23 13:13 | 2026-09-23 13:13 | 2026-09-23 13:13 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 0.4700 | 0.4700 | 0.5000 | 162.0000 | 13301.00 | 0.00 | 13207.00 | 283 | 43 | 3901 | 11819 | 0.330061764954734 | 0.974288397238622 | 0.974288397238622 | true | false | false | |||||||||||||||||
| cd44ba8f-6c89-47d3-9a96-b72dafaa4224 | 2026-09-24 10:30 | 2026-09-24 10:30 | 2026-09-24 10:30 | MSTR | MSTR260925C00180000 | call | 180.0000 | 2026-09-25 | 0.3300 | 0.3300 | 0.3400 | 164.2950 | 13200.00 | 0.00 | 13200.00 | 400 | 6 | 7933 | 11685 | 0.678904578519469 | 1.17737783867868 | 1.18137546950079 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56117000314.00 |
| 2026-10-29 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:04:59.983035Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:10:29.738922Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:22:41.713421Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:20:26.028708Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:23:56.707397Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:36:57.124687Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:33:30.058722Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:37:27.552956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:46:43.807773Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:04:08.107942Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:11:50.316445Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:15:02.242582Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:51:29.790694Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:20:35.100506Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:17:19.986908Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:31:48.426973Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |