PREVIEW / futures_daily / 2013-05-06
file: by_date/futures_daily/2013/2013-05-06.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 |
|---|---|---|---|---|---|---|---|
| 2013-05-06 | ES | Futures | 1651.13 | 1658.31 | 1650.1 | 1656.52 | 963963.0 |
| 2013-05-06 | NQ | Futures | 3392.21 | 3412.13 | 3391.92 | 3404.63 | 134824.0 |
| 2013-05-06 | YM | Futures | 14673.1 | 14698.7 | 14653.4 | 14678.0 | 73286.0 |
| 2013-05-06 | CL | Futures | 166.7 | 169.47 | 165.42 | 167.71 | 271004.0 |
| 2013-05-06 | GC | Futures | 1951.5 | 1962.6 | 1943.2 | 1948.8 | 80796.0 |
| 2013-05-06 | ZN | Futures | 118.366396 | 118.38031 | 118.115944 | 118.143772 | 747942.0 |
| 2013-05-06 | A6 | Futures | 0.94851 | 0.9486 | 0.94057 | 0.9426 | 78914.0 |
| 2013-05-06 | AD | Futures | 0.99592 | 0.99743 | 0.99421 | 0.99702 | 42315.0 |
| 2013-05-06 | B | Futures | 99.87 | 101.13 | 99.54 | 101.06 | 66582.0 |
| 2013-05-06 | B6 | Futures | 1.6285 | 1.6317 | 1.6237 | 1.6263 | 46804.0 |
| 2013-05-06 | BFX | Futures | 3231.1 | 3231.2 | 3212.1 | 3212.1 | 87.0 |
| 2013-05-06 | BR | Futures | 0.24495 | 0.24532 | 0.24495 | 0.24495 | 203.0 |
| 2013-05-06 | BZ | Futures | 101.46 | 102.12 | 100.56 | 102.08 | 2605.0 |
| 2013-05-06 | CB | Futures | 84.31 | 84.31 | 83.817 | 84.31 | 8.0 |
| 2013-05-06 | CC | Futures | 1809.0 | 1811.0 | 1788.0 | 1801.0 | 7534.0 |
| 2013-05-06 | CNH | Futures | 7.1842 | 7.2283 | 7.1842 | 7.2107 | 134.0 |
| 2013-05-06 | CSC | Futures | 3.778 | 3.778 | 3.726 | 3.75 | 35.0 |
| 2013-05-06 | CT | Futures | 103.49 | 104.83 | 103.49 | 104.73 | 10545.0 |
| 2013-05-06 | DC | Futures | 28.53 | 28.68 | 28.4 | 28.65 | 399.0 |
| 2013-05-06 | DX | Futures | 78.943 | 79.265 | 78.847 | 79.172 | 20038.0 |
| 2013-05-06 | E1 | Futures | 1.37594 | 1.378 | 1.36938 | 1.37131 | 21640.0 |
| 2013-05-06 | E6 | Futures | 1.5469 | 1.54973 | 1.53924 | 1.54219 | 133956.0 |
| 2013-05-06 | E7 | Futures | 1.5368 | 1.5395 | 1.5292 | 1.5321 | 2164.0 |
| 2013-05-06 | ED | Futures | 95.2683 | 95.2683 | 95.2635 | 95.2683 | 31344.0 |
| 2013-05-06 | ER | Futures | 97.842 | 97.847 | 97.832 | 97.842 | 38513.0 |
| 2013-05-06 | EW | Futures | 1185.0 | 1193.7 | 1184.4 | 1192.7 | 15041.0 |
| 2013-05-06 | FBTP | Futures | 80.17 | 80.48 | 79.88 | 79.92 | 15257.0 |
| 2013-05-06 | FBTS | Futures | 93.1 | 93.177 | 93.031 | 93.04 | 3401.0 |
| 2013-05-06 | FCE | Futures | 2983.3 | 2986.4 | 2970.6 | 2979.0 | 44687.0 |
| 2013-05-06 | FDAX | Futures | 9040.4 | 9063.7 | 9010.9 | 9019.3 | 51933.0 |
| 2013-05-06 | FDIV | Futures | 121.84 | 121.84 | 121.79 | 121.79 | 1.0 |
| 2013-05-06 | FESX | Futures | 1909.2 | 1909.9 | 1896.6 | 1900.1 | 368422.0 |
| 2013-05-06 | FEU3 | Futures | 98.438 | 98.443 | 98.433 | 98.443 | 450.0 |
| 2013-05-06 | FGBL | Futures | 122.49 | 122.67 | 122.34 | 122.5 | 289903.0 |
| 2013-05-06 | FGBM | Futures | 118.23 | 118.3 | 118.17 | 118.29 | 183697.0 |
| 2013-05-06 | FGBS | Futures | 110.527 | 110.547 | 110.512 | 110.542 | 110575.0 |
| 2013-05-06 | FGBX | Futures | 130.04 | 130.1 | 129.64 | 129.93 | 4803.0 |
| 2013-05-06 | FMWO | Futures | 4850.9 | 4850.9 | 4850.9 | 4850.9 | 0.0 |
| 2013-05-06 | FOAT | Futures | 109.87 | 110.07 | 109.82 | 110.04 | 11362.0 |
| 2013-05-06 | FTDX | Futures | 880.0 | 887.1 | 880.0 | 882.9 | 90.0 |
| 2013-05-06 | FTI | Futures | 309.09 | 309.92 | 308.39 | 308.66 | 14170.0 |
| 2013-05-06 | FVSA | Futures | 2923.15 | 2970.68 | 2915.22 | 2923.15 | 1507.0 |
| 2013-05-06 | FXXP | Futures | 219.7 | 220.1 | 219.3 | 219.8 | 1790.0 |
| 2013-05-06 | GF | Futures | 252.563 | 252.789 | 249.89 | 250.796 | 2099.0 |
| 2013-05-06 | GSCI | Futures | 1010.91 | 1016.53 | 1008.34 | 1016.53 | 284.0 |
| 2013-05-06 | HE | Futures | 90.348 | 90.912 | 89.44 | 89.588 | 23983.0 |
| 2013-05-06 | HG | Futures | 4.2048 | 4.2424 | 4.1787 | 4.2176 | 43643.0 |
| 2013-05-06 | HH | Futures | 45.058 | 45.507 | 44.665 | 45.069 | 431.0 |
| 2013-05-06 | HO | Futures | 2.3203 | 2.3526 | 2.3117 | 2.3507 | 49783.0 |
| 2013-05-06 | HRC | Futures | 2135.1 | 2135.1 | 2135.1 | 2135.1 | 0.0 |
> showing 50 of 99 rows — these rows as CSV