PREVIEW / futures_daily / 2011-03-28
file: by_date/futures_daily/2011/2011-03-28.parquet size: 9 KB rows: 92
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-28 | ES | Futures | 1296.17 | 1302.11 | 1288.99 | 1289.24 | 1290490.0 |
| 2011-03-28 | NQ | Futures | 2637.94 | 2651.9 | 2613.46 | 2614.6 | 205806.0 |
| 2011-03-28 | YM | Futures | 11441.9 | 11477.7 | 11386.5 | 11389.3 | 71107.0 |
| 2011-03-28 | CL | Futures | 203.88 | 204.52 | 200.34 | 201.08 | 223079.0 |
| 2011-03-28 | GC | Futures | 1935.5 | 1940.0 | 1910.5 | 1923.7 | 108286.0 |
| 2011-03-28 | ZN | Futures | 100.394512 | 100.499858 | 100.131148 | 100.355007 | 856063.0 |
| 2011-03-28 | A6 | Futures | 0.87029 | 0.87638 | 0.86943 | 0.87277 | 69646.0 |
| 2011-03-28 | AD | Futures | 1.01295 | 1.02052 | 1.01176 | 1.01853 | 57240.0 |
| 2011-03-28 | B | Futures | 98.04 | 98.24 | 97.0 | 97.19 | 63575.0 |
| 2011-03-28 | B6 | Futures | 1.6612 | 1.6646 | 1.654 | 1.6607 | 105476.0 |
| 2011-03-28 | BFX | Futures | 3067.9 | 3110.1 | 3056.4 | 3069.7 | 128.0 |
| 2011-03-28 | BR | Futures | 0.26173 | 0.26173 | 0.26154 | 0.26154 | 403.0 |
| 2011-03-28 | BZ | Futures | 102.36 | 103.42 | 102.36 | 102.47 | 539.0 |
| 2011-03-28 | C | Futures | 2321.0 | 2357.0 | 2320.0 | 2346.0 | 3662.0 |
| 2011-03-28 | CC | Futures | 2573.0 | 2631.0 | 2573.0 | 2610.0 | 6149.0 |
| 2011-03-28 | CSC | Futures | 4.433 | 4.505 | 4.433 | 4.505 | 7.0 |
| 2011-03-28 | CT | Futures | 181.43 | 182.42 | 176.6 | 176.6 | 6478.0 |
| 2011-03-28 | DC | Futures | 29.6 | 30.19 | 28.84 | 29.84 | 331.0 |
| 2011-03-28 | DX | Futures | 76.138 | 76.312 | 75.914 | 75.995 | 17318.0 |
| 2011-03-28 | E1 | Futures | 1.42226 | 1.43156 | 1.41873 | 1.42894 | 34995.0 |
| 2011-03-28 | E6 | Futures | 1.66173 | 1.66978 | 1.65829 | 1.66753 | 237107.0 |
| 2011-03-28 | E7 | Futures | 1.6505 | 1.6572 | 1.6461 | 1.6551 | 4728.0 |
| 2011-03-28 | EBM | Futures | 221.22 | 228.03 | 221.22 | 227.56 | 9364.0 |
| 2011-03-28 | ED | Futures | 94.8454 | 94.8502 | 94.8359 | 94.8454 | 141252.0 |
| 2011-03-28 | ER | Futures | 97.247 | 97.262 | 97.242 | 97.247 | 59296.0 |
| 2011-03-28 | EW | Futures | 962.2 | 967.9 | 955.0 | 955.2 | 17371.0 |
| 2011-03-28 | FBTP | Futures | 64.0 | 64.13 | 64.0 | 64.06 | 4120.0 |
| 2011-03-28 | FCE | Futures | 2643.6 | 2657.9 | 2635.9 | 2646.6 | 85967.0 |
| 2011-03-28 | FDAX | Futures | 7435.3 | 7478.6 | 7405.4 | 7432.6 | 115278.0 |
| 2011-03-28 | FESX | Futures | 1815.8 | 1825.4 | 1808.1 | 1817.7 | 730848.0 |
| 2011-03-28 | FEU3 | Futures | 97.8 | 97.8 | 97.79 | 97.79 | 5.0 |
| 2011-03-28 | FGBL | Futures | 97.36 | 97.53 | 97.19 | 97.37 | 684094.0 |
| 2011-03-28 | FGBM | Futures | 102.86 | 102.93 | 102.71 | 102.84 | 439044.0 |
| 2011-03-28 | FGBS | Futures | 106.325 | 106.36 | 106.275 | 106.33 | 572542.0 |
| 2011-03-28 | FGBX | Futures | 93.42 | 93.83 | 93.09 | 93.46 | 3440.0 |
| 2011-03-28 | FTDX | Futures | 807.4 | 824.3 | 807.4 | 823.0 | 620.0 |
| 2011-03-28 | FTI | Futures | 295.26 | 296.81 | 295.02 | 295.75 | 24382.0 |
| 2011-03-28 | FTUK | Futures | 4094.8 | 4116.1 | 4089.9 | 4101.1 | 60598.0 |
| 2011-03-28 | FXXP | Futures | 181.7 | 182.3 | 180.7 | 181.6 | 1264.0 |
| 2011-03-28 | G | Futures | 81.65 | 81.88 | 81.5 | 81.74 | 71734.0 |
| 2011-03-28 | GF | Futures | 327.19 | 327.916 | 325.254 | 326.464 | 973.0 |
| 2011-03-28 | GSCI | Futures | 1119.4 | 1119.4 | 1109.7 | 1110.79 | 288.0 |
| 2011-03-28 | HE | Futures | 107.637 | 108.248 | 107.212 | 108.248 | 482.0 |
| 2011-03-28 | HG | Futures | 5.8974 | 5.908 | 5.7695 | 5.7942 | 25815.0 |
| 2011-03-28 | HO | Futures | 2.5583 | 2.5751 | 2.5332 | 2.5379 | 16828.0 |
| 2011-03-28 | HRC | Futures | 3106.0 | 3106.0 | 3106.0 | 3106.0 | 1.0 |
| 2011-03-28 | J1 | Futures | 0.0154438 | 0.0154451 | 0.0153559 | 0.015391 | 80571.0 |
| 2011-03-28 | J7 | Futures | 0.015345 | 0.015345 | 0.015264 | 0.015297 | 275.0 |
| 2011-03-28 | JB | Futures | 121.47 | 121.47 | 121.47 | 121.47 | 1473.0 |
| 2011-03-28 | KC | Futures | 653.43 | 653.67 | 637.55 | 639.73 | 9073.0 |
> showing 50 of 92 rows — these rows as CSV