PREVIEW / futures_daily / 2012-05-31
file: by_date/futures_daily/2012/2012-05-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-05-31 | ES | Futures | 1319.1 | 1329.18 | 1307.26 | 1319.35 | 2746687.0 |
| 2012-05-31 | NQ | Futures | 2900.68 | 2912.99 | 2871.17 | 2891.8 | 307420.0 |
| 2012-05-31 | YM | Futures | 12041.4 | 12135.7 | 11968.4 | 12042.3 | 199425.0 |
| 2012-05-31 | CL | Futures | 160.45 | 161.79 | 157.35 | 158.58 | 345433.0 |
| 2012-05-31 | GC | Futures | 2090.9 | 2104.9 | 2076.0 | 2091.0 | 177334.0 |
| 2012-05-31 | ZN | Futures | 116.670316 | 117.198297 | 116.480784 | 116.886924 | 465590.0 |
| 2012-05-31 | A6 | Futures | 0.87211 | 0.87769 | 0.86887 | 0.87508 | 174254.0 |
| 2012-05-31 | AD | Futures | 0.97633 | 0.97996 | 0.9701 | 0.97362 | 139488.0 |
| 2012-05-31 | B | Futures | 93.37 | 94.2 | 91.62 | 92.1 | 113501.0 |
| 2012-05-31 | B6 | Futures | 1.6249 | 1.6294 | 1.612 | 1.6175 | 150295.0 |
| 2012-05-31 | BFX | Futures | 2573.7 | 2575.8 | 2535.7 | 2556.2 | 155.0 |
| 2012-05-31 | BR | Futures | 0.23234 | 0.23372 | 0.23234 | 0.23236 | 460.0 |
| 2012-05-31 | BZ | Futures | 99.48 | 99.68 | 97.92 | 97.92 | 770.0 |
| 2012-05-31 | C | Futures | 1463.0 | 1479.0 | 1455.0 | 1470.0 | 9331.0 |
| 2012-05-31 | CB | Futures | 79.793 | 79.793 | 79.793 | 79.793 | 3.0 |
| 2012-05-31 | CC | Futures | 1561.0 | 1591.0 | 1561.0 | 1570.0 | 14553.0 |
| 2012-05-31 | CSC | Futures | 3.608 | 3.617 | 3.597 | 3.597 | 39.0 |
| 2012-05-31 | CT | Futures | 87.29 | 87.77 | 86.39 | 87.53 | 17611.0 |
| 2012-05-31 | DC | Futures | 25.66 | 25.83 | 25.5 | 25.58 | 111.0 |
| 2012-05-31 | DX | Futures | 80.544 | 80.703 | 80.229 | 80.543 | 31355.0 |
| 2012-05-31 | E1 | Futures | 1.3488 | 1.35469 | 1.34513 | 1.34853 | 57695.0 |
| 2012-05-31 | E6 | Futures | 1.47679 | 1.48372 | 1.47273 | 1.47643 | 354135.0 |
| 2012-05-31 | E7 | Futures | 1.463 | 1.4696 | 1.4587 | 1.4623 | 2684.0 |
| 2012-05-31 | ED | Futures | 95.0621 | 95.0717 | 95.0573 | 95.0693 | 164071.0 |
| 2012-05-31 | ER | Futures | 97.567 | 97.582 | 97.553 | 97.572 | 99796.0 |
| 2012-05-31 | EW | Futures | 935.3 | 942.3 | 922.9 | 935.3 | 33871.0 |
| 2012-05-31 | FBTP | Futures | 64.81 | 65.46 | 64.77 | 64.85 | 33598.0 |
| 2012-05-31 | FBTS | Futures | 83.492 | 83.768 | 83.378 | 83.386 | 7517.0 |
| 2012-05-31 | FCE | Futures | 2214.8 | 2237.6 | 2189.4 | 2211.1 | 161530.0 |
| 2012-05-31 | FDAX | Futures | 6952.1 | 6990.3 | 6863.2 | 6896.9 | 183899.0 |
| 2012-05-31 | FESX | Futures | 1458.4 | 1471.5 | 1443.9 | 1452.9 | 1541123.0 |
| 2012-05-31 | FGBL | Futures | 119.17 | 119.78 | 118.87 | 119.74 | 1147525.0 |
| 2012-05-31 | FGBM | Futures | 116.2 | 116.44 | 116.06 | 116.41 | 748772.0 |
| 2012-05-31 | FGBS | Futures | 110.382 | 110.422 | 110.363 | 110.402 | 696267.0 |
| 2012-05-31 | FGBX | Futures | 131.68 | 133.78 | 131.49 | 133.51 | 34772.0 |
| 2012-05-31 | FOAT | Futures | 98.95 | 100.22 | 98.95 | 100.06 | 36495.0 |
| 2012-05-31 | FTDX | Futures | 706.8 | 709.2 | 695.6 | 698.4 | 398.0 |
| 2012-05-31 | FTI | Futures | 252.58 | 253.84 | 249.42 | 251.32 | 36178.0 |
| 2012-05-31 | FTUK | Futures | 3844.9 | 3902.9 | 3836.5 | 3858.4 | 163863.0 |
| 2012-05-31 | FVSA | Futures | 10727.07 | 11321.28 | 10680.16 | 11211.82 | 3726.0 |
| 2012-05-31 | FXXP | Futures | 174.6 | 175.3 | 172.3 | 173.0 | 3845.0 |
| 2012-05-31 | G | Futures | 99.03 | 99.74 | 98.63 | 99.72 | 183126.0 |
| 2012-05-31 | GF | Futures | 307.387 | 310.989 | 307.289 | 309.46 | 3790.0 |
| 2012-05-31 | GSCI | Futures | 953.86 | 957.11 | 943.94 | 947.99 | 434.0 |
| 2012-05-31 | HE | Futures | 93.313 | 95.98 | 93.313 | 95.793 | 21800.0 |
| 2012-05-31 | HG | Futures | 4.4337 | 4.4599 | 4.376 | 4.4075 | 77584.0 |
| 2012-05-31 | HO | Futures | 2.2577 | 2.2698 | 2.2239 | 2.2279 | 16390.0 |
| 2012-05-31 | HRC | Futures | 2550.0 | 2550.0 | 2550.0 | 2550.0 | 0.0 |
| 2012-05-31 | J1 | Futures | 0.0158517 | 0.0160335 | 0.0158479 | 0.0160084 | 133628.0 |
| 2012-05-31 | J7 | Futures | 0.015784 | 0.015958 | 0.015784 | 0.015933 | 597.0 |
> showing 50 of 99 rows — these rows as CSV