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_alerts523,327 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 |
|---|
| d45e3546-7b5d-4a2e-b0c6-52b16531d9d1 | 2026-08-31 09:39 | 2026-08-31 09:38 | 2026-08-31 09:38 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.5500 | 3.5500 | 3.6500 | 109.4800 | 79165.00 | 0.00 | 79165.00 | 223 | 8 | 224 | 18490 | 0.0121146565711195 | 0.331858064746747 | 0.331858064746747 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 14038397136.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b9adeb0c-1f4f-4451-8d19-360cd0455aa0 | 2026-08-31 09:39 | 2026-08-31 09:39 | 2026-08-31 09:39 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.5500 | 3.5500 | 3.6000 | 109.4800 | 27335.00 | 0.00 | 27335.00 | 77 | 5 | 301 | 18490 | 0.0162790697674419 | 0.331858064746747 | 0.331858064746747 | true | false | false | true | ||||||||||||||||
| 59fb9284-4988-4c0e-8b37-0b6096bf8e1b | 2026-08-31 09:39 | 2026-08-31 09:39 | 2026-08-31 09:39 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.5500 | 3.4500 | 3.6000 | 109.5600 | 88750.00 | 88750.00 | 0.00 | 250 | 6 | 601 | 18490 | 0.0325040562466198 | 0.33319512787458 | 0.33319512787458 | false | false | false | true | ||||||||||||||||
| 67fc7431-8662-41f6-8866-9b5cf7a0ae87 | 2026-08-31 09:40 | 2026-08-31 09:40 | 2026-08-31 09:40 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.5500 | 3.5500 | 3.6000 | 109.5800 | 236430.00 | 0.00 | 225780.00 | 666 | 29 | 1667 | 18490 | 0.0901568415359654 | 0.333528820893169 | 0.333528820893169 | false | false | false | true | ||||||||||||||||
| 33a0b442-c44d-46d2-ad08-6731edfae7c8 | 2026-08-31 09:45 | 2026-08-31 09:45 | 2026-08-31 09:45 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.4500 | 3.4500 | 3.5000 | 109.9600 | 69000.00 | 0.00 | 69000.00 | 200 | 10 | 2714 | 18490 | 0.146782044348296 | 0.334210080989442 | 0.334210080989442 | false | false | false | true | ||||||||||||||||
| 2e7643f6-9707-4e76-a131-602998c6e2e7 | 2026-08-31 09:48 | 2026-08-31 09:48 | 2026-08-31 09:48 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.5000 | 3.5000 | 3.5500 | 109.7050 | 70000.00 | 0.00 | 70000.00 | 200 | 8 | 4294 | 18490 | 0.2322336398053 | 0.332812078869682 | 0.332812078869682 | false | false | false | true | ||||||||||||||||
| 4e85884a-a83c-4734-84b3-2216144a8334 | 2026-09-21 15:34 | 2026-09-21 15:34 | 2026-09-21 15:34 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.4000 | 3.4000 | 3.5500 | 107.0250 | 52026.00 | 0.00 | 52026.00 | 153 | 29 | 22705 | 23525 | 0.965143464399575 | 0.321372025327081 | 0.321372025327081 | true | false | false | true | ||||||||||||||||
| 86524f65-b564-4a67-96a2-7227d8fd4333 | 2026-09-21 15:34 | 2026-09-21 15:34 | 2026-09-21 15:34 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.4000 | 3.4000 | 3.4500 | 107.0250 | 12920.00 | 0.00 | 12920.00 | 38 | 6 | 22763 | 23525 | 0.967608926673751 | 0.321372025327081 | 0.321372025327081 | false | false | false | true | ||||||||||||||||
| ec8ac99b-38d5-4f20-9887-4a44e6eb9f3e | 2026-09-21 15:39 | 2026-09-21 15:38 | 2026-09-21 15:38 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.4000 | 3.4000 | 3.4500 | 107.1100 | 63920.00 | 0.00 | 63920.00 | 188 | 33 | 23040 | 23525 | 0.979383634431456 | 0.323187944744502 | 0.323187944744502 | false | false | false | true | ||||||||||||||||
| eae7de77-60d3-4a1e-93c1-6754c7be52f7 | 2026-09-21 15:39 | 2026-09-21 15:38 | 2026-09-21 15:38 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.4000 | 3.4000 | 3.4500 | 107.1150 | 37740.00 | 0.00 | 37740.00 | 111 | 8 | 23180 | 23525 | 0.985334750265675 | 0.32329455058272 | 0.32329455058272 | false | false | false | true | ||||||||||||||||
| 773c144f-10a0-40d1-a49f-e97d49aef9e2 | 2026-09-21 15:39 | 2026-09-21 15:38 | 2026-09-21 15:38 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.4000 | 3.4000 | 3.4500 | 107.1150 | 36720.00 | 0.00 | 36720.00 | 108 | 8 | 23317 | 23525 | 0.99115834218916 | 0.32329455058272 | 0.32329455058272 | false | false | false | true | ||||||||||||||||
| c2ce8b84-9c72-41a3-b7d1-ee70a684f2e3 | 2026-09-21 15:39 | 2026-09-21 15:39 | 2026-09-21 15:39 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.4000 | 3.4000 | 3.4500 | 107.1250 | 33660.00 | 0.00 | 33660.00 | 99 | 11 | 23434 | 23525 | 0.996131774707758 | 0.323507691646749 | 0.323507691646749 | false | false | false | true | ||||||||||||||||
| 05f6b9b6-c75d-46bf-9785-b203669cc6c5 | 2026-09-21 15:39 | 2026-09-21 15:39 | 2026-09-21 15:39 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.4000 | 3.4000 | 3.4500 | 107.1350 | 10880.00 | 0.00 | 10880.00 | 32 | 5 | 23479 | 23525 | 0.998044633368757 | 0.323720738683655 | 0.323720738683655 | false | false | false | true | ||||||||||||||||
| ad7329b1-ad75-40d7-91bb-202f00c38186 | 2026-09-23 15:02 | 2026-09-23 15:02 | 2026-09-23 15:02 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.1000 | 3.0500 | 3.1000 | 108.1600 | 26350.00 | 26350.00 | 0.00 | 85 | 18 | 118 | 19595 | 0.00602194437356468 | 0.330858179491362 | 0.330858179491362 | false | false | false | true | ||||||||||||||||
| f1c88951-393d-41de-9293-efffe60c5891 | 2026-09-23 15:06 | 2026-09-23 15:06 | 2026-09-23 15:06 | IGV | IGV261120P00103000 | put | 103.0000 | 2026-11-20 | 3.1000 | 3.0500 | 3.1000 | 108.1150 | 18600.00 | 18600.00 | 0.00 | 60 | 12 | 194 | 19595 | 0.0099004848175555 | 0.329934317472205 | 0.329934317472205 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:02:22.723941Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14093711286.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14093711286.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14093711286.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14093711286.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14093711286.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14093711286.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14093711286.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13830698840.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:05:07.702473Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13830698840.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:12:23.721983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |