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_alerts375,978 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 |
|---|
| e73bbaae-568b-40ad-8253-b269d892b3b6 | 2026-09-23 09:42 | 2026-09-23 09:42 | 2026-09-23 09:42 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 0.3100 | 0.3100 | 0.3700 | 111.7500 | 33077.00 | 0.00 | 33077.00 | 1067 | 14 | 1697 | 48082 | 0.0352938729670147 | 0.525962065866291 | 0.525962065866291 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Consumer Cyclical | 257338183667.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 72ef79d2-843a-475b-8e87-04cebf5a66be | 2026-09-23 09:42 | 2026-09-23 09:42 | 2026-09-23 09:42 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 0.3100 | 0.3100 | 0.3700 | 111.7500 | 18786.00 | 0.00 | 18786.00 | 606 | 58 | 630 | 48082 | 0.013102616363712 | 0.525962065866291 | 0.525962065866291 | false | false | false | true | ||||||||||||||||
| 6bc0b195-865a-472a-bef9-8075208e15b4 | 2026-09-22 10:05 | 2026-09-22 10:05 | 2026-09-22 10:05 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 0.7500 | 0.7500 | 0.8200 | 118.2500 | 15000.00 | 0.00 | 15000.00 | 200 | 35 | 2212 | 47755 | 0.0463197570934981 | 0.499208441220292 | 0.499208441220292 | true | false | false | true | ||||||||||||||||
| 30807f0b-a01a-47b1-a007-32308d1d24ff | 2026-09-22 09:44 | 2026-09-22 09:44 | 2026-09-22 09:44 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 0.9600 | 0.9400 | 1.0100 | 119.0000 | 48026.00 | 192.00 | 47834.00 | 502 | 47 | 1832 | 47755 | 0.0383624751334939 | 0.511351438062363 | 0.509809945412539 | false | false | false | true | ||||||||||||||||
| 7f35117c-9f35-4190-b96b-bb6655fac3c4 | 2026-09-22 09:41 | 2026-09-22 09:41 | 2026-09-22 09:41 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 0.9400 | 0.9400 | 1.0300 | 119.6600 | 64773.00 | 665.00 | 64108.00 | 689 | 20 | 1225 | 47755 | 0.0256517642131714 | 0.503012604508462 | 0.503012604508462 | false | false | false | true | ||||||||||||||||
| 87399e42-c502-4e4e-99d0-965f3abbe058 | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 1.0200 | 1.0100 | 1.1000 | 119.8000 | 11526.00 | 204.00 | 11322.00 | 113 | 8 | 182 | 47755 | 0.00381111925452832 | 0.512375433986354 | 0.512375433986354 | false | false | false | true | ||||||||||||||||
| 71072cab-d365-4c7a-8d4d-2f462ac21e6e | 2026-09-18 10:56 | 2026-09-18 10:56 | 2026-09-18 10:56 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 0.6400 | 0.6400 | 0.6500 | 113.1000 | 65408.00 | 0.00 | 128.00 | 1022 | 15 | 19634 | 27923 | 0.703147942556316 | 0.532465982041246 | 0.532465982041246 | false | false | false | true | ||||||||||||||||
| 299d0c6f-5083-4f91-906c-2994ff2aec47 | 2026-09-18 10:55 | 2026-09-18 10:55 | 2026-09-18 10:55 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 0.6300 | 0.6300 | 0.6400 | 113.1300 | 55440.00 | 0.00 | 21798.00 | 880 | 8 | 16620 | 27923 | 0.5952082512624 | 0.529934888769979 | 0.529934888769979 | false | false | false | true | ||||||||||||||||
| 4f6cfbed-acc7-466f-a0c9-0c6c0f615c9c | 2026-09-18 10:55 | 2026-09-18 10:55 | 2026-09-18 10:55 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 0.6200 | 0.6200 | 0.6300 | 113.1400 | 88288.00 | 0.00 | 248.00 | 1424 | 40 | 14120 | 27923 | 0.505676324177202 | 0.527741066313141 | 0.527741066313141 | false | false | false | true | ||||||||||||||||
| 6e4f6e17-f82d-4515-b132-b181da58bb17 | 2026-09-18 10:49 | 2026-09-18 10:48 | 2026-09-18 10:48 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 0.5900 | 0.5900 | 0.6000 | 113.1850 | 99297.00 | 0.00 | 30975.00 | 1683 | 47 | 10511 | 27923 | 0.376428034237009 | 0.521414571724347 | 0.520807046765151 | false | false | false | true | ||||||||||||||||
| 93691365-7ad4-44e4-9ebc-39a5b4d7eeb9 | 2026-09-18 10:48 | 2026-09-18 10:48 | 2026-09-18 10:48 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 0.5900 | 0.5900 | 0.6000 | 113.0800 | 88677.00 | 0.00 | 413.00 | 1503 | 16 | 8049 | 27923 | 0.288256992443505 | 0.522629882212792 | 0.522629882212792 | false | false | false | true | ||||||||||||||||
| 75aeb849-7f03-444e-b7e9-a0761bfc9fe9 | 2026-09-18 10:47 | 2026-09-18 10:47 | 2026-09-18 10:47 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 0.5900 | 0.5300 | 0.6000 | 113.1600 | 80543.00 | 480.00 | 80063.00 | 1365 | 28 | 4840 | 27923 | 0.173333810836944 | 0.523307766791528 | 0.521240984321869 | false | false | false | true | ||||||||||||||||
| c0ea007f-8b95-4b9a-b666-e7d4da49ae2d | 2026-09-18 10:47 | 2026-09-18 10:47 | 2026-09-18 10:47 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 0.5900 | 0.5900 | 0.6000 | 113.1700 | 182133.00 | 0.00 | 182133.00 | 3087 | 37 | 3475 | 27923 | 0.124449378648426 | 0.521067403996594 | 0.521067403996594 | false | false | false | true | ||||||||||||||||
| fb6a7978-1e24-4454-8076-b8b07054fccb | 2026-08-25 11:26 | 2026-08-25 11:26 | 2026-08-25 11:26 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 2.2100 | 2.2100 | 2.3100 | 118.2600 | 67640.00 | 456.00 | 67184.00 | 306 | 36 | 556 | 27014 | 0.0205819204856741 | 0.478875775892741 | 0.474330693610581 | false | false | false | true | ||||||||||||||||
| 13dde73f-f262-4d77-acba-016edf0f34e8 | 2026-08-24 11:04 | 2026-08-24 11:04 | 2026-08-24 11:04 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 2.6100 | 2.5800 | 2.6300 | 119.5000 | 51678.00 | 25317.00 | 26361.00 | 198 | 18 | 17807 | 10897 | 1.63411948242636 | 0.477424489531916 | 0.476614932636068 | true | false | false | true | ||||||||||||||||
| cd2fbbb1-d60f-4937-95d8-9d490cd54818 | 2026-08-24 11:04 | 2026-08-24 11:04 | 2026-08-24 11:04 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 2.6200 | 2.5700 | 2.6200 | 119.5000 | 52400.00 | 52400.00 | 0.00 | 200 | 32 | 17502 | 10897 | 1.60613012755804 | 0.477592125648987 | 0.477344099495405 | true | false | false | true | ||||||||||||||||
| 6262f08e-f0b3-407a-b44f-389f5f1c8d21 | 2026-08-24 10:50 | 2026-08-24 10:49 | 2026-08-24 10:49 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 2.5900 | 2.5100 | 2.6300 | 119.6600 | 518000.00 | 518000.00 | 0.00 | 2000 | 28 | 17050 | 10897 | 1.56465082132697 | 0.474329555067177 | 0.472515280008467 | false | false | false | true | ||||||||||||||||
| 996e73bd-e78f-4786-be23-73bc9696a14f | 2026-08-24 10:49 | 2026-08-24 10:48 | 2026-08-24 10:48 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 2.6100 | 2.4800 | 2.6200 | 119.6100 | 502096.00 | 244489.00 | 257607.00 | 1923 | 16 | 12949 | 10897 | 1.18830870881894 | 0.475855973049668 | 0.47479761674917 | false | false | false | true | ||||||||||||||||
| 75266365-5ab3-4f78-9ab1-50f0a658dcf8 | 2026-08-24 10:48 | 2026-08-24 10:48 | 2026-08-24 10:48 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 2.6200 | 2.4900 | 2.6300 | 119.7650 | 523854.00 | 523595.00 | 0.00 | 2000 | 12 | 11024 | 10897 | 1.01165458383041 | 0.472649966594654 | 0.470783530160093 | false | false | false | true | ||||||||||||||||
| 96384f84-bea9-4f21-a1a5-700f08e7c77a | 2026-08-24 10:07 | 2026-08-24 10:07 | 2026-08-24 10:07 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 2.1600 | 2.1100 | 2.1700 | 117.6599 | 108000.00 | 20088.00 | 87912.00 | 500 | 14 | 4660 | 10897 | 0.427640635037166 | 0.47212574640736 | 0.47212574640736 | true | false | false | true | ||||||||||||||||
| 685cfbd7-6cfc-47b0-a441-868d42b25ab7 | 2026-08-24 10:06 | 2026-08-24 10:06 | 2026-08-24 10:06 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 2.1600 | 2.1000 | 2.1600 | 117.6400 | 107900.00 | 107900.00 | 0.00 | 500 | 34 | 4160 | 10897 | 0.381756446728457 | 0.473555025683991 | 0.471641813296106 | true | false | false | true | ||||||||||||||||
| 4d6177c7-a633-422d-9488-bf5c6010d533 | 2026-08-17 10:46 | 2026-08-17 10:46 | 2026-08-17 10:46 | BABA | BABA261016C00140000 | call | 140.0000 | 2026-10-16 | 4.0500 | 3.9500 | 4.1000 | 124.4100 | 107306.00 | 87461.00 | 19845.00 | 265 | 26 | 575 | 9278 | 0.0619745634835094 | 0.455313748973872 | 0.455313748973872 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 257338183667.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 270135416447.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Consumer Cyclical |
| 270135416447.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:45:11.876123Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 270135416447.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:43:21.956551Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 270135416447.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 263005197820.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 263005197820.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 263005197820.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 263005197820.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 263005197820.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Consumer Cyclical |
| 263005197820.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 263005197820.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:09:19.758040Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:09:19.758040Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |