PREVIEW / futures_daily / 2012-03-19
file: by_date/futures_daily/2012/2012-03-19.parquet size: 9 KB rows: 97
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-19 | ES | Futures | 1408.03 | 1418.86 | 1404.25 | 1414.83 | 1525304.0 |
| 2012-03-19 | NQ | Futures | 3103.18 | 3133.54 | 3093.73 | 3125.24 | 229820.0 |
| 2012-03-19 | YM | Futures | 12800.9 | 12844.6 | 12762.0 | 12804.8 | 97568.0 |
| 2012-03-19 | CL | Futures | 198.68 | 200.38 | 197.32 | 200.12 | 243063.0 |
| 2012-03-19 | GC | Futures | 2221.6 | 2236.5 | 2212.6 | 2232.7 | 135038.0 |
| 2012-03-19 | ZN | Futures | 111.404041 | 111.688339 | 110.754218 | 110.862522 | 1224333.0 |
| 2012-03-19 | A6 | Futures | 0.94363 | 0.94723 | 0.94003 | 0.94561 | 104815.0 |
| 2012-03-19 | AD | Futures | 1.01296 | 1.01839 | 1.01114 | 1.01768 | 72009.0 |
| 2012-03-19 | B | Futures | 112.84 | 113.24 | 112.14 | 112.94 | 122464.0 |
| 2012-03-19 | B6 | Futures | 1.662 | 1.6694 | 1.6596 | 1.6677 | 78403.0 |
| 2012-03-19 | BFX | Futures | 2895.1 | 2903.5 | 2870.2 | 2870.2 | 12.0 |
| 2012-03-19 | BR | Futures | 0.25948 | 0.25948 | 0.25948 | 0.25948 | 110.0 |
| 2012-03-19 | BZ | Futures | 120.44 | 120.44 | 119.33 | 120.13 | 453.0 |
| 2012-03-19 | C | Futures | 1458.0 | 1482.0 | 1450.0 | 1479.0 | 5332.0 |
| 2012-03-19 | CB | Futures | 83.022 | 83.426 | 83.022 | 83.426 | 11.0 |
| 2012-03-19 | CC | Futures | 1717.0 | 1753.0 | 1706.0 | 1742.0 | 9410.0 |
| 2012-03-19 | CSC | Futures | 3.637 | 3.657 | 3.63 | 3.657 | 22.0 |
| 2012-03-19 | CT | Futures | 109.79 | 112.11 | 109.66 | 111.48 | 11426.0 |
| 2012-03-19 | DC | Futures | 25.84 | 26.06 | 25.45 | 25.73 | 136.0 |
| 2012-03-19 | DX | Futures | 77.574 | 77.69 | 77.128 | 77.232 | 19289.0 |
| 2012-03-19 | E1 | Futures | 1.4322 | 1.44162 | 1.42788 | 1.43822 | 38295.0 |
| 2012-03-19 | E6 | Futures | 1.57396 | 1.58435 | 1.56955 | 1.58113 | 224237.0 |
| 2012-03-19 | E7 | Futures | 1.559 | 1.5692 | 1.5544 | 1.566 | 3443.0 |
| 2012-03-19 | EBM | Futures | 285.7 | 288.05 | 283.34 | 283.67 | 9387.0 |
| 2012-03-19 | ED | Futures | 95.0836 | 95.0931 | 95.0693 | 95.0788 | 192958.0 |
| 2012-03-19 | ER | Futures | 97.494 | 97.533 | 97.489 | 97.533 | 201132.0 |
| 2012-03-19 | EW | Futures | 1007.9 | 1017.3 | 1003.8 | 1011.2 | 21802.0 |
| 2012-03-19 | FBTP | Futures | 69.33 | 69.71 | 69.31 | 69.5 | 6217.0 |
| 2012-03-19 | FBTS | Futures | 86.356 | 86.47 | 86.34 | 86.438 | 2519.0 |
| 2012-03-19 | FCE | Futures | 2548.7 | 2553.7 | 2518.2 | 2538.4 | 69779.0 |
| 2012-03-19 | FDAX | Futures | 7943.7 | 7945.9 | 7856.4 | 7922.2 | 104292.0 |
| 2012-03-19 | FESX | Futures | 1755.2 | 1760.0 | 1740.0 | 1753.8 | 693965.0 |
| 2012-03-19 | FGBL | Futures | 111.15 | 111.55 | 110.92 | 111.19 | 652863.0 |
| 2012-03-19 | FGBM | Futures | 112.4 | 112.65 | 112.34 | 112.45 | 419669.0 |
| 2012-03-19 | FGBS | Futures | 109.625 | 109.7 | 109.62 | 109.64 | 428812.0 |
| 2012-03-19 | FGBX | Futures | 113.09 | 113.69 | 112.79 | 113.37 | 4715.0 |
| 2012-03-19 | FTDX | Futures | 740.5 | 746.6 | 736.8 | 743.8 | 199.0 |
| 2012-03-19 | FTI | Futures | 283.26 | 283.68 | 281.44 | 283.09 | 17263.0 |
| 2012-03-19 | FTUK | Futures | 4323.5 | 4326.0 | 4287.4 | 4310.3 | 77741.0 |
| 2012-03-19 | FVSA | Futures | 8268.21 | 8284.95 | 7933.46 | 7933.46 | 4001.0 |
| 2012-03-19 | FXXP | Futures | 193.2 | 194.0 | 193.0 | 193.6 | 3184.0 |
| 2012-03-19 | G | Futures | 91.64 | 92.09 | 91.6 | 91.78 | 123148.0 |
| 2012-03-19 | GF | Futures | 322.977 | 323.605 | 320.727 | 320.989 | 2239.0 |
| 2012-03-19 | GSCI | Futures | 1126.68 | 1128.66 | 1122.8 | 1125.1 | 740.0 |
| 2012-03-19 | HE | Futures | 103.779 | 103.999 | 103.229 | 103.944 | 376.0 |
| 2012-03-19 | HG | Futures | 5.0927 | 5.1386 | 5.0541 | 5.1249 | 38422.0 |
| 2012-03-19 | HO | Futures | 2.717 | 2.717 | 2.6901 | 2.7012 | 31238.0 |
| 2012-03-19 | HRC | Futures | 2719.2 | 2719.2 | 2719.2 | 2719.2 | 0.0 |
| 2012-03-19 | J1 | Futures | 0.0150454 | 0.0151156 | 0.0150166 | 0.0150467 | 84341.0 |
| 2012-03-19 | J7 | Futures | 0.014967 | 0.015043 | 0.014948 | 0.014976 | 344.0 |
> showing 50 of 97 rows — these rows as CSV