PREVIEW / futures_1hour / 2010-06-06
file: by_date/futures_1hour/2010/2010-06-06.parquet size: 14 KB rows: 252
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-06 18:00:00 | ES | Futures | 1040.28 | 1041.74 | 1032.95 | 1034.66 | 22144.0 |
| 2010-06-06 19:00:00 | ES | Futures | 1034.66 | 1040.77 | 1033.92 | 1037.59 | 13836.0 |
| 2010-06-06 20:00:00 | ES | Futures | 1037.59 | 1038.81 | 1028.55 | 1031.72 | 25909.0 |
| 2010-06-06 21:00:00 | ES | Futures | 1031.72 | 1032.95 | 1028.55 | 1028.55 | 12103.0 |
| 2010-06-06 22:00:00 | ES | Futures | 1028.79 | 1034.17 | 1028.55 | 1033.19 | 10557.0 |
| 2010-06-06 23:00:00 | ES | Futures | 1033.19 | 1034.17 | 1030.75 | 1033.43 | 5505.0 |
| 2010-06-06 18:00:00 | NQ | Futures | 2098.25 | 2098.82 | 2076.77 | 2084.79 | 2143.0 |
| 2010-06-06 19:00:00 | NQ | Futures | 2085.37 | 2097.39 | 2084.22 | 2091.67 | 864.0 |
| 2010-06-06 20:00:00 | NQ | Futures | 2091.95 | 2093.38 | 2075.06 | 2079.92 | 1610.0 |
| 2010-06-06 21:00:00 | NQ | Futures | 2080.21 | 2082.5 | 2075.34 | 2076.77 | 1805.0 |
| 2010-06-06 22:00:00 | NQ | Futures | 2076.77 | 2086.8 | 2076.2 | 2084.51 | 1138.0 |
| 2010-06-06 23:00:00 | NQ | Futures | 2083.65 | 2087.66 | 2079.92 | 2085.37 | 567.0 |
| 2010-06-06 18:00:00 | YM | Futures | 9338.3 | 9345.8 | 9274.3 | 9285.6 | 1460.0 |
| 2010-06-06 19:00:00 | YM | Futures | 9287.5 | 9336.4 | 9281.8 | 9311.9 | 1309.0 |
| 2010-06-06 20:00:00 | YM | Futures | 9312.9 | 9327.0 | 9245.1 | 9265.8 | 2091.0 |
| 2010-06-06 21:00:00 | YM | Futures | 9266.8 | 9277.1 | 9243.2 | 9247.0 | 1434.0 |
| 2010-06-06 22:00:00 | YM | Futures | 9247.0 | 9282.8 | 9242.3 | 9277.1 | 1366.0 |
| 2010-06-06 23:00:00 | YM | Futures | 9277.1 | 9283.7 | 9260.2 | 9276.2 | 787.0 |
| 2010-06-06 18:00:00 | CL | Futures | 138.35 | 138.83 | 137.98 | 138.08 | 2240.0 |
| 2010-06-06 19:00:00 | CL | Futures | 138.08 | 138.57 | 138.08 | 138.33 | 1112.0 |
| 2010-06-06 20:00:00 | CL | Futures | 138.33 | 138.45 | 136.7 | 137.17 | 3260.0 |
| 2010-06-06 21:00:00 | CL | Futures | 137.17 | 137.69 | 136.94 | 137.37 | 2404.0 |
| 2010-06-06 22:00:00 | CL | Futures | 137.37 | 138.04 | 137.35 | 137.88 | 1445.0 |
| 2010-06-06 23:00:00 | CL | Futures | 137.9 | 138.0 | 137.59 | 137.72 | 982.0 |
| 2010-06-06 18:00:00 | GC | Futures | 1713.8 | 1715.8 | 1711.7 | 1714.4 | 931.0 |
| 2010-06-06 19:00:00 | GC | Futures | 1714.9 | 1715.6 | 1709.9 | 1710.7 | 1100.0 |
| 2010-06-06 20:00:00 | GC | Futures | 1710.6 | 1711.3 | 1707.2 | 1708.6 | 2300.0 |
| 2010-06-06 21:00:00 | GC | Futures | 1708.5 | 1712.8 | 1707.6 | 1712.0 | 2044.0 |
| 2010-06-06 22:00:00 | GC | Futures | 1711.8 | 1714.7 | 1711.7 | 1712.3 | 1206.0 |
| 2010-06-06 23:00:00 | GC | Futures | 1712.1 | 1713.0 | 1711.1 | 1712.5 | 452.0 |
| 2010-06-06 18:00:00 | ZN | Futures | 100.12192 | 100.12192 | 100.12192 | 100.12192 | 4.0 |
| 2010-06-06 19:00:00 | ZN | Futures | 100.12192 | 100.12192 | 100.070529 | 100.070529 | 38.0 |
| 2010-06-06 20:00:00 | ZN | Futures | 100.083377 | 100.147615 | 100.083377 | 100.147615 | 6.0 |
| 2010-06-06 21:00:00 | ZN | Futures | 100.096225 | 100.160463 | 100.096225 | 100.160463 | 195.0 |
| 2010-06-06 22:00:00 | ZN | Futures | 100.160463 | 100.160463 | 100.096225 | 100.134768 | 341.0 |
| 2010-06-06 23:00:00 | ZN | Futures | 100.12192 | 100.12192 | 100.12192 | 100.12192 | 1.0 |
> showing 36 of 252 rows — these rows as CSV