PREVIEW / futures_daily / 2012-06-15
file: by_date/futures_daily/2012/2012-06-15.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-06-15 | ES | Futures | 1342.11 | 1355.53 | 1341.35 | 1354.51 | 1817397.0 |
| 2012-06-15 | NQ | Futures | 2910.44 | 2947.17 | 2907.86 | 2942.86 | 223665.0 |
| 2012-06-15 | YM | Futures | 12232.0 | 12343.5 | 12216.4 | 12330.9 | 102545.0 |
| 2012-06-15 | CL | Futures | 154.41 | 155.2 | 152.7 | 153.79 | 111159.0 |
| 2012-06-15 | GC | Futures | 2171.0 | 2186.2 | 2166.1 | 2176.4 | 130137.0 |
| 2012-06-15 | ZN | Futures | 116.168279 | 116.740268 | 116.15466 | 116.60408 | 894215.0 |
| 2012-06-15 | A6 | Futures | 0.8937 | 0.89981 | 0.89127 | 0.89945 | 113148.0 |
| 2012-06-15 | AD | Futures | 0.97814 | 0.97965 | 0.97564 | 0.97794 | 69035.0 |
| 2012-06-15 | B | Futures | 88.89 | 89.08 | 88.05 | 88.63 | 148874.0 |
| 2012-06-15 | B6 | Futures | 1.6251 | 1.6458 | 1.6168 | 1.6383 | 123288.0 |
| 2012-06-15 | BFX | Futures | 2532.5 | 2546.1 | 2532.5 | 2542.0 | 62.0 |
| 2012-06-15 | BR | Futures | 0.22887 | 0.23081 | 0.22887 | 0.23081 | 3.0 |
| 2012-06-15 | BZ | Futures | 94.24 | 94.66 | 93.63 | 94.23 | 2371.0 |
| 2012-06-15 | C | Futures | 1583.0 | 1590.0 | 1572.0 | 1574.0 | 4574.0 |
| 2012-06-15 | CB | Futures | 83.291 | 83.426 | 83.291 | 83.426 | 3.0 |
| 2012-06-15 | CC | Futures | 1707.0 | 1711.0 | 1688.0 | 1693.0 | 10170.0 |
| 2012-06-15 | CSC | Futures | 3.636 | 3.636 | 3.636 | 3.636 | 1.0 |
| 2012-06-15 | CT | Futures | 97.86 | 99.54 | 97.1 | 97.84 | 23794.0 |
| 2012-06-15 | DC | Futures | 26.53 | 26.82 | 26.4 | 26.77 | 25.0 |
| 2012-06-15 | DX | Futures | 79.794 | 79.887 | 79.309 | 79.558 | 28352.0 |
| 2012-06-15 | E1 | Futures | 1.36101 | 1.40762 | 1.35688 | 1.36191 | 48050.0 |
| 2012-06-15 | E6 | Futures | 1.49126 | 1.49527 | 1.48654 | 1.49185 | 214311.0 |
| 2012-06-15 | E7 | Futures | 1.4815 | 1.4864 | 1.4774 | 1.4826 | 2080.0 |
| 2012-06-15 | ED | Futures | 95.0701 | 95.1131 | 95.0653 | 95.0987 | 314070.0 |
| 2012-06-15 | ER | Futures | 97.518 | 97.597 | 97.518 | 97.572 | 228306.0 |
| 2012-06-15 | EW | Futures | 920.6 | 931.5 | 920.0 | 929.0 | 28934.0 |
| 2012-06-15 | FBTP | Futures | 64.3 | 65.32 | 64.19 | 65.13 | 18411.0 |
| 2012-06-15 | FBTS | Futures | 83.235 | 83.674 | 83.235 | 83.607 | 2057.0 |
| 2012-06-15 | FCE | Futures | 2246.1 | 2287.2 | 2246.1 | 2278.3 | 172399.0 |
| 2012-06-15 | FDAX | Futures | 6811.7 | 6902.2 | 6800.7 | 6902.2 | 30594.0 |
| 2012-06-15 | FESX | Futures | 1450.7 | 1473.0 | 1449.3 | 1464.2 | 1805667.0 |
| 2012-06-15 | FEU3 | Futures | 98.122 | 98.152 | 98.122 | 98.152 | 301.0 |
| 2012-06-15 | FGBL | Futures | 117.08 | 117.81 | 117.03 | 117.53 | 721116.0 |
| 2012-06-15 | FGBM | Futures | 115.17 | 115.54 | 115.15 | 115.42 | 410948.0 |
| 2012-06-15 | FGBS | Futures | 110.198 | 110.293 | 110.193 | 110.243 | 285916.0 |
| 2012-06-15 | FGBX | Futures | 124.97 | 127.75 | 124.82 | 127.37 | 12837.0 |
| 2012-06-15 | FOAT | Futures | 97.88 | 98.79 | 97.88 | 98.71 | 13693.0 |
| 2012-06-15 | FTDX | Futures | 659.8 | 678.4 | 659.8 | 675.1 | 865.0 |
| 2012-06-15 | FTI | Futures | 248.98 | 254.16 | 248.81 | 253.06 | 48052.0 |
| 2012-06-15 | FTUK | Futures | 3956.5 | 3994.0 | 3944.8 | 3968.9 | 143169.0 |
| 2012-06-15 | FVSA | Futures | 9978.74 | 10174.7 | 9888.3 | 10084.26 | 8619.0 |
| 2012-06-15 | FXXP | Futures | 173.2 | 174.5 | 173.0 | 174.2 | 6815.0 |
| 2012-06-15 | G | Futures | 99.11 | 99.26 | 98.57 | 98.89 | 158462.0 |
| 2012-06-15 | GF | Futures | 309.509 | 309.608 | 307.091 | 307.93 | 4172.0 |
| 2012-06-15 | GSCI | Futures | 921.27 | 927.37 | 920.72 | 923.73 | 78.0 |
| 2012-06-15 | HE | Futures | 99.504 | 99.714 | 97.74 | 97.924 | 18074.0 |
| 2012-06-15 | HG | Futures | 4.4049 | 4.4782 | 4.397 | 4.431 | 52795.0 |
| 2012-06-15 | HO | Futures | 2.1705 | 2.1795 | 2.158 | 2.1721 | 17560.0 |
| 2012-06-15 | HRC | Futures | 2470.4 | 2470.4 | 2470.4 | 2470.4 | 0.0 |
| 2012-06-15 | J1 | Futures | 0.015799 | 0.0159619 | 0.0157789 | 0.0159456 | 89263.0 |
> showing 50 of 99 rows — these rows as CSV