PREVIEW / futures_daily / 2008-01-17
file: by_date/futures_daily/2008/2008-01-17.parquet size: 7 KB rows: 47
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-01-17 | ES | Futures | 1276.52 | 1287.64 | 1236.44 | 1241.76 | 3404177.0 |
| 2008-01-17 | NQ | Futures | 2113.61 | 2138.3 | 2075.16 | 2083.3 | 645261.0 |
| 2008-01-17 | YM | Futures | 11090.9 | 11178.8 | 10796.0 | 10851.1 | 277771.0 |
| 2008-01-17 | CL | Futures | 388.49 | 393.17 | 381.76 | 384.2 | 165032.0 |
| 2008-01-17 | ZN | Futures | 83.22636 | 83.922251 | 83.136567 | 83.720218 | 1499816.0 |
| 2008-01-17 | A6 | Futures | 0.65969 | 0.66647 | 0.65735 | 0.66097 | 57264.0 |
| 2008-01-17 | AD | Futures | 0.95843 | 0.96452 | 0.95253 | 0.95362 | 41761.0 |
| 2008-01-17 | B6 | Futures | 1.9913 | 2.0087 | 1.9896 | 2.0 | 87125.0 |
| 2008-01-17 | CB | Futures | 87.305 | 87.305 | 86.964 | 87.305 | 4.0 |
| 2008-01-17 | DC | Futures | 41.74 | 42.46 | 41.59 | 42.19 | 279.0 |
| 2008-01-17 | DX | Futures | 82.366 | 82.711 | 82.107 | 82.371 | 2730.0 |
| 2008-01-17 | E1 | Futures | 1.21437 | 1.21956 | 1.20477 | 1.21383 | 57357.0 |
| 2008-01-17 | E6 | Futures | 1.69936 | 1.70678 | 1.69182 | 1.70179 | 191917.0 |
| 2008-01-17 | E7 | Futures | 1.6863 | 1.6939 | 1.6793 | 1.6889 | 1430.0 |
| 2008-01-17 | ED | Futures | 91.1335 | 91.2138 | 91.0815 | 91.1713 | 375441.0 |
| 2008-01-17 | ER | Futures | 94.278 | 94.327 | 94.268 | 94.293 | 243381.0 |
| 2008-01-17 | EW | Futures | 778.1 | 785.4 | 755.7 | 757.0 | 41748.0 |
| 2008-01-17 | FDAX | Futures | 8558.4 | 8612.8 | 8347.3 | 8457.1 | 257000.0 |
| 2008-01-17 | FESX | Futures | 2366.3 | 2382.2 | 2295.1 | 2328.7 | 2236147.0 |
| 2008-01-17 | FEU3 | Futures | 94.749 | 94.794 | 94.749 | 94.779 | 773.0 |
| 2008-01-17 | FTDX | Futures | 757.4 | 769.3 | 734.6 | 745.5 | 12908.0 |
| 2008-01-17 | FTUK | Futures | 3872.6 | 3897.2 | 3791.3 | 3812.0 | 187756.0 |
| 2008-01-17 | G | Futures | 70.31 | 70.33 | 69.93 | 70.26 | 150755.0 |
| 2008-01-17 | GF | Futures | 298.891 | 300.149 | 294.525 | 299.853 | 394.0 |
| 2008-01-17 | HG | Futures | 4.4595 | 4.5628 | 4.3997 | 4.4728 | 12213.0 |
| 2008-01-17 | J1 | Futures | 0.0119864 | 0.0120954 | 0.0119441 | 0.012039 | 177704.0 |
| 2008-01-17 | J7 | Futures | 0.011793 | 0.011878 | 0.011737 | 0.011827 | 118.0 |
| 2008-01-17 | JB | Futures | 115.17 | 115.27 | 114.78 | 114.89 | 2552.0 |
| 2008-01-17 | KC | Futures | 428.67 | 432.01 | 424.53 | 427.39 | 9817.0 |
| 2008-01-17 | KE | Futures | 5195.24 | 5357.76 | 5192.53 | 5317.13 | 4680.0 |
| 2008-01-17 | L | Futures | 94.243 | 94.243 | 94.153 | 94.173 | 111642.0 |
| 2008-01-17 | LE | Futures | 196.791 | 198.901 | 194.682 | 197.899 | 3102.0 |
| 2008-01-17 | MP | Futures | 0.04294 | 0.04301 | 0.04286 | 0.04289 | 13207.0 |
| 2008-01-17 | N6 | Futures | 0.57205 | 0.57737 | 0.56823 | 0.57047 | 2231.0 |
| 2008-01-17 | PA | Futures | 446.23 | 452.23 | 441.67 | 451.33 | 719.0 |
| 2008-01-17 | PJY | Futures | 165.84 | 165.84 | 165.84 | 165.84 | 0.0 |
| 2008-01-17 | PL | Futures | 1846.9 | 1855.2 | 1835.2 | 1849.1 | 2204.0 |
| 2008-01-17 | PSI | Futures | 9252.4 | 9252.4 | 9107.0 | 9118.8 | 411.0 |
| 2008-01-17 | RP | Futures | 0.85268 | 0.85291 | 0.84563 | 0.84893 | 399.0 |
| 2008-01-17 | RTY | Futures | 709.8 | 716.7 | 689.9 | 692.9 | 377356.0 |
| 2008-01-17 | RY | Futures | 142.78 | 143.19 | 141.53 | 142.47 | 1907.0 |
| 2008-01-17 | SI | Futures | 27.343 | 27.869 | 27.257 | 27.584 | 25634.0 |
| 2008-01-17 | US | Futures | 90.505773 | 91.695386 | 90.458188 | 91.433671 | 456670.0 |
| 2008-01-17 | ZF | Futures | 92.0253348 | 92.5628958 | 91.884545 | 92.3709097 | 767015.0 |
| 2008-01-17 | ZL | Futures | 52.59 | 53.83 | 52.49 | 52.76 | 10160.0 |
| 2008-01-17 | ZT | Futures | 98.46026041 | 98.69939993 | 98.37330059 | 98.60519345 | 382130.0 |
| 2008-01-17 | ZW | Futures | 7089.98 | 7303.79 | 7080.44 | 7181.62 | 3859.0 |
> showing 47 of 47 rows — these rows as CSV