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 |
|---|
| 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 |
|---|
| e3fb2a73-ea8a-460f-9fd1-560729202c29 | 2026-09-10 15:45 | 2026-09-10 15:45 | 2026-09-10 15:45 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 4.7000 | 4.4000 | 4.9000 | 202.8100 | 23500.00 | 4700.00 | 10340.00 | 50 | 7 | 60 | 11 | 5.45454545454545 | 0.210631290988159 | 0.210631290988159 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 10336082630.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3d20bda7-6c60-40f9-ba81-505432d0000d | 2026-09-21 10:28 | 2026-09-21 10:28 | 2026-09-21 10:28 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 6.3000 | 6.2000 | 6.4000 | 207.5800 | 109640.00 | 97650.00 | 9450.00 | 174 | 11 | 253 | 129 | 1.96124031007752 | 0.212082994008712 | 0.212082994008712 | false | false | false | |||||||||||||||||
| 4fdb1bd1-6fe1-448a-9b9f-d01e57a1d255 | 2026-09-21 10:33 | 2026-09-21 10:33 | 2026-09-21 10:33 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 6.6500 | 6.6000 | 6.7000 | 207.8200 | 10634.00 | 0.00 | 1989.00 | 16 | 6 | 493 | 129 | 3.82170542635659 | 0.221802501354748 | 0.220834852890187 | false | false | false | |||||||||||||||||
| c9fd49d5-d81f-4c4a-b7d3-b7b50a0dfb01 | 2026-09-21 10:35 | 2026-09-21 10:34 | 2026-09-21 10:34 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 6.6000 | 6.5000 | 6.7000 | 207.7600 | 17160.00 | 0.00 | 3960.00 | 26 | 12 | 596 | 129 | 4.62015503875969 | 0.221187617098975 | 0.221187617098975 | false | false | false | |||||||||||||||||
| e87baf1d-f28f-442b-98b1-c7cf8fbe1212 | 2026-09-21 10:43 | 2026-09-21 10:43 | 2026-09-21 10:43 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 6.7000 | 6.7000 | 7.0000 | 207.0000 | 22124.00 | 0.00 | 22124.00 | 33 | 21 | 690 | 129 | 5.34883720930233 | 0.219834166630094 | 0.219834166630094 | true | false | false | |||||||||||||||||
| 9f5b0896-9f90-4e3a-828d-b44d00ecac0f | 2026-09-21 10:49 | 2026-09-21 10:49 | 2026-09-21 10:49 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 6.5000 | 6.5000 | 6.7000 | 207.6400 | 11707.00 | 0.00 | 11707.00 | 18 | 12 | 729 | 129 | 5.65116279069767 | 0.219945510157744 | 0.219945510157744 | false | false | false | |||||||||||||||||
| 2ba865e8-9d6f-49ba-aa96-2216991d3aae | 2026-09-21 10:59 | 2026-09-21 10:59 | 2026-09-21 10:59 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 6.4100 | 6.4000 | 6.6000 | 207.5450 | 15380.00 | 0.00 | 15380.00 | 24 | 15 | 813 | 129 | 6.30232558139535 | 0.220354456154077 | 0.220354456154077 | false | false | false | |||||||||||||||||
| d59c8e54-0d04-4f91-a238-d235c9f2a323 | 2026-09-21 11:01 | 2026-09-21 11:01 | 2026-09-21 11:01 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 6.3000 | 6.2000 | 6.6000 | 207.2800 | 11970.00 | 0.00 | 11970.00 | 19 | 6 | 856 | 129 | 6.63565891472868 | 0.220910107126769 | 0.220910107126769 | false | false | false | |||||||||||||||||
| 010cc2fa-1135-4863-94e5-27502d9f07e2 | 2026-09-21 12:52 | 2026-09-21 12:52 | 2026-09-21 12:52 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 6.0000 | 5.7000 | 6.3000 | 206.0000 | 15000.00 | 0.00 | 13200.00 | 25 | 7 | 1105 | 129 | 8.56589147286822 | 0.222799516033726 | 0.222799516033726 | false | false | false | |||||||||||||||||
| df42f723-c565-4307-aab6-4921b6b88fa3 | 2026-09-21 13:37 | 2026-09-21 13:37 | 2026-09-21 13:37 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 6.1000 | 6.1000 | 6.3000 | 207.0000 | 62220.00 | 0.00 | 62220.00 | 102 | 25 | 1250 | 129 | 9.68992248062015 | 0.218541028101507 | 0.218541028101507 | false | false | false | |||||||||||||||||
| 7feb953d-3749-4f73-8444-8165fae354df | 2026-09-22 09:55 | 2026-09-22 09:55 | 2026-09-22 09:55 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 7.2000 | 7.2000 | 7.5000 | 208.9300 | 288720.00 | 0.00 | 288720.00 | 401 | 24 | 463 | 1053 | 0.439696106362773 | 0.21901509193552 | 0.21901509193552 | false | false | false | |||||||||||||||||
| 3ebec828-3e22-4323-9451-e83222493e89 | 2026-09-22 10:10 | 2026-09-22 10:10 | 2026-09-22 10:10 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 7.6800 | 7.4000 | 7.7000 | 209.2000 | 13820.00 | 13820.00 | 0.00 | 18 | 5 | 567 | 1053 | 0.538461538461538 | 0.235729357025134 | 0.225199911428461 | false | false | false | |||||||||||||||||
| 8f6306aa-4f9a-4c1a-a634-9a60ef283575 | 2026-09-22 10:37 | 2026-09-22 10:37 | 2026-09-22 10:37 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 7.6900 | 7.3000 | 7.8000 | 209.3000 | 15375.00 | 15375.00 | 0.00 | 20 | 7 | 1013 | 1053 | 0.962013295346629 | 0.232026821335087 | 0.232026821335087 | false | false | false | |||||||||||||||||
| b07d7cd4-1422-4c7e-9238-46393e9e35f1 | 2026-09-28 11:30 | 2026-09-28 11:30 | 2026-09-28 11:30 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 7.1000 | 7.1000 | 7.6000 | 209.4700 | 39050.00 | 0.00 | 39050.00 | 55 | 8 | 57 | 742 | 0.0768194070080863 | 0.230118819549897 | 0.230118819549897 | false | false | false | |||||||||||||||||
| 008244d5-4174-44d5-b43e-9e45556a9119 | 2026-09-28 13:17 | 2026-09-28 13:17 | 2026-09-28 13:17 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 8.3000 | 8.3000 | 8.7000 | 210.9400 | 46480.00 | 0.00 | 46480.00 | 56 | 16 | 127 | 742 | 0.171159029649596 | 0.226747737259828 | 0.240158297259694 | true | false | false | |||||||||||||||||
| c1934492-47e6-46bc-98ea-9154bc1d1a7a | 2026-09-28 14:04 | 2026-09-28 14:04 | 2026-09-28 14:04 | IBB | IBB261016C00205000 | call | 205.0000 | 2026-10-16 | 7.9000 | 7.9000 | 8.3000 | 210.0000 | 39500.00 | 0.00 | 7900.00 | 50 | 5 | 177 | 742 | 0.238544474393531 | 0.226603343872883 | 0.226603343872883 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 10453744346.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:29:33.809340Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 10453744346.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:34:41.643622Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 10453744346.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:37:14.719915Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 10453744346.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:45:07.990945Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 10453744346.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:51:11.587541Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 10453744346.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:02:30.535242Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 10453744346.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:02:30.535242Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 10453744346.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 10453744346.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:39:31.841992Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 10546876021.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:56:25.927111Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 10546876021.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:11:50.316445Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 10546876021.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:38:45.745623Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 10636200884.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:32:36.194150Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 10636200884.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:19:28.127725Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 10636200884.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:10:39.755253Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |