PREVIEW / futures_1hour / 2018-01-01
file: by_date/futures_1hour/2018/2018-01-01.parquet size: 14 KB rows: 271
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 |
|---|---|---|---|---|---|---|---|
| 2018-01-01 18:00:00 | ES | Futures | 2924.88 | 2931.17 | 2924.06 | 2930.9 | 16395.0 |
| 2018-01-01 19:00:00 | ES | Futures | 2930.9 | 2931.99 | 2930.08 | 2930.9 | 5597.0 |
| 2018-01-01 20:00:00 | ES | Futures | 2930.62 | 2930.9 | 2928.98 | 2929.53 | 5650.0 |
| 2018-01-01 21:00:00 | ES | Futures | 2929.53 | 2930.08 | 2926.25 | 2927.07 | 5557.0 |
| 2018-01-01 22:00:00 | ES | Futures | 2927.07 | 2929.26 | 2926.25 | 2928.71 | 2351.0 |
| 2018-01-01 23:00:00 | ES | Futures | 2928.71 | 2929.26 | 2928.44 | 2929.26 | 1356.0 |
| 2018-01-01 18:00:00 | NQ | Futures | 7598.74 | 7613.28 | 7594.59 | 7612.98 | 2705.0 |
| 2018-01-01 19:00:00 | NQ | Futures | 7612.68 | 7620.99 | 7612.39 | 7618.02 | 2117.0 |
| 2018-01-01 20:00:00 | NQ | Futures | 7618.02 | 7620.99 | 7614.76 | 7617.13 | 1788.0 |
| 2018-01-01 21:00:00 | NQ | Futures | 7617.13 | 7620.4 | 7608.24 | 7610.91 | 1472.0 |
| 2018-01-01 22:00:00 | NQ | Futures | 7610.91 | 7616.24 | 7606.75 | 7608.53 | 1216.0 |
| 2018-01-01 23:00:00 | NQ | Futures | 7608.53 | 7613.87 | 7608.53 | 7613.28 | 517.0 |
| 2018-01-01 18:00:00 | YM | Futures | 26884.0 | 26931.8 | 26874.2 | 26925.3 | 2239.0 |
| 2018-01-01 19:00:00 | YM | Futures | 26926.4 | 26927.5 | 26914.4 | 26914.4 | 759.0 |
| 2018-01-01 20:00:00 | YM | Futures | 26915.5 | 26919.8 | 26904.6 | 26912.2 | 965.0 |
| 2018-01-01 21:00:00 | YM | Futures | 26910.1 | 26916.6 | 26890.5 | 26899.2 | 858.0 |
| 2018-01-01 22:00:00 | YM | Futures | 26898.1 | 26910.1 | 26892.7 | 26910.1 | 679.0 |
| 2018-01-01 23:00:00 | YM | Futures | 26911.2 | 26920.9 | 26910.1 | 26919.8 | 362.0 |
| 2018-01-01 18:00:00 | CL | Futures | 53.41 | 53.48 | 53.34 | 53.43 | 3380.0 |
| 2018-01-01 19:00:00 | CL | Futures | 53.43 | 53.47 | 53.42 | 53.45 | 1501.0 |
| 2018-01-01 20:00:00 | CL | Futures | 53.44 | 53.83 | 53.41 | 53.75 | 14477.0 |
| 2018-01-01 21:00:00 | CL | Futures | 53.74 | 53.88 | 53.74 | 53.8 | 8349.0 |
| 2018-01-01 22:00:00 | CL | Futures | 53.8 | 53.8 | 53.73 | 53.74 | 2992.0 |
| 2018-01-01 23:00:00 | CL | Futures | 53.74 | 53.77 | 53.72 | 53.74 | 2384.0 |
| 2018-01-01 18:00:00 | GC | Futures | 1733.5 | 1739.3 | 1732.5 | 1738.0 | 5308.0 |
| 2018-01-01 19:00:00 | GC | Futures | 1738.1 | 1738.8 | 1736.1 | 1737.5 | 4910.0 |
| 2018-01-01 20:00:00 | GC | Futures | 1737.6 | 1738.4 | 1734.7 | 1737.2 | 8006.0 |
| 2018-01-01 21:00:00 | GC | Futures | 1737.3 | 1738.1 | 1736.3 | 1736.8 | 4092.0 |
| 2018-01-01 22:00:00 | GC | Futures | 1736.8 | 1738.8 | 1736.1 | 1737.5 | 4540.0 |
| 2018-01-01 23:00:00 | GC | Futures | 1737.3 | 1738.5 | 1737.2 | 1738.4 | 1842.0 |
| 2018-01-01 18:00:00 | ZN | Futures | 123.722058 | 123.737649 | 123.690874 | 123.722058 | 7869.0 |
| 2018-01-01 19:00:00 | ZN | Futures | 123.722058 | 123.737649 | 123.706466 | 123.722058 | 4167.0 |
| 2018-01-01 20:00:00 | ZN | Futures | 123.706466 | 123.737649 | 123.706466 | 123.737649 | 3533.0 |
| 2018-01-01 21:00:00 | ZN | Futures | 123.737649 | 123.737649 | 123.706466 | 123.706466 | 885.0 |
| 2018-01-01 22:00:00 | ZN | Futures | 123.722058 | 123.722058 | 123.706466 | 123.722058 | 327.0 |
| 2018-01-01 23:00:00 | ZN | Futures | 123.706466 | 123.722058 | 123.706466 | 123.722058 | 2784.0 |
> showing 36 of 271 rows — these rows as CSV