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_alerts658,639 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 |
|---|
| d0b6f62b-3dc1-4647-a77a-ce54779c3587 | 2026-09-22 09:55 | 2026-09-22 09:55 | 2026-09-22 09:55 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 4.3500 | 4.2000 | 4.9000 | 496.3975 | 36540.00 | 5655.00 | 30885.00 | 84 | 16 | 150 | 163 | 0.920245398773006 | 0.262075431023936 | 0.262489241066525 | true | false | false | true | false | 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-22T13:56:25.927111Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 660b2204-e28b-4ff9-9128-b0cf03774f77 | 2026-09-25 09:54 | 2026-09-25 09:54 | 2026-09-25 09:54 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 13.7000 | 13.3000 | 13.7000 | 516.2300 | 41100.00 | 41100.00 | 0.00 | 30 | 7 | 731 | 933 | 0.783494105037513 | 0.266733835932043 | 0.266733835932043 | false | false | false | |||||||||||||||||
| 89a89fad-5c8e-4441-b6cc-06206ad14b62 | 2026-09-25 13:02 | 2026-09-25 13:02 | 2026-09-25 13:02 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 14.1500 | 13.6500 | 14.1500 | 517.0000 | 186780.00 | 186780.00 | 0.00 | 132 | 12 | 984 | 933 | 1.05466237942122 | 0.258302244638735 | 0.258297695033507 | true | false | false | |||||||||||||||||
| 94bce706-cba7-4b98-966e-05e21e57af96 | 2026-09-25 13:02 | 2026-09-25 13:02 | 2026-09-25 13:02 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 14.1500 | 13.7000 | 14.1500 | 517.1000 | 93390.00 | 93390.00 | 0.00 | 66 | 7 | 1127 | 933 | 1.20793140407288 | 0.253693160660828 | 0.253693160660828 | true | false | false | |||||||||||||||||
| 99549f4a-e0b4-43e1-9eca-bbcc8e7bdf4f | 2026-09-25 13:02 | 2026-09-25 13:02 | 2026-09-25 13:02 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 14.2000 | 13.7000 | 14.2000 | 517.1900 | 44020.00 | 44020.00 | 0.00 | 31 | 6 | 1202 | 933 | 1.28831725616292 | 0.254752917043808 | 0.252409945690653 | true | false | false | |||||||||||||||||
| 0ebaf876-8615-4946-a39a-d529ddc8ce19 | 2026-09-25 15:59 | 2026-09-25 15:59 | 2026-09-25 15:59 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 13.2000 | 13.0500 | 13.3000 | 516.0000 | 165000.00 | 125400.00 | 39600.00 | 125 | 5 | 1620 | 933 | 1.73633440514469 | 0.248103554346759 | 0.248103554346759 | false | false | false | |||||||||||||||||
| 7017037a-b0a6-4ce9-a92f-d50c59a923b2 | 2026-09-28 09:43 | 2026-09-28 09:43 | 2026-09-28 09:43 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 4.7000 | 4.5500 | 4.7000 | 504.1400 | 102460.00 | 102460.00 | 0.00 | 218 | 20 | 576 | 805 | 0.715527950310559 | 0.339990108642192 | 0.339990108642192 | true | false | false | |||||||||||||||||
| 541e9124-852e-412c-a4a8-93433fd960f2 | 2026-09-28 10:02 | 2026-09-28 10:02 | 2026-09-28 10:02 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 7.2500 | 7.2500 | 7.6500 | 509.3000 | 253770.00 | 0.00 | 253770.00 | 350 | 7 | 1942 | 805 | 2.41242236024845 | 0.31517995189922 | 0.31517995189922 | false | false | false | |||||||||||||||||
| 37b80532-27d4-4c39-a3bb-9cade3624d5a | 2026-09-28 13:11 | 2026-09-28 13:11 | 2026-09-28 13:11 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 9.0000 | 8.7000 | 9.0000 | 511.7600 | 171000.00 | 171000.00 | 0.00 | 190 | 5 | 2687 | 805 | 3.33788819875776 | 0.325509259022312 | 0.319915805690445 | false | false | false | |||||||||||||||||
| 4f852e15-3305-4c63-a2ce-71029856e41f | 2026-09-29 10:03 | 2026-09-29 10:03 | 2026-09-29 10:03 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 3.6000 | 3.6000 | 3.6500 | 504.7000 | 31680.00 | 0.00 | 27720.00 | 88 | 8 | 5465 | 1046 | 5.22466539196941 | 0.35297027696218 | 0.35297027696218 | true | false | false | true | ||||||||||||||||
| f89991e3-3684-4268-86ec-5a5c3b32f474 | 2026-09-29 10:03 | 2026-09-29 10:03 | 2026-09-29 10:03 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 3.7000 | 3.6000 | 3.7500 | 504.8850 | 11470.00 | 11100.00 | 0.00 | 31 | 7 | 5545 | 1046 | 5.30114722753346 | 0.353730781730653 | 0.353730781730653 | false | false | false | |||||||||||||||||
| b9b84975-199a-42f1-876e-7cac0b7405b9 | 2026-09-29 10:22 | 2026-09-29 10:22 | 2026-09-29 10:22 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 5.0000 | 4.7000 | 5.0500 | 506.9199 | 23485.00 | 22000.00 | 1485.00 | 47 | 10 | 9127 | 1046 | 8.72562141491396 | 0.372321848099806 | 0.367491595204265 | false | false | false | |||||||||||||||||
| 123d54e7-2af2-4a30-a738-99a223d54f0f | 2026-09-29 10:24 | 2026-09-29 10:24 | 2026-09-29 10:24 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 6.0500 | 5.9000 | 6.0500 | 508.4800 | 13915.00 | 13915.00 | 0.00 | 23 | 12 | 9553 | 1046 | 9.13288718929254 | 0.381650990095184 | 0.381650990095184 | true | false | false | |||||||||||||||||
| 72844074-30eb-4ba8-a791-b595a28f64a1 | 2026-09-29 14:36 | 2026-09-29 14:36 | 2026-09-29 14:36 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 5.0000 | 4.8500 | 5.1000 | 507.0000 | 10000.00 | 5500.00 | 2500.00 | 20 | 6 | 12457 | 1046 | 11.9091778202677 | 0.330129450518625 | 0.326772705602164 | false | false | false | |||||||||||||||||
| 5eee058d-79e7-4ae4-b1c6-c67893944a5f | 2026-09-29 15:57 | 2026-09-29 15:57 | 2026-09-29 15:57 | MSFT | MSFT260930C00505000 | call | 505.0000 | 2026-09-30 | 5.3500 | 5.2000 | 5.3500 | 508.0000 | 42800.00 | 42800.00 | 0.00 | 80 | 5 | 12950 | 1046 | 12.3804971319312 | 0.325932568070564 | 0.325932568070564 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:54:35.682199Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:04:49.737352Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:04:49.737352Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:04:49.737352Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-28T13:43:35.547112Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T14:03:25.739526Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T17:11:57.740479Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3779305633099.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:06:19.717900Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3779305633099.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:06:19.717900Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3779305633099.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:23:29.656550Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3779305633099.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:27:05.819137Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3779305633099.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:39:05.555740Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3779305633099.00 |
| 2026-11-04 |
| 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 |