PREVIEW / futures_daily / 2010-07-08
file: by_date/futures_daily/2010/2010-07-08.parquet size: 9 KB rows: 90
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-07-08 | ES | Futures | 1032.66 | 1042.16 | 1028.02 | 1040.7 | 2112208.0 |
| 2010-07-08 | NQ | Futures | 2024.27 | 2040.96 | 2008.42 | 2035.02 | 310109.0 |
| 2010-07-08 | YM | Futures | 9223.7 | 9339.3 | 9200.6 | 9331.0 | 143415.0 |
| 2010-07-08 | CL | Futures | 159.86 | 162.32 | 158.86 | 161.12 | 325813.0 |
| 2010-07-08 | GC | Futures | 1640.8 | 1648.1 | 1619.6 | 1631.6 | 123075.0 |
| 2010-07-08 | ZN | Futures | 100.285884 | 100.375528 | 99.850471 | 100.119402 | 1133187.0 |
| 2010-07-08 | A6 | Futures | 0.70982 | 0.72317 | 0.70933 | 0.71927 | 110057.0 |
| 2010-07-08 | AD | Futures | 0.94224 | 0.95113 | 0.94145 | 0.945 | 81467.0 |
| 2010-07-08 | B | Futures | 65.09 | 66.06 | 64.7 | 65.59 | 107478.0 |
| 2010-07-08 | B6 | Futures | 1.5755 | 1.5824 | 1.567 | 1.5725 | 92809.0 |
| 2010-07-08 | BFX | Futures | 2790.1 | 2804.9 | 2783.0 | 2799.9 | 143.0 |
| 2010-07-08 | BZ | Futures | 69.48 | 70.09 | 69.48 | 70.09 | 198.0 |
| 2010-07-08 | C | Futures | 2614.0 | 2620.0 | 2572.0 | 2584.0 | 13513.0 |
| 2010-07-08 | CB | Futures | 83.294 | 83.536 | 83.053 | 83.053 | 14.0 |
| 2010-07-08 | CC | Futures | 2476.0 | 2500.0 | 2466.0 | 2476.0 | 4198.0 |
| 2010-07-08 | CSC | Futures | 3.751 | 3.758 | 3.748 | 3.758 | 8.0 |
| 2010-07-08 | CT | Futures | 65.29 | 65.87 | 64.83 | 65.02 | 64.0 |
| 2010-07-08 | DC | Futures | 23.03 | 23.06 | 22.89 | 23.06 | 172.0 |
| 2010-07-08 | DX | Futures | 84.862 | 84.912 | 84.544 | 84.701 | 17824.0 |
| 2010-07-08 | E1 | Futures | 1.24976 | 1.25462 | 1.24464 | 1.25291 | 31585.0 |
| 2010-07-08 | E6 | Futures | 1.49408 | 1.50472 | 1.49254 | 1.4994 | 249254.0 |
| 2010-07-08 | E7 | Futures | 1.4837 | 1.4935 | 1.4818 | 1.4886 | 3262.0 |
| 2010-07-08 | ED | Futures | 94.347 | 94.385 | 94.3423 | 94.3755 | 206958.0 |
| 2010-07-08 | ER | Futures | 97.222 | 97.227 | 97.164 | 97.193 | 252124.0 |
| 2010-07-08 | EW | Futures | 710.5 | 718.6 | 706.6 | 715.7 | 25605.0 |
| 2010-07-08 | FBTP | Futures | 64.88 | 65.1 | 64.86 | 65.03 | 3910.0 |
| 2010-07-08 | FCE | Futures | 2315.5 | 2348.7 | 2305.3 | 2326.0 | 133975.0 |
| 2010-07-08 | FDAX | Futures | 6577.4 | 6613.3 | 6538.7 | 6565.9 | 119124.0 |
| 2010-07-08 | FESX | Futures | 1642.7 | 1666.8 | 1633.4 | 1645.2 | 1359163.0 |
| 2010-07-08 | FEU3 | Futures | 97.78 | 97.78 | 97.731 | 97.751 | 670.0 |
| 2010-07-08 | FGBL | Futures | 100.83 | 101.03 | 100.49 | 100.7 | 786337.0 |
| 2010-07-08 | FGBM | Futures | 105.23 | 105.33 | 104.96 | 105.11 | 474032.0 |
| 2010-07-08 | FGBS | Futures | 107.451 | 107.48 | 107.343 | 107.387 | 435252.0 |
| 2010-07-08 | FGBX | Futures | 100.62 | 101.0 | 100.16 | 100.43 | 2634.0 |
| 2010-07-08 | FTDX | Futures | 672.5 | 679.2 | 672.1 | 674.7 | 858.0 |
| 2010-07-08 | FTI | Futures | 254.34 | 257.74 | 252.24 | 255.48 | 34671.0 |
| 2010-07-08 | FTUK | Futures | 3464.9 | 3515.1 | 3461.5 | 3484.5 | 104728.0 |
| 2010-07-08 | G | Futures | 81.16 | 81.49 | 80.94 | 81.17 | 86034.0 |
| 2010-07-08 | GF | Futures | 287.476 | 287.981 | 286.213 | 286.971 | 4354.0 |
| 2010-07-08 | GSCI | Futures | 848.07 | 852.85 | 840.3 | 850.89 | 3243.0 |
| 2010-07-08 | HE | Futures | 98.13 | 98.828 | 97.736 | 98.221 | 17527.0 |
| 2010-07-08 | HG | Futures | 4.0687 | 4.0908 | 4.0058 | 4.0386 | 22756.0 |
| 2010-07-08 | HO | Futures | 1.7619 | 1.8002 | 1.7582 | 1.7784 | 19369.0 |
| 2010-07-08 | HRC | Futures | 2875.5 | 2875.5 | 2875.5 | 2875.5 | 0.0 |
| 2010-07-08 | J1 | Futures | 0.01435 | 0.0143638 | 0.0142015 | 0.014243 | 143645.0 |
| 2010-07-08 | J7 | Futures | 0.014241 | 0.014241 | 0.014097 | 0.014136 | 186.0 |
| 2010-07-08 | JB | Futures | 120.59 | 120.59 | 120.31 | 120.46 | 886.0 |
| 2010-07-08 | KC | Futures | 409.48 | 411.36 | 403.95 | 407.09 | 7220.0 |
| 2010-07-08 | KE | Futures | 2316.05 | 2402.35 | 2310.73 | 2394.89 | 19373.0 |
| 2010-07-08 | L | Futures | 98.036 | 98.056 | 98.026 | 98.036 | 30352.0 |
> showing 50 of 90 rows — these rows as CSV