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 | 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 |
|---|
| 0de8d12e-0dfe-432b-a3a7-0b04037de432 | 2026-08-24 15:03 | 2026-08-24 15:03 | 2026-08-24 15:03 | SNOW | SNOW280121C00450000 | call | 450.0000 | 2028-01-21 | 62.2600 | 61.1500 | 64.0000 | 325.6900 | 56035.00 | 0.00 | 56035.00 | 9 | 6 | 9 | 19 | 0.473684210526316 | 0.601838357711343 | 0.602486325341562 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 117253080000.00 | 2026-12-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d6e2c940-a718-4a6a-888f-5141c96efb90 | 2026-08-24 12:24 | 2026-08-24 12:24 | 2026-08-24 12:24 | SNOW | SNOW270319P00370000 | put | 370.0000 | 2027-03-19 | 81.7500 | 78.9500 | 81.7500 | 326.5600 | 138975.00 | 138975.00 | 0.00 | 17 | 5 | 26 | 27 | 0.962962962962963 | 0.611955130164275 | 0.611955130164275 | false | false | false | true | ||||||||||||||||
| b7a50d90-4435-44d1-a7dd-c62e11993fb4 | 2026-08-21 12:13 | 2026-08-21 12:13 | 2026-08-21 12:13 | SNOW | SNOW271217C00360000 | call | 360.0000 | 2027-12-17 | 85.1000 | 83.1500 | 85.1000 | 326.8175 | 3940130.00 | 3940130.00 | 0.00 | 463 | 17 | 673 | 242 | 2.78099173553719 | 0.612060898673905 | 0.612060898673905 | false | false | false | true | ||||||||||||||||
| 4b3abe0b-8bba-4b8a-84d0-db9358a424be | 2026-08-21 11:41 | 2026-08-21 11:41 | 2026-08-21 11:41 | SNOW | SNOW260918P00330000 | put | 330.0000 | 2026-09-18 | 27.5000 | 26.4500 | 27.5000 | 326.0800 | 340997.00 | 340997.00 | 0.00 | 124 | 29 | 203 | 567 | 0.358024691358025 | 0.71936962514374 | 0.71936962514374 | false | false | false | true | ||||||||||||||||
| 9e0ef823-b70d-4ded-a8e1-6f3e4b7562ba | 2026-08-21 09:56 | 2026-08-21 09:56 | 2026-08-21 09:56 | SNOW | SNOW260918C00330000 | call | 330.0000 | 2026-09-18 | 22.1500 | 19.8500 | 22.1500 | 320.5450 | 62012.00 | 62012.00 | 0.00 | 28 | 5 | 30 | 1023 | 0.0293255131964809 | 0.7307295205709 | 0.7307295205709 | false | false | false | true | ||||||||||||||||
| 1f5515f5-241a-4465-a871-0c615055cd7d | 2026-08-20 10:59 | 2026-08-20 10:59 | 2026-08-20 10:59 | SNOW | SNOW260821C00322500 | call | 322.5000 | 2026-08-21 | 3.8500 | 3.8500 | 4.7500 | 322.3100 | 98945.00 | 0.00 | 98945.00 | 257 | 5 | 281 | 63 | 4.46031746031746 | 0.583483563973369 | 0.583483563973369 | true | false | false | true | ||||||||||||||||
| af595c1c-f82a-470d-9bf9-21eb3cb984fb | 2026-08-19 15:24 | 2026-08-19 15:23 | 2026-08-19 15:23 | SNOW | SNOW260821P00360000 | put | 360.0000 | 2026-08-21 | 34.5000 | 33.9500 | 34.5000 | 325.5650 | 155250.00 | 155250.00 | 0.00 | 45 | 18 | 113 | 212 | 0.533018867924528 | 0.67311489577881 | 0.67311489577881 | false | false | false | true | ||||||||||||||||
| 4f6f7783-e884-4ac5-8ed2-917ad1e0b34c | 2026-08-19 10:26 | 2026-08-19 10:26 | 2026-08-19 10:26 | SNOW | SNOW270115C00340000 | call | 340.0000 | 2027-01-15 | 41.7500 | 40.8000 | 41.7500 | 318.0100 | 100200.00 | 100200.00 | 0.00 | 24 | 11 | 53 | 2085 | 0.0254196642685851 | 0.600070981081317 | 0.600070981081317 | false | false | false | true | ||||||||||||||||
| 181b2129-6a3c-40b0-a075-f3dcfd356b43 | 2026-08-19 10:26 | 2026-08-19 10:26 | 2026-08-19 10:26 | SNOW | SNOW270115C00340000 | call | 340.0000 | 2027-01-15 | 41.7500 | 40.6500 | 41.7500 | 318.0100 | 121075.00 | 121075.00 | 0.00 | 29 | 10 | 29 | 2085 | 0.0139088729016787 | 0.600070981081317 | 0.600070981081317 | false | false | false | true | ||||||||||||||||
| 27488658-c83d-44b7-b9db-5dafeadc391c | 2026-08-19 10:24 | 2026-08-19 10:24 | 2026-08-19 10:24 | SNOW | SNOW261218C00340000 | call | 340.0000 | 2026-12-18 | 37.3500 | 36.0500 | 37.3500 | 317.4000 | 448200.00 | 250245.00 | 0.00 | 120 | 21 | 120 | 660 | 0.181818181818182 | 0.615015825042755 | 0.615015825042755 | false | false | false | true | ||||||||||||||||
| fd99b15c-38c8-4ea8-8746-0698b5a6caaf | 2026-08-19 09:49 | 2026-08-19 09:49 | 2026-08-19 09:49 | SNOW | SNOW260821P00315000 | put | 315.0000 | 2026-08-21 | 4.0000 | 3.2500 | 4.0500 | 319.2900 | 57590.00 | 54035.00 | 3555.00 | 144 | 31 | 385 | 1252 | 0.307507987220447 | 0.632729302535298 | 0.638302668538339 | true | false | false | true | ||||||||||||||||
| d3abae5e-632f-4b89-ad3f-c8a4e7d56fed | 2026-08-18 13:23 | 2026-08-18 13:23 | 2026-08-18 13:23 | SNOW | SNOW280121P00300000 | put | 300.0000 | 2028-01-21 | 68.8000 | 66.2500 | 68.8000 | 324.1700 | 130715.00 | 130715.00 | 0.00 | 19 | 5 | 89 | 148 | 0.601351351351351 | 0.623921797367688 | 0.623921797367688 | false | false | false | true | ||||||||||||||||
| 8553386f-6323-487b-be6e-3cd0f731756f | 2026-08-18 13:08 | 2026-08-18 13:08 | 2026-08-18 13:08 | SNOW | SNOW261120C00380000 | call | 380.0000 | 2026-11-20 | 19.6500 | 19.6500 | 20.4000 | 323.3900 | 84495.00 | 0.00 | 84495.00 | 43 | 19 | 182 | 559 | 0.325581395348837 | 0.578263315877183 | 0.578263315877183 | false | false | false | true | ||||||||||||||||
| ad0fe82e-7fee-4b9f-ab8d-3fb9f7e8eb1c | 2026-08-18 11:49 | 2026-08-18 11:49 | 2026-08-18 11:49 | SNOW | SNOW261218C00370000 | call | 370.0000 | 2026-12-18 | 30.0000 | 30.0000 | 30.9500 | 322.9600 | 168000.00 | 0.00 | 168000.00 | 56 | 12 | 58 | 151 | 0.384105960264901 | 0.611124723965248 | 0.611124723965248 | false | false | false | true | ||||||||||||||||
| bf7eef1d-453e-48e2-a4ef-4d3b2c027d60 | 2026-08-18 11:05 | 2026-08-18 11:05 | 2026-08-18 11:05 | SNOW | SNOW260918C00350000 | call | 350.0000 | 2026-09-18 | 16.4000 | 15.9500 | 16.4000 | 324.0600 | 118080.00 | 118080.00 | 0.00 | 72 | 5 | 120 | 1353 | 0.0886917960088692 | 0.691194361113348 | 0.691955538367567 | false | false | false | true | ||||||||||||||||
| 4f50938e-7486-4e3d-b247-f088247193a0 | 2026-08-18 10:45 | 2026-08-18 10:45 | 2026-08-18 10:45 | SNOW | SNOW261120C00380000 | call | 380.0000 | 2026-11-20 | 19.9000 | 19.9000 | 20.2000 | 322.6200 | 256710.00 | 0.00 | 97510.00 | 129 | 7 | 139 | 559 | 0.24865831842576 | 0.586845175710183 | 0.586845175710183 | true | false | false | true | ||||||||||||||||
| 0d5a98b1-8c96-4c7b-8936-ee8979018c8b | 2026-08-17 15:16 | 2026-08-17 15:16 | 2026-08-17 15:16 | SNOW | SNOW260918P00330000 | put | 330.0000 | 2026-09-18 | 24.5500 | 24.4000 | 24.7500 | 333.8550 | 81015.00 | 2455.00 | 78560.00 | 33 | 5 | 416 | 460 | 0.904347826086957 | 0.689834228346221 | 0.689834228346221 | false | false | false | true | ||||||||||||||||
| 943033fd-ef4f-4eeb-8566-618ca67424a7 | 2026-08-17 14:04 | 2026-08-17 14:04 | 2026-08-17 14:04 | SNOW | SNOW260918P00330000 | put | 330.0000 | 2026-09-18 | 24.6000 | 24.4000 | 24.7000 | 333.0000 | 61500.00 | 2460.00 | 59040.00 | 25 | 6 | 315 | 460 | 0.684782608695652 | 0.69023463487404 | 0.69023463487404 | false | false | false | true | ||||||||||||||||
| e8c38e16-9839-4554-91c1-517de9421a05 | 2026-08-17 11:33 | 2026-08-17 11:33 | 2026-08-17 11:33 | SNOW | SNOW270319P00280000 | put | 280.0000 | 2027-03-19 | 32.3000 | 31.8000 | 32.3000 | 332.9500 | 83975.00 | 80750.00 | 3225.00 | 26 | 18 | 29 | 110 | 0.263636363636364 | 0.624951319004822 | 0.624344048449207 | false | false | false | true | ||||||||||||||||
| 98c17d8c-4805-4370-9d76-633816c6bf0a | 2026-08-17 11:32 | 2026-08-17 11:32 | 2026-08-17 11:32 | SNOW | SNOW270219P00330000 | put | 330.0000 | 2027-02-19 | 50.5100 | 50.5000 | 54.8500 | 332.7850 | 50510.00 | 0.00 | 50510.00 | 10 | 6 | 10 | 17 | 0.588235294117647 | 0.593945584065877 | 0.594494209927275 | false | false | false | true | ||||||||||||||||
| a3f9b3c8-f1b4-42c7-b0b2-f5a8d1736c42 | 2026-08-17 11:24 | 2026-08-17 11:24 | 2026-08-17 11:24 | SNOW | SNOW260918P00330000 | put | 330.0000 | 2026-09-18 | 25.7000 | 25.2500 | 25.7000 | 331.1450 | 454890.00 | 454890.00 | 0.00 | 177 | 29 | 238 | 460 | 0.517391304347826 | 0.688862641927729 | 0.688862641927729 | false | false | false | true | ||||||||||||||||
| df2ce057-c5e9-4abe-a519-b862ab48b198 | 2026-08-17 10:25 | 2026-08-17 10:25 | 2026-08-17 10:25 | SNOW | SNOW260918C00320000 | call | 320.0000 | 2026-09-18 | 32.5000 | 31.3000 | 32.9000 | 330.2650 | 195000.00 | 9750.00 | 162500.00 | 60 | 35 | 62 | 3142 | 0.0197326543602801 | 0.691061498480436 | 0.691061498480436 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T16:44:07.615841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:23:23.944279Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 117253080000.00 |
| 2026-12-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |