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 | 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 |
|---|
| d52089a0-9457-42de-8a35-b72cdfbb02d0 | 2026-08-18 10:11 | 2026-08-18 10:11 | 2026-08-18 10:11 | SOXL | SOXL261002P00100000 | put | 100.0000 | 2026-10-02 | 10.0000 | 9.5000 | 10.5500 | 127.6200 | 15000.00 | 14000.00 | 1000.00 | 15 | 6 | 65 | 349 | 0.186246418338109 | 1.34846691798166 | 1.34826510517371 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 17090976068.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 |
| b9953422-2b28-4694-85d3-1615efa46583 | 2026-08-27 15:44 | 2026-08-27 15:44 | 2026-08-27 15:44 | SOXL | SOXL261002P00100000 | put | 100.0000 | 2026-10-02 | 8.0900 | 8.0500 | 8.3000 | 120.8400 | 16180.00 | 12944.00 | 3236.00 | 20 | 5 | 249 | 835 | 0.298203592814371 | 1.21171183108825 | 1.21171183108825 | false | false | false | true | ||||||||||||||||
| 513a6959-0a40-4b95-9f9d-535c81414fd4 | 2026-08-28 12:01 | 2026-08-28 12:00 | 2026-08-28 12:00 | SOXL | SOXL261002P00100000 | put | 100.0000 | 2026-10-02 | 10.0000 | 9.3000 | 10.1000 | 111.0000 | 11004.00 | 9999.00 | 1005.00 | 11 | 10 | 85 | 909 | 0.0935093509350935 | 1.1803812983899 | 1.18296811599151 | true | false | false | true | ||||||||||||||||
| f6de36de-bcc1-4f35-bf91-e362c0f1c6cf | 2026-09-01 10:30 | 2026-09-01 10:30 | 2026-09-01 10:30 | SOXL | SOXL261002P00100000 | put | 100.0000 | 2026-10-02 | 11.2000 | 11.1000 | 11.4000 | 102.7800 | 56000.00 | 0.00 | 56000.00 | 50 | 6 | 152 | 939 | 0.161874334398296 | 1.08317005505772 | 1.08317005505772 | true | false | false | true | ||||||||||||||||
| 15b6204d-935f-4c2d-a2a8-42eac7899548 | 2026-09-14 10:04 | 2026-09-14 10:04 | 2026-09-14 10:04 | SOXL | SOXL261002P00100000 | put | 100.0000 | 2026-10-02 | 9.3100 | 9.2000 | 9.9000 | 102.8200 | 93991.00 | 90225.00 | 3766.00 | 101 | 75 | 237 | 1177 | 0.201359388275276 | 1.20015551702449 | 1.21712434509743 | true | false | false | true | ||||||||||||||||
| 9ac618fe-a00e-45ab-a3f4-140bfa5eff64 | 2026-09-18 12:29 | 2026-09-18 12:29 | 2026-09-18 12:29 | SOXL | SOXL261002P00100000 | put | 100.0000 | 2026-10-02 | 3.1500 | 3.0000 | 3.3500 | 116.9750 | 13563.00 | 13563.00 | 0.00 | 43 | 43 | 510 | 1825 | 0.279452054794521 | 1.10403242130861 | 1.10403242130861 | false | false | false | true | ||||||||||||||||
| c10b145a-8275-4e9a-8ff3-79e077260da0 | 2026-09-21 11:05 | 2026-09-21 11:05 | 2026-09-21 11:05 | SOXL | SOXL261002P00100000 | put | 100.0000 | 2026-10-02 | 1.0000 | 1.0000 | 1.1500 | 138.4450 | 32300.00 | 0.00 | 32300.00 | 323 | 7 | 1504 | 1909 | 0.787847040335254 | 1.34314466202163 | 1.34314466202163 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 17090976068.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:52:49.177007Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 17090976068.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 17090976068.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 20605860309.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:14:09.812180Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 20173880889.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:45:45.480252Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 21580422420.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:05:23.809831Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |