PREVIEW / futures_daily / 2013-01-09
file: by_date/futures_daily/2013/2013-01-09.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-01-09 | ES | Futures | 1485.17 | 1493.35 | 1484.91 | 1489.52 | 1193627.0 |
| 2013-01-09 | NQ | Futures | 3131.59 | 3149.18 | 3127.26 | 3139.66 | 159091.0 |
| 2013-01-09 | YM | Futures | 13008.6 | 13096.8 | 13006.6 | 13066.4 | 84372.0 |
| 2013-01-09 | CL | Futures | 165.33 | 166.21 | 164.49 | 165.24 | 201385.0 |
| 2013-01-09 | GC | Futures | 2212.0 | 2220.2 | 2200.6 | 2206.2 | 131709.0 |
| 2013-01-09 | ZN | Futures | 116.266437 | 116.54208 | 116.142397 | 116.486952 | 967862.0 |
| 2013-01-09 | A6 | Futures | 0.95637 | 0.9592 | 0.95472 | 0.95673 | 84467.0 |
| 2013-01-09 | AD | Futures | 1.01493 | 1.01593 | 1.01332 | 1.01382 | 47790.0 |
| 2013-01-09 | B | Futures | 104.11 | 104.35 | 103.41 | 104.0 | 188223.0 |
| 2013-01-09 | B6 | Futures | 1.6774 | 1.6794 | 1.6707 | 1.6732 | 106874.0 |
| 2013-01-09 | BFX | Futures | 3031.0 | 3031.0 | 3024.8 | 3027.6 | 3.0 |
| 2013-01-09 | BR | Futures | 0.23838 | 0.2391 | 0.23838 | 0.23897 | 66.0 |
| 2013-01-09 | BZ | Futures | 106.29 | 106.61 | 105.75 | 106.31 | 1387.0 |
| 2013-01-09 | C | Futures | 1520.0 | 1533.0 | 1516.0 | 1528.0 | 4774.0 |
| 2013-01-09 | CB | Futures | 83.012 | 83.012 | 82.347 | 82.504 | 33.0 |
| 2013-01-09 | CC | Futures | 1673.0 | 1688.0 | 1666.0 | 1677.0 | 10302.0 |
| 2013-01-09 | CSC | Futures | 3.824 | 3.83 | 3.824 | 3.824 | 13.0 |
| 2013-01-09 | CT | Futures | 94.64 | 95.02 | 93.89 | 94.12 | 13545.0 |
| 2013-01-09 | DC | Futures | 28.69 | 28.69 | 28.29 | 28.36 | 248.0 |
| 2013-01-09 | DX | Futures | 77.647 | 77.878 | 77.589 | 77.808 | 27720.0 |
| 2013-01-09 | E1 | Futures | 1.39475 | 1.39565 | 1.38947 | 1.39153 | 23581.0 |
| 2013-01-09 | E6 | Futures | 1.54396 | 1.54549 | 1.53842 | 1.54054 | 221294.0 |
| 2013-01-09 | E7 | Futures | 1.5333 | 1.5349 | 1.5279 | 1.53 | 3514.0 |
| 2013-01-09 | EBM | Futures | 272.0 | 277.84 | 272.0 | 274.51 | 19743.0 |
| 2013-01-09 | ED | Futures | 95.2295 | 95.239 | 95.2295 | 95.239 | 105636.0 |
| 2013-01-09 | ER | Futures | 97.813 | 97.827 | 97.813 | 97.822 | 97157.0 |
| 2013-01-09 | EW | Futures | 1071.2 | 1076.9 | 1070.0 | 1075.3 | 10479.0 |
| 2013-01-09 | FBTP | Futures | 76.6 | 76.78 | 76.36 | 76.7 | 19335.0 |
| 2013-01-09 | FBTS | Futures | 91.323 | 91.569 | 91.239 | 91.569 | 6426.0 |
| 2013-01-09 | FCE | Futures | 2799.3 | 2808.0 | 2788.4 | 2797.8 | 72511.0 |
| 2013-01-09 | FDAX | Futures | 8425.0 | 8452.3 | 8401.0 | 8438.1 | 84039.0 |
| 2013-01-09 | FESX | Futures | 1832.9 | 1842.5 | 1828.8 | 1839.7 | 742209.0 |
| 2013-01-09 | FEU3 | Futures | 98.433 | 98.433 | 98.428 | 98.428 | 271.0 |
| 2013-01-09 | FGBL | Futures | 118.41 | 118.83 | 118.35 | 118.68 | 675376.0 |
| 2013-01-09 | FGBM | Futures | 116.6 | 116.86 | 116.56 | 116.79 | 447094.0 |
| 2013-01-09 | FGBS | Futures | 110.358 | 110.392 | 110.343 | 110.367 | 355924.0 |
| 2013-01-09 | FGBX | Futures | 124.54 | 125.29 | 124.2 | 124.71 | 9226.0 |
| 2013-01-09 | FOAT | Futures | 105.29 | 105.45 | 105.15 | 105.33 | 20760.0 |
| 2013-01-09 | FTDX | Futures | 824.1 | 828.4 | 823.7 | 827.5 | 100.0 |
| 2013-01-09 | FTI | Futures | 300.93 | 301.4 | 299.77 | 300.76 | 21889.0 |
| 2013-01-09 | FTUK | Futures | 4429.2 | 4464.1 | 4428.1 | 4454.2 | 74641.0 |
| 2013-01-09 | FVSA | Futures | 3462.01 | 3462.01 | 3380.79 | 3411.25 | 7958.0 |
| 2013-01-09 | FXXP | Futures | 205.9 | 207.2 | 205.9 | 207.0 | 9247.0 |
| 2013-01-09 | G | Futures | 97.01 | 97.25 | 96.88 | 97.09 | 145043.0 |
| 2013-01-09 | GF | Futures | 289.849 | 290.229 | 287.477 | 287.477 | 1418.0 |
| 2013-01-09 | GSCI | Futures | 1047.98 | 1049.51 | 1043.07 | 1047.18 | 1975.0 |
| 2013-01-09 | HE | Futures | 98.724 | 98.781 | 96.601 | 96.63 | 35480.0 |
| 2013-01-09 | HG | Futures | 4.7251 | 4.761 | 4.7058 | 4.7135 | 40263.0 |
| 2013-01-09 | HH | Futures | 37.076 | 37.146 | 36.242 | 36.547 | 339.0 |
| 2013-01-09 | HO | Futures | 2.4549 | 2.467 | 2.4467 | 2.4634 | 35573.0 |
> showing 50 of 101 rows — these rows as CSV