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 |
|---|
| 8ee271ef-e137-4d7d-9fca-a9541aaeeed9 | 2026-08-18 09:37 | 2026-08-18 09:37 | 2026-08-18 09:37 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 1.9800 | 1.9300 | 1.9900 | 302.3300 | 539916.00 | 539916.00 | 0.00 | 2728 | 11 | 5228 | 17210 | 0.303776873910517 | 0.217966779574259 | 0.217966779574259 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 79887436077.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 815602a9-6da9-471e-999f-5ed362db4c76 | 2026-08-18 10:14 | 2026-08-18 10:14 | 2026-08-18 10:14 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 2.1100 | 2.0600 | 2.1100 | 301.7500 | 338959.00 | 338959.00 | 0.00 | 1608 | 16 | 12349 | 17210 | 0.717547937245787 | 0.218513611874844 | 0.218849570173647 | false | false | false | true | ||||||||||||||||
| 2021976e-4436-4892-a709-66a8155ffe5d | 2026-08-18 10:14 | 2026-08-18 10:14 | 2026-08-18 10:14 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 2.0900 | 2.0400 | 2.0900 | 301.8100 | 341297.00 | 341297.00 | 0.00 | 1633 | 31 | 9758 | 17210 | 0.566995932597327 | 0.218496328808775 | 0.218496328808775 | false | false | false | true | ||||||||||||||||
| d772e325-8c04-44c4-817e-7bf7b9070fd6 | 2026-08-21 12:53 | 2026-08-21 12:53 | 2026-08-21 12:53 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 2.0800 | 2.0500 | 2.0800 | 299.5600 | 208000.00 | 208000.00 | 0.00 | 1000 | 17 | 1053 | 25391 | 0.0414713874995077 | 0.209342596638444 | 0.209342596638444 | false | false | false | true | ||||||||||||||||
| e9d10f98-a677-435b-af0b-97e667518b19 | 2026-08-26 10:57 | 2026-08-26 10:57 | 2026-08-26 10:57 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 1.8200 | 1.8100 | 1.8600 | 298.6400 | 266994.00 | 6734.00 | 260260.00 | 1467 | 48 | 1479 | 21588 | 0.0685102834908282 | 0.20838454529723 | 0.20838454529723 | false | false | false | true | ||||||||||||||||
| 839db61d-e230-4e37-a6e9-fdf90281116a | 2026-08-27 12:05 | 2026-08-27 12:05 | 2026-08-27 12:05 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 1.3400 | 1.3200 | 1.3400 | 300.2200 | 201268.00 | 201268.00 | 0.00 | 1502 | 6 | 4081 | 22227 | 0.183605524812165 | 0.203069852153044 | 0.203069852153044 | false | false | false | true | ||||||||||||||||
| 7e45bf22-35de-4ec9-b673-5622604afc51 | 2026-08-27 12:06 | 2026-08-27 12:06 | 2026-08-27 12:06 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 1.3600 | 1.3300 | 1.3600 | 300.1200 | 838848.00 | 838848.00 | 0.00 | 6168 | 11 | 12081 | 22227 | 0.543528141449588 | 0.20325544135599 | 0.20325544135599 | false | false | false | true | ||||||||||||||||
| 45b6ee2d-934d-4fce-b375-0ab226bf2414 | 2026-08-27 12:06 | 2026-08-27 12:06 | 2026-08-27 12:06 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 1.3600 | 1.3300 | 1.3600 | 300.1200 | 249152.00 | 249152.00 | 0.00 | 1832 | 13 | 5913 | 22227 | 0.266027804022135 | 0.20325544135599 | 0.20325544135599 | false | false | false | true | ||||||||||||||||
| ff7b29c6-bbaf-4dba-9bbb-12c0352bc9b3 | 2026-08-27 16:07 | 2026-08-27 16:06 | 2026-08-27 16:06 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 1.3800 | 1.3800 | 1.4000 | 299.8200 | 656190.00 | 0.00 | 656190.00 | 4755 | 9 | 25230 | 22227 | 1.13510595222027 | 0.201607230175303 | 0.201607230175303 | false | false | false | true | ||||||||||||||||
| 5f5654ad-ca6c-4134-a062-c27d98e3951a | 2026-08-27 16:07 | 2026-08-27 16:06 | 2026-08-27 16:06 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 1.3800 | 1.3800 | 1.4200 | 299.8200 | 601128.00 | 0.00 | 601128.00 | 4356 | 37 | 17586 | 22227 | 0.791199892023215 | 0.201607230175303 | 0.201607230175303 | false | false | false | true | ||||||||||||||||
| 2cbd8761-3a30-4abc-ac05-7000703cd73b | 2026-08-27 16:07 | 2026-08-27 16:06 | 2026-08-27 16:06 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 1.3800 | 1.3800 | 1.4100 | 299.8200 | 398682.00 | 0.00 | 398682.00 | 2889 | 23 | 20475 | 22227 | 0.921176946956404 | 0.201607230175303 | 0.201607230175303 | false | false | false | true | ||||||||||||||||
| d8d6a51d-aefe-4c81-9efb-b7247f8bdf81 | 2026-08-28 10:22 | 2026-08-28 10:22 | 2026-08-28 10:22 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 1.4700 | 1.4500 | 1.5000 | 298.2900 | 192570.00 | 0.00 | 192570.00 | 1310 | 11 | 1320 | 23453 | 0.0562827783226027 | 0.196295628979587 | 0.196295628979587 | false | false | false | true | ||||||||||||||||
| 00b72868-7087-4b3b-9231-582e359abdb6 | 2026-08-28 14:54 | 2026-08-28 14:54 | 2026-08-28 14:54 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 1.8800 | 1.8400 | 1.8800 | 295.9350 | 174088.00 | 174088.00 | 0.00 | 926 | 34 | 4779 | 23453 | 0.203769240608877 | 0.192345432627545 | 0.192345432627545 | false | false | false | true | ||||||||||||||||
| f4307000-b6a3-4559-9d99-a62f15aaeb7d | 2026-09-01 12:38 | 2026-09-01 12:38 | 2026-09-01 12:38 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 3.3300 | 3.3200 | 3.3700 | 290.6999 | 116550.00 | 7992.00 | 68598.00 | 350 | 9 | 763 | 22877 | 0.0333522752109105 | 0.207928325790963 | 0.207928325790963 | false | false | false | true | ||||||||||||||||
| 7dfcbf94-0ee3-436b-9c7e-9ebbdc916885 | 2026-09-11 14:58 | 2026-09-11 14:58 | 2026-09-11 14:58 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 2.2500 | 2.2300 | 2.2500 | 289.2950 | 160650.00 | 160650.00 | 0.00 | 714 | 7 | 3762 | 24406 | 0.1541424239941 | 0.21094908243861 | 0.21094908243861 | false | false | false | true | ||||||||||||||||
| a5245cc9-e6ac-4dcf-8de5-a4b371cb0aa9 | 2026-09-15 10:39 | 2026-09-15 10:39 | 2026-09-15 10:39 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 3.7800 | 3.7800 | 3.8200 | 284.7800 | 252939.00 | 1900.00 | 251039.00 | 669 | 39 | 1931 | 25718 | 0.0750835990356949 | 0.250778036273904 | 0.249373587849767 | true | false | false | true | ||||||||||||||||
| 246ed70f-4dae-4d07-8e4e-2a04a9424a76 | 2026-09-16 09:53 | 2026-09-16 09:53 | 2026-09-16 09:53 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 2.5500 | 2.5200 | 2.5600 | 286.6200 | 273614.00 | 24735.00 | 248879.00 | 1073 | 20 | 1336 | 25277 | 0.0528543735411639 | 0.281922404639264 | 0.281922404639264 | false | false | false | true | ||||||||||||||||
| 1be092c6-b859-473a-8486-3a65a741a854 | 2026-09-16 09:58 | 2026-09-16 09:58 | 2026-09-16 09:58 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 2.4400 | 2.4200 | 2.4500 | 286.7450 | 123464.00 | 22936.00 | 100528.00 | 506 | 26 | 2010 | 25277 | 0.079518930252799 | 0.276501731518063 | 0.276501731518063 | false | false | false | true | ||||||||||||||||
| 5fac699c-698a-4081-9c0d-dd10b4c47f84 | 2026-09-16 15:25 | 2026-09-16 15:25 | 2026-09-16 15:25 | IWM | IWM260918P00287000 | put | 287.0000 | 2026-09-18 | 6.1000 | 5.9300 | 6.1000 | 281.1150 | 136030.00 | 136030.00 | 0.00 | 223 | 9 | 4983 | 25277 | 0.197135736044626 | 0.23193080054173 | 0.23193080054173 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:02:19.815281Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:07:33.804891Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:07:33.804891Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:07:33.804891Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:32:48.312014Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:32:48.312014Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:32:48.312014Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:38:22.875878Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T19:10:32.565799Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:48:42.201804Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78377484640.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78788792160.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 |
| — |
| 78788792160.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 |
| — |
| 78788792160.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:29:08.379560Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |