PREVIEW / futures_daily / 2010-12-27
file: by_date/futures_daily/2010/2010-12-27.parquet size: 8 KB rows: 85
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-27 | ES | Futures | 1229.91 | 1234.59 | 1225.98 | 1233.6 | 587701.0 |
| 2010-12-27 | NQ | Futures | 2528.61 | 2536.27 | 2505.9 | 2531.73 | 139752.0 |
| 2010-12-27 | YM | Futures | 10762.2 | 10768.8 | 10719.2 | 10766.0 | 32652.0 |
| 2010-12-27 | CL | Futures | 186.63 | 188.29 | 185.48 | 186.49 | 104321.0 |
| 2010-12-27 | GC | Futures | 1874.3 | 1885.3 | 1865.9 | 1879.7 | 44354.0 |
| 2010-12-27 | ZN | Futures | 99.412665 | 99.906609 | 98.996713 | 99.776624 | 271548.0 |
| 2010-12-27 | A6 | Futures | 0.84113 | 0.8447 | 0.83605 | 0.84317 | 25930.0 |
| 2010-12-27 | AD | Futures | 0.98252 | 0.9851 | 0.98004 | 0.98371 | 18229.0 |
| 2010-12-27 | B | Futures | 79.62 | 80.3 | 79.14 | 79.79 | 20329.0 |
| 2010-12-27 | B6 | Futures | 1.6001 | 1.6025 | 1.5934 | 1.597 | 31754.0 |
| 2010-12-27 | BFX | Futures | 3003.2 | 3003.2 | 2958.2 | 2995.0 | 427.0 |
| 2010-12-27 | BR | Futures | 0.25132 | 0.25216 | 0.25095 | 0.25216 | 139.0 |
| 2010-12-27 | BZ | Futures | 84.81 | 84.99 | 84.81 | 84.99 | 148.0 |
| 2010-12-27 | CC | Futures | 2451.0 | 2475.0 | 2439.0 | 2467.0 | 2066.0 |
| 2010-12-27 | CT | Futures | 126.16 | 126.16 | 121.87 | 124.99 | 7893.0 |
| 2010-12-27 | DC | Futures | 22.64 | 22.64 | 22.47 | 22.5 | 26.0 |
| 2010-12-27 | DX | Futures | 80.674 | 80.864 | 80.37 | 80.534 | 5040.0 |
| 2010-12-27 | E1 | Futures | 1.36723 | 1.3709 | 1.36041 | 1.36618 | 19261.0 |
| 2010-12-27 | E6 | Futures | 1.55085 | 1.55783 | 1.546 | 1.55452 | 93879.0 |
| 2010-12-27 | E7 | Futures | 1.539 | 1.5462 | 1.5346 | 1.543 | 2156.0 |
| 2010-12-27 | EBM | Futures | 224.46 | 224.69 | 223.32 | 223.55 | 1517.0 |
| 2010-12-27 | ED | Futures | 94.7718 | 94.7814 | 94.7671 | 94.7718 | 49127.0 |
| 2010-12-27 | ER | Futures | 97.37 | 97.375 | 97.355 | 97.36 | 13605.0 |
| 2010-12-27 | EW | Futures | 893.0 | 897.1 | 889.0 | 895.9 | 7206.0 |
| 2010-12-27 | FBTP | Futures | 63.77 | 63.95 | 63.67 | 63.73 | 701.0 |
| 2010-12-27 | FCE | Futures | 2611.7 | 2613.7 | 2493.6 | 2579.0 | 55289.0 |
| 2010-12-27 | FDAX | Futures | 7582.2 | 7585.4 | 7405.0 | 7492.3 | 61432.0 |
| 2010-12-27 | FESX | Futures | 1780.6 | 1780.6 | 1734.0 | 1755.7 | 322946.0 |
| 2010-12-27 | FEU3 | Futures | 97.909 | 97.914 | 97.909 | 97.914 | 250.0 |
| 2010-12-27 | FGBL | Futures | 99.15 | 99.17 | 98.49 | 98.73 | 146076.0 |
| 2010-12-27 | FGBM | Futures | 104.86 | 104.86 | 104.47 | 104.58 | 83994.0 |
| 2010-12-27 | FGBS | Futures | 107.395 | 107.405 | 107.316 | 107.366 | 59304.0 |
| 2010-12-27 | FGBX | Futures | 97.65 | 97.65 | 96.88 | 97.32 | 456.0 |
| 2010-12-27 | FTDX | Futures | 744.2 | 745.5 | 738.1 | 740.3 | 184.0 |
| 2010-12-27 | FTI | Futures | 285.76 | 285.76 | 282.68 | 284.8 | 14251.0 |
| 2010-12-27 | FXXP | Futures | 180.5 | 181.3 | 179.7 | 180.6 | 1006.0 |
| 2010-12-27 | GF | Futures | 302.354 | 302.354 | 300.361 | 300.672 | 2004.0 |
| 2010-12-27 | GSCI | Futures | 1020.46 | 1020.46 | 1011.37 | 1018.84 | 146.0 |
| 2010-12-27 | HE | Futures | 98.793 | 99.326 | 98.292 | 98.887 | 7538.0 |
| 2010-12-27 | HG | Futures | 5.6374 | 5.7287 | 5.6028 | 5.7041 | 10788.0 |
| 2010-12-27 | HO | Futures | 2.124 | 2.1417 | 2.1075 | 2.1159 | 5676.0 |
| 2010-12-27 | HRC | Futures | 2615.9 | 2615.9 | 2615.9 | 2615.9 | 0.0 |
| 2010-12-27 | J1 | Futures | 0.0151624 | 0.0152101 | 0.0151473 | 0.0151749 | 47670.0 |
| 2010-12-27 | J7 | Futures | 0.015047 | 0.015101 | 0.015042 | 0.015067 | 103.0 |
| 2010-12-27 | JB | Futures | 120.81 | 120.98 | 120.55 | 120.65 | 636.0 |
| 2010-12-27 | KC | Futures | 577.76 | 584.87 | 570.4 | 582.29 | 2563.0 |
| 2010-12-27 | KE | Futures | 3418.68 | 3451.28 | 3384.04 | 3438.03 | 4048.0 |
| 2010-12-27 | LBS | Futures | 833.7 | 853.1 | 832.9 | 853.1 | 528.0 |
| 2010-12-27 | LE | Futures | 163.272 | 163.879 | 162.628 | 163.651 | 9152.0 |
| 2010-12-27 | MFS | Futures | 1316.8 | 1324.7 | 1316.5 | 1323.8 | 187.0 |
> showing 50 of 85 rows — these rows as CSV