PREVIEW / futures_daily / 2011-05-09
file: by_date/futures_daily/2011/2011-05-09.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-05-09 | ES | Futures | 1323.89 | 1332.8 | 1321.17 | 1329.34 | 1666599.0 |
| 2011-05-09 | NQ | Futures | 2708.27 | 2731.05 | 2703.72 | 2717.95 | 265715.0 |
| 2011-05-09 | YM | Futures | 11833.1 | 11918.6 | 11819.9 | 11875.4 | 105033.0 |
| 2011-05-09 | CL | Futures | 189.07 | 199.26 | 187.74 | 197.62 | 469290.0 |
| 2011-05-09 | GC | Futures | 2025.7 | 2049.1 | 2015.4 | 2034.6 | 153908.0 |
| 2011-05-09 | ZN | Futures | 102.962315 | 103.265184 | 102.830633 | 103.212511 | 1010936.0 |
| 2011-05-09 | A6 | Futures | 0.91437 | 0.9232 | 0.91188 | 0.91926 | 95610.0 |
| 2011-05-09 | AD | Futures | 1.02928 | 1.03575 | 1.026 | 1.03157 | 80119.0 |
| 2011-05-09 | B | Futures | 93.34 | 98.42 | 92.35 | 97.9 | 205644.0 |
| 2011-05-09 | B6 | Futures | 1.7005 | 1.7038 | 1.6894 | 1.7019 | 125994.0 |
| 2011-05-09 | BFX | Futures | 3184.5 | 3184.9 | 3101.5 | 3143.2 | 161.0 |
| 2011-05-09 | BR | Futures | 0.26904 | 0.27124 | 0.26851 | 0.27084 | 442.0 |
| 2011-05-09 | BZ | Futures | 100.43 | 103.28 | 100.43 | 103.16 | 803.0 |
| 2011-05-09 | C | Futures | 2061.0 | 2097.0 | 2045.0 | 2062.0 | 3331.0 |
| 2011-05-09 | CB | Futures | 120.269 | 120.269 | 120.269 | 120.269 | 3.0 |
| 2011-05-09 | CC | Futures | 2453.0 | 2509.0 | 2445.0 | 2453.0 | 8659.0 |
| 2011-05-09 | CSC | Futures | 4.41 | 4.412 | 4.41 | 4.412 | 2.0 |
| 2011-05-09 | CT | Futures | 143.61 | 147.04 | 141.74 | 143.91 | 6939.0 |
| 2011-05-09 | DC | Futures | 29.69 | 29.91 | 29.53 | 29.81 | 137.0 |
| 2011-05-09 | DX | Futures | 74.651 | 74.984 | 74.233 | 74.526 | 51476.0 |
| 2011-05-09 | E1 | Futures | 1.49349 | 1.50371 | 1.49022 | 1.50083 | 37867.0 |
| 2011-05-09 | E6 | Futures | 1.69987 | 1.70922 | 1.68696 | 1.69667 | 386539.0 |
| 2011-05-09 | E7 | Futures | 1.6867 | 1.6964 | 1.6744 | 1.684 | 6485.0 |
| 2011-05-09 | ED | Futures | 94.9406 | 94.9502 | 94.9406 | 94.9454 | 155851.0 |
| 2011-05-09 | ER | Futures | 97.281 | 97.291 | 97.267 | 97.281 | 121080.0 |
| 2011-05-09 | EW | Futures | 981.2 | 993.2 | 978.5 | 991.1 | 23678.0 |
| 2011-05-09 | FBTP | Futures | 64.91 | 64.94 | 64.73 | 64.89 | 5166.0 |
| 2011-05-09 | FCE | Futures | 2710.3 | 2739.2 | 2691.9 | 2702.8 | 154437.0 |
| 2011-05-09 | FDAX | Futures | 7958.0 | 8010.9 | 7891.8 | 7930.3 | 133592.0 |
| 2011-05-09 | FESX | Futures | 1852.9 | 1865.1 | 1832.4 | 1839.5 | 1359455.0 |
| 2011-05-09 | FEU3 | Futures | 97.815 | 97.825 | 97.815 | 97.825 | 323.0 |
| 2011-05-09 | FGBL | Futures | 98.96 | 99.57 | 98.86 | 99.44 | 1091005.0 |
| 2011-05-09 | FGBM | Futures | 103.53 | 103.86 | 103.39 | 103.81 | 610056.0 |
| 2011-05-09 | FGBS | Futures | 106.439 | 106.558 | 106.384 | 106.533 | 734273.0 |
| 2011-05-09 | FGBX | Futures | 95.42 | 96.79 | 95.29 | 96.37 | 5473.0 |
| 2011-05-09 | FTDX | Futures | 836.8 | 836.8 | 825.2 | 829.7 | 226.0 |
| 2011-05-09 | FTI | Futures | 291.03 | 294.94 | 290.57 | 291.85 | 38893.0 |
| 2011-05-09 | FTUK | Futures | 4136.1 | 4179.8 | 4123.8 | 4139.9 | 102207.0 |
| 2011-05-09 | FXXP | Futures | 186.5 | 187.6 | 185.3 | 186.4 | 298.0 |
| 2011-05-09 | G | Futures | 83.53 | 83.84 | 83.47 | 83.73 | 102628.0 |
| 2011-05-09 | GF | Futures | 311.298 | 311.599 | 308.05 | 308.05 | 898.0 |
| 2011-05-09 | GSCI | Futures | 1056.06 | 1098.39 | 1056.06 | 1092.69 | 2406.0 |
| 2011-05-09 | HE | Futures | 98.217 | 98.72 | 97.317 | 98.111 | 23229.0 |
| 2011-05-09 | HG | Futures | 5.2943 | 5.4079 | 5.281 | 5.3361 | 31872.0 |
| 2011-05-09 | HO | Futures | 2.3764 | 2.4829 | 2.3722 | 2.461 | 73747.0 |
| 2011-05-09 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-05-09 | J1 | Futures | 0.0155845 | 0.0156724 | 0.015543 | 0.015641 | 91702.0 |
| 2011-05-09 | J7 | Futures | 0.01549 | 0.015576 | 0.015449 | 0.015545 | 483.0 |
| 2011-05-09 | JB | Futures | 122.58 | 122.6 | 122.39 | 122.45 | 7.0 |
| 2011-05-09 | KC | Futures | 695.42 | 705.61 | 688.22 | 689.18 | 8600.0 |
> showing 50 of 93 rows — these rows as CSV