PREVIEW / futures_daily / 2009-04-06
file: by_date/futures_daily/2009/2009-04-06.parquet size: 8 KB rows: 85
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-04-06 | ES | Futures | 800.6 | 808.22 | 780.34 | 791.54 | 1996010.0 |
| 2009-04-06 | NQ | Futures | 1477.98 | 1491.46 | 1444.27 | 1474.05 | 253879.0 |
| 2009-04-06 | YM | Futures | 7157.1 | 7229.7 | 7000.1 | 7100.5 | 143565.0 |
| 2009-04-06 | CL | Futures | 147.1 | 150.47 | 139.83 | 143.31 | 228983.0 |
| 2009-04-06 | GC | Futures | 1243.4 | 1245.5 | 1197.7 | 1208.5 | 123648.0 |
| 2009-04-06 | ZN | Futures | 94.876345 | 95.106951 | 94.621464 | 94.645738 | 474417.0 |
| 2009-04-06 | A6 | Futures | 0.56871 | 0.57245 | 0.56217 | 0.56488 | 36641.0 |
| 2009-04-06 | AD | Futures | 0.80094 | 0.80577 | 0.79169 | 0.79405 | 38387.0 |
| 2009-04-06 | B | Futures | 52.91 | 53.6 | 50.66 | 51.68 | 78381.0 |
| 2009-04-06 | B6 | Futures | 1.5446 | 1.5568 | 1.5265 | 1.5322 | 69418.0 |
| 2009-04-06 | BFX | Futures | 1992.8 | 2014.9 | 1963.1 | 1966.6 | 101.0 |
| 2009-04-06 | BZ | Futures | 54.59 | 54.59 | 53.67 | 54.55 | 3.0 |
| 2009-04-06 | C | Futures | 2015.0 | 2016.0 | 1839.0 | 1847.0 | 9842.0 |
| 2009-04-06 | CC | Futures | 2452.0 | 2462.0 | 2241.0 | 2257.0 | 8538.0 |
| 2009-04-06 | CT | Futures | 44.71 | 45.22 | 43.92 | 44.37 | 9321.0 |
| 2009-04-06 | DC | Futures | 29.35 | 29.54 | 28.55 | 28.67 | 170.0 |
| 2009-04-06 | DX | Futures | 86.824 | 87.802 | 86.603 | 87.607 | 4123.0 |
| 2009-04-06 | E1 | Futures | 1.17544 | 1.18114 | 1.1639 | 1.16748 | 29006.0 |
| 2009-04-06 | E6 | Futures | 1.60208 | 1.61014 | 1.58335 | 1.58821 | 143512.0 |
| 2009-04-06 | E7 | Futures | 1.5835 | 1.5913 | 1.5652 | 1.5698 | 1527.0 |
| 2009-04-06 | EBM | Futures | 213.63 | 218.27 | 212.85 | 213.24 | 3754.0 |
| 2009-04-06 | ED | Futures | 93.2142 | 93.2377 | 93.1859 | 93.2095 | 135522.0 |
| 2009-04-06 | ER | Futures | 96.606 | 96.679 | 96.581 | 96.65 | 118176.0 |
| 2009-04-06 | EW | Futures | 507.4 | 513.1 | 490.9 | 498.4 | 25266.0 |
| 2009-04-06 | FCE | Futures | 1902.1 | 1915.8 | 1842.8 | 1857.7 | 127587.0 |
| 2009-04-06 | FDAX | Futures | 4855.8 | 4870.0 | 4698.4 | 4726.7 | 140358.0 |
| 2009-04-06 | FESX | Futures | 1293.1 | 1302.1 | 1249.9 | 1257.1 | 1184684.0 |
| 2009-04-06 | FEU3 | Futures | 97.204 | 97.249 | 97.195 | 97.229 | 200.0 |
| 2009-04-06 | FGBL | Futures | 91.91 | 92.37 | 91.9 | 92.25 | 520812.0 |
| 2009-04-06 | FGBM | Futures | 97.0 | 97.35 | 96.99 | 97.29 | 318980.0 |
| 2009-04-06 | FGBS | Futures | 103.296 | 103.435 | 103.282 | 103.411 | 324965.0 |
| 2009-04-06 | FGBX | Futures | 82.0 | 82.34 | 81.84 | 82.1 | 1253.0 |
| 2009-04-06 | FTDX | Futures | 456.9 | 470.3 | 455.1 | 459.5 | 592.0 |
| 2009-04-06 | FTI | Futures | 192.26 | 193.5 | 186.21 | 187.61 | 34565.0 |
| 2009-04-06 | FTUK | Futures | 2693.4 | 2699.4 | 2605.5 | 2621.1 | 93677.0 |
| 2009-04-06 | G | Futures | 76.66 | 77.0 | 76.39 | 76.65 | 72825.0 |
| 2009-04-06 | GF | Futures | 265.834 | 268.835 | 265.694 | 267.928 | 312.0 |
| 2009-04-06 | GSCI | Futures | 793.19 | 802.55 | 774.05 | 785.32 | 583.0 |
| 2009-04-06 | HE | Futures | 121.462 | 121.462 | 118.285 | 119.977 | 188.0 |
| 2009-04-06 | HG | Futures | 2.8036 | 2.8698 | 2.7233 | 2.7599 | 16693.0 |
| 2009-04-06 | HO | Futures | 1.5983 | 1.6264 | 1.5376 | 1.5728 | 12362.0 |
| 2009-04-06 | HRC | Futures | 2624.9 | 2624.9 | 2624.9 | 2624.9 | 0.0 |
| 2009-04-06 | J1 | Futures | 0.0125724 | 0.01259 | 0.012435 | 0.012498 | 61168.0 |
| 2009-04-06 | J7 | Futures | 0.012389 | 0.012408 | 0.012255 | 0.012328 | 62.0 |
| 2009-04-06 | JB | Futures | 114.9 | 115.02 | 114.52 | 114.56 | 1112.0 |
| 2009-04-06 | KC | Futures | 334.74 | 335.59 | 327.43 | 330.52 | 6631.0 |
| 2009-04-06 | KE | Futures | 2987.6 | 3045.53 | 2962.95 | 2972.81 | 7163.0 |
| 2009-04-06 | L | Futures | 96.846 | 96.905 | 96.826 | 96.895 | 48015.0 |
| 2009-04-06 | LBS | Futures | 969.1 | 969.1 | 948.9 | 962.3 | 110.0 |
| 2009-04-06 | LE | Futures | 148.879 | 149.365 | 147.73 | 149.144 | 7487.0 |
> showing 50 of 85 rows — these rows as CSV