PREVIEW / futures_daily / 2012-10-25
file: by_date/futures_daily/2012/2012-10-25.parquet size: 9 KB rows: 100
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-25 | ES | Futures | 1431.26 | 1441.95 | 1424.39 | 1433.29 | 1808585.0 |
| 2012-10-25 | NQ | Futures | 3052.0 | 3076.16 | 3037.9 | 3046.82 | 252966.0 |
| 2012-10-25 | YM | Futures | 12719.8 | 12810.6 | 12669.0 | 12749.1 | 124932.0 |
| 2012-10-25 | CL | Futures | 154.36 | 156.35 | 153.61 | 155.09 | 208678.0 |
| 2012-10-25 | GC | Futures | 2273.5 | 2295.0 | 2272.8 | 2287.1 | 141164.0 |
| 2012-10-25 | ZN | Futures | 116.258197 | 116.285664 | 115.750039 | 115.942315 | 1293522.0 |
| 2012-10-25 | A6 | Futures | 0.93662 | 0.94098 | 0.93498 | 0.93798 | 108760.0 |
| 2012-10-25 | AD | Futures | 1.0088 | 1.01232 | 1.007 | 1.0085 | 64912.0 |
| 2012-10-25 | B | Futures | 98.84 | 100.0 | 98.35 | 99.25 | 123350.0 |
| 2012-10-25 | B6 | Futures | 1.6746 | 1.6858 | 1.6734 | 1.6837 | 131557.0 |
| 2012-10-25 | BFX | Futures | 2835.8 | 2837.2 | 2816.6 | 2821.8 | 13.0 |
| 2012-10-25 | BR | Futures | 0.2383 | 0.23857 | 0.2383 | 0.23845 | 60.0 |
| 2012-10-25 | BZ | Futures | 102.56 | 102.56 | 102.34 | 102.34 | 847.0 |
| 2012-10-25 | C | Futures | 1595.0 | 1595.0 | 1560.0 | 1577.0 | 3514.0 |
| 2012-10-25 | CB | Futures | 91.792 | 92.595 | 91.792 | 92.595 | 6.0 |
| 2012-10-25 | CC | Futures | 1814.0 | 1829.0 | 1792.0 | 1811.0 | 12897.0 |
| 2012-10-25 | CSC | Futures | 4.183 | 4.202 | 4.183 | 4.202 | 14.0 |
| 2012-10-25 | CT | Futures | 93.4 | 94.85 | 93.14 | 93.85 | 11149.0 |
| 2012-10-25 | DC | Futures | 30.99 | 31.21 | 30.92 | 31.18 | 535.0 |
| 2012-10-25 | DX | Futures | 77.562 | 77.707 | 77.271 | 77.603 | 17225.0 |
| 2012-10-25 | E1 | Futures | 1.3811 | 1.38638 | 1.37673 | 1.37853 | 24844.0 |
| 2012-10-25 | E6 | Futures | 1.52803 | 1.53427 | 1.52285 | 1.52556 | 226534.0 |
| 2012-10-25 | E7 | Futures | 1.5188 | 1.5251 | 1.5139 | 1.5164 | 3816.0 |
| 2012-10-25 | ED | Futures | 95.2444 | 95.2492 | 95.2301 | 95.2396 | 195879.0 |
| 2012-10-25 | ER | Futures | 97.862 | 97.866 | 97.857 | 97.866 | 53703.0 |
| 2012-10-25 | EW | Futures | 993.4 | 1001.2 | 986.1 | 995.6 | 22361.0 |
| 2012-10-25 | FBTP | Futures | 72.98 | 73.17 | 72.7 | 72.81 | 15844.0 |
| 2012-10-25 | FBTS | Futures | 89.784 | 89.784 | 89.567 | 89.608 | 2242.0 |
| 2012-10-25 | FCE | Futures | 2583.2 | 2597.5 | 2553.9 | 2562.9 | 88193.0 |
| 2012-10-25 | FDAX | Futures | 7898.9 | 7953.2 | 7869.3 | 7886.9 | 114135.0 |
| 2012-10-25 | FESX | Futures | 1696.7 | 1707.6 | 1682.4 | 1687.2 | 902046.0 |
| 2012-10-25 | FEU3 | Futures | 98.483 | 98.487 | 98.483 | 98.487 | 301.0 |
| 2012-10-25 | FGBL | Futures | 117.17 | 117.39 | 116.91 | 117.33 | 728768.0 |
| 2012-10-25 | FGBM | Futures | 115.8 | 115.91 | 115.71 | 115.89 | 453181.0 |
| 2012-10-25 | FGBS | Futures | 110.238 | 110.268 | 110.218 | 110.258 | 308151.0 |
| 2012-10-25 | FGBX | Futures | 122.44 | 122.82 | 121.62 | 122.7 | 7249.0 |
| 2012-10-25 | FOAT | Futures | 103.44 | 103.5 | 103.34 | 103.48 | 20354.0 |
| 2012-10-25 | FTDX | Futures | 750.9 | 753.8 | 748.6 | 752.8 | 199.0 |
| 2012-10-25 | FTI | Futures | 281.49 | 283.72 | 281.11 | 281.75 | 26641.0 |
| 2012-10-25 | FTUK | Futures | 4222.3 | 4259.2 | 4222.3 | 4231.4 | 68432.0 |
| 2012-10-25 | FVSA | Futures | 5319.47 | 5319.47 | 5172.64 | 5229.11 | 1366.0 |
| 2012-10-25 | FXXP | Futures | 194.0 | 195.7 | 194.0 | 194.5 | 1196.0 |
| 2012-10-25 | G | Futures | 98.13 | 98.21 | 97.57 | 97.85 | 163729.0 |
| 2012-10-25 | GF | Futures | 282.851 | 283.139 | 279.395 | 280.451 | 1877.0 |
| 2012-10-25 | GSCI | Futures | 1035.39 | 1037.25 | 1026.33 | 1030.05 | 169.0 |
| 2012-10-25 | HE | Futures | 97.295 | 97.792 | 96.518 | 97.108 | 15090.0 |
| 2012-10-25 | HG | Futures | 4.5935 | 4.6141 | 4.5466 | 4.5627 | 47524.0 |
| 2012-10-25 | HH | Futures | 43.992 | 43.992 | 43.992 | 43.992 | 665.0 |
| 2012-10-25 | HO | Futures | 2.4554 | 2.4789 | 2.4523 | 2.4682 | 59530.0 |
| 2012-10-25 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
> showing 50 of 100 rows — these rows as CSV