PREVIEW / futures_daily / 2014-03-12
file: by_date/futures_daily/2014/2014-03-12.parquet size: 9 KB rows: 100
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 |
|---|---|---|---|---|---|---|---|
| 2014-03-12 | ES | Futures | 1922.29 | 1926.67 | 1910.95 | 1925.38 | 1666288.0 |
| 2014-03-12 | NQ | Futures | 4241.19 | 4265.04 | 4209.29 | 4261.31 | 319464.0 |
| 2014-03-12 | YM | Futures | 16332.7 | 16362.8 | 16252.4 | 16337.7 | 16715.0 |
| 2014-03-12 | CL | Futures | 177.02 | 177.24 | 173.59 | 174.37 | 416927.0 |
| 2014-03-12 | GC | Futures | 1778.0 | 1807.6 | 1773.8 | 1806.6 | 223878.0 |
| 2014-03-12 | ZN | Futures | 114.736403 | 115.17101 | 114.678455 | 115.026141 | 1282405.0 |
| 2014-03-12 | A6 | Futures | 0.85667 | 0.8584 | 0.85177 | 0.85763 | 44720.0 |
| 2014-03-12 | AD | Futures | 0.91086 | 0.91218 | 0.907 | 0.90984 | 43435.0 |
| 2014-03-12 | B | Futures | 110.7 | 110.94 | 110.0 | 110.44 | 245647.0 |
| 2014-03-12 | B6 | Futures | 1.7449 | 1.7471 | 1.7402 | 1.745 | 70906.0 |
| 2014-03-12 | BR | Futures | 0.21774 | 0.21872 | 0.21774 | 0.21856 | 40.0 |
| 2014-03-12 | BZ | Futures | 112.82 | 113.16 | 112.2 | 112.65 | 11041.0 |
| 2014-03-12 | C | Futures | 1969.0 | 1971.0 | 1934.0 | 1941.0 | 11111.0 |
| 2014-03-12 | CB | Futures | 93.898 | 93.91 | 93.669 | 93.796 | 18.0 |
| 2014-03-12 | CC | Futures | 2230.0 | 2236.0 | 2166.0 | 2187.0 | 21068.0 |
| 2014-03-12 | CNH | Futures | 7.0505 | 7.0669 | 7.0505 | 7.059 | 35.0 |
| 2014-03-12 | CSC | Futures | 4.332 | 4.332 | 4.321 | 4.332 | 55.0 |
| 2014-03-12 | CT | Futures | 102.84 | 104.45 | 101.65 | 103.63 | 14066.0 |
| 2014-03-12 | DC | Futures | 34.58 | 34.59 | 34.09 | 34.3 | 173.0 |
| 2014-03-12 | DX | Futures | 75.907 | 75.969 | 75.67 | 75.735 | 25643.0 |
| 2014-03-12 | E1 | Futures | 1.46266 | 1.47049 | 1.46151 | 1.46908 | 23233.0 |
| 2014-03-12 | E6 | Futures | 1.63611 | 1.6426 | 1.63411 | 1.64119 | 123102.0 |
| 2014-03-12 | E7 | Futures | 1.6245 | 1.6315 | 1.6233 | 1.6303 | 2633.0 |
| 2014-03-12 | EBM | Futures | 295.22 | 301.56 | 294.52 | 300.86 | 20346.0 |
| 2014-03-12 | ED | Futures | 95.3851 | 95.3899 | 95.3851 | 95.3851 | 88611.0 |
| 2014-03-12 | ER | Futures | 97.832 | 97.842 | 97.832 | 97.837 | 80526.0 |
| 2014-03-12 | EW | Futures | 1410.9 | 1416.3 | 1401.8 | 1414.8 | 6350.0 |
| 2014-03-12 | FBTP | Futures | 86.42 | 86.59 | 86.26 | 86.34 | 62254.0 |
| 2014-03-12 | FBTS | Futures | 97.029 | 97.064 | 96.985 | 97.02 | 6377.0 |
| 2014-03-12 | FCE | Futures | 3369.6 | 3369.6 | 3319.4 | 3343.5 | 7098.0 |
| 2014-03-12 | FDAX | Futures | 10280.5 | 10285.5 | 10138.0 | 10205.1 | 139450.0 |
| 2014-03-12 | FESX | Futures | 2163.0 | 2164.4 | 2137.1 | 2155.8 | 221697.0 |
| 2014-03-12 | FEU3 | Futures | 98.458 | 98.458 | 98.458 | 98.458 | 17.0 |
| 2014-03-12 | FGBL | Futures | 122.93 | 123.5 | 122.9 | 123.25 | 836906.0 |
| 2014-03-12 | FGBM | Futures | 119.43 | 119.68 | 119.41 | 119.6 | 531910.0 |
| 2014-03-12 | FGBS | Futures | 110.498 | 110.543 | 110.493 | 110.518 | 295193.0 |
| 2014-03-12 | FGBX | Futures | 124.91 | 125.87 | 124.91 | 125.48 | 18360.0 |
| 2014-03-12 | FMWO | Futures | 5458.5 | 5473.6 | 5458.5 | 5473.6 | 31.0 |
| 2014-03-12 | FOAT | Futures | 111.32 | 111.87 | 111.32 | 111.65 | 54766.0 |
| 2014-03-12 | FTDX | Futures | 1178.9 | 1178.9 | 1171.9 | 1171.9 | 1.0 |
| 2014-03-12 | FTI | Futures | 334.51 | 334.85 | 331.52 | 333.96 | 337.0 |
| 2014-03-12 | FTUK | Futures | 5012.7 | 5028.7 | 4988.3 | 5010.4 | 13458.0 |
| 2014-03-12 | FVSA | Futures | 1956.02 | 2006.18 | 1915.9 | 1945.99 | 8049.0 |
| 2014-03-12 | FXXP | Futures | 242.2 | 242.2 | 241.8 | 242.2 | 254.0 |
| 2014-03-12 | G | Futures | 92.98 | 93.29 | 92.94 | 93.07 | 166409.0 |
| 2014-03-12 | GF | Futures | 281.357 | 282.077 | 280.916 | 281.557 | 3016.0 |
| 2014-03-12 | GSCI | Futures | 1057.19 | 1062.57 | 1055.71 | 1059.01 | 2014.0 |
| 2014-03-12 | HE | Futures | 141.816 | 142.058 | 139.129 | 140.005 | 36648.0 |
| 2014-03-12 | HG | Futures | 3.7385 | 3.7784 | 3.6853 | 3.7537 | 93723.0 |
| 2014-03-12 | HH | Futures | 59.498 | 59.551 | 58.012 | 58.534 | 3552.0 |
> showing 50 of 100 rows — these rows as CSV