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_alerts474,253 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 |
|---|
| b9649ac7-707c-4792-81c4-5a0693e54643 | 2026-09-25 15:54 | 2026-09-25 15:54 | 2026-09-25 15:54 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 6.2500 | 6.0000 | 6.2500 | 250.5800 | 51250.00 | 51250.00 | 0.00 | 82 | 8 | 1139 | 14620 | 0.077906976744186 | 0.284820958590336 | 0.284820958590336 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 2693018909521.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:58:21.779683Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 4d5f38a8-ed17-4392-a229-32927a525c0d | 2026-09-25 11:58 | 2026-09-25 11:58 | 2026-09-25 11:58 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 6.8000 | 6.7500 | 6.9500 | 249.2500 | 14280.00 | 680.00 | 13600.00 | 21 | 6 | 526 | 14620 | 0.0359781121751026 | 0.281191357850072 | 0.281397186913045 | false | false | false | true | ||||||||||||||||
| 9fd1deda-3da6-4708-86b3-7aa84dd76cf9 | 2026-09-25 11:33 | 2026-09-25 11:33 | 2026-09-25 11:33 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 6.8000 | 6.8000 | 7.0000 | 249.0000 | 25160.00 | 0.00 | 25160.00 | 37 | 6 | 476 | 14620 | 0.0325581395348837 | 0.280366936316801 | 0.280366936316801 | false | false | false | true | ||||||||||||||||
| 35b44a8f-037f-4d9f-8c3a-8278e9dcb6ea | 2026-09-25 11:07 | 2026-09-25 11:07 | 2026-09-25 11:07 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 6.9500 | 6.8500 | 6.9500 | 249.0900 | 20850.00 | 20850.00 | 0.00 | 30 | 7 | 392 | 14620 | 0.026812585499316 | 0.284384214803776 | 0.284384214803776 | false | false | false | true | ||||||||||||||||
| 42d028df-7eec-4aa6-9502-77914a7f780f | 2026-09-25 10:13 | 2026-09-25 10:13 | 2026-09-25 10:13 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 7.8000 | 7.6500 | 7.8000 | 247.6500 | 23400.00 | 23400.00 | 0.00 | 30 | 10 | 211 | 14620 | 0.0144322845417237 | 0.289649015663802 | 0.289203327273666 | false | false | false | true | ||||||||||||||||
| 5dd3e24a-192c-4259-bd3b-92ed38092ff0 | 2026-09-25 10:10 | 2026-09-25 10:10 | 2026-09-25 10:10 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 7.9000 | 7.6500 | 7.9000 | 247.4950 | 10270.00 | 10270.00 | 0.00 | 13 | 9 | 179 | 14620 | 0.0122435020519836 | 0.289853560762408 | 0.289965935314172 | false | false | false | true | ||||||||||||||||
| 45768b0d-66a2-4d5a-bde7-f01ed3bc03b7 | 2026-09-23 14:49 | 2026-09-23 14:49 | 2026-09-23 14:49 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 7.0500 | 7.0500 | 7.2500 | 249.8700 | 84600.00 | 0.00 | 84600.00 | 120 | 21 | 2052 | 14826 | 0.138405503844597 | 0.292250215493044 | 0.291870283900757 | true | false | false | true | ||||||||||||||||
| f02083af-f0a6-4e67-9da9-5434e0686dc5 | 2026-09-23 14:25 | 2026-09-23 14:24 | 2026-09-23 14:24 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 7.1000 | 7.1000 | 7.2500 | 249.0000 | 51120.00 | 0.00 | 51120.00 | 72 | 11 | 1860 | 14826 | 0.125455281262647 | 0.29215848762332 | 0.29215848762332 | false | false | false | true | ||||||||||||||||
| 536367f6-0087-46b6-b8e0-1f9189638010 | 2026-09-23 14:15 | 2026-09-23 14:15 | 2026-09-23 14:15 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 7.2500 | 7.2500 | 7.3500 | 249.5500 | 76850.00 | 0.00 | 76850.00 | 106 | 15 | 1760 | 14826 | 0.118710373667881 | 0.29375334878907 | 0.29375334878907 | true | false | false | true | ||||||||||||||||
| f003c754-9f36-460d-85fe-7ef39f6b4030 | 2026-09-23 11:02 | 2026-09-23 11:02 | 2026-09-23 11:02 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 6.7500 | 6.7000 | 6.9000 | 250.5950 | 16200.00 | 675.00 | 15525.00 | 24 | 10 | 1146 | 14826 | 0.0772966410360178 | 0.29340818717821 | 0.29340818717821 | false | false | false | true | ||||||||||||||||
| 2ba96703-92ba-481c-82bb-769b4274b7db | 2026-09-23 11:02 | 2026-09-23 11:02 | 2026-09-23 11:02 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 6.7500 | 6.7500 | 6.9000 | 250.5000 | 12825.00 | 0.00 | 12825.00 | 19 | 7 | 1122 | 14826 | 0.075677863213274 | 0.291657901098951 | 0.291657901098951 | true | false | false | true | ||||||||||||||||
| fe6cf45c-1a82-4051-86c0-bc4d7e01e05d | 2026-09-23 10:36 | 2026-09-23 10:36 | 2026-09-23 10:36 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 7.4600 | 7.4500 | 7.6500 | 248.9600 | 37298.00 | 3028.00 | 34270.00 | 50 | 18 | 1050 | 14826 | 0.0708215297450425 | 0.290228822287551 | 0.295042388097407 | false | false | false | true | ||||||||||||||||
| 42068d55-b64a-4944-85ca-8e803b864b3f | 2026-09-23 10:36 | 2026-09-23 10:36 | 2026-09-23 10:36 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 7.4400 | 7.4000 | 7.6000 | 249.0501 | 37216.00 | 0.00 | 37216.00 | 50 | 5 | 1000 | 14826 | 0.0674490759476595 | 0.290007216064271 | 0.294819427712759 | false | false | false | true | ||||||||||||||||
| 9922de09-2fe6-4d00-be7b-4db4209f8dca | 2026-09-23 10:12 | 2026-09-23 10:12 | 2026-09-23 10:12 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 7.6700 | 7.5500 | 7.7000 | 249.0200 | 153305.00 | 153305.00 | 0.00 | 200 | 5 | 604 | 14826 | 0.0407392418723863 | 0.300240681126499 | 0.29983961650281 | false | false | false | true | ||||||||||||||||
| d8f1b49a-a626-4bd4-9e9d-f368db6c009f | 2026-09-21 12:28 | 2026-09-21 12:28 | 2026-09-21 12:28 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 4.5500 | 4.4500 | 4.5500 | 257.5500 | 10920.00 | 10920.00 | 0.00 | 24 | 6 | 447 | 13954 | 0.032033825426401 | 0.302447493802687 | 0.302447493802687 | false | false | false | true | ||||||||||||||||
| 301e3462-b6bd-4bc1-bfa1-9d733f0eb344 | 2026-09-21 11:02 | 2026-09-21 11:02 | 2026-09-21 11:02 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 5.2500 | 5.1500 | 5.3000 | 255.0500 | 23625.00 | 23100.00 | 525.00 | 45 | 6 | 298 | 13954 | 0.0213558836176007 | 0.294728295515105 | 0.295609665699466 | false | false | false | true | ||||||||||||||||
| 91d26229-a681-4b8f-953d-d306641cdb8e | 2026-09-18 12:31 | 2026-09-18 12:31 | 2026-09-18 12:31 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 6.1200 | 6.0500 | 6.2000 | 253.5000 | 305871.00 | 61000.00 | 244871.00 | 500 | 31 | 1048 | 13684 | 0.0765857936275943 | 0.290110152877332 | 0.289962489244742 | true | false | false | true | ||||||||||||||||
| 0f78c147-6b8e-4a77-a34b-fcb0f10c597b | 2026-09-15 15:32 | 2026-09-15 15:32 | 2026-09-15 15:32 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 9.5500 | 9.5500 | 9.6000 | 247.9100 | 102185.00 | 0.00 | 102185.00 | 107 | 13 | 1547 | 12937 | 0.11957950065703 | 0.307528176757574 | 0.307528176757574 | false | false | false | true | ||||||||||||||||
| efa3995a-245c-463f-8fc2-5ae0035e4470 | 2026-08-28 11:10 | 2026-08-28 11:09 | 2026-08-28 11:09 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 4.9000 | 4.9000 | 5.1500 | 265.7952 | 377356.00 | 0.00 | 377356.00 | 770 | 49 | 1059 | 10432 | 0.101514570552147 | 0.305279169142893 | 0.305321817124465 | false | false | false | true | ||||||||||||||||
| 042c0a08-2fea-42db-bab0-bc4e9108e17e | 2026-08-25 12:13 | 2026-08-25 12:13 | 2026-08-25 12:13 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 6.6400 | 6.6000 | 6.8000 | 260.6400 | 780402.00 | 628347.00 | 152055.00 | 1175 | 65 | 1340 | 9444 | 0.141889030072003 | 0.304985349325381 | 0.304802457701075 | false | false | false | true | ||||||||||||||||
| 8c07d406-ab9a-4a0a-b986-705a1c692cac | 2026-08-24 10:13 | 2026-08-24 10:13 | 2026-08-24 10:13 | AMZN | AMZN261016P00250000 | put | 250.0000 | 2026-10-16 | 6.6700 | 6.5500 | 6.8000 | 261.1800 | 447350.00 | 251840.00 | 195510.00 | 671 | 21 | 684 | 7886 | 0.086735987826528 | 0.307420374532528 | 0.308431281882238 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2693018909521.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:59:16.361510Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2693018909521.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:34:39.698780Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2693018909521.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:08:32.454345Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2693018909521.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:14:35.986965Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2693018909521.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:11:57.153448Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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-23T18:50:04.558688Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2688704384092.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:27:32.623000Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T18:19:20.444616Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T15:04:15.950179Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T15:04:15.950179Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T14:37:43.750009Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T14:37:43.750009Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T14:13:13.809395Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:29:13.911862Z"} |
| 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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:05:23.809831Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2736595616352.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:45:45.480252Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 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-15T19:44:55.237483Z"} |
| 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-08-28T15:11:58.135920Z"} |
| 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-08-25T16:29:52.792110Z"} |
| 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-08-24T14:21:20.397116Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |