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_alerts609,118 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 |
|---|
| 768da873-2cd7-46dc-8a25-a747997b8c97 | 2026-09-01 09:31 | 2026-09-01 09:31 | 2026-09-01 09:31 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 3.7000 | 3.7000 | 3.7500 | 108.5000 | 111370.00 | 0.00 | 52910.00 | 301 | 10 | 301 | 4659 | 0.064606138656364 | 0.337270717684378 | 0.337270717684378 | 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-09-01T13:34:32.417809Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8946654a-1cd5-4abe-93c9-ec40fc314697 | 2026-09-04 10:17 | 2026-09-04 10:17 | 2026-09-04 10:17 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 4.2500 | 4.2500 | 4.4000 | 105.0100 | 29750.00 | 0.00 | 1275.00 | 70 | 13 | 80 | 5097 | 0.0156955071610751 | 0.316523642520532 | 0.316523642520532 | false | false | false | true | ||||||||||||||||
| 66bf53bc-9138-4160-b30c-09f8958bf72b | 2026-09-04 10:31 | 2026-09-04 10:31 | 2026-09-04 10:31 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 4.3500 | 4.1000 | 4.3500 | 104.8300 | 44370.00 | 44370.00 | 0.00 | 102 | 22 | 238 | 5097 | 0.0466941338041985 | 0.318820574970584 | 0.318494168248192 | false | false | false | true | ||||||||||||||||
| bcdbf381-37ef-407a-b565-ffc08938b5cd | 2026-09-04 12:01 | 2026-09-04 12:01 | 2026-09-04 12:01 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 4.3500 | 4.1500 | 4.5000 | 104.6450 | 217476.00 | 217476.00 | 0.00 | 500 | 5 | 740 | 5097 | 0.145183441239945 | 0.314487105881989 | 0.314487105881989 | false | false | false | true | ||||||||||||||||
| fdc588f9-af87-43ca-90fd-1de109370044 | 2026-09-04 13:02 | 2026-09-04 13:02 | 2026-09-04 13:02 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 4.3500 | 4.1500 | 4.3500 | 104.7050 | 113095.00 | 113095.00 | 0.00 | 260 | 18 | 16201 | 5097 | 3.17853639395723 | 0.316448524546375 | 0.316448524546375 | false | false | false | true | ||||||||||||||||
| 377b15ef-4ad3-49ec-ac62-f7ec8359c607 | 2026-09-04 13:29 | 2026-09-04 13:29 | 2026-09-04 13:29 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 4.3500 | 4.3500 | 4.4500 | 104.7950 | 108750.00 | 0.00 | 26100.00 | 250 | 5 | 16453 | 5097 | 3.22797724151462 | 0.317922363748724 | 0.317922363748724 | false | false | false | true | ||||||||||||||||
| 0a2d95ad-ded5-4d13-89e8-edf97c5cdf87 | 2026-09-04 13:29 | 2026-09-04 13:29 | 2026-09-04 13:29 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 4.3500 | 4.0500 | 4.3500 | 104.7950 | 326250.00 | 326250.00 | 0.00 | 750 | 5 | 17203 | 5097 | 3.3751226211497 | 0.317922363748724 | 0.317922363748724 | false | false | false | true | ||||||||||||||||
| b7c6f903-d836-4801-8836-68295156a5b3 | 2026-09-08 10:31 | 2026-09-08 10:30 | 2026-09-08 10:30 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 5.2500 | 5.1500 | 5.3000 | 102.2350 | 42525.00 | 34650.00 | 7875.00 | 81 | 7 | 248 | 19943 | 0.0124354410068696 | 0.322040177102868 | 0.322040177102868 | false | false | false | true | ||||||||||||||||
| 79ec83b9-481f-4dcc-82bc-3faef770c4c1 | 2026-09-08 10:31 | 2026-09-08 10:31 | 2026-09-08 10:31 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 5.2500 | 5.1500 | 5.3000 | 102.2750 | 22050.00 | 11025.00 | 11025.00 | 42 | 6 | 494 | 19943 | 0.0247705961991676 | 0.32279488231279 | 0.32279488231279 | false | false | false | true | ||||||||||||||||
| 4aa31722-6b33-4391-ac27-1a60bd6f0711 | 2026-09-08 10:34 | 2026-09-08 10:34 | 2026-09-08 10:34 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 5.2000 | 5.2000 | 5.2500 | 102.4000 | 10920.00 | 0.00 | 10920.00 | 21 | 5 | 571 | 19943 | 0.0286316000601715 | 0.322718310011833 | 0.322718310011833 | false | false | false | true | ||||||||||||||||
| 4b4b602b-7459-4424-9b5c-1cb7abc5e7d5 | 2026-09-08 12:47 | 2026-09-08 12:46 | 2026-09-08 12:46 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 5.1000 | 5.1000 | 5.1500 | 102.7800 | 38250.00 | 0.00 | 38250.00 | 75 | 7 | 1499 | 19943 | 0.0751642180213609 | 0.324912595043802 | 0.324912595043802 | false | false | false | true | ||||||||||||||||
| 930d8d9a-827c-4b9a-8604-397516a43667 | 2026-09-08 13:12 | 2026-09-08 13:11 | 2026-09-08 13:11 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 5.0500 | 5.0500 | 5.1500 | 102.9100 | 163115.00 | 0.00 | 163115.00 | 323 | 8 | 1872 | 19943 | 0.093867522438951 | 0.324862019036468 | 0.324862019036468 | false | false | false | true | ||||||||||||||||
| 9e59dcb8-6e80-438d-bb85-a120afeeccbc | 2026-09-08 15:43 | 2026-09-08 15:43 | 2026-09-08 15:43 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 5.1500 | 5.1500 | 5.2500 | 102.6450 | 108665.00 | 0.00 | 108665.00 | 211 | 11 | 2778 | 19943 | 0.139296996439854 | 0.32485272192587 | 0.32485272192587 | false | false | false | true | ||||||||||||||||
| 020ff756-4d38-417e-ac1d-233bef76eeb1 | 2026-09-08 15:44 | 2026-09-08 15:44 | 2026-09-08 15:44 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 5.1500 | 5.0500 | 5.2000 | 102.6350 | 405235.00 | 393905.00 | 11330.00 | 787 | 12 | 3567 | 19943 | 0.178859750288322 | 0.324667523825061 | 0.324667523825061 | false | false | false | true | ||||||||||||||||
| 044e40bd-e129-47e3-bf45-d3f70dbbc687 | 2026-09-11 09:36 | 2026-09-11 09:36 | 2026-09-11 09:36 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 5.2000 | 5.1000 | 5.3500 | 102.0000 | 130000.00 | 114400.00 | 15600.00 | 250 | 32 | 250 | 21066 | 0.0118674641602582 | 0.319749668487228 | 0.319749668487228 | false | false | false | true | ||||||||||||||||
| f623165f-d4da-4ae8-9613-26c84f3667e4 | 2026-09-11 15:31 | 2026-09-11 15:31 | 2026-09-11 15:31 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 5.1400 | 5.0000 | 5.2500 | 101.7900 | 154200.00 | 154200.00 | 0.00 | 300 | 2 | 3063 | 21066 | 0.145400170891484 | 0.310176837339098 | 0.310176837339098 | false | true | true | false | ||||||||||||||||
| d17e1537-7171-4ad0-a3e3-ba15c215755e | 2026-09-23 12:09 | 2026-09-23 12:09 | 2026-09-23 12:09 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 3.1000 | 2.8000 | 3.1000 | 108.1100 | 106330.00 | 106330.00 | 0.00 | 343 | 22 | 346 | 24619 | 0.0140541857914619 | 0.333814091285348 | 0.333814091285348 | false | false | false | true | ||||||||||||||||
| fbfe6bc6-1374-4da6-a769-d346d4430c6f | 2026-09-23 13:02 | 2026-09-23 13:02 | 2026-09-23 13:02 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 3.0100 | 3.0000 | 3.2000 | 108.0750 | 53213.00 | 305.00 | 52908.00 | 177 | 10 | 847 | 24619 | 0.034404321865226 | 0.329789527736739 | 0.330370754531799 | false | false | false | true | ||||||||||||||||
| 133c62f0-d36e-42c0-8cc2-f85d74f034ea | 2026-09-23 13:02 | 2026-09-23 13:02 | 2026-09-23 13:02 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 3.0100 | 2.8000 | 3.2000 | 108.0500 | 97380.00 | 32400.00 | 24180.00 | 324 | 10 | 670 | 24619 | 0.0272147528331776 | 0.327076294293631 | 0.329403436259094 | false | false | false | true | ||||||||||||||||
| 4908fbf7-ada4-4fe8-82ab-3e66411f98f1 | 2026-09-23 13:10 | 2026-09-23 13:10 | 2026-09-23 13:10 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 3.1500 | 3.0000 | 3.1500 | 107.9300 | 117495.00 | 117495.00 | 0.00 | 373 | 19 | 1220 | 24619 | 0.0495552215768309 | 0.33391136091009 | 0.33391136091009 | false | false | false | true | ||||||||||||||||
| 49a5a526-3a9e-4408-a6fe-b2223315c994 | 2026-09-25 10:08 | 2026-09-25 10:08 | 2026-09-25 10:08 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 3.5000 | 3.5000 | 3.5500 | 106.0000 | 70700.00 | 0.00 | 70700.00 | 202 | 20 | 254 | 23731 | 0.0107032994816906 | 0.337788170939455 | 0.337788170939455 | true | false | false | true | ||||||||||||||||
| acae7ce8-e8be-4416-893d-e81a32fd9550 | 2026-09-28 12:04 | 2026-09-28 12:04 | 2026-09-28 12:04 | IGV | IGV261218P00100000 | put | 100.0000 | 2026-12-18 | 3.8000 | 3.7000 | 3.9500 | 105.3700 | 38000.00 | 27360.00 | 760.00 | 100 | 29 | 1137 | 23666 | 0.0480436068621651 | 0.337273157452526 | 0.337273157452526 | 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-09-04T14:26:05.443569Z"} |
| 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-09-04T14:44:26.340635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:13:56.145626Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:07:55.847311Z"} |
| 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-09-04T17:34:11.817020Z"} |
| 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-09-04T17:34:11.817020Z"} |
| 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-09-08T14:47:12.085652Z"} |
| 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-09-08T14:47:12.085652Z"} |
| 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-09-08T14:47:12.085652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13356725098.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:11:09.796111Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13356725098.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:42:35.153326Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13356725098.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13356725098.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13356725098.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:37:33.609039Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 13356725098.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13830698840.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:13:15.432740Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 13830698840.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:03:13.598333Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13830698840.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:03:13.598333Z"} |
| 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-23T17:11:20.356460Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14114590147.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:09:41.700516Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13923614587.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:05:35.930466Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |