PREVIEW / futures_daily / 2010-04-08
file: by_date/futures_daily/2010/2010-04-08.parquet size: 9 KB rows: 91
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-08 | ES | Futures | 1147.61 | 1153.94 | 1140.3 | 1152.72 | 1910628.0 |
| 2010-04-08 | NQ | Futures | 2239.37 | 2249.01 | 2222.64 | 2246.18 | 231684.0 |
| 2010-04-08 | YM | Futures | 9969.5 | 10018.2 | 9919.8 | 10005.3 | 110072.0 |
| 2010-04-08 | CL | Futures | 200.37 | 200.94 | 197.43 | 199.79 | 389596.0 |
| 2010-04-08 | GC | Futures | 1578.1 | 1584.3 | 1570.2 | 1581.8 | 119675.0 |
| 2010-04-08 | ZN | Futures | 94.695739 | 94.912551 | 94.478927 | 94.529942 | 974637.0 |
| 2010-04-08 | A6 | Futures | 0.75472 | 0.75686 | 0.75128 | 0.75669 | 67508.0 |
| 2010-04-08 | AD | Futures | 0.98192 | 0.98538 | 0.97679 | 0.984 | 68194.0 |
| 2010-04-08 | B | Futures | 76.68 | 76.95 | 75.76 | 76.37 | 127414.0 |
| 2010-04-08 | B6 | Futures | 1.5807 | 1.5864 | 1.5713 | 1.5849 | 101755.0 |
| 2010-04-08 | BFX | Futures | 3023.5 | 3026.8 | 2991.8 | 3003.1 | 127.0 |
| 2010-04-08 | BR | Futures | 0.2283 | 0.2283 | 0.2283 | 0.2283 | 139.0 |
| 2010-04-08 | BZ | Futures | 80.02 | 80.02 | 80.02 | 80.02 | 1.0 |
| 2010-04-08 | C | Futures | 2162.0 | 2170.0 | 2142.0 | 2152.0 | 4849.0 |
| 2010-04-08 | CB | Futures | 76.492 | 76.615 | 76.492 | 76.615 | 29.0 |
| 2010-04-08 | CC | Futures | 2421.0 | 2453.0 | 2402.0 | 2427.0 | 7876.0 |
| 2010-04-08 | CT | Futures | 65.77 | 66.28 | 63.82 | 63.92 | 25286.0 |
| 2010-04-08 | DC | Futures | 23.45 | 23.54 | 23.0 | 23.15 | 460.0 |
| 2010-04-08 | DX | Futures | 82.898 | 83.156 | 82.705 | 82.793 | 21652.0 |
| 2010-04-08 | E1 | Futures | 1.22669 | 1.22906 | 1.22116 | 1.22656 | 45388.0 |
| 2010-04-08 | E6 | Futures | 1.57822 | 1.5813 | 1.57136 | 1.57941 | 313608.0 |
| 2010-04-08 | E7 | Futures | 1.5652 | 1.5682 | 1.5584 | 1.5665 | 5569.0 |
| 2010-04-08 | EBM | Futures | 208.5 | 209.73 | 208.09 | 209.73 | 8533.0 |
| 2010-04-08 | ED | Futures | 94.4087 | 94.4087 | 94.3944 | 94.4039 | 198106.0 |
| 2010-04-08 | ER | Futures | 97.365 | 97.384 | 97.36 | 97.365 | 155867.0 |
| 2010-04-08 | EW | Futures | 785.9 | 786.2 | 777.4 | 784.3 | 24832.0 |
| 2010-04-08 | FBTP | Futures | 64.9 | 64.93 | 64.73 | 64.89 | 6533.0 |
| 2010-04-08 | FCE | Futures | 2568.4 | 2569.4 | 2528.1 | 2545.1 | 137377.0 |
| 2010-04-08 | FDAX | Futures | 6754.7 | 6768.8 | 6681.8 | 6723.1 | 143311.0 |
| 2010-04-08 | FESX | Futures | 1771.7 | 1771.7 | 1745.9 | 1758.2 | 1173067.0 |
| 2010-04-08 | FEU3 | Futures | 97.929 | 97.934 | 97.924 | 97.924 | 69.0 |
| 2010-04-08 | FGBL | Futures | 96.21 | 96.46 | 96.2 | 96.36 | 731922.0 |
| 2010-04-08 | FGBM | Futures | 101.94 | 102.11 | 101.91 | 102.01 | 485389.0 |
| 2010-04-08 | FGBS | Futures | 106.473 | 106.542 | 106.463 | 106.517 | 515234.0 |
| 2010-04-08 | FGBX | Futures | 91.77 | 92.0 | 91.6 | 91.87 | 1835.0 |
| 2010-04-08 | FTDX | Futures | 737.6 | 738.0 | 729.6 | 732.7 | 361.0 |
| 2010-04-08 | FTI | Futures | 284.7 | 285.76 | 282.35 | 283.45 | 30029.0 |
| 2010-04-08 | FTUK | Futures | 3853.6 | 3859.0 | 3815.0 | 3831.6 | 94180.0 |
| 2010-04-08 | G | Futures | 75.91 | 76.21 | 75.88 | 76.07 | 95340.0 |
| 2010-04-08 | GF | Futures | 293.559 | 295.385 | 293.298 | 294.537 | 1471.0 |
| 2010-04-08 | GSCI | Futures | 994.65 | 998.23 | 988.48 | 993.73 | 2751.0 |
| 2010-04-08 | HE | Futures | 100.691 | 101.607 | 99.623 | 101.21 | 405.0 |
| 2010-04-08 | HG | Futures | 4.898 | 4.9048 | 4.8297 | 4.9 | 27979.0 |
| 2010-04-08 | HO | Futures | 2.0542 | 2.0608 | 2.0274 | 2.0456 | 34253.0 |
| 2010-04-08 | HRC | Futures | 3221.8 | 3221.8 | 3221.8 | 3221.8 | 0.0 |
| 2010-04-08 | J1 | Futures | 0.0134846 | 0.01355 | 0.0134544 | 0.0134657 | 106292.0 |
| 2010-04-08 | J7 | Futures | 0.013367 | 0.013441 | 0.01335 | 0.013358 | 247.0 |
| 2010-04-08 | JB | Futures | 117.25 | 117.64 | 117.17 | 117.63 | 2011.0 |
| 2010-04-08 | KC | Futures | 352.88 | 353.4 | 343.64 | 345.95 | 22726.0 |
| 2010-04-08 | KE | Futures | 2171.32 | 2175.75 | 2144.73 | 2151.38 | 8107.0 |
> showing 50 of 91 rows — these rows as CSV