PREVIEW / futures_daily / 2008-02-19
file: by_date/futures_daily/2008/2008-02-19.parquet size: 7 KB rows: 56
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-19 | ES | Futures | 1251.27 | 1269.57 | 1246.86 | 1256.36 | 1718585.0 |
| 2008-02-19 | NQ | Futures | 2001.08 | 2044.02 | 1977.79 | 1999.68 | 370968.0 |
| 2008-02-19 | YM | Futures | 10967.4 | 11120.2 | 10931.0 | 11003.8 | 177170.0 |
| 2008-02-19 | CL | Futures | 409.34 | 428.16 | 407.88 | 427.52 | 281935.0 |
| 2008-02-19 | GC | Futures | 1293.9 | 1335.8 | 1291.2 | 1329.3 | 133503.0 |
| 2008-02-19 | ZN | Futures | 83.518185 | 83.630426 | 82.844742 | 83.057999 | 1757938.0 |
| 2008-02-19 | A6 | Futures | 0.68192 | 0.69429 | 0.68117 | 0.69195 | 39736.0 |
| 2008-02-19 | AD | Futures | 0.97425 | 0.97994 | 0.96481 | 0.9654 | 59744.0 |
| 2008-02-19 | B6 | Futures | 1.9886 | 1.9942 | 1.9754 | 1.979 | 87414.0 |
| 2008-02-19 | BFX | Futures | 4200.5 | 4301.1 | 4196.4 | 4271.7 | 267.0 |
| 2008-02-19 | CB | Futures | 84.577 | 84.577 | 84.577 | 84.577 | 14.0 |
| 2008-02-19 | CC | Futures | 2304.0 | 2338.0 | 2293.0 | 2301.0 | 7189.0 |
| 2008-02-19 | DC | Futures | 44.49 | 45.59 | 44.49 | 45.34 | 238.0 |
| 2008-02-19 | DX | Futures | 82.458 | 82.479 | 81.918 | 82.128 | 2087.0 |
| 2008-02-19 | E1 | Futures | 1.21823 | 1.22196 | 1.20651 | 1.21797 | 63072.0 |
| 2008-02-19 | E6 | Futures | 1.70203 | 1.71108 | 1.69402 | 1.70818 | 198328.0 |
| 2008-02-19 | E7 | Futures | 1.6888 | 1.6979 | 1.6812 | 1.6953 | 1753.0 |
| 2008-02-19 | ED | Futures | 91.7928 | 91.7952 | 91.7385 | 91.7574 | 259495.0 |
| 2008-02-19 | ER | Futures | 94.268 | 94.278 | 94.244 | 94.263 | 113032.0 |
| 2008-02-19 | EW | Futures | 789.6 | 801.3 | 788.3 | 795.8 | 21190.0 |
| 2008-02-19 | FCE | Futures | 3176.2 | 3235.8 | 3142.9 | 3197.0 | 138336.0 |
| 2008-02-19 | FDAX | Futures | 7899.6 | 8046.7 | 7827.7 | 7954.5 | 194150.0 |
| 2008-02-19 | FESX | Futures | 2163.6 | 2200.6 | 2142.5 | 2172.7 | 1428293.0 |
| 2008-02-19 | FEU3 | Futures | 94.754 | 94.754 | 94.734 | 94.739 | 1245.0 |
| 2008-02-19 | FTDX | Futures | 752.8 | 760.1 | 740.1 | 740.1 | 938.0 |
| 2008-02-19 | FTI | Futures | 329.98 | 336.47 | 326.8 | 333.76 | 38181.0 |
| 2008-02-19 | FTUK | Futures | 3806.5 | 3888.1 | 3788.4 | 3836.0 | 128950.0 |
| 2008-02-19 | G | Futures | 68.94 | 69.26 | 68.92 | 69.06 | 69390.0 |
| 2008-02-19 | GF | Futures | 304.737 | 310.805 | 304.515 | 310.509 | 158.0 |
| 2008-02-19 | HE | Futures | 150.413 | 152.053 | 149.827 | 151.174 | 3013.0 |
| 2008-02-19 | HG | Futures | 4.9521 | 5.2193 | 4.9396 | 5.2074 | 10691.0 |
| 2008-02-19 | HO | Futures | 2.9892 | 3.1086 | 2.9892 | 3.1086 | 9180.0 |
| 2008-02-19 | J1 | Futures | 0.0119095 | 0.0119826 | 0.0118557 | 0.0119364 | 158223.0 |
| 2008-02-19 | J7 | Futures | 0.011723 | 0.011769 | 0.011652 | 0.011726 | 54.0 |
| 2008-02-19 | JB | Futures | 114.41 | 114.51 | 114.36 | 114.5 | 3202.0 |
| 2008-02-19 | KC | Futures | 476.53 | 499.88 | 473.69 | 497.83 | 25889.0 |
| 2008-02-19 | KE | Futures | 5885.96 | 6026.81 | 5793.86 | 5875.12 | 7700.0 |
| 2008-02-19 | L | Futures | 93.944 | 93.964 | 93.944 | 93.964 | 28340.0 |
| 2008-02-19 | LE | Futures | 197.213 | 199.692 | 196.791 | 198.11 | 3069.0 |
| 2008-02-19 | MP | Futures | 0.04377 | 0.04395 | 0.04371 | 0.04374 | 22132.0 |
| 2008-02-19 | N6 | Futures | 0.58906 | 0.59857 | 0.58906 | 0.5964 | 2051.0 |
| 2008-02-19 | PA | Futures | 541.84 | 605.1 | 541.84 | 602.59 | 1629.0 |
| 2008-02-19 | PJY | Futures | 165.5 | 165.5 | 165.5 | 165.5 | 0.0 |
| 2008-02-19 | PL | Futures | 2462.2 | 2567.3 | 2428.0 | 2542.6 | 5721.0 |
| 2008-02-19 | PSI | Futures | 8921.5 | 8938.0 | 8879.0 | 8885.3 | 94.0 |
| 2008-02-19 | RB | Futures | 1.3689 | 1.4208 | 1.3689 | 1.4157 | 8855.0 |
| 2008-02-19 | RP | Futures | 0.85433 | 0.8623 | 0.85229 | 0.86122 | 161.0 |
| 2008-02-19 | RTY | Futures | 710.4 | 723.4 | 707.9 | 715.6 | 206492.0 |
| 2008-02-19 | RY | Futures | 143.92 | 144.75 | 143.74 | 144.24 | 1052.0 |
| 2008-02-19 | SI | Futures | 29.454 | 30.324 | 29.23 | 30.165 | 32166.0 |
> showing 50 of 56 rows — these rows as CSV