PREVIEW / futures_daily / 2009-09-22
file: by_date/futures_daily/2009/2009-09-22.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-09-22 | ES | Futures | 1022.41 | 1031.33 | 1021.92 | 1029.4 | 1414027.0 |
| 2009-09-22 | NQ | Futures | 1950.07 | 1965.59 | 1947.82 | 1957.69 | 226574.0 |
| 2009-09-22 | YM | Futures | 8822.6 | 8889.8 | 8815.4 | 8870.8 | 106605.0 |
| 2009-09-22 | CL | Futures | 172.78 | 178.38 | 172.71 | 177.71 | 218292.0 |
| 2009-09-22 | GC | Futures | 1389.3 | 1412.2 | 1388.2 | 1403.9 | 96174.0 |
| 2009-09-22 | ZN | Futures | 93.143473 | 93.417462 | 92.931755 | 93.280468 | 667814.0 |
| 2009-09-22 | A6 | Futures | 0.69281 | 0.70332 | 0.69257 | 0.70081 | 60469.0 |
| 2009-09-22 | AD | Futures | 0.91462 | 0.92517 | 0.91393 | 0.92271 | 51319.0 |
| 2009-09-22 | B | Futures | 64.99 | 66.79 | 64.97 | 66.58 | 104031.0 |
| 2009-09-22 | B6 | Futures | 1.6859 | 1.7059 | 1.6859 | 1.7012 | 94457.0 |
| 2009-09-22 | BFX | Futures | 2831.1 | 2843.1 | 2804.5 | 2809.7 | 167.0 |
| 2009-09-22 | BR | Futures | 0.21812 | 0.21832 | 0.21794 | 0.21794 | 10.0 |
| 2009-09-22 | BZ | Futures | 68.55 | 69.3 | 68.55 | 69.3 | 6.0 |
| 2009-09-22 | C | Futures | 2087.0 | 2120.0 | 2080.0 | 2115.0 | 6312.0 |
| 2009-09-22 | CC | Futures | 2716.0 | 2786.0 | 2712.0 | 2782.0 | 7121.0 |
| 2009-09-22 | CT | Futures | 53.69 | 55.28 | 53.59 | 55.19 | 120.0 |
| 2009-09-22 | DC | Futures | 24.34 | 24.85 | 23.99 | 24.22 | 360.0 |
| 2009-09-22 | DX | Futures | 78.568 | 78.568 | 77.817 | 77.95 | 5864.0 |
| 2009-09-22 | E1 | Futures | 1.28048 | 1.29395 | 1.28008 | 1.29078 | 32923.0 |
| 2009-09-22 | E6 | Futures | 1.73979 | 1.75662 | 1.7392 | 1.75283 | 181689.0 |
| 2009-09-22 | E7 | Futures | 1.7215 | 1.7397 | 1.7215 | 1.736 | 1942.0 |
| 2009-09-22 | ED | Futures | 94.1103 | 94.134 | 94.1009 | 94.1198 | 155773.0 |
| 2009-09-22 | ER | Futures | 97.144 | 97.184 | 97.135 | 97.174 | 105629.0 |
| 2009-09-22 | EW | Futures | 675.8 | 682.6 | 675.1 | 680.2 | 27249.0 |
| 2009-09-22 | FCE | Futures | 2528.9 | 2546.4 | 2516.4 | 2523.0 | 99631.0 |
| 2009-09-22 | FDAX | Futures | 6205.9 | 6260.3 | 6192.9 | 6210.8 | 116128.0 |
| 2009-09-22 | FESX | Futures | 1716.7 | 1729.2 | 1709.5 | 1713.7 | 802920.0 |
| 2009-09-22 | FEU3 | Futures | 97.722 | 97.746 | 97.722 | 97.746 | 365.0 |
| 2009-09-22 | FGBL | Futures | 92.57 | 92.77 | 92.36 | 92.66 | 766150.0 |
| 2009-09-22 | FGBM | Futures | 98.51 | 98.63 | 98.38 | 98.58 | 374256.0 |
| 2009-09-22 | FGBS | Futures | 104.619 | 104.658 | 104.561 | 104.653 | 448558.0 |
| 2009-09-22 | FGBX | Futures | 84.81 | 85.27 | 84.35 | 85.04 | 2478.0 |
| 2009-09-22 | FTDX | Futures | 678.5 | 687.9 | 678.5 | 684.8 | 597.0 |
| 2009-09-22 | FTI | Futures | 257.37 | 259.14 | 256.92 | 257.45 | 21288.0 |
| 2009-09-22 | FTUK | Futures | 3399.3 | 3422.2 | 3386.4 | 3395.3 | 98434.0 |
| 2009-09-22 | G | Futures | 75.82 | 75.88 | 75.56 | 75.77 | 78765.0 |
| 2009-09-22 | GF | Futures | 266.052 | 267.291 | 265.295 | 266.672 | 1777.0 |
| 2009-09-22 | GSCI | Futures | 928.56 | 934.56 | 924.16 | 934.56 | 632.0 |
| 2009-09-22 | HE | Futures | 75.306 | 76.068 | 73.972 | 74.315 | 12186.0 |
| 2009-09-22 | HG | Futures | 3.9179 | 4.0301 | 3.9019 | 3.9917 | 18401.0 |
| 2009-09-22 | HO | Futures | 1.7642 | 1.824 | 1.7642 | 1.8172 | 8811.0 |
| 2009-09-22 | HRC | Futures | 2738.7 | 2738.7 | 2738.7 | 2738.7 | 0.0 |
| 2009-09-22 | J1 | Futures | 0.013663 | 0.0138174 | 0.0136454 | 0.0137685 | 73439.0 |
| 2009-09-22 | J7 | Futures | 0.013471 | 0.013635 | 0.013471 | 0.013589 | 58.0 |
| 2009-09-22 | KC | Futures | 359.0 | 364.94 | 356.62 | 364.41 | 10187.0 |
| 2009-09-22 | KE | Futures | 2183.44 | 2219.5 | 2165.99 | 2178.79 | 7157.0 |
| 2009-09-22 | L | Futures | 97.858 | 97.878 | 97.858 | 97.868 | 38236.0 |
| 2009-09-22 | LBS | Futures | 721.0 | 721.4 | 705.1 | 716.5 | 755.0 |
| 2009-09-22 | LE | Futures | 141.456 | 141.917 | 141.08 | 141.205 | 18219.0 |
| 2009-09-22 | MFS | Futures | 1268.5 | 1268.5 | 1260.7 | 1266.4 | 485.0 |
> showing 50 of 86 rows — these rows as CSV