PREVIEW / futures_daily / 2011-03-16
file: by_date/futures_daily/2011/2011-03-16.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-16 | ES | Futures | 1262.01 | 1270.68 | 1230.83 | 1241.47 | 4540281.0 |
| 2011-03-16 | NQ | Futures | 2557.65 | 2575.88 | 2490.17 | 2515.23 | 628574.0 |
| 2011-03-16 | YM | Futures | 11074.3 | 11140.1 | 10804.5 | 10885.4 | 254001.0 |
| 2011-03-16 | CL | Futures | 189.63 | 194.48 | 187.62 | 191.35 | 225137.0 |
| 2011-03-16 | GC | Futures | 1892.9 | 1908.9 | 1889.5 | 1894.7 | 151887.0 |
| 2011-03-16 | ZN | Futures | 101.566484 | 102.672614 | 101.210942 | 102.18539 | 2126048.0 |
| 2011-03-16 | A6 | Futures | 0.83924 | 0.84524 | 0.82801 | 0.83418 | 199051.0 |
| 2011-03-16 | AD | Futures | 1.00847 | 1.01335 | 0.99702 | 1.0019 | 126663.0 |
| 2011-03-16 | B | Futures | 92.1 | 95.0 | 91.09 | 93.81 | 223522.0 |
| 2011-03-16 | B6 | Futures | 1.6701 | 1.6741 | 1.6591 | 1.6634 | 116241.0 |
| 2011-03-16 | BFX | Futures | 2978.3 | 2978.3 | 2900.6 | 2916.5 | 1295.0 |
| 2011-03-16 | BR | Futures | 0.2603 | 0.2603 | 0.25826 | 0.25931 | 118.0 |
| 2011-03-16 | BZ | Futures | 98.34 | 100.03 | 98.08 | 98.82 | 1596.0 |
| 2011-03-16 | C | Futures | 2337.0 | 2389.0 | 2304.0 | 2321.0 | 9784.0 |
| 2011-03-16 | CB | Futures | 116.177 | 116.177 | 116.162 | 116.177 | 1.0 |
| 2011-03-16 | CC | Futures | 2622.0 | 2672.0 | 2548.0 | 2584.0 | 13175.0 |
| 2011-03-16 | CSC | Futures | 4.224 | 4.25 | 4.217 | 4.219 | 50.0 |
| 2011-03-16 | CT | Futures | 169.9 | 177.0 | 165.44 | 165.54 | 15647.0 |
| 2011-03-16 | DC | Futures | 27.79 | 28.0 | 27.44 | 27.65 | 304.0 |
| 2011-03-16 | DX | Futures | 76.357 | 76.75 | 76.253 | 76.602 | 37535.0 |
| 2011-03-16 | E1 | Futures | 1.42933 | 1.44439 | 1.42462 | 1.44086 | 63855.0 |
| 2011-03-16 | E6 | Futures | 1.65557 | 1.6564 | 1.64029 | 1.64431 | 370287.0 |
| 2011-03-16 | E7 | Futures | 1.6435 | 1.6441 | 1.6282 | 1.6321 | 5806.0 |
| 2011-03-16 | EBM | Futures | 196.56 | 201.26 | 191.87 | 193.75 | 16987.0 |
| 2011-03-16 | ED | Futures | 94.8645 | 94.8692 | 94.8312 | 94.8407 | 391090.0 |
| 2011-03-16 | ER | Futures | 97.321 | 97.39 | 97.291 | 97.346 | 259560.0 |
| 2011-03-16 | EW | Futures | 933.8 | 940.2 | 919.2 | 926.3 | 47800.0 |
| 2011-03-16 | FBTP | Futures | 64.12 | 64.58 | 64.12 | 64.51 | 7422.0 |
| 2011-03-16 | FCE | Futures | 2506.2 | 2531.4 | 2416.3 | 2462.6 | 158553.0 |
| 2011-03-16 | FDAX | Futures | 7092.8 | 7213.3 | 6866.9 | 6992.2 | 394085.0 |
| 2011-03-16 | FESX | Futures | 1725.4 | 1751.1 | 1659.5 | 1698.5 | 1912439.0 |
| 2011-03-16 | FEU3 | Futures | 97.85 | 97.929 | 97.85 | 97.89 | 1018.0 |
| 2011-03-16 | FGBL | Futures | 98.28 | 99.16 | 98.15 | 98.94 | 1262722.0 |
| 2011-03-16 | FGBM | Futures | 103.52 | 104.3 | 103.45 | 104.08 | 870934.0 |
| 2011-03-16 | FGBS | Futures | 106.647 | 106.984 | 106.608 | 106.855 | 1088476.0 |
| 2011-03-16 | FGBX | Futures | 95.79 | 97.31 | 95.73 | 96.92 | 7097.0 |
| 2011-03-16 | FTDX | Futures | 787.7 | 788.2 | 762.7 | 767.2 | 4245.0 |
| 2011-03-16 | FTI | Futures | 282.54 | 284.91 | 274.68 | 278.79 | 37789.0 |
| 2011-03-16 | FTUK | Futures | 3975.8 | 3980.0 | 3820.8 | 3898.8 | 179763.0 |
| 2011-03-16 | FXXP | Futures | 175.4 | 175.8 | 171.2 | 172.3 | 7933.0 |
| 2011-03-16 | G | Futures | 82.01 | 82.56 | 81.94 | 82.46 | 135655.0 |
| 2011-03-16 | GF | Futures | 315.574 | 317.268 | 308.919 | 309.04 | 2595.0 |
| 2011-03-16 | GSCI | Futures | 1073.61 | 1077.52 | 1054.51 | 1059.91 | 683.0 |
| 2011-03-16 | HE | Futures | 98.976 | 100.784 | 98.83 | 99.53 | 13914.0 |
| 2011-03-16 | HG | Futures | 5.581 | 5.6876 | 5.5544 | 5.591 | 47444.0 |
| 2011-03-16 | HO | Futures | 2.472 | 2.5368 | 2.4408 | 2.5021 | 32392.0 |
| 2011-03-16 | HRC | Futures | 3098.9 | 3098.9 | 3098.9 | 3098.9 | 0.0 |
| 2011-03-16 | J1 | Futures | 0.0155657 | 0.0158006 | 0.0154878 | 0.0156888 | 223995.0 |
| 2011-03-16 | J7 | Futures | 0.015458 | 0.015706 | 0.015394 | 0.015593 | 1294.0 |
| 2011-03-16 | JB | Futures | 121.76 | 121.98 | 121.53 | 121.78 | 2612.0 |
> showing 50 of 94 rows — these rows as CSV