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 | strike |
|---|
| expirydate |
|---|
| 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 |
|---|
| d3b00bd1-dc66-4164-8294-6f12b69d8ff4 | 2026-09-29 15:58 | 2026-09-29 15:58 | 2026-09-29 15:58 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 59.7000 | 59.2000 | 59.7000 | 154.0000 | 298475.00 | 292525.00 | 5950.00 | 50 | 5 | 448 | 6054 | 0.074000660720185 | 0.761397009466985 | 0.759000870211429 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 56390439440.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| cd5595bd-b4f1-45af-95ef-1198b3ca1955 | 2026-09-22 10:03 | 2026-09-22 10:03 | 2026-09-22 10:03 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 72.1100 | 72.0000 | 72.8000 | 169.2399 | 245185.00 | 79530.00 | 165655.00 | 34 | 11 | 37 | 5657 | 0.00654056920629309 | 0.784754882156353 | 0.788187678390194 | false | false | ||||||||||||||||||
| 51ae0377-858b-4736-b0ed-112ca764581b | 2026-09-21 10:10 | 2026-09-21 10:10 | 2026-09-21 10:10 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 70.9000 | 69.9000 | 72.0000 | 166.0000 | 70900.00 | 35450.00 | 35450.00 | 10 | 5 | 23 | 5707 | 0.00403013842649378 | 0.797269647942611 | 0.797269647942611 | false | false | ||||||||||||||||||
| 5d5e5a34-c8a1-453d-9405-fa5e8b6c09ed | 2026-09-04 10:59 | 2026-09-04 10:59 | 2026-09-04 10:59 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 55.0000 | 54.1000 | 56.3000 | 138.9800 | 357500.00 | 0.00 | 357500.00 | 65 | 5 | 313 | 5373 | 0.0582542341336311 | 0.823650281528628 | 0.823650281528628 | false | false | ||||||||||||||||||
| 4c40e9e5-bc3f-4463-af57-65815ee3b72c | 2026-08-31 12:06 | 2026-08-31 12:05 | 2026-08-31 12:05 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 49.6800 | 49.2000 | 50.3000 | 129.8695 | 84454.00 | 79479.00 | 0.00 | 17 | 7 | 128 | 5086 | 0.0251671254423909 | 0.830454765874834 | 0.829092968307338 | false | false | ||||||||||||||||||
| db6339d7-3caa-49b8-ab2c-599ca5947e51 | 2026-08-28 13:02 | 2026-08-28 13:02 | 2026-08-28 13:02 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 48.4900 | 48.0000 | 49.3000 | 126.6796 | 436380.00 | 4805.00 | 431575.00 | 90 | 7 | 249 | 5091 | 0.0489098408956983 | 0.841181329519799 | 0.834935535336412 | false | false | ||||||||||||||||||
| 641f7736-c646-49ed-9302-3f7d454982d1 | 2026-08-27 14:11 | 2026-08-27 14:11 | 2026-08-27 14:11 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 55.0100 | 54.7000 | 56.6500 | 137.1000 | 583150.00 | 99120.00 | 484030.00 | 106 | 10 | 729 | 5054 | 0.144242184408389 | 0.83704793592746 | 0.83967400086977 | false | false | ||||||||||||||||||
| 3d19d6e5-4fb5-4e21-b11a-48e32186a62e | 2026-08-25 12:05 | 2026-08-25 12:05 | 2026-08-25 12:05 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 49.9800 | 48.9500 | 50.7000 | 128.2200 | 534802.00 | 314852.00 | 214960.00 | 107 | 13 | 577 | 4463 | 0.129285234147434 | 0.846662361553636 | 0.846172478046103 | true | false | ||||||||||||||||||
| 7d93b06a-c988-48bd-a6c6-e19e59db0988 | 2026-08-25 11:38 | 2026-08-25 11:37 | 2026-08-25 11:37 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 48.6500 | 48.1000 | 48.6500 | 126.3000 | 24325.00 | 14595.00 | 0.00 | 5 | 5 | 459 | 4463 | 0.102845619538427 | 0.844574244563005 | 0.844574244563005 | false | false | ||||||||||||||||||
| d11d6b19-1fe2-4afc-913a-282df3d67e50 | 2026-08-24 10:49 | 2026-08-24 10:49 | 2026-08-24 10:49 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 48.7500 | 47.6000 | 50.3000 | 124.7850 | 48750.00 | 14625.00 | 14625.00 | 10 | 10 | 73 | 4540 | 0.016079295154185 | 0.859065424125428 | 0.859065424125428 | false | false | ||||||||||||||||||
| 1d842548-1879-4eb6-9598-db9b6b96f44f | 2026-08-21 13:44 | 2026-08-21 13:44 | 2026-08-21 13:44 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 45.2500 | 44.7500 | 46.2000 | 119.8500 | 22625.00 | 0.00 | 22625.00 | 5 | 5 | 235 | 4668 | 0.0503427592116538 | 0.852760117080524 | 0.852760117080524 | false | false | ||||||||||||||||||
| 1cf8285b-5376-4d1d-a6f6-ede56ef7d277 | 2026-08-20 09:57 | 2026-08-20 09:56 | 2026-08-20 09:56 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 39.9600 | 38.5000 | 40.0000 | 111.8000 | 851210.00 | 799925.00 | 51285.00 | 213 | 19 | 225 | 4555 | 0.0493962678375412 | 0.847520998188837 | 0.848168438392324 | true | false | ||||||||||||||||||
| bc9caf85-d755-4100-9bb8-bf5aee498769 | 2026-08-19 13:02 | 2026-08-19 13:02 | 2026-08-19 13:02 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 36.0100 | 35.1500 | 37.0000 | 105.9800 | 540138.00 | 0.00 | 540138.00 | 150 | 5 | 477 | 4368 | 0.109203296703297 | 0.839626318659725 | 0.839626318659725 | false | false | ||||||||||||||||||
| 2bb81709-b94a-4183-b71f-8ea4820b1f63 | 2026-08-19 10:16 | 2026-08-19 10:16 | 2026-08-19 10:16 | MSTR | MSTR281215C00200000 | call | 200.0000 | 2028-12-15 | 31.1500 | 30.2500 | 31.6000 | 99.0800 | 124605.00 | 93450.00 | 31155.00 | 40 | 7 | 74 | 4368 | 0.0169413919413919 | 0.824969933445996 | 0.825714823301218 | false | false |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:12:42.136586Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T17:15:24.821907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:29:52.792110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:16:43.855599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |