PREVIEW / futures_daily / 2012-01-31
file: by_date/futures_daily/2012/2012-01-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-01-31 | ES | Futures | 1313.67 | 1322.2 | 1306.89 | 1312.92 | 1894426.0 |
| 2012-01-31 | NQ | Futures | 2815.82 | 2834.4 | 2800.38 | 2818.11 | 271817.0 |
| 2012-01-31 | YM | Futures | 12193.8 | 12265.4 | 12099.1 | 12162.9 | 97231.0 |
| 2012-01-31 | CL | Futures | 184.8 | 189.3 | 182.89 | 184.05 | 373891.0 |
| 2012-01-31 | GC | Futures | 2322.6 | 2344.3 | 2312.7 | 2330.6 | 157876.0 |
| 2012-01-31 | ZN | Futures | 114.069927 | 114.366984 | 113.799875 | 114.285968 | 1176769.0 |
| 2012-01-31 | A6 | Futures | 0.93781 | 0.94591 | 0.9363 | 0.93986 | 139137.0 |
| 2012-01-31 | AD | Futures | 1.00071 | 1.00613 | 0.9972 | 1.00001 | 82455.0 |
| 2012-01-31 | B | Futures | 98.58 | 101.07 | 98.16 | 98.58 | 93550.0 |
| 2012-01-31 | B6 | Futures | 1.6413 | 1.651 | 1.6403 | 1.6463 | 103871.0 |
| 2012-01-31 | BFX | Futures | 2669.7 | 2669.7 | 2642.6 | 2642.6 | 434.0 |
| 2012-01-31 | BR | Futures | 0.26602 | 0.26616 | 0.26478 | 0.26585 | 1841.0 |
| 2012-01-31 | BZ | Futures | 105.64 | 106.7 | 104.69 | 105.06 | 368.0 |
| 2012-01-31 | C | Futures | 1524.0 | 1548.0 | 1513.0 | 1526.0 | 6635.0 |
| 2012-01-31 | CB | Futures | 83.695 | 84.502 | 83.695 | 84.098 | 19.0 |
| 2012-01-31 | CC | Futures | 1768.0 | 1814.0 | 1765.0 | 1776.0 | 11354.0 |
| 2012-01-31 | CSC | Futures | 3.891 | 3.891 | 3.866 | 3.866 | 10.0 |
| 2012-01-31 | CT | Futures | 121.87 | 122.73 | 119.92 | 120.1 | 17659.0 |
| 2012-01-31 | DC | Futures | 27.94 | 28.02 | 27.6 | 27.79 | 432.0 |
| 2012-01-31 | DX | Futures | 77.053 | 77.505 | 76.751 | 77.298 | 24949.0 |
| 2012-01-31 | E1 | Futures | 1.43169 | 1.43982 | 1.42355 | 1.42762 | 26475.0 |
| 2012-01-31 | E6 | Futures | 1.57098 | 1.57971 | 1.55903 | 1.56417 | 317545.0 |
| 2012-01-31 | E7 | Futures | 1.5566 | 1.5652 | 1.5448 | 1.5499 | 5878.0 |
| 2012-01-31 | EBM | Futures | 276.16 | 283.69 | 276.16 | 282.38 | 19956.0 |
| 2012-01-31 | ED | Futures | 95.0772 | 95.1059 | 95.0772 | 95.0963 | 234244.0 |
| 2012-01-31 | ER | Futures | 97.41 | 97.474 | 97.405 | 97.464 | 121917.0 |
| 2012-01-31 | EW | Futures | 941.9 | 951.3 | 936.6 | 941.7 | 25509.0 |
| 2012-01-31 | FBTP | Futures | 62.35 | 63.12 | 62.35 | 62.83 | 10880.0 |
| 2012-01-31 | FBTS | Futures | 82.915 | 83.461 | 82.915 | 83.405 | 2462.0 |
| 2012-01-31 | FCE | Futures | 2339.5 | 2367.6 | 2338.8 | 2351.3 | 78930.0 |
| 2012-01-31 | FDAX | Futures | 7160.4 | 7220.0 | 7126.7 | 7143.3 | 142089.0 |
| 2012-01-31 | FESX | Futures | 1617.2 | 1631.3 | 1612.5 | 1617.9 | 987496.0 |
| 2012-01-31 | FEU3 | Futures | 98.019 | 98.019 | 98.019 | 98.019 | 2.0 |
| 2012-01-31 | FGBL | Futures | 112.96 | 113.21 | 112.55 | 113.07 | 717058.0 |
| 2012-01-31 | FGBM | Futures | 113.56 | 113.76 | 113.39 | 113.68 | 384401.0 |
| 2012-01-31 | FGBS | Futures | 109.944 | 109.969 | 109.909 | 109.954 | 452073.0 |
| 2012-01-31 | FGBX | Futures | 117.59 | 118.01 | 116.66 | 117.7 | 6306.0 |
| 2012-01-31 | FTDX | Futures | 688.3 | 694.8 | 686.9 | 689.3 | 208.0 |
| 2012-01-31 | FTI | Futures | 264.74 | 267.25 | 264.74 | 265.7 | 38842.0 |
| 2012-01-31 | FTUK | Futures | 4077.7 | 4104.0 | 4066.9 | 4071.6 | 119049.0 |
| 2012-01-31 | FVSA | Futures | 10429.02 | 10736.32 | 10409.81 | 10659.5 | 1360.0 |
| 2012-01-31 | FXXP | Futures | 179.2 | 180.4 | 179.1 | 179.5 | 857.0 |
| 2012-01-31 | G | Futures | 94.85 | 95.17 | 94.55 | 95.16 | 159629.0 |
| 2012-01-31 | GF | Futures | 327.385 | 330.407 | 327.332 | 329.824 | 2855.0 |
| 2012-01-31 | GSCI | Futures | 1043.25 | 1049.35 | 1030.42 | 1035.27 | 190.0 |
| 2012-01-31 | HE | Futures | 105.682 | 107.495 | 105.682 | 107.404 | 15985.0 |
| 2012-01-31 | HG | Futures | 5.0537 | 5.1124 | 4.966 | 4.999 | 57786.0 |
| 2012-01-31 | HO | Futures | 2.4588 | 2.5007 | 2.4588 | 2.469 | 61170.0 |
| 2012-01-31 | HRC | Futures | 2837.4 | 2837.4 | 2837.4 | 2837.4 | 60.0 |
| 2012-01-31 | J1 | Futures | 0.0164528 | 0.0164992 | 0.0164389 | 0.0164917 | 68569.0 |
> showing 50 of 99 rows — these rows as CSV