PREVIEW / futures_1hour / 2015-01-01
file: by_date/futures_1hour/2015/2015-01-01.parquet size: 13 KB rows: 231
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-01 18:00:00 | ES | Futures | 2163.11 | 2167.58 | 2163.11 | 2167.32 | 8768.0 |
| 2015-01-01 19:00:00 | ES | Futures | 2167.32 | 2167.58 | 2165.74 | 2167.06 | 3301.0 |
| 2015-01-01 20:00:00 | ES | Futures | 2167.32 | 2170.21 | 2167.06 | 2169.16 | 5844.0 |
| 2015-01-01 21:00:00 | ES | Futures | 2169.16 | 2171.27 | 2168.9 | 2170.48 | 3399.0 |
| 2015-01-01 22:00:00 | ES | Futures | 2170.74 | 2170.74 | 2169.95 | 2170.21 | 2014.0 |
| 2015-01-01 23:00:00 | ES | Futures | 2170.48 | 2172.06 | 2169.95 | 2171.53 | 2772.0 |
| 2015-01-01 18:00:00 | NQ | Futures | 4981.25 | 4992.12 | 4981.25 | 4990.35 | 791.0 |
| 2015-01-01 19:00:00 | NQ | Futures | 4990.35 | 4991.53 | 4988.59 | 4990.94 | 274.0 |
| 2015-01-01 20:00:00 | NQ | Futures | 4990.94 | 4996.81 | 4990.94 | 4995.64 | 752.0 |
| 2015-01-01 21:00:00 | NQ | Futures | 4995.35 | 4998.87 | 4994.46 | 4997.4 | 447.0 |
| 2015-01-01 22:00:00 | NQ | Futures | 4997.99 | 4998.28 | 4995.05 | 4995.35 | 248.0 |
| 2015-01-01 23:00:00 | NQ | Futures | 4995.64 | 4999.75 | 4994.76 | 4999.16 | 363.0 |
| 2015-01-01 18:00:00 | YM | Futures | 18561.2 | 18608.2 | 18557.0 | 18604.0 | 1259.0 |
| 2015-01-01 19:00:00 | YM | Futures | 18605.0 | 18606.1 | 18591.5 | 18604.0 | 372.0 |
| 2015-01-01 20:00:00 | YM | Futures | 18604.0 | 18624.9 | 18602.9 | 18616.5 | 892.0 |
| 2015-01-01 21:00:00 | YM | Futures | 18616.5 | 18632.2 | 18613.4 | 18626.9 | 388.0 |
| 2015-01-01 22:00:00 | YM | Futures | 18628.0 | 18628.0 | 18621.7 | 18622.8 | 299.0 |
| 2015-01-01 23:00:00 | YM | Futures | 18623.8 | 18639.5 | 18621.7 | 18636.3 | 280.0 |
| 2015-01-01 18:00:00 | CL | Futures | 91.5 | 93.79 | 91.24 | 92.84 | 4754.0 |
| 2015-01-01 19:00:00 | CL | Futures | 92.87 | 93.18 | 92.19 | 92.31 | 2777.0 |
| 2015-01-01 20:00:00 | CL | Futures | 92.36 | 92.67 | 92.01 | 92.01 | 3358.0 |
| 2015-01-01 21:00:00 | CL | Futures | 92.02 | 92.13 | 91.43 | 91.73 | 3155.0 |
| 2015-01-01 22:00:00 | CL | Futures | 91.7 | 91.85 | 91.56 | 91.77 | 1498.0 |
| 2015-01-01 23:00:00 | CL | Futures | 91.77 | 91.99 | 91.5 | 91.51 | 2532.0 |
| 2015-01-01 18:00:00 | GC | Futures | 1619.8 | 1624.5 | 1619.1 | 1623.6 | 1180.0 |
| 2015-01-01 19:00:00 | GC | Futures | 1623.4 | 1625.5 | 1622.5 | 1624.4 | 832.0 |
| 2015-01-01 20:00:00 | GC | Futures | 1624.3 | 1624.4 | 1620.0 | 1621.0 | 1474.0 |
| 2015-01-01 21:00:00 | GC | Futures | 1621.1 | 1621.7 | 1620.0 | 1621.1 | 677.0 |
| 2015-01-01 22:00:00 | GC | Futures | 1621.1 | 1622.6 | 1620.3 | 1622.6 | 635.0 |
| 2015-01-01 23:00:00 | GC | Futures | 1622.6 | 1624.3 | 1620.6 | 1620.6 | 863.0 |
| 2015-01-01 18:00:00 | ZN | Futures | 120.394145 | 120.468435 | 120.379287 | 120.379287 | 3361.0 |
| 2015-01-01 19:00:00 | ZN | Futures | 120.379287 | 120.379287 | 120.304998 | 120.304998 | 2401.0 |
| 2015-01-01 20:00:00 | ZN | Futures | 120.304998 | 120.334713 | 120.245566 | 120.275282 | 3372.0 |
| 2015-01-01 21:00:00 | ZN | Futures | 120.275282 | 120.304998 | 120.275282 | 120.275282 | 1626.0 |
| 2015-01-01 22:00:00 | ZN | Futures | 120.275282 | 120.304998 | 120.275282 | 120.304998 | 1480.0 |
| 2015-01-01 23:00:00 | ZN | Futures | 120.304998 | 120.304998 | 120.245566 | 120.260424 | 1415.0 |
> showing 36 of 231 rows — these rows as CSV