PREVIEW / futures_daily / 2013-10-01
file: by_date/futures_daily/2013/2013-10-01.parquet size: 9 KB rows: 102
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-10-01 | ES | Futures | 1724.2 | 1738.32 | 1720.86 | 1735.5 | 1762715.0 |
| 2013-10-01 | NQ | Futures | 3699.69 | 3734.15 | 3690.22 | 3727.54 | 250343.0 |
| 2013-10-01 | YM | Futures | 15011.5 | 15064.2 | 14957.8 | 15044.3 | 154554.0 |
| 2013-10-01 | CL | Futures | 181.13 | 181.61 | 178.92 | 180.65 | 223028.0 |
| 2013-10-01 | GC | Futures | 1756.6 | 1769.3 | 1696.0 | 1700.9 | 212833.0 |
| 2013-10-01 | ZN | Futures | 114.583651 | 114.597813 | 114.20128 | 114.314575 | 1096668.0 |
| 2013-10-01 | A6 | Futures | 0.87631 | 0.88679 | 0.87291 | 0.88226 | 99113.0 |
| 2013-10-01 | AD | Futures | 0.97794 | 0.98036 | 0.97571 | 0.97662 | 49848.0 |
| 2013-10-01 | B | Futures | 107.28 | 107.28 | 105.65 | 106.76 | 175314.0 |
| 2013-10-01 | B6 | Futures | 1.6979 | 1.7059 | 1.6977 | 1.6992 | 97468.0 |
| 2013-10-01 | BFX | Futures | 3356.7 | 3373.5 | 3356.7 | 3373.5 | 4.0 |
| 2013-10-01 | BR | Futures | 0.22593 | 0.22822 | 0.22522 | 0.2257 | 143.0 |
| 2013-10-01 | BZ | Futures | 107.3 | 107.79 | 106.29 | 107.4 | 12531.0 |
| 2013-10-01 | C | Futures | 1824.0 | 1825.0 | 1800.0 | 1807.0 | 6421.0 |
| 2013-10-01 | CB | Futures | 73.495 | 73.495 | 73.375 | 73.483 | 5.0 |
| 2013-10-01 | CC | Futures | 1970.0 | 1972.0 | 1953.0 | 1963.0 | 12067.0 |
| 2013-10-01 | CSC | Futures | 3.284 | 3.288 | 3.284 | 3.288 | 17.0 |
| 2013-10-01 | CT | Futures | 102.33 | 102.51 | 100.28 | 101.59 | 14690.0 |
| 2013-10-01 | DC | Futures | 25.03 | 25.16 | 24.95 | 25.15 | 117.0 |
| 2013-10-01 | DX | Futures | 76.557 | 76.614 | 76.181 | 76.462 | 28642.0 |
| 2013-10-01 | E1 | Futures | 1.42105 | 1.43004 | 1.41693 | 1.41963 | 38238.0 |
| 2013-10-01 | E6 | Futures | 1.59598 | 1.60389 | 1.59539 | 1.59705 | 186815.0 |
| 2013-10-01 | E7 | Futures | 1.5858 | 1.5935 | 1.5851 | 1.5867 | 2592.0 |
| 2013-10-01 | ED | Futures | 95.3255 | 95.3351 | 95.3208 | 95.3303 | 86313.0 |
| 2013-10-01 | ER | Futures | 97.837 | 97.852 | 97.837 | 97.847 | 52834.0 |
| 2013-10-01 | EW | Futures | 1266.0 | 1288.2 | 1263.4 | 1285.0 | 47310.0 |
| 2013-10-01 | FBTP | Futures | 78.01 | 79.07 | 77.86 | 78.56 | 52379.0 |
| 2013-10-01 | FBTS | Futures | 93.532 | 93.921 | 93.532 | 93.782 | 3.0 |
| 2013-10-01 | FCE | Futures | 3202.7 | 3240.9 | 3202.3 | 3238.5 | 117737.0 |
| 2013-10-01 | FDAX | Futures | 9573.7 | 9661.9 | 9558.7 | 9633.1 | 98781.0 |
| 2013-10-01 | FDIV | Futures | 134.51 | 134.56 | 134.51 | 134.56 | 5.0 |
| 2013-10-01 | FESX | Futures | 2027.0 | 2052.3 | 2024.9 | 2046.0 | 1005932.0 |
| 2013-10-01 | FGBL | Futures | 119.58 | 119.73 | 119.27 | 119.43 | 678719.0 |
| 2013-10-01 | FGBM | Futures | 117.68 | 117.74 | 117.5 | 117.56 | 386251.0 |
| 2013-10-01 | FGBS | Futures | 110.443 | 110.448 | 110.408 | 110.423 | 253604.0 |
| 2013-10-01 | FGBX | Futures | 121.59 | 121.82 | 120.93 | 121.32 | 13179.0 |
| 2013-10-01 | FMWO | Futures | 5102.9 | 5102.9 | 5102.9 | 5102.9 | 0.0 |
| 2013-10-01 | FOAT | Futures | 106.91 | 107.01 | 106.78 | 106.93 | 43464.0 |
| 2013-10-01 | FTDX | Futures | 1021.4 | 1026.6 | 1017.2 | 1026.6 | 58.0 |
| 2013-10-01 | FTI | Futures | 324.22 | 327.47 | 323.79 | 327.12 | 25923.0 |
| 2013-10-01 | FTUK | Futures | 4819.9 | 4846.2 | 4795.2 | 4816.2 | 99279.0 |
| 2013-10-01 | FVSA | Futures | 2458.33 | 2517.01 | 2438.76 | 2458.33 | 6478.0 |
| 2013-10-01 | FXXP | Futures | 226.6 | 227.9 | 226.2 | 227.7 | 5006.0 |
| 2013-10-01 | G | Futures | 92.51 | 92.65 | 92.32 | 92.58 | 136499.0 |
| 2013-10-01 | GF | Futures | 266.99 | 268.62 | 266.704 | 268.009 | 1608.0 |
| 2013-10-01 | GSCI | Futures | 1055.27 | 1055.27 | 1047.48 | 1054.43 | 385.0 |
| 2013-10-01 | HE | Futures | 109.516 | 109.927 | 108.218 | 108.725 | 25109.0 |
| 2013-10-01 | HG | Futures | 4.2095 | 4.2259 | 4.1139 | 4.1455 | 51906.0 |
| 2013-10-01 | HH | Futures | 38.399 | 38.943 | 38.367 | 38.527 | 135.0 |
| 2013-10-01 | HO | Futures | 2.3728 | 2.3798 | 2.34 | 2.3644 | 25502.0 |
> showing 50 of 102 rows — these rows as CSV