PREVIEW / futures_daily / 2012-07-02
file: by_date/futures_daily/2012/2012-07-02.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 |
|---|---|---|---|---|---|---|---|
| 2012-07-02 | ES | Futures | 1376.03 | 1379.58 | 1366.67 | 1374.77 | 1688137.0 |
| 2012-07-02 | NQ | Futures | 2997.96 | 3007.43 | 2983.61 | 3000.54 | 187657.0 |
| 2012-07-02 | YM | Futures | 12444.4 | 12466.8 | 12344.5 | 12395.0 | 117485.0 |
| 2012-07-02 | CL | Futures | 154.38 | 155.11 | 149.73 | 152.74 | 299104.0 |
| 2012-07-02 | GC | Futures | 2138.3 | 2143.7 | 2122.0 | 2135.8 | 98936.0 |
| 2012-07-02 | ZN | Futures | 116.318086 | 116.999025 | 116.181898 | 116.808362 | 960083.0 |
| 2012-07-02 | A6 | Futures | 0.91609 | 0.9178 | 0.91186 | 0.91618 | 116258.0 |
| 2012-07-02 | AD | Futures | 0.98446 | 0.98546 | 0.98115 | 0.98446 | 68830.0 |
| 2012-07-02 | B | Futures | 87.88 | 87.92 | 85.66 | 87.26 | 151440.0 |
| 2012-07-02 | B6 | Futures | 1.64 | 1.6429 | 1.6344 | 1.6397 | 105920.0 |
| 2012-07-02 | BFX | Futures | 2665.6 | 2702.5 | 2665.6 | 2699.2 | 70.0 |
| 2012-07-02 | BR | Futures | 0.23496 | 0.23783 | 0.23494 | 0.23764 | 385.0 |
| 2012-07-02 | BZ | Futures | 93.5 | 93.5 | 93.5 | 93.5 | 2953.0 |
| 2012-07-02 | C | Futures | 1624.0 | 1631.0 | 1607.0 | 1626.0 | 3452.0 |
| 2012-07-02 | CB | Futures | 84.367 | 84.367 | 84.367 | 84.367 | 4.0 |
| 2012-07-02 | CC | Futures | 1726.0 | 1741.0 | 1704.0 | 1726.0 | 13212.0 |
| 2012-07-02 | CSC | Futures | 3.856 | 3.856 | 3.814 | 3.823 | 3.0 |
| 2012-07-02 | CT | Futures | 94.53 | 95.41 | 93.26 | 95.24 | 54.0 |
| 2012-07-02 | DC | Futures | 28.22 | 28.28 | 27.72 | 27.88 | 113.0 |
| 2012-07-02 | DX | Futures | 79.328 | 79.683 | 79.256 | 79.598 | 17071.0 |
| 2012-07-02 | E1 | Futures | 1.36411 | 1.36424 | 1.35339 | 1.35533 | 38754.0 |
| 2012-07-02 | E6 | Futures | 1.4955 | 1.49598 | 1.48371 | 1.48548 | 223942.0 |
| 2012-07-02 | E7 | Futures | 1.4859 | 1.4864 | 1.4743 | 1.4762 | 2484.0 |
| 2012-07-02 | ED | Futures | 95.1131 | 95.1131 | 95.0987 | 95.1083 | 118600.0 |
| 2012-07-02 | ER | Futures | 97.607 | 97.631 | 97.597 | 97.616 | 112046.0 |
| 2012-07-02 | EW | Futures | 952.9 | 959.8 | 949.3 | 956.2 | 26858.0 |
| 2012-07-02 | FBTP | Futures | 65.71 | 66.86 | 65.69 | 66.37 | 16950.0 |
| 2012-07-02 | FBTS | Futures | 84.997 | 85.939 | 84.988 | 85.41 | 4341.0 |
| 2012-07-02 | FCE | Futures | 2378.0 | 2410.5 | 2362.4 | 2396.8 | 127555.0 |
| 2012-07-02 | FDAX | Futures | 7036.5 | 7147.9 | 6981.9 | 7084.6 | 152692.0 |
| 2012-07-02 | FESX | Futures | 1537.2 | 1556.2 | 1524.4 | 1542.7 | 1446764.0 |
| 2012-07-02 | FGBL | Futures | 116.38 | 117.11 | 116.2 | 117.02 | 663220.0 |
| 2012-07-02 | FGBM | Futures | 114.94 | 115.36 | 114.9 | 115.28 | 344057.0 |
| 2012-07-02 | FGBS | Futures | 110.093 | 110.218 | 110.088 | 110.188 | 268089.0 |
| 2012-07-02 | FGBX | Futures | 123.05 | 123.86 | 122.22 | 123.67 | 6815.0 |
| 2012-07-02 | FOAT | Futures | 97.74 | 98.95 | 97.74 | 98.79 | 10903.0 |
| 2012-07-02 | FTDX | Futures | 689.6 | 703.5 | 689.6 | 699.8 | 171.0 |
| 2012-07-02 | FTI | Futures | 263.6 | 265.22 | 260.62 | 263.86 | 32117.0 |
| 2012-07-02 | FTUK | Futures | 4047.1 | 4091.9 | 4024.9 | 4069.7 | 105541.0 |
| 2012-07-02 | FVSA | Futures | 7732.77 | 7732.77 | 7536.82 | 7551.89 | 7152.0 |
| 2012-07-02 | FXXP | Futures | 179.8 | 182.1 | 179.8 | 181.5 | 2134.0 |
| 2012-07-02 | G | Futures | 98.55 | 98.95 | 98.29 | 98.84 | 132759.0 |
| 2012-07-02 | GF | Futures | 297.618 | 297.667 | 294.707 | 295.348 | 2741.0 |
| 2012-07-02 | GSCI | Futures | 941.71 | 948.29 | 935.61 | 948.29 | 400.0 |
| 2012-07-02 | HE | Futures | 101.714 | 102.97 | 100.672 | 101.527 | 21016.0 |
| 2012-07-02 | HG | Futures | 4.5025 | 4.5122 | 4.4478 | 4.4691 | 48958.0 |
| 2012-07-02 | HO | Futures | 2.216 | 2.216 | 2.1662 | 2.1887 | 23317.0 |
| 2012-07-02 | HRC | Futures | 2531.1 | 2531.1 | 2531.1 | 2531.1 | 50.0 |
| 2012-07-02 | J1 | Futures | 0.0157 | 0.0158203 | 0.0156849 | 0.0157852 | 73040.0 |
| 2012-07-02 | J7 | Futures | 0.015643 | 0.015756 | 0.015625 | 0.015723 | 276.0 |
> showing 50 of 97 rows — these rows as CSV