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_alerts474,253 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 | price |
|---|
| 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 |
|---|
| 8f488a6a-6867-4db4-99f8-705d7f0cb1e3 | 2026-09-21 15:06 | 2026-09-21 15:06 | 2026-09-21 15:06 | BLSH | BLSH270115C00035000 | call | 35.0000 | 2027-01-15 | 9.3000 | 9.3000 | 9.4500 | 39.9700 | 11160.00 | 0.00 | 11160.00 | 12 | 5 | 127 | 599 | 0.212020033388982 | 0.747498827423128 | 0.747498827423128 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 6054473388.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 1f6aed66-fe50-499d-9f30-ad09e49f7aa1 | 2026-09-21 15:09 | 2026-09-21 15:09 | 2026-09-21 15:09 | BLSH | BLSH270115C00035000 | call | 35.0000 | 2027-01-15 | 9.3000 | 9.2000 | 9.4500 | 39.9700 | 56730.00 | 0.00 | 56730.00 | 61 | 5 | 193 | 599 | 0.32220367278798 | 0.74518548466554 | 0.747498827423128 | false | false | false | true | false | |||||||||||||||
| c5b5f02b-b146-41ec-a78c-db91cad3179d | 2026-09-21 15:10 | 2026-09-21 15:10 | 2026-09-21 15:10 | BLSH | BLSH270115C00035000 | call | 35.0000 | 2027-01-15 | 9.3000 | 9.3000 | 9.4000 | 39.9900 | 27900.00 | 0.00 | 27900.00 | 30 | 6 | 226 | 599 | 0.377295492487479 | 0.745648405578102 | 0.745648405578102 | false | false | false | true | false | |||||||||||||||
| 160af47f-ef30-48d0-96ac-b76905b2a25b | 2026-09-21 15:10 | 2026-09-21 15:10 | 2026-09-21 15:10 | BLSH | BLSH270115C00035000 | call | 35.0000 | 2027-01-15 | 9.3000 | 9.1500 | 9.4000 | 39.9600 | 46500.00 | 23250.00 | 930.00 | 50 | 11 | 276 | 599 | 0.460767946577629 | 0.748423286493355 | 0.748423286493355 | true | false | false | true | false | |||||||||||||||
| 329293ba-29f7-4a56-bd35-9e28e4599d3a | 2026-09-21 15:10 | 2026-09-21 15:10 | 2026-09-21 15:10 | BLSH | BLSH270115C00035000 | call | 35.0000 | 2027-01-15 | 9.3000 | 9.1500 | 9.4000 | 39.9600 | 39060.00 | 7440.00 | 31620.00 | 42 | 5 | 358 | 599 | 0.597662771285476 | 0.748423286493355 | 0.748423286493355 | false | false | false | true | false | |||||||||||||||
| 088fead0-ac6b-43c3-ac49-6bf2f85056e0 | 2026-09-21 15:10 | 2026-09-21 15:10 | 2026-09-21 15:10 | BLSH | BLSH270115C00035000 | call | 35.0000 | 2027-01-15 | 9.3000 | 9.3000 | 9.4000 | 39.9550 | 27900.00 | 0.00 | 17670.00 | 30 | 6 | 412 | 599 | 0.687813021702838 | 0.748885329364714 | 0.748885329364714 | false | false | false | true | false | |||||||||||||||
| 6fe73c31-36ed-4384-9ee9-e93111f00606 | 2026-09-22 11:44 | 2026-09-22 11:44 | 2026-09-22 11:44 | BLSH | BLSH260925C00037500 | call | 37.5000 | 2026-09-25 | 3.9000 | 3.6500 | 3.9000 | 41.1400 | 57330.00 | 57330.00 | 0.00 | 147 | 7 | 250 | 252 | 0.992063492063492 | 0.957836939257268 | 0.957836939257268 | false | false | false | true | false | |||||||||||||||
| 6f56c00c-ee60-42be-8814-9c598cb247f0 | 2026-09-22 11:48 | 2026-09-22 11:48 | 2026-09-22 11:48 | BLSH | BLSH280121C00055000 | call | 55.0000 | 2028-01-21 | 10.4500 | 10.4500 | 11.5500 | 40.6300 | 433695.00 | 1060.00 | 432635.00 | 415 | 14 | 415 | 196 | 2.11734693877551 | 0.747607938764468 | 0.755727973615509 | false | false | false | true | false | |||||||||||||||
| 60b26c1c-2bc4-4b18-bed3-1e67a156c460 | 2026-09-22 13:29 | 2026-09-22 13:29 | 2026-09-22 13:29 | BLSH | BLSH261009P00043000 | put | 43.0000 | 2026-10-09 | 4.0500 | 3.8500 | 4.0500 | 40.5600 | 37665.00 | 37665.00 | 0.00 | 93 | 11 | 93 | 0 | 0 | 0.754414078267733 | 0.754414078267733 | false | false | false | true | false | |||||||||||||||
| 1a2edc89-78a6-47e9-b0bf-810fee2fde59 | 2026-09-23 12:08 | 2026-09-23 12:08 | 2026-09-23 12:08 | BLSH | BLSH261120P00035000 | put | 35.0000 | 2026-11-20 | 2.3700 | 2.2400 | 2.5000 | 40.1750 | 260463.00 | 237.00 | 260226.00 | 1099 | 26 | 1123 | 9 | 124.777777777778 | 0.771579137296896 | 0.771579137296896 | false | false | false | true | false | |||||||||||||||
| ffaade84-2b86-4f9d-831b-5b40cd62eda6 | 2026-09-23 12:32 | 2026-09-23 12:32 | 2026-09-23 12:32 | BLSH | BLSH270115C00050000 | call | 50.0000 | 2027-01-15 | 3.8000 | 3.5500 | 3.8500 | 40.3200 | 38000.00 | 19000.00 | 19000.00 | 100 | 6 | 258 | 2199 | 0.117326057298772 | 0.75585366539756 | 0.75426195553759 | false | false | false | true | false | |||||||||||||||
| 763692d1-2f9c-406e-b8d7-2b73d9cfdaf4 | 2026-09-23 13:54 | 2026-09-23 13:54 | 2026-09-23 13:54 | BLSH | BLSH261002P00037000 | put | 37.0000 | 2026-10-02 | 0.7100 | 0.7000 | 0.7700 | 40.0650 | 37488.00 | 0.00 | 33938.00 | 528 | 33 | 552 | 16 | 34.5 | 0.773695702244445 | 0.773695702244445 | false | false | false | true | false | |||||||||||||||
| 2db67d48-681c-4564-8c49-be205a621c14 | 2026-09-24 11:21 | 2026-09-24 11:21 | 2026-09-24 11:21 | BLSH | BLSH261016C00040000 | call | 40.0000 | 2026-10-16 | 2.4000 | 2.2900 | 2.7700 | 39.1700 | 17530.00 | 3120.00 | 8650.00 | 73 | 13 | 76 | 1059 | 0.0717658168083097 | 0.710156898499628 | 0.711441119230871 | true | false | false | true | false | |||||||||||||||
| 6f77c22b-5a7b-4012-8ed5-dc96f58400cb | 2026-09-24 11:21 | 2026-09-24 11:21 | 2026-09-24 11:21 | BLSH | BLSH261016C00040000 | call | 40.0000 | 2026-10-16 | 2.3500 | 2.3500 | 2.5800 | 39.0000 | 42382.00 | 3308.00 | 37429.00 | 180 | 21 | 328 | 1059 | 0.309726156751652 | 0.70862114058298 | 0.70862114058298 | true | false | false | true | false | |||||||||||||||
| 9484b487-f77b-49d4-bb95-d99348194712 | 2026-09-24 13:56 | 2026-09-24 13:56 | 2026-09-24 13:56 | BLSH | BLSH270115P00030000 | put | 30.0000 | 2027-01-15 | 2.0300 | 2.0300 | 2.1500 | 39.3550 | 116725.00 | 0.00 | 116725.00 | 575 | 28 | 578 | 221 | 2.61538461538462 | 0.74294613482093 | 0.74294613482093 | false | false | false | true | false | |||||||||||||||
| 18b7333e-55a6-4779-a0af-46806e65ff0a | 2026-09-25 15:57 | 2026-09-25 15:57 | 2026-09-25 15:57 | BLSH | BLSH261002C00040000 | call | 40.0000 | 2026-10-02 | 0.6500 | 0.2800 | 0.6500 | 37.6550 | 10595.00 | 10595.00 | 0.00 | 163 | 7 | 173 | 103 | 1.67961165048544 | 0.717792408056174 | 0.717792408056174 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6054473388.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6054473388.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6054473388.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6054473388.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6054473388.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6138940381.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:49:01.734970Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 6138940381.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:49:01.734970Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6138940381.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:30:55.056187Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6049948371.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:13:15.432740Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6049948371.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:39:09.093031Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6049948371.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:55:17.981841Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6049948371.00 |
| 2026-11-18 |
| unknown |
| — |
| 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 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 6049948371.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:25:28.380196Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6049948371.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:01:57.698805Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5668338563.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:58:21.779683Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |