PREVIEW / futures_1hour / 2009-11-11
file: by_date/futures_1hour/2009/2009-11-11.parquet size: 44 KB rows: 1,307
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-11 00:00:00 | ES | Futures | 1059.24 | 1060.45 | 1059.24 | 1059.96 | 2713.0 |
| 2009-11-11 01:00:00 | ES | Futures | 1059.96 | 1060.2 | 1058.99 | 1059.72 | 3797.0 |
| 2009-11-11 02:00:00 | ES | Futures | 1059.72 | 1062.87 | 1059.72 | 1062.63 | 9874.0 |
| 2009-11-11 03:00:00 | ES | Futures | 1062.63 | 1063.6 | 1061.9 | 1062.63 | 25002.0 |
| 2009-11-11 04:00:00 | ES | Futures | 1062.87 | 1067.71 | 1062.38 | 1066.74 | 39433.0 |
| 2009-11-11 05:00:00 | ES | Futures | 1066.74 | 1067.23 | 1064.32 | 1065.29 | 21120.0 |
| 2009-11-11 06:00:00 | ES | Futures | 1065.53 | 1066.26 | 1065.05 | 1066.02 | 16529.0 |
| 2009-11-11 07:00:00 | ES | Futures | 1066.26 | 1067.47 | 1064.81 | 1065.05 | 35482.0 |
| 2009-11-11 08:00:00 | ES | Futures | 1065.29 | 1065.78 | 1064.08 | 1064.56 | 25329.0 |
| 2009-11-11 09:00:00 | ES | Futures | 1064.32 | 1065.53 | 1061.17 | 1065.05 | 222300.0 |
| 2009-11-11 10:00:00 | ES | Futures | 1065.05 | 1068.92 | 1059.72 | 1061.66 | 440148.0 |
| 2009-11-11 11:00:00 | ES | Futures | 1061.42 | 1062.38 | 1057.54 | 1059.48 | 279137.0 |
| 2009-11-11 12:00:00 | ES | Futures | 1059.24 | 1063.35 | 1058.51 | 1060.93 | 156782.0 |
| 2009-11-11 13:00:00 | ES | Futures | 1060.93 | 1062.63 | 1057.3 | 1058.99 | 129859.0 |
| 2009-11-11 14:00:00 | ES | Futures | 1058.99 | 1062.63 | 1058.51 | 1061.9 | 105807.0 |
| 2009-11-11 15:00:00 | ES | Futures | 1061.66 | 1062.87 | 1059.24 | 1062.38 | 174877.0 |
| 2009-11-11 16:00:00 | ES | Futures | 1062.38 | 1063.35 | 1061.66 | 1061.9 | 70512.0 |
| 2009-11-11 17:00:00 | ES | Futures | 1061.66 | 1062.63 | 1061.66 | 1062.14 | 1886.0 |
| 2009-11-11 18:00:00 | ES | Futures | 1062.38 | 1062.63 | 1061.42 | 1062.63 | 3418.0 |
| 2009-11-11 19:00:00 | ES | Futures | 1062.38 | 1064.08 | 1062.14 | 1063.6 | 4436.0 |
| 2009-11-11 20:00:00 | ES | Futures | 1063.84 | 1063.84 | 1062.38 | 1062.63 | 2577.0 |
| 2009-11-11 21:00:00 | ES | Futures | 1062.63 | 1063.11 | 1061.42 | 1061.66 | 3500.0 |
| 2009-11-11 22:00:00 | ES | Futures | 1061.9 | 1062.14 | 1058.99 | 1059.24 | 5044.0 |
| 2009-11-11 23:00:00 | ES | Futures | 1059.24 | 1059.72 | 1058.02 | 1058.27 | 5324.0 |
| 2009-11-11 00:00:00 | NQ | Futures | 2023.45 | 2025.45 | 2022.6 | 2024.88 | 222.0 |
| 2009-11-11 01:00:00 | NQ | Futures | 2024.31 | 2024.88 | 2022.88 | 2024.31 | 95.0 |
| 2009-11-11 02:00:00 | NQ | Futures | 2024.59 | 2029.16 | 2024.31 | 2028.59 | 1279.0 |
| 2009-11-11 03:00:00 | NQ | Futures | 2028.59 | 2030.58 | 2028.02 | 2028.87 | 3706.0 |
| 2009-11-11 04:00:00 | NQ | Futures | 2028.87 | 2039.42 | 2028.87 | 2037.14 | 3241.0 |
| 2009-11-11 05:00:00 | NQ | Futures | 2037.43 | 2038.0 | 2033.43 | 2035.43 | 1925.0 |
| 2009-11-11 06:00:00 | NQ | Futures | 2035.43 | 2039.42 | 2035.15 | 2038.85 | 2048.0 |
| 2009-11-11 07:00:00 | NQ | Futures | 2038.57 | 2040.56 | 2037.14 | 2037.71 | 3056.0 |
| 2009-11-11 08:00:00 | NQ | Futures | 2037.43 | 2037.71 | 2034.86 | 2035.43 | 2716.0 |
| 2009-11-11 09:00:00 | NQ | Futures | 2035.43 | 2039.71 | 2031.15 | 2038.28 | 39940.0 |
| 2009-11-11 10:00:00 | NQ | Futures | 2038.0 | 2044.84 | 2028.02 | 2028.59 | 60852.0 |
| 2009-11-11 11:00:00 | NQ | Futures | 2028.87 | 2031.44 | 2021.46 | 2025.73 | 40746.0 |
| 2009-11-11 12:00:00 | NQ | Futures | 2025.73 | 2032.29 | 2024.59 | 2026.87 | 26991.0 |
| 2009-11-11 13:00:00 | NQ | Futures | 2026.87 | 2030.58 | 2020.03 | 2023.45 | 25552.0 |
| 2009-11-11 14:00:00 | NQ | Futures | 2023.45 | 2032.29 | 2022.88 | 2030.01 | 23175.0 |
| 2009-11-11 15:00:00 | NQ | Futures | 2030.01 | 2033.72 | 2026.3 | 2032.58 | 35412.0 |
| 2009-11-11 16:00:00 | NQ | Futures | 2032.58 | 2036.29 | 2032.29 | 2034.29 | 15066.0 |
| 2009-11-11 17:00:00 | NQ | Futures | 2034.0 | 2035.43 | 2033.43 | 2034.0 | 186.0 |
| 2009-11-11 18:00:00 | NQ | Futures | 2035.43 | 2035.72 | 2032.86 | 2034.86 | 340.0 |
| 2009-11-11 19:00:00 | NQ | Futures | 2034.86 | 2037.43 | 2034.86 | 2036.29 | 405.0 |
| 2009-11-11 20:00:00 | NQ | Futures | 2036.57 | 2037.14 | 2034.58 | 2035.15 | 190.0 |
| 2009-11-11 21:00:00 | NQ | Futures | 2035.43 | 2035.72 | 2033.15 | 2033.72 | 213.0 |
| 2009-11-11 22:00:00 | NQ | Futures | 2033.72 | 2034.29 | 2028.87 | 2029.44 | 364.0 |
| 2009-11-11 23:00:00 | NQ | Futures | 2029.44 | 2029.73 | 2027.45 | 2028.59 | 433.0 |
| 2009-11-11 00:00:00 | YM | Futures | 9519.5 | 9526.0 | 9517.6 | 9526.0 | 193.0 |
| 2009-11-11 01:00:00 | YM | Futures | 9525.1 | 9526.0 | 9517.6 | 9522.3 | 222.0 |
> showing 50 of 1,307 rows — these rows as CSV