PREVIEW / futures_daily / 2010-06-11
file: by_date/futures_daily/2010/2010-06-11.parquet size: 9 KB rows: 88
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-06-11 | ES | Futures | 1055.58 | 1063.62 | 1046.33 | 1060.7 | 1182031.0 |
| 2010-06-11 | NQ | Futures | 2066.09 | 2097.28 | 2050.77 | 2091.9 | 101875.0 |
| 2010-06-11 | YM | Futures | 9323.6 | 9390.1 | 9257.0 | 9373.5 | 127181.0 |
| 2010-06-11 | CL | Futures | 165.25 | 165.51 | 160.31 | 161.44 | 421739.0 |
| 2010-06-11 | GC | Futures | 1662.5 | 1681.1 | 1661.6 | 1678.1 | 80168.0 |
| 2010-06-11 | ZN | Futures | 98.211269 | 98.902807 | 98.211269 | 98.890001 | 978226.0 |
| 2010-06-11 | A6 | Futures | 0.69607 | 0.69781 | 0.69093 | 0.69582 | 85868.0 |
| 2010-06-11 | AD | Futures | 0.95715 | 0.95853 | 0.94994 | 0.95162 | 80297.0 |
| 2010-06-11 | B | Futures | 66.8 | 67.08 | 65.29 | 65.93 | 147001.0 |
| 2010-06-11 | B6 | Futures | 1.5265 | 1.5322 | 1.5053 | 1.506 | 139426.0 |
| 2010-06-11 | BR | Futures | 0.22578 | 0.22578 | 0.22578 | 0.22578 | 66.0 |
| 2010-06-11 | BZ | Futures | 71.11 | 71.11 | 71.11 | 71.11 | 28.0 |
| 2010-06-11 | C | Futures | 2475.0 | 2501.0 | 2438.0 | 2442.0 | 4921.0 |
| 2010-06-11 | CC | Futures | 2453.0 | 2519.0 | 2440.0 | 2450.0 | 9475.0 |
| 2010-06-11 | CT | Futures | 65.49 | 65.73 | 64.77 | 64.81 | 15386.0 |
| 2010-06-11 | DC | Futures | 22.4 | 22.56 | 22.09 | 22.39 | 71.0 |
| 2010-06-11 | DX | Futures | 88.082 | 88.838 | 88.031 | 88.616 | 34418.0 |
| 2010-06-11 | E1 | Futures | 1.15139 | 1.15363 | 1.13931 | 1.14391 | 50353.0 |
| 2010-06-11 | E6 | Futures | 1.43295 | 1.43839 | 1.42538 | 1.42893 | 266377.0 |
| 2010-06-11 | E7 | Futures | 1.4229 | 1.4279 | 1.4152 | 1.4186 | 4160.0 |
| 2010-06-11 | ED | Futures | 94.2569 | 94.2711 | 94.2332 | 94.2474 | 225412.0 |
| 2010-06-11 | ER | Futures | 97.38 | 97.384 | 97.365 | 97.365 | 99274.0 |
| 2010-06-11 | EW | Futures | 730.3 | 741.1 | 723.9 | 740.1 | 36860.0 |
| 2010-06-11 | FBTP | Futures | 64.53 | 64.77 | 64.53 | 64.72 | 4429.0 |
| 2010-06-11 | FCE | Futures | 2332.1 | 2365.9 | 2319.8 | 2351.3 | 136547.0 |
| 2010-06-11 | FDAX | Futures | 6601.3 | 6628.5 | 6507.2 | 6573.6 | 173815.0 |
| 2010-06-11 | FESX | Futures | 1609.9 | 1638.3 | 1604.9 | 1625.3 | 114707.0 |
| 2010-06-11 | FEU3 | Futures | 97.938 | 97.938 | 97.924 | 97.924 | 111.0 |
| 2010-06-11 | FGBL | Futures | 100.41 | 100.98 | 100.28 | 100.95 | 799418.0 |
| 2010-06-11 | FGBM | Futures | 105.12 | 105.48 | 105.07 | 105.44 | 397287.0 |
| 2010-06-11 | FGBS | Futures | 107.662 | 107.795 | 107.647 | 107.785 | 348785.0 |
| 2010-06-11 | FGBX | Futures | 99.63 | 100.59 | 99.24 | 100.46 | 2641.0 |
| 2010-06-11 | FTDX | Futures | 669.0 | 677.4 | 669.0 | 674.3 | 693.0 |
| 2010-06-11 | FTI | Futures | 259.13 | 259.33 | 254.93 | 258.1 | 669.0 |
| 2010-06-11 | FTUK | Futures | 3519.3 | 3553.0 | 3495.9 | 3527.2 | 47397.0 |
| 2010-06-11 | G | Futures | 79.65 | 80.43 | 79.65 | 80.39 | 77224.0 |
| 2010-06-11 | GF | Futures | 278.95 | 281.034 | 277.877 | 278.066 | 1534.0 |
| 2010-06-11 | GSCI | Futures | 837.57 | 848.92 | 835.78 | 841.84 | 3255.0 |
| 2010-06-11 | HE | Futures | 97.505 | 98.85 | 97.036 | 98.287 | 17279.0 |
| 2010-06-11 | HG | Futures | 3.9285 | 3.9978 | 3.8946 | 3.9435 | 41735.0 |
| 2010-06-11 | HO | Futures | 1.8175 | 1.827 | 1.7867 | 1.7977 | 13113.0 |
| 2010-06-11 | HRC | Futures | 3017.0 | 3017.0 | 3017.0 | 3017.0 | 0.0 |
| 2010-06-11 | J1 | Futures | 0.0137838 | 0.013819 | 0.0137285 | 0.0137587 | 125770.0 |
| 2010-06-11 | J7 | Futures | 0.013683 | 0.013701 | 0.013626 | 0.013655 | 167.0 |
| 2010-06-11 | JB | Futures | 119.64 | 119.64 | 119.39 | 119.48 | 1969.0 |
| 2010-06-11 | KC | Futures | 347.81 | 377.01 | 347.81 | 368.0 | 42726.0 |
| 2010-06-11 | KE | Futures | 2008.53 | 2057.43 | 1979.18 | 2030.26 | 16065.0 |
| 2010-06-11 | L | Futures | 98.026 | 98.046 | 98.007 | 98.017 | 42840.0 |
| 2010-06-11 | LBS | Futures | 645.9 | 650.3 | 631.4 | 631.4 | 360.0 |
| 2010-06-11 | LE | Futures | 143.159 | 143.648 | 141.898 | 142.02 | 15289.0 |
> showing 50 of 88 rows — these rows as CSV