PREVIEW / futures_1hour / 2014-06-08
file: by_date/futures_1hour/2014/2014-06-08.parquet size: 13 KB rows: 250
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-08 18:00:00 | ES | Futures | 2024.66 | 2025.18 | 2023.62 | 2023.88 | 6019.0 |
| 2014-06-08 19:00:00 | ES | Futures | 2023.88 | 2024.4 | 2023.88 | 2023.88 | 1059.0 |
| 2014-06-08 20:00:00 | ES | Futures | 2023.88 | 2024.92 | 2023.62 | 2024.4 | 2544.0 |
| 2014-06-08 21:00:00 | ES | Futures | 2024.66 | 2024.92 | 2023.88 | 2024.4 | 2295.0 |
| 2014-06-08 22:00:00 | ES | Futures | 2024.4 | 2025.44 | 2024.4 | 2024.92 | 2987.0 |
| 2014-06-08 23:00:00 | ES | Futures | 2024.92 | 2025.18 | 2023.88 | 2023.88 | 1900.0 |
| 2014-06-08 18:00:00 | NQ | Futures | 4426.58 | 4426.58 | 4423.08 | 4424.25 | 537.0 |
| 2014-06-08 19:00:00 | NQ | Futures | 4423.96 | 4424.25 | 4423.38 | 4423.96 | 108.0 |
| 2014-06-08 20:00:00 | NQ | Futures | 4423.67 | 4425.12 | 4423.08 | 4424.54 | 285.0 |
| 2014-06-08 21:00:00 | NQ | Futures | 4424.54 | 4425.7 | 4423.67 | 4424.25 | 355.0 |
| 2014-06-08 22:00:00 | NQ | Futures | 4424.25 | 4426.0 | 4424.25 | 4424.54 | 414.0 |
| 2014-06-08 23:00:00 | NQ | Futures | 4424.54 | 4425.41 | 4423.08 | 4423.38 | 353.0 |
| 2014-06-08 18:00:00 | YM | Futures | 17445.8 | 17445.8 | 17432.4 | 17433.5 | 540.0 |
| 2014-06-08 19:00:00 | YM | Futures | 17433.5 | 17438.6 | 17433.5 | 17434.5 | 74.0 |
| 2014-06-08 20:00:00 | YM | Futures | 17434.5 | 17441.7 | 17432.4 | 17438.6 | 263.0 |
| 2014-06-08 21:00:00 | YM | Futures | 17437.6 | 17441.7 | 17434.5 | 17438.6 | 404.0 |
| 2014-06-08 22:00:00 | YM | Futures | 17439.6 | 17446.9 | 17438.6 | 17442.7 | 755.0 |
| 2014-06-08 23:00:00 | YM | Futures | 17442.7 | 17444.8 | 17435.5 | 17437.6 | 324.0 |
| 2014-06-08 18:00:00 | CL | Futures | 165.91 | 165.91 | 165.65 | 165.7 | 842.0 |
| 2014-06-08 19:00:00 | CL | Futures | 165.7 | 165.85 | 165.68 | 165.8 | 525.0 |
| 2014-06-08 20:00:00 | CL | Futures | 165.81 | 165.96 | 165.81 | 165.96 | 419.0 |
| 2014-06-08 21:00:00 | CL | Futures | 165.96 | 166.06 | 165.86 | 165.94 | 462.0 |
| 2014-06-08 22:00:00 | CL | Futures | 165.94 | 166.01 | 165.85 | 165.94 | 464.0 |
| 2014-06-08 23:00:00 | CL | Futures | 165.93 | 166.1 | 165.85 | 165.98 | 604.0 |
| 2014-06-08 18:00:00 | GC | Futures | 1716.2 | 1717.2 | 1714.4 | 1716.6 | 526.0 |
| 2014-06-08 19:00:00 | GC | Futures | 1716.6 | 1718.0 | 1715.5 | 1717.9 | 443.0 |
| 2014-06-08 20:00:00 | GC | Futures | 1717.7 | 1718.3 | 1715.4 | 1715.5 | 725.0 |
| 2014-06-08 21:00:00 | GC | Futures | 1715.4 | 1717.0 | 1714.3 | 1715.9 | 1894.0 |
| 2014-06-08 22:00:00 | GC | Futures | 1715.9 | 1717.4 | 1715.8 | 1716.5 | 977.0 |
| 2014-06-08 23:00:00 | GC | Futures | 1716.5 | 1716.6 | 1715.1 | 1716.5 | 572.0 |
| 2014-06-08 18:00:00 | ZN | Futures | 117.274502 | 117.289237 | 117.230298 | 117.274502 | 2829.0 |
| 2014-06-08 19:00:00 | ZN | Futures | 117.259768 | 117.303972 | 117.259768 | 117.289237 | 3096.0 |
| 2014-06-08 20:00:00 | ZN | Futures | 117.289237 | 117.303972 | 117.245033 | 117.259768 | 5739.0 |
| 2014-06-08 21:00:00 | ZN | Futures | 117.259768 | 117.259768 | 117.068215 | 117.112419 | 23216.0 |
| 2014-06-08 22:00:00 | ZN | Futures | 117.097685 | 117.141889 | 117.097685 | 117.112419 | 8347.0 |
| 2014-06-08 23:00:00 | ZN | Futures | 117.112419 | 117.127154 | 117.097685 | 117.112419 | 2458.0 |
> showing 36 of 250 rows — these rows as CSV