PREVIEW / futures_daily / 2015-03-09
file: by_date/futures_daily/2015/2015-03-09.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-03-09 | ES | Futures | 2173.29 | 2182.73 | 2165.43 | 2177.75 | 1189658.0 |
| 2015-03-09 | NQ | Futures | 5118.92 | 5134.0 | 5095.71 | 5120.95 | 217756.0 |
| 2015-03-09 | YM | Futures | 18205.3 | 18352.9 | 18146.2 | 18302.0 | 99504.0 |
| 2015-03-09 | CL | Futures | 91.78 | 93.98 | 91.13 | 92.52 | 409877.0 |
| 2015-03-09 | GC | Futures | 1529.3 | 1535.5 | 1523.0 | 1525.2 | 123613.0 |
| 2015-03-09 | ZN | Futures | 119.422532 | 119.822136 | 119.30413 | 119.748135 | 998527.0 |
| 2015-03-09 | A6 | Futures | 0.75487 | 0.75791 | 0.75242 | 0.75526 | 85654.0 |
| 2015-03-09 | AD | Futures | 0.80689 | 0.81005 | 0.80648 | 0.80893 | 62896.0 |
| 2015-03-09 | ALI | Futures | 2683.27 | 2683.27 | 2683.27 | 2683.27 | 0.0 |
| 2015-03-09 | B | Futures | 59.1 | 59.54 | 58.01 | 58.14 | 194228.0 |
| 2015-03-09 | B6 | Futures | 1.5816 | 1.5915 | 1.5807 | 1.5909 | 102341.0 |
| 2015-03-09 | BFX | Futures | 4482.6 | 4482.6 | 4480.2 | 4481.4 | 13.0 |
| 2015-03-09 | BR | Futures | 0.17946 | 0.17946 | 0.17798 | 0.17838 | 43.0 |
| 2015-03-09 | BZ | Futures | 58.43 | 59.0 | 57.55 | 57.63 | 19997.0 |
| 2015-03-09 | C | Futures | 2214.0 | 2227.0 | 2186.0 | 2203.0 | 6187.0 |
| 2015-03-09 | CB | Futures | 143.219 | 143.219 | 142.754 | 143.016 | 23.0 |
| 2015-03-09 | CC | Futures | 2167.0 | 2195.0 | 2154.0 | 2166.0 | 12907.0 |
| 2015-03-09 | CNH | Futures | 7.1281 | 7.1297 | 7.1281 | 7.1297 | 1.0 |
| 2015-03-09 | CSC | Futures | 4.442 | 4.466 | 4.436 | 4.436 | 56.0 |
| 2015-03-09 | CT | Futures | 80.43 | 80.93 | 79.53 | 79.79 | 12388.0 |
| 2015-03-09 | DC | Futures | 36.17 | 36.3 | 35.74 | 35.81 | 303.0 |
| 2015-03-09 | DX | Futures | 92.546 | 92.617 | 92.111 | 92.367 | 45303.0 |
| 2015-03-09 | E1 | Futures | 1.29365 | 1.2999 | 1.29339 | 1.29709 | 18013.0 |
| 2015-03-09 | E6 | Futures | 1.27459 | 1.28306 | 1.27318 | 1.27741 | 191629.0 |
| 2015-03-09 | E7 | Futures | 1.2669 | 1.2754 | 1.2656 | 1.2698 | 3098.0 |
| 2015-03-09 | EBM | Futures | 297.67 | 301.68 | 297.67 | 300.47 | 13234.0 |
| 2015-03-09 | ED | Futures | 95.4594 | 95.4594 | 95.4546 | 95.457 | 78028.0 |
| 2015-03-09 | ER | Futures | 98.063 | 98.063 | 98.058 | 98.063 | 17843.0 |
| 2015-03-09 | EW | Futures | 1556.2 | 1562.1 | 1552.1 | 1560.0 | 16548.0 |
| 2015-03-09 | FBTP | Futures | 102.94 | 103.45 | 102.89 | 103.22 | 80232.0 |
| 2015-03-09 | FBTS | Futures | 99.608 | 99.697 | 99.572 | 99.652 | 10244.0 |
| 2015-03-09 | FCE | Futures | 4025.3 | 4027.3 | 3999.7 | 4015.9 | 79799.0 |
| 2015-03-09 | FDAX | Futures | 12788.3 | 12888.8 | 12726.1 | 12857.1 | 81568.0 |
| 2015-03-09 | FESX | Futures | 2595.4 | 2610.5 | 2583.8 | 2601.8 | 825542.0 |
| 2015-03-09 | FGBL | Futures | 138.8 | 139.81 | 138.77 | 139.73 | 692541.0 |
| 2015-03-09 | FGBM | Futures | 124.55 | 124.7 | 124.54 | 124.66 | 385956.0 |
| 2015-03-09 | FGBS | Futures | 111.173 | 111.193 | 111.158 | 111.183 | 257869.0 |
| 2015-03-09 | FGBX | Futures | 166.95 | 169.8 | 166.68 | 169.53 | 40937.0 |
| 2015-03-09 | FMWO | Futures | 5730.0 | 5748.5 | 5728.7 | 5744.8 | 166.0 |
| 2015-03-09 | FOAT | Futures | 127.38 | 128.45 | 127.36 | 128.32 | 66468.0 |
| 2015-03-09 | FTDX | Futures | 1500.7 | 1502.6 | 1494.6 | 1502.1 | 269.0 |
| 2015-03-09 | FTI | Futures | 421.16 | 422.45 | 418.53 | 421.38 | 19808.0 |
| 2015-03-09 | FTUK | Futures | 5351.0 | 5363.0 | 5333.0 | 5348.6 | 74955.0 |
| 2015-03-09 | FVSA | Futures | 1754.64 | 1781.5 | 1723.31 | 1736.74 | 4988.0 |
| 2015-03-09 | FXXP | Futures | 297.0 | 298.5 | 295.5 | 297.4 | 8786.0 |
| 2015-03-09 | G | Futures | 101.84 | 102.11 | 101.77 | 101.84 | 122518.0 |
| 2015-03-09 | GF | Futures | 354.39 | 355.107 | 352.155 | 353.757 | 1570.0 |
| 2015-03-09 | GSCI | Futures | 702.82 | 710.47 | 701.54 | 702.65 | 2825.0 |
| 2015-03-09 | HE | Futures | 88.543 | 89.08 | 87.705 | 88.644 | 20607.0 |
| 2015-03-09 | HG | Futures | 3.3205 | 3.4019 | 3.2939 | 3.393 | 50100.0 |
> showing 50 of 107 rows — these rows as CSV