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_alerts326,449 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 | 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 |
|---|
| ebe2749a-9135-42ea-b6e3-9de85dc31957 | 2026-09-10 11:15 | 2026-09-10 11:15 | 2026-09-10 11:15 | XP | XP270115C00030000 | call | 30.0000 | 2027-01-15 | 0.3000 | 0.2000 | 0.3500 | 20.0250 | 25500.00 | 24000.00 | 1500.00 | 850 | 21 | 2000 | 9094 | 0.219925225423356 | 0.496299529926479 | 0.496299529926479 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 8139142289.00 | 2026-11-16 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T15:21:12.723015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b21b62e0-02d4-4663-af4a-88b6fb2c9354 | 2026-09-11 10:24 | 2026-09-11 10:24 | 2026-09-11 10:24 | XP | XP261120C00025000 | call | 25.0000 | 2026-11-20 | 0.5700 | 0.5000 | 0.5500 | 19.9350 | 71010.00 | 71010.00 | 0.00 | 1235 | 2 | 1600 | 529 | 3.02457466918715 | 0.558696771564003 | 0.577782318813593 | false | true | false | true | false | |||||||||||||||
| 83d14c08-aa3b-4190-96bf-8abf92590b6c | 2026-09-11 13:07 | 2026-09-11 13:07 | 2026-09-11 13:07 | XP | XP261120P00020000 | put | 20.0000 | 2026-11-20 | 1.8000 | 1.8000 | 1.9500 | 19.8750 | 11700.00 | 0.00 | 11700.00 | 65 | 5 | 71 | 2561 | 0.027723545490043 | 0.523897009197754 | 0.523897009197754 | false | false | false | true | false | |||||||||||||||
| 6c1b2820-0ab0-42a9-903a-5d9092ca64ca | 2026-09-15 15:10 | 2026-09-15 15:10 | 2026-09-15 15:10 | XP | XP261016C00020000 | call | 20.0000 | 2026-10-16 | 0.9500 | 0.9500 | 1.0000 | 19.4800 | 36195.00 | 0.00 | 36195.00 | 381 | 21 | 547 | 839 | 0.65196662693683 | 0.508564653244912 | 0.507528926213654 | false | false | false | true | false | |||||||||||||||
| 76c1105c-0a4f-4c73-8b05-e70a19800c99 | 2026-09-15 15:51 | 2026-09-15 15:50 | 2026-09-15 15:50 | XP | XP261120C00022000 | call | 22.0000 | 2026-11-20 | 1.0600 | 0.9000 | 1.3000 | 19.0000 | 122215.00 | 0.00 | 96915.00 | 1153 | 2 | 1175 | 1672 | 0.702751196172249 | 0.573465544706863 | 0.573465544706863 | false | true | false | true | false | |||||||||||||||
| 51580240-d543-4bd4-bf14-1d621a20fc35 | 2026-09-16 10:00 | 2026-09-16 10:00 | 2026-09-16 10:00 | XP | XP280121P00013000 | put | 13.0000 | 2028-01-21 | 1.1500 | 0.7000 | 1.6500 | 19.3700 | 10580.00 | 4715.00 | 5865.00 | 92 | 10 | 92 | 707 | 0.13012729844413 | 0.51883783470223 | 0.51883783470223 | false | false | false | true | false | |||||||||||||||
| db4ba669-86a0-40f3-805d-79a1c277016b | 2026-09-16 10:38 | 2026-09-16 10:38 | 2026-09-16 10:38 | XP | XP261120C00020000 | call | 20.0000 | 2026-11-20 | 1.7000 | 1.6000 | 1.7500 | 19.4500 | 81090.00 | 81090.00 | 0.00 | 477 | 13 | 500 | 6382 | 0.0783453462864306 | 0.574259439535098 | 0.574259439535098 | false | false | false | true | false | |||||||||||||||
| 008be3f2-4b9d-49b7-ac88-c95c71ddb535 | 2026-09-16 13:18 | 2026-09-16 13:18 | 2026-09-16 13:18 | XP | XP261120C00026000 | call | 26.0000 | 2026-11-20 | 0.4000 | 0.3500 | 0.4000 | 19.6050 | 10760.00 | 10760.00 | 0.00 | 269 | 34 | 487 | 318 | 1.5314465408805 | 0.600182716113096 | 0.600182716113096 | false | false | false | true | false | |||||||||||||||
| 02aa7a84-4d56-4eed-a891-ab2da35332b5 | 2026-09-16 13:30 | 2026-09-16 13:30 | 2026-09-16 13:30 | XP | XP261120C00022000 | call | 22.0000 | 2026-11-20 | 1.1400 | 1.0500 | 1.1500 | 19.6500 | 11335.00 | 11335.00 | 0.00 | 99 | 7 | 2348 | 2585 | 0.908317214700193 | 0.592658666662502 | 0.589497786538988 | false | false | false | true | false | |||||||||||||||
| 89f87ea6-2898-46c5-85ff-5809e260c16c | 2026-09-16 13:57 | 2026-09-16 13:56 | 2026-09-16 13:56 | XP | XP261030C00021500 | call | 21.5000 | 2026-10-30 | 0.9000 | 0.8500 | 1.0500 | 19.0000 | 13770.00 | 4590.00 | 9180.00 | 153 | 5 | 153 | 0 | 0 | 0.573186686316402 | 0.573186686316402 | false | false | false | true | false | |||||||||||||||
| a087c242-ee28-4329-b8f4-a36bfdf0f4dd | 2026-09-17 09:54 | 2026-09-17 09:54 | 2026-09-17 09:54 | XP | XP261120C00022000 | call | 22.0000 | 2026-11-20 | 1.2000 | 1.0500 | 1.2000 | 19.7100 | 76510.00 | 67990.00 | 0.00 | 638 | 20 | 638 | 4850 | 0.131546391752577 | 0.607118516101126 | 0.602727885489835 | false | false | false | true | false | |||||||||||||||
| 9bcd0445-f177-4a10-9085-cbf667d21ac9 | 2026-09-17 12:33 | 2026-09-17 12:33 | 2026-09-17 12:33 | XP | XP270115P00021000 | put | 21.0000 | 2027-01-15 | 2.8000 | 2.6000 | 2.8000 | 20.3000 | 80080.00 | 80080.00 | 0.00 | 286 | 13 | 286 | 200 | 1.43 | 0.554586059894891 | 0.554586059894891 | false | false | false | true | false | |||||||||||||||
| f0846403-d3c3-4782-bd8b-eea9ca3d0bad | 2026-09-17 13:19 | 2026-09-17 13:19 | 2026-09-17 13:19 | XP | XP270115P00016000 | put | 16.0000 | 2027-01-15 | 0.8000 | 0.6500 | 0.8000 | 20.2150 | 27200.00 | 27200.00 | 0.00 | 340 | 30 | 344 | 700 | 0.491428571428571 | 0.5866952668599 | 0.5866952668599 | false | false | false | true | false | |||||||||||||||
| 80e5d5cb-40b0-480b-92de-5b2ea85b2b5f | 2026-09-17 14:15 | 2026-09-17 14:15 | 2026-09-17 14:15 | XP | XP261120C00025000 | call | 25.0000 | 2026-11-20 | 0.6600 | 0.6500 | 0.7000 | 20.2750 | 1320000.00 | 0.00 | 1320000.00 | 20000 | 4 | 71181 | 122118 | 0.582887043679065 | 0.596826720801548 | 0.596826720801548 | false | true | true | false | false | |||||||||||||||
| 25c21215-5866-42dc-9a15-6ed9314e1c72 | 2026-09-18 10:46 | 2026-09-18 10:46 | 2026-09-18 10:46 | XP | XP261009C00019500 | call | 19.5000 | 2026-10-09 | 1.2500 | 1.2000 | 1.3000 | 19.8500 | 47250.00 | 1875.00 | 45375.00 | 378 | 14 | 378 | 57 | 6.63157894736842 | 0.553908459651822 | 0.553908459651822 | false | false | false | true | false | |||||||||||||||
| 80b765aa-ab8c-45ff-9388-19fb88bf413f | 2026-09-18 11:32 | 2026-09-18 11:32 | 2026-09-18 11:32 | XP | XP270115C00027000 | call | 27.0000 | 2027-01-15 | 0.6000 | 0.4500 | 0.6500 | 20.0550 | 126720.00 | 126720.00 | 0.00 | 2112 | 1 | 2112 | 24017 | 0.0879377107881917 | 0.514504395120131 | 0.514504395120131 | false | true | false | true | false | |||||||||||||||
| 86afad23-a775-4e19-88cf-69c628769cd3 | 2026-09-18 13:06 | 2026-09-18 13:06 | 2026-09-18 13:06 | XP | XP261002C00020500 | call | 20.5000 | 2026-10-02 | 0.5500 | 0.5000 | 0.6000 | 20.2250 | 13200.00 | 11935.00 | 0.00 | 240 | 30 | 347 | 305 | 1.13770491803279 | 0.418304389314323 | 0.418304389314323 | false | false | false | true | false | |||||||||||||||
| ba05f7b5-bcc8-48c1-a130-4d41c1ceed70 | 2026-09-21 14:00 | 2026-09-21 14:00 | 2026-09-21 14:00 | XP | XP261120C00022000 | call | 22.0000 | 2026-11-20 | 1.4500 | 1.4500 | 1.5000 | 20.5950 | 24215.00 | 0.00 | 24215.00 | 167 | 5 | 644 | 5588 | 0.115246957766643 | 0.588992875321953 | 0.588992875321953 | false | false | false | true | false | |||||||||||||||
| 385d169f-374c-45dc-9336-efda42db4427 | 2026-09-22 10:55 | 2026-09-22 10:55 | 2026-09-22 10:55 | XP | XP261120P00018000 | put | 18.0000 | 2026-11-20 | 0.8500 | 0.8500 | 0.9000 | 20.5350 | 31110.00 | 0.00 | 31110.00 | 366 | 20 | 423 | 1597 | 0.264871634314339 | 0.615214965235506 | 0.615214965235506 | false | false | false | true | false |
| d9769fb4-003b-49e4-9181-c78c9cc101f5 |
| 1 |
| Common Stock |
| Financial Services |
| 8139142289.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:26:53.669819Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8139142289.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T17:27:08.545704Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8139142289.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8139142289.00 |
| 2026-11-16 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8207678062.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8207678062.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8207678062.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8207678062.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8207678062.00 |
| 2026-11-16 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 8386286441.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:57:31.198579Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8386286441.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8386286441.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| d9769fb4-003b-49e4-9181-c78c9cc101f5 |
| 1 |
| Common Stock |
| Financial Services |
| 8386286441.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8311520143.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| d9769fb4-003b-49e4-9181-c78c9cc101f5 |
| 1 |
| Common Stock |
| Financial Services |
| 8311520143.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8311520143.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8631353752.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:00:14.697100Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8809962131.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |