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_alerts523,327 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 |
|---|
| 74bc582c-92c3-4a98-b9ad-a7398acfd694 | 2026-09-25 10:50 | 2026-09-25 10:50 | 2026-09-25 10:50 | SMH | SMH261016P00540000 | put | 540.0000 | 2026-10-16 | 2.7200 | 2.7200 | 2.8900 | 605.3148 | 54400.00 | 0.00 | 54400.00 | 200 | 15 | 655 | 10917 | 0.0599981679948704 | 0.389704106529936 | 0.389704106529936 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 74129314174.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T14:52:00.220874Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 32b0154e-5e16-4445-bb06-761e52eecb8d | 2026-09-24 11:16 | 2026-09-24 11:16 | 2026-09-24 11:16 | SMH | SMH261016P00540000 | put | 540.0000 | 2026-10-16 | 4.0500 | 3.6500 | 4.0500 | 591.8000 | 19035.00 | 19035.00 | 0.00 | 47 | 7 | 70 | 10692 | 0.00654695099139544 | 0.371716820891073 | 0.371716820891073 | false | false | false | true | false | |||||||||||||||
| 7dc12b27-b557-4537-a7f9-8ce8063d06d1 | 2026-09-21 11:15 | 2026-09-21 11:15 | 2026-09-21 11:15 | SMH | SMH261016P00540000 | put | 540.0000 | 2026-10-16 | 5.1000 | 5.0500 | 5.2000 | 590.8900 | 21930.00 | 6120.00 | 15810.00 | 43 | 5 | 409 | 10647 | 0.0384145768761153 | 0.374761792705264 | 0.374761792705264 | false | false | false | true | false | |||||||||||||||
| 434ed131-01e4-4766-8996-52fa9e3850fb | 2026-09-17 10:42 | 2026-09-17 10:42 | 2026-09-17 10:42 | SMH | SMH261016P00540000 | put | 540.0000 | 2026-10-16 | 11.5000 | 11.2000 | 11.5000 | 560.3300 | 1479855.00 | 1479855.00 | 0.00 | 1287 | 52 | 3101 | 8434 | 0.367678444391748 | 0.33484425473675 | 0.33484425473675 | false | false | false | true | false | |||||||||||||||
| 47e4719f-e108-4f42-aaad-e14f27f1c305 | 2026-09-17 10:02 | 2026-09-17 10:02 | 2026-09-17 10:02 | SMH | SMH261016P00540000 | put | 540.0000 | 2026-10-16 | 11.7500 | 10.9500 | 11.7500 | 559.6450 | 1798903.00 | 1798903.00 | 0.00 | 1531 | 56 | 1662 | 8434 | 0.197059520986483 | 0.335378935889108 | 0.335378935889108 | false | false | false | true | false | |||||||||||||||
| f54befe3-c299-498b-ae56-21d6127f32d4 | 2026-09-10 09:58 | 2026-09-10 09:58 | 2026-09-10 09:58 | SMH | SMH261016P00540000 | put | 540.0000 | 2026-10-16 | 16.2800 | 15.7000 | 16.3000 | 557.4500 | 133525.00 | 122220.00 | 11305.00 | 82 | 22 | 122 | 8250 | 0.0147878787878788 | 0.361804610754516 | 0.359504925120362 | true | false | false | true | false | |||||||||||||||
| 5c0c4e60-a9ee-466e-b3b4-b0293fc52269 | 2026-09-01 10:30 | 2026-09-01 10:30 | 2026-09-01 10:30 | SMH | SMH261016P00540000 | put | 540.0000 | 2026-10-16 | 21.8800 | 21.8000 | 22.6000 | 542.9300 | 111570.00 | 6570.00 | 105000.00 | 51 | 6 | 150 | 1715 | 0.0874635568513119 | 0.325790803109245 | 0.323367650972959 | true | false | false | true | false | |||||||||||||||
| 7c0fc77c-c0d9-4a32-a08a-2c2b00848bde | 2026-08-18 11:27 | 2026-08-18 11:27 | 2026-08-18 11:27 | SMH | SMH261016P00540000 | put | 540.0000 | 2026-10-16 | 23.5100 | 23.5000 | 24.1500 | 565.1800 | 968781.00 | 26290.00 | 942491.00 | 412 | 15 | 414 | 984 | 0.420731707317073 | 0.40759699631398 | 0.40759699631398 | true | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 74239177442.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:16:59.605616Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 74084243802.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:16:13.769524Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 66853944779.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:48:09.438351Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 66853944779.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:07:38.635762Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 69867717125.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:06:33.692120Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 66248124771.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 |
| — |
| 66248124771.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |