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 |
|---|
| 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 |
|---|
| acb43e3c-bf62-4c51-82a9-b1c1a15fb37b | 2026-09-22 12:18 | 2026-09-22 12:18 | 2026-09-22 12:18 | LYB | LYB261016P00060000 | put | 60.0000 | 2026-10-16 | 2.2500 | 2.1500 | 2.3000 | 60.4250 | 22510.00 | 22510.00 | 0.00 | 100 | 7 | 457 | 2366 | 0.193153000845309 | 0.411448616470143 | 0.411448616470143 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 19136768276.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T16:20:35.100506Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| ce64570d-dcdd-4c4b-833f-838b634d2aa1 | 2026-09-18 09:57 | 2026-09-18 09:57 | 2026-09-18 09:57 | LYB | LYB261218C00065000 | call | 65.0000 | 2026-12-18 | 4.3200 | 4.1000 | 4.7000 | 62.9700 | 10790.00 | 1720.00 | 8210.00 | 25 | 7 | 27 | 971 | 0.0278063851699279 | 0.390673653500691 | 0.394659988697414 | true | false | false | |||||||||||||||||
| 66edce4b-cea7-4a75-9989-272f1ef5f7b0 | 2026-09-17 11:11 | 2026-09-17 11:11 | 2026-09-17 11:11 | LYB | LYB261016C00067500 | call | 67.5000 | 2026-10-16 | 1.7400 | 1.4500 | 1.7500 | 64.0000 | 17416.00 | 17416.00 | 0.00 | 100 | 5 | 301 | 1199 | 0.251042535446205 | 0.42036927333125 | 0.42036927333125 | false | false | false | |||||||||||||||||
| b44cedec-66fb-4e9e-89c4-72e0221e9c3d | 2026-09-17 11:11 | 2026-09-17 11:10 | 2026-09-17 11:10 | LYB | LYB261016C00067500 | call | 67.5000 | 2026-10-16 | 1.7000 | 1.4500 | 1.7500 | 63.9250 | 17047.00 | 17047.00 | 0.00 | 100 | 10 | 101 | 1199 | 0.0842368640533778 | 0.419879776929704 | 0.419879776929704 | false | false | false | |||||||||||||||||
| 0afeff71-d8c4-4ac4-867b-0013d67474ae | 2026-09-16 14:31 | 2026-09-16 14:31 | 2026-09-16 14:31 | LYB | LYB261016C00067500 | call | 67.5000 | 2026-10-16 | 2.0800 | 1.9000 | 2.1500 | 64.7800 | 20756.00 | 20756.00 | 0.00 | 100 | 10 | 808 | 492 | 1.64227642276423 | 0.419388358585286 | 0.419388358585286 | false | false | false | |||||||||||||||||
| d74a08df-a85f-45e6-b0f5-5bb7554829ea | 2026-09-16 12:36 | 2026-09-16 12:36 | 2026-09-16 12:36 | LYB | LYB261016P00060000 | put | 60.0000 | 2026-10-16 | 1.2600 | 1.1000 | 1.3500 | 64.6300 | 12572.00 | 12572.00 | 0.00 | 100 | 6 | 102 | 1304 | 0.0782208588957055 | 0.433221044533035 | 0.433221044533035 | false | false | false | |||||||||||||||||
| 6aa97115-a593-4a1d-b772-485c8593824a | 2026-09-01 11:09 | 2026-09-01 11:09 | 2026-09-01 11:09 | LYB | LYB260918C00070000 | call | 70.0000 | 2026-09-18 | 0.7000 | 0.5000 | 0.7000 | 65.0300 | 34998.00 | 34998.00 | 0.00 | 500 | 5 | 522 | 4125 | 0.126545454545455 | 0.404935894484447 | 0.409754707264674 | false | false | false | |||||||||||||||||
| 86f7c9a5-7b35-4cc0-bb13-1ca96faaa1b8 | 2026-08-31 09:54 | 2026-08-31 09:54 | 2026-08-31 09:54 | LYB | LYB270617C00075000 | call | 75.0000 | 2027-06-17 | 6.1700 | 6.1000 | 6.9000 | 65.8445 | 61650.00 | 0.00 | 52500.00 | 100 | 5 | 100 | 73 | 1.36986301369863 | 0.370424806197796 | 0.376021147460397 | false | false | false | |||||||||||||||||
| 59a3223b-436c-42fd-9c8a-f166babb4cb8 | 2026-08-28 13:30 | 2026-08-28 13:30 | 2026-08-28 13:30 | LYB | LYB271217P00055000 | put | 55.0000 | 2027-12-17 | 7.3500 | 7.2000 | 7.6000 | 63.2250 | 24990.00 | 0.00 | 23510.00 | 34 | 8 | 57 | 290 | 0.196551724137931 | 0.466347398337867 | 0.470582217339729 | false | false | false | |||||||||||||||||
| 4f8bb1bb-cfc2-4bd6-96af-f57aa8e2a066 | 2026-08-25 11:51 | 2026-08-25 11:51 | 2026-08-25 11:51 | LYB | LYB260918P00057500 | put | 57.5000 | 2026-09-18 | 0.6400 | 0.5500 | 0.6500 | 63.4450 | 102399.00 | 102399.00 | 0.00 | 1600 | 7 | 1630 | 3163 | 0.515333544103699 | 0.425205684145389 | 0.425205684145389 | false | false | false | |||||||||||||||||
| 5f933633-e512-47f6-937e-dc91c923fe5d | 2026-08-20 15:55 | 2026-08-20 15:54 | 2026-08-20 15:54 | LYB | LYB260918C00072500 | call | 72.5000 | 2026-09-18 | 1.3200 | 1.2500 | 1.3500 | 68.2150 | 13026.00 | 1430.00 | 11596.00 | 99 | 5 | 535 | 1400 | 0.382142857142857 | 0.366331016126814 | 0.36906982685425 | false | false | false | |||||||||||||||||
| d0257333-11d0-48c5-919b-34ada5c653a1 | 2026-08-19 11:23 | 2026-08-19 11:23 | 2026-08-19 11:23 | LYB | LYB260821C00062500 | call | 62.5000 | 2026-08-21 | 4.7000 | 4.6000 | 4.9000 | 67.1300 | 94004.00 | 10340.00 | 83664.00 | 200 | 16 | 657 | 2369 | 0.277332207682567 | 0.61816811980445 | 0.622629649250074 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20005740367.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20755188416.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20755188416.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20965163085.00 |
| 2026-10-30 |
| unknown |
| — |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20965163085.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20270631488.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T15:18:08.991662Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20270631488.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:02:22.723941Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20270631488.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T17:47:47.104019Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20270631488.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20270631488.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:59:19.634890Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20270631488.00 |
| 2026-10-30 |
| 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 |