PREVIEW / futures_daily / 2013-12-19
file: by_date/futures_daily/2013/2013-12-19.parquet size: 9 KB rows: 105
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-19 | ES | Futures | 1859.66 | 1862.5 | 1850.39 | 1857.6 | 1516505.0 |
| 2013-12-19 | NQ | Futures | 4033.69 | 4038.28 | 3998.33 | 4015.29 | 252985.0 |
| 2013-12-19 | YM | Futures | 16082.6 | 16113.5 | 16011.7 | 16089.6 | 125165.0 |
| 2013-12-19 | CL | Futures | 172.88 | 175.64 | 172.58 | 174.84 | 192782.0 |
| 2013-12-19 | GC | Futures | 1612.4 | 1623.3 | 1570.3 | 1580.4 | 206495.0 |
| 2013-12-19 | ZN | Futures | 113.675832 | 113.775987 | 113.017671 | 113.232288 | 1295056.0 |
| 2013-12-19 | A6 | Futures | 0.83757 | 0.841 | 0.83595 | 0.8391 | 65698.0 |
| 2013-12-19 | AD | Futures | 0.94296 | 0.94782 | 0.94174 | 0.94762 | 52535.0 |
| 2013-12-19 | B | Futures | 111.01 | 112.31 | 110.9 | 112.07 | 159785.0 |
| 2013-12-19 | B6 | Futures | 1.7201 | 1.7214 | 1.7151 | 1.7191 | 70968.0 |
| 2013-12-19 | BFX | Futures | 3429.9 | 3432.1 | 3429.9 | 3432.1 | 4.0 |
| 2013-12-19 | BR | Futures | 0.21658 | 0.21717 | 0.21591 | 0.21679 | 1232.0 |
| 2013-12-19 | BZ | Futures | 112.81 | 114.25 | 112.8 | 114.01 | 6496.0 |
| 2013-12-19 | C | Futures | 1875.0 | 1888.0 | 1869.0 | 1879.0 | 7209.0 |
| 2013-12-19 | CB | Futures | 78.999 | 80.839 | 78.999 | 80.262 | 61.0 |
| 2013-12-19 | CC | Futures | 2061.0 | 2085.0 | 2057.0 | 2071.0 | 10701.0 |
| 2013-12-19 | CNH | Futures | 7.0071 | 7.008 | 7.0046 | 7.0046 | 33.0 |
| 2013-12-19 | CSC | Futures | 3.72 | 3.758 | 3.72 | 3.749 | 22.0 |
| 2013-12-19 | CT | Futures | 94.64 | 95.35 | 94.52 | 95.01 | 6083.0 |
| 2013-12-19 | DC | Futures | 28.72 | 29.12 | 28.68 | 29.04 | 218.0 |
| 2013-12-19 | DX | Futures | 76.718 | 76.871 | 76.666 | 76.826 | 21716.0 |
| 2013-12-19 | E1 | Futures | 1.43532 | 1.43789 | 1.42941 | 1.4298 | 32184.0 |
| 2013-12-19 | E6 | Futures | 1.61416 | 1.61652 | 1.6112 | 1.61191 | 174579.0 |
| 2013-12-19 | E7 | Futures | 1.6036 | 1.6059 | 1.6007 | 1.6014 | 4189.0 |
| 2013-12-19 | EBM | Futures | 281.92 | 284.01 | 281.92 | 283.66 | 14994.0 |
| 2013-12-19 | ED | Futures | 95.3566 | 95.3566 | 95.328 | 95.3471 | 231229.0 |
| 2013-12-19 | ER | Futures | 97.857 | 97.876 | 97.852 | 97.867 | 104037.0 |
| 2013-12-19 | EW | Futures | 1341.8 | 1343.4 | 1327.7 | 1329.5 | 29352.0 |
| 2013-12-19 | FBTP | Futures | 82.0 | 82.21 | 81.89 | 82.04 | 32980.0 |
| 2013-12-19 | FBTS | Futures | 95.644 | 95.644 | 95.574 | 95.609 | 5173.0 |
| 2013-12-19 | FCE | Futures | 3232.3 | 3263.4 | 3225.6 | 3256.8 | 72597.0 |
| 2013-12-19 | FDAX | Futures | 10271.6 | 10392.5 | 10271.6 | 10358.7 | 30219.0 |
| 2013-12-19 | FESX | Futures | 2112.7 | 2133.8 | 2106.3 | 2126.0 | 627307.0 |
| 2013-12-19 | FEU3 | Futures | 98.488 | 98.488 | 98.483 | 98.483 | 1.0 |
| 2013-12-19 | FGBL | Futures | 119.26 | 119.35 | 118.82 | 118.96 | 585832.0 |
| 2013-12-19 | FGBM | Futures | 117.57 | 117.62 | 117.34 | 117.45 | 410260.0 |
| 2013-12-19 | FGBS | Futures | 110.313 | 110.353 | 110.288 | 110.338 | 288942.0 |
| 2013-12-19 | FGBX | Futures | 120.1 | 120.43 | 119.36 | 119.55 | 13594.0 |
| 2013-12-19 | FMWO | Futures | 5291.2 | 5303.8 | 5291.2 | 5303.8 | 58.0 |
| 2013-12-19 | FOAT | Futures | 108.32 | 108.38 | 108.0 | 108.14 | 40895.0 |
| 2013-12-19 | FTDX | Futures | 1085.9 | 1088.7 | 1085.0 | 1086.9 | 206.0 |
| 2013-12-19 | FTI | Futures | 330.32 | 333.67 | 330.32 | 333.2 | 15933.0 |
| 2013-12-19 | FTUK | Futures | 4929.1 | 4951.5 | 4910.6 | 4935.9 | 91330.0 |
| 2013-12-19 | FVSA | Futures | 1880.67 | 1886.04 | 1832.31 | 1859.18 | 9204.0 |
| 2013-12-19 | FXXP | Futures | 232.9 | 234.5 | 232.6 | 234.0 | 5152.0 |
| 2013-12-19 | G | Futures | 90.68 | 90.94 | 90.44 | 90.55 | 130598.0 |
| 2013-12-19 | GF | Futures | 267.885 | 268.811 | 267.603 | 268.529 | 1114.0 |
| 2013-12-19 | GSCI | Futures | 1037.48 | 1045.41 | 1036.65 | 1044.34 | 43.0 |
| 2013-12-19 | HE | Futures | 104.196 | 104.588 | 103.924 | 104.317 | 7927.0 |
| 2013-12-19 | HG | Futures | 4.1957 | 4.1976 | 4.1364 | 4.1623 | 41088.0 |
> showing 50 of 105 rows — these rows as CSV