PREVIEW / futures_daily / 2012-10-31
file: by_date/futures_daily/2012/2012-10-31.parquet size: 9 KB rows: 99
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-31 | ES | Futures | 1437.62 | 1443.47 | 1425.41 | 1431.77 | 1775915.0 |
| 2012-10-31 | NQ | Futures | 3063.22 | 3079.9 | 3028.12 | 3038.19 | 326935.0 |
| 2012-10-31 | YM | Futures | 12769.6 | 12815.5 | 12681.7 | 12723.7 | 111943.0 |
| 2012-10-31 | CL | Futures | 154.51 | 157.14 | 154.29 | 155.43 | 212577.0 |
| 2012-10-31 | GC | Futures | 2283.5 | 2305.2 | 2282.8 | 2295.2 | 120009.0 |
| 2012-10-31 | ZN | Futures | 116.587812 | 116.95863 | 116.368068 | 116.931162 | 995044.0 |
| 2012-10-31 | A6 | Futures | 0.93835 | 0.94153 | 0.93726 | 0.93962 | 102333.0 |
| 2012-10-31 | AD | Futures | 1.00348 | 1.0066 | 1.00128 | 1.00248 | 73166.0 |
| 2012-10-31 | B | Futures | 99.09 | 100.27 | 98.97 | 99.33 | 107538.0 |
| 2012-10-31 | B6 | Futures | 1.6793 | 1.6855 | 1.678 | 1.6843 | 86744.0 |
| 2012-10-31 | BFX | Futures | 2859.7 | 2859.7 | 2840.3 | 2840.3 | 9.0 |
| 2012-10-31 | BR | Futures | 0.23804 | 0.2383 | 0.23779 | 0.2383 | 1236.0 |
| 2012-10-31 | BZ | Futures | 102.71 | 103.36 | 102.3 | 102.42 | 525.0 |
| 2012-10-31 | C | Futures | 1557.0 | 1579.0 | 1555.0 | 1569.0 | 3171.0 |
| 2012-10-31 | CB | Futures | 91.939 | 92.247 | 91.886 | 92.247 | 15.0 |
| 2012-10-31 | CC | Futures | 1797.0 | 1823.0 | 1783.0 | 1801.0 | 14410.0 |
| 2012-10-31 | CSC | Futures | 4.107 | 4.124 | 4.107 | 4.124 | 3.0 |
| 2012-10-31 | CT | Futures | 91.52 | 92.73 | 90.11 | 90.42 | 25386.0 |
| 2012-10-31 | DC | Futures | 30.62 | 30.83 | 30.57 | 30.77 | 423.0 |
| 2012-10-31 | DX | Futures | 77.494 | 77.542 | 77.218 | 77.476 | 16080.0 |
| 2012-10-31 | E1 | Futures | 1.38149 | 1.38844 | 1.38007 | 1.38303 | 25528.0 |
| 2012-10-31 | E6 | Futures | 1.52685 | 1.53403 | 1.5252 | 1.52697 | 213027.0 |
| 2012-10-31 | E7 | Futures | 1.5177 | 1.5247 | 1.5162 | 1.5178 | 3491.0 |
| 2012-10-31 | ED | Futures | 95.2205 | 95.2349 | 95.2205 | 95.2301 | 97202.0 |
| 2012-10-31 | ER | Futures | 97.866 | 97.876 | 97.862 | 97.862 | 76771.0 |
| 2012-10-31 | EW | Futures | 990.5 | 997.2 | 987.9 | 997.2 | 21167.0 |
| 2012-10-31 | FBTP | Futures | 72.12 | 72.38 | 72.11 | 72.32 | 15534.0 |
| 2012-10-31 | FBTS | Futures | 89.625 | 89.684 | 89.575 | 89.675 | 2284.0 |
| 2012-10-31 | FCE | Futures | 2596.0 | 2618.5 | 2568.9 | 2574.2 | 104697.0 |
| 2012-10-31 | FDAX | Futures | 7983.8 | 8052.3 | 7947.7 | 7965.8 | 116057.0 |
| 2012-10-31 | FESX | Futures | 1709.0 | 1727.3 | 1697.4 | 1704.2 | 1026765.0 |
| 2012-10-31 | FGBL | Futures | 118.32 | 118.56 | 117.99 | 118.41 | 771184.0 |
| 2012-10-31 | FGBM | Futures | 116.36 | 116.47 | 116.21 | 116.4 | 404169.0 |
| 2012-10-31 | FGBS | Futures | 110.363 | 110.372 | 110.328 | 110.358 | 281407.0 |
| 2012-10-31 | FGBX | Futures | 124.79 | 125.78 | 124.22 | 125.32 | 14250.0 |
| 2012-10-31 | FOAT | Futures | 103.68 | 103.78 | 103.48 | 103.61 | 48347.0 |
| 2012-10-31 | FTDX | Futures | 758.5 | 762.2 | 754.7 | 755.2 | 106.0 |
| 2012-10-31 | FTI | Futures | 284.24 | 286.0 | 282.52 | 282.74 | 30107.0 |
| 2012-10-31 | FTUK | Futures | 4253.4 | 4278.6 | 4209.8 | 4217.9 | 106634.0 |
| 2012-10-31 | FVSA | Futures | 5059.7 | 5082.29 | 4946.76 | 5014.53 | 7642.0 |
| 2012-10-31 | FXXP | Futures | 195.8 | 196.6 | 194.5 | 194.6 | 1459.0 |
| 2012-10-31 | G | Futures | 98.48 | 98.58 | 98.23 | 98.39 | 177272.0 |
| 2012-10-31 | GF | Futures | 282.083 | 282.467 | 279.827 | 280.931 | 1517.0 |
| 2012-10-31 | GSCI | Futures | 1034.02 | 1037.57 | 1028.92 | 1031.67 | 348.0 |
| 2012-10-31 | HE | Futures | 97.17 | 98.538 | 96.86 | 97.295 | 28736.0 |
| 2012-10-31 | HG | Futures | 4.5087 | 4.5743 | 4.5029 | 4.5203 | 52059.0 |
| 2012-10-31 | HH | Futures | 43.282 | 43.282 | 42.875 | 42.956 | 689.0 |
| 2012-10-31 | HO | Futures | 2.4879 | 2.4994 | 2.4682 | 2.4821 | 79435.0 |
| 2012-10-31 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
| 2012-10-31 | J1 | Futures | 0.0157316 | 0.0157516 | 0.0156615 | 0.0157015 | 87174.0 |
> showing 50 of 99 rows — these rows as CSV