PREVIEW / futures_daily / 2016-04-25
file: by_date/futures_daily/2016/2016-04-25.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2016-04-25 | ES | Futures | 2245.68 | 2245.68 | 2223.67 | 2236.82 | 1280888.0 |
| 2016-04-25 | NQ | Futures | 5260.51 | 5263.74 | 5212.33 | 5254.93 | 172474.0 |
| 2016-04-25 | YM | Futures | 18677.1 | 18681.2 | 18479.5 | 18613.6 | 123634.0 |
| 2016-04-25 | CL | Futures | 52.12 | 52.46 | 50.72 | 50.8 | 606383.0 |
| 2016-04-25 | GC | Futures | 1591.2 | 1603.2 | 1587.1 | 1598.5 | 120768.0 |
| 2016-04-25 | ZN | Futures | 125.057291 | 125.238337 | 124.830984 | 124.921507 | 943310.0 |
| 2016-04-25 | A6 | Futures | 0.7785 | 0.78053 | 0.77678 | 0.7784 | 59562.0 |
| 2016-04-25 | AD | Futures | 0.80795 | 0.80805 | 0.80396 | 0.80611 | 54285.0 |
| 2016-04-25 | ALI | Futures | 2241.09 | 2241.09 | 2241.09 | 2241.09 | 0.0 |
| 2016-04-25 | B | Futures | 37.57 | 37.73 | 36.7 | 36.79 | 176210.0 |
| 2016-04-25 | B6 | Futures | 1.5219 | 1.5295 | 1.5167 | 1.5246 | 90028.0 |
| 2016-04-25 | BFX | Futures | 4014.2 | 4014.2 | 4000.7 | 4000.7 | 6.0 |
| 2016-04-25 | BR | Futures | 0.18054 | 0.18214 | 0.18054 | 0.18145 | 621.0 |
| 2016-04-25 | BZ | Futures | 37.19 | 37.61 | 36.59 | 36.67 | 19876.0 |
| 2016-04-25 | C | Futures | 2397.0 | 2402.0 | 2377.0 | 2390.0 | 3836.0 |
| 2016-04-25 | CB | Futures | 254.866 | 256.146 | 254.866 | 256.146 | 5.0 |
| 2016-04-25 | CC | Futures | 2312.0 | 2324.0 | 2292.0 | 2317.0 | 17680.0 |
| 2016-04-25 | CNH | Futures | 7.0854 | 7.095 | 7.0842 | 7.091 | 24.0 |
| 2016-04-25 | CSC | Futures | 3.539 | 3.546 | 3.537 | 3.537 | 12.0 |
| 2016-04-25 | CT | Futures | 72.45 | 73.2 | 71.78 | 72.85 | 19416.0 |
| 2016-04-25 | DC | Futures | 27.72 | 27.87 | 27.7 | 27.76 | 130.0 |
| 2016-04-25 | DX | Futures | 88.612 | 88.663 | 88.244 | 88.384 | 15038.0 |
| 2016-04-25 | E1 | Futures | 1.28662 | 1.29303 | 1.28612 | 1.28976 | 15598.0 |
| 2016-04-25 | E6 | Futures | 1.31091 | 1.31721 | 1.31039 | 1.31505 | 109321.0 |
| 2016-04-25 | E7 | Futures | 1.304 | 1.3101 | 1.3037 | 1.3079 | 1694.0 |
| 2016-04-25 | EBM | Futures | 193.66 | 196.88 | 192.38 | 195.92 | 24446.0 |
| 2016-04-25 | ED | Futures | 95.6919 | 95.7063 | 95.6919 | 95.6967 | 188507.0 |
| 2016-04-25 | ER | Futures | 98.259 | 98.259 | 98.254 | 98.254 | 20333.0 |
| 2016-04-25 | EW | Futures | 1561.4 | 1562.2 | 1543.9 | 1550.0 | 13841.0 |
| 2016-04-25 | FBON | Futures | 117.72 | 117.87 | 117.29 | 117.33 | 280.0 |
| 2016-04-25 | FBTP | Futures | 106.07 | 106.16 | 105.45 | 105.57 | 88265.0 |
| 2016-04-25 | FBTS | Futures | 100.997 | 100.997 | 100.952 | 100.979 | 12366.0 |
| 2016-04-25 | FCE | Futures | 3823.4 | 3832.3 | 3786.4 | 3808.1 | 74722.0 |
| 2016-04-25 | FDAX | Futures | 11169.6 | 11212.5 | 11022.9 | 11096.0 | 111441.0 |
| 2016-04-25 | FDXM | Futures | 10759.5 | 10795.7 | 10615.8 | 10684.0 | 17232.0 |
| 2016-04-25 | FESX | Futures | 2393.8 | 2401.6 | 2367.3 | 2379.0 | 1007868.0 |
| 2016-04-25 | FEU3 | Futures | 98.912 | 98.912 | 98.912 | 98.912 | 4.0 |
| 2016-04-25 | FGBL | Futures | 145.52 | 145.61 | 144.81 | 145.06 | 722511.0 |
| 2016-04-25 | FGBM | Futures | 127.54 | 127.6 | 127.32 | 127.37 | 412145.0 |
| 2016-04-25 | FGBS | Futures | 111.678 | 111.683 | 111.643 | 111.648 | 191930.0 |
| 2016-04-25 | FGBX | Futures | 170.53 | 170.67 | 168.42 | 169.21 | 42354.0 |
| 2016-04-25 | FMWO | Futures | 5711.1 | 5711.1 | 5447.5 | 5699.9 | 258.0 |
| 2016-04-25 | FOAT | Futures | 133.2 | 133.31 | 132.47 | 132.74 | 88411.0 |
| 2016-04-25 | FTDX | Futures | 1570.9 | 1577.1 | 1561.4 | 1567.6 | 84.0 |
| 2016-04-25 | FTI | Futures | 402.94 | 403.26 | 397.75 | 398.79 | 30498.0 |
| 2016-04-25 | FTUK | Futures | 5179.0 | 5180.6 | 5116.7 | 5125.7 | 115741.0 |
| 2016-04-25 | FVSA | Futures | 2413.57 | 2508.01 | 2392.58 | 2434.56 | 11499.0 |
| 2016-04-25 | FXXP | Futures | 275.8 | 276.9 | 273.7 | 274.6 | 17922.0 |
| 2016-04-25 | G | Futures | 107.14 | 107.36 | 106.91 | 107.17 | 135767.0 |
| 2016-04-25 | GF | Futures | 285.891 | 287.339 | 283.944 | 286.141 | 3026.0 |
> showing 50 of 110 rows — these rows as CSV