PREVIEW / futures_daily / 2013-03-25
file: by_date/futures_daily/2013/2013-03-25.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-03-25 | ES | Futures | 1591.32 | 1602.1 | 1580.03 | 1588.24 | 2254735.0 |
| 2013-03-25 | NQ | Futures | 3226.74 | 3247.53 | 3200.75 | 3216.06 | 249371.0 |
| 2013-03-25 | YM | Futures | 14230.0 | 14295.0 | 14101.0 | 14166.0 | 207407.0 |
| 2013-03-25 | CL | Futures | 163.58 | 166.95 | 163.54 | 165.48 | 270651.0 |
| 2013-03-25 | GC | Futures | 2138.4 | 2143.7 | 2111.3 | 2132.7 | 234090.0 |
| 2013-03-25 | ZN | Futures | 117.05848 | 117.322846 | 116.738458 | 117.169792 | 1356646.0 |
| 2013-03-25 | A6 | Futures | 0.95848 | 0.96125 | 0.95691 | 0.95931 | 78332.0 |
| 2013-03-25 | AD | Futures | 0.97954 | 0.98436 | 0.97954 | 0.98165 | 69778.0 |
| 2013-03-25 | B | Futures | 102.6 | 104.67 | 102.55 | 103.83 | 119924.0 |
| 2013-03-25 | B6 | Futures | 1.5929 | 1.5968 | 1.5839 | 1.5879 | 105117.0 |
| 2013-03-25 | BFX | Futures | 3124.2 | 3124.2 | 3110.1 | 3118.8 | 7.0 |
| 2013-03-25 | BR | Futures | 0.24448 | 0.24448 | 0.24371 | 0.24445 | 144.0 |
| 2013-03-25 | BZ | Futures | 105.07 | 105.95 | 104.25 | 105.12 | 3895.0 |
| 2013-03-25 | C | Futures | 1535.0 | 1546.0 | 1513.0 | 1519.0 | 3896.0 |
| 2013-03-25 | CB | Futures | 83.743 | 83.94 | 83.743 | 83.817 | 16.0 |
| 2013-03-25 | CC | Futures | 1633.0 | 1648.0 | 1607.0 | 1611.0 | 11281.0 |
| 2013-03-25 | CSC | Futures | 3.736 | 3.736 | 3.698 | 3.712 | 19.0 |
| 2013-03-25 | CT | Futures | 107.4 | 107.51 | 105.95 | 106.52 | 13522.0 |
| 2013-03-25 | DC | Futures | 28.68 | 28.78 | 28.25 | 28.39 | 146.0 |
| 2013-03-25 | DX | Futures | 79.395 | 79.875 | 78.645 | 79.765 | 30087.0 |
| 2013-03-25 | E1 | Futures | 1.36758 | 1.38198 | 1.35574 | 1.35844 | 40532.0 |
| 2013-03-25 | E6 | Futures | 1.52969 | 1.54372 | 1.51342 | 1.51755 | 400240.0 |
| 2013-03-25 | E7 | Futures | 1.5202 | 1.5344 | 1.5037 | 1.5076 | 6970.0 |
| 2013-03-25 | EBM | Futures | 281.76 | 283.51 | 280.89 | 283.51 | 10587.0 |
| 2013-03-25 | ED | Futures | 95.2014 | 95.2349 | 95.1919 | 95.211 | 206933.0 |
| 2013-03-25 | ER | Futures | 97.744 | 97.793 | 97.744 | 97.754 | 282658.0 |
| 2013-03-25 | EW | Futures | 1161.2 | 1168.3 | 1152.2 | 1159.1 | 18981.0 |
| 2013-03-25 | FBTP | Futures | 76.11 | 76.31 | 75.16 | 75.52 | 46249.0 |
| 2013-03-25 | FBTS | Futures | 91.551 | 91.568 | 91.294 | 91.371 | 6740.0 |
| 2013-03-25 | FCE | Futures | 2874.8 | 2891.0 | 2791.6 | 2808.9 | 178768.0 |
| 2013-03-25 | FDAX | Futures | 8909.8 | 8943.1 | 8738.0 | 8770.2 | 151170.0 |
| 2013-03-25 | FESX | Futures | 1858.8 | 1864.4 | 1793.8 | 1809.2 | 1511356.0 |
| 2013-03-25 | FEU3 | Futures | 98.359 | 98.359 | 98.349 | 98.354 | 53.0 |
| 2013-03-25 | FGBL | Futures | 120.7 | 121.47 | 120.62 | 121.29 | 747025.0 |
| 2013-03-25 | FGBM | Futures | 117.74 | 118.07 | 117.7 | 118.03 | 404289.0 |
| 2013-03-25 | FGBS | Futures | 110.472 | 110.517 | 110.437 | 110.507 | 367282.0 |
| 2013-03-25 | FGBX | Futures | 127.54 | 128.3 | 126.91 | 127.9 | 10737.0 |
| 2013-03-25 | FMWO | Futures | 4668.3 | 4668.3 | 4632.7 | 4632.7 | 40.0 |
| 2013-03-25 | FOAT | Futures | 106.77 | 106.97 | 106.71 | 106.88 | 32289.0 |
| 2013-03-25 | FTDX | Futures | 885.2 | 885.2 | 868.2 | 869.1 | 271.0 |
| 2013-03-25 | FTI | Futures | 304.84 | 305.45 | 299.15 | 300.15 | 34718.0 |
| 2013-03-25 | FTUK | Futures | 4727.1 | 4756.5 | 4680.3 | 4705.2 | 98956.0 |
| 2013-03-25 | FVSA | Futures | 3262.98 | 3497.24 | 3045.45 | 3421.94 | 11839.0 |
| 2013-03-25 | FXXP | Futures | 214.0 | 214.8 | 211.6 | 212.1 | 2385.0 |
| 2013-03-25 | G | Futures | 98.74 | 99.32 | 98.58 | 99.18 | 113509.0 |
| 2013-03-25 | GF | Futures | 254.724 | 255.184 | 253.484 | 254.357 | 874.0 |
| 2013-03-25 | GSCI | Futures | 1041.58 | 1048.72 | 1037.32 | 1043.1 | 178.0 |
| 2013-03-25 | HE | Futures | 88.425 | 89.86 | 88.048 | 89.306 | 346.0 |
| 2013-03-25 | HG | Futures | 4.4213 | 4.4481 | 4.3868 | 4.3951 | 47762.0 |
| 2013-03-25 | HH | Futures | 44.977 | 45.305 | 44.003 | 44.048 | 1585.0 |
> showing 50 of 103 rows — these rows as CSV