PREVIEW / futures_1hour / 2008-03-25
file: by_date/futures_1hour/2008/2008-03-25.parquet size: 42 KB rows: 1,214
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-03-25 00:00:00 | ES | Futures | 1258.05 | 1260.62 | 1257.82 | 1258.99 | 1631.0 |
| 2008-03-25 01:00:00 | ES | Futures | 1258.75 | 1259.68 | 1257.82 | 1258.29 | 1009.0 |
| 2008-03-25 02:00:00 | ES | Futures | 1258.05 | 1260.85 | 1257.82 | 1259.92 | 1423.0 |
| 2008-03-25 03:00:00 | ES | Futures | 1260.15 | 1261.08 | 1258.29 | 1260.38 | 5427.0 |
| 2008-03-25 04:00:00 | ES | Futures | 1260.38 | 1261.08 | 1256.42 | 1257.12 | 22482.0 |
| 2008-03-25 05:00:00 | ES | Futures | 1257.36 | 1257.82 | 1255.49 | 1255.96 | 19323.0 |
| 2008-03-25 06:00:00 | ES | Futures | 1255.96 | 1263.41 | 1255.96 | 1262.01 | 24667.0 |
| 2008-03-25 07:00:00 | ES | Futures | 1262.01 | 1266.2 | 1261.78 | 1264.57 | 31126.0 |
| 2008-03-25 08:00:00 | ES | Futures | 1264.34 | 1264.57 | 1257.36 | 1258.05 | 48734.0 |
| 2008-03-25 09:00:00 | ES | Futures | 1257.82 | 1263.64 | 1252.93 | 1252.93 | 277542.0 |
| 2008-03-25 10:00:00 | ES | Futures | 1252.93 | 1256.89 | 1249.9 | 1254.79 | 342368.0 |
| 2008-03-25 11:00:00 | ES | Futures | 1254.79 | 1259.92 | 1253.86 | 1255.73 | 190263.0 |
| 2008-03-25 12:00:00 | ES | Futures | 1255.73 | 1262.71 | 1254.1 | 1259.92 | 152044.0 |
| 2008-03-25 13:00:00 | ES | Futures | 1259.92 | 1265.27 | 1258.52 | 1264.34 | 139582.0 |
| 2008-03-25 14:00:00 | ES | Futures | 1264.81 | 1265.51 | 1260.15 | 1264.34 | 151911.0 |
| 2008-03-25 15:00:00 | ES | Futures | 1264.34 | 1265.97 | 1258.99 | 1260.85 | 221742.0 |
| 2008-03-25 16:00:00 | ES | Futures | 1260.85 | 1261.55 | 1257.82 | 1258.05 | 69965.0 |
| 2008-03-25 17:00:00 | ES | Futures | 1258.05 | 1258.29 | 1256.42 | 1258.05 | 2938.0 |
| 2008-03-25 18:00:00 | ES | Futures | 1257.59 | 1258.05 | 1256.42 | 1257.59 | 2775.0 |
| 2008-03-25 19:00:00 | ES | Futures | 1257.59 | 1257.82 | 1255.03 | 1256.19 | 2791.0 |
| 2008-03-25 20:00:00 | ES | Futures | 1256.19 | 1257.82 | 1254.79 | 1255.26 | 3059.0 |
| 2008-03-25 21:00:00 | ES | Futures | 1255.26 | 1255.49 | 1254.56 | 1255.26 | 2306.0 |
| 2008-03-25 22:00:00 | ES | Futures | 1255.26 | 1256.66 | 1254.56 | 1255.26 | 1962.0 |
| 2008-03-25 23:00:00 | ES | Futures | 1255.73 | 1256.19 | 1254.1 | 1255.73 | 1220.0 |
| 2008-03-25 00:00:00 | NQ | Futures | 2058.99 | 2064.08 | 2058.99 | 2062.39 | 182.0 |
| 2008-03-25 01:00:00 | NQ | Futures | 2060.97 | 2062.67 | 2060.12 | 2060.12 | 42.0 |
| 2008-03-25 02:00:00 | NQ | Futures | 2059.28 | 2062.39 | 2059.28 | 2061.54 | 20.0 |
| 2008-03-25 03:00:00 | NQ | Futures | 2061.25 | 2063.52 | 2059.84 | 2060.69 | 190.0 |
| 2008-03-25 04:00:00 | NQ | Futures | 2061.82 | 2062.67 | 2053.9 | 2055.03 | 1319.0 |
| 2008-03-25 05:00:00 | NQ | Futures | 2055.6 | 2056.16 | 2052.2 | 2054.18 | 666.0 |
| 2008-03-25 06:00:00 | NQ | Futures | 2053.62 | 2065.21 | 2053.34 | 2063.23 | 944.0 |
| 2008-03-25 07:00:00 | NQ | Futures | 2063.23 | 2070.31 | 2063.23 | 2068.89 | 1956.0 |
| 2008-03-25 08:00:00 | NQ | Futures | 2068.89 | 2070.02 | 2061.82 | 2062.39 | 5291.0 |
| 2008-03-25 09:00:00 | NQ | Futures | 2062.67 | 2069.46 | 2051.64 | 2051.92 | 56839.0 |
| 2008-03-25 10:00:00 | NQ | Futures | 2051.64 | 2062.1 | 2043.72 | 2057.3 | 66960.0 |
| 2008-03-25 11:00:00 | NQ | Futures | 2057.01 | 2065.5 | 2054.47 | 2056.16 | 36365.0 |
| 2008-03-25 12:00:00 | NQ | Futures | 2056.16 | 2067.19 | 2053.05 | 2061.54 | 30701.0 |
| 2008-03-25 13:00:00 | NQ | Futures | 2061.54 | 2076.81 | 2057.86 | 2075.11 | 31859.0 |
| 2008-03-25 14:00:00 | NQ | Futures | 2075.11 | 2078.22 | 2068.33 | 2077.38 | 35192.0 |
| 2008-03-25 15:00:00 | NQ | Futures | 2077.38 | 2081.05 | 2068.89 | 2070.02 | 50144.0 |
| 2008-03-25 16:00:00 | NQ | Futures | 2069.74 | 2070.02 | 2064.93 | 2066.35 | 8590.0 |
| 2008-03-25 17:00:00 | NQ | Futures | 2066.35 | 2066.91 | 2064.65 | 2066.06 | 170.0 |
| 2008-03-25 18:00:00 | NQ | Futures | 2065.78 | 2066.91 | 2063.23 | 2066.06 | 158.0 |
| 2008-03-25 19:00:00 | NQ | Futures | 2065.78 | 2065.78 | 2061.82 | 2063.8 | 160.0 |
| 2008-03-25 20:00:00 | NQ | Futures | 2063.8 | 2065.5 | 2060.41 | 2061.54 | 167.0 |
| 2008-03-25 21:00:00 | NQ | Futures | 2061.82 | 2062.67 | 2060.12 | 2062.67 | 84.0 |
| 2008-03-25 22:00:00 | NQ | Futures | 2062.95 | 2063.52 | 2060.12 | 2062.67 | 80.0 |
| 2008-03-25 23:00:00 | NQ | Futures | 2062.39 | 2062.95 | 2060.12 | 2060.12 | 151.0 |
| 2008-03-25 00:00:00 | YM | Futures | 11389.9 | 11408.1 | 11389.9 | 11398.1 | 141.0 |
| 2008-03-25 01:00:00 | YM | Futures | 11396.3 | 11399.0 | 11388.1 | 11394.5 | 72.0 |
> showing 50 of 1,214 rows — these rows as CSV