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_alerts566,287 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 |
|---|
| 7266c571-50bb-45f1-928d-6006655f44a5 | 2026-08-28 14:25 | 2026-08-28 14:25 | 2026-08-28 14:25 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 2.8000 | 2.7600 | 2.8000 | 295.9200 | 138880.00 | 138880.00 | 0.00 | 496 | 11 | 525 | 634 | 0.82807570977918 | 0.205027728299266 | 0.205027728299266 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 79887436077.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T18:46:22.896033Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5ed6ccce-33dd-41c8-8d48-4b38236b7f3b | 2026-09-03 09:44 | 2026-09-03 09:44 | 2026-09-03 09:44 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 2.7700 | 2.7700 | 2.8100 | 294.9900 | 126866.00 | 0.00 | 126866.00 | 458 | 21 | 21625 | 786 | 27.5127226463104 | 0.209895853536943 | 0.209895853536943 | false | false | false | |||||||||||||||||
| 4782c039-af60-40d6-875e-0e94f3c15bab | 2026-09-03 10:21 | 2026-09-03 10:21 | 2026-09-03 10:21 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 2.8600 | 2.8500 | 2.9100 | 294.1700 | 286305.00 | 0.00 | 286305.00 | 1000 | 5 | 24004 | 786 | 30.5394402035623 | 0.20713191459231 | 0.20713191459231 | false | false | false | |||||||||||||||||
| 6d4dbdee-a8f8-4d3b-8c7b-47dbf254796a | 2026-09-03 11:33 | 2026-09-03 11:33 | 2026-09-03 11:33 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 2.6900 | 2.6500 | 2.6900 | 295.2350 | 118091.00 | 118091.00 | 0.00 | 439 | 10 | 37966 | 786 | 48.3027989821883 | 0.208997246761195 | 0.208997246761195 | false | false | false | |||||||||||||||||
| 0b53e630-2a2b-4960-bc92-5a65325b2575 | 2026-09-03 11:33 | 2026-09-03 11:33 | 2026-09-03 11:33 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 2.6900 | 2.6500 | 2.6900 | 295.2350 | 256357.00 | 256357.00 | 0.00 | 953 | 13 | 37527 | 786 | 47.7442748091603 | 0.208997246761195 | 0.208997246761195 | false | false | false | |||||||||||||||||
| a8b31bec-628d-4ec4-a8d5-3ea4e65a4176 | 2026-09-04 10:32 | 2026-09-04 10:32 | 2026-09-04 10:32 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 2.4000 | 2.3700 | 2.4100 | 295.5595 | 514560.00 | 514560.00 | 0.00 | 2144 | 6 | 6833 | 31069 | 0.219929833596189 | 0.203574909305456 | 0.203571325817956 | false | false | false | |||||||||||||||||
| 7952bb45-7e01-483d-9ac7-d3a81bf24187 | 2026-09-04 10:32 | 2026-09-04 10:32 | 2026-09-04 10:32 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 2.3900 | 2.3500 | 2.4000 | 295.5700 | 868454.00 | 788628.00 | 79826.00 | 3632 | 63 | 4689 | 31069 | 0.150922141040909 | 0.203507907557425 | 0.20364657310988 | false | false | false | |||||||||||||||||
| 4f752b17-09f8-45d4-a7c2-e210c3bc6c77 | 2026-09-08 12:05 | 2026-09-08 12:05 | 2026-09-08 12:05 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 2.3700 | 2.3400 | 2.3800 | 295.7600 | 501492.00 | 501492.00 | 0.00 | 2116 | 64 | 2161 | 38057 | 0.0567832461833565 | 0.213694528164269 | 0.213394395467004 | false | false | false | |||||||||||||||||
| 4b28d6a8-cab6-4f8b-85d6-5b8d6e194d7c | 2026-09-21 15:19 | 2026-09-21 15:19 | 2026-09-21 15:19 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 2.8400 | 2.8400 | 2.8600 | 286.2800 | 11076.00 | 0.00 | 11076.00 | 39 | 6 | 674 | 32078 | 0.02101128499283 | 0.180074730190116 | 0.180074730190116 | true | false | false | |||||||||||||||||
| cc5c01ba-2e12-42e9-9eb1-c2239c3e488c | 2026-09-22 10:40 | 2026-09-22 10:40 | 2026-09-22 10:40 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 2.6500 | 2.6100 | 2.6500 | 286.6481 | 66250.00 | 66250.00 | 0.00 | 250 | 21 | 356 | 32096 | 0.0110917248255234 | 0.180471354901432 | 0.180471354901432 | true | false | false | |||||||||||||||||
| 45013ee0-b53d-4ae3-9342-f25ef28e95f0 | 2026-09-23 13:02 | 2026-09-23 13:02 | 2026-09-23 13:02 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 4.3800 | 4.3300 | 4.3800 | 282.2100 | 10074.00 | 10074.00 | 0.00 | 23 | 7 | 24478 | 32224 | 0.759620158887785 | 0.187514782114106 | 0.187514782114106 | false | false | false | |||||||||||||||||
| 30cc026c-0ca0-4175-942f-4c18724f9456 | 2026-09-24 09:49 | 2026-09-24 09:48 | 2026-09-24 09:48 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 4.9700 | 4.9300 | 4.9800 | 280.5400 | 16401.00 | 15407.00 | 0.00 | 33 | 12 | 132 | 30984 | 0.00426026336173509 | 0.184850572273596 | 0.184850572273596 | true | false | false | |||||||||||||||||
| 62f8e089-6ae3-4191-8dc9-e47ca6a3521e | 2026-09-24 09:56 | 2026-09-24 09:56 | 2026-09-24 09:56 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 5.0300 | 4.9800 | 5.0300 | 280.5100 | 40743.00 | 40743.00 | 0.00 | 81 | 6 | 316 | 30984 | 0.0101988122902143 | 0.186506353925713 | 0.186506353925713 | false | false | false | |||||||||||||||||
| 4be472c5-ab59-4077-bafa-858e81b16c96 | 2026-09-25 11:22 | 2026-09-25 11:22 | 2026-09-25 11:22 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 4.2600 | 4.2400 | 4.2600 | 281.6501 | 13206.00 | 13206.00 | 0.00 | 31 | 6 | 388 | 28690 | 0.0135238759149529 | 0.181550751913106 | 0.181550751913106 | false | false | false | |||||||||||||||||
| a3f19bdf-01ce-4292-91cc-c82caf86234f | 2026-09-28 10:38 | 2026-09-28 10:37 | 2026-09-28 10:37 | IWM | IWM261016P00281000 | put | 281.0000 | 2026-10-16 | 4.8000 | 4.7600 | 4.8100 | 280.1500 | 39840.00 | 39360.00 | 480.00 | 83 | 6 | 104 | 28851 | 0.00360472773907317 | 0.187398946946065 | 0.187398946946065 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:45:03.310585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 79887436077.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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78377484640.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:41:08.297651Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77607608234.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:51:23.785124Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77607608234.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:59:25.813942Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77601345973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:25:06.221939Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:38:19.697231Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |