PREVIEW / futures_daily / 2013-01-14
file: by_date/futures_daily/2013/2013-01-14.parquet size: 9 KB rows: 100
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-01-14 | ES | Futures | 1500.77 | 1505.38 | 1494.12 | 1498.21 | 1168502.0 |
| 2013-01-14 | NQ | Futures | 3165.04 | 3172.25 | 3136.49 | 3147.45 | 207499.0 |
| 2013-01-14 | YM | Futures | 13171.3 | 13195.9 | 13136.0 | 13172.3 | 89707.0 |
| 2013-01-14 | CL | Futures | 166.05 | 166.94 | 164.59 | 166.69 | 110113.0 |
| 2013-01-14 | GC | Futures | 2211.5 | 2231.9 | 2211.5 | 2224.7 | 126856.0 |
| 2013-01-14 | ZN | Futures | 116.34913 | 116.638556 | 116.307783 | 116.459387 | 787313.0 |
| 2013-01-14 | A6 | Futures | 0.95939 | 0.96341 | 0.9582 | 0.96231 | 66792.0 |
| 2013-01-14 | AD | Futures | 1.01673 | 1.01854 | 1.01493 | 1.01783 | 49010.0 |
| 2013-01-14 | B | Futures | 103.09 | 104.32 | 102.67 | 104.07 | 188587.0 |
| 2013-01-14 | B6 | Futures | 1.6855 | 1.6878 | 1.6747 | 1.6807 | 101229.0 |
| 2013-01-14 | BR | Futures | 0.23998 | 0.23998 | 0.23998 | 0.23998 | 52.0 |
| 2013-01-14 | BZ | Futures | 105.4 | 106.53 | 105.0 | 106.39 | 1331.0 |
| 2013-01-14 | C | Futures | 1538.0 | 1570.0 | 1533.0 | 1555.0 | 11767.0 |
| 2013-01-14 | CB | Futures | 82.491 | 83.194 | 82.426 | 83.194 | 6.0 |
| 2013-01-14 | CC | Futures | 1702.0 | 1732.0 | 1682.0 | 1710.0 | 18481.0 |
| 2013-01-14 | CSC | Futures | 3.802 | 3.802 | 3.749 | 3.766 | 77.0 |
| 2013-01-14 | CT | Futures | 95.17 | 95.68 | 94.54 | 95.04 | 11095.0 |
| 2013-01-14 | DC | Futures | 27.91 | 28.04 | 27.69 | 27.91 | 239.0 |
| 2013-01-14 | DX | Futures | 76.707 | 76.875 | 76.581 | 76.711 | 25940.0 |
| 2013-01-14 | E1 | Futures | 1.41071 | 1.41264 | 1.39578 | 1.39745 | 32492.0 |
| 2013-01-14 | E6 | Futures | 1.57745 | 1.58194 | 1.57356 | 1.57863 | 225105.0 |
| 2013-01-14 | E7 | Futures | 1.5669 | 1.5711 | 1.5629 | 1.5679 | 9754.0 |
| 2013-01-14 | EBM | Futures | 275.9 | 278.12 | 275.9 | 277.56 | 17744.0 |
| 2013-01-14 | ED | Futures | 95.239 | 95.2438 | 95.2342 | 95.239 | 93710.0 |
| 2013-01-14 | ER | Futures | 97.773 | 97.788 | 97.744 | 97.759 | 152792.0 |
| 2013-01-14 | EW | Futures | 1076.2 | 1080.0 | 1073.6 | 1076.3 | 14571.0 |
| 2013-01-14 | FBTP | Futures | 77.62 | 77.62 | 77.02 | 77.23 | 19470.0 |
| 2013-01-14 | FBTS | Futures | 91.806 | 91.942 | 91.781 | 91.84 | 4818.0 |
| 2013-01-14 | FCE | Futures | 2790.3 | 2799.7 | 2779.0 | 2784.7 | 37197.0 |
| 2013-01-14 | FDAX | Futures | 8458.9 | 8508.6 | 8415.2 | 8452.3 | 103074.0 |
| 2013-01-14 | FESX | Futures | 1856.1 | 1859.5 | 1840.4 | 1847.2 | 632008.0 |
| 2013-01-14 | FEU3 | Futures | 98.374 | 98.374 | 98.364 | 98.364 | 220.0 |
| 2013-01-14 | FGBL | Futures | 117.77 | 118.15 | 117.73 | 118.01 | 604961.0 |
| 2013-01-14 | FGBM | Futures | 116.26 | 116.4 | 116.18 | 116.31 | 367175.0 |
| 2013-01-14 | FGBS | Futures | 110.213 | 110.243 | 110.183 | 110.218 | 304690.0 |
| 2013-01-14 | FGBX | Futures | 122.62 | 123.58 | 122.62 | 123.29 | 6666.0 |
| 2013-01-14 | FOAT | Futures | 105.04 | 105.19 | 104.86 | 105.06 | 14857.0 |
| 2013-01-14 | FTDX | Futures | 826.5 | 829.8 | 819.9 | 821.3 | 517.0 |
| 2013-01-14 | FTI | Futures | 300.76 | 300.76 | 297.53 | 298.22 | 9127.0 |
| 2013-01-14 | FTUK | Futures | 4474.4 | 4486.2 | 4453.4 | 4466.7 | 74708.0 |
| 2013-01-14 | FVSA | Futures | 3330.03 | 3339.1 | 3239.29 | 3266.51 | 13676.0 |
| 2013-01-14 | FXXP | Futures | 206.6 | 206.7 | 205.2 | 205.6 | 3807.0 |
| 2013-01-14 | G | Futures | 96.8 | 97.13 | 96.77 | 97.06 | 138828.0 |
| 2013-01-14 | GF | Futures | 281.919 | 283.741 | 280.752 | 282.9 | 4209.0 |
| 2013-01-14 | GSCI | Futures | 1051.52 | 1055.69 | 1046.45 | 1055.37 | 2867.0 |
| 2013-01-14 | HE | Futures | 96.916 | 98.007 | 96.716 | 97.806 | 28851.0 |
| 2013-01-14 | HG | Futures | 4.6994 | 4.7373 | 4.6653 | 4.6666 | 50246.0 |
| 2013-01-14 | HH | Futures | 39.764 | 39.999 | 39.588 | 39.6 | 253.0 |
| 2013-01-14 | HO | Futures | 2.4243 | 2.4669 | 2.424 | 2.462 | 40761.0 |
| 2013-01-14 | HRC | Futures | 2353.9 | 2353.9 | 2353.9 | 2353.9 | 0.0 |
> showing 50 of 100 rows — these rows as CSV