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 | expiry |
|---|
| 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 |
|---|
| 324d700b-8cf4-4bad-ba68-9060a86691a6 | 2026-09-02 15:57 | 2026-09-02 15:57 | 2026-09-02 15:57 | CRML | CRML270219C00012500 | call | 12.5000 | 2027-02-19 | 0.7500 | 0.6000 | 0.8000 | 7.2600 | 78075.00 | 24075.00 | 54000.00 | 1041 | 8 | 4693 | 5656 | 0.829738330975955 | 0.977435772950079 | 0.977435772950079 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 677737030.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dd098504-199a-4b8a-b005-ef3823af4440 | 2026-09-02 15:57 | 2026-09-02 15:56 | 2026-09-02 15:56 | CRML | CRML270219C00012500 | call | 12.5000 | 2027-02-19 | 0.7500 | 0.6000 | 0.8000 | 7.2285 | 71625.00 | 1350.00 | 70275.00 | 955 | 10 | 3652 | 5656 | 0.645685997171146 | 0.983191887127105 | 0.983191887127105 | false | false | false | true | ||||||||||||||||
| 6e973169-a75b-48cc-beb8-0d723e657449 | 2026-09-02 15:57 | 2026-09-02 15:56 | 2026-09-02 15:56 | CRML | CRML270219C00012500 | call | 12.5000 | 2027-02-19 | 0.7500 | 0.6000 | 0.8000 | 7.2400 | 67650.00 | 28500.00 | 39150.00 | 902 | 12 | 2697 | 5656 | 0.476838755304102 | 0.978347750690946 | 0.981087507358799 | false | false | false | true | ||||||||||||||||
| f0b40e38-c1a3-4639-a3fd-aa0b47312b42 | 2026-09-02 15:25 | 2026-09-02 15:25 | 2026-09-02 15:25 | CRML | CRML270219C00012500 | call | 12.5000 | 2027-02-19 | 0.7500 | 0.7500 | 0.8000 | 7.2550 | 74700.00 | 0.00 | 74700.00 | 996 | 6 | 1795 | 5656 | 0.317362093352192 | 0.978347750690946 | 0.978347750690946 | false | false | false | true | ||||||||||||||||
| 610217ce-7b8f-405a-983b-3450c8700e85 | 2026-09-02 15:14 | 2026-09-02 15:14 | 2026-09-02 15:14 | CRML | CRML270219C00012500 | call | 12.5000 | 2027-02-19 | 0.7500 | 0.6500 | 0.8000 | 7.3699 | 49125.00 | 26625.00 | 22500.00 | 655 | 6 | 685 | 5656 | 0.121110325318246 | 0.957548798189816 | 0.957548798189816 | false | false | false | true | ||||||||||||||||
| cf3d667a-af9f-4384-8af1-9c224231d43a | 2026-08-25 10:32 | 2026-08-25 10:32 | 2026-08-25 10:32 | CRML | CRML270219C00012500 | call | 12.5000 | 2027-02-19 | 1.0000 | 0.9000 | 1.1000 | 7.8000 | 79400.00 | 65900.00 | 13500.00 | 794 | 10 | 5609 | 137 | 40.9416058394161 | 0.985490629719154 | 0.985490629719154 | false | false | false | true | ||||||||||||||||
| b8e14d1e-df46-4829-b0f6-487296f4bb0c | 2026-08-25 09:52 | 2026-08-25 09:52 | 2026-08-25 09:52 | CRML | CRML270219C00012500 | call | 12.5000 | 2027-02-19 | 1.0000 | 0.9500 | 1.0500 | 7.7300 | 74500.00 | 59700.00 | 0.00 | 745 | 7 | 4575 | 137 | 33.3941605839416 | 0.998305786927017 | 0.998305786927017 | false | false | false | true | ||||||||||||||||
| 105ea0db-24df-4a41-b40f-9ba8da025bf7 | 2026-08-25 09:52 | 2026-08-25 09:52 | 2026-08-25 09:52 | CRML | CRML270219C00012500 | call | 12.5000 | 2027-02-19 | 1.0000 | 0.9500 | 1.0500 | 7.7350 | 101900.00 | 57900.00 | 20900.00 | 1019 | 12 | 3829 | 137 | 27.9489051094891 | 0.996486331632373 | 0.997386578385393 | true | false | false | true | ||||||||||||||||
| dee89a39-268e-4862-994b-d262c8bb23b2 | 2026-08-25 09:50 | 2026-08-25 09:49 | 2026-08-25 09:49 | CRML | CRML270219C00012500 | call | 12.5000 | 2027-02-19 | 1.0000 | 0.9000 | 1.0000 | 7.7342 | 59700.00 | 59700.00 | 0.00 | 597 | 7 | 1632 | 137 | 11.9124087591241 | 0.997533611714627 | 0.997533611714627 | false | false | false | true | ||||||||||||||||
| 1d93f61c-82a1-4889-85ee-7584c2275f3c | 2026-08-25 09:50 | 2026-08-25 09:49 | 2026-08-25 09:49 | CRML | CRML270219C00012500 | call | 12.5000 | 2027-02-19 | 1.0000 | 0.9000 | 1.0500 | 7.7450 | 77700.00 | 76400.00 | 0.00 | 777 | 9 | 2409 | 137 | 17.5839416058394 | 0.995549946212679 | 0.995549946212679 | false | false | false | true | ||||||||||||||||
| ffdb24e6-fc7f-4c06-84c9-d90ee42fe121 | 2026-08-25 09:49 | 2026-08-25 09:49 | 2026-08-25 09:49 | CRML | CRML270219C00012500 | call | 12.5000 | 2027-02-19 | 1.0000 | 0.8500 | 1.0000 | 7.7714 | 51300.00 | 51300.00 | 0.00 | 513 | 6 | 1035 | 137 | 7.55474452554745 | 0.990712611569432 | 0.990712611569432 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 677737030.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 677737030.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 677737030.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:37:03.508091Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 677737030.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:37:03.508091Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 677737030.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:42:01.576369Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 677737030.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 677737030.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 677737030.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 677737030.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 677737030.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |