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.
Simplify Analyticsuw_flow_alerts326,449 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 |
|---|
| 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 |
|---|
| a48f81d3-d2b1-42f7-aafa-428a85114596 | 2026-08-17 13:24 | 2026-08-17 13:24 | 2026-08-17 13:24 | WDAY | WDAY260821C00192500 | call | 192.5000 | 2026-08-21 | 3.1000 | 2.5500 | 3.1000 | 189.7100 | 32550.00 | 32550.00 | 0.00 | 105 | 18 | 274 | 621 | 0.44122383252818 | 0.541527279690106 | 0.541527279690106 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 38065160000.00 | 2026-11-24 | unknown | — | 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 |
| 6f9226d0-093e-4c78-aeb6-42a9b0b1df47 | 2026-08-17 11:51 | 2026-08-17 11:50 | 2026-08-17 11:50 | WDAY | WDAY280121C00260000 | call | 260.0000 | 2028-01-21 | 12.1000 | 10.5000 | 12.1000 | 191.0800 | 12100.00 | 12100.00 | 0.00 | 10 | 5 | 3803 | 72 | 52.8194444444444 | 0.311971119168712 | 0.311971119168712 | true | false | false | true | ||||||||||||||||
| 32302fdd-6ee3-43d2-95b6-80b14de5c16a | 2026-08-17 11:11 | 2026-08-17 11:11 | 2026-08-17 11:11 | WDAY | WDAY260918P00180000 | put | 180.0000 | 2026-09-18 | 7.2000 | 7.0000 | 8.2000 | 191.8000 | 15120.00 | 11520.00 | 3600.00 | 21 | 5 | 39 | 508 | 0.0767716535433071 | 0.567767741010574 | 0.567767741010574 | false | false | false | true | ||||||||||||||||
| e0b899b5-481a-4dd0-b270-d8e6a5801894 | 2026-08-17 10:40 | 2026-08-17 10:39 | 2026-08-17 10:39 | WDAY | WDAY260821C00200000 | call | 200.0000 | 2026-08-21 | 1.7000 | 1.4500 | 1.9500 | 193.1600 | 12920.00 | 9010.00 | 0.00 | 76 | 11 | 526 | 7617 | 0.0690560588158067 | 0.518068166627176 | 0.518068166627176 | false | false | false | true | ||||||||||||||||
| cf098a02-d9a7-45f6-b198-a4fb29063fa9 | 2026-08-17 10:21 | 2026-08-17 10:21 | 2026-08-17 10:21 | WDAY | WDAY260918P00160000 | put | 160.0000 | 2026-09-18 | 2.0000 | 1.5500 | 2.0000 | 194.4750 | 20000.00 | 12000.00 | 0.00 | 100 | 5 | 100 | 829 | 0.120627261761158 | 0.593689574892699 | 0.593689574892699 | false | false | false | true | ||||||||||||||||
| 04821f27-7c46-4286-870f-0a40eee4d332 | 2026-08-17 10:21 | 2026-08-17 10:21 | 2026-08-17 10:21 | WDAY | WDAY260821C00200000 | call | 200.0000 | 2026-08-21 | 2.2000 | 2.1500 | 2.6500 | 194.4750 | 14526.00 | 2865.00 | 11221.00 | 66 | 30 | 280 | 7617 | 0.0367598792175397 | 0.535800497466406 | 0.533821494533854 | true | false | false | true | ||||||||||||||||
| 97a2f977-6572-44b3-81e1-81ed7437fcf3 | 2026-08-17 10:20 | 2026-08-17 10:20 | 2026-08-17 10:20 | WDAY | WDAY260821C00200000 | call | 200.0000 | 2026-08-21 | 2.2000 | 1.9000 | 2.2000 | 194.2350 | 36520.00 | 36520.00 | 0.00 | 166 | 12 | 207 | 7617 | 0.0271760535643954 | 0.544349219117149 | 0.544349219117149 | false | false | false | true | ||||||||||||||||
| c953a0f1-0faa-42e2-858e-9eaaadfa268f | 2026-08-17 09:58 | 2026-08-17 09:58 | 2026-08-17 09:58 | WDAY | WDAY260904P00177500 | put | 177.5000 | 2026-09-04 | 4.6000 | 4.6000 | 4.9000 | 192.7551 | 13340.00 | 0.00 | 2300.00 | 29 | 5 | 151 | 7 | 21.5714285714286 | 0.649275299263742 | 0.649275299263742 | false | false | false | true | ||||||||||||||||
| 60e60d8c-1861-4ad5-beaa-f8880832ac72 | 2026-08-17 09:58 | 2026-08-17 09:57 | 2026-08-17 09:57 | WDAY | WDAY260904P00177500 | put | 177.5000 | 2026-09-04 | 4.6500 | 4.2000 | 5.1000 | 192.7551 | 19990.00 | 7990.00 | 9670.00 | 43 | 9 | 73 | 7 | 10.4285714285714 | 0.656527778847425 | 0.649275299263742 | false | false | false | true | ||||||||||||||||
| e39618f7-b53d-4c7a-958f-0d125154d405 | 2026-08-17 09:52 | 2026-08-17 09:52 | 2026-08-17 09:52 | WDAY | WDAY270617C00350000 | call | 350.0000 | 2027-06-17 | 2.7000 | 2.6500 | 2.7000 | 194.5450 | 58590.00 | 58590.00 | 0.00 | 217 | 20 | 217 | 39 | 5.56410256410256 | 0.40328347448093 | 0.40328347448093 | false | false | false | true | ||||||||||||||||
| 092f1ced-b1c8-476d-8d13-00be36ac1460 | 2026-08-17 09:52 | 2026-08-17 09:52 | 2026-08-17 09:52 | WDAY | WDAY270617C00400000 | call | 400.0000 | 2027-06-17 | 2.2000 | 2.1500 | 2.2000 | 194.5450 | 74140.00 | 74140.00 | 0.00 | 337 | 27 | 337 | 242 | 1.39256198347107 | 0.451722024712691 | 0.451722024712691 | false | false | false | true | ||||||||||||||||
| 372fbcdc-73e2-4455-a5b2-512c40d89e61 | 2026-08-17 09:47 | 2026-08-17 09:47 | 2026-08-17 09:47 | WDAY | WDAY261218C00220000 | call | 220.0000 | 2026-12-18 | 10.1400 | 8.0000 | 11.5000 | 192.5150 | 507000.00 | 507000.00 | 0.00 | 500 | 14 | 501 | 3738 | 0.134028892455859 | 0.424965871121537 | 0.424965871121537 | false | true | true | false | ||||||||||||||||
| 2c26579c-0514-47ef-b0b0-90e7dc2ebf24 | 2026-08-17 09:38 | 2026-08-17 09:37 | 2026-08-17 09:37 | WDAY | WDAY260821P00197500 | put | 197.5000 | 2026-08-21 | 5.9000 | 5.5000 | 6.6000 | 195.2400 | 23010.00 | 0.00 | 22420.00 | 39 | 9 | 43 | 36 | 1.19444444444444 | 0.577147051023038 | 0.577147051023038 | false | false | false | true | ||||||||||||||||
| 87807d49-6561-4da0-908a-fdf86c026b6f | 2026-08-17 09:35 | 2026-08-17 09:35 | 2026-08-17 09:35 | WDAY | WDAY280121C00180000 | call | 180.0000 | 2028-01-21 | 45.0000 | 45.0000 | 49.4000 | 193.9700 | 22500.00 | 0.00 | 22500.00 | 5 | 5 | 6 | 26 | 0.230769230769231 | 0.364376498173684 | 0.364376498173684 | false | false | false | true | ||||||||||||||||
| e3ebb126-5f8b-4fe7-a50e-86789e7fd2d6 | 2026-08-14 15:53 | 2026-08-14 15:53 | 2026-08-14 15:53 | WDAY | WDAY260821C00210000 | call | 210.0000 | 2026-08-21 | 1.6000 | 1.6000 | 1.9000 | 198.0600 | 72640.00 | 0.00 | 72640.00 | 454 | 18 | 1457 | 185 | 7.87567567567568 | 0.500703792689984 | 0.500703792689984 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 2 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 38065160000.00 |
| 2026-11-24 |
| unknown |
| — |
| 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 |