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 |
|---|
| 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 |
|---|
| e90f371e-a759-4330-86c7-58e0f1b954d2 | 2026-09-18 11:33 | 2026-09-18 11:33 | 2026-09-18 11:33 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 1.4000 | 1.4000 | 1.5000 | 202.4150 | 75740.00 | 0.00 | 75740.00 | 541 | 13 | 549 | 182 | 3.01648351648352 | 0.302420581940479 | 0.302420581940479 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 318165319433.00 | 2026-10-14 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 5ebcb9dc-c234-4c9f-a2dc-f654551c4b12 | 2026-09-22 09:43 | 2026-09-22 09:42 | 2026-09-22 09:42 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 0.6200 | 0.0100 | 0.6600 | 204.2200 | 24676.00 | 20026.00 | 4650.00 | 398 | 47 | 398 | 2908 | 0.136863823933975 | 0.384909606226289 | 0.384909606226289 | false | false | false | |||||||||||||||||
| 76ab5c91-f2fe-496e-9e0f-ca264dda04f1 | 2026-09-23 12:28 | 2026-09-23 12:28 | 2026-09-23 12:28 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 1.4100 | 1.4100 | 1.6500 | 198.9500 | 10011.00 | 0.00 | 10011.00 | 71 | 17 | 152 | 3422 | 0.0444184687317358 | 0.3539126873555 | 0.3539126873555 | false | false | false | |||||||||||||||||
| 7225db30-3f07-49a4-b39c-e61244649757 | 2026-09-24 09:51 | 2026-09-24 09:51 | 2026-09-24 09:51 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 2.4000 | 2.3000 | 2.4000 | 196.2299 | 11280.00 | 5520.00 | 0.00 | 47 | 6 | 107 | 3426 | 0.0312317571511967 | 0.41440820492809 | 0.41440820492809 | false | false | false | |||||||||||||||||
| 4e4e2ebe-0594-4dab-9c32-15a39bfc5369 | 2026-09-24 09:51 | 2026-09-24 09:51 | 2026-09-24 09:51 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 2.3700 | 2.2600 | 2.3700 | 196.1200 | 11850.00 | 11850.00 | 0.00 | 50 | 7 | 157 | 3426 | 0.045826036193812 | 0.389322196418011 | 0.389322196418011 | false | false | false | |||||||||||||||||
| 9883a671-4601-4719-872f-38fa2359c11e | 2026-09-24 09:52 | 2026-09-24 09:52 | 2026-09-24 09:52 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 2.2100 | 2.2000 | 2.3700 | 196.2900 | 11050.00 | 10387.00 | 663.00 | 50 | 9 | 421 | 3426 | 0.122883829538821 | 0.375451897328222 | 0.375451897328222 | false | false | false | |||||||||||||||||
| 5b836c43-ad4d-49cb-ada1-632cba33546d | 2026-09-24 09:52 | 2026-09-24 09:52 | 2026-09-24 09:52 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 2.2100 | 2.1000 | 2.2900 | 196.2900 | 11050.00 | 9061.00 | 1989.00 | 50 | 7 | 271 | 3426 | 0.0791009924109749 | 0.375451897328222 | 0.375451897328222 | false | false | false | |||||||||||||||||
| 522ec2be-7f0e-4d49-8283-4cdad22da0ee | 2026-09-24 09:52 | 2026-09-24 09:52 | 2026-09-24 09:52 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 2.2100 | 2.2000 | 2.2100 | 196.2900 | 11050.00 | 7735.00 | 0.00 | 50 | 7 | 371 | 3426 | 0.108289550496205 | 0.375451897328222 | 0.375451897328222 | false | false | false | |||||||||||||||||
| 44028549-8149-44f1-a0ed-3b745e9dd4b9 | 2026-09-24 09:52 | 2026-09-24 09:52 | 2026-09-24 09:52 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 2.2100 | 2.2000 | 2.3700 | 196.2900 | 11050.00 | 3315.00 | 663.00 | 50 | 7 | 321 | 3426 | 0.0936952714535902 | 0.375451897328222 | 0.375451897328222 | false | false | false | |||||||||||||||||
| f0f25dfc-f37e-4a67-ad77-6a7ce1f73dfd | 2026-09-24 09:52 | 2026-09-24 09:52 | 2026-09-24 09:52 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 2.2100 | 2.2000 | 2.3700 | 196.2900 | 11050.00 | 10387.00 | 663.00 | 50 | 7 | 571 | 3426 | 0.166666666666667 | 0.375451897328222 | 0.375451897328222 | false | false | false | |||||||||||||||||
| c379fef4-5b01-45b9-8775-9a7c82a2711f | 2026-09-24 09:52 | 2026-09-24 09:52 | 2026-09-24 09:52 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 2.2100 | 2.2000 | 2.3700 | 196.2900 | 11050.00 | 7956.00 | 3094.00 | 50 | 8 | 671 | 3426 | 0.195855224751897 | 0.375451897328222 | 0.375451897328222 | false | false | false | |||||||||||||||||
| 65300377-cbed-44c8-a427-7b2c69673b3b | 2026-09-24 09:52 | 2026-09-24 09:52 | 2026-09-24 09:52 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 2.2100 | 2.2000 | 2.3700 | 196.2900 | 11050.00 | 9503.00 | 1547.00 | 50 | 9 | 621 | 3426 | 0.181260945709282 | 0.375451897328222 | 0.375451897328222 | false | false | false | |||||||||||||||||
| 4e3327e9-e7b4-48b9-9197-c26d0f69ac58 | 2026-09-24 09:52 | 2026-09-24 09:52 | 2026-09-24 09:52 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 2.2100 | 2.2000 | 2.3700 | 196.2900 | 11050.00 | 10387.00 | 663.00 | 50 | 8 | 471 | 3426 | 0.137478108581436 | 0.375451897328222 | 0.375451897328222 | false | false | false | |||||||||||||||||
| 319519a2-8753-427c-a42c-580447ab1f3f | 2026-09-24 09:52 | 2026-09-24 09:52 | 2026-09-24 09:52 | MS | MS260925P00197500 | put | 197.5000 | 2026-09-25 | 2.2100 | 2.2000 | 2.3700 | 196.2900 | 11050.00 | 10387.00 | 663.00 | 50 | 9 | 521 | 3426 | 0.152072387624051 | 0.375451897328222 | 0.375451897328222 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 314395960333.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:43:21.956551Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 311584646670.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:31:43.812748Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 311584646670.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 311584646670.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 311584646670.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 311584646670.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 311584646670.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 311584646670.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 311584646670.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 311584646670.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 311584646670.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 311584646670.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 311584646670.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |