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.
Simplify Analyticsuw_flow_alerts474,253 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 |
|---|
| 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 |
|---|
| cf81a2fb-8bdd-4b4b-a77b-c1aae510f543 | 2026-09-09 15:04 | 2026-09-09 15:04 | 2026-09-09 15:04 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.5600 | 2.4100 | 2.6300 | 194.8750 | 71680.00 | 768.00 | 42240.00 | 280 | 8 | 281 | 22 | 12.7727272727273 | 0.344154408507716 | 0.344154408507716 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 4238179533.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 43ddd808-f5ae-4aa0-8520-962f135af072 | 2026-09-09 15:04 | 2026-09-09 15:04 | 2026-09-09 15:04 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.5500 | 2.5500 | 2.5600 | 194.8600 | 85425.00 | 0.00 | 85425.00 | 335 | 6 | 616 | 22 | 28 | 0.343554183460323 | 0.343554183460323 | false | false | false | true | false | |||||||||||||||
| b4d87d6d-75bd-4d4e-8a0f-9da563f35137 | 2026-09-09 15:04 | 2026-09-09 15:04 | 2026-09-09 15:04 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.5600 | 2.4400 | 2.5600 | 194.8600 | 50176.00 | 12544.00 | 0.00 | 196 | 5 | 812 | 22 | 36.9090909090909 | 0.344041986762784 | 0.344041986762784 | false | false | false | true | ||||||||||||||||
| 8a47440f-b15e-4431-86bf-f41069111cac | 2026-09-09 15:04 | 2026-09-09 15:04 | 2026-09-09 15:04 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.5800 | 2.4000 | 2.6000 | 194.8600 | 78432.00 | 36378.00 | 21930.00 | 304 | 6 | 1177 | 22 | 53.5 | 0.345015762650641 | 0.345015762650641 | true | false | false | true | ||||||||||||||||
| 38329b89-8b56-4224-a038-420274a7117f | 2026-09-09 15:04 | 2026-09-09 15:04 | 2026-09-09 15:04 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.5800 | 2.4700 | 2.5800 | 194.8300 | 101652.00 | 101652.00 | 0.00 | 394 | 14 | 1571 | 22 | 71.4090909090909 | 0.344790567212284 | 0.344790567212284 | false | false | false | true | ||||||||||||||||
| bcc8bc8f-4a8e-4293-85a2-7fc562fc94e0 | 2026-09-09 15:11 | 2026-09-09 15:11 | 2026-09-09 15:11 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.5500 | 2.3500 | 2.5800 | 195.0900 | 25500.00 | 4335.00 | 21165.00 | 100 | 14 | 1982 | 22 | 90.0909090909091 | 0.345274517992913 | 0.345274517992913 | false | false | false | true | ||||||||||||||||
| 8e76b9a9-d75b-4edd-bfca-36767840b19b | 2026-09-09 15:13 | 2026-09-09 15:13 | 2026-09-09 15:13 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.5900 | 2.5300 | 2.6000 | 195.0100 | 15519.00 | 4135.00 | 0.00 | 60 | 11 | 2254 | 22 | 102.454545454545 | 0.346627140591497 | 0.346140446175939 | false | false | false | true | ||||||||||||||||
| c8f5b0ba-035f-4910-9df4-5f8f3dab74b0 | 2026-09-09 15:14 | 2026-09-09 15:14 | 2026-09-09 15:14 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.5900 | 2.5200 | 2.5900 | 195.0500 | 15022.00 | 15022.00 | 0.00 | 58 | 5 | 2437 | 22 | 110.772727272727 | 0.346926883062108 | 0.346926883062108 | false | false | false | true | ||||||||||||||||
| 9af60694-4a08-46d7-9ddf-2f53a56f67b9 | 2026-09-09 15:49 | 2026-09-09 15:49 | 2026-09-09 15:49 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.5900 | 2.3400 | 2.6600 | 195.1600 | 161875.00 | 89096.00 | 29008.00 | 625 | 35 | 5002 | 22 | 227.363636363636 | 0.347750388841124 | 0.347750388841124 | false | false | false | true | ||||||||||||||||
| 701dedd0-3331-4064-a8fb-34c0f7adeb7b | 2026-09-14 11:04 | 2026-09-14 11:04 | 2026-09-14 11:04 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.1800 | 1.9300 | 2.1800 | 198.2000 | 18094.00 | 18094.00 | 0.00 | 83 | 5 | 396 | 6296 | 0.0628970775095299 | 0.361238556840476 | 0.361238556840476 | true | false | false | true | ||||||||||||||||
| f5edcdf2-e83f-42f0-8894-b5b51ea0f84e | 2026-09-14 13:25 | 2026-09-14 13:24 | 2026-09-14 13:24 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.4800 | 2.0600 | 2.5500 | 195.1300 | 10168.00 | 10168.00 | 0.00 | 41 | 5 | 1322 | 6296 | 0.20997458703939 | 0.354177440002656 | 0.354177440002656 | false | false | false | true | ||||||||||||||||
| 2062b20e-de4d-4495-8c0a-959201f808ac | 2026-09-14 14:57 | 2026-09-14 14:57 | 2026-09-14 14:57 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.7100 | 2.7100 | 2.8800 | 193.5850 | 60777.00 | 0.00 | 40921.00 | 224 | 8 | 2518 | 6296 | 0.399936467598475 | 0.353571895415707 | 0.354061424161518 | true | false | false | true | ||||||||||||||||
| 5be8795b-3f8b-43ee-ae04-7116c50817ae | 2026-09-16 09:53 | 2026-09-16 09:53 | 2026-09-16 09:53 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.7300 | 2.5200 | 2.9200 | 194.3600 | 69644.00 | 33352.00 | 15892.00 | 255 | 5 | 342 | 6429 | 0.053196453569762 | 0.365459009759004 | 0.366458495518262 | false | false | false | true | ||||||||||||||||
| ad7831bf-a41c-4c82-b5b8-69f281fa23db | 2026-09-16 09:53 | 2026-09-16 09:53 | 2026-09-16 09:53 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.7800 | 2.7500 | 2.9200 | 194.1100 | 38706.00 | 20850.00 | 17856.00 | 139 | 5 | 689 | 6429 | 0.107170633068907 | 0.366434196850617 | 0.366929685033296 | true | false | false | true | ||||||||||||||||
| 7cb07f5f-5c5d-45ee-b1ce-2114d190b2d5 | 2026-09-16 09:55 | 2026-09-16 09:55 | 2026-09-16 09:55 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.7500 | 2.7200 | 2.8800 | 194.3342 | 463925.00 | 117700.00 | 341275.00 | 1687 | 44 | 2598 | 6429 | 0.40410639290714 | 0.366749959873138 | 0.366749959873138 | false | false | false | true | ||||||||||||||||
| 82783dca-d76b-4d33-af8e-a853df540eaa | 2026-09-16 10:00 | 2026-09-16 09:59 | 2026-09-16 09:59 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.7100 | 2.6700 | 2.7100 | 194.1900 | 25203.00 | 25203.00 | 0.00 | 93 | 5 | 3243 | 6429 | 0.50443303779748 | 0.363593619368806 | 0.363593619368806 | false | false | false | true | ||||||||||||||||
| c781ed75-49fa-4b7d-9cd5-fe951ef05fdc | 2026-09-16 10:04 | 2026-09-16 10:04 | 2026-09-16 10:04 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.6500 | 2.6500 | 2.8000 | 194.2400 | 11925.00 | 0.00 | 11925.00 | 45 | 7 | 3813 | 6429 | 0.593093793747083 | 0.360983118628027 | 0.360983118628027 | false | false | false | true | ||||||||||||||||
| 0491f5d9-f292-4ec5-8e8e-358e10cae707 | 2026-09-16 10:06 | 2026-09-16 10:05 | 2026-09-16 10:05 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.6400 | 2.6400 | 2.8700 | 194.2500 | 16368.00 | 0.00 | 16368.00 | 62 | 11 | 4383 | 6429 | 0.681754549696687 | 0.360558989394568 | 0.360558989394568 | false | false | false | true | ||||||||||||||||
| 05db7641-572b-43b7-b7d2-794cfc09d4b8 | 2026-09-16 10:06 | 2026-09-16 10:06 | 2026-09-16 10:06 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.6300 | 2.6100 | 2.6300 | 194.3600 | 25248.00 | 25248.00 | 0.00 | 96 | 5 | 4479 | 6429 | 0.696686887540831 | 0.360932659066481 | 0.360932659066481 | false | false | false | true | ||||||||||||||||
| 612d960e-a447-41fc-8ac8-debedf49cec4 | 2026-09-16 10:06 | 2026-09-16 10:06 | 2026-09-16 10:06 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.6300 | 2.6300 | 2.8700 | 194.2500 | 73640.00 | 0.00 | 73640.00 | 280 | 7 | 4816 | 6429 | 0.74910561518121 | 0.360054242961236 | 0.360054242961236 | false | false | false | true | ||||||||||||||||
| 65fc8362-fb63-4f7e-a3f9-7b143e6f1a58 | 2026-09-16 10:21 | 2026-09-16 10:21 | 2026-09-16 10:21 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.7900 | 2.7900 | 2.8000 | 193.0000 | 13950.00 | 0.00 | 6696.00 | 50 | 6 | 4866 | 6429 | 0.756882874475035 | 0.361978463325793 | 0.361978463325793 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4238179533.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4238179533.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4238179533.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4238179533.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4238179533.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4238179533.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4238179533.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4238179533.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:53:17.072904Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4238179533.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4238179533.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4238179533.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 4332127978.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4332127978.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4332127978.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4332127978.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4332127978.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4332127978.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4332127978.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4332127978.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 4332127978.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |