PREVIEW / futures_daily / 2014-10-22
file: by_date/futures_daily/2014/2014-10-22.parquet size: 9 KB rows: 106
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-10-22 | ES | Futures | 2024.67 | 2030.41 | 2005.87 | 2010.83 | 2022453.0 |
| 2014-10-22 | NQ | Futures | 4601.71 | 4616.2 | 4565.79 | 4577.09 | 343470.0 |
| 2014-10-22 | YM | Futures | 16786.3 | 16839.1 | 16620.9 | 16663.6 | 192923.0 |
| 2014-10-22 | CL | Futures | 158.49 | 159.65 | 154.02 | 154.6 | 352217.0 |
| 2014-10-22 | GC | Futures | 1638.1 | 1639.8 | 1627.4 | 1633.7 | 113405.0 |
| 2014-10-22 | ZN | Futures | 119.520502 | 119.84266 | 119.242275 | 119.417997 | 1305863.0 |
| 2014-10-22 | A6 | Futures | 0.84974 | 0.85343 | 0.84634 | 0.85003 | 81606.0 |
| 2014-10-22 | AD | Futures | 0.90382 | 0.90707 | 0.89721 | 0.9029 | 87820.0 |
| 2014-10-22 | ALI | Futures | 3055.23 | 3055.23 | 3055.23 | 3055.23 | 15.0 |
| 2014-10-22 | B | Futures | 89.74 | 90.38 | 87.68 | 87.93 | 264812.0 |
| 2014-10-22 | B6 | Futures | 1.6934 | 1.6949 | 1.6823 | 1.6863 | 84098.0 |
| 2014-10-22 | BFX | Futures | 3681.8 | 3702.0 | 3681.8 | 3702.0 | 4.0 |
| 2014-10-22 | BR | Futures | 0.2149 | 0.21661 | 0.21436 | 0.21442 | 117.0 |
| 2014-10-22 | BZ | Futures | 90.33 | 91.03 | 88.35 | 88.58 | 17458.0 |
| 2014-10-22 | C | Futures | 2155.0 | 2164.0 | 2149.0 | 2161.0 | 3220.0 |
| 2014-10-22 | CB | Futures | 135.849 | 137.197 | 135.849 | 136.427 | 17.0 |
| 2014-10-22 | CC | Futures | 2288.0 | 2303.0 | 2283.0 | 2298.0 | 5186.0 |
| 2014-10-22 | CNH | Futures | 7.0461 | 7.0498 | 7.0448 | 7.048 | 6.0 |
| 2014-10-22 | CSC | Futures | 4.914 | 4.951 | 4.914 | 4.919 | 7.0 |
| 2014-10-22 | CT | Futures | 79.83 | 80.35 | 79.11 | 79.42 | 8482.0 |
| 2014-10-22 | DC | Futures | 39.91 | 40.39 | 39.66 | 40.03 | 201.0 |
| 2014-10-22 | DX | Futures | 81.134 | 81.538 | 80.997 | 81.499 | 34247.0 |
| 2014-10-22 | E1 | Futures | 1.34745 | 1.35026 | 1.34054 | 1.34105 | 36325.0 |
| 2014-10-22 | E6 | Futures | 1.49693 | 1.50011 | 1.48798 | 1.48881 | 205927.0 |
| 2014-10-22 | E7 | Futures | 1.4875 | 1.4907 | 1.4787 | 1.4794 | 3977.0 |
| 2014-10-22 | ED | Futures | 95.4422 | 95.4422 | 95.4326 | 95.4374 | 61965.0 |
| 2014-10-22 | ER | Futures | 97.974 | 97.979 | 97.97 | 97.974 | 35449.0 |
| 2014-10-22 | EW | Futures | 1421.7 | 1427.0 | 1404.4 | 1407.5 | 19525.0 |
| 2014-10-22 | FBTP | Futures | 94.07 | 94.58 | 94.03 | 94.19 | 66788.0 |
| 2014-10-22 | FBTS | Futures | 98.224 | 98.322 | 98.188 | 98.206 | 20098.0 |
| 2014-10-22 | FCE | Futures | 3309.8 | 3314.2 | 3273.9 | 3308.5 | 106860.0 |
| 2014-10-22 | FDAX | Futures | 9802.1 | 9818.0 | 9683.8 | 9777.4 | 118577.0 |
| 2014-10-22 | FESX | Futures | 2177.5 | 2177.5 | 2145.6 | 2169.5 | 1377634.0 |
| 2014-10-22 | FEU3 | Futures | 98.596 | 98.601 | 98.591 | 98.601 | 150.0 |
| 2014-10-22 | FGBL | Futures | 132.66 | 132.88 | 132.4 | 132.71 | 657480.0 |
| 2014-10-22 | FGBM | Futures | 122.92 | 123.03 | 122.88 | 122.96 | 348528.0 |
| 2014-10-22 | FGBS | Futures | 110.883 | 110.918 | 110.878 | 110.903 | 202614.0 |
| 2014-10-22 | FGBX | Futures | 144.46 | 144.98 | 143.66 | 144.38 | 26973.0 |
| 2014-10-22 | FMWO | Futures | 5493.1 | 5506.9 | 5486.8 | 5506.9 | 1709.0 |
| 2014-10-22 | FOAT | Futures | 121.6 | 121.77 | 121.5 | 121.63 | 61707.0 |
| 2014-10-22 | FTDX | Futures | 1133.6 | 1142.2 | 1130.3 | 1139.8 | 262.0 |
| 2014-10-22 | FTI | Futures | 345.9 | 346.21 | 342.14 | 345.33 | 28150.0 |
| 2014-10-22 | FTUK | Futures | 4924.1 | 4936.5 | 4879.6 | 4924.5 | 103858.0 |
| 2014-10-22 | FVSA | Futures | 1670.82 | 1724.99 | 1654.15 | 1679.15 | 19088.0 |
| 2014-10-22 | FXXP | Futures | 246.1 | 247.2 | 243.8 | 246.9 | 7768.0 |
| 2014-10-22 | G | Futures | 99.28 | 99.62 | 98.7 | 99.04 | 179692.0 |
| 2014-10-22 | GF | Futures | 366.281 | 369.529 | 365.068 | 368.121 | 1743.0 |
| 2014-10-22 | GSCI | Futures | 923.53 | 924.72 | 905.44 | 906.04 | 69.0 |
| 2014-10-22 | HE | Futures | 118.574 | 121.434 | 118.473 | 120.795 | 14546.0 |
| 2014-10-22 | HG | Futures | 3.842 | 3.8623 | 3.8192 | 3.8274 | 32430.0 |
> showing 50 of 106 rows — these rows as CSV