PREVIEW / futures_daily / 2012-09-12
file: by_date/futures_daily/2012/2012-09-12.parquet size: 9 KB rows: 99
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 |
|---|---|---|---|---|---|---|---|
| 2012-09-12 | ES | Futures | 1448.7 | 1458.57 | 1446.67 | 1457.81 | 1725227.0 |
| 2012-09-12 | NQ | Futures | 3192.22 | 3214.02 | 3185.33 | 3209.43 | 255194.0 |
| 2012-09-12 | YM | Futures | 12907.3 | 12984.4 | 12898.5 | 12971.7 | 14075.0 |
| 2012-09-12 | CL | Futures | 175.21 | 177.4 | 174.23 | 175.5 | 223528.0 |
| 2012-09-12 | GC | Futures | 2315.8 | 2335.8 | 2306.2 | 2314.7 | 182989.0 |
| 2012-09-12 | ZN | Futures | 116.68395 | 116.780088 | 116.27193 | 116.326866 | 943387.0 |
| 2012-09-12 | A6 | Futures | 0.93971 | 0.94662 | 0.93944 | 0.94198 | 69935.0 |
| 2012-09-12 | AD | Futures | 1.02868 | 1.03078 | 1.02526 | 1.02567 | 72031.0 |
| 2012-09-12 | B | Futures | 104.27 | 105.77 | 104.26 | 105.16 | 226728.0 |
| 2012-09-12 | B6 | Futures | 1.6777 | 1.6842 | 1.6772 | 1.6812 | 55507.0 |
| 2012-09-12 | BFX | Futures | 2907.7 | 2907.7 | 2905.5 | 2905.5 | 2.0 |
| 2012-09-12 | BR | Futures | 0.2374 | 0.2374 | 0.23672 | 0.23672 | 198.0 |
| 2012-09-12 | BZ | Futures | 109.76 | 110.44 | 109.71 | 110.21 | 1888.0 |
| 2012-09-12 | C | Futures | 1715.0 | 1727.0 | 1694.0 | 1714.0 | 5981.0 |
| 2012-09-12 | CB | Futures | 97.68 | 98.215 | 97.412 | 97.947 | 11.0 |
| 2012-09-12 | CC | Futures | 1980.0 | 2002.0 | 1952.0 | 1984.0 | 8404.0 |
| 2012-09-12 | CSC | Futures | 3.994 | 3.994 | 3.994 | 3.994 | 2.0 |
| 2012-09-12 | CT | Futures | 98.36 | 98.8 | 95.4 | 95.94 | 49.0 |
| 2012-09-12 | DC | Futures | 29.81 | 30.19 | 29.55 | 30.18 | 100.0 |
| 2012-09-12 | DX | Futures | 77.508 | 77.639 | 77.14 | 77.406 | 13692.0 |
| 2012-09-12 | E1 | Futures | 1.37312 | 1.37982 | 1.37042 | 1.37505 | 19016.0 |
| 2012-09-12 | E6 | Futures | 1.51484 | 1.52473 | 1.51048 | 1.51967 | 118682.0 |
| 2012-09-12 | E7 | Futures | 1.5075 | 1.5155 | 1.5017 | 1.5106 | 2959.0 |
| 2012-09-12 | ED | Futures | 95.2062 | 95.2205 | 95.2014 | 95.2062 | 202709.0 |
| 2012-09-12 | ER | Futures | 97.857 | 97.857 | 97.832 | 97.837 | 157894.0 |
| 2012-09-12 | EW | Futures | 1020.1 | 1024.2 | 1016.8 | 1023.7 | 17539.0 |
| 2012-09-12 | FBTP | Futures | 70.79 | 71.31 | 70.73 | 71.14 | 20896.0 |
| 2012-09-12 | FBTS | Futures | 89.173 | 89.424 | 89.072 | 89.374 | 3327.0 |
| 2012-09-12 | FCE | Futures | 2636.5 | 2665.0 | 2627.9 | 2641.4 | 1876.0 |
| 2012-09-12 | FDAX | Futures | 7984.2 | 8091.7 | 7977.6 | 8026.8 | 175895.0 |
| 2012-09-12 | FESX | Futures | 1732.1 | 1755.9 | 1728.7 | 1737.6 | 130427.0 |
| 2012-09-12 | FEU3 | Futures | 98.473 | 98.473 | 98.458 | 98.458 | 3.0 |
| 2012-09-12 | FGBL | Futures | 117.27 | 117.42 | 116.37 | 116.63 | 941030.0 |
| 2012-09-12 | FGBM | Futures | 115.79 | 115.79 | 115.38 | 115.45 | 635395.0 |
| 2012-09-12 | FGBS | Futures | 110.318 | 110.323 | 110.228 | 110.253 | 454187.0 |
| 2012-09-12 | FGBX | Futures | 122.99 | 123.06 | 120.77 | 121.47 | 7574.0 |
| 2012-09-12 | FOAT | Futures | 102.72 | 102.84 | 102.41 | 102.59 | 11591.0 |
| 2012-09-12 | FTDX | Futures | 761.8 | 762.2 | 761.8 | 762.2 | 1011.0 |
| 2012-09-12 | FTI | Futures | 286.94 | 289.37 | 285.79 | 286.81 | 144.0 |
| 2012-09-12 | FTUK | Futures | 4215.7 | 4236.6 | 4191.6 | 4208.4 | 12906.0 |
| 2012-09-12 | FVSA | Futures | 6110.07 | 6378.91 | 5877.89 | 6085.63 | 3279.0 |
| 2012-09-12 | FXXP | Futures | 195.2 | 196.7 | 195.1 | 196.4 | 9231.0 |
| 2012-09-12 | G | Futures | 99.03 | 99.1 | 98.32 | 98.41 | 194169.0 |
| 2012-09-12 | GF | Futures | 284.911 | 288.416 | 284.863 | 286.907 | 2617.0 |
| 2012-09-12 | GSCI | Futures | 1098.79 | 1100.89 | 1096.05 | 1100.89 | 1868.0 |
| 2012-09-12 | HE | Futures | 90.588 | 90.989 | 89.445 | 90.742 | 23559.0 |
| 2012-09-12 | HG | Futures | 4.7375 | 4.7953 | 4.706 | 4.7452 | 49133.0 |
| 2012-09-12 | HH | Futures | 41.061 | 41.061 | 41.061 | 41.061 | 200.0 |
| 2012-09-12 | HO | Futures | 2.5747 | 2.6037 | 2.5747 | 2.6014 | 27809.0 |
| 2012-09-12 | HRC | Futures | 2471.7 | 2471.7 | 2471.7 | 2471.7 | 0.0 |
> showing 50 of 99 rows — these rows as CSV