PREVIEW / futures_daily / 2011-01-25
file: by_date/futures_daily/2011/2011-01-25.parquet size: 9 KB rows: 93
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-25 | ES | Futures | 1268.3 | 1271.5 | 1256.98 | 1267.32 | 2360267.0 |
| 2011-01-25 | NQ | Futures | 2608.93 | 2614.89 | 2589.91 | 2612.62 | 250703.0 |
| 2011-01-25 | YM | Futures | 11162.8 | 11185.3 | 11091.7 | 11158.1 | 133455.0 |
| 2011-01-25 | CL | Futures | 178.41 | 178.72 | 175.2 | 175.34 | 338646.0 |
| 2011-01-25 | GC | Futures | 1813.0 | 1818.7 | 1796.8 | 1810.9 | 227628.0 |
| 2011-01-25 | ZN | Futures | 100.036594 | 100.699519 | 99.919608 | 100.595531 | 1286403.0 |
| 2011-01-25 | A6 | Futures | 0.84046 | 0.84249 | 0.83359 | 0.83672 | 121151.0 |
| 2011-01-25 | AD | Futures | 0.99771 | 1.00019 | 0.98997 | 0.99185 | 77618.0 |
| 2011-01-25 | B | Futures | 82.14 | 82.41 | 80.83 | 81.18 | 123792.0 |
| 2011-01-25 | B6 | Futures | 1.6572 | 1.6611 | 1.6333 | 1.6376 | 204006.0 |
| 2011-01-25 | BFX | Futures | 3095.7 | 3095.7 | 3059.2 | 3059.2 | 94.0 |
| 2011-01-25 | BR | Futures | 0.25577 | 0.25577 | 0.25554 | 0.25558 | 23.0 |
| 2011-01-25 | BZ | Futures | 86.67 | 86.74 | 86.67 | 86.74 | 552.0 |
| 2011-01-25 | C | Futures | 2419.0 | 2438.0 | 2389.0 | 2433.0 | 8372.0 |
| 2011-01-25 | CB | Futures | 117.922 | 119.095 | 117.922 | 118.215 | 39.0 |
| 2011-01-25 | CC | Futures | 2705.0 | 2739.0 | 2654.0 | 2706.0 | 14286.0 |
| 2011-01-25 | CT | Futures | 140.49 | 143.97 | 135.49 | 138.77 | 21400.0 |
| 2011-01-25 | DC | Futures | 28.05 | 28.64 | 27.7 | 27.9 | 1311.0 |
| 2011-01-25 | DX | Futures | 78.014 | 78.429 | 77.81 | 78.004 | 21541.0 |
| 2011-01-25 | E1 | Futures | 1.38138 | 1.39436 | 1.37692 | 1.39161 | 44668.0 |
| 2011-01-25 | E6 | Futures | 1.61273 | 1.6203 | 1.60492 | 1.61639 | 393954.0 |
| 2011-01-25 | E7 | Futures | 1.602 | 1.6081 | 1.5931 | 1.6044 | 7602.0 |
| 2011-01-25 | EBM | Futures | 236.03 | 238.76 | 230.81 | 238.3 | 8794.0 |
| 2011-01-25 | ED | Futures | 94.8384 | 94.8432 | 94.8289 | 94.8337 | 284827.0 |
| 2011-01-25 | ER | Futures | 97.281 | 97.296 | 97.247 | 97.262 | 261970.0 |
| 2011-01-25 | EW | Futures | 906.0 | 908.9 | 899.5 | 908.4 | 24363.0 |
| 2011-01-25 | FBTP | Futures | 64.15 | 64.24 | 63.94 | 64.0 | 6926.0 |
| 2011-01-25 | FCE | Futures | 2705.1 | 2709.5 | 2682.1 | 2685.8 | 116389.0 |
| 2011-01-25 | FDAX | Futures | 7605.2 | 7617.5 | 7553.3 | 7564.0 | 139327.0 |
| 2011-01-25 | FESX | Futures | 1858.2 | 1863.2 | 1834.0 | 1835.9 | 1117866.0 |
| 2011-01-25 | FEU3 | Futures | 97.81 | 97.82 | 97.81 | 97.82 | 5.0 |
| 2011-01-25 | FGBL | Futures | 98.02 | 98.47 | 97.97 | 98.18 | 866756.0 |
| 2011-01-25 | FGBM | Futures | 103.6 | 103.88 | 103.56 | 103.69 | 667428.0 |
| 2011-01-25 | FGBS | Futures | 106.833 | 106.927 | 106.808 | 106.848 | 646148.0 |
| 2011-01-25 | FGBX | Futures | 95.98 | 96.61 | 95.76 | 95.85 | 5697.0 |
| 2011-01-25 | FTDX | Futures | 760.5 | 761.3 | 755.2 | 758.3 | 508.0 |
| 2011-01-25 | FTI | Futures | 291.24 | 291.77 | 287.98 | 288.62 | 29874.0 |
| 2011-01-25 | FTUK | Futures | 4117.9 | 4122.1 | 4074.9 | 4087.0 | 98574.0 |
| 2011-01-25 | FXXP | Futures | 182.3 | 182.6 | 181.1 | 181.4 | 3689.0 |
| 2011-01-25 | G | Futures | 80.44 | 81.2 | 80.43 | 80.77 | 143780.0 |
| 2011-01-25 | GF | Futures | 309.143 | 310.129 | 307.169 | 308.649 | 2314.0 |
| 2011-01-25 | GSCI | Futures | 1007.99 | 1007.99 | 992.54 | 992.86 | 190.0 |
| 2011-01-25 | HE | Futures | 100.697 | 102.272 | 100.551 | 101.659 | 21184.0 |
| 2011-01-25 | HG | Futures | 5.7887 | 5.8007 | 5.6081 | 5.6321 | 41864.0 |
| 2011-01-25 | HO | Futures | 2.1905 | 2.1974 | 2.1545 | 2.1715 | 56053.0 |
| 2011-01-25 | HRC | Futures | 2727.0 | 2727.0 | 2727.0 | 2727.0 | 0.0 |
| 2011-01-25 | J1 | Futures | 0.0152202 | 0.0153256 | 0.0151963 | 0.015288 | 136534.0 |
| 2011-01-25 | J7 | Futures | 0.015114 | 0.015217 | 0.015089 | 0.015179 | 327.0 |
| 2011-01-25 | JB | Futures | 120.57 | 120.72 | 120.43 | 120.53 | 1376.0 |
| 2011-01-25 | KC | Futures | 581.93 | 584.38 | 564.76 | 567.09 | 14620.0 |
> showing 50 of 93 rows — these rows as CSV