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 |
|---|
| 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 |
|---|
| 4b0079a9-1f85-4daa-89a9-aec62ee6026f | 2026-08-21 10:07 | 2026-08-21 10:07 | 2026-08-21 10:07 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.3000 | 0.2800 | 0.3000 | 34.8100 | 165000.00 | 165000.00 | 0.00 | 5500 | 62 | 5653 | 195 | 28.9897435897436 | 0.265665936032771 | 0.265060092922671 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 8633146199.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 28e26774-a2e0-44df-a5e5-4fbce6264024 | 2026-08-21 10:28 | 2026-08-21 10:28 | 2026-08-21 10:28 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.3800 | 0.3700 | 0.3900 | 35.0750 | 181944.00 | 178486.00 | 3458.00 | 4788 | 28 | 10520 | 195 | 53.9487179487179 | 0.265094213532278 | 0.265094213532278 | false | false | false | true | ||||||||||||||||
| bd2bd9ab-a2c2-4bc4-9b64-376776d734e7 | 2026-08-25 13:44 | 2026-08-25 13:43 | 2026-08-25 13:43 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.4500 | 0.4400 | 0.4500 | 35.5200 | 85500.00 | 85500.00 | 0.00 | 1900 | 37 | 7648 | 10656 | 0.717717717717718 | 0.274328130149983 | 0.274328130149983 | false | false | false | true | ||||||||||||||||
| 90e9ad7f-eee9-4587-b618-b07eefd110ee | 2026-08-25 15:17 | 2026-08-25 15:17 | 2026-08-25 15:17 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.5600 | 0.5500 | 0.5800 | 35.7299 | 61600.00 | 3920.00 | 10024.00 | 1100 | 43 | 8764 | 10656 | 0.822447447447447 | 0.283056483176704 | 0.283056483176704 | true | false | false | true | ||||||||||||||||
| 89d392a4-ae69-4c66-9b06-aa72e64cf566 | 2026-08-26 09:42 | 2026-08-26 09:42 | 2026-08-26 09:42 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.6100 | 0.6100 | 0.6600 | 35.9100 | 11895.00 | 0.00 | 11895.00 | 195 | 26 | 195 | 17062 | 0.0114289063415778 | 0.283316961243107 | 0.283316961243107 | false | false | false | true | ||||||||||||||||
| 49d30cd1-d2d1-462c-86eb-9bce831849a8 | 2026-08-26 10:09 | 2026-08-26 10:08 | 2026-08-26 10:08 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.6600 | 0.6500 | 0.7000 | 35.9850 | 50820.00 | 3960.00 | 4884.00 | 770 | 23 | 1240 | 17062 | 0.0726761223772125 | 0.288726529251353 | 0.288726529251353 | true | false | false | true | ||||||||||||||||
| f0da031a-abc1-4cb6-a7f1-119896ca945a | 2026-08-27 15:06 | 2026-08-27 15:05 | 2026-08-27 15:05 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.4500 | 0.4500 | 0.4700 | 35.7400 | 107640.00 | 0.00 | 107640.00 | 2392 | 23 | 2587 | 16460 | 0.157168894289186 | 0.26326822596413 | 0.26326822596413 | false | false | false | true | ||||||||||||||||
| 41ea492e-a70d-4784-aacb-6f8cff2e2db0 | 2026-08-28 10:16 | 2026-08-28 10:15 | 2026-08-28 10:15 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.2900 | 0.2900 | 0.3000 | 35.4400 | 41354.00 | 0.00 | 41354.00 | 1426 | 21 | 1468 | 15634 | 0.0938979148010746 | 0.260227449770942 | 0.260227449770942 | false | false | false | true | ||||||||||||||||
| ec079548-7ee4-46a7-a442-59f1f2d7febf | 2026-08-28 10:16 | 2026-08-28 10:16 | 2026-08-28 10:16 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.2700 | 0.2700 | 0.2900 | 35.4000 | 76248.00 | 0.00 | 76248.00 | 2824 | 33 | 4292 | 15634 | 0.274529870794422 | 0.256636635508156 | 0.256636635508156 | false | false | false | true | ||||||||||||||||
| 4916b88d-a129-437a-aaf0-9322b4895c41 | 2026-08-28 10:21 | 2026-08-28 10:21 | 2026-08-28 10:21 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.2300 | 0.2300 | 0.2400 | 35.3050 | 109250.00 | 0.00 | 109250.00 | 4750 | 49 | 9049 | 15634 | 0.578802609696815 | 0.250922508738578 | 0.250922508738578 | false | false | false | true | ||||||||||||||||
| 5bf5d2b3-d156-4bad-87ab-6a97f98f7adc | 2026-08-28 10:23 | 2026-08-28 10:23 | 2026-08-28 10:23 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.2400 | 0.2300 | 0.2400 | 35.2900 | 14088.00 | 14088.00 | 0.00 | 587 | 31 | 9752 | 15634 | 0.623768709223487 | 0.259447011153194 | 0.259447011153194 | false | false | false | true | ||||||||||||||||
| fe391a5a-9c13-4e29-b714-cfa18e39dc2e | 2026-08-28 10:27 | 2026-08-28 10:27 | 2026-08-28 10:27 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.2500 | 0.2300 | 0.2500 | 35.2900 | 19550.00 | 19550.00 | 0.00 | 782 | 8 | 11560 | 15634 | 0.739414097479852 | 0.2652883390377 | 0.2652883390377 | false | false | false | true | ||||||||||||||||
| 27b80f65-d2bf-41c7-9328-f27cc3d6746b | 2026-08-28 10:40 | 2026-08-28 10:40 | 2026-08-28 10:40 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.2500 | 0.2500 | 0.2600 | 35.3200 | 163825.00 | 0.00 | 163825.00 | 6553 | 14 | 18308 | 15634 | 1.17103748241013 | 0.259903260591441 | 0.259903260591441 | false | false | false | true | ||||||||||||||||
| 8e5301ce-aae4-405a-9373-7c019c38ec16 | 2026-09-01 09:40 | 2026-09-01 09:39 | 2026-09-01 09:39 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.6800 | 0.6600 | 0.6900 | 36.3850 | 20944.00 | 2992.00 | 17952.00 | 308 | 20 | 331 | 13475 | 0.0245640074211503 | 0.347337145663862 | 0.347337145663862 | false | false | false | true | ||||||||||||||||
| 15bfc180-d31f-473f-b629-0c5a12876f96 | 2026-09-01 09:51 | 2026-09-01 09:51 | 2026-09-01 09:51 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.6900 | 0.6900 | 0.7300 | 36.4450 | 11109.00 | 0.00 | 11109.00 | 161 | 25 | 1205 | 13475 | 0.0894248608534323 | 0.323123073389554 | 0.323123073389554 | false | false | false | true | ||||||||||||||||
| 4e24671c-22a3-4d2e-ba7e-27f09b1179b0 | 2026-09-01 09:52 | 2026-09-01 09:52 | 2026-09-01 09:52 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.6900 | 0.6800 | 0.7200 | 36.4400 | 26220.00 | 0.00 | 26220.00 | 380 | 9 | 1696 | 13475 | 0.125862708719852 | 0.325925113590722 | 0.325925113590722 | false | false | false | true | ||||||||||||||||
| a20cc56b-42ff-4fb1-9979-572d7ee0054d | 2026-09-01 09:54 | 2026-09-01 09:54 | 2026-09-01 09:54 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.7200 | 0.7000 | 0.7400 | 36.4800 | 10008.00 | 0.00 | 1584.00 | 139 | 6 | 2171 | 13475 | 0.161113172541744 | 0.328449854807565 | 0.328449854807565 | false | false | false | true | ||||||||||||||||
| d517bc75-dc3e-4a12-9917-4f03444139af | 2026-09-01 09:54 | 2026-09-01 09:54 | 2026-09-01 09:54 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.7200 | 0.7200 | 0.7300 | 36.4800 | 18576.00 | 0.00 | 18576.00 | 258 | 13 | 2437 | 13475 | 0.180853432282004 | 0.328449854807565 | 0.328449854807565 | false | false | false | true | ||||||||||||||||
| 3cc28e37-1c93-4a2b-a105-9ef43556d47a | 2026-09-01 09:56 | 2026-09-01 09:55 | 2026-09-01 09:55 | EWZ | EWZ260904C00036000 | call | 36.0000 | 2026-09-04 | 0.7300 | 0.7300 | 0.7600 | 36.5200 | 11680.00 | 0.00 | 11680.00 | 160 | 13 | 3587 | 13475 | 0.266196660482375 | 0.313295266593763 | 0.313295266593763 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T19:21:53.483381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:38:22.875878Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:38:22.875878Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:54:23.998586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:44:23.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:00:27.391289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:00:27.391289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:00:27.391289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:00:27.391289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:00:27.391289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |