PREVIEW / futures_daily / 2011-04-08
file: by_date/futures_daily/2011/2011-04-08.parquet size: 9 KB rows: 92
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-04-08 | ES | Futures | 1315.23 | 1322.41 | 1305.58 | 1310.53 | 1858868.0 |
| 2011-04-08 | NQ | Futures | 2652.47 | 2668.13 | 2624.85 | 2639.94 | 231045.0 |
| 2011-04-08 | YM | Futures | 11611.2 | 11663.8 | 11532.2 | 11588.6 | 95335.0 |
| 2011-04-08 | CL | Futures | 213.34 | 218.93 | 212.93 | 218.11 | 319475.0 |
| 2011-04-08 | GC | Futures | 1975.9 | 1998.3 | 1973.0 | 1995.2 | 123693.0 |
| 2011-04-08 | ZN | Futures | 99.841447 | 99.854615 | 99.380559 | 99.762437 | 969577.0 |
| 2011-04-08 | A6 | Futures | 0.89027 | 0.90047 | 0.88924 | 0.89507 | 72683.0 |
| 2011-04-08 | AD | Futures | 1.03705 | 1.04362 | 1.03625 | 1.03834 | 70589.0 |
| 2011-04-08 | B | Futures | 103.45 | 107.21 | 103.39 | 106.98 | 155719.0 |
| 2011-04-08 | B6 | Futures | 1.6941 | 1.7052 | 1.6934 | 1.6971 | 107021.0 |
| 2011-04-08 | BFX | Futures | 3149.9 | 3149.9 | 3128.0 | 3141.9 | 16.0 |
| 2011-04-08 | BR | Futures | 0.27748 | 0.27784 | 0.27715 | 0.27715 | 395.0 |
| 2011-04-08 | BZ | Futures | 112.45 | 112.79 | 112.45 | 112.79 | 1531.0 |
| 2011-04-08 | C | Futures | 2113.0 | 2130.0 | 2079.0 | 2096.0 | 5237.0 |
| 2011-04-08 | CB | Futures | 115.575 | 116.455 | 115.575 | 116.441 | 12.0 |
| 2011-04-08 | CC | Futures | 2389.0 | 2402.0 | 2346.0 | 2376.0 | 18783.0 |
| 2011-04-08 | CT | Futures | 186.19 | 189.93 | 179.96 | 181.5 | 13535.0 |
| 2011-04-08 | DC | Futures | 29.34 | 29.95 | 29.26 | 29.93 | 212.0 |
| 2011-04-08 | DX | Futures | 75.417 | 75.457 | 74.685 | 74.897 | 20849.0 |
| 2011-04-08 | E1 | Futures | 1.42933 | 1.44583 | 1.42881 | 1.43942 | 38664.0 |
| 2011-04-08 | E6 | Futures | 1.69169 | 1.71372 | 1.69027 | 1.70733 | 257705.0 |
| 2011-04-08 | E7 | Futures | 1.6782 | 1.7009 | 1.6778 | 1.6946 | 5199.0 |
| 2011-04-08 | EBM | Futures | 235.31 | 235.78 | 231.56 | 232.26 | 7297.0 |
| 2011-04-08 | ED | Futures | 94.9264 | 94.9359 | 94.9216 | 94.9311 | 162682.0 |
| 2011-04-08 | ER | Futures | 97.257 | 97.257 | 97.207 | 97.217 | 134261.0 |
| 2011-04-08 | EW | Futures | 986.7 | 994.1 | 974.9 | 980.2 | 22292.0 |
| 2011-04-08 | FBTP | Futures | 64.25 | 64.42 | 64.12 | 64.29 | 6055.0 |
| 2011-04-08 | FCE | Futures | 2701.1 | 2708.5 | 2682.2 | 2703.8 | 299092.0 |
| 2011-04-08 | FDAX | Futures | 7732.2 | 7745.0 | 7676.6 | 7713.0 | 93424.0 |
| 2011-04-08 | FESX | Futures | 1863.8 | 1869.0 | 1850.4 | 1860.6 | 971416.0 |
| 2011-04-08 | FEU3 | Futures | 97.78 | 97.78 | 97.76 | 97.76 | 48.0 |
| 2011-04-08 | FGBL | Futures | 96.39 | 96.47 | 95.98 | 96.05 | 839733.0 |
| 2011-04-08 | FGBM | Futures | 102.25 | 102.28 | 101.91 | 101.99 | 427415.0 |
| 2011-04-08 | FGBS | Futures | 106.152 | 106.152 | 105.998 | 106.018 | 551075.0 |
| 2011-04-08 | FGBX | Futures | 91.26 | 91.43 | 90.57 | 90.77 | 4305.0 |
| 2011-04-08 | FTDX | Futures | 844.4 | 844.4 | 830.6 | 833.7 | 289.0 |
| 2011-04-08 | FTI | Futures | 300.72 | 301.09 | 297.34 | 298.85 | 24788.0 |
| 2011-04-08 | FTUK | Futures | 4198.4 | 4218.0 | 4180.5 | 4198.7 | 68805.0 |
| 2011-04-08 | FXXP | Futures | 186.1 | 186.1 | 185.2 | 185.2 | 2218.0 |
| 2011-04-08 | G | Futures | 80.74 | 80.78 | 80.52 | 80.55 | 115572.0 |
| 2011-04-08 | GF | Futures | 326.464 | 328.582 | 325.738 | 325.738 | 467.0 |
| 2011-04-08 | GSCI | Futures | 1174.2 | 1191.58 | 1174.2 | 1187.12 | 2854.0 |
| 2011-04-08 | HE | Futures | 107.265 | 107.318 | 106.548 | 107.291 | 184.0 |
| 2011-04-08 | HG | Futures | 5.8887 | 6.0272 | 5.8634 | 5.9959 | 41844.0 |
| 2011-04-08 | HO | Futures | 2.6738 | 2.773 | 2.6738 | 2.7663 | 32352.0 |
| 2011-04-08 | HRC | Futures | 3024.8 | 3024.8 | 3024.8 | 3024.8 | 0.0 |
| 2011-04-08 | J1 | Futures | 0.0147817 | 0.014842 | 0.0147164 | 0.0148156 | 127578.0 |
| 2011-04-08 | J7 | Futures | 0.014689 | 0.01475 | 0.014628 | 0.014725 | 815.0 |
| 2011-04-08 | JB | Futures | 120.64 | 120.66 | 120.54 | 120.62 | 59.0 |
| 2011-04-08 | KC | Futures | 661.18 | 675.0 | 659.49 | 666.4 | 13661.0 |
> showing 50 of 92 rows — these rows as CSV