PREVIEW / futures_daily / 2009-07-30
file: by_date/futures_daily/2009/2009-07-30.parquet size: 8 KB rows: 86
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-30 | ES | Futures | 934.49 | 953.68 | 934.01 | 942.41 | 2202255.0 |
| 2009-07-30 | NQ | Futures | 1802.14 | 1837.9 | 1800.73 | 1809.46 | 324926.0 |
| 2009-07-30 | YM | Futures | 8160.0 | 8303.4 | 8154.5 | 8201.5 | 150350.0 |
| 2009-07-30 | CL | Futures | 161.84 | 173.25 | 161.58 | 172.35 | 344216.0 |
| 2009-07-30 | GC | Futures | 1288.3 | 1298.7 | 1286.9 | 1295.8 | 62132.0 |
| 2009-07-30 | ZN | Futures | 91.384461 | 91.766153 | 91.039707 | 91.556838 | 771377.0 |
| 2009-07-30 | A6 | Futures | 0.65488 | 0.66412 | 0.65238 | 0.66267 | 78269.0 |
| 2009-07-30 | AD | Futures | 0.90554 | 0.91442 | 0.90504 | 0.91225 | 60418.0 |
| 2009-07-30 | B | Futures | 63.34 | 66.96 | 63.27 | 66.75 | 82543.0 |
| 2009-07-30 | B6 | Futures | 1.705 | 1.7214 | 1.7018 | 1.7174 | 112307.0 |
| 2009-07-30 | BFX | Futures | 2430.3 | 2467.3 | 2414.1 | 2462.6 | 90.0 |
| 2009-07-30 | BR | Futures | 0.2061 | 0.2061 | 0.2061 | 0.2061 | 29.0 |
| 2009-07-30 | BZ | Futures | 68.74 | 69.63 | 68.74 | 69.63 | 3.0 |
| 2009-07-30 | C | Futures | 1875.0 | 1943.0 | 1874.0 | 1933.0 | 3467.0 |
| 2009-07-30 | CB | Futures | 73.752 | 73.752 | 73.752 | 73.752 | 4.0 |
| 2009-07-30 | CC | Futures | 2489.0 | 2606.0 | 2489.0 | 2578.0 | 8747.0 |
| 2009-07-30 | CT | Futures | 50.37 | 51.9 | 50.29 | 51.37 | 152.0 |
| 2009-07-30 | DC | Futures | 21.52 | 21.82 | 20.95 | 21.08 | 327.0 |
| 2009-07-30 | DX | Futures | 81.602 | 81.648 | 81.172 | 81.274 | 4144.0 |
| 2009-07-30 | E1 | Futures | 1.21776 | 1.22146 | 1.21114 | 1.21709 | 35330.0 |
| 2009-07-30 | E6 | Futures | 1.66645 | 1.67334 | 1.66289 | 1.67108 | 224051.0 |
| 2009-07-30 | E7 | Futures | 1.6495 | 1.6563 | 1.6461 | 1.6539 | 2151.0 |
| 2009-07-30 | ED | Futures | 93.9424 | 93.9613 | 93.9424 | 93.9472 | 137418.0 |
| 2009-07-30 | ER | Futures | 97.1 | 97.135 | 97.09 | 97.12 | 90270.0 |
| 2009-07-30 | EW | Futures | 598.0 | 611.5 | 598.0 | 603.6 | 35956.0 |
| 2009-07-30 | FCE | Futures | 2223.5 | 2265.7 | 2209.7 | 2252.3 | 128206.0 |
| 2009-07-30 | FDAX | Futures | 5823.8 | 5925.8 | 5766.2 | 5896.7 | 149461.0 |
| 2009-07-30 | FESX | Futures | 1565.7 | 1591.3 | 1551.3 | 1585.4 | 1231187.0 |
| 2009-07-30 | FEU3 | Futures | 97.682 | 97.697 | 97.682 | 97.697 | 11.0 |
| 2009-07-30 | FGBL | Futures | 91.7 | 92.27 | 91.49 | 91.83 | 649778.0 |
| 2009-07-30 | FGBM | Futures | 97.84 | 98.17 | 97.71 | 97.89 | 288273.0 |
| 2009-07-30 | FGBS | Futures | 103.988 | 104.09 | 103.974 | 104.027 | 388444.0 |
| 2009-07-30 | FGBX | Futures | 83.55 | 84.8 | 83.46 | 84.08 | 1864.0 |
| 2009-07-30 | FTDX | Futures | 593.4 | 602.3 | 587.1 | 600.5 | 1589.0 |
| 2009-07-30 | FTI | Futures | 228.38 | 233.06 | 226.86 | 232.28 | 34089.0 |
| 2009-07-30 | FTUK | Futures | 3019.0 | 3065.8 | 3007.7 | 3057.5 | 93342.0 |
| 2009-07-30 | G | Futures | 74.17 | 74.53 | 74.12 | 74.41 | 59103.0 |
| 2009-07-30 | GF | Futures | 281.832 | 282.383 | 279.558 | 281.487 | 1473.0 |
| 2009-07-30 | GSCI | Futures | 908.86 | 937.06 | 904.99 | 937.06 | 594.0 |
| 2009-07-30 | HE | Futures | 80.825 | 81.293 | 78.234 | 78.63 | 6452.0 |
| 2009-07-30 | HG | Futures | 3.4815 | 3.6156 | 3.4569 | 3.6002 | 24339.0 |
| 2009-07-30 | HO | Futures | 1.7058 | 1.816 | 1.7033 | 1.8115 | 48168.0 |
| 2009-07-30 | HRC | Futures | 2434.4 | 2434.4 | 2434.4 | 2434.4 | 0.0 |
| 2009-07-30 | J1 | Futures | 0.0132513 | 0.0132803 | 0.013133 | 0.0131708 | 90811.0 |
| 2009-07-30 | J7 | Futures | 0.013085 | 0.013086 | 0.012957 | 0.012989 | 187.0 |
| 2009-07-30 | JB | Futures | 116.57 | 116.7 | 116.5 | 116.57 | 2359.0 |
| 2009-07-30 | KC | Futures | 334.83 | 341.62 | 334.02 | 339.04 | 7998.0 |
| 2009-07-30 | KE | Futures | 2622.41 | 2690.76 | 2622.41 | 2635.6 | 7507.0 |
| 2009-07-30 | L | Futures | 97.386 | 97.426 | 97.386 | 97.416 | 27781.0 |
| 2009-07-30 | LBS | Futures | 827.3 | 831.4 | 790.4 | 800.1 | 1421.0 |
> showing 50 of 86 rows — these rows as CSV