PREVIEW / futures_daily / 2012-03-28
file: by_date/futures_daily/2012/2012-03-28.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-03-28 | ES | Futures | 1417.1 | 1423.15 | 1402.74 | 1411.05 | 1759121.0 |
| 2012-03-28 | NQ | Futures | 3180.81 | 3196.85 | 3151.02 | 3171.35 | 238252.0 |
| 2012-03-28 | YM | Futures | 12763.0 | 12814.5 | 12645.3 | 12693.9 | 117871.0 |
| 2012-03-28 | CL | Futures | 196.9 | 197.14 | 192.95 | 194.32 | 309064.0 |
| 2012-03-28 | GC | Futures | 2249.4 | 2255.4 | 2214.0 | 2219.8 | 169137.0 |
| 2012-03-28 | ZN | Futures | 112.297548 | 112.500618 | 112.067402 | 112.270472 | 1040364.0 |
| 2012-03-28 | A6 | Futures | 0.9323 | 0.93257 | 0.92312 | 0.92537 | 139663.0 |
| 2012-03-28 | AD | Futures | 1.00883 | 1.00964 | 1.0043 | 1.00531 | 79925.0 |
| 2012-03-28 | B | Futures | 112.45 | 112.51 | 111.08 | 111.66 | 130213.0 |
| 2012-03-28 | B6 | Futures | 1.6731 | 1.6747 | 1.6617 | 1.6675 | 112504.0 |
| 2012-03-28 | BFX | Futures | 2857.6 | 2857.6 | 2835.6 | 2838.0 | 4.0 |
| 2012-03-28 | BR | Futures | 0.25924 | 0.25924 | 0.25757 | 0.25762 | 70.0 |
| 2012-03-28 | BZ | Futures | 118.14 | 118.14 | 117.76 | 118.11 | 582.0 |
| 2012-03-28 | C | Futures | 1521.0 | 1548.0 | 1506.0 | 1515.0 | 11943.0 |
| 2012-03-28 | CB | Futures | 81.945 | 81.945 | 80.869 | 81.004 | 24.0 |
| 2012-03-28 | CC | Futures | 1774.0 | 1807.0 | 1739.0 | 1746.0 | 13058.0 |
| 2012-03-28 | CSC | Futures | 3.637 | 3.637 | 3.632 | 3.632 | 2.0 |
| 2012-03-28 | CT | Futures | 115.61 | 117.74 | 115.01 | 117.68 | 16987.0 |
| 2012-03-28 | DC | Futures | 25.38 | 25.66 | 25.27 | 25.66 | 58.0 |
| 2012-03-28 | DX | Futures | 76.823 | 77.041 | 76.591 | 76.832 | 27609.0 |
| 2012-03-28 | E1 | Futures | 1.4483 | 1.45341 | 1.44293 | 1.44843 | 36399.0 |
| 2012-03-28 | E6 | Futures | 1.59032 | 1.59712 | 1.58554 | 1.59103 | 239588.0 |
| 2012-03-28 | E7 | Futures | 1.5752 | 1.5817 | 1.5703 | 1.5758 | 3951.0 |
| 2012-03-28 | EBM | Futures | 286.03 | 288.05 | 284.35 | 284.69 | 7938.0 |
| 2012-03-28 | ED | Futures | 95.0931 | 95.1027 | 95.0884 | 95.0931 | 90641.0 |
| 2012-03-28 | ER | Futures | 97.553 | 97.557 | 97.538 | 97.548 | 91980.0 |
| 2012-03-28 | EW | Futures | 1009.9 | 1014.5 | 995.2 | 1003.8 | 24484.0 |
| 2012-03-28 | FBTP | Futures | 68.17 | 68.44 | 67.79 | 68.17 | 14377.0 |
| 2012-03-28 | FBTS | Futures | 85.778 | 85.982 | 85.721 | 85.868 | 859.0 |
| 2012-03-28 | FCE | Futures | 2448.7 | 2471.8 | 2417.1 | 2432.0 | 89532.0 |
| 2012-03-28 | FDAX | Futures | 7810.0 | 7875.7 | 7696.7 | 7758.6 | 153659.0 |
| 2012-03-28 | FESX | Futures | 1688.2 | 1704.8 | 1663.4 | 1677.2 | 1057111.0 |
| 2012-03-28 | FEU3 | Futures | 98.112 | 98.122 | 98.112 | 98.122 | 547.0 |
| 2012-03-28 | FGBL | Futures | 112.7 | 113.2 | 112.43 | 113.04 | 693691.0 |
| 2012-03-28 | FGBM | Futures | 113.41 | 113.65 | 113.23 | 113.57 | 401415.0 |
| 2012-03-28 | FGBS | Futures | 109.899 | 109.944 | 109.844 | 109.924 | 370406.0 |
| 2012-03-28 | FGBX | Futures | 116.71 | 117.21 | 115.96 | 116.93 | 4683.0 |
| 2012-03-28 | FTDX | Futures | 747.6 | 751.8 | 736.3 | 743.4 | 132.0 |
| 2012-03-28 | FTI | Futures | 276.2 | 278.31 | 272.64 | 274.13 | 28995.0 |
| 2012-03-28 | FTUK | Futures | 4239.6 | 4255.6 | 4177.9 | 4208.2 | 111330.0 |
| 2012-03-28 | FVSA | Futures | 7833.04 | 8151.05 | 7665.67 | 8100.84 | 3210.0 |
| 2012-03-28 | FXXP | Futures | 189.6 | 190.3 | 187.5 | 188.2 | 1047.0 |
| 2012-03-28 | G | Futures | 93.29 | 93.71 | 93.02 | 93.58 | 124656.0 |
| 2012-03-28 | GF | Futures | 323.187 | 323.187 | 319.314 | 320.204 | 1951.0 |
| 2012-03-28 | GSCI | Futures | 1106.74 | 1107.29 | 1098.11 | 1099.38 | 145.0 |
| 2012-03-28 | HE | Futures | 103.174 | 103.421 | 101.936 | 102.596 | 136.0 |
| 2012-03-28 | HG | Futures | 5.0705 | 5.0737 | 4.959 | 4.9721 | 48941.0 |
| 2012-03-28 | HO | Futures | 2.6563 | 2.6624 | 2.6412 | 2.6567 | 27748.0 |
| 2012-03-28 | HRC | Futures | 2699.8 | 2699.8 | 2699.8 | 2699.8 | 0.0 |
| 2012-03-28 | J1 | Futures | 0.015083 | 0.0151884 | 0.015083 | 0.0151583 | 99455.0 |
> showing 50 of 99 rows — these rows as CSV