PREVIEW / futures_daily / 2009-01-30
file: by_date/futures_daily/2009/2009-01-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-01-30 | ES | Futures | 796.04 | 801.7 | 771.96 | 776.68 | 2467501.0 |
| 2009-01-30 | NQ | Futures | 1349.97 | 1357.52 | 1312.24 | 1318.39 | 298960.0 |
| 2009-01-30 | YM | Futures | 7228.2 | 7268.3 | 7042.1 | 7083.1 | 192790.0 |
| 2009-01-30 | CL | Futures | 138.36 | 144.31 | 136.27 | 138.46 | 237726.0 |
| 2009-01-30 | GC | Futures | 1264.2 | 1292.4 | 1253.2 | 1288.4 | 129072.0 |
| 2009-01-30 | ZN | Futures | 93.734189 | 94.535029 | 93.674424 | 93.841764 | 556565.0 |
| 2009-01-30 | A6 | Futures | 0.51544 | 0.51544 | 0.50172 | 0.50251 | 30041.0 |
| 2009-01-30 | AD | Futures | 0.80124 | 0.80429 | 0.78837 | 0.79908 | 29549.0 |
| 2009-01-30 | B | Futures | 47.58 | 49.69 | 47.05 | 47.83 | 65751.0 |
| 2009-01-30 | B6 | Futures | 1.4834 | 1.5103 | 1.4727 | 1.5007 | 84534.0 |
| 2009-01-30 | BFX | Futures | 2084.7 | 2109.1 | 2069.9 | 2090.2 | 1310.0 |
| 2009-01-30 | BZ | Futures | 49.96 | 50.18 | 49.16 | 49.16 | 28.0 |
| 2009-01-30 | C | Futures | 2001.0 | 2001.0 | 1968.0 | 1986.0 | 5561.0 |
| 2009-01-30 | CB | Futures | 76.342 | 76.342 | 75.846 | 75.846 | 5.0 |
| 2009-01-30 | CC | Futures | 2466.0 | 2469.0 | 2409.0 | 2445.0 | 5491.0 |
| 2009-01-30 | CT | Futures | 48.67 | 48.96 | 48.06 | 48.09 | 10630.0 |
| 2009-01-30 | DC | Futures | 28.28 | 28.58 | 27.59 | 27.72 | 248.0 |
| 2009-01-30 | DX | Futures | 89.285 | 89.829 | 89.093 | 89.653 | 4733.0 |
| 2009-01-30 | E1 | Futures | 1.15211 | 1.15451 | 1.14042 | 1.14401 | 30426.0 |
| 2009-01-30 | E6 | Futures | 1.5309 | 1.53126 | 1.51054 | 1.5135 | 197969.0 |
| 2009-01-30 | E7 | Futures | 1.517 | 1.517 | 1.494 | 1.4962 | 2946.0 |
| 2009-01-30 | EBM | Futures | 228.56 | 232.39 | 228.56 | 231.62 | 2281.0 |
| 2009-01-30 | ED | Futures | 93.1614 | 93.1943 | 93.0012 | 93.0154 | 314242.0 |
| 2009-01-30 | ER | Futures | 96.248 | 96.292 | 96.233 | 96.253 | 112812.0 |
| 2009-01-30 | EW | Futures | 502.8 | 504.9 | 482.0 | 486.0 | 41240.0 |
| 2009-01-30 | FCE | Futures | 1854.2 | 1873.4 | 1819.6 | 1836.6 | 162666.0 |
| 2009-01-30 | FDAX | Futures | 4831.8 | 4870.6 | 4709.5 | 4739.0 | 186572.0 |
| 2009-01-30 | FESX | Futures | 1298.4 | 1311.6 | 1273.2 | 1280.6 | 1493188.0 |
| 2009-01-30 | FEU3 | Futures | 96.835 | 96.854 | 96.815 | 96.815 | 1248.0 |
| 2009-01-30 | FGBL | Futures | 91.48 | 91.84 | 91.23 | 91.41 | 679449.0 |
| 2009-01-30 | FGBM | Futures | 96.83 | 97.14 | 96.74 | 97.0 | 384651.0 |
| 2009-01-30 | FGBS | Futures | 103.349 | 103.484 | 103.306 | 103.445 | 423208.0 |
| 2009-01-30 | FGBX | Futures | 84.38 | 84.77 | 83.08 | 83.68 | 3067.0 |
| 2009-01-30 | FTDX | Futures | 431.4 | 435.8 | 426.9 | 431.4 | 356.0 |
| 2009-01-30 | FTI | Futures | 201.77 | 203.75 | 198.34 | 199.91 | 42307.0 |
| 2009-01-30 | FTUK | Futures | 2723.0 | 2747.6 | 2671.5 | 2690.8 | 144799.0 |
| 2009-01-30 | G | Futures | 73.32 | 73.69 | 73.16 | 73.46 | 68153.0 |
| 2009-01-30 | GF | Futures | 253.052 | 257.119 | 253.052 | 255.296 | 521.0 |
| 2009-01-30 | GSCI | Futures | 803.98 | 807.73 | 786.86 | 792.37 | 730.0 |
| 2009-01-30 | HE | Futures | 117.967 | 122.268 | 117.339 | 121.736 | 5366.0 |
| 2009-01-30 | HG | Futures | 2.0577 | 2.076 | 1.9796 | 2.0669 | 13329.0 |
| 2009-01-30 | HO | Futures | 1.5799 | 1.6426 | 1.5718 | 1.5971 | 36088.0 |
| 2009-01-30 | HRC | Futures | 3041.9 | 3041.9 | 3041.9 | 3041.9 | 0.0 |
| 2009-01-30 | J1 | Futures | 0.0140435 | 0.0141786 | 0.0140296 | 0.0140687 | 71717.0 |
| 2009-01-30 | J7 | Futures | 0.013875 | 0.014006 | 0.013866 | 0.0139 | 33.0 |
| 2009-01-30 | JB | Futures | 116.38 | 116.49 | 116.2 | 116.29 | 970.0 |
| 2009-01-30 | KC | Futures | 346.68 | 348.25 | 336.96 | 339.82 | 10743.0 |
| 2009-01-30 | KE | Futures | 3047.87 | 3074.1 | 2991.66 | 3002.9 | 5011.0 |
| 2009-01-30 | L | Futures | 96.871 | 96.91 | 96.837 | 96.841 | 42921.0 |
| 2009-01-30 | LBS | Futures | 794.3 | 830.7 | 794.3 | 830.7 | 129.0 |
> showing 50 of 86 rows — these rows as CSV