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_alerts609,118 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 |
|---|
| 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 |
|---|
| cf034eba-c42c-4108-87a5-925fb8f2616c | 2026-09-09 10:41 | 2026-09-09 10:41 | 2026-09-09 10:41 | PYPL | PYPL261016P00052500 | put | 52.5000 | 2026-10-16 | 1.9400 | 1.9300 | 1.9800 | 53.0500 | 14550.00 | 4656.00 | 9894.00 | 75 | 11 | 134 | 4395 | 0.0304891922639363 | 0.343815103962211 | 0.343815103962211 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 46220551022.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:59:53.339088Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7ad1dd02-3d4e-465d-8877-25859deafce5 | 2026-09-09 15:42 | 2026-09-09 15:42 | 2026-09-09 15:42 | PYPL | PYPL261016P00052500 | put | 52.5000 | 2026-10-16 | 2.4700 | 2.2900 | 2.4700 | 52.3750 | 35568.00 | 35568.00 | 0.00 | 144 | 23 | 459 | 4395 | 0.104436860068259 | 0.377993322116673 | 0.377993322116673 | true | false | false | |||||||||||||||||
| 6eb33fbe-2a62-4ef8-89c4-1d32f66b63de | 2026-09-10 15:32 | 2026-09-10 15:32 | 2026-09-10 15:32 | PYPL | PYPL261016P00052500 | put | 52.5000 | 2026-10-16 | 1.7800 | 1.7100 | 1.7900 | 53.1750 | 10153.00 | 1253.00 | 8900.00 | 57 | 8 | 546 | 4922 | 0.110930516050386 | 0.333313761904388 | 0.331778771836298 | false | false | false | |||||||||||||||||
| eab1c5c1-4ab1-4b69-b35d-82e5fd32cdc5 | 2026-09-10 15:32 | 2026-09-10 15:32 | 2026-09-10 15:32 | PYPL | PYPL261016P00052500 | put | 52.5000 | 2026-10-16 | 1.7800 | 1.7200 | 1.8200 | 53.1914 | 14774.00 | 6942.00 | 7832.00 | 83 | 6 | 806 | 4922 | 0.163754571312475 | 0.332825132106705 | 0.332825132106705 | false | false | false | |||||||||||||||||
| a0bc8ffe-6c84-47e8-bad1-fea10084bd88 | 2026-09-14 12:02 | 2026-09-14 12:02 | 2026-09-14 12:02 | PYPL | PYPL261016P00052500 | put | 52.5000 | 2026-10-16 | 1.3200 | 1.3200 | 1.4100 | 54.1100 | 29568.00 | 0.00 | 29568.00 | 224 | 29 | 241 | 6294 | 0.0382904353352399 | 0.33375254204311 | 0.33375254204311 | false | false | false | |||||||||||||||||
| 02e612b5-5fc3-453f-8b3f-b567708e3b65 | 2026-09-16 10:40 | 2026-09-16 10:40 | 2026-09-16 10:40 | PYPL | PYPL261016P00052500 | put | 52.5000 | 2026-10-16 | 1.4500 | 1.4500 | 1.5900 | 53.3900 | 16240.00 | 0.00 | 16240.00 | 112 | 23 | 140 | 6752 | 0.0207345971563981 | 0.319957256720441 | 0.319957256720441 | false | false | false | |||||||||||||||||
| 5ecd7749-5323-4494-87ee-0de2bfbcefa8 | 2026-09-18 11:45 | 2026-09-18 11:45 | 2026-09-18 11:45 | PYPL | PYPL261016P00052500 | put | 52.5000 | 2026-10-16 | 1.5600 | 1.5500 | 1.6300 | 52.7300 | 12947.00 | 5148.00 | 7019.00 | 83 | 7 | 166 | 7045 | 0.0235628105039035 | 0.301200229180258 | 0.301200229180258 | false | false | false | |||||||||||||||||
| f2f3c307-d0db-4db6-a5e6-f57357f2f87e | 2026-09-18 12:21 | 2026-09-18 12:21 | 2026-09-18 12:21 | PYPL | PYPL261016P00052500 | put | 52.5000 | 2026-10-16 | 1.5300 | 1.4700 | 1.6000 | 52.0000 | 20056.00 | 11794.00 | 8262.00 | 131 | 15 | 360 | 7045 | 0.0511000709723208 | 0.296014610282849 | 0.296014610282849 | true | false | false | |||||||||||||||||
| b67e0291-ee88-446e-9e6b-5b635dc4a233 | 2026-09-21 11:59 | 2026-09-21 11:59 | 2026-09-21 11:59 | PYPL | PYPL261016P00052500 | put | 52.5000 | 2026-10-16 | 1.4900 | 1.4300 | 1.5100 | 52.6300 | 10132.00 | 5364.00 | 4768.00 | 68 | 8 | 578 | 7264 | 0.0795704845814978 | 0.296135667505467 | 0.296135667505467 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 46220551022.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:53:17.072904Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 46220551022.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 46220551022.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 46220551022.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 45091342669.00 |
| 2026-10-27 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 44834704406.00 |
| 2026-10-27 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 44834704406.00 |
| 2026-10-27 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:25:30.671610Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 45014351190.00 |
| 2026-10-27 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:00:04.115943Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |