PREVIEW / futures_daily / 2013-08-05
file: by_date/futures_daily/2013/2013-08-05.parquet size: 9 KB rows: 101
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-08-05 | ES | Futures | 1753.77 | 1756.09 | 1749.65 | 1753.51 | 856742.0 |
| 2013-08-05 | NQ | Futures | 3627.85 | 3632.48 | 3618.31 | 3627.57 | 114587.0 |
| 2013-08-05 | YM | Futures | 15447.2 | 15459.1 | 15386.7 | 15416.5 | 67119.0 |
| 2013-08-05 | CL | Futures | 186.6 | 188.08 | 184.6 | 186.11 | 204860.0 |
| 2013-08-05 | GC | Futures | 1735.4 | 1746.2 | 1714.9 | 1722.5 | 97862.0 |
| 2013-08-05 | ZN | Futures | 113.699928 | 113.770113 | 113.349002 | 113.50341 | 699487.0 |
| 2013-08-05 | A6 | Futures | 0.83383 | 0.83589 | 0.82782 | 0.83383 | 72996.0 |
| 2013-08-05 | AD | Futures | 0.96885 | 0.97167 | 0.96744 | 0.97076 | 43971.0 |
| 2013-08-05 | B | Futures | 105.87 | 106.45 | 104.62 | 105.68 | 118882.0 |
| 2013-08-05 | B6 | Futures | 1.6017 | 1.6118 | 1.5994 | 1.6088 | 98980.0 |
| 2013-08-05 | BFX | Futures | 3320.6 | 3321.4 | 3320.6 | 3321.4 | 5.0 |
| 2013-08-05 | BR | Futures | 0.2167 | 0.2167 | 0.21343 | 0.2138 | 183.0 |
| 2013-08-05 | BZ | Futures | 106.45 | 107.21 | 105.41 | 106.45 | 11990.0 |
| 2013-08-05 | C | Futures | 1665.0 | 1724.0 | 1660.0 | 1709.0 | 7708.0 |
| 2013-08-05 | CB | Futures | 72.965 | 73.013 | 72.953 | 73.013 | 11.0 |
| 2013-08-05 | CC | Futures | 1712.0 | 1788.0 | 1712.0 | 1769.0 | 16552.0 |
| 2013-08-05 | CNH | Futures | 7.107 | 7.107 | 7.1018 | 7.1018 | 10.0 |
| 2013-08-05 | CSC | Futures | 3.48 | 3.509 | 3.452 | 3.452 | 34.0 |
| 2013-08-05 | CT | Futures | 101.53 | 102.15 | 101.53 | 101.7 | 7.0 |
| 2013-08-05 | DC | Futures | 26.63 | 27.09 | 26.38 | 26.47 | 442.0 |
| 2013-08-05 | DX | Futures | 78.377 | 78.52 | 78.186 | 78.306 | 24480.0 |
| 2013-08-05 | E1 | Futures | 1.38404 | 1.38738 | 1.37748 | 1.38519 | 28407.0 |
| 2013-08-05 | E6 | Futures | 1.5679 | 1.5699 | 1.56176 | 1.56495 | 155132.0 |
| 2013-08-05 | E7 | Futures | 1.5574 | 1.5597 | 1.5512 | 1.5547 | 2957.0 |
| 2013-08-05 | ED | Futures | 95.2964 | 95.3012 | 95.2964 | 95.2964 | 47224.0 |
| 2013-08-05 | ER | Futures | 97.822 | 97.832 | 97.817 | 97.822 | 27313.0 |
| 2013-08-05 | EW | Futures | 1273.5 | 1276.4 | 1270.1 | 1274.6 | 10054.0 |
| 2013-08-05 | FBTP | Futures | 78.38 | 78.76 | 78.36 | 78.39 | 20357.0 |
| 2013-08-05 | FBTS | Futures | 93.186 | 93.281 | 93.143 | 93.16 | 3711.0 |
| 2013-08-05 | FCE | Futures | 3135.1 | 3141.3 | 3123.5 | 3130.9 | 50741.0 |
| 2013-08-05 | FDAX | Futures | 9354.5 | 9364.5 | 9287.9 | 9324.0 | 51720.0 |
| 2013-08-05 | FESX | Futures | 1978.6 | 1980.8 | 1964.6 | 1972.3 | 428840.0 |
| 2013-08-05 | FGBL | Futures | 119.51 | 119.7 | 118.99 | 119.08 | 456068.0 |
| 2013-08-05 | FGBM | Futures | 117.18 | 117.27 | 116.96 | 117.0 | 316563.0 |
| 2013-08-05 | FGBS | Futures | 110.308 | 110.323 | 110.258 | 110.263 | 223133.0 |
| 2013-08-05 | FGBX | Futures | 124.02 | 124.34 | 122.96 | 123.19 | 8804.0 |
| 2013-08-05 | FMWO | Futures | 5024.4 | 5024.4 | 5024.4 | 5024.4 | 0.0 |
| 2013-08-05 | FOAT | Futures | 107.05 | 107.13 | 106.48 | 106.5 | 28948.0 |
| 2013-08-05 | FTDX | Futures | 950.3 | 952.2 | 948.0 | 950.3 | 76.0 |
| 2013-08-05 | FTI | Futures | 324.4 | 325.58 | 323.44 | 324.66 | 15373.0 |
| 2013-08-05 | FTUK | Futures | 4955.7 | 4980.4 | 4906.2 | 4930.5 | 61357.0 |
| 2013-08-05 | FVSA | Futures | 2581.5 | 2609.94 | 2574.38 | 2588.61 | 2272.0 |
| 2013-08-05 | FXXP | Futures | 224.3 | 224.9 | 223.3 | 224.0 | 7829.0 |
| 2013-08-05 | G | Futures | 94.42 | 94.62 | 93.76 | 93.87 | 119139.0 |
| 2013-08-05 | GF | Futures | 259.894 | 260.147 | 258.841 | 259.431 | 969.0 |
| 2013-08-05 | GSCI | Futures | 1044.15 | 1048.15 | 1041.04 | 1046.93 | 122.0 |
| 2013-08-05 | HE | Futures | 101.557 | 103.734 | 101.436 | 103.432 | 18510.0 |
| 2013-08-05 | HG | Futures | 4.0279 | 4.0463 | 3.9943 | 4.0197 | 38588.0 |
| 2013-08-05 | HH | Futures | 36.95 | 36.994 | 36.477 | 36.565 | 317.0 |
| 2013-08-05 | HO | Futures | 2.4666 | 2.4779 | 2.4255 | 2.4512 | 44220.0 |
> showing 50 of 101 rows — these rows as CSV