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_alerts658,639 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 | strike |
|---|
| 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 |
|---|
| f77de13f-3bc9-496a-8775-6c50370e5358 | 2026-08-21 09:42 | 2026-08-21 09:42 | 2026-08-21 09:42 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 3.2000 | 3.2000 | 3.4000 | 979.2900 | 192027.00 | 0.00 | 192027.00 | 600 | 40 | 9825 | 14133 | 0.695181490129484 | 0.980341338431645 | 0.986556157984502 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9e18c333-15e8-4643-8087-5607f8f0198e | 2026-08-21 09:35 | 2026-08-21 09:35 | 2026-08-21 09:35 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 4.1000 | 3.7500 | 4.1000 | 981.2400 | 122983.00 | 122983.00 | 0.00 | 300 | 12 | 5159 | 14133 | 0.365032194155523 | 1.02970561812632 | 1.02380290746243 | true | false | false | |||||||||||||||||
| 30b3efe0-9acf-43c0-b6f2-ba14ca5e49c4 | 2026-08-21 09:34 | 2026-08-21 09:34 | 2026-08-21 09:34 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 4.8800 | 4.8500 | 5.2500 | 983.8750 | 146289.00 | 0.00 | 146289.00 | 300 | 12 | 4334 | 14133 | 0.306658175900375 | 1.03485210343525 | 1.04476887603483 | true | false | false | |||||||||||||||||
| f4cf86f5-c650-4348-b62a-e986f35c88cb | 2026-08-20 13:20 | 2026-08-20 13:20 | 2026-08-20 13:20 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 2.2200 | 2.2100 | 2.3000 | 955.1700 | 190903.00 | 444.00 | 190459.00 | 860 | 17 | 29632 | 13559 | 2.18541190353271 | 0.74046007438425 | 0.741443261521633 | true | false | false | |||||||||||||||||
| 07f7c650-3589-432b-a578-9d577f7aab67 | 2026-08-20 10:40 | 2026-08-20 10:40 | 2026-08-20 10:40 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 5.0000 | 4.9500 | 5.1000 | 960.6556 | 264506.00 | 1520.00 | 262986.00 | 529 | 50 | 18360 | 13559 | 1.35408215945129 | 0.895185295049651 | 0.891013617911974 | false | false | false | |||||||||||||||||
| 60f5813f-0c1f-423a-927e-700289d4d66d | 2026-08-20 10:24 | 2026-08-20 10:23 | 2026-08-20 10:23 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 5.0000 | 4.9000 | 5.1000 | 959.2900 | 125014.00 | 121505.00 | 1509.00 | 250 | 38 | 13444 | 13559 | 0.991518548565528 | 0.921390487300242 | 0.916849091057753 | true | false | false | |||||||||||||||||
| 1ed39ccb-7911-4e48-9e02-cfb42e7c9f2e | 2026-08-20 10:13 | 2026-08-20 10:13 | 2026-08-20 10:13 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 4.0000 | 3.9000 | 4.0500 | 955.4999 | 110018.00 | 106818.00 | 0.00 | 275 | 37 | 10367 | 13559 | 0.764584408879711 | 0.900645808601097 | 0.89569455273802 | false | false | false | |||||||||||||||||
| 4afa6fe4-6323-49ba-862f-f11a5bfcf23d | 2026-08-18 15:44 | 2026-08-18 15:44 | 2026-08-18 15:44 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 6.2000 | 6.1000 | 6.4000 | 940.2600 | 200301.00 | 1245.00 | 199056.00 | 323 | 43 | 21023 | 9821 | 2.14061704510742 | 0.732619163117013 | 0.732619163117013 | false | false | false | |||||||||||||||||
| be4e9b72-0c56-468c-ad64-95787f1d5e3f | 2026-08-18 09:42 | 2026-08-18 09:42 | 2026-08-18 09:42 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 16.0000 | 16.0000 | 16.6500 | 973.0000 | 254412.00 | 1605.00 | 252807.00 | 159 | 32 | 1766 | 9821 | 0.179818755727523 | 0.757942256398829 | 0.761558840165533 | false | false | false | |||||||||||||||||
| c340342c-625e-4ada-9aec-9d26d79042b4 | 2026-08-17 15:59 | 2026-08-17 15:59 | 2026-08-17 15:59 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 34.9400 | 34.0000 | 34.9500 | 1010.7674 | 1048232.00 | 1048232.00 | 0.00 | 300 | 10 | 11876 | 10820 | 1.09759704251386 | 0.690881785095867 | 0.691364198678687 | false | false | false | |||||||||||||||||
| e9d8ced1-3f1c-4589-b723-748bbc0ccf84 | 2026-08-17 15:32 | 2026-08-17 15:31 | 2026-08-17 15:31 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 36.5200 | 36.2000 | 36.8000 | 1013.3800 | 105922.00 | 105922.00 | 0.00 | 29 | 11 | 10397 | 10820 | 0.96090573012939 | 0.692302926563701 | 0.692302926563701 | false | false | false | |||||||||||||||||
| 9c1f09f7-aa02-4c75-8888-016442da5daf | 2026-08-17 13:22 | 2026-08-17 13:22 | 2026-08-17 13:22 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 42.9400 | 42.9000 | 43.1500 | 1023.5500 | 107345.00 | 30095.00 | 4290.00 | 25 | 25 | 8918 | 10820 | 0.824214417744917 | 0.695515701345298 | 0.698012831713255 | false | false | false | |||||||||||||||||
| 42ff0263-0187-4e37-b8ff-2a3ae17727f4 | 2026-08-17 10:47 | 2026-08-17 10:47 | 2026-08-17 10:47 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 45.0000 | 44.3000 | 45.4000 | 1025.3400 | 139514.00 | 139514.00 | 0.00 | 31 | 12 | 5790 | 10820 | 0.535120147874307 | 0.725837586197687 | 0.720222938374166 | false | false | false | |||||||||||||||||
| 2abaa5ce-47aa-4725-8750-3d6870a775d6 | 2026-08-17 10:06 | 2026-08-17 10:06 | 2026-08-17 10:06 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 39.3100 | 39.0000 | 39.6000 | 1015.2100 | 157245.00 | 102270.00 | 3930.00 | 40 | 39 | 4193 | 10820 | 0.387523105360444 | 0.732481657838602 | 0.736123086754914 | true | false | false | |||||||||||||||||
| 6a7c1076-6a81-4d69-94f5-c68e5469c087 | 2026-08-17 09:32 | 2026-08-17 09:32 | 2026-08-17 09:32 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 38.2600 | 37.5500 | 38.3500 | 1009.9900 | 742215.00 | 252655.00 | 15260.00 | 194 | 77 | 1167 | 10820 | 0.107855822550832 | 0.775493336395652 | 0.781504310308302 | true | false | false | |||||||||||||||||
| fce7bc24-fa64-4950-aa71-cacc62ebd3ed | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | MU | MU260821C01000000 | call | 1000.0000 | 2026-08-21 | 35.1200 | 34.0000 | 35.9000 | 1005.8200 | 842939.00 | 587189.00 | 255750.00 | 240 | 31 | 469 | 10820 | 0.0433456561922366 | 0.76576958014896 | 0.766421598122876 | true | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:59:29.758034Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |