PREVIEW / futures_daily / 2012-03-26
file: by_date/futures_daily/2012/2012-03-26.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-03-26 | ES | Futures | 1404.5 | 1426.42 | 1403.24 | 1425.92 | 1456063.0 |
| 2012-03-26 | NQ | Futures | 3127.53 | 3182.81 | 3126.67 | 3181.66 | 202381.0 |
| 2012-03-26 | YM | Futures | 12671.5 | 12840.8 | 12662.8 | 12836.9 | 97619.0 |
| 2012-03-26 | CL | Futures | 196.86 | 197.84 | 195.75 | 197.3 | 162276.0 |
| 2012-03-26 | GC | Futures | 2226.2 | 2267.2 | 2215.7 | 2256.8 | 71810.0 |
| 2012-03-26 | ZN | Futures | 111.756029 | 111.932023 | 111.444655 | 111.823719 | 894885.0 |
| 2012-03-26 | A6 | Futures | 0.93302 | 0.94003 | 0.92924 | 0.93832 | 118634.0 |
| 2012-03-26 | AD | Futures | 1.00561 | 1.01366 | 1.0043 | 1.01195 | 81562.0 |
| 2012-03-26 | B | Futures | 112.42 | 113.22 | 111.99 | 113.03 | 82935.0 |
| 2012-03-26 | B6 | Futures | 1.6648 | 1.6757 | 1.6575 | 1.6735 | 96398.0 |
| 2012-03-26 | BFX | Futures | 2852.7 | 2888.9 | 2852.7 | 2883.7 | 35.0 |
| 2012-03-26 | BR | Futures | 0.25924 | 0.25924 | 0.25924 | 0.25924 | 288.0 |
| 2012-03-26 | BZ | Futures | 119.58 | 119.58 | 119.56 | 119.56 | 236.0 |
| 2012-03-26 | C | Futures | 1490.0 | 1518.0 | 1484.0 | 1515.0 | 4226.0 |
| 2012-03-26 | CB | Futures | 81.273 | 81.945 | 81.273 | 81.945 | 9.0 |
| 2012-03-26 | CC | Futures | 1753.0 | 1784.0 | 1742.0 | 1774.0 | 8841.0 |
| 2012-03-26 | CSC | Futures | 3.623 | 3.639 | 3.616 | 3.637 | 19.0 |
| 2012-03-26 | CT | Futures | 112.2 | 113.9 | 111.83 | 113.77 | 12774.0 |
| 2012-03-26 | DC | Futures | 25.35 | 25.71 | 25.14 | 25.6 | 165.0 |
| 2012-03-26 | DX | Futures | 77.022 | 77.453 | 76.6 | 76.716 | 19084.0 |
| 2012-03-26 | E1 | Futures | 1.44359 | 1.45262 | 1.43442 | 1.45053 | 37723.0 |
| 2012-03-26 | E6 | Futures | 1.58423 | 1.59652 | 1.5754 | 1.59354 | 261180.0 |
| 2012-03-26 | E7 | Futures | 1.5692 | 1.5811 | 1.5603 | 1.5783 | 3770.0 |
| 2012-03-26 | EBM | Futures | 289.74 | 295.13 | 289.74 | 292.77 | 12599.0 |
| 2012-03-26 | ED | Futures | 95.0693 | 95.0884 | 95.0645 | 95.0836 | 129673.0 |
| 2012-03-26 | ER | Futures | 97.553 | 97.567 | 97.548 | 97.562 | 54797.0 |
| 2012-03-26 | EW | Futures | 1003.1 | 1016.1 | 1001.1 | 1015.7 | 21804.0 |
| 2012-03-26 | FBTP | Futures | 68.42 | 68.88 | 68.4 | 68.58 | 9057.0 |
| 2012-03-26 | FBTS | Futures | 86.21 | 86.291 | 85.974 | 86.161 | 724.0 |
| 2012-03-26 | FCE | Futures | 2482.4 | 2493.4 | 2451.5 | 2482.0 | 92235.0 |
| 2012-03-26 | FDAX | Futures | 7794.5 | 7875.7 | 7717.1 | 7840.9 | 126656.0 |
| 2012-03-26 | FESX | Futures | 1702.7 | 1713.1 | 1682.0 | 1705.5 | 935505.0 |
| 2012-03-26 | FEU3 | Futures | 98.137 | 98.137 | 98.137 | 98.137 | 1.0 |
| 2012-03-26 | FGBL | Futures | 112.71 | 112.82 | 112.0 | 112.12 | 681101.0 |
| 2012-03-26 | FGBM | Futures | 113.35 | 113.42 | 112.98 | 113.08 | 343246.0 |
| 2012-03-26 | FGBS | Futures | 109.889 | 109.909 | 109.81 | 109.839 | 347561.0 |
| 2012-03-26 | FGBX | Futures | 116.58 | 117.04 | 115.31 | 115.57 | 7015.0 |
| 2012-03-26 | FTDX | Futures | 738.7 | 750.8 | 736.3 | 748.5 | 465.0 |
| 2012-03-26 | FTI | Futures | 275.39 | 278.65 | 274.51 | 278.02 | 29999.0 |
| 2012-03-26 | FTUK | Futures | 4254.9 | 4279.7 | 4236.3 | 4269.1 | 89987.0 |
| 2012-03-26 | FVSA | Futures | 7699.14 | 7899.99 | 7481.56 | 7481.56 | 5687.0 |
| 2012-03-26 | FXXP | Futures | 189.9 | 191.2 | 188.8 | 190.9 | 2045.0 |
| 2012-03-26 | G | Futures | 92.99 | 93.31 | 92.54 | 92.62 | 93041.0 |
| 2012-03-26 | GF | Futures | 319.262 | 320.832 | 318.425 | 319.314 | 1699.0 |
| 2012-03-26 | GSCI | Futures | 1113.15 | 1118.93 | 1113.15 | 1117.58 | 138.0 |
| 2012-03-26 | HE | Futures | 103.119 | 103.339 | 102.486 | 103.339 | 202.0 |
| 2012-03-26 | HG | Futures | 4.9892 | 5.1124 | 4.9754 | 5.0967 | 48328.0 |
| 2012-03-26 | HO | Futures | 2.6561 | 2.6794 | 2.6503 | 2.6781 | 23970.0 |
| 2012-03-26 | HRC | Futures | 2699.8 | 2699.8 | 2699.8 | 2699.8 | 0.0 |
| 2012-03-26 | J1 | Futures | 0.0152222 | 0.0152222 | 0.0151169 | 0.0151545 | 92190.0 |
> showing 50 of 99 rows — these rows as CSV