PREVIEW / futures_1hour / 2017-10-01
file: by_date/futures_1hour/2017/2017-10-01.parquet size: 15 KB rows: 287
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 |
|---|---|---|---|---|---|---|---|
| 2017-10-01 18:00:00 | ES | Futures | 2755.28 | 2761.3 | 2754.19 | 2758.02 | 21056.0 |
| 2017-10-01 19:00:00 | ES | Futures | 2758.02 | 2758.56 | 2756.92 | 2757.74 | 4753.0 |
| 2017-10-01 20:00:00 | ES | Futures | 2757.74 | 2758.29 | 2756.38 | 2756.65 | 7539.0 |
| 2017-10-01 21:00:00 | ES | Futures | 2756.92 | 2757.2 | 2756.1 | 2756.92 | 4650.0 |
| 2017-10-01 22:00:00 | ES | Futures | 2756.92 | 2756.92 | 2755.56 | 2756.38 | 3076.0 |
| 2017-10-01 23:00:00 | ES | Futures | 2756.38 | 2756.92 | 2756.1 | 2756.1 | 3738.0 |
| 2017-10-01 18:00:00 | NQ | Futures | 7118.96 | 7137.4 | 7116.88 | 7129.37 | 4757.0 |
| 2017-10-01 19:00:00 | NQ | Futures | 7129.37 | 7132.05 | 7126.99 | 7130.26 | 1091.0 |
| 2017-10-01 20:00:00 | NQ | Futures | 7129.96 | 7131.75 | 7125.21 | 7127.29 | 1607.0 |
| 2017-10-01 21:00:00 | NQ | Futures | 7127.29 | 7130.56 | 7125.8 | 7128.18 | 1058.0 |
| 2017-10-01 22:00:00 | NQ | Futures | 7128.18 | 7128.48 | 7123.72 | 7127.29 | 823.0 |
| 2017-10-01 23:00:00 | NQ | Futures | 7126.99 | 7129.67 | 7125.5 | 7126.69 | 1340.0 |
| 2017-10-01 18:00:00 | YM | Futures | 24315.2 | 24379.4 | 24306.5 | 24348.9 | 3725.0 |
| 2017-10-01 19:00:00 | YM | Futures | 24348.9 | 24351.1 | 24339.1 | 24342.4 | 836.0 |
| 2017-10-01 20:00:00 | YM | Futures | 24342.4 | 24342.4 | 24327.1 | 24331.5 | 1235.0 |
| 2017-10-01 21:00:00 | YM | Futures | 24331.5 | 24338.0 | 24323.9 | 24334.8 | 942.0 |
| 2017-10-01 22:00:00 | YM | Futures | 24334.8 | 24334.8 | 24318.4 | 24328.2 | 564.0 |
| 2017-10-01 23:00:00 | YM | Futures | 24328.2 | 24331.5 | 24326.1 | 24328.2 | 442.0 |
| 2017-10-01 18:00:00 | CL | Futures | 46.23 | 46.29 | 46.2 | 46.26 | 1421.0 |
| 2017-10-01 19:00:00 | CL | Futures | 46.25 | 46.27 | 46.2 | 46.21 | 820.0 |
| 2017-10-01 20:00:00 | CL | Futures | 46.21 | 46.27 | 46.19 | 46.27 | 2094.0 |
| 2017-10-01 21:00:00 | CL | Futures | 46.27 | 46.27 | 46.18 | 46.19 | 1914.0 |
| 2017-10-01 22:00:00 | CL | Futures | 46.18 | 46.19 | 46.1 | 46.14 | 3332.0 |
| 2017-10-01 23:00:00 | CL | Futures | 46.15 | 46.16 | 46.11 | 46.11 | 1333.0 |
| 2017-10-01 18:00:00 | GC | Futures | 1708.1 | 1708.9 | 1703.9 | 1705.9 | 3241.0 |
| 2017-10-01 19:00:00 | GC | Futures | 1705.9 | 1706.6 | 1705.0 | 1705.8 | 3907.0 |
| 2017-10-01 20:00:00 | GC | Futures | 1705.7 | 1705.7 | 1700.8 | 1702.5 | 12315.0 |
| 2017-10-01 21:00:00 | GC | Futures | 1702.5 | 1703.1 | 1701.4 | 1702.1 | 4776.0 |
| 2017-10-01 22:00:00 | GC | Futures | 1702.1 | 1702.9 | 1701.7 | 1701.8 | 2842.0 |
| 2017-10-01 23:00:00 | GC | Futures | 1701.8 | 1702.3 | 1700.8 | 1701.9 | 3872.0 |
| 2017-10-01 18:00:00 | ZN | Futures | 124.718624 | 124.734185 | 124.6097 | 124.671942 | 15096.0 |
| 2017-10-01 19:00:00 | ZN | Futures | 124.671942 | 124.687503 | 124.640821 | 124.656382 | 7894.0 |
| 2017-10-01 20:00:00 | ZN | Futures | 124.671942 | 124.671942 | 124.516336 | 124.547457 | 26786.0 |
| 2017-10-01 21:00:00 | ZN | Futures | 124.563018 | 124.578578 | 124.531896 | 124.531896 | 19162.0 |
| 2017-10-01 22:00:00 | ZN | Futures | 124.547457 | 124.563018 | 124.531896 | 124.547457 | 6079.0 |
| 2017-10-01 23:00:00 | ZN | Futures | 124.547457 | 124.578578 | 124.531896 | 124.563018 | 9384.0 |
> showing 36 of 287 rows — these rows as CSV