uw_flow_alerts728,802 rows| 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 |
|---|
| 5f766549-40a3-4ffd-88ea-5327715f6847 | 2026-10-01 11:06 | 2026-10-01 11:06 | 2026-10-01 11:06 | DHT | DHT261016C00024000 | call | 24.0000 | 2026-10-16 | 0.7500 | 0.7500 | 0.8500 | 23.4400 | 18261.00 | 0.00 | 17781.00 | 243 | 25 | 722 | 16602 | 0.0434887362968317 | 0.542640760801678 | 0.515962387050848 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 3788434029.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-01T15:07:32.032853Z"} | 2026-10-01 | 2026-10-01 21:15 | 2026-10-01 21:15 |
| 118db5de-8fc8-4770-8b50-d4f9bcc61a02 | 2026-10-01 11:06 | 2026-10-01 11:06 | 2026-10-01 11:06 | DHT | DHT261016C00024000 | call | 24.0000 | 2026-10-16 | 0.7500 | 0.7500 | 0.8000 | 23.4200 | 16650.00 | 0.00 | 16650.00 | 222 | 17 | 944 | 16602 | 0.0568606192025057 | 0.520626508793051 | 0.520626508793051 | false | false | false | true | ||||||||||||||||
| 8ce9a1c3-84ca-4e5a-8bb8-93ea81469cdc | 2026-10-01 11:06 | 2026-10-01 11:06 | 2026-10-01 11:06 | DHT | DHT261016C00024000 | call | 24.0000 | 2026-10-16 | 0.8000 | 0.8000 | 0.8500 | 23.4350 | 15200.00 | 0.00 | 15200.00 | 190 | 20 | 479 | 16602 | 0.0288519455487291 | 0.540279973511317 | 0.543819695848181 | false | false | false | true | ||||||||||||||||
| 45333e35-0fef-4d68-8b9e-1a46d71e9aa4 | 2026-10-01 11:06 | 2026-10-01 11:06 | 2026-10-01 11:06 | DHT | DHT261016C00024000 | call | 24.0000 | 2026-10-16 | 0.8000 | 0.8000 | 0.8500 | 23.4700 | 18880.00 | 0.00 | 18880.00 | 236 | 30 | 289 | 16602 | 0.0174075412600891 | 0.53554654196541 | 0.53554654196541 | false | false | false | true | ||||||||||||||||
| d70a5130-5117-4cee-9881-6f8d1017f9a2 | 2026-09-16 10:29 | 2026-09-16 10:29 | 2026-09-16 10:29 | DHT | DHT261016C00024000 | call | 24.0000 | 2026-10-16 | 1.0800 | 1.0000 | 1.1000 | 23.0000 | 40129.00 | 32359.00 | 1785.00 | 372 | 27 | 2119 | 14431 | 0.146836671055367 | 0.52998333043793 | 0.53044368840562 | false | false | false | true | ||||||||||||||||
| a22a41aa-638a-4ccd-82cc-e0ae80f7d09d | 2026-09-16 10:29 | 2026-09-16 10:29 | 2026-09-16 10:29 | DHT | DHT261016C00024000 | call | 24.0000 | 2026-10-16 | 1.0300 | 0.9500 | 1.0500 | 23.0000 | 43385.00 | 30885.00 | 12500.00 | 422 | 29 | 1555 | 14431 | 0.107754140392211 | 0.514143577308495 | 0.514143577308495 | false | false | false | true | ||||||||||||||||
| 8a8b77de-2d56-4e7f-bf53-689b045654be | 2026-09-16 10:29 | 2026-09-16 10:28 | 2026-09-16 10:28 | DHT | DHT261016C00024000 | call | 24.0000 | 2026-10-16 | 1.0000 | 0.9500 | 1.0500 | 23.0000 | 38900.00 | 21400.00 | 17300.00 | 389 | 18 | 1044 | 14431 | 0.072344258887118 | 0.516635988481005 | 0.51164749199416 | true | false | false | true | ||||||||||||||||
| dad51fb7-4063-4c6a-b7d8-0b45961a0140 | 2026-09-16 10:20 | 2026-09-16 10:20 | 2026-09-16 10:20 | DHT | DHT261016C00024000 | call | 24.0000 | 2026-10-16 | 0.9500 | 0.9000 | 0.9500 | 23.0000 | 43603.00 | 43603.00 | 0.00 | 459 | 35 | 520 | 14431 | 0.0360335389092925 | 0.502306736677693 | 0.49984410905109 | false | false | false | true | ||||||||||||||||
| ce59b079-d299-47a9-a2db-cf7a3e3458db | 2026-09-11 13:07 | 2026-09-11 13:06 | 2026-09-11 13:06 | DHT | DHT261016C00024000 | call | 24.0000 | 2026-10-16 | 0.6000 | 0.6000 | 0.6500 | 22.0950 | 25145.00 | 0.00 | 25145.00 | 419 | 38 | 5090 | 668 | 7.61976047904192 | 0.462357178770607 | 0.462357178770607 | true | false | false | true | ||||||||||||||||
| b5fab6cd-a9e3-43a3-b608-f8e1a291fbc7 | 2026-09-11 12:46 | 2026-09-11 12:46 | 2026-09-11 12:46 | DHT | DHT261016C00024000 | call | 24.0000 | 2026-10-16 | 0.6500 | 0.6000 | 0.7000 | 22.2450 | 16056.00 | 0.00 | 15471.00 | 247 | 47 | 4522 | 668 | 6.76946107784431 | 0.462893761986708 | 0.462893761986708 | true | false | false | true | ||||||||||||||||
| 656c8d62-88e8-4a80-bf98-ed13f69e9dce | 2026-09-11 12:16 | 2026-09-11 12:16 | 2026-09-11 12:16 | DHT | DHT261016C00024000 | call | 24.0000 | 2026-10-16 | 0.6500 | 0.6000 | 0.7000 | 22.1750 | 19500.00 | 0.00 | 19370.00 | 300 | 17 | 3915 | 668 | 5.86077844311377 | 0.472189685727636 | 0.472189685727636 | true | false | false | true | ||||||||||||||||
| 65acd27a-28d0-4d78-863a-a55a4573d1cf | 2026-09-11 12:11 | 2026-09-11 12:11 | 2026-09-11 12:11 | DHT | DHT261016C00024000 | call | 24.0000 | 2026-10-16 | 0.6500 | 0.6000 | 0.7000 | 22.1400 | 16250.00 | 0.00 | 16185.00 | 250 | 6 | 3158 | 668 | 4.72754491017964 | 0.476825513710783 | 0.476825513710783 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3788434029.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T15:07:32.032853Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3788434029.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T15:07:32.032853Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3788434029.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T15:07:32.032853Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 3704818337.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 3704818337.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3704818337.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3704818337.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 3561706865.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T17:27:08.545704Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3561706865.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3561706865.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:20:29.379987Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3561706865.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:20:29.379987Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |