PREVIEW / futures_1hour / 2010-10-15
file: by_date/futures_1hour/2010/2010-10-15.parquet size: 40 KB rows: 1,154
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-10-15 00:00:00 | ES | Futures | 1156.97 | 1157.46 | 1155.74 | 1156.48 | 2693.0 |
| 2010-10-15 01:00:00 | ES | Futures | 1156.48 | 1158.2 | 1156.23 | 1157.71 | 3999.0 |
| 2010-10-15 02:00:00 | ES | Futures | 1157.71 | 1159.93 | 1156.48 | 1159.19 | 12537.0 |
| 2010-10-15 03:00:00 | ES | Futures | 1159.19 | 1159.44 | 1155.25 | 1155.99 | 30355.0 |
| 2010-10-15 04:00:00 | ES | Futures | 1156.23 | 1157.46 | 1154.51 | 1156.97 | 23112.0 |
| 2010-10-15 05:00:00 | ES | Futures | 1156.97 | 1157.22 | 1154.75 | 1155.74 | 16530.0 |
| 2010-10-15 06:00:00 | ES | Futures | 1155.99 | 1156.73 | 1154.01 | 1155.0 | 22756.0 |
| 2010-10-15 07:00:00 | ES | Futures | 1155.0 | 1155.99 | 1153.77 | 1155.25 | 32978.0 |
| 2010-10-15 08:00:00 | ES | Futures | 1155.25 | 1163.38 | 1155.25 | 1159.44 | 211960.0 |
| 2010-10-15 09:00:00 | ES | Futures | 1159.19 | 1162.89 | 1153.77 | 1154.51 | 402349.0 |
| 2010-10-15 10:00:00 | ES | Futures | 1154.51 | 1156.48 | 1146.62 | 1151.55 | 547283.0 |
| 2010-10-15 11:00:00 | ES | Futures | 1151.8 | 1157.22 | 1151.06 | 1151.8 | 328968.0 |
| 2010-10-15 12:00:00 | ES | Futures | 1151.8 | 1155.99 | 1149.82 | 1153.52 | 268517.0 |
| 2010-10-15 13:00:00 | ES | Futures | 1153.77 | 1155.0 | 1151.3 | 1152.04 | 149240.0 |
| 2010-10-15 14:00:00 | ES | Futures | 1152.04 | 1156.23 | 1150.56 | 1154.26 | 163684.0 |
| 2010-10-15 15:00:00 | ES | Futures | 1154.01 | 1156.73 | 1151.8 | 1155.99 | 252453.0 |
| 2010-10-15 16:00:00 | ES | Futures | 1156.23 | 1158.94 | 1155.49 | 1158.45 | 105647.0 |
| 2010-10-15 00:00:00 | NQ | Futures | 2375.27 | 2375.27 | 2372.11 | 2373.54 | 134.0 |
| 2010-10-15 01:00:00 | NQ | Futures | 2373.54 | 2376.41 | 2373.26 | 2374.98 | 272.0 |
| 2010-10-15 02:00:00 | NQ | Futures | 2374.98 | 2378.42 | 2372.68 | 2377.56 | 763.0 |
| 2010-10-15 03:00:00 | NQ | Futures | 2377.27 | 2377.27 | 2368.95 | 2371.25 | 2385.0 |
| 2010-10-15 04:00:00 | NQ | Futures | 2370.96 | 2373.26 | 2368.09 | 2372.97 | 1359.0 |
| 2010-10-15 05:00:00 | NQ | Futures | 2372.97 | 2372.97 | 2368.38 | 2370.39 | 660.0 |
| 2010-10-15 06:00:00 | NQ | Futures | 2370.39 | 2371.82 | 2367.23 | 2368.38 | 1228.0 |
| 2010-10-15 07:00:00 | NQ | Futures | 2368.38 | 2370.1 | 2365.51 | 2369.53 | 2377.0 |
| 2010-10-15 08:00:00 | NQ | Futures | 2369.53 | 2383.87 | 2369.24 | 2377.27 | 16210.0 |
| 2010-10-15 09:00:00 | NQ | Futures | 2377.27 | 2387.89 | 2370.1 | 2375.27 | 62450.0 |
| 2010-10-15 10:00:00 | NQ | Futures | 2375.27 | 2378.42 | 2364.36 | 2374.41 | 67971.0 |
| 2010-10-15 11:00:00 | NQ | Futures | 2374.41 | 2391.91 | 2373.26 | 2383.3 | 59030.0 |
| 2010-10-15 12:00:00 | NQ | Futures | 2383.3 | 2390.18 | 2379.28 | 2386.17 | 31897.0 |
| 2010-10-15 13:00:00 | NQ | Futures | 2386.46 | 2391.05 | 2384.45 | 2387.03 | 23423.0 |
| 2010-10-15 14:00:00 | NQ | Futures | 2386.74 | 2394.49 | 2383.59 | 2392.48 | 26394.0 |
| 2010-10-15 15:00:00 | NQ | Futures | 2392.48 | 2405.1 | 2387.6 | 2405.1 | 55317.0 |
| 2010-10-15 16:00:00 | NQ | Futures | 2404.82 | 2407.4 | 2404.24 | 2405.68 | 14414.0 |
| 2010-10-15 00:00:00 | YM | Futures | 10529.6 | 10533.5 | 10521.1 | 10525.8 | 96.0 |
| 2010-10-15 01:00:00 | YM | Futures | 10524.9 | 10539.2 | 10523.9 | 10537.3 | 141.0 |
| 2010-10-15 02:00:00 | YM | Futures | 10534.4 | 10550.6 | 10527.7 | 10548.7 | 495.0 |
| 2010-10-15 03:00:00 | YM | Futures | 10546.8 | 10546.8 | 10513.5 | 10523.0 | 1736.0 |
| 2010-10-15 04:00:00 | YM | Futures | 10521.1 | 10531.6 | 10509.6 | 10528.7 | 846.0 |
| 2010-10-15 05:00:00 | YM | Futures | 10529.6 | 10530.6 | 10511.6 | 10520.1 | 491.0 |
| 2010-10-15 06:00:00 | YM | Futures | 10520.1 | 10526.8 | 10505.8 | 10511.6 | 866.0 |
| 2010-10-15 07:00:00 | YM | Futures | 10515.4 | 10523.0 | 10503.9 | 10518.2 | 817.0 |
| 2010-10-15 08:00:00 | YM | Futures | 10518.2 | 10577.3 | 10517.3 | 10546.8 | 9350.0 |
| 2010-10-15 09:00:00 | YM | Futures | 10545.8 | 10567.8 | 10490.6 | 10496.3 | 24186.0 |
| 2010-10-15 10:00:00 | YM | Futures | 10496.3 | 10512.5 | 10433.4 | 10472.5 | 34789.0 |
| 2010-10-15 11:00:00 | YM | Futures | 10472.5 | 10506.8 | 10453.4 | 10461.1 | 16475.0 |
| 2010-10-15 12:00:00 | YM | Futures | 10461.1 | 10485.8 | 10442.0 | 10468.7 | 15269.0 |
| 2010-10-15 13:00:00 | YM | Futures | 10469.6 | 10481.1 | 10450.6 | 10457.3 | 8340.0 |
| 2010-10-15 14:00:00 | YM | Futures | 10457.3 | 10488.7 | 10444.9 | 10471.5 | 10385.0 |
| 2010-10-15 15:00:00 | YM | Futures | 10470.6 | 10492.5 | 10453.4 | 10485.8 | 15979.0 |
> showing 50 of 1,154 rows — these rows as CSV