PREVIEW / futures_daily / 2015-01-09
file: by_date/futures_daily/2015/2015-01-09.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-09 | ES | Futures | 2152.59 | 2161.24 | 2129.01 | 2133.2 | 1907571.0 |
| 2015-01-09 | NQ | Futures | 4910.64 | 4934.14 | 4851.18 | 4874.09 | 341966.0 |
| 2015-01-09 | YM | Futures | 18140.1 | 18194.1 | 17937.4 | 17975.1 | 196348.0 |
| 2015-01-09 | CL | Futures | 95.81 | 97.16 | 92.37 | 94.72 | 421007.0 |
| 2015-01-09 | GC | Futures | 1582.4 | 1602.1 | 1579.9 | 1591.8 | 155980.0 |
| 2015-01-09 | ZN | Futures | 120.703321 | 121.395241 | 120.659156 | 121.144972 | 1451875.0 |
| 2015-01-09 | A6 | Futures | 0.79102 | 0.80032 | 0.79033 | 0.79954 | 98418.0 |
| 2015-01-09 | AD | Futures | 0.85914 | 0.86169 | 0.85537 | 0.85762 | 65367.0 |
| 2015-01-09 | ALI | Futures | 2807.27 | 2807.27 | 2793.53 | 2793.53 | 11.0 |
| 2015-01-09 | B | Futures | 53.47 | 53.62 | 51.16 | 52.39 | 300479.0 |
| 2015-01-09 | B6 | Futures | 1.5847 | 1.5949 | 1.5846 | 1.5937 | 121008.0 |
| 2015-01-09 | BFX | Futures | 3971.6 | 3998.2 | 3935.2 | 3935.2 | 5.0 |
| 2015-01-09 | BR | Futures | 0.20472 | 0.20714 | 0.20472 | 0.20621 | 60.0 |
| 2015-01-09 | BZ | Futures | 53.39 | 53.87 | 51.45 | 52.67 | 42672.0 |
| 2015-01-09 | C | Futures | 2233.0 | 2243.0 | 2217.0 | 2224.0 | 7884.0 |
| 2015-01-09 | CB | Futures | 133.906 | 135.159 | 133.495 | 135.138 | 33.0 |
| 2015-01-09 | CC | Futures | 2212.0 | 2216.0 | 2181.0 | 2190.0 | 15401.0 |
| 2015-01-09 | CNH | Futures | 7.1054 | 7.1054 | 7.0952 | 7.0952 | 11.0 |
| 2015-01-09 | CSC | Futures | 4.415 | 4.432 | 4.361 | 4.373 | 76.0 |
| 2015-01-09 | CT | Futures | 77.27 | 77.73 | 77.03 | 77.6 | 10006.0 |
| 2015-01-09 | DC | Futures | 34.81 | 34.81 | 34.15 | 34.27 | 198.0 |
| 2015-01-09 | DX | Futures | 87.572 | 87.79 | 87.184 | 87.224 | 45231.0 |
| 2015-01-09 | E1 | Futures | 1.25483 | 1.26096 | 1.25202 | 1.26045 | 46244.0 |
| 2015-01-09 | E6 | Futures | 1.38774 | 1.39433 | 1.38433 | 1.39363 | 240002.0 |
| 2015-01-09 | E7 | Futures | 1.3792 | 1.386 | 1.3762 | 1.3853 | 7471.0 |
| 2015-01-09 | EBM | Futures | 316.3 | 320.36 | 315.49 | 316.71 | 20179.0 |
| 2015-01-09 | ED | Futures | 95.4498 | 95.4546 | 95.445 | 95.4498 | 244209.0 |
| 2015-01-09 | ER | Futures | 98.023 | 98.033 | 98.023 | 98.028 | 44067.0 |
| 2015-01-09 | EW | Futures | 1514.8 | 1521.1 | 1498.4 | 1502.0 | 15037.0 |
| 2015-01-09 | FBTP | Futures | 98.93 | 99.15 | 98.6 | 98.63 | 64886.0 |
| 2015-01-09 | FBTS | Futures | 98.739 | 98.792 | 98.668 | 98.677 | 14362.0 |
| 2015-01-09 | FCE | Futures | 3462.7 | 3488.8 | 3385.2 | 3408.8 | 153921.0 |
| 2015-01-09 | FDAX | Futures | 10897.1 | 10955.4 | 10660.6 | 10683.4 | 140829.0 |
| 2015-01-09 | FESX | Futures | 2238.6 | 2248.0 | 2171.6 | 2183.8 | 1466883.0 |
| 2015-01-09 | FEU3 | Futures | 98.645 | 98.65 | 98.645 | 98.65 | 10.0 |
| 2015-01-09 | FGBL | Futures | 136.91 | 137.26 | 136.67 | 137.23 | 663818.0 |
| 2015-01-09 | FGBM | Futures | 123.87 | 123.95 | 123.82 | 123.95 | 308551.0 |
| 2015-01-09 | FGBS | Futures | 110.983 | 111.033 | 110.983 | 111.018 | 294783.0 |
| 2015-01-09 | FGBX | Futures | 158.4 | 160.04 | 157.64 | 159.64 | 32259.0 |
| 2015-01-09 | FMWO | Futures | 5569.2 | 5574.1 | 5518.5 | 5518.5 | 555.0 |
| 2015-01-09 | FOAT | Futures | 126.05 | 126.2 | 125.96 | 126.14 | 83450.0 |
| 2015-01-09 | FTDX | Futures | 1333.6 | 1334.6 | 1318.6 | 1321.4 | 154.0 |
| 2015-01-09 | FTI | Futures | 365.5 | 367.45 | 357.23 | 359.66 | 41971.0 |
| 2015-01-09 | FTUK | Futures | 5062.5 | 5073.4 | 4994.3 | 5003.3 | 94722.0 |
| 2015-01-09 | FVSA | Futures | 1990.18 | 2106.57 | 1959.14 | 2083.29 | 13112.0 |
| 2015-01-09 | FXXP | Futures | 257.0 | 258.2 | 253.0 | 253.9 | 10612.0 |
| 2015-01-09 | G | Futures | 104.12 | 104.55 | 104.0 | 104.51 | 161785.0 |
| 2015-01-09 | GF | Futures | 361.291 | 361.611 | 355.113 | 356.878 | 2060.0 |
| 2015-01-09 | GSCI | Futures | 676.11 | 676.11 | 664.69 | 672.7 | 2526.0 |
| 2015-01-09 | HE | Futures | 105.044 | 106.184 | 104.373 | 106.017 | 24014.0 |
> showing 50 of 107 rows — these rows as CSV