PREVIEW / futures_1hour / 2008-03-24
file: by_date/futures_1hour/2008/2008-03-24.parquet size: 36 KB rows: 975
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-24 00:00:00 | ES | Futures | 1241.06 | 1241.76 | 1240.59 | 1241.29 | 832.0 |
| 2008-03-24 01:00:00 | ES | Futures | 1241.52 | 1241.99 | 1240.59 | 1241.06 | 1158.0 |
| 2008-03-24 02:00:00 | ES | Futures | 1241.06 | 1241.29 | 1238.03 | 1238.26 | 1594.0 |
| 2008-03-24 03:00:00 | ES | Futures | 1238.26 | 1240.59 | 1237.33 | 1240.36 | 1093.0 |
| 2008-03-24 04:00:00 | ES | Futures | 1240.36 | 1240.59 | 1237.56 | 1240.59 | 778.0 |
| 2008-03-24 05:00:00 | ES | Futures | 1240.59 | 1241.99 | 1239.66 | 1240.82 | 1219.0 |
| 2008-03-24 06:00:00 | ES | Futures | 1240.59 | 1241.99 | 1238.26 | 1238.96 | 1766.0 |
| 2008-03-24 07:00:00 | ES | Futures | 1238.96 | 1243.39 | 1238.26 | 1241.99 | 6193.0 |
| 2008-03-24 08:00:00 | ES | Futures | 1242.22 | 1246.65 | 1241.06 | 1245.95 | 25010.0 |
| 2008-03-24 09:00:00 | ES | Futures | 1245.95 | 1254.1 | 1243.85 | 1253.4 | 215301.0 |
| 2008-03-24 10:00:00 | ES | Futures | 1253.4 | 1263.64 | 1253.16 | 1260.15 | 296954.0 |
| 2008-03-24 11:00:00 | ES | Futures | 1260.38 | 1265.27 | 1258.29 | 1262.25 | 142700.0 |
| 2008-03-24 12:00:00 | ES | Futures | 1262.25 | 1268.07 | 1260.62 | 1265.04 | 139565.0 |
| 2008-03-24 13:00:00 | ES | Futures | 1265.04 | 1266.67 | 1263.88 | 1266.67 | 78787.0 |
| 2008-03-24 14:00:00 | ES | Futures | 1266.67 | 1266.67 | 1259.68 | 1260.38 | 153785.0 |
| 2008-03-24 15:00:00 | ES | Futures | 1260.15 | 1263.41 | 1256.19 | 1258.75 | 255949.0 |
| 2008-03-24 16:00:00 | ES | Futures | 1258.52 | 1260.62 | 1257.82 | 1258.29 | 80942.0 |
| 2008-03-24 17:00:00 | ES | Futures | 1258.29 | 1259.22 | 1257.59 | 1258.75 | 1580.0 |
| 2008-03-24 18:00:00 | ES | Futures | 1258.75 | 1264.11 | 1258.75 | 1262.94 | 11085.0 |
| 2008-03-24 19:00:00 | ES | Futures | 1262.94 | 1262.94 | 1260.85 | 1261.55 | 1435.0 |
| 2008-03-24 20:00:00 | ES | Futures | 1261.55 | 1262.71 | 1259.92 | 1261.08 | 2067.0 |
| 2008-03-24 21:00:00 | ES | Futures | 1261.08 | 1262.94 | 1260.15 | 1260.38 | 2685.0 |
| 2008-03-24 22:00:00 | ES | Futures | 1260.15 | 1261.55 | 1258.29 | 1258.52 | 2223.0 |
| 2008-03-24 23:00:00 | ES | Futures | 1258.52 | 1258.99 | 1258.05 | 1258.05 | 1944.0 |
| 2008-03-24 00:00:00 | NQ | Futures | 1986.02 | 1986.59 | 1984.61 | 1986.59 | 80.0 |
| 2008-03-24 01:00:00 | NQ | Futures | 1987.15 | 1989.42 | 1987.15 | 1989.42 | 289.0 |
| 2008-03-24 02:00:00 | NQ | Futures | 1989.42 | 1989.98 | 1984.61 | 1984.61 | 228.0 |
| 2008-03-24 03:00:00 | NQ | Futures | 1984.61 | 1988.57 | 1982.91 | 1988.0 | 163.0 |
| 2008-03-24 04:00:00 | NQ | Futures | 1987.72 | 1989.42 | 1984.33 | 1989.42 | 141.0 |
| 2008-03-24 05:00:00 | NQ | Futures | 1988.29 | 1991.4 | 1988.29 | 1988.85 | 187.0 |
| 2008-03-24 06:00:00 | NQ | Futures | 1989.13 | 1991.96 | 1986.59 | 1986.59 | 109.0 |
| 2008-03-24 07:00:00 | NQ | Futures | 1986.59 | 1992.24 | 1986.59 | 1990.55 | 569.0 |
| 2008-03-24 08:00:00 | NQ | Futures | 1990.27 | 1999.32 | 1988.57 | 1997.05 | 3632.0 |
| 2008-03-24 09:00:00 | NQ | Futures | 1997.05 | 2017.13 | 1992.81 | 2014.59 | 56889.0 |
| 2008-03-24 10:00:00 | NQ | Futures | 2015.44 | 2049.94 | 2014.59 | 2040.04 | 75770.0 |
| 2008-03-24 11:00:00 | NQ | Futures | 2040.04 | 2056.16 | 2038.91 | 2051.92 | 33031.0 |
| 2008-03-24 12:00:00 | NQ | Futures | 2052.2 | 2065.5 | 2048.81 | 2059.84 | 42012.0 |
| 2008-03-24 13:00:00 | NQ | Futures | 2059.84 | 2066.35 | 2057.01 | 2066.06 | 26135.0 |
| 2008-03-24 14:00:00 | NQ | Futures | 2065.78 | 2066.35 | 2052.2 | 2053.62 | 32173.0 |
| 2008-03-24 15:00:00 | NQ | Futures | 2053.34 | 2062.1 | 2050.51 | 2058.43 | 63848.0 |
| 2008-03-24 16:00:00 | NQ | Futures | 2058.43 | 2062.67 | 2057.01 | 2058.71 | 15759.0 |
| 2008-03-24 17:00:00 | NQ | Futures | 2058.71 | 2060.69 | 2058.14 | 2060.12 | 170.0 |
| 2008-03-24 18:00:00 | NQ | Futures | 2060.69 | 2065.21 | 2060.41 | 2064.93 | 582.0 |
| 2008-03-24 19:00:00 | NQ | Futures | 2064.37 | 2064.37 | 2061.54 | 2061.82 | 305.0 |
| 2008-03-24 20:00:00 | NQ | Futures | 2061.82 | 2064.65 | 2060.12 | 2060.97 | 133.0 |
| 2008-03-24 21:00:00 | NQ | Futures | 2060.41 | 2062.1 | 2060.41 | 2060.69 | 39.0 |
| 2008-03-24 22:00:00 | NQ | Futures | 2060.97 | 2061.54 | 2058.71 | 2060.69 | 202.0 |
| 2008-03-24 23:00:00 | NQ | Futures | 2058.99 | 2060.12 | 2058.43 | 2058.99 | 62.0 |
| 2008-03-24 00:00:00 | YM | Futures | 11254.6 | 11260.9 | 11253.6 | 11259.1 | 42.0 |
| 2008-03-24 01:00:00 | YM | Futures | 11258.2 | 11259.1 | 11250.0 | 11253.6 | 54.0 |
> showing 50 of 975 rows — these rows as CSV