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_alerts425,429 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 |
|---|
| b35861f6-a103-4966-a65c-a948dd5f1612 | 2026-08-17 12:37 | 2026-08-17 12:37 | 2026-08-17 12:37 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 34.7500 | 34.5500 | 34.7500 | 260.3900 | 125100.00 | 125100.00 | 0.00 | 36 | 12 | 88 | 6439 | 0.0136667184345395 | 0.365705264485205 | 0.365705264485205 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 2734761943045.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 37c0e5d2-3e1d-4463-8659-b3353ebf1776 | 2026-09-08 11:43 | 2026-09-08 11:43 | 2026-09-08 11:43 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 32.6500 | 32.5000 | 32.9000 | 256.9500 | 114275.00 | 0.00 | 114275.00 | 35 | 6 | 184 | 6442 | 0.0285625582117355 | 0.370848363027238 | 0.370848363027238 | false | false | false | true | ||||||||||||||||
| 5c1e64c0-ab47-41e9-8b3a-fbd1363d55c2 | 2026-09-11 15:10 | 2026-09-11 15:10 | 2026-09-11 15:10 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 32.3500 | 32.1500 | 32.4500 | 257.0800 | 482015.00 | 388200.00 | 93815.00 | 149 | 7 | 169 | 6783 | 0.0249152292495946 | 0.37703332402128 | 0.376991488289118 | false | false | false | true | ||||||||||||||||
| fbdac722-9419-4cde-8c2d-4945562b8aae | 2026-09-11 15:10 | 2026-09-11 15:10 | 2026-09-11 15:10 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 32.3000 | 32.1500 | 32.7000 | 257.1000 | 268090.00 | 96900.00 | 151810.00 | 83 | 14 | 252 | 6783 | 0.0371517027863777 | 0.376474089907682 | 0.376474089907682 | true | false | false | true | ||||||||||||||||
| 57ca676c-c165-42a7-8872-32fca92ae77f | 2026-09-11 15:10 | 2026-09-11 15:10 | 2026-09-11 15:10 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 32.3000 | 32.2500 | 32.6000 | 257.1050 | 106590.00 | 96900.00 | 9690.00 | 33 | 5 | 285 | 6783 | 0.0420168067226891 | 0.376453181313044 | 0.376453181313044 | true | false | false | true | ||||||||||||||||
| d10b2d30-36bd-4263-a46f-f49c232d9d16 | 2026-09-11 15:10 | 2026-09-11 15:10 | 2026-09-11 15:10 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 32.2500 | 32.2000 | 32.4500 | 257.0650 | 525676.00 | 96750.00 | 332176.00 | 163 | 21 | 448 | 6783 | 0.066047471620227 | 0.376186652127826 | 0.376186652127826 | true | false | false | true | ||||||||||||||||
| 8516f5d6-f9e1-497c-abe7-6da9f1c8a739 | 2026-09-11 15:11 | 2026-09-11 15:10 | 2026-09-11 15:10 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 32.2500 | 32.1500 | 32.4500 | 257.0700 | 216075.00 | 193500.00 | 22575.00 | 67 | 6 | 581 | 6783 | 0.0856553147574819 | 0.376165751790843 | 0.376165751790843 | true | false | false | true | ||||||||||||||||
| 8ed9747f-d462-4c46-bb19-e9699ad74fe9 | 2026-09-11 15:11 | 2026-09-11 15:11 | 2026-09-11 15:11 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 32.2500 | 32.1500 | 32.2500 | 257.0800 | 677250.00 | 677250.00 | 0.00 | 210 | 9 | 821 | 6783 | 0.121037888839746 | 0.376291155034486 | 0.376123951360781 | false | false | false | true | ||||||||||||||||
| 5e183342-d5a2-4198-a70e-4d18e54a79cb | 2026-09-11 15:11 | 2026-09-11 15:11 | 2026-09-11 15:11 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 32.2000 | 32.1500 | 32.4500 | 257.0600 | 1413580.00 | 386400.00 | 379960.00 | 439 | 9 | 1260 | 6783 | 0.185758513931889 | 0.375690166927105 | 0.3757737327756 | false | false | false | true | ||||||||||||||||
| eff329c1-ebcc-48c3-8643-46c7aba1a507 | 2026-09-11 15:11 | 2026-09-11 15:11 | 2026-09-11 15:11 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 32.2000 | 32.1500 | 32.4500 | 257.0450 | 698740.00 | 373520.00 | 228620.00 | 217 | 33 | 1477 | 6783 | 0.217750257997936 | 0.375836408011954 | 0.375836408011954 | true | false | false | true | ||||||||||||||||
| 426f2655-cc88-4a09-9c92-c2bafa544972 | 2026-09-11 15:11 | 2026-09-11 15:11 | 2026-09-11 15:11 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 32.2000 | 32.1500 | 32.2000 | 257.0700 | 386400.00 | 386400.00 | 0.00 | 120 | 5 | 1647 | 6783 | 0.24281291463954 | 0.375731949689637 | 0.375731949689637 | false | false | false | true | ||||||||||||||||
| 8ecee4b1-f1ef-4cc4-8202-0844f4ae331a | 2026-09-15 12:53 | 2026-09-15 12:53 | 2026-09-15 12:53 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 28.8000 | 28.6000 | 28.8500 | 249.2200 | 1160629.00 | 930229.00 | 230400.00 | 403 | 39 | 468 | 7669 | 0.0610249054635546 | 0.380078748494324 | 0.380078748494324 | true | false | false | true | ||||||||||||||||
| 2dcc1491-1e3c-453c-8e68-476c0bff189f | 2026-09-15 12:54 | 2026-09-15 12:54 | 2026-09-15 12:54 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 28.8000 | 28.8000 | 28.9500 | 249.3400 | 155520.00 | 0.00 | 155520.00 | 54 | 5 | 630 | 7669 | 0.0821489112009388 | 0.379557617547811 | 0.379586726447431 | false | false | false | true | ||||||||||||||||
| f51d88d7-4313-4deb-aae3-36b1b3277548 | 2026-09-15 12:55 | 2026-09-15 12:54 | 2026-09-15 12:54 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 28.8000 | 28.7000 | 28.9000 | 249.3100 | 345600.00 | 115200.00 | 230400.00 | 120 | 6 | 841 | 7669 | 0.109662276698396 | 0.379709724757433 | 0.379709724757433 | true | false | false | true | ||||||||||||||||
| b56e38a8-9343-470e-a3ee-61dfc57af4ed | 2026-09-15 12:56 | 2026-09-15 12:56 | 2026-09-15 12:56 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 28.8000 | 28.6500 | 28.8500 | 249.2100 | 1074240.00 | 613440.00 | 460800.00 | 373 | 13 | 1579 | 7669 | 0.205893858390925 | 0.380119753807525 | 0.380119753807525 | true | false | false | true | ||||||||||||||||
| 75f74781-bd92-40e4-9de5-8000264a9d13 | 2026-09-21 12:55 | 2026-09-21 12:55 | 2026-09-21 12:55 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 31.7500 | 31.7500 | 32.6000 | 257.0000 | 2711450.00 | 0.00 | 2711450.00 | 854 | 5 | 909 | 7246 | 0.125448523323213 | 0.361602941785216 | 0.361901882127003 | false | false | false | true | ||||||||||||||||
| ebd623a9-d215-4e47-9403-7e29071659b4 | 2026-09-21 13:23 | 2026-09-21 13:23 | 2026-09-21 13:23 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 32.0000 | 31.9500 | 32.2000 | 257.0000 | 694400.00 | 0.00 | 694400.00 | 217 | 10 | 1160 | 7246 | 0.160088324592879 | 0.363744627437258 | 0.364557711206981 | false | false | false | true | ||||||||||||||||
| c538bb0d-6d2a-406d-b70c-d4200602ec48 | 2026-09-22 15:57 | 2026-09-22 15:57 | 2026-09-22 15:57 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 30.6500 | 30.6000 | 31.1500 | 255.1400 | 36780.00 | 30650.00 | 6130.00 | 12 | 7 | 444 | 7140 | 0.0621848739495798 | 0.364097400263329 | 0.364097400263329 | false | false | false | true | ||||||||||||||||
| b5dc22d6-4e50-4fc2-9a20-65536d8e1651 | 2026-09-24 11:33 | 2026-09-24 11:32 | 2026-09-24 11:32 | AMZN | AMZN271217C00300000 | call | 300.0000 | 2027-12-17 | 26.0000 | 25.9000 | 26.0500 | 246.1300 | 18200.00 | 2600.00 | 15600.00 | 7 | 7 | 49 | 7257 | 0.00675210141931928 | 0.359694914355485 | 0.359694914355485 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:43:32.720264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T17:17:02.017770Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T17:17:02.017770Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T17:17:02.017770Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T17:17:02.017770Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:24:56.111062Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2688704384092.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |