PREVIEW / futures_daily / 2012-05-30
file: by_date/futures_daily/2012/2012-05-30.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-05-30 | ES | Futures | 1343.79 | 1344.55 | 1318.09 | 1318.6 | 2313731.0 |
| 2012-05-30 | NQ | Futures | 2933.04 | 2934.19 | 2887.5 | 2899.53 | 307814.0 |
| 2012-05-30 | YM | Futures | 12236.8 | 12241.7 | 12035.5 | 12040.4 | 192577.0 |
| 2012-05-30 | CL | Futures | 166.52 | 166.63 | 159.94 | 160.95 | 297197.0 |
| 2012-05-30 | GC | Futures | 2079.8 | 2100.1 | 2048.1 | 2093.0 | 273695.0 |
| 2012-05-30 | ZN | Futures | 115.817423 | 116.77862 | 115.803885 | 116.683854 | 1624141.0 |
| 2012-05-30 | A6 | Futures | 0.88336 | 0.88399 | 0.87139 | 0.87238 | 143895.0 |
| 2012-05-30 | AD | Futures | 0.98287 | 0.98368 | 0.97523 | 0.97663 | 120447.0 |
| 2012-05-30 | B | Futures | 96.55 | 96.55 | 93.07 | 93.59 | 90978.0 |
| 2012-05-30 | B6 | Futures | 1.6411 | 1.6412 | 1.624 | 1.6252 | 113892.0 |
| 2012-05-30 | BFX | Futures | 2577.5 | 2594.4 | 2546.0 | 2565.6 | 298.0 |
| 2012-05-30 | BR | Futures | 0.23329 | 0.23329 | 0.23329 | 0.23329 | 584.0 |
| 2012-05-30 | BZ | Futures | 101.36 | 101.36 | 99.5 | 99.5 | 794.0 |
| 2012-05-30 | C | Futures | 1464.0 | 1468.0 | 1441.0 | 1449.0 | 8395.0 |
| 2012-05-30 | CB | Futures | 80.062 | 80.062 | 80.062 | 80.062 | 6.0 |
| 2012-05-30 | CC | Futures | 1587.0 | 1587.0 | 1543.0 | 1561.0 | 13700.0 |
| 2012-05-30 | CSC | Futures | 3.61 | 3.628 | 3.608 | 3.617 | 32.0 |
| 2012-05-30 | CT | Futures | 88.61 | 89.49 | 86.1 | 86.75 | 22236.0 |
| 2012-05-30 | DC | Futures | 25.66 | 25.74 | 25.53 | 25.66 | 55.0 |
| 2012-05-30 | DX | Futures | 80.035 | 80.587 | 80.001 | 80.501 | 28931.0 |
| 2012-05-30 | E1 | Futures | 1.36215 | 1.36241 | 1.34801 | 1.35024 | 56666.0 |
| 2012-05-30 | E6 | Futures | 1.491 | 1.49147 | 1.47572 | 1.47799 | 363376.0 |
| 2012-05-30 | E7 | Futures | 1.4767 | 1.4771 | 1.4614 | 1.4638 | 3525.0 |
| 2012-05-30 | ED | Futures | 95.0669 | 95.0669 | 95.0549 | 95.0621 | 181739.0 |
| 2012-05-30 | ER | Futures | 97.548 | 97.572 | 97.543 | 97.567 | 85081.0 |
| 2012-05-30 | EW | Futures | 957.5 | 958.0 | 934.8 | 935.2 | 26871.0 |
| 2012-05-30 | FBTP | Futures | 65.67 | 65.67 | 64.43 | 64.82 | 41496.0 |
| 2012-05-30 | FBTS | Futures | 83.768 | 83.768 | 83.069 | 83.337 | 5109.0 |
| 2012-05-30 | FCE | Futures | 2248.0 | 2259.0 | 2202.6 | 2213.3 | 187205.0 |
| 2012-05-30 | FDAX | Futures | 7051.6 | 7070.4 | 6918.4 | 6946.1 | 221381.0 |
| 2012-05-30 | FESX | Futures | 1481.2 | 1492.2 | 1451.5 | 1457.7 | 1779235.0 |
| 2012-05-30 | FEU3 | Futures | 98.117 | 98.142 | 98.117 | 98.142 | 53.0 |
| 2012-05-30 | FGBL | Futures | 118.28 | 119.28 | 118.27 | 119.17 | 1206133.0 |
| 2012-05-30 | FGBM | Futures | 115.87 | 116.31 | 115.83 | 116.25 | 666456.0 |
| 2012-05-30 | FGBS | Futures | 110.348 | 110.432 | 110.338 | 110.412 | 629265.0 |
| 2012-05-30 | FGBX | Futures | 129.35 | 132.15 | 129.35 | 131.9 | 19025.0 |
| 2012-05-30 | FOAT | Futures | 98.7 | 99.03 | 98.02 | 98.73 | 20675.0 |
| 2012-05-30 | FTDX | Futures | 712.9 | 713.4 | 701.7 | 704.0 | 141.0 |
| 2012-05-30 | FTI | Futures | 255.14 | 256.09 | 251.24 | 252.23 | 51969.0 |
| 2012-05-30 | FTUK | Futures | 3922.2 | 3922.2 | 3845.2 | 3857.6 | 138144.0 |
| 2012-05-30 | FVSA | Futures | 10461.24 | 10914.72 | 10320.51 | 10836.53 | 5632.0 |
| 2012-05-30 | FXXP | Futures | 175.5 | 176.5 | 174.0 | 174.2 | 5623.0 |
| 2012-05-30 | G | Futures | 97.92 | 99.1 | 97.92 | 99.02 | 182958.0 |
| 2012-05-30 | GF | Futures | 311.236 | 312.124 | 305.216 | 308.029 | 4113.0 |
| 2012-05-30 | GSCI | Futures | 967.83 | 968.22 | 954.81 | 957.03 | 196.0 |
| 2012-05-30 | HE | Futures | 92.113 | 93.579 | 91.606 | 92.993 | 11872.0 |
| 2012-05-30 | HG | Futures | 4.5463 | 4.5469 | 4.4166 | 4.4396 | 73952.0 |
| 2012-05-30 | HO | Futures | 2.3208 | 2.3208 | 2.2545 | 2.2601 | 18046.0 |
| 2012-05-30 | HRC | Futures | 2550.0 | 2550.0 | 2550.0 | 2550.0 | 0.0 |
| 2012-05-30 | J1 | Futures | 0.0157677 | 0.0159018 | 0.0157614 | 0.0158617 | 105060.0 |
> showing 50 of 99 rows — these rows as CSV