PREVIEW / futures_daily / 2022-07-28
file: by_date/futures_daily/2022/2022-07-28.parquet size: 10 KB rows: 126
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2022-07-28 | ES | Futures | 4511.91 | 4611.75 | 4481.06 | 4569.68 | 2014467.0 |
| 2022-07-28 | NQ | Futures | 14364.66 | 14784.86 | 14215.07 | 14544.5 | 645261.0 |
| 2022-07-28 | YM | Futures | 35145.1 | 35653.5 | 34926.4 | 35523.4 | 206840.0 |
| 2022-07-28 | CL | Futures | 83.23 | 84.65 | 81.43 | 81.75 | 318403.0 |
| 2022-07-28 | GC | Futures | 2004.3 | 2030.6 | 2003.2 | 2024.7 | 192863.0 |
| 2022-07-28 | ZN | Futures | 123.386901 | 124.688247 | 123.113779 | 124.399059 | 1861248.0 |
| 2022-07-28 | A6 | Futures | 0.71674 | 0.71905 | 0.71306 | 0.7149 | 97376.0 |
| 2022-07-28 | AD | Futures | 0.79079 | 0.79262 | 0.788 | 0.79084 | 90715.0 |
| 2022-07-28 | ALI | Futures | 2744.66 | 2802.31 | 2739.03 | 2757.59 | 558.0 |
| 2022-07-28 | B | Futures | 86.78 | 88.35 | 85.61 | 86.34 | 306963.0 |
| 2022-07-28 | B6 | Futures | 1.2349 | 1.2384 | 1.2293 | 1.2341 | 116502.0 |
| 2022-07-28 | BR | Futures | 0.16469 | 0.16956 | 0.16335 | 0.16665 | 10903.0 |
| 2022-07-28 | BTC | Futures | 31571.0 | 33685.0 | 31280.9 | 33056.3 | 8974.0 |
| 2022-07-28 | BZ | Futures | 85.09 | 86.43 | 83.73 | 84.47 | 22908.0 |
| 2022-07-28 | C | Futures | 1307.0 | 1316.0 | 1275.0 | 1277.0 | 7880.0 |
| 2022-07-28 | CB | Futures | 226.024 | 226.809 | 224.412 | 224.412 | 10.0 |
| 2022-07-28 | CC | Futures | 1423.0 | 1429.0 | 1382.0 | 1385.0 | 24415.0 |
| 2022-07-28 | CNH | Futures | 6.3581 | 6.367 | 6.3558 | 6.3581 | 284.0 |
| 2022-07-28 | CSC | Futures | 2.743 | 2.743 | 2.663 | 2.687 | 118.0 |
| 2022-07-28 | CT | Futures | 127.59 | 130.39 | 127.59 | 129.78 | 36.0 |
| 2022-07-28 | DC | Futures | 26.04 | 26.11 | 25.37 | 25.55 | 790.0 |
| 2022-07-28 | DX | Futures | 102.509 | 103.074 | 102.181 | 102.481 | 39034.0 |
| 2022-07-28 | E1 | Futures | 1.15671 | 1.16279 | 1.15229 | 1.1618 | 39012.0 |
| 2022-07-28 | E6 | Futures | 1.07651 | 1.08024 | 1.06751 | 1.07409 | 267290.0 |
| 2022-07-28 | E7 | Futures | 1.0703 | 1.0737 | 1.0611 | 1.0677 | 10556.0 |
| 2022-07-28 | EBM | Futures | 481.98 | 487.59 | 477.43 | 478.48 | 11864.0 |
| 2022-07-28 | ED | Futures | 94.9857 | 95.0594 | 94.9759 | 95.0447 | 118959.0 |
| 2022-07-28 | ER | Futures | 98.164 | 98.352 | 98.114 | 98.277 | 181944.0 |
| 2022-07-28 | ESG | Futures | 388.46 | 394.46 | 386.75 | 394.12 | 397.0 |
| 2022-07-28 | EW | Futures | 2664.8 | 2712.7 | 2644.3 | 2701.9 | 9891.0 |
| 2022-07-28 | FBON | Futures | 132.24 | 134.74 | 131.98 | 134.67 | 196.0 |
| 2022-07-28 | FBTP | Futures | 114.76 | 116.8 | 114.28 | 116.65 | 142821.0 |
| 2022-07-28 | FBTS | Futures | 106.803 | 107.414 | 106.734 | 107.374 | 73589.0 |
| 2022-07-28 | FCE | Futures | 6916.7 | 7012.7 | 6843.7 | 6957.3 | 55647.0 |
| 2022-07-28 | FDAX | Futures | 14211.6 | 14366.5 | 14080.3 | 14291.2 | 56936.0 |
| 2022-07-28 | FDXM | Futures | 14300.6 | 14448.9 | 14166.3 | 14378.5 | 38172.0 |
| 2022-07-28 | FDXS | Futures | 14194.8 | 14329.1 | 14050.9 | 14261.4 | 33658.0 |
| 2022-07-28 | FESX | Futures | 3594.4 | 3643.0 | 3560.7 | 3618.2 | 739383.0 |
| 2022-07-28 | FEU3 | Futures | 98.15 | 98.219 | 98.14 | 98.185 | 82.0 |
| 2022-07-28 | FGBL | Futures | 153.71 | 155.9 | 152.72 | 155.83 | 809485.0 |
| 2022-07-28 | FGBM | Futures | 128.76 | 130.08 | 128.32 | 130.05 | 642635.0 |
| 2022-07-28 | FGBS | Futures | 111.634 | 112.071 | 111.471 | 112.04 | 686728.0 |
| 2022-07-28 | FGBX | Futures | 183.31 | 188.6 | 181.39 | 188.29 | 70236.0 |
| 2022-07-28 | FMWO | Futures | 9603.5 | 9727.6 | 9541.5 | 9651.5 | 6216.0 |
| 2022-07-28 | FOAT | Futures | 140.8 | 142.64 | 140.1 | 142.54 | 177935.0 |
| 2022-07-28 | FSMX | Futures | 28565.8 | 28688.8 | 28440.8 | 28594.7 | 239.0 |
| 2022-07-28 | FTDX | Futures | 3263.0 | 3281.7 | 3236.2 | 3281.7 | 54.0 |
| 2022-07-28 | FTI | Futures | 724.3 | 731.9 | 718.78 | 727.85 | 19092.0 |
| 2022-07-28 | FTUK | Futures | 7423.9 | 7453.3 | 7358.5 | 7396.5 | 81026.0 |
| 2022-07-28 | FVSA | Futures | 73.62 | 74.46 | 69.43 | 70.83 | 20816.0 |
> showing 50 of 126 rows — these rows as CSV