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_alerts326,449 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 |
|---|
| adb7211d-6231-4d4b-898e-acc19bd8ab3c | 2026-09-21 15:06 | 2026-09-21 15:06 | 2026-09-21 15:06 | TCOM | TCOM261016C00040000 | call | 40.0000 | 2026-10-16 | 1.7000 | 1.7000 | 1.7500 | 40.7100 | 21080.00 | 0.00 | 21080.00 | 124 | 16 | 162 | 1936 | 0.0836776859504132 | 0.296732553279263 | 0.296732553279263 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Consumer Cyclical | 26405572283.00 | 2026-11-16 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| c595e2e7-d57a-4c1d-aa1d-55672d2f07de | 2026-09-18 10:27 | 2026-09-18 10:27 | 2026-09-18 10:27 | TCOM | TCOM261016P00040000 | put | 40.0000 | 2026-10-16 | 0.8000 | 0.7500 | 0.8000 | 41.0600 | 38480.00 | 38480.00 | 0.00 | 481 | 33 | 941 | 4559 | 0.206404913358193 | 0.292318804060493 | 0.292318804060493 | false | false | false | true | ||||||||||||||||
| 3d578d62-9bc0-4612-ba8f-8997421f0ca5 | 2026-09-18 10:27 | 2026-09-18 10:27 | 2026-09-18 10:27 | TCOM | TCOM261016C00045000 | call | 45.0000 | 2026-10-16 | 0.2500 | 0.2000 | 0.2500 | 40.9700 | 11250.00 | 11250.00 | 0.00 | 450 | 24 | 649 | 1659 | 0.391199517781796 | 0.300785257842454 | 0.300785257842454 | false | false | false | true | ||||||||||||||||
| 512d53a3-2e24-477a-a05c-a802523f9c06 | 2026-09-18 10:22 | 2026-09-18 10:22 | 2026-09-18 10:22 | TCOM | TCOM270115C00045000 | call | 45.0000 | 2027-01-15 | 1.8900 | 1.8500 | 1.9000 | 40.9200 | 34916.00 | 26688.00 | 8228.00 | 185 | 6 | 608 | 1793 | 0.33909648633575 | 0.342261617824747 | 0.345644353689494 | false | false | false | true | ||||||||||||||||
| 5b8398b6-8e5b-4b12-a3e3-ffd721567977 | 2026-09-18 10:19 | 2026-09-18 10:18 | 2026-09-18 10:18 | TCOM | TCOM270115C00045000 | call | 45.0000 | 2027-01-15 | 1.8800 | 1.8500 | 1.9000 | 40.9550 | 34778.00 | 34404.00 | 374.00 | 185 | 5 | 373 | 1793 | 0.20803123257111 | 0.340779138396689 | 0.340779138396689 | false | false | false | true | ||||||||||||||||
| 842f48da-68ae-4195-aa78-5f35efad117f | 2026-09-18 10:18 | 2026-09-18 10:18 | 2026-09-18 10:18 | TCOM | TCOM270115C00045000 | call | 45.0000 | 2027-01-15 | 1.8500 | 1.7500 | 1.9000 | 40.9350 | 34380.00 | 34195.00 | 185.00 | 186 | 11 | 188 | 1793 | 0.104852203011712 | 0.33802939430985 | 0.33936969754265 | false | false | false | true | ||||||||||||||||
| e9398bad-5c94-4fcd-bbc0-15db38a20800 | 2026-09-17 15:48 | 2026-09-17 15:48 | 2026-09-17 15:48 | TCOM | TCOM261016P00040000 | put | 40.0000 | 2026-10-16 | 1.0500 | 0.9500 | 1.1000 | 40.4500 | 19425.00 | 19425.00 | 0.00 | 185 | 6 | 1555 | 3801 | 0.409102867666404 | 0.291891839250199 | 0.291891839250199 | false | false | false | true | ||||||||||||||||
| 44b6ee7e-3d9f-42d3-8fb1-b98ae6ea1080 | 2026-09-17 13:08 | 2026-09-17 13:07 | 2026-09-17 13:07 | TCOM | TCOM261016C00040000 | call | 40.0000 | 2026-10-16 | 1.7000 | 1.6500 | 1.7500 | 40.5200 | 19890.00 | 14620.00 | 0.00 | 117 | 11 | 807 | 1672 | 0.482655502392345 | 0.300689470634158 | 0.299356697303032 | false | false | false | true | ||||||||||||||||
| de71ea42-3a94-4502-88d0-4f14b31b04ab | 2026-09-17 13:07 | 2026-09-17 13:07 | 2026-09-17 13:07 | TCOM | TCOM261016P00040000 | put | 40.0000 | 2026-10-16 | 1.0500 | 1.0000 | 1.1000 | 40.5100 | 15750.00 | 0.00 | 0.00 | 150 | 7 | 1020 | 3801 | 0.26835043409629 | 0.297456058676539 | 0.297456058676539 | false | false | false | true | ||||||||||||||||
| d0a0879a-8a3b-40ac-a7bb-feba3cef158a | 2026-09-17 13:07 | 2026-09-17 13:07 | 2026-09-17 13:07 | TCOM | TCOM261016P00040000 | put | 40.0000 | 2026-10-16 | 1.0500 | 1.0000 | 1.1000 | 40.4900 | 11550.00 | 0.00 | 0.00 | 110 | 7 | 870 | 3801 | 0.228887134964483 | 0.295609000793578 | 0.295609000793578 | false | false | false | true | ||||||||||||||||
| 7ba9ea52-7920-4664-83bb-13894cb2a257 | 2026-09-17 11:38 | 2026-09-17 11:38 | 2026-09-17 11:38 | TCOM | TCOM261016C00040000 | call | 40.0000 | 2026-10-16 | 1.6000 | 1.5500 | 1.6500 | 40.4250 | 21760.00 | 0.00 | 21120.00 | 136 | 35 | 185 | 1672 | 0.110645933014354 | 0.289405531765157 | 0.289405531765157 | false | false | false | true | ||||||||||||||||
| f833c83a-07a7-42fa-bcce-1414976e73b4 | 2026-09-17 10:32 | 2026-09-17 10:32 | 2026-09-17 10:32 | TCOM | TCOM261016C00035000 | call | 35.0000 | 2026-10-16 | 5.8000 | 5.1000 | 6.0000 | 40.5900 | 13920.00 | 3480.00 | 10440.00 | 24 | 5 | 85 | 22 | 3.86363636363636 | 0.349581759140028 | 0.349581759140028 | false | false | false | true | ||||||||||||||||
| cd650cdd-c1ad-46f1-b305-5654007efc58 | 2026-09-16 12:15 | 2026-09-16 12:15 | 2026-09-16 12:15 | TCOM | TCOM260918C00040000 | call | 40.0000 | 2026-09-18 | 1.1300 | 1.0500 | 1.2000 | 40.9300 | 11285.00 | 440.00 | 10730.00 | 100 | 15 | 1483 | 2175 | 0.68183908045977 | 0.440032928127556 | 0.414814459121847 | false | false | false | true | ||||||||||||||||
| 74f0da6a-6545-4a33-97c6-dc3569435bde | 2026-09-16 11:46 | 2026-09-16 11:46 | 2026-09-16 11:46 | TCOM | TCOM261016P00040000 | put | 40.0000 | 2026-10-16 | 1.1000 | 1.0000 | 1.1500 | 40.4600 | 170170.00 | 170170.00 | 0.00 | 1547 | 27 | 2882 | 2367 | 1.21757498943811 | 0.30357006970877 | 0.29929274891733 | false | false | false | true | ||||||||||||||||
| 802af6a3-856e-4e28-bea4-778d5221daf5 | 2026-09-16 10:16 | 2026-09-16 10:15 | 2026-09-16 10:15 | TCOM | TCOM270115C00047000 | call | 47.0000 | 2027-01-15 | 1.1500 | 1.1000 | 1.5000 | 39.0000 | 17250.00 | 17135.00 | 115.00 | 150 | 14 | 150 | 432 | 0.347222222222222 | 0.351534289407306 | 0.351534289407306 | true | false | false | true | ||||||||||||||||
| 50f75b55-1d78-4604-af85-f49ad375a191 | 2026-09-16 10:11 | 2026-09-16 10:11 | 2026-09-16 10:11 | TCOM | TCOM261218P00035000 | put | 35.0000 | 2026-12-18 | 0.9000 | 0.8000 | 0.9500 | 39.6700 | 18900.00 | 18810.00 | 0.00 | 210 | 7 | 217 | 1192 | 0.182046979865772 | 0.362772836636006 | 0.362772836636006 | false | false | false | true | ||||||||||||||||
| 826ccda2-2dbd-4423-8210-95b763c056cd | 2026-09-16 10:03 | 2026-09-16 10:02 | 2026-09-16 10:02 | TCOM | TCOM270617C00050000 | call | 50.0000 | 2027-06-17 | 2.4000 | 2.2000 | 2.4000 | 39.8600 | 36240.00 | 36240.00 | 0.00 | 151 | 7 | 151 | 1119 | 0.134941912421805 | 0.374634560904891 | 0.374634560904891 | true | false | false | true | ||||||||||||||||
| 29464712-2ae4-48af-8d63-4f94bd13da82 | 2026-09-16 09:33 | 2026-09-16 09:33 | 2026-09-16 09:33 | TCOM | TCOM261016P00040000 | put | 40.0000 | 2026-10-16 | 1.0500 | 0.9000 | 1.0500 | 40.6800 | 72450.00 | 72450.00 | 0.00 | 690 | 10 | 807 | 2367 | 0.340937896070976 | 0.319183292784396 | 0.30792417776001 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 26425059790.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 26425059790.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Consumer Cyclical |
| 26425059790.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Consumer Cyclical |
| 26425059790.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Consumer Cyclical |
| 26425059790.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 26217193047.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 26217193047.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 26217193047.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 26217193047.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 26217193047.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 26217193047.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Consumer Cyclical |
| 26262663897.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 26262663897.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 26262663897.00 |
| 2026-11-16 |
| unknown |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 26262663897.00 |
| 2026-11-16 |
| unknown |
| — |
| 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 |
| ADR |
| Consumer Cyclical |
| 26262663897.00 |
| 2026-11-16 |
| unknown |
| — |
| 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 |
| ADR |
| Consumer Cyclical |
| 26262663897.00 |
| 2026-11-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |