PREVIEW / futures_1hour / 2008-06-15
file: by_date/futures_1hour/2008/2008-06-15.parquet size: 12 KB rows: 211
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2008-06-15 18:00:00 | ES | Futures | 1263.41 | 1265.04 | 1261.78 | 1264.57 | 3724.0 |
| 2008-06-15 19:00:00 | ES | Futures | 1264.57 | 1264.8 | 1263.64 | 1264.8 | 945.0 |
| 2008-06-15 20:00:00 | ES | Futures | 1264.57 | 1265.73 | 1263.87 | 1264.11 | 2107.0 |
| 2008-06-15 21:00:00 | ES | Futures | 1263.87 | 1264.34 | 1262.95 | 1263.18 | 1781.0 |
| 2008-06-15 22:00:00 | ES | Futures | 1263.18 | 1263.64 | 1262.02 | 1263.41 | 2238.0 |
| 2008-06-15 23:00:00 | ES | Futures | 1263.41 | 1264.34 | 1262.71 | 1264.34 | 1078.0 |
| 2008-06-15 18:00:00 | NQ | Futures | 2221.62 | 2223.31 | 2219.65 | 2221.34 | 126.0 |
| 2008-06-15 19:00:00 | NQ | Futures | 2223.31 | 2223.31 | 2213.18 | 2221.06 | 395.0 |
| 2008-06-15 20:00:00 | NQ | Futures | 2219.93 | 2223.03 | 2217.4 | 2217.96 | 608.0 |
| 2008-06-15 21:00:00 | NQ | Futures | 2218.24 | 2218.24 | 2209.52 | 2212.34 | 1626.0 |
| 2008-06-15 22:00:00 | NQ | Futures | 2212.06 | 2214.02 | 2210.93 | 2213.74 | 178.0 |
| 2008-06-15 23:00:00 | NQ | Futures | 2213.46 | 2215.71 | 2212.06 | 2215.43 | 123.0 |
| 2008-06-15 18:00:00 | YM | Futures | 11179.2 | 11184.6 | 11155.5 | 11177.3 | 161.0 |
| 2008-06-15 19:00:00 | YM | Futures | 11180.1 | 11183.7 | 11172.8 | 11178.2 | 94.0 |
| 2008-06-15 20:00:00 | YM | Futures | 11179.2 | 11190.1 | 11179.2 | 11180.1 | 111.0 |
| 2008-06-15 21:00:00 | YM | Futures | 11177.3 | 11181.0 | 11169.2 | 11170.1 | 125.0 |
| 2008-06-15 22:00:00 | YM | Futures | 11170.1 | 11175.5 | 11161.0 | 11175.5 | 106.0 |
| 2008-06-15 23:00:00 | YM | Futures | 11173.7 | 11183.7 | 11169.2 | 11180.1 | 112.0 |
| 2008-06-15 18:00:00 | CL | Futures | 512.63 | 513.77 | 511.99 | 511.99 | 582.0 |
| 2008-06-15 19:00:00 | CL | Futures | 511.95 | 512.37 | 511.65 | 511.87 | 65.0 |
| 2008-06-15 20:00:00 | CL | Futures | 511.87 | 512.48 | 511.61 | 511.72 | 78.0 |
| 2008-06-15 21:00:00 | CL | Futures | 511.83 | 511.95 | 510.77 | 511.0 | 91.0 |
| 2008-06-15 22:00:00 | CL | Futures | 510.81 | 511.3 | 510.62 | 510.81 | 116.0 |
| 2008-06-15 23:00:00 | CL | Futures | 510.81 | 510.96 | 510.32 | 510.7 | 86.0 |
| 2008-06-15 18:00:00 | GC | Futures | 1257.9 | 1261.2 | 1256.6 | 1259.6 | 373.0 |
| 2008-06-15 19:00:00 | GC | Futures | 1259.7 | 1261.2 | 1259.0 | 1259.7 | 180.0 |
| 2008-06-15 20:00:00 | GC | Futures | 1259.9 | 1261.0 | 1258.9 | 1260.5 | 507.0 |
| 2008-06-15 21:00:00 | GC | Futures | 1260.5 | 1261.3 | 1259.9 | 1260.9 | 268.0 |
| 2008-06-15 22:00:00 | GC | Futures | 1260.7 | 1261.9 | 1260.3 | 1260.6 | 327.0 |
| 2008-06-15 23:00:00 | GC | Futures | 1260.9 | 1261.6 | 1260.0 | 1260.7 | 197.0 |
| 2008-06-15 20:00:00 | ZN | Futures | 83.346488 | 83.36989 | 83.311385 | 83.358189 | 1348.0 |
| 2008-06-15 21:00:00 | ZN | Futures | 83.346488 | 83.358189 | 83.299684 | 83.323086 | 1348.0 |
| 2008-06-15 22:00:00 | ZN | Futures | 83.323086 | 83.358189 | 83.311385 | 83.346488 | 871.0 |
| 2008-06-15 23:00:00 | ZN | Futures | 83.346488 | 83.381591 | 83.334787 | 83.358189 | 1557.0 |
> showing 34 of 211 rows — these rows as CSV