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_alerts658,639 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 |
|---|
| 1758278f-b7d7-4a17-8f4e-15d7dcd11033 | 2026-08-19 10:11 | 2026-08-19 10:11 | 2026-08-19 10:11 | SMH | SMH260821C00562500 | call | 562.5000 | 2026-08-21 | 5.4000 | 4.9500 | 5.5000 | 556.6250 | 269963.00 | 269418.00 | 0.00 | 500 | 13 | 1005 | 226 | 4.44690265486726 | 0.484315417287142 | 0.481160576668071 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 66248124771.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4cea4cae-c29e-40f1-9d0e-32aed62225a4 | 2026-08-20 09:58 | 2026-08-20 09:57 | 2026-08-20 09:57 | SMH | SMH260821C00562500 | call | 562.5000 | 2026-08-21 | 4.0500 | 3.8000 | 4.3000 | 558.8600 | 404595.00 | 1620.00 | 402570.00 | 999 | 16 | 2168 | 2184 | 0.992673992673993 | 0.483608108743469 | 0.483608108743469 | false | false | false | true | ||||||||||||||||
| e2871ec5-456e-46bb-8dcc-d6a5f5b46836 | 2026-08-20 11:01 | 2026-08-20 11:01 | 2026-08-20 11:01 | SMH | SMH260821C00562500 | call | 562.5000 | 2026-08-21 | 7.0000 | 5.7500 | 7.0000 | 565.4600 | 105000.00 | 105000.00 | 0.00 | 150 | 5 | 2463 | 2184 | 1.12774725274725 | 0.454843552919486 | 0.454843552919486 | true | false | false | true | ||||||||||||||||
| ab387392-1a69-4e3f-aba3-6611266fc4c1 | 2026-08-20 13:30 | 2026-08-20 13:30 | 2026-08-20 13:30 | SMH | SMH260821C00562500 | call | 562.5000 | 2026-08-21 | 3.6000 | 3.6000 | 4.0000 | 560.2700 | 180000.00 | 0.00 | 180000.00 | 500 | 6 | 3245 | 2184 | 1.48580586080586 | 0.392830076344148 | 0.392830076344148 | true | false | false | true | ||||||||||||||||
| 75684fda-ccab-4218-b98d-75a0c7c1a3c3 | 2026-08-20 14:05 | 2026-08-20 14:05 | 2026-08-20 14:05 | SMH | SMH260821C00562500 | call | 562.5000 | 2026-08-21 | 3.4000 | 3.4000 | 3.6000 | 560.0550 | 87380.00 | 0.00 | 87380.00 | 257 | 10 | 3507 | 2184 | 1.60576923076923 | 0.3833696213795 | 0.3833696213795 | true | false | false | true | ||||||||||||||||
| 1e21defb-c2ee-48d4-81d3-d690d8e7de74 | 2026-08-21 09:31 | 2026-08-21 09:31 | 2026-08-21 09:31 | SMH | SMH260821C00562500 | call | 562.5000 | 2026-08-21 | 7.5000 | 6.8000 | 7.5000 | 568.7900 | 76500.00 | 76500.00 | 0.00 | 102 | 8 | 103 | 4288 | 0.0240205223880597 | 0.570098893529972 | 0.566051532921027 | true | false | false | true | ||||||||||||||||
| 1b2d8f74-4816-4e44-8882-e80a327247a9 | 2026-08-21 09:41 | 2026-08-21 09:41 | 2026-08-21 09:41 | SMH | SMH260821C00562500 | call | 562.5000 | 2026-08-21 | 4.5000 | 3.9500 | 4.5000 | 564.8000 | 135000.00 | 135000.00 | 0.00 | 300 | 7 | 603 | 4288 | 0.140625 | 0.531886268762061 | 0.531886268762061 | true | false | false | true | ||||||||||||||||
| 8ad470b4-03f6-4962-8a28-0920e560e30d | 2026-08-21 09:47 | 2026-08-21 09:47 | 2026-08-21 09:47 | SMH | SMH260821C00562500 | call | 562.5000 | 2026-08-21 | 5.0000 | 4.2500 | 5.0000 | 565.8050 | 150000.00 | 150000.00 | 0.00 | 300 | 9 | 906 | 4288 | 0.211287313432836 | 0.510055768285779 | 0.510055768285779 | true | false | false | true | ||||||||||||||||
| 774e6a15-d507-42bf-9418-b48b380cffe3 | 2026-08-21 09:53 | 2026-08-21 09:53 | 2026-08-21 09:53 | SMH | SMH260821C00562500 | call | 562.5000 | 2026-08-21 | 3.3000 | 2.6000 | 3.3000 | 562.5800 | 165000.00 | 41250.00 | 0.00 | 500 | 5 | 1407 | 4288 | 0.328125 | 0.549059721546138 | 0.549059721546138 | true | false | false | true | ||||||||||||||||
| b2d25cb9-0fc5-4a7a-9987-070a81d75c32 | 2026-08-21 10:15 | 2026-08-21 10:15 | 2026-08-21 10:15 | SMH | SMH260821C00562500 | call | 562.5000 | 2026-08-21 | 1.1000 | 1.1000 | 1.3000 | 557.6500 | 55000.00 | 0.00 | 55000.00 | 500 | 8 | 3562 | 4288 | 0.830690298507463 | 0.506380545046045 | 0.506380545046045 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 66248124771.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 66248124771.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 66248124771.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 66248124771.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 66248124771.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 66248124771.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 66248124771.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 66248124771.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 66248124771.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |