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_alerts658,639 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 | strike |
|---|
| 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 |
|---|
| 308671d1-7581-4877-ac0d-4de0d56521d0 | 2026-10-01 15:39 | 2026-10-01 15:39 | 2026-10-01 15:39 | EEM | EEM261120C00067000 | call | 67.0000 | 2026-11-20 | 2.4300 | 2.3900 | 2.4800 | 66.8000 | 121500.00 | 0.00 | 121500.00 | 500 | 2 | 4043 | 1561 | 2.5900064061499 | 0.237489992031458 | 0.237489992031458 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 31071398449.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-01T19:42:36.719976Z"} | 2026-10-01 | 2026-10-01 21:15 | 2026-10-01 21:15 |
| 201bf979-0207-4bf8-b836-0215b866aa35 | 2026-09-18 11:35 | 2026-09-18 11:35 | 2026-09-18 11:35 | EEM | EEM261016C00071500 | call | 71.5000 | 2026-10-16 | 0.3000 | 0.2500 | 0.3400 | 66.6850 | 72150.00 | 72150.00 | 0.00 | 2405 | 1 | 2407 | 10370 | 0.232111861137898 | 0.222340179428164 | 0.222340179428164 | false | true | false | |||||||||||||||||
| faf8c468-14e6-4cf2-bfaa-58f119af5623 | 2026-09-17 14:36 | 2026-09-17 14:36 | 2026-09-17 14:36 | EEM | EEM260918P00071000 | put | 71.0000 | 2026-09-18 | 3.8500 | 3.8500 | 4.1000 | 66.9759 | 1315160.00 | 0.00 | 1315160.00 | 3416 | 2 | 3416 | 4009 | 0.852082813669244 | 0.752610424070475 | 0.752610424070475 | false | true | true | |||||||||||||||||
| 3ce515f7-df13-403b-ae96-e1740ff8115e | 2026-09-14 15:08 | 2026-09-14 15:08 | 2026-09-14 15:08 | EEM | EEM260918C00067000 | call | 67.0000 | 2026-09-18 | 0.5000 | 0.4600 | 0.5200 | 66.2900 | 200000.00 | 200000.00 | 0.00 | 4000 | 1 | 8155 | 22348 | 0.364909611598353 | 0.285697680380957 | 0.285697680380957 | false | true | false | |||||||||||||||||
| 85dc94d7-2da8-4265-b5b4-9601388f554a | 2026-09-14 13:44 | 2026-09-14 13:44 | 2026-09-14 13:44 | EEM | EEM260918C00067000 | call | 67.0000 | 2026-09-18 | 0.5200 | 0.5100 | 0.5400 | 66.3850 | 208000.00 | 0.00 | 208000.00 | 4000 | 1 | 4153 | 22348 | 0.185833184177555 | 0.279625634098899 | 0.279625634098899 | false | true | false | |||||||||||||||||
| 08624a75-4c55-4b4a-ac9c-be51d613bfb6 | 2026-09-01 10:35 | 2026-09-01 10:35 | 2026-09-01 10:35 | EEM | EEM261218C00070000 | call | 70.0000 | 2026-12-18 | 2.4200 | 2.2700 | 2.5600 | 67.3000 | 605000.00 | 605000.00 | 0.00 | 2500 | 2 | 2500 | 71558 | 0.034936694709187 | 0.221390122998136 | 0.221390122998136 | false | true | true | |||||||||||||||||
| 26540c16-3f03-4803-ac42-601da35f40fa | 2026-09-01 09:45 | 2026-09-01 09:45 | 2026-09-01 09:45 | EEM | EEM261016P00057000 | put | 57.0000 | 2026-10-16 | 0.2500 | 0.1500 | 0.4100 | 67.2000 | 875000.00 | 0.00 | 875000.00 | 35000 | 1 | 35000 | 10376 | 3.37316885119507 | 0.337178550886342 | 0.337178550886342 | false | true | false | |||||||||||||||||
| 74161bf1-e420-4bd9-9a93-6b8dca60dda8 | 2026-09-01 09:45 | 2026-09-01 09:45 | 2026-09-01 09:45 | EEM | EEM261120P00057000 | put | 57.0000 | 2026-11-20 | 0.5500 | 0.2700 | 0.7600 | 67.1800 | 1650000.00 | 1650000.00 | 0.00 | 30000 | 1 | 30000 | 2241 | 13.3868808567604 | 0.317008169193905 | 0.317008169193905 | false | true | false | |||||||||||||||||
| a59fc9f5-f57a-4c0a-ac89-9db19d3cd681 | 2026-08-24 10:47 | 2026-08-24 10:47 | 2026-08-24 10:47 | EEM | EEM270319P00065000 | put | 65.0000 | 2027-03-19 | 4.1800 | 3.6000 | 4.6000 | 66.0500 | 2090000.00 | 2090000.00 | 0.00 | 5000 | 2 | 5000 | 46322 | 0.107940071672208 | 0.27512718628852 | 0.27512718628852 | false | true | true | |||||||||||||||||
| ea0dfe3d-4812-4616-a261-264f2bb76e1a | 2026-08-18 14:37 | 2026-08-18 14:36 | 2026-08-18 14:36 | EEM | EEM260821C00067000 | call | 67.0000 | 2026-08-21 | 0.1200 | 0.1100 | 0.1500 | 65.4100 | 50004.00 | 0.00 | 50004.00 | 4167 | 1 | 4204 | 17147 | 0.245174082929959 | 0.253987208498848 | 0.253987208498848 | false | true | false | |||||||||||||||||
| a63f694c-d91a-4b75-90aa-b32eea0bafcc | 2026-08-18 14:37 | 2026-08-18 14:36 | 2026-08-18 14:36 | EEM | EEM260821C00066000 | call | 66.0000 | 2026-08-21 | 0.3800 | 0.3300 | 0.3800 | 65.4100 | 50008.00 | 50008.00 | 0.00 | 1316 | 1 | 1524 | 3829 | 0.398015147558109 | 0.262547966021184 | 0.262547966021184 | false | true | false | |||||||||||||||||
| cf7697b6-e349-4eba-95cd-6dcdc88d91f2 | 2026-08-17 11:06 | 2026-08-17 11:06 | 2026-08-17 11:06 | EEM | EEM261016P00058000 | put | 58.0000 | 2026-10-16 | 0.4900 | 0.2300 | 0.6500 | 67.9300 | 2450000.00 | 2450000.00 | 0.00 | 50000 | 1 | 50000 | 6861 | 7.28756740999854 | 0.339742755751936 | 0.339742755751936 | false | true | false | |||||||||||||||||
| 1f42bb91-7f32-4014-a6a9-1da636b7375b | 2026-08-17 10:08 | 2026-08-17 10:08 | 2026-08-17 10:08 | EEM | EEM260821C00068000 | call | 68.0000 | 2026-08-21 | 0.4900 | 0.2900 | 0.5800 | 67.5050 | 49000.00 | 49000.00 | 0.00 | 1000 | 2 | 1000 | 25068 | 0.0398914951332376 | 0.246993067911436 | 0.246993067911436 | false | true | true |
| true |
| false |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 31139277742.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 30606476518.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| true |
| false |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 31584444876.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 31584444876.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| false |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 2 |
| ETF |
| — |
| 30829842863.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| true |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 30829842863.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 |
| true |
| true |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 30829842863.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 |
| false |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 30829842863.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 30829842863.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:49:07.657249Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 30829842863.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:49:07.657249Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| true |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 30829842863.00 |
| — |
| — |
| — |
| 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 |
| false |
| false |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 30829842863.00 |
| — |
| — |
| — |
| 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 |