PREVIEW / futures_daily / 2013-05-07
file: by_date/futures_daily/2013/2013-05-07.parquet size: 9 KB rows: 103
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-07 | ES | Futures | 1655.49 | 1664.99 | 1652.15 | 1663.7 | 1507222.0 |
| 2013-05-07 | NQ | Futures | 3404.63 | 3415.31 | 3392.79 | 3403.47 | 176584.0 |
| 2013-05-07 | YM | Futures | 14673.1 | 14767.6 | 14648.5 | 14753.8 | 105798.0 |
| 2013-05-07 | CL | Futures | 167.06 | 167.88 | 165.55 | 166.77 | 260141.0 |
| 2013-05-07 | GC | Futures | 1950.3 | 1951.5 | 1912.2 | 1923.3 | 192504.0 |
| 2013-05-07 | ZN | Futures | 118.227256 | 118.338568 | 118.018546 | 118.10203 | 870605.0 |
| 2013-05-07 | A6 | Futures | 0.94362 | 0.94371 | 0.93457 | 0.93734 | 128051.0 |
| 2013-05-07 | AD | Futures | 0.99692 | 1.00024 | 0.99562 | 0.99933 | 62763.0 |
| 2013-05-07 | B | Futures | 100.93 | 101.43 | 99.73 | 100.13 | 189151.0 |
| 2013-05-07 | B6 | Futures | 1.6259 | 1.627 | 1.6158 | 1.6202 | 87379.0 |
| 2013-05-07 | BFX | Futures | 3239.6 | 3249.3 | 3239.6 | 3244.0 | 25.0 |
| 2013-05-07 | BR | Futures | 0.24527 | 0.24619 | 0.2448 | 0.24567 | 570.0 |
| 2013-05-07 | BZ | Futures | 101.65 | 102.45 | 100.77 | 101.14 | 8765.0 |
| 2013-05-07 | C | Futures | 1647.0 | 1662.0 | 1643.0 | 1654.0 | 2911.0 |
| 2013-05-07 | CB | Futures | 83.694 | 83.694 | 83.694 | 83.694 | 5.0 |
| 2013-05-07 | CC | Futures | 1794.0 | 1815.0 | 1791.0 | 1797.0 | 14834.0 |
| 2013-05-07 | CNH | Futures | 7.2121 | 7.2121 | 7.1884 | 7.1896 | 90.0 |
| 2013-05-07 | CSC | Futures | 3.754 | 3.754 | 3.684 | 3.686 | 53.0 |
| 2013-05-07 | CT | Futures | 104.69 | 104.81 | 102.49 | 104.45 | 14075.0 |
| 2013-05-07 | DC | Futures | 28.65 | 28.86 | 28.07 | 28.13 | 556.0 |
| 2013-05-07 | DX | Futures | 79.174 | 79.217 | 78.924 | 79.131 | 18348.0 |
| 2013-05-07 | E1 | Futures | 1.37131 | 1.37375 | 1.36359 | 1.36912 | 26734.0 |
| 2013-05-07 | E6 | Futures | 1.54183 | 1.54855 | 1.54101 | 1.54301 | 183012.0 |
| 2013-05-07 | E7 | Futures | 1.5317 | 1.5385 | 1.531 | 1.5329 | 2439.0 |
| 2013-05-07 | ED | Futures | 95.2683 | 95.2683 | 95.2635 | 95.2683 | 44353.0 |
| 2013-05-07 | ER | Futures | 97.842 | 97.842 | 97.827 | 97.827 | 110815.0 |
| 2013-05-07 | EW | Futures | 1191.2 | 1203.7 | 1190.3 | 1202.2 | 21793.0 |
| 2013-05-07 | FBTP | Futures | 80.14 | 80.44 | 79.9 | 80.25 | 25096.0 |
| 2013-05-07 | FBTS | Futures | 93.083 | 93.211 | 93.023 | 93.143 | 5645.0 |
| 2013-05-07 | FCE | Futures | 2984.4 | 3006.8 | 2979.0 | 2992.1 | 84742.0 |
| 2013-05-07 | FDAX | Futures | 9031.5 | 9127.1 | 9026.5 | 9087.1 | 83893.0 |
| 2013-05-07 | FESX | Futures | 1904.3 | 1921.8 | 1901.5 | 1912.0 | 744384.0 |
| 2013-05-07 | FEU3 | Futures | 98.428 | 98.428 | 98.428 | 98.428 | 200.0 |
| 2013-05-07 | FGBL | Futures | 122.52 | 122.59 | 121.84 | 121.89 | 840435.0 |
| 2013-05-07 | FGBM | Futures | 118.32 | 118.32 | 117.93 | 117.94 | 589381.0 |
| 2013-05-07 | FGBS | Futures | 110.552 | 110.552 | 110.467 | 110.487 | 291341.0 |
| 2013-05-07 | FGBX | Futures | 129.89 | 130.04 | 128.68 | 128.75 | 11727.0 |
| 2013-05-07 | FMWO | Futures | 4863.6 | 4863.6 | 4863.6 | 4863.6 | 0.0 |
| 2013-05-07 | FOAT | Futures | 110.05 | 110.15 | 109.61 | 109.65 | 44470.0 |
| 2013-05-07 | FTDX | Futures | 884.3 | 890.4 | 884.3 | 885.7 | 59.0 |
| 2013-05-07 | FTI | Futures | 309.09 | 310.31 | 308.26 | 308.87 | 20569.0 |
| 2013-05-07 | FTUK | Futures | 4816.3 | 4852.3 | 4808.9 | 4836.7 | 80693.0 |
| 2013-05-07 | FVSA | Futures | 2867.69 | 2931.07 | 2796.4 | 2836.01 | 7977.0 |
| 2013-05-07 | FXXP | Futures | 219.9 | 220.9 | 219.9 | 220.0 | 3681.0 |
| 2013-05-07 | G | Futures | 100.25 | 100.31 | 99.59 | 99.73 | 166523.0 |
| 2013-05-07 | GF | Futures | 249.98 | 250.388 | 247.443 | 248.032 | 2730.0 |
| 2013-05-07 | GSCI | Futures | 1015.33 | 1017.33 | 1009.38 | 1010.27 | 1386.0 |
| 2013-05-07 | HE | Futures | 89.686 | 90.127 | 89.44 | 89.563 | 28127.0 |
| 2013-05-07 | HG | Futures | 4.2004 | 4.2647 | 4.157 | 4.2074 | 79218.0 |
| 2013-05-07 | HH | Futures | 44.676 | 44.844 | 44.002 | 44.047 | 904.0 |
> showing 50 of 103 rows — these rows as CSV