PREVIEW / futures_daily / 2015-03-24
file: by_date/futures_daily/2015/2015-03-24.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 |
|---|---|---|---|---|---|---|---|
| 2015-03-24 | ES | Futures | 2201.76 | 2209.12 | 2190.2 | 2192.3 | 1193863.0 |
| 2015-03-24 | NQ | Futures | 5150.92 | 5179.37 | 5136.7 | 5142.21 | 184226.0 |
| 2015-03-24 | YM | Futures | 18426.8 | 18491.2 | 18336.8 | 18359.3 | 108919.0 |
| 2015-03-24 | CL | Futures | 83.58 | 85.52 | 82.19 | 83.67 | 309553.0 |
| 2015-03-24 | GC | Futures | 1554.0 | 1561.8 | 1549.0 | 1557.8 | 162922.0 |
| 2015-03-24 | ZN | Futures | 122.071761 | 122.397365 | 121.95336 | 122.278964 | 975935.0 |
| 2015-03-24 | A6 | Futures | 0.77341 | 0.77923 | 0.76926 | 0.77213 | 109458.0 |
| 2015-03-24 | AD | Futures | 0.81485 | 0.82067 | 0.81291 | 0.81608 | 65497.0 |
| 2015-03-24 | ALI | Futures | 2679.47 | 2679.47 | 2679.47 | 2679.47 | 0.0 |
| 2015-03-24 | B | Futures | 54.94 | 55.89 | 53.98 | 54.23 | 197476.0 |
| 2015-03-24 | B6 | Futures | 1.5732 | 1.5765 | 1.5614 | 1.5616 | 106995.0 |
| 2015-03-24 | BFX | Futures | 4541.7 | 4549.0 | 4541.7 | 4544.7 | 11.0 |
| 2015-03-24 | BR | Futures | 0.17881 | 0.17998 | 0.17667 | 0.17892 | 45.0 |
| 2015-03-24 | BZ | Futures | 54.59 | 55.4 | 53.53 | 53.76 | 16166.0 |
| 2015-03-24 | C | Futures | 2096.0 | 2134.0 | 2082.0 | 2129.0 | 7664.0 |
| 2015-03-24 | CB | Futures | 141.398 | 142.005 | 141.398 | 141.6 | 9.0 |
| 2015-03-24 | CC | Futures | 2029.0 | 2060.0 | 2004.0 | 2055.0 | 19809.0 |
| 2015-03-24 | CNH | Futures | 7.0385 | 7.0491 | 7.0383 | 7.0411 | 26.0 |
| 2015-03-24 | CSC | Futures | 4.268 | 4.319 | 4.247 | 4.292 | 89.0 |
| 2015-03-24 | CT | Futures | 82.03 | 82.54 | 81.53 | 81.92 | 14815.0 |
| 2015-03-24 | DC | Futures | 34.32 | 34.93 | 34.28 | 34.71 | 108.0 |
| 2015-03-24 | DX | Futures | 91.32 | 91.705 | 90.681 | 91.499 | 70360.0 |
| 2015-03-24 | E1 | Futures | 1.32386 | 1.34055 | 1.31863 | 1.33418 | 21963.0 |
| 2015-03-24 | E6 | Futures | 1.28858 | 1.29834 | 1.28211 | 1.28529 | 362087.0 |
| 2015-03-24 | E7 | Futures | 1.2812 | 1.2908 | 1.2746 | 1.2779 | 9996.0 |
| 2015-03-24 | EBM | Futures | 312.11 | 312.51 | 308.5 | 308.9 | 23102.0 |
| 2015-03-24 | ED | Futures | 95.5046 | 95.5141 | 95.5046 | 95.5094 | 107726.0 |
| 2015-03-24 | ER | Futures | 98.053 | 98.058 | 98.048 | 98.053 | 26980.0 |
| 2015-03-24 | EW | Futures | 1606.8 | 1610.4 | 1599.5 | 1602.7 | 12698.0 |
| 2015-03-24 | FBTP | Futures | 103.39 | 103.53 | 102.97 | 103.07 | 82230.0 |
| 2015-03-24 | FBTS | Futures | 99.519 | 99.555 | 99.43 | 99.484 | 21061.0 |
| 2015-03-24 | FCE | Futures | 4105.4 | 4152.1 | 4094.0 | 4140.8 | 82478.0 |
| 2015-03-24 | FDAX | Futures | 13208.1 | 13381.2 | 13116.6 | 13368.4 | 116487.0 |
| 2015-03-24 | FESX | Futures | 2668.2 | 2705.7 | 2655.6 | 2699.8 | 970401.0 |
| 2015-03-24 | FGBL | Futures | 140.72 | 140.97 | 140.46 | 140.49 | 492100.0 |
| 2015-03-24 | FGBM | Futures | 124.58 | 124.68 | 124.55 | 124.56 | 326939.0 |
| 2015-03-24 | FGBS | Futures | 111.198 | 111.223 | 111.198 | 111.198 | 125310.0 |
| 2015-03-24 | FGBX | Futures | 176.79 | 177.61 | 176.1 | 176.32 | 21469.0 |
| 2015-03-24 | FMWO | Futures | 5856.9 | 5869.3 | 5854.5 | 5854.5 | 266.0 |
| 2015-03-24 | FOAT | Futures | 129.53 | 129.8 | 129.25 | 129.27 | 72011.0 |
| 2015-03-24 | FTDX | Futures | 1535.4 | 1546.7 | 1523.2 | 1544.8 | 347.0 |
| 2015-03-24 | FTI | Futures | 429.3 | 432.76 | 427.82 | 431.37 | 25819.0 |
| 2015-03-24 | FTUK | Futures | 5496.0 | 5525.6 | 5477.1 | 5501.2 | 82861.0 |
| 2015-03-24 | FVSA | Futures | 1787.18 | 1787.18 | 1681.3 | 1685.54 | 22256.0 |
| 2015-03-24 | FXXP | Futures | 302.6 | 305.6 | 302.1 | 305.1 | 10535.0 |
| 2015-03-24 | G | Futures | 105.59 | 105.85 | 105.42 | 105.54 | 142976.0 |
| 2015-03-24 | GF | Futures | 371.74 | 373.224 | 369.322 | 371.401 | 1871.0 |
| 2015-03-24 | GSCI | Futures | 689.21 | 692.49 | 687.58 | 689.21 | 79.0 |
| 2015-03-24 | HE | Futures | 78.508 | 79.116 | 75.964 | 76.513 | 2710.0 |
| 2015-03-24 | HG | Futures | 3.6566 | 3.6687 | 3.5257 | 3.5613 | 62095.0 |
> showing 50 of 105 rows — these rows as CSV