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_alerts566,287 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 |
|---|
| e4a007d3-acf9-498e-b8e4-b2bab2f08cc2 | 2026-08-25 12:29 | 2026-08-25 12:29 | 2026-08-25 12:29 | EWY | EWY260918P00170000 | put | 170.0000 | 2026-09-18 | 5.1000 | 5.1000 | 5.2000 | 179.2800 | 19890.00 | 0.00 | 19890.00 | 39 | 7 | 56 | 11180 | 0.00500894454382826 | 0.512962954894938 | 0.512962954894938 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 26836573555.00 | — | — | — | 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 |
| bc9055a4-d0f5-4a56-aeab-7f81e8754439 | 2026-08-25 12:47 | 2026-08-25 12:47 | 2026-08-25 12:47 | EWY | EWY260918P00170000 | put | 170.0000 | 2026-09-18 | 5.1000 | 5.1000 | 5.2000 | 179.1400 | 127043.00 | 0.00 | 127043.00 | 249 | 17 | 310 | 11180 | 0.0277280858676208 | 0.510270235834992 | 0.510270235834992 | false | false | false | true | ||||||||||||||||
| aeff9443-476c-47ed-bb36-2286b74b1dbd | 2026-08-27 11:07 | 2026-08-27 11:07 | 2026-08-27 11:07 | EWY | EWY260918P00170000 | put | 170.0000 | 2026-09-18 | 3.4000 | 3.4000 | 3.8000 | 181.0350 | 34000.00 | 0.00 | 34000.00 | 100 | 9 | 120 | 11329 | 0.0105922852855504 | 0.455816942969883 | 0.455816942969883 | false | false | false | true | ||||||||||||||||
| 8812a487-3d67-48ea-86b1-6ef4cbb633ad | 2026-08-28 15:41 | 2026-08-28 15:41 | 2026-08-28 15:41 | EWY | EWY260918P00170000 | put | 170.0000 | 2026-09-18 | 3.3000 | 3.1000 | 3.5000 | 180.4650 | 33000.00 | 0.00 | 0.00 | 100 | 5 | 137 | 11508 | 0.0119047619047619 | 0.448522841782038 | 0.448522841782038 | false | false | false | true | ||||||||||||||||
| 54e10f6f-179b-4a4d-9e04-0f7ab8fd7f57 | 2026-08-31 14:57 | 2026-08-31 14:57 | 2026-08-31 14:57 | EWY | EWY260918P00170000 | put | 170.0000 | 2026-09-18 | 2.9500 | 2.9000 | 2.9500 | 179.3100 | 22420.00 | 22420.00 | 0.00 | 76 | 20 | 443 | 11505 | 0.0385049978270317 | 0.433164663627944 | 0.433164663627944 | false | false | false | true | ||||||||||||||||
| 83b376be-1e04-487d-99c5-a093d04e1518 | 2026-08-31 15:15 | 2026-08-31 15:15 | 2026-08-31 15:15 | EWY | EWY260918P00170000 | put | 170.0000 | 2026-09-18 | 3.0000 | 2.9000 | 3.1000 | 179.2800 | 278400.00 | 275700.00 | 0.00 | 928 | 24 | 1439 | 11505 | 0.125076053889613 | 0.436364894077455 | 0.436364894077455 | false | false | false | true | ||||||||||||||||
| 08e50d25-a637-46f4-9b08-70291bcd6312 | 2026-09-03 14:29 | 2026-09-03 14:29 | 2026-09-03 14:29 | EWY | EWY260918P00170000 | put | 170.0000 | 2026-09-18 | 2.1500 | 2.1500 | 2.2100 | 180.4600 | 135450.00 | 0.00 | 135450.00 | 630 | 17 | 999 | 12589 | 0.0793549924537294 | 0.428425102247782 | 0.428425102247782 | false | false | false | true | ||||||||||||||||
| 50f38b1a-176b-41a8-8b3e-b60b22ce8c76 | 2026-09-10 10:20 | 2026-09-10 10:20 | 2026-09-10 10:20 | EWY | EWY260918P00170000 | put | 170.0000 | 2026-09-18 | 1.0000 | 0.8200 | 1.0400 | 184.8300 | 136200.00 | 136200.00 | 0.00 | 1362 | 11 | 1383 | 12887 | 0.107317451695507 | 0.530251072026937 | 0.530251072026937 | false | false | false | true | ||||||||||||||||
| b7c1dd71-7573-4d54-b602-78a09a4e83b6 | 2026-09-14 11:08 | 2026-09-14 11:08 | 2026-09-14 11:08 | EWY | EWY260918P00170000 | put | 170.0000 | 2026-09-18 | 1.7100 | 1.6300 | 1.7700 | 176.4900 | 183654.00 | 28386.00 | 155268.00 | 1074 | 5 | 3850 | 14072 | 0.27359295054008 | 0.580790922104702 | 0.580790922104702 | false | false | false | true | ||||||||||||||||
| f418719a-01d7-427b-82ae-ad7e66929d01 | 2026-09-14 14:28 | 2026-09-14 14:28 | 2026-09-14 14:28 | EWY | EWY260918P00170000 | put | 170.0000 | 2026-09-18 | 1.1500 | 1.0900 | 1.2700 | 178.7600 | 143980.00 | 115.00 | 142715.00 | 1252 | 9 | 5124 | 14072 | 0.364127345082433 | 0.57089650341118 | 0.57089650341118 | false | false | false | true | ||||||||||||||||
| 6187df08-475c-438c-9ecb-f02912c25eba | 2026-09-15 14:05 | 2026-09-15 14:05 | 2026-09-15 14:05 | EWY | EWY260918P00170000 | put | 170.0000 | 2026-09-18 | 1.2600 | 1.2600 | 1.3600 | 176.4600 | 48762.00 | 0.00 | 48762.00 | 387 | 34 | 2710 | 14935 | 0.181452962838969 | 0.578532584634826 | 0.578532584634826 | false | false | false | true | ||||||||||||||||
| 196a50f5-aa64-4552-b438-c2968154053d | 2026-09-16 14:32 | 2026-09-16 14:32 | 2026-09-16 14:32 | EWY | EWY260918P00170000 | put | 170.0000 | 2026-09-18 | 0.7700 | 0.6300 | 0.7700 | 176.7900 | 39578.00 | 39578.00 | 0.00 | 514 | 35 | 553 | 15063 | 0.0367124742747129 | 0.593548053927193 | 0.593548053927193 | true | false | false | true | ||||||||||||||||
| adf592f1-ead3-4a68-b5bb-525c4bd5b106 | 2026-09-16 15:09 | 2026-09-16 15:09 | 2026-09-16 15:09 | EWY | EWY260918P00170000 | put | 170.0000 | 2026-09-18 | 1.1300 | 0.8900 | 1.1300 | 174.8150 | 74693.00 | 74693.00 | 0.00 | 661 | 35 | 1222 | 15063 | 0.0811259377282082 | 0.578984298225758 | 0.577772541193795 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T19:57:19.773601Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28584308397.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:21:23.599560Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28584308397.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28584308397.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:49:41.095224Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26611812485.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26611812485.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:16:52.058969Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |