PREVIEW / futures_daily / 2011-10-28
file: by_date/futures_daily/2011/2011-10-28.parquet size: 9 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-28 | ES | Futures | 1280.0 | 1282.0 | 1270.52 | 1278.75 | 1932702.0 |
| 2011-10-28 | NQ | Futures | 2732.36 | 2741.49 | 2714.95 | 2735.5 | 213787.0 |
| 2011-10-28 | YM | Futures | 11691.2 | 11714.3 | 11616.3 | 11689.3 | 82969.0 |
| 2011-10-28 | CL | Futures | 176.21 | 176.21 | 172.61 | 175.07 | 276760.0 |
| 2011-10-28 | GC | Futures | 2357.6 | 2368.2 | 2339.8 | 2359.0 | 107441.0 |
| 2011-10-28 | ZN | Futures | 109.20331 | 110.021162 | 109.163088 | 109.913902 | 1089328.0 |
| 2011-10-28 | A6 | Futures | 0.93681 | 0.93813 | 0.93144 | 0.93654 | 105413.0 |
| 2011-10-28 | AD | Futures | 1.00736 | 1.00996 | 1.00225 | 1.00586 | 60549.0 |
| 2011-10-28 | B | Futures | 98.55 | 98.55 | 96.53 | 96.76 | 91561.0 |
| 2011-10-28 | B6 | Futures | 1.68 | 1.6849 | 1.6764 | 1.6812 | 82515.0 |
| 2011-10-28 | BFX | Futures | 2668.4 | 2668.4 | 2626.0 | 2638.1 | 8.0 |
| 2011-10-28 | BR | Futures | 0.26705 | 0.26705 | 0.26705 | 0.26705 | 337.0 |
| 2011-10-28 | BZ | Futures | 102.67 | 103.19 | 101.96 | 102.17 | 683.0 |
| 2011-10-28 | C | Futures | 1812.0 | 1816.0 | 1784.0 | 1799.0 | 4812.0 |
| 2011-10-28 | CB | Futures | 94.793 | 94.793 | 94.793 | 94.793 | 7.0 |
| 2011-10-28 | CC | Futures | 2161.0 | 2167.0 | 2125.0 | 2155.0 | 10010.0 |
| 2011-10-28 | CT | Futures | 134.52 | 135.43 | 132.26 | 134.56 | 15069.0 |
| 2011-10-28 | DC | Futures | 29.39 | 29.71 | 29.19 | 29.66 | 320.0 |
| 2011-10-28 | DX | Futures | 73.707 | 73.928 | 73.673 | 73.841 | 20066.0 |
| 2011-10-28 | E1 | Futures | 1.52707 | 1.52747 | 1.51802 | 1.5234 | 18892.0 |
| 2011-10-28 | E6 | Futures | 1.69421 | 1.6966 | 1.68836 | 1.69099 | 233050.0 |
| 2011-10-28 | E7 | Futures | 1.6809 | 1.682 | 1.674 | 1.6765 | 4092.0 |
| 2011-10-28 | ED | Futures | 94.9889 | 95.0032 | 94.9746 | 94.9936 | 160971.0 |
| 2011-10-28 | ER | Futures | 97.169 | 97.194 | 97.169 | 97.184 | 123989.0 |
| 2011-10-28 | EW | Futures | 915.3 | 916.7 | 906.6 | 912.2 | 20651.0 |
| 2011-10-28 | FBTP | Futures | 61.55 | 61.55 | 60.62 | 60.83 | 12247.0 |
| 2011-10-28 | FBTS | Futures | 81.831 | 81.831 | 81.221 | 81.293 | 2169.0 |
| 2011-10-28 | FCE | Futures | 2434.1 | 2445.9 | 2388.8 | 2400.0 | 94201.0 |
| 2011-10-28 | FDAX | Futures | 6951.4 | 6992.7 | 6855.3 | 6896.6 | 160757.0 |
| 2011-10-28 | FESX | Futures | 1657.5 | 1663.4 | 1623.5 | 1632.9 | 1341628.0 |
| 2011-10-28 | FEU3 | Futures | 97.737 | 97.742 | 97.737 | 97.742 | 278.0 |
| 2011-10-28 | FGBL | Futures | 107.93 | 108.45 | 107.52 | 108.15 | 839673.0 |
| 2011-10-28 | FGBM | Futures | 109.87 | 110.23 | 109.61 | 110.08 | 431901.0 |
| 2011-10-28 | FGBS | Futures | 108.771 | 108.94 | 108.691 | 108.865 | 476512.0 |
| 2011-10-28 | FGBX | Futures | 107.32 | 108.0 | 106.26 | 107.54 | 8238.0 |
| 2011-10-28 | FTDX | Futures | 668.4 | 668.4 | 653.2 | 657.8 | 163.0 |
| 2011-10-28 | FTI | Futures | 261.62 | 262.44 | 256.53 | 258.18 | 36486.0 |
| 2011-10-28 | FTUK | Futures | 4120.2 | 4122.8 | 4059.6 | 4067.9 | 112795.0 |
| 2011-10-28 | FVSA | Futures | 13147.01 | 13272.03 | 12271.94 | 13105.34 | 7937.0 |
| 2011-10-28 | FXXP | Futures | 174.4 | 175.0 | 172.4 | 173.1 | 1553.0 |
| 2011-10-28 | G | Futures | 89.49 | 89.86 | 89.07 | 89.58 | 148015.0 |
| 2011-10-28 | GF | Futures | 313.588 | 315.469 | 311.486 | 312.26 | 1984.0 |
| 2011-10-28 | GSCI | Futures | 1021.37 | 1027.95 | 1016.91 | 1023.64 | 260.0 |
| 2011-10-28 | HE | Futures | 111.957 | 112.375 | 111.315 | 111.411 | 14658.0 |
| 2011-10-28 | HG | Futures | 4.9028 | 4.9623 | 4.7843 | 4.9041 | 47297.0 |
| 2011-10-28 | HO | Futures | 2.4974 | 2.5009 | 2.4533 | 2.463 | 55835.0 |
| 2011-10-28 | HRC | Futures | 2685.6 | 2685.6 | 2685.6 | 2685.6 | 0.0 |
| 2011-10-28 | J1 | Futures | 0.0165484 | 0.016615 | 0.0165434 | 0.0165974 | 52969.0 |
| 2011-10-28 | J7 | Futures | 0.016444 | 0.016512 | 0.016444 | 0.016497 | 314.0 |
| 2011-10-28 | JB | Futures | 124.4 | 124.4 | 123.97 | 123.99 | 4893.0 |
> showing 50 of 97 rows — these rows as CSV