PREVIEW / futures_1hour / 2015-02-10
file: by_date/futures_1hour/2015/2015-02-10.parquet size: 51 KB rows: 1,565
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-02-10 00:00:00 | ES | Futures | 2151.27 | 2154.42 | 2151.0 | 2152.58 | 2480.0 |
| 2015-02-10 01:00:00 | ES | Futures | 2152.58 | 2152.58 | 2151.79 | 2152.32 | 1286.0 |
| 2015-02-10 02:00:00 | ES | Futures | 2152.32 | 2155.48 | 2151.79 | 2152.06 | 6434.0 |
| 2015-02-10 03:00:00 | ES | Futures | 2152.06 | 2154.95 | 2148.37 | 2150.48 | 24315.0 |
| 2015-02-10 04:00:00 | ES | Futures | 2150.48 | 2151.53 | 2147.85 | 2151.0 | 12877.0 |
| 2015-02-10 05:00:00 | ES | Futures | 2150.74 | 2154.16 | 2150.74 | 2151.0 | 13262.0 |
| 2015-02-10 06:00:00 | ES | Futures | 2151.0 | 2154.69 | 2151.0 | 2153.63 | 10856.0 |
| 2015-02-10 07:00:00 | ES | Futures | 2153.9 | 2167.32 | 2153.9 | 2159.69 | 68918.0 |
| 2015-02-10 08:00:00 | ES | Futures | 2159.69 | 2166.0 | 2159.16 | 2163.11 | 44199.0 |
| 2015-02-10 09:00:00 | ES | Futures | 2163.11 | 2164.42 | 2154.95 | 2156.27 | 185755.0 |
| 2015-02-10 10:00:00 | ES | Futures | 2156.0 | 2160.21 | 2150.74 | 2155.21 | 226445.0 |
| 2015-02-10 11:00:00 | ES | Futures | 2155.21 | 2161.27 | 2153.63 | 2160.48 | 172336.0 |
| 2015-02-10 12:00:00 | ES | Futures | 2160.74 | 2165.74 | 2158.37 | 2163.9 | 131549.0 |
| 2015-02-10 13:00:00 | ES | Futures | 2163.9 | 2165.48 | 2160.74 | 2161.53 | 82718.0 |
| 2015-02-10 14:00:00 | ES | Futures | 2161.79 | 2172.84 | 2161.53 | 2172.84 | 127771.0 |
| 2015-02-10 15:00:00 | ES | Futures | 2172.84 | 2175.21 | 2170.48 | 2171.79 | 190252.0 |
| 2015-02-10 16:00:00 | ES | Futures | 2171.79 | 2172.06 | 2169.95 | 2171.53 | 55666.0 |
| 2015-02-10 17:00:00 | ES | Futures | 2171.27 | 2171.79 | 2170.74 | 2171.0 | 1659.0 |
| 2015-02-10 18:00:00 | ES | Futures | 2171.27 | 2172.58 | 2170.48 | 2171.0 | 4284.0 |
| 2015-02-10 19:00:00 | ES | Futures | 2171.27 | 2171.79 | 2170.21 | 2171.27 | 1864.0 |
| 2015-02-10 20:00:00 | ES | Futures | 2171.53 | 2171.53 | 2169.95 | 2170.74 | 1772.0 |
| 2015-02-10 21:00:00 | ES | Futures | 2170.48 | 2171.0 | 2168.9 | 2169.16 | 2093.0 |
| 2015-02-10 22:00:00 | ES | Futures | 2169.42 | 2169.42 | 2168.63 | 2168.9 | 1593.0 |
| 2015-02-10 23:00:00 | ES | Futures | 2168.9 | 2169.42 | 2168.63 | 2168.9 | 1709.0 |
| 2015-02-10 00:00:00 | NQ | Futures | 4954.52 | 4961.28 | 4952.47 | 4957.46 | 434.0 |
| 2015-02-10 01:00:00 | NQ | Futures | 4957.17 | 4958.05 | 4955.7 | 4957.75 | 319.0 |
| 2015-02-10 02:00:00 | NQ | Futures | 4959.22 | 4965.98 | 4956.87 | 4957.17 | 1435.0 |
| 2015-02-10 03:00:00 | NQ | Futures | 4957.17 | 4963.33 | 4946.89 | 4952.17 | 4098.0 |
| 2015-02-10 04:00:00 | NQ | Futures | 4952.76 | 4957.17 | 4947.77 | 4956.29 | 1537.0 |
| 2015-02-10 05:00:00 | NQ | Futures | 4956.87 | 4963.63 | 4954.23 | 4955.11 | 2382.0 |
| 2015-02-10 06:00:00 | NQ | Futures | 4955.4 | 4963.92 | 4955.11 | 4960.98 | 1618.0 |
| 2015-02-10 07:00:00 | NQ | Futures | 4961.57 | 4992.12 | 4961.57 | 4974.79 | 12121.0 |
| 2015-02-10 08:00:00 | NQ | Futures | 4974.79 | 4985.65 | 4973.03 | 4978.02 | 6796.0 |
| 2015-02-10 09:00:00 | NQ | Futures | 4978.02 | 4987.71 | 4968.62 | 4979.19 | 35513.0 |
| 2015-02-10 10:00:00 | NQ | Futures | 4978.9 | 4986.24 | 4966.86 | 4979.19 | 37580.0 |
| 2015-02-10 11:00:00 | NQ | Futures | 4979.49 | 4999.16 | 4975.67 | 4997.99 | 25474.0 |
| 2015-02-10 12:00:00 | NQ | Futures | 4997.99 | 5008.56 | 4992.12 | 5007.09 | 19629.0 |
| 2015-02-10 13:00:00 | NQ | Futures | 5006.8 | 5011.21 | 4999.16 | 5003.57 | 15421.0 |
| 2015-02-10 14:00:00 | NQ | Futures | 5003.86 | 5026.18 | 5003.28 | 5026.18 | 20133.0 |
| 2015-02-10 15:00:00 | NQ | Futures | 5025.6 | 5032.64 | 5021.19 | 5025.01 | 31482.0 |
| 2015-02-10 16:00:00 | NQ | Futures | 5025.01 | 5027.06 | 5022.66 | 5025.89 | 6575.0 |
| 2015-02-10 17:00:00 | NQ | Futures | 5025.6 | 5027.06 | 5025.01 | 5025.01 | 373.0 |
| 2015-02-10 18:00:00 | NQ | Futures | 5025.89 | 5029.12 | 5025.01 | 5026.18 | 450.0 |
| 2015-02-10 19:00:00 | NQ | Futures | 5026.18 | 5027.65 | 5024.71 | 5027.06 | 265.0 |
| 2015-02-10 20:00:00 | NQ | Futures | 5026.77 | 5027.06 | 5023.54 | 5024.71 | 425.0 |
| 2015-02-10 21:00:00 | NQ | Futures | 5024.71 | 5025.01 | 5021.19 | 5022.95 | 403.0 |
| 2015-02-10 22:00:00 | NQ | Futures | 5022.66 | 5023.54 | 5021.48 | 5022.66 | 319.0 |
| 2015-02-10 23:00:00 | NQ | Futures | 5022.66 | 5024.13 | 5022.37 | 5022.95 | 473.0 |
| 2015-02-10 00:00:00 | YM | Futures | 18469.3 | 18493.3 | 18467.2 | 18480.8 | 403.0 |
| 2015-02-10 01:00:00 | YM | Futures | 18478.7 | 18478.7 | 18474.5 | 18477.7 | 187.0 |
> showing 50 of 1,565 rows — these rows as CSV