PREVIEW / futures_1hour / 2008-04-15
file: by_date/futures_1hour/2008/2008-04-15.parquet size: 41 KB rows: 1,196
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-15 00:00:00 | ES | Futures | 1240.82 | 1241.99 | 1240.59 | 1241.52 | 501.0 |
| 2008-04-15 01:00:00 | ES | Futures | 1241.52 | 1242.22 | 1240.82 | 1241.99 | 615.0 |
| 2008-04-15 02:00:00 | ES | Futures | 1241.99 | 1242.45 | 1240.82 | 1241.52 | 3381.0 |
| 2008-04-15 03:00:00 | ES | Futures | 1241.29 | 1242.45 | 1238.5 | 1239.43 | 12122.0 |
| 2008-04-15 04:00:00 | ES | Futures | 1239.19 | 1240.82 | 1238.5 | 1240.59 | 6594.0 |
| 2008-04-15 05:00:00 | ES | Futures | 1240.36 | 1240.36 | 1237.33 | 1238.73 | 7731.0 |
| 2008-04-15 06:00:00 | ES | Futures | 1238.73 | 1239.43 | 1235.7 | 1236.17 | 9528.0 |
| 2008-04-15 07:00:00 | ES | Futures | 1236.17 | 1242.22 | 1235.47 | 1241.76 | 20789.0 |
| 2008-04-15 08:00:00 | ES | Futures | 1241.76 | 1246.65 | 1237.8 | 1246.41 | 110098.0 |
| 2008-04-15 09:00:00 | ES | Futures | 1246.41 | 1246.88 | 1241.99 | 1241.99 | 188433.0 |
| 2008-04-15 10:00:00 | ES | Futures | 1241.99 | 1243.85 | 1238.03 | 1240.59 | 330908.0 |
| 2008-04-15 11:00:00 | ES | Futures | 1240.36 | 1240.82 | 1234.07 | 1236.17 | 277685.0 |
| 2008-04-15 12:00:00 | ES | Futures | 1236.17 | 1238.5 | 1235.0 | 1237.33 | 120603.0 |
| 2008-04-15 13:00:00 | ES | Futures | 1237.56 | 1243.15 | 1236.87 | 1242.45 | 163859.0 |
| 2008-04-15 14:00:00 | ES | Futures | 1242.22 | 1243.15 | 1238.26 | 1239.19 | 155390.0 |
| 2008-04-15 15:00:00 | ES | Futures | 1238.96 | 1245.95 | 1238.5 | 1245.48 | 257593.0 |
| 2008-04-15 16:00:00 | ES | Futures | 1245.48 | 1252.23 | 1243.15 | 1249.9 | 87112.0 |
| 2008-04-15 17:00:00 | ES | Futures | 1249.9 | 1252.47 | 1248.74 | 1251.77 | 4578.0 |
| 2008-04-15 18:00:00 | ES | Futures | 1251.53 | 1251.77 | 1249.9 | 1250.14 | 3166.0 |
| 2008-04-15 19:00:00 | ES | Futures | 1250.14 | 1250.6 | 1249.21 | 1250.14 | 1842.0 |
| 2008-04-15 20:00:00 | ES | Futures | 1250.14 | 1251.3 | 1249.44 | 1250.6 | 1755.0 |
| 2008-04-15 21:00:00 | ES | Futures | 1250.6 | 1251.77 | 1250.14 | 1251.53 | 2211.0 |
| 2008-04-15 22:00:00 | ES | Futures | 1251.53 | 1252.23 | 1251.07 | 1251.3 | 1620.0 |
| 2008-04-15 23:00:00 | ES | Futures | 1251.3 | 1251.53 | 1250.84 | 1250.84 | 555.0 |
| 2008-04-15 00:00:00 | NQ | Futures | 2035.23 | 2037.5 | 2034.39 | 2035.52 | 181.0 |
| 2008-04-15 01:00:00 | NQ | Futures | 2036.65 | 2037.21 | 2035.52 | 2036.37 | 21.0 |
| 2008-04-15 02:00:00 | NQ | Futures | 2035.8 | 2038.06 | 2035.52 | 2036.65 | 262.0 |
| 2008-04-15 03:00:00 | NQ | Futures | 2035.23 | 2037.78 | 2031.28 | 2032.41 | 1048.0 |
| 2008-04-15 04:00:00 | NQ | Futures | 2032.41 | 2035.8 | 2031.28 | 2035.52 | 376.0 |
| 2008-04-15 05:00:00 | NQ | Futures | 2035.23 | 2035.23 | 2030.43 | 2031.84 | 524.0 |
| 2008-04-15 06:00:00 | NQ | Futures | 2031.28 | 2032.12 | 2026.18 | 2027.6 | 690.0 |
| 2008-04-15 07:00:00 | NQ | Futures | 2027.88 | 2039.19 | 2027.03 | 2037.78 | 3256.0 |
| 2008-04-15 08:00:00 | NQ | Futures | 2037.5 | 2047.4 | 2032.41 | 2044.29 | 11364.0 |
| 2008-04-15 09:00:00 | NQ | Futures | 2044.0 | 2045.98 | 2034.39 | 2034.67 | 37692.0 |
| 2008-04-15 10:00:00 | NQ | Futures | 2034.95 | 2039.76 | 2021.09 | 2025.34 | 57175.0 |
| 2008-04-15 11:00:00 | NQ | Futures | 2025.05 | 2027.32 | 2015.15 | 2020.81 | 44360.0 |
| 2008-04-15 12:00:00 | NQ | Futures | 2021.09 | 2027.32 | 2018.55 | 2025.05 | 26598.0 |
| 2008-04-15 13:00:00 | NQ | Futures | 2025.05 | 2036.08 | 2022.79 | 2033.82 | 32237.0 |
| 2008-04-15 14:00:00 | NQ | Futures | 2033.82 | 2036.08 | 2025.34 | 2027.03 | 24958.0 |
| 2008-04-15 15:00:00 | NQ | Futures | 2026.75 | 2039.48 | 2025.9 | 2036.65 | 44172.0 |
| 2008-04-15 16:00:00 | NQ | Futures | 2036.65 | 2060.97 | 2030.43 | 2057.86 | 15962.0 |
| 2008-04-15 17:00:00 | NQ | Futures | 2057.58 | 2060.69 | 2056.45 | 2060.12 | 1107.0 |
| 2008-04-15 18:00:00 | NQ | Futures | 2060.69 | 2063.23 | 2060.12 | 2060.69 | 1212.0 |
| 2008-04-15 19:00:00 | NQ | Futures | 2060.69 | 2060.69 | 2057.86 | 2059.28 | 391.0 |
| 2008-04-15 20:00:00 | NQ | Futures | 2059.56 | 2062.95 | 2059.28 | 2060.97 | 226.0 |
| 2008-04-15 21:00:00 | NQ | Futures | 2060.97 | 2061.25 | 2058.99 | 2061.25 | 226.0 |
| 2008-04-15 22:00:00 | NQ | Futures | 2061.54 | 2062.1 | 2058.43 | 2058.43 | 435.0 |
| 2008-04-15 23:00:00 | NQ | Futures | 2058.99 | 2058.99 | 2057.86 | 2057.86 | 82.0 |
| 2008-04-15 00:00:00 | YM | Futures | 11200.0 | 11205.5 | 11194.6 | 11199.1 | 54.0 |
| 2008-04-15 01:00:00 | YM | Futures | 11202.8 | 11207.3 | 11196.4 | 11204.6 | 58.0 |
> showing 50 of 1,196 rows — these rows as CSV