PREVIEW / futures_1hour / 2010-09-10
file: by_date/futures_1hour/2010/2010-09-10.parquet size: 38 KB rows: 1,093
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-09-10 00:00:00 | ES | Futures | 1080.65 | 1082.12 | 1080.41 | 1081.39 | 1667.0 |
| 2010-09-10 01:00:00 | ES | Futures | 1081.39 | 1083.84 | 1080.65 | 1083.6 | 3705.0 |
| 2010-09-10 02:00:00 | ES | Futures | 1083.6 | 1083.84 | 1081.63 | 1082.86 | 5350.0 |
| 2010-09-10 03:00:00 | ES | Futures | 1083.11 | 1086.54 | 1082.61 | 1085.31 | 18406.0 |
| 2010-09-10 04:00:00 | ES | Futures | 1085.07 | 1086.05 | 1082.61 | 1085.07 | 9618.0 |
| 2010-09-10 05:00:00 | ES | Futures | 1084.82 | 1085.31 | 1083.11 | 1083.11 | 6670.0 |
| 2010-09-10 06:00:00 | ES | Futures | 1083.35 | 1085.56 | 1083.11 | 1085.31 | 4756.0 |
| 2010-09-10 07:00:00 | ES | Futures | 1085.31 | 1087.28 | 1085.07 | 1086.3 | 11655.0 |
| 2010-09-10 08:00:00 | ES | Futures | 1086.3 | 1086.54 | 1084.58 | 1084.82 | 14783.0 |
| 2010-09-10 09:00:00 | ES | Futures | 1084.82 | 1088.01 | 1082.61 | 1086.54 | 67128.0 |
| 2010-09-10 10:00:00 | ES | Futures | 1086.3 | 1089.49 | 1085.31 | 1088.5 | 56300.0 |
| 2010-09-10 11:00:00 | ES | Futures | 1088.75 | 1088.99 | 1084.33 | 1085.31 | 40611.0 |
| 2010-09-10 12:00:00 | ES | Futures | 1085.31 | 1087.28 | 1083.84 | 1086.3 | 21849.0 |
| 2010-09-10 13:00:00 | ES | Futures | 1086.05 | 1088.26 | 1086.05 | 1087.28 | 17019.0 |
| 2010-09-10 14:00:00 | ES | Futures | 1087.03 | 1089.49 | 1086.79 | 1088.5 | 22838.0 |
| 2010-09-10 15:00:00 | ES | Futures | 1088.5 | 1089.98 | 1087.52 | 1089.24 | 48786.0 |
| 2010-09-10 16:00:00 | ES | Futures | 1088.99 | 1089.49 | 1088.75 | 1088.99 | 22085.0 |
| 2010-09-10 00:00:00 | NQ | Futures | 2158.99 | 2161.57 | 2158.7 | 2160.42 | 72.0 |
| 2010-09-10 01:00:00 | NQ | Futures | 2160.71 | 2165.29 | 2159.56 | 2165.01 | 160.0 |
| 2010-09-10 02:00:00 | NQ | Futures | 2164.43 | 2164.72 | 2160.99 | 2164.15 | 321.0 |
| 2010-09-10 03:00:00 | NQ | Futures | 2164.15 | 2171.02 | 2163.0 | 2169.02 | 994.0 |
| 2010-09-10 04:00:00 | NQ | Futures | 2169.02 | 2169.88 | 2163.86 | 2168.45 | 816.0 |
| 2010-09-10 05:00:00 | NQ | Futures | 2168.45 | 2169.3 | 2165.29 | 2165.29 | 300.0 |
| 2010-09-10 06:00:00 | NQ | Futures | 2165.29 | 2168.45 | 2165.29 | 2168.16 | 341.0 |
| 2010-09-10 07:00:00 | NQ | Futures | 2168.45 | 2171.6 | 2167.3 | 2170.45 | 823.0 |
| 2010-09-10 08:00:00 | NQ | Futures | 2170.16 | 2170.45 | 2166.44 | 2166.73 | 1747.0 |
| 2010-09-10 09:00:00 | NQ | Futures | 2166.73 | 2172.17 | 2158.13 | 2167.3 | 14033.0 |
| 2010-09-10 10:00:00 | NQ | Futures | 2167.3 | 2174.18 | 2163.0 | 2170.45 | 11724.0 |
| 2010-09-10 11:00:00 | NQ | Futures | 2170.74 | 2171.02 | 2158.42 | 2160.13 | 7522.0 |
| 2010-09-10 12:00:00 | NQ | Futures | 2160.13 | 2161.85 | 2154.98 | 2159.56 | 6183.0 |
| 2010-09-10 13:00:00 | NQ | Futures | 2159.56 | 2163.57 | 2158.7 | 2162.43 | 4259.0 |
| 2010-09-10 14:00:00 | NQ | Futures | 2162.43 | 2171.88 | 2162.14 | 2169.02 | 9604.0 |
| 2010-09-10 15:00:00 | NQ | Futures | 2169.02 | 2172.74 | 2166.44 | 2170.16 | 8499.0 |
| 2010-09-10 16:00:00 | NQ | Futures | 2170.16 | 2171.6 | 2168.45 | 2168.45 | 2010.0 |
| 2010-09-10 00:00:00 | YM | Futures | 9837.1 | 9845.7 | 9834.3 | 9840.9 | 55.0 |
| 2010-09-10 01:00:00 | YM | Futures | 9840.9 | 9861.9 | 9837.1 | 9861.9 | 227.0 |
| 2010-09-10 02:00:00 | YM | Futures | 9860.9 | 9860.9 | 9844.8 | 9853.3 | 448.0 |
| 2010-09-10 03:00:00 | YM | Futures | 9857.1 | 9881.9 | 9851.4 | 9865.7 | 1520.0 |
| 2010-09-10 04:00:00 | YM | Futures | 9866.7 | 9872.4 | 9846.7 | 9862.9 | 1119.0 |
| 2010-09-10 05:00:00 | YM | Futures | 9862.9 | 9866.7 | 9849.5 | 9849.5 | 570.0 |
| 2010-09-10 06:00:00 | YM | Futures | 9850.5 | 9867.6 | 9849.5 | 9865.7 | 376.0 |
| 2010-09-10 07:00:00 | YM | Futures | 9865.7 | 9879.0 | 9862.9 | 9874.3 | 444.0 |
| 2010-09-10 08:00:00 | YM | Futures | 9872.4 | 9876.2 | 9860.9 | 9862.9 | 1369.0 |
| 2010-09-10 09:00:00 | YM | Futures | 9862.9 | 9884.8 | 9840.0 | 9869.5 | 11059.0 |
| 2010-09-10 10:00:00 | YM | Futures | 9868.6 | 9893.3 | 9860.9 | 9890.5 | 10765.0 |
| 2010-09-10 11:00:00 | YM | Futures | 9891.4 | 9893.3 | 9856.2 | 9862.9 | 7623.0 |
| 2010-09-10 12:00:00 | YM | Futures | 9863.8 | 9877.1 | 9852.4 | 9869.5 | 5450.0 |
| 2010-09-10 13:00:00 | YM | Futures | 9868.6 | 9888.6 | 9866.7 | 9881.9 | 4633.0 |
| 2010-09-10 14:00:00 | YM | Futures | 9881.0 | 9902.9 | 9879.0 | 9893.3 | 6863.0 |
| 2010-09-10 15:00:00 | YM | Futures | 9893.3 | 9904.8 | 9883.8 | 9900.0 | 6986.0 |
> showing 50 of 1,093 rows — these rows as CSV