PREVIEW / futures_daily / 2009-10-30
file: by_date/futures_daily/2009/2009-10-30.parquet size: 9 KB rows: 89
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-10-30 | ES | Futures | 1023.61 | 1025.06 | 992.99 | 996.36 | 3376612.0 |
| 2009-10-30 | NQ | Futures | 1926.93 | 1932.29 | 1873.88 | 1880.09 | 452709.0 |
| 2009-10-30 | YM | Futures | 8990.6 | 8997.0 | 8744.6 | 8773.6 | 287054.0 |
| 2009-10-30 | CL | Futures | 195.98 | 196.54 | 188.31 | 188.68 | 412394.0 |
| 2009-10-30 | GC | Futures | 1447.5 | 1450.5 | 1431.4 | 1438.3 | 129455.0 |
| 2009-10-30 | ZN | Futures | 93.840898 | 94.613046 | 93.778628 | 94.538322 | 1067367.0 |
| 2009-10-30 | A6 | Futures | 0.73726 | 0.73847 | 0.72263 | 0.72481 | 129845.0 |
| 2009-10-30 | AD | Futures | 0.92389 | 0.92557 | 0.9088 | 0.91324 | 107007.0 |
| 2009-10-30 | B | Futures | 73.25 | 73.38 | 70.51 | 70.6 | 61641.0 |
| 2009-10-30 | B6 | Futures | 1.7224 | 1.7246 | 1.707 | 1.7108 | 147701.0 |
| 2009-10-30 | BFX | Futures | 2785.8 | 2790.5 | 2695.2 | 2702.1 | 291.0 |
| 2009-10-30 | BR | Futures | 0.22438 | 0.22438 | 0.22438 | 0.22438 | 230.0 |
| 2009-10-30 | BZ | Futures | 76.34 | 76.34 | 75.17 | 75.17 | 261.0 |
| 2009-10-30 | C | Futures | 2227.0 | 2230.0 | 2205.0 | 2211.0 | 4583.0 |
| 2009-10-30 | CB | Futures | 75.307 | 76.652 | 75.307 | 76.652 | 23.0 |
| 2009-10-30 | CC | Futures | 2935.0 | 2937.0 | 2887.0 | 2893.0 | 10575.0 |
| 2009-10-30 | CT | Futures | 58.29 | 58.62 | 57.45 | 58.37 | 12705.0 |
| 2009-10-30 | DC | Futures | 25.16 | 25.62 | 25.16 | 25.4 | 296.0 |
| 2009-10-30 | DX | Futures | 77.669 | 78.185 | 77.567 | 78.078 | 16719.0 |
| 2009-10-30 | E1 | Futures | 1.29752 | 1.30109 | 1.28563 | 1.28893 | 77285.0 |
| 2009-10-30 | E6 | Futures | 1.75792 | 1.76077 | 1.7424 | 1.74524 | 313640.0 |
| 2009-10-30 | E7 | Futures | 1.7424 | 1.7438 | 1.7256 | 1.7285 | 3687.0 |
| 2009-10-30 | ED | Futures | 94.2285 | 94.238 | 94.219 | 94.2285 | 137089.0 |
| 2009-10-30 | ER | Futures | 97.13 | 97.144 | 97.12 | 97.139 | 88347.0 |
| 2009-10-30 | EW | Futures | 654.2 | 655.0 | 635.2 | 637.4 | 69533.0 |
| 2009-10-30 | FBTP | Futures | 62.35 | 62.71 | 62.35 | 62.67 | 3391.0 |
| 2009-10-30 | FCE | Futures | 2451.0 | 2453.7 | 2353.9 | 2371.7 | 190505.0 |
| 2009-10-30 | FDAX | Futures | 6092.3 | 6096.6 | 5856.2 | 5879.0 | 214550.0 |
| 2009-10-30 | FESX | Futures | 1682.6 | 1686.8 | 1619.9 | 1628.3 | 1813113.0 |
| 2009-10-30 | FEU3 | Futures | 97.697 | 97.712 | 97.692 | 97.712 | 794.0 |
| 2009-10-30 | FGBL | Futures | 93.4 | 94.12 | 93.4 | 93.94 | 918983.0 |
| 2009-10-30 | FGBM | Futures | 98.86 | 99.28 | 98.85 | 99.2 | 449392.0 |
| 2009-10-30 | FGBS | Futures | 104.619 | 104.769 | 104.605 | 104.745 | 497099.0 |
| 2009-10-30 | FGBX | Futures | 86.52 | 87.62 | 86.5 | 87.37 | 2243.0 |
| 2009-10-30 | FTDX | Futures | 658.9 | 662.9 | 633.1 | 644.7 | 1065.0 |
| 2009-10-30 | FTI | Futures | 253.25 | 253.45 | 245.23 | 246.74 | 48203.0 |
| 2009-10-30 | FTUK | Futures | 3389.7 | 3410.9 | 3297.5 | 3317.0 | 142755.0 |
| 2009-10-30 | G | Futures | 76.67 | 77.07 | 76.65 | 76.94 | 73487.0 |
| 2009-10-30 | GF | Futures | 260.2 | 262.47 | 259.925 | 260.819 | 1339.0 |
| 2009-10-30 | GSCI | Futures | 997.63 | 1001.37 | 974.61 | 975.0 | 755.0 |
| 2009-10-30 | HE | Futures | 86.891 | 87.539 | 85.976 | 86.434 | 13963.0 |
| 2009-10-30 | HG | Futures | 4.2273 | 4.2502 | 4.0997 | 4.1186 | 27568.0 |
| 2009-10-30 | HO | Futures | 2.0175 | 2.0229 | 1.935 | 1.9425 | 49748.0 |
| 2009-10-30 | HRC | Futures | 2713.1 | 2713.1 | 2713.1 | 2713.1 | 0.0 |
| 2009-10-30 | J1 | Futures | 0.0137295 | 0.0139681 | 0.0137145 | 0.0139543 | 121065.0 |
| 2009-10-30 | J7 | Futures | 0.013545 | 0.013782 | 0.013545 | 0.013772 | 92.0 |
| 2009-10-30 | JB | Futures | 116.45 | 116.46 | 116.25 | 116.38 | 88.0 |
| 2009-10-30 | KC | Futures | 361.51 | 365.6 | 353.32 | 357.68 | 11328.0 |
| 2009-10-30 | KE | Futures | 2368.4 | 2389.34 | 2305.58 | 2321.87 | 8344.0 |
| 2009-10-30 | L | Futures | 97.77 | 97.779 | 97.76 | 97.77 | 28611.0 |
> showing 50 of 89 rows — these rows as CSV