PREVIEW / futures_daily / 2011-07-13
file: by_date/futures_daily/2011/2011-07-13.parquet size: 9 KB rows: 93
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-13 | ES | Futures | 1301.75 | 1318.63 | 1298.27 | 1303.24 | 2315093.0 |
| 2011-07-13 | NQ | Futures | 2669.82 | 2704.55 | 2662.13 | 2669.82 | 267288.0 |
| 2011-07-13 | YM | Futures | 11735.3 | 11869.6 | 11708.8 | 11746.7 | 120254.0 |
| 2011-07-13 | CL | Futures | 185.59 | 190.36 | 185.22 | 188.14 | 355098.0 |
| 2011-07-13 | GC | Futures | 2122.2 | 2150.5 | 2117.6 | 2145.9 | 210275.0 |
| 2011-07-13 | ZN | Futures | 106.333339 | 106.386559 | 105.774531 | 106.266815 | 1493281.0 |
| 2011-07-13 | A6 | Futures | 0.9137 | 0.9297 | 0.91265 | 0.9277 | 140290.0 |
| 2011-07-13 | AD | Futures | 1.03189 | 1.04038 | 1.0306 | 1.03928 | 87491.0 |
| 2011-07-13 | B | Futures | 99.24 | 101.35 | 98.71 | 100.48 | 229824.0 |
| 2011-07-13 | B6 | Futures | 1.6561 | 1.6759 | 1.6531 | 1.6741 | 154064.0 |
| 2011-07-13 | BFX | Futures | 2946.3 | 2976.5 | 2941.5 | 2963.3 | 552.0 |
| 2011-07-13 | BR | Futures | 0.28058 | 0.28058 | 0.27991 | 0.27991 | 433.0 |
| 2011-07-13 | BZ | Futures | 103.43 | 105.16 | 103.43 | 104.35 | 1256.0 |
| 2011-07-13 | C | Futures | 2106.0 | 2181.0 | 2094.0 | 2150.0 | 10050.0 |
| 2011-07-13 | CC | Futures | 2433.0 | 2526.0 | 2422.0 | 2513.0 | 11965.0 |
| 2011-07-13 | CT | Futures | 138.86 | 144.81 | 138.4 | 143.21 | 81.0 |
| 2011-07-13 | DC | Futures | 30.92 | 31.52 | 30.78 | 31.4 | 126.0 |
| 2011-07-13 | DX | Futures | 75.658 | 75.717 | 74.643 | 74.818 | 37181.0 |
| 2011-07-13 | E1 | Futures | 1.57688 | 1.60068 | 1.57073 | 1.59584 | 58564.0 |
| 2011-07-13 | E6 | Futures | 1.65587 | 1.68236 | 1.65361 | 1.67666 | 436217.0 |
| 2011-07-13 | E7 | Futures | 1.6435 | 1.67 | 1.6418 | 1.6644 | 6845.0 |
| 2011-07-13 | ED | Futures | 94.8858 | 94.9239 | 94.881 | 94.9096 | 323071.0 |
| 2011-07-13 | ER | Futures | 97.351 | 97.361 | 97.331 | 97.341 | 127784.0 |
| 2011-07-13 | EW | Futures | 970.0 | 984.1 | 968.3 | 971.9 | 21766.0 |
| 2011-07-13 | FBTP | Futures | 61.13 | 61.9 | 60.81 | 61.3 | 12771.0 |
| 2011-07-13 | FCE | Futures | 2655.2 | 2683.1 | 2638.7 | 2677.4 | 185599.0 |
| 2011-07-13 | FDAX | Futures | 7672.4 | 7801.7 | 7658.5 | 7788.4 | 165256.0 |
| 2011-07-13 | FESX | Futures | 1726.7 | 1748.5 | 1713.8 | 1744.0 | 1833002.0 |
| 2011-07-13 | FGBL | Futures | 103.56 | 103.73 | 102.85 | 102.96 | 1311143.0 |
| 2011-07-13 | FGBM | Futures | 106.85 | 107.02 | 106.42 | 106.64 | 756050.0 |
| 2011-07-13 | FGBS | Futures | 107.686 | 107.771 | 107.527 | 107.656 | 778863.0 |
| 2011-07-13 | FGBX | Futures | 100.54 | 100.83 | 98.95 | 99.04 | 9680.0 |
| 2011-07-13 | FTDX | Futures | 775.7 | 782.8 | 775.2 | 781.0 | 482.0 |
| 2011-07-13 | FTI | Futures | 273.45 | 275.06 | 271.83 | 274.73 | 15084.0 |
| 2011-07-13 | FTUK | Futures | 4103.6 | 4144.5 | 4096.9 | 4137.8 | 105935.0 |
| 2011-07-13 | FXXP | Futures | 181.1 | 182.6 | 180.7 | 182.6 | 2374.0 |
| 2011-07-13 | G | Futures | 85.95 | 86.09 | 85.52 | 85.73 | 151358.0 |
| 2011-07-13 | GF | Futures | 330.186 | 331.522 | 323.853 | 325.131 | 4001.0 |
| 2011-07-13 | GSCI | Futures | 1104.86 | 1124.64 | 1101.5 | 1117.83 | 2052.0 |
| 2011-07-13 | HE | Futures | 108.347 | 110.11 | 107.769 | 109.366 | 26526.0 |
| 2011-07-13 | HG | Futures | 5.802 | 5.8681 | 5.7809 | 5.8212 | 39181.0 |
| 2011-07-13 | HO | Futures | 2.4879 | 2.547 | 2.4861 | 2.5209 | 31803.0 |
| 2011-07-13 | HRC | Futures | 3010.1 | 3010.1 | 3010.1 | 3010.1 | 0.0 |
| 2011-07-13 | J1 | Futures | 0.0158924 | 0.0159402 | 0.0158019 | 0.0159201 | 114574.0 |
| 2011-07-13 | J7 | Futures | 0.015775 | 0.015831 | 0.0157 | 0.015814 | 241.0 |
| 2011-07-13 | JB | Futures | 123.1 | 123.12 | 122.99 | 123.12 | 31.0 |
| 2011-07-13 | KC | Futures | 612.02 | 629.76 | 610.96 | 624.44 | 10823.0 |
| 2011-07-13 | KE | Futures | 2815.46 | 2941.25 | 2787.61 | 2926.85 | 18993.0 |
| 2011-07-13 | L | Futures | 98.413 | 98.443 | 98.403 | 98.433 | 26746.0 |
| 2011-07-13 | LBS | Futures | 558.4 | 563.8 | 548.3 | 550.3 | 396.0 |
> showing 50 of 93 rows — these rows as CSV