PREVIEW / futures_daily / 2011-03-29
file: by_date/futures_daily/2011/2011-03-29.parquet size: 9 KB rows: 94
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-03-29 | ES | Futures | 1289.74 | 1304.59 | 1287.26 | 1303.35 | 1549071.0 |
| 2011-03-29 | NQ | Futures | 2615.74 | 2647.63 | 2607.48 | 2645.06 | 221150.0 |
| 2011-03-29 | YM | Futures | 11392.1 | 11503.1 | 11383.7 | 11493.7 | 91646.0 |
| 2011-03-29 | CL | Futures | 201.0 | 203.05 | 198.6 | 202.64 | 246824.0 |
| 2011-03-29 | GC | Futures | 1925.4 | 1928.3 | 1911.3 | 1918.6 | 140893.0 |
| 2011-03-29 | ZN | Futures | 100.447185 | 100.552531 | 100.012634 | 100.091643 | 963093.0 |
| 2011-03-29 | A6 | Futures | 0.87037 | 0.87475 | 0.86694 | 0.87423 | 74353.0 |
| 2011-03-29 | AD | Futures | 1.01584 | 1.02082 | 1.01584 | 1.01932 | 46073.0 |
| 2011-03-29 | B | Futures | 97.09 | 97.92 | 96.12 | 97.51 | 73840.0 |
| 2011-03-29 | B6 | Futures | 1.6594 | 1.665 | 1.6546 | 1.6596 | 90698.0 |
| 2011-03-29 | BFX | Futures | 3066.8 | 3100.3 | 3043.7 | 3100.3 | 1037.0 |
| 2011-03-29 | BR | Futures | 0.26226 | 0.26323 | 0.26226 | 0.26248 | 109.0 |
| 2011-03-29 | BZ | Futures | 102.86 | 102.86 | 102.81 | 102.81 | 699.0 |
| 2011-03-29 | C | Futures | 2330.0 | 2335.0 | 2202.0 | 2205.0 | 10078.0 |
| 2011-03-29 | CB | Futures | 117.335 | 117.335 | 116.895 | 117.335 | 15.0 |
| 2011-03-29 | CC | Futures | 2605.0 | 2610.0 | 2435.0 | 2457.0 | 18362.0 |
| 2011-03-29 | CSC | Futures | 4.386 | 4.386 | 4.358 | 4.386 | 2.0 |
| 2011-03-29 | CT | Futures | 175.74 | 179.74 | 173.57 | 174.27 | 7214.0 |
| 2011-03-29 | DC | Futures | 29.78 | 29.84 | 28.91 | 29.1 | 363.0 |
| 2011-03-29 | DX | Futures | 76.108 | 76.317 | 75.79 | 76.12 | 20736.0 |
| 2011-03-29 | E1 | Futures | 1.42868 | 1.43352 | 1.42004 | 1.42122 | 38219.0 |
| 2011-03-29 | E6 | Futures | 1.66599 | 1.67369 | 1.66137 | 1.66635 | 277555.0 |
| 2011-03-29 | E7 | Futures | 1.6537 | 1.6612 | 1.649 | 1.6539 | 5129.0 |
| 2011-03-29 | EBM | Futures | 228.27 | 231.32 | 221.93 | 225.92 | 13267.0 |
| 2011-03-29 | ED | Futures | 94.8454 | 94.855 | 94.8407 | 94.8454 | 156433.0 |
| 2011-03-29 | ER | Futures | 97.247 | 97.281 | 97.247 | 97.267 | 167667.0 |
| 2011-03-29 | EW | Futures | 956.0 | 968.1 | 953.2 | 967.8 | 20487.0 |
| 2011-03-29 | FBTP | Futures | 64.17 | 64.17 | 63.95 | 64.0 | 5296.0 |
| 2011-03-29 | FCE | Futures | 2646.6 | 2661.9 | 2628.9 | 2655.9 | 117917.0 |
| 2011-03-29 | FDAX | Futures | 7426.8 | 7453.5 | 7352.0 | 7431.0 | 134993.0 |
| 2011-03-29 | FESX | Futures | 1817.1 | 1822.8 | 1797.8 | 1816.4 | 948323.0 |
| 2011-03-29 | FEU3 | Futures | 97.795 | 97.82 | 97.795 | 97.81 | 11.0 |
| 2011-03-29 | FGBL | Futures | 97.46 | 97.51 | 96.99 | 97.22 | 772106.0 |
| 2011-03-29 | FGBM | Futures | 102.9 | 102.9 | 102.53 | 102.68 | 474197.0 |
| 2011-03-29 | FGBS | Futures | 106.35 | 106.355 | 106.246 | 106.27 | 562033.0 |
| 2011-03-29 | FGBX | Futures | 93.68 | 93.74 | 92.98 | 93.11 | 4378.0 |
| 2011-03-29 | FTDX | Futures | 829.7 | 829.7 | 813.2 | 820.3 | 906.0 |
| 2011-03-29 | FTI | Futures | 295.38 | 297.63 | 294.36 | 297.01 | 31818.0 |
| 2011-03-29 | FTUK | Futures | 4085.0 | 4128.7 | 4083.3 | 4119.3 | 77105.0 |
| 2011-03-29 | FXXP | Futures | 182.0 | 182.0 | 180.4 | 181.7 | 1008.0 |
| 2011-03-29 | G | Futures | 81.77 | 81.9 | 81.59 | 81.66 | 99593.0 |
| 2011-03-29 | GF | Futures | 326.525 | 330.276 | 325.859 | 328.4 | 658.0 |
| 2011-03-29 | GSCI | Futures | 1107.66 | 1118.15 | 1106.8 | 1116.27 | 91.0 |
| 2011-03-29 | HE | Futures | 108.168 | 108.912 | 107.902 | 108.806 | 655.0 |
| 2011-03-29 | HG | Futures | 5.7955 | 5.8208 | 5.7176 | 5.7895 | 28865.0 |
| 2011-03-29 | HO | Futures | 2.5342 | 2.56 | 2.5183 | 2.5508 | 17474.0 |
| 2011-03-29 | HRC | Futures | 3088.3 | 3088.3 | 3088.3 | 3088.3 | 0.0 |
| 2011-03-29 | J1 | Futures | 0.0153835 | 0.0154149 | 0.0152365 | 0.0152453 | 132002.0 |
| 2011-03-29 | J7 | Futures | 0.015282 | 0.015319 | 0.015144 | 0.015152 | 555.0 |
| 2011-03-29 | JB | Futures | 121.53 | 121.86 | 121.47 | 121.47 | 1381.0 |
> showing 50 of 94 rows — these rows as CSV