PREVIEW / futures_1hour / 2010-03-15
file: by_date/futures_1hour/2010/2010-03-15.parquet size: 41 KB rows: 1,298
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-15 00:00:00 | ES | Futures | 1115.81 | 1116.54 | 1115.81 | 1116.54 | 923.0 |
| 2010-03-15 01:00:00 | ES | Futures | 1116.29 | 1116.78 | 1115.81 | 1116.54 | 593.0 |
| 2010-03-15 02:00:00 | ES | Futures | 1116.54 | 1117.03 | 1116.29 | 1117.03 | 932.0 |
| 2010-03-15 03:00:00 | ES | Futures | 1117.03 | 1117.76 | 1116.29 | 1117.76 | 4213.0 |
| 2010-03-15 04:00:00 | ES | Futures | 1117.76 | 1118.49 | 1116.29 | 1116.54 | 15876.0 |
| 2010-03-15 05:00:00 | ES | Futures | 1116.29 | 1116.54 | 1115.56 | 1116.05 | 11730.0 |
| 2010-03-15 06:00:00 | ES | Futures | 1116.05 | 1117.27 | 1115.81 | 1116.54 | 8187.0 |
| 2010-03-15 07:00:00 | ES | Futures | 1116.78 | 1118.25 | 1116.54 | 1118.01 | 10480.0 |
| 2010-03-15 08:00:00 | ES | Futures | 1118.25 | 1118.98 | 1117.52 | 1118.25 | 23859.0 |
| 2010-03-15 09:00:00 | ES | Futures | 1118.25 | 1119.96 | 1116.29 | 1116.54 | 161988.0 |
| 2010-03-15 10:00:00 | ES | Futures | 1116.29 | 1118.74 | 1115.32 | 1116.29 | 197579.0 |
| 2010-03-15 11:00:00 | ES | Futures | 1116.29 | 1117.03 | 1111.16 | 1112.87 | 252595.0 |
| 2010-03-15 12:00:00 | ES | Futures | 1113.12 | 1114.58 | 1111.9 | 1113.85 | 106688.0 |
| 2010-03-15 13:00:00 | ES | Futures | 1113.85 | 1115.32 | 1113.61 | 1114.83 | 68684.0 |
| 2010-03-15 14:00:00 | ES | Futures | 1115.07 | 1116.54 | 1112.87 | 1116.05 | 128361.0 |
| 2010-03-15 15:00:00 | ES | Futures | 1116.05 | 1120.94 | 1115.56 | 1120.21 | 237452.0 |
| 2010-03-15 16:00:00 | ES | Futures | 1119.96 | 1121.43 | 1119.72 | 1120.69 | 87764.0 |
| 2010-03-15 17:00:00 | ES | Futures | 1120.45 | 1121.43 | 1120.45 | 1121.18 | 1710.0 |
| 2010-03-15 18:00:00 | ES | Futures | 1121.43 | 1121.92 | 1120.69 | 1121.18 | 3631.0 |
| 2010-03-15 19:00:00 | ES | Futures | 1120.94 | 1120.94 | 1120.21 | 1120.69 | 2085.0 |
| 2010-03-15 20:00:00 | ES | Futures | 1120.69 | 1120.94 | 1120.21 | 1120.21 | 1381.0 |
| 2010-03-15 21:00:00 | ES | Futures | 1120.45 | 1122.16 | 1120.21 | 1122.16 | 2848.0 |
| 2010-03-15 22:00:00 | ES | Futures | 1121.92 | 1122.16 | 1121.18 | 1121.67 | 1264.0 |
| 2010-03-15 23:00:00 | ES | Futures | 1121.43 | 1121.67 | 1120.94 | 1120.94 | 1178.0 |
| 2010-03-15 00:00:00 | NQ | Futures | 2195.05 | 2196.19 | 2195.05 | 2195.91 | 58.0 |
| 2010-03-15 01:00:00 | NQ | Futures | 2195.62 | 2196.48 | 2195.62 | 2196.19 | 85.0 |
| 2010-03-15 02:00:00 | NQ | Futures | 2196.48 | 2197.34 | 2196.19 | 2197.05 | 108.0 |
| 2010-03-15 03:00:00 | NQ | Futures | 2197.34 | 2198.2 | 2196.48 | 2198.2 | 295.0 |
| 2010-03-15 04:00:00 | NQ | Futures | 2198.48 | 2199.63 | 2196.48 | 2197.05 | 1023.0 |
| 2010-03-15 05:00:00 | NQ | Futures | 2197.05 | 2197.05 | 2194.76 | 2195.91 | 624.0 |
| 2010-03-15 06:00:00 | NQ | Futures | 2195.91 | 2197.91 | 2195.91 | 2196.76 | 423.0 |
| 2010-03-15 07:00:00 | NQ | Futures | 2197.05 | 2199.63 | 2196.76 | 2199.34 | 648.0 |
| 2010-03-15 08:00:00 | NQ | Futures | 2199.06 | 2199.91 | 2197.62 | 2197.91 | 2055.0 |
| 2010-03-15 09:00:00 | NQ | Futures | 2197.91 | 2202.21 | 2192.47 | 2192.75 | 30285.0 |
| 2010-03-15 10:00:00 | NQ | Futures | 2192.75 | 2197.62 | 2188.17 | 2189.32 | 38034.0 |
| 2010-03-15 11:00:00 | NQ | Futures | 2189.32 | 2191.32 | 2180.73 | 2184.16 | 37381.0 |
| 2010-03-15 12:00:00 | NQ | Futures | 2183.88 | 2186.45 | 2181.59 | 2183.88 | 18082.0 |
| 2010-03-15 13:00:00 | NQ | Futures | 2183.88 | 2186.17 | 2183.02 | 2185.02 | 10989.0 |
| 2010-03-15 14:00:00 | NQ | Futures | 2185.02 | 2189.6 | 2181.01 | 2187.89 | 17158.0 |
| 2010-03-15 15:00:00 | NQ | Futures | 2187.89 | 2197.91 | 2187.6 | 2196.76 | 30771.0 |
| 2010-03-15 16:00:00 | NQ | Futures | 2196.76 | 2197.91 | 2195.33 | 2195.62 | 8562.0 |
| 2010-03-15 17:00:00 | NQ | Futures | 2195.62 | 2197.62 | 2195.62 | 2197.05 | 70.0 |
| 2010-03-15 18:00:00 | NQ | Futures | 2197.05 | 2198.2 | 2196.48 | 2197.34 | 245.0 |
| 2010-03-15 19:00:00 | NQ | Futures | 2196.76 | 2197.34 | 2195.62 | 2197.05 | 102.0 |
| 2010-03-15 20:00:00 | NQ | Futures | 2197.05 | 2197.05 | 2195.62 | 2195.91 | 205.0 |
| 2010-03-15 21:00:00 | NQ | Futures | 2195.91 | 2198.2 | 2195.91 | 2198.2 | 350.0 |
| 2010-03-15 22:00:00 | NQ | Futures | 2198.2 | 2198.48 | 2197.91 | 2197.91 | 108.0 |
| 2010-03-15 23:00:00 | NQ | Futures | 2197.62 | 2197.91 | 2197.05 | 2197.05 | 117.0 |
| 2010-03-15 00:00:00 | YM | Futures | 9912.3 | 9915.1 | 9909.5 | 9912.3 | 126.0 |
| 2010-03-15 01:00:00 | YM | Futures | 9914.2 | 9917.9 | 9911.3 | 9917.0 | 103.0 |
> showing 50 of 1,298 rows — these rows as CSV