PREVIEW / futures_1hour / 2013-12-30
file: by_date/futures_1hour/2013/2013-12-30.parquet size: 47 KB rows: 1,498
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-30 00:00:00 | ES | Futures | 1899.29 | 1899.55 | 1899.03 | 1899.55 | 1028.0 |
| 2013-12-30 01:00:00 | ES | Futures | 1899.29 | 1900.07 | 1899.29 | 1899.81 | 1519.0 |
| 2013-12-30 02:00:00 | ES | Futures | 1899.55 | 1900.07 | 1899.55 | 1899.55 | 1901.0 |
| 2013-12-30 03:00:00 | ES | Futures | 1899.55 | 1900.07 | 1898.77 | 1899.55 | 5535.0 |
| 2013-12-30 04:00:00 | ES | Futures | 1899.29 | 1899.81 | 1898.77 | 1899.55 | 5371.0 |
| 2013-12-30 05:00:00 | ES | Futures | 1899.55 | 1901.36 | 1899.29 | 1901.1 | 6137.0 |
| 2013-12-30 06:00:00 | ES | Futures | 1901.36 | 1902.14 | 1900.84 | 1901.1 | 4815.0 |
| 2013-12-30 07:00:00 | ES | Futures | 1901.1 | 1901.36 | 1900.07 | 1901.1 | 7434.0 |
| 2013-12-30 08:00:00 | ES | Futures | 1900.84 | 1901.62 | 1899.81 | 1899.81 | 10723.0 |
| 2013-12-30 09:00:00 | ES | Futures | 1900.07 | 1901.62 | 1897.74 | 1898.26 | 105876.0 |
| 2013-12-30 10:00:00 | ES | Futures | 1898.26 | 1899.55 | 1896.96 | 1898.26 | 73098.0 |
| 2013-12-30 11:00:00 | ES | Futures | 1898.26 | 1900.07 | 1897.48 | 1898.26 | 77718.0 |
| 2013-12-30 12:00:00 | ES | Futures | 1898.26 | 1898.77 | 1896.96 | 1897.22 | 36973.0 |
| 2013-12-30 13:00:00 | ES | Futures | 1897.48 | 1898.52 | 1896.96 | 1898.0 | 42084.0 |
| 2013-12-30 14:00:00 | ES | Futures | 1898.0 | 1900.07 | 1897.74 | 1899.29 | 41244.0 |
| 2013-12-30 15:00:00 | ES | Futures | 1899.55 | 1899.55 | 1897.48 | 1899.03 | 91610.0 |
| 2013-12-30 16:00:00 | ES | Futures | 1899.03 | 1899.81 | 1898.0 | 1899.03 | 41168.0 |
| 2013-12-30 17:00:00 | ES | Futures | 1898.77 | 1899.03 | 1898.77 | 1898.77 | 872.0 |
| 2013-12-30 18:00:00 | ES | Futures | 1899.03 | 1899.03 | 1898.26 | 1898.77 | 964.0 |
| 2013-12-30 19:00:00 | ES | Futures | 1898.77 | 1899.03 | 1898.26 | 1898.52 | 1318.0 |
| 2013-12-30 20:00:00 | ES | Futures | 1898.26 | 1898.52 | 1898.0 | 1898.0 | 1084.0 |
| 2013-12-30 21:00:00 | ES | Futures | 1898.0 | 1898.26 | 1897.74 | 1898.26 | 863.0 |
| 2013-12-30 22:00:00 | ES | Futures | 1898.0 | 1898.77 | 1898.0 | 1898.26 | 463.0 |
| 2013-12-30 23:00:00 | ES | Futures | 1898.26 | 1898.52 | 1898.26 | 1898.52 | 363.0 |
| 2013-12-30 00:00:00 | NQ | Futures | 4153.59 | 4153.59 | 4152.43 | 4153.01 | 188.0 |
| 2013-12-30 01:00:00 | NQ | Futures | 4152.72 | 4154.76 | 4152.72 | 4154.18 | 165.0 |
| 2013-12-30 02:00:00 | NQ | Futures | 4153.88 | 4155.05 | 4153.3 | 4154.47 | 172.0 |
| 2013-12-30 03:00:00 | NQ | Futures | 4154.47 | 4154.76 | 4152.14 | 4152.43 | 646.0 |
| 2013-12-30 04:00:00 | NQ | Futures | 4153.01 | 4153.3 | 4150.69 | 4151.85 | 471.0 |
| 2013-12-30 05:00:00 | NQ | Futures | 4151.56 | 4154.18 | 4148.94 | 4152.72 | 916.0 |
| 2013-12-30 06:00:00 | NQ | Futures | 4153.01 | 4153.88 | 4151.85 | 4151.85 | 445.0 |
| 2013-12-30 07:00:00 | NQ | Futures | 4151.27 | 4151.85 | 4148.94 | 4150.11 | 941.0 |
| 2013-12-30 08:00:00 | NQ | Futures | 4150.4 | 4151.56 | 4146.04 | 4146.04 | 1696.0 |
| 2013-12-30 09:00:00 | NQ | Futures | 4146.33 | 4148.65 | 4134.7 | 4139.93 | 17405.0 |
| 2013-12-30 10:00:00 | NQ | Futures | 4139.93 | 4146.04 | 4136.44 | 4141.39 | 13419.0 |
| 2013-12-30 11:00:00 | NQ | Futures | 4141.09 | 4150.11 | 4141.09 | 4146.33 | 14345.0 |
| 2013-12-30 12:00:00 | NQ | Futures | 4146.33 | 4146.91 | 4143.13 | 4144.0 | 7454.0 |
| 2013-12-30 13:00:00 | NQ | Futures | 4144.0 | 4147.49 | 4143.71 | 4145.16 | 6950.0 |
| 2013-12-30 14:00:00 | NQ | Futures | 4145.16 | 4152.43 | 4144.29 | 4150.69 | 6898.0 |
| 2013-12-30 15:00:00 | NQ | Futures | 4150.69 | 4150.69 | 4144.58 | 4146.33 | 14542.0 |
| 2013-12-30 16:00:00 | NQ | Futures | 4146.62 | 4148.36 | 4145.75 | 4148.07 | 1985.0 |
| 2013-12-30 17:00:00 | NQ | Futures | 4148.36 | 4148.36 | 4147.78 | 4148.36 | 56.0 |
| 2013-12-30 18:00:00 | NQ | Futures | 4146.91 | 4148.36 | 4146.91 | 4147.49 | 83.0 |
| 2013-12-30 19:00:00 | NQ | Futures | 4147.49 | 4147.49 | 4146.33 | 4146.33 | 75.0 |
| 2013-12-30 20:00:00 | NQ | Futures | 4146.62 | 4146.62 | 4145.75 | 4146.33 | 101.0 |
| 2013-12-30 21:00:00 | NQ | Futures | 4146.33 | 4146.33 | 4145.16 | 4145.75 | 86.0 |
| 2013-12-30 22:00:00 | NQ | Futures | 4145.75 | 4146.62 | 4145.46 | 4146.04 | 100.0 |
| 2013-12-30 23:00:00 | NQ | Futures | 4146.62 | 4146.91 | 4146.04 | 4146.62 | 27.0 |
| 2013-12-30 00:00:00 | YM | Futures | 16834.0 | 16836.1 | 16829.9 | 16833.0 | 244.0 |
| 2013-12-30 01:00:00 | YM | Futures | 16833.0 | 16838.1 | 16832.0 | 16835.1 | 182.0 |
> showing 50 of 1,498 rows — these rows as CSV