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 | 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 |
|---|
| 3118dfb2-64ff-47b6-bcd6-a23bab3567eb | 2026-09-16 15:49 | 2026-09-16 15:49 | 2026-09-16 15:49 | EC | EC270219P00019000 | put | 19.0000 | 2027-02-19 | 2.6000 | 2.3000 | 2.6000 | 17.0000 | 10400.00 | 10400.00 | 0.00 | 40 | 5 | 80 | 0 | 0 | 0.415437024817549 | 0.415437024817549 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 35894874456.00 | 2026-11-10 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 6377cf2a-6269-4100-b855-8c22d24d6669 | 2026-09-15 11:05 | 2026-09-15 11:05 | 2026-09-15 11:05 | EC | EC270219C00020000 | call | 20.0000 | 2027-02-19 | 1.2500 | 1.0500 | 1.2500 | 18.0000 | 19375.00 | 2125.00 | 0.00 | 155 | 24 | 177 | 437 | 0.405034324942792 | 0.386849902991759 | 0.386849902991759 | false | false | false | |||||||||||||||||
| d442fa0e-6eb1-4dde-9866-6a328f81842a | 2026-09-03 12:30 | 2026-09-03 12:30 | 2026-09-03 12:30 | EC | EC261120P00018000 | put | 18.0000 | 2026-11-20 | 1.7000 | 1.5500 | 1.7000 | 17.2300 | 11560.00 | 11560.00 | 0.00 | 68 | 5 | 68 | 492 | 0.138211382113821 | 0.423562935183737 | 0.423562935183737 | false | false | false | |||||||||||||||||
| 890d0cfb-acce-435a-a7fe-a62ecc22e19f | 2026-09-02 14:54 | 2026-09-02 14:54 | 2026-09-02 14:54 | EC | EC270219C00018000 | call | 18.0000 | 2027-02-19 | 1.8000 | 1.6500 | 1.8500 | 17.5700 | 10440.00 | 9000.00 | 1440.00 | 58 | 5 | 58 | 306 | 0.189542483660131 | 0.386459763795961 | 0.386459763795961 | false | false | false | |||||||||||||||||
| d5f1e577-f7dc-4272-911a-9ff87e28364c | 2026-09-01 15:29 | 2026-09-01 15:29 | 2026-09-01 15:29 | EC | EC261120P00018000 | put | 18.0000 | 2026-11-20 | 1.6000 | 1.4500 | 1.6000 | 17.4600 | 11200.00 | 11200.00 | 0.00 | 70 | 13 | 431 | 60 | 7.18333333333333 | 0.424819341372854 | 0.424819341372854 | false | false | false | |||||||||||||||||
| 90ca8892-4101-443c-a851-976468850e70 | 2026-09-01 14:19 | 2026-09-01 14:19 | 2026-09-01 14:19 | EC | EC261120P00018000 | put | 18.0000 | 2026-11-20 | 1.5500 | 1.4500 | 1.6500 | 17.5350 | 10385.00 | 6510.00 | 3875.00 | 67 | 9 | 346 | 60 | 5.76666666666667 | 0.421000861833528 | 0.421000861833528 | false | false | false | |||||||||||||||||
| 509c7e4c-2f00-4e99-8120-5f977c9d9b6e | 2026-08-27 11:19 | 2026-08-27 11:19 | 2026-08-27 11:19 | EC | EC261016C00017000 | call | 17.0000 | 2026-10-16 | 0.6500 | 0.6500 | 0.7000 | 16.4000 | 22230.00 | 0.00 | 22230.00 | 342 | 33 | 342 | 2 | 171 | 0.359071792317515 | 0.359071792317515 | false | false | false | |||||||||||||||||
| 50c84df4-5ae3-406a-94c0-70e6747c4ac0 | 2026-08-24 15:33 | 2026-08-24 15:33 | 2026-08-24 15:33 | EC | EC261120C00015000 | call | 15.0000 | 2026-11-20 | 2.8000 | 2.5000 | 2.9000 | 17.3200 | 16800.00 | 1960.00 | 14840.00 | 60 | 7 | 64 | 1267 | 0.0505130228887135 | 0.37751559786389 | 0.37751559786389 | false | false | false | |||||||||||||||||
| 1076699e-df00-4c60-8dbb-5d13f8586a52 | 2026-08-19 11:22 | 2026-08-19 11:21 | 2026-08-19 11:21 | EC | EC270219C00019000 | call | 19.0000 | 2027-02-19 | 1.8000 | 1.7500 | 2.0500 | 18.0700 | 16380.00 | 0.00 | 16380.00 | 91 | 20 | 144 | 120 | 1.2 | 0.398567440207711 | 0.398567440207711 | false | false | false | |||||||||||||||||
| a8d5ae34-2ce1-4326-938d-63dbf872cea0 | 2026-08-17 14:54 | 2026-08-17 14:54 | 2026-08-17 14:54 | EC | EC270219C00018000 | call | 18.0000 | 2027-02-19 | 2.0500 | 1.8000 | 2.1000 | 17.6950 | 14350.00 | 10250.00 | 3895.00 | 70 | 6 | 90 | 208 | 0.432692307692308 | 0.403210207028303 | 0.403210207028303 | false | false | false | |||||||||||||||||
| e37b3ab9-04af-4670-866b-4ba5f2947fa3 | 2026-08-17 13:49 | 2026-08-17 13:49 | 2026-08-17 13:49 | EC | EC260918C00018000 | call | 18.0000 | 2026-09-18 | 0.6500 | 0.5500 | 0.6500 | 17.0000 | 18719.00 | 18719.00 | 0.00 | 288 | 16 | 344 | 891 | 0.386083052749719 | 0.383846865223485 | 0.379010028742517 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 36470508181.00 |
| 2026-11-10 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:09:54.469160Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 36470508181.00 |
| 2026-11-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 36470508181.00 |
| 2026-11-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:08:56.003529Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 36470508181.00 |
| 2026-11-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T19:44:53.190071Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 36470508181.00 |
| 2026-11-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:40:09.958238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 36470508181.00 |
| 2026-11-10 |
| unknown |
| — |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 36470508181.00 |
| 2026-11-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:47:47.207382Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 36470508181.00 |
| 2026-11-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 36470508181.00 |
| 2026-11-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 36470508181.00 |
| 2026-11-10 |
| 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 |