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 |
|---|
| 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 |
|---|
| f30e61ab-e9c8-41c1-b556-3fc2aecd39e9 | 2026-09-24 10:02 | 2026-09-24 10:02 | 2026-09-24 10:02 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 1.3500 | 1.3400 | 1.3600 | 765.7050 | 13519.00 | 13519.00 | 0.00 | 100 | 13 | 5212 | 4611 | 1.13034049013229 | 0.156691302978361 | 0.157382733307689 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 803942864100.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T14:04:09.722188Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 57299c2e-e503-49e6-a5af-f10fb42c96ff | 2026-09-24 10:55 | 2026-09-24 10:55 | 2026-09-24 10:55 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 1.5700 | 1.5600 | 1.5800 | 764.8800 | 39727.00 | 30363.00 | 9364.00 | 253 | 26 | 13200 | 4611 | 2.86271958360442 | 0.152094954687457 | 0.152769985432288 | true | false | false | |||||||||||||||||
| 0a0fa7cb-9623-4c80-9c28-889f7ecb7937 | 2026-09-24 10:55 | 2026-09-24 10:55 | 2026-09-24 10:55 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 1.5900 | 1.5800 | 1.5900 | 764.8600 | 27340.00 | 26076.00 | 1264.00 | 172 | 22 | 13742 | 4611 | 2.98026458468879 | 0.152277881201948 | 0.152937415992939 | true | false | false | |||||||||||||||||
| 8aa49af4-63a9-4244-a9bd-b8d9feb35d18 | 2026-09-24 10:58 | 2026-09-24 10:58 | 2026-09-24 10:58 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 1.7500 | 1.7400 | 1.7700 | 764.4100 | 21016.00 | 20489.00 | 527.00 | 120 | 9 | 15530 | 4611 | 3.36803296464975 | 0.152776267340584 | 0.152645279028495 | false | false | false | |||||||||||||||||
| 1e0e899e-004f-4090-ad40-38cd982b726a | 2026-09-24 11:18 | 2026-09-24 11:18 | 2026-09-24 11:18 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 2.0400 | 2.0400 | 2.0500 | 763.7600 | 21425.00 | 1025.00 | 20400.00 | 105 | 13 | 22189 | 4611 | 4.81218824549989 | 0.152984610717704 | 0.153617955206316 | false | false | false | |||||||||||||||||
| 813934df-533e-478a-8331-8ff200cb38a8 | 2026-09-24 11:32 | 2026-09-24 11:32 | 2026-09-24 11:32 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 2.1600 | 2.1400 | 2.1700 | 763.4600 | 10163.00 | 9949.00 | 214.00 | 47 | 6 | 26098 | 4611 | 5.65994361309911 | 0.151085632881083 | 0.152608107608691 | false | false | false | |||||||||||||||||
| b08bd9c3-0471-4182-b3ad-f0948f70bcb3 | 2026-09-24 11:39 | 2026-09-24 11:39 | 2026-09-24 11:39 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 2.0900 | 2.0800 | 2.1000 | 763.5680 | 23852.00 | 23852.00 | 0.00 | 114 | 5 | 29141 | 4611 | 6.31988722619822 | 0.150690463575782 | 0.151321579588779 | false | false | false | |||||||||||||||||
| 3d2dd447-40f3-4ee1-9901-9f5b33ae449f | 2026-09-25 10:05 | 2026-09-25 10:05 | 2026-09-25 10:05 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 0.3400 | 0.3300 | 0.3400 | 767.0000 | 15333.00 | 15300.00 | 33.00 | 451 | 11 | 41929 | 9457 | 4.43364703394311 | 0.212627420609469 | 0.214767796146781 | false | false | false | |||||||||||||||||
| 447f6664-1263-4e2f-991d-259dcba1cf19 | 2026-09-25 10:06 | 2026-09-25 10:06 | 2026-09-25 10:06 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 0.5400 | 0.5300 | 0.5400 | 766.6800 | 18072.00 | 17118.00 | 954.00 | 335 | 20 | 46257 | 9457 | 4.89129745162314 | 0.228141162992469 | 0.230267650489585 | true | false | false | |||||||||||||||||
| 02a43f9c-4e0c-486f-b9d3-8c787639ed34 | 2026-09-25 10:15 | 2026-09-25 10:15 | 2026-09-25 10:15 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 0.5300 | 0.5200 | 0.5400 | 766.5400 | 12451.00 | 6101.00 | 6350.00 | 233 | 20 | 60380 | 9457 | 6.38468859046209 | 0.224120733288153 | 0.226357531178332 | false | false | false | |||||||||||||||||
| 9e6c62b0-a12a-4ced-9e14-0efb574f60d3 | 2026-09-25 10:35 | 2026-09-25 10:35 | 2026-09-25 10:35 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 0.2200 | 0.2100 | 0.2300 | 767.9450 | 21250.00 | 374.00 | 20810.00 | 966 | 19 | 88370 | 9457 | 9.34440097282436 | 0.211464282427186 | 0.214266930214361 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:56:01.849843Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:56:01.849843Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:58:33.796895Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:21:44.336640Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:45:14.547721Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:05:23.720155Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:06:13.706447Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:15:34.282180Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:37:32.022295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |