PREVIEW / futures_daily / 2010-01-08
file: by_date/futures_daily/2010/2010-01-08.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 |
|---|---|---|---|---|---|---|---|
| 2010-01-08 | ES | Futures | 1102.39 | 1106.75 | 1096.33 | 1106.51 | 1527666.0 |
| 2010-01-08 | NQ | Futures | 2123.54 | 2140.51 | 2109.4 | 2137.68 | 268934.0 |
| 2010-01-08 | YM | Futures | 9634.9 | 9663.3 | 9587.4 | 9651.4 | 79925.0 |
| 2010-01-08 | CL | Futures | 196.0 | 197.95 | 193.99 | 196.24 | 310377.0 |
| 2010-01-08 | GC | Futures | 1557.4 | 1569.1 | 1540.9 | 1567.6 | 212621.0 |
| 2010-01-08 | ZN | Futures | 93.333231 | 93.748829 | 93.16951 | 93.522139 | 998453.0 |
| 2010-01-08 | A6 | Futures | 0.74013 | 0.74696 | 0.73639 | 0.7459 | 82078.0 |
| 2010-01-08 | AD | Futures | 0.95418 | 0.96011 | 0.95053 | 0.95675 | 80679.0 |
| 2010-01-08 | B | Futures | 74.36 | 74.86 | 73.5 | 74.31 | 130809.0 |
| 2010-01-08 | B6 | Futures | 1.6539 | 1.6727 | 1.6523 | 1.6646 | 122147.0 |
| 2010-01-08 | BFX | Futures | 2950.0 | 2961.3 | 2935.4 | 2935.4 | 132.0 |
| 2010-01-08 | BR | Futures | 0.23144 | 0.23144 | 0.23144 | 0.23144 | 90.0 |
| 2010-01-08 | C | Futures | 2306.0 | 2318.0 | 2296.0 | 2303.0 | 5499.0 |
| 2010-01-08 | CB | Futures | 71.186 | 71.31 | 71.186 | 71.31 | 15.0 |
| 2010-01-08 | CC | Futures | 2819.0 | 2857.0 | 2819.0 | 2832.0 | 3975.0 |
| 2010-01-08 | CT | Futures | 59.47 | 59.84 | 59.05 | 59.06 | 8319.0 |
| 2010-01-08 | DC | Futures | 23.42 | 23.55 | 23.32 | 23.42 | 163.0 |
| 2010-01-08 | DX | Futures | 79.525 | 79.764 | 78.859 | 78.971 | 23272.0 |
| 2010-01-08 | E1 | Futures | 1.27482 | 1.29144 | 1.27007 | 1.2884 | 80000.0 |
| 2010-01-08 | E6 | Futures | 1.69363 | 1.70925 | 1.6883 | 1.70653 | 348468.0 |
| 2010-01-08 | E7 | Futures | 1.6813 | 1.6971 | 1.6766 | 1.6947 | 4631.0 |
| 2010-01-08 | EBM | Futures | 225.62 | 226.89 | 225.62 | 226.47 | 2501.0 |
| 2010-01-08 | ED | Futures | 94.3583 | 94.3725 | 94.3441 | 94.3678 | 208112.0 |
| 2010-01-08 | ER | Futures | 97.281 | 97.296 | 97.272 | 97.291 | 111861.0 |
| 2010-01-08 | EW | Futures | 725.1 | 729.9 | 720.0 | 729.4 | 20709.0 |
| 2010-01-08 | FBTP | Futures | 63.01 | 63.3 | 62.97 | 63.17 | 3028.0 |
| 2010-01-08 | FCE | Futures | 2643.2 | 2653.4 | 2621.3 | 2642.9 | 96280.0 |
| 2010-01-08 | FDAX | Futures | 6619.7 | 6622.9 | 6527.4 | 6603.8 | 135006.0 |
| 2010-01-08 | FESX | Futures | 1809.5 | 1813.1 | 1791.0 | 1806.5 | 1003071.0 |
| 2010-01-08 | FEU3 | Futures | 97.85 | 97.855 | 97.84 | 97.855 | 290.0 |
| 2010-01-08 | FGBL | Futures | 93.51 | 93.95 | 93.44 | 93.61 | 823864.0 |
| 2010-01-08 | FGBM | Futures | 99.53 | 99.84 | 99.49 | 99.65 | 424449.0 |
| 2010-01-08 | FGBS | Futures | 105.226 | 105.352 | 105.201 | 105.309 | 494637.0 |
| 2010-01-08 | FGBX | Futures | 86.36 | 87.36 | 86.36 | 86.93 | 4656.0 |
| 2010-01-08 | FTDX | Futures | 760.6 | 764.1 | 756.2 | 760.6 | 524.0 |
| 2010-01-08 | FTI | Futures | 279.03 | 280.05 | 275.77 | 278.99 | 31780.0 |
| 2010-01-08 | FTUK | Futures | 3678.4 | 3688.4 | 3650.9 | 3677.0 | 81854.0 |
| 2010-01-08 | G | Futures | 74.86 | 75.11 | 74.67 | 74.86 | 65890.0 |
| 2010-01-08 | GF | Futures | 261.069 | 261.883 | 259.713 | 261.34 | 589.0 |
| 2010-01-08 | GSCI | Futures | 1027.54 | 1031.9 | 1020.91 | 1028.39 | 3914.0 |
| 2010-01-08 | HE | Futures | 90.223 | 90.858 | 89.553 | 89.988 | 18687.0 |
| 2010-01-08 | HG | Futures | 4.7374 | 4.7567 | 4.6787 | 4.6911 | 26080.0 |
| 2010-01-08 | HO | Futures | 2.0435 | 2.0615 | 2.0192 | 2.0544 | 22180.0 |
| 2010-01-08 | HRC | Futures | 2681.4 | 2681.4 | 2681.4 | 2681.4 | 0.0 |
| 2010-01-08 | J1 | Futures | 0.0134527 | 0.0136452 | 0.0134388 | 0.0135924 | 137669.0 |
| 2010-01-08 | J7 | Futures | 0.0133 | 0.013473 | 0.013274 | 0.013422 | 119.0 |
| 2010-01-08 | JB | Futures | 117.16 | 117.17 | 116.99 | 117.1 | 2647.0 |
| 2010-01-08 | KC | Futures | 370.79 | 380.03 | 369.49 | 378.34 | 15490.0 |
| 2010-01-08 | KE | Futures | 2488.47 | 2541.61 | 2445.5 | 2532.56 | 7985.0 |
| 2010-01-08 | L | Futures | 97.819 | 97.838 | 97.809 | 97.829 | 44595.0 |
> showing 50 of 89 rows — these rows as CSV