PREVIEW / futures_daily / 2011-03-18
file: by_date/futures_daily/2011/2011-03-18.parquet size: 9 KB rows: 94
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-03-18 | ES | Futures | 1255.83 | 1274.64 | 1248.9 | 1261.52 | 2342198.0 |
| 2011-03-18 | NQ | Futures | 2534.59 | 2566.76 | 2522.63 | 2530.04 | 356862.0 |
| 2011-03-18 | YM | Futures | 11002.9 | 11155.2 | 10958.7 | 11093.1 | 117477.0 |
| 2011-03-18 | CL | Futures | 198.79 | 202.16 | 195.33 | 196.96 | 227003.0 |
| 2011-03-18 | GC | Futures | 1906.6 | 1932.7 | 1902.9 | 1921.8 | 135868.0 |
| 2011-03-18 | ZN | Futures | 101.882521 | 102.080044 | 101.44797 | 101.711334 | 1091691.0 |
| 2011-03-18 | A6 | Futures | 0.83272 | 0.84687 | 0.82989 | 0.84524 | 133316.0 |
| 2011-03-18 | AD | Futures | 1.00867 | 1.01375 | 1.00718 | 1.00797 | 73358.0 |
| 2011-03-18 | B | Futures | 97.96 | 99.48 | 95.9 | 96.63 | 227420.0 |
| 2011-03-18 | B6 | Futures | 1.6756 | 1.6874 | 1.6667 | 1.6829 | 123635.0 |
| 2011-03-18 | BFX | Futures | 2965.9 | 2980.1 | 2956.0 | 2968.6 | 54.0 |
| 2011-03-18 | BR | Futures | 0.25905 | 0.25905 | 0.25905 | 0.25905 | 1228.0 |
| 2011-03-18 | BZ | Futures | 103.64 | 103.94 | 101.04 | 101.79 | 1686.0 |
| 2011-03-18 | C | Futures | 2361.0 | 2366.0 | 2208.0 | 2212.0 | 12368.0 |
| 2011-03-18 | CB | Futures | 115.575 | 115.575 | 114.989 | 115.047 | 7.0 |
| 2011-03-18 | CC | Futures | 2664.0 | 2686.0 | 2488.0 | 2513.0 | 16058.0 |
| 2011-03-18 | CSC | Futures | 4.289 | 4.289 | 4.232 | 4.232 | 4.0 |
| 2011-03-18 | CT | Futures | 175.38 | 178.06 | 174.65 | 178.06 | 8407.0 |
| 2011-03-18 | DC | Futures | 28.57 | 29.17 | 28.39 | 28.46 | 238.0 |
| 2011-03-18 | DX | Futures | 75.909 | 76.382 | 75.412 | 75.592 | 25095.0 |
| 2011-03-18 | E1 | Futures | 1.45801 | 1.45984 | 1.44151 | 1.4529 | 47977.0 |
| 2011-03-18 | E6 | Futures | 1.65817 | 1.67807 | 1.65379 | 1.67452 | 289168.0 |
| 2011-03-18 | E7 | Futures | 1.6462 | 1.6657 | 1.6416 | 1.6621 | 4756.0 |
| 2011-03-18 | EBM | Futures | 218.41 | 223.1 | 215.12 | 217.7 | 21543.0 |
| 2011-03-18 | ED | Futures | 94.855 | 94.8645 | 94.8502 | 94.8597 | 131535.0 |
| 2011-03-18 | ER | Futures | 97.316 | 97.341 | 97.242 | 97.247 | 174453.0 |
| 2011-03-18 | EW | Futures | 928.2 | 940.9 | 925.0 | 934.5 | 28730.0 |
| 2011-03-18 | FBTP | Futures | 64.28 | 64.58 | 64.27 | 64.53 | 3344.0 |
| 2011-03-18 | FCE | Futures | 2529.4 | 2571.4 | 2526.5 | 2538.1 | 176784.0 |
| 2011-03-18 | FDAX | Futures | 7201.5 | 7244.7 | 7094.7 | 7148.6 | 185141.0 |
| 2011-03-18 | FESX | Futures | 1747.2 | 1767.1 | 1730.6 | 1740.8 | 1873308.0 |
| 2011-03-18 | FEU3 | Futures | 97.85 | 97.875 | 97.79 | 97.79 | 421.0 |
| 2011-03-18 | FGBL | Futures | 98.24 | 98.59 | 98.04 | 98.12 | 881712.0 |
| 2011-03-18 | FGBM | Futures | 103.57 | 103.78 | 103.23 | 103.31 | 537973.0 |
| 2011-03-18 | FGBS | Futures | 106.632 | 106.712 | 106.419 | 106.449 | 674475.0 |
| 2011-03-18 | FGBX | Futures | 95.05 | 95.86 | 94.78 | 95.02 | 7391.0 |
| 2011-03-18 | FTDX | Futures | 788.6 | 792.6 | 775.2 | 776.1 | 3123.0 |
| 2011-03-18 | FTI | Futures | 284.66 | 286.54 | 282.99 | 284.38 | 56057.0 |
| 2011-03-18 | FTUK | Futures | 3957.3 | 4000.7 | 3955.2 | 3974.1 | 145234.0 |
| 2011-03-18 | FXXP | Futures | 175.8 | 177.0 | 175.1 | 175.6 | 1474.0 |
| 2011-03-18 | G | Futures | 82.11 | 82.36 | 82.04 | 82.28 | 103838.0 |
| 2011-03-18 | GF | Futures | 313.396 | 316.119 | 311.521 | 312.61 | 754.0 |
| 2011-03-18 | GSCI | Futures | 1106.8 | 1112.51 | 1092.94 | 1099.05 | 206.0 |
| 2011-03-18 | HE | Futures | 102.855 | 104.502 | 102.191 | 104.502 | 478.0 |
| 2011-03-18 | HG | Futures | 5.7915 | 5.8288 | 5.7295 | 5.7795 | 28697.0 |
| 2011-03-18 | HO | Futures | 2.5759 | 2.5965 | 2.5172 | 2.5328 | 27911.0 |
| 2011-03-18 | HRC | Futures | 3098.9 | 3098.9 | 3098.9 | 3098.9 | 0.0 |
| 2011-03-18 | J1 | Futures | 0.0158961 | 0.0159023 | 0.015327 | 0.0155229 | 267799.0 |
| 2011-03-18 | J7 | Futures | 0.015765 | 0.015795 | 0.015236 | 0.015428 | 1906.0 |
| 2011-03-18 | JB | Futures | 121.72 | 121.72 | 121.72 | 121.72 | 2759.0 |
> showing 50 of 94 rows — these rows as CSV