PREVIEW / futures_daily / 2011-12-15
file: by_date/futures_daily/2011/2011-12-15.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 |
|---|---|---|---|---|---|---|---|
| 2011-12-15 | ES | Futures | 1210.55 | 1224.85 | 1202.27 | 1216.07 | 2299656.0 |
| 2011-12-15 | NQ | Futures | 2549.36 | 2575.38 | 2533.07 | 2542.5 | 243508.0 |
| 2011-12-15 | YM | Futures | 11372.8 | 11505.3 | 11309.0 | 11432.8 | 106121.0 |
| 2011-12-15 | CL | Futures | 177.58 | 179.77 | 174.74 | 175.81 | 120784.0 |
| 2011-12-15 | GC | Futures | 2133.2 | 2155.5 | 2109.6 | 2129.5 | 189916.0 |
| 2011-12-15 | ZN | Futures | 112.989719 | 113.259771 | 112.73317 | 112.962714 | 830857.0 |
| 2011-12-15 | A6 | Futures | 0.87267 | 0.88014 | 0.86866 | 0.87347 | 64739.0 |
| 2011-12-15 | AD | Futures | 0.96408 | 0.9706 | 0.96267 | 0.96709 | 41187.0 |
| 2011-12-15 | B | Futures | 92.75 | 94.28 | 91.81 | 92.33 | 150754.0 |
| 2011-12-15 | B6 | Futures | 1.6149 | 1.6221 | 1.6121 | 1.6192 | 76817.0 |
| 2011-12-15 | BFX | Futures | 2390.3 | 2414.6 | 2389.0 | 2412.6 | 101.0 |
| 2011-12-15 | BR | Futures | 0.24568 | 0.24755 | 0.24568 | 0.24755 | 42.0 |
| 2011-12-15 | BZ | Futures | 99.73 | 100.0 | 97.67 | 97.98 | 399.0 |
| 2011-12-15 | C | Futures | 1444.0 | 1461.0 | 1412.0 | 1421.0 | 6647.0 |
| 2011-12-15 | CB | Futures | 89.212 | 89.212 | 89.077 | 89.212 | 24.0 |
| 2011-12-15 | CC | Futures | 1699.0 | 1713.0 | 1650.0 | 1668.0 | 9017.0 |
| 2011-12-15 | CSC | Futures | 3.988 | 3.988 | 3.976 | 3.978 | 39.0 |
| 2011-12-15 | CT | Futures | 109.63 | 111.68 | 109.48 | 111.14 | 6610.0 |
| 2011-12-15 | DC | Futures | 28.56 | 28.7 | 28.54 | 28.66 | 84.0 |
| 2011-12-15 | DX | Futures | 79.058 | 79.145 | 78.615 | 78.831 | 25566.0 |
| 2011-12-15 | E1 | Futures | 1.38075 | 1.4011 | 1.37839 | 1.39861 | 23439.0 |
| 2011-12-15 | E6 | Futures | 1.55389 | 1.56166 | 1.55102 | 1.55688 | 144989.0 |
| 2011-12-15 | E7 | Futures | 1.5397 | 1.5473 | 1.537 | 1.5427 | 2779.0 |
| 2011-12-15 | EBM | Futures | 230.62 | 233.57 | 230.3 | 232.26 | 6135.0 |
| 2011-12-15 | ED | Futures | 94.8671 | 94.8909 | 94.8432 | 94.8814 | 256171.0 |
| 2011-12-15 | ER | Futures | 97.135 | 97.218 | 97.125 | 97.189 | 147685.0 |
| 2011-12-15 | EW | Futures | 842.3 | 855.0 | 836.3 | 850.1 | 29110.0 |
| 2011-12-15 | FBTP | Futures | 56.91 | 58.3 | 56.6 | 58.08 | 9225.0 |
| 2011-12-15 | FBTS | Futures | 78.027 | 79.496 | 77.93 | 79.423 | 1373.0 |
| 2011-12-15 | FCE | Futures | 2126.0 | 2160.4 | 2117.4 | 2143.9 | 75624.0 |
| 2011-12-15 | FDAX | Futures | 6145.2 | 6294.5 | 6134.9 | 6240.7 | 222569.0 |
| 2011-12-15 | FESX | Futures | 1466.1 | 1494.9 | 1462.1 | 1484.9 | 1329219.0 |
| 2011-12-15 | FEU3 | Futures | 97.722 | 97.747 | 97.722 | 97.742 | 69.0 |
| 2011-12-15 | FGBL | Futures | 111.82 | 111.85 | 111.22 | 111.38 | 455732.0 |
| 2011-12-15 | FGBM | Futures | 112.78 | 112.83 | 112.49 | 112.54 | 272327.0 |
| 2011-12-15 | FGBS | Futures | 109.73 | 109.745 | 109.655 | 109.7 | 294849.0 |
| 2011-12-15 | FGBX | Futures | 118.29 | 118.29 | 116.75 | 116.92 | 7553.0 |
| 2011-12-15 | FTDX | Futures | 615.9 | 619.6 | 612.6 | 618.2 | 358.0 |
| 2011-12-15 | FTI | Futures | 244.1 | 249.05 | 244.1 | 247.46 | 10893.0 |
| 2011-12-15 | FTUK | Futures | 3846.2 | 3893.4 | 3839.7 | 3876.5 | 97945.0 |
| 2011-12-15 | FVSA | Futures | 14594.13 | 14594.13 | 13996.01 | 14195.38 | 4015.0 |
| 2011-12-15 | FXXP | Futures | 164.7 | 166.3 | 164.2 | 165.6 | 19372.0 |
| 2011-12-15 | G | Futures | 94.04 | 94.28 | 93.62 | 93.81 | 86201.0 |
| 2011-12-15 | GF | Futures | 309.594 | 310.725 | 308.356 | 310.133 | 1141.0 |
| 2011-12-15 | GSCI | Futures | 985.85 | 985.93 | 966.16 | 969.38 | 586.0 |
| 2011-12-15 | HE | Futures | 106.482 | 106.575 | 105.219 | 105.311 | 15133.0 |
| 2011-12-15 | HG | Futures | 4.3223 | 4.3923 | 4.2637 | 4.3092 | 42330.0 |
| 2011-12-15 | HO | Futures | 2.3081 | 2.3393 | 2.2846 | 2.2928 | 22676.0 |
| 2011-12-15 | HRC | Futures | 2786.5 | 2786.5 | 2786.5 | 2786.5 | 0.0 |
| 2011-12-15 | J1 | Futures | 0.0161225 | 0.0161916 | 0.0161075 | 0.0161564 | 44178.0 |
> showing 50 of 99 rows — these rows as CSV