PREVIEW / futures_1hour / 2008-03-12
file: by_date/futures_1hour/2008/2008-03-12.parquet size: 42 KB rows: 1,183
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-12 00:00:00 | ES | Futures | 1233.16 | 1233.86 | 1232.23 | 1232.23 | 2968.0 |
| 2008-03-12 01:00:00 | ES | Futures | 1232.23 | 1233.16 | 1232.0 | 1232.93 | 3196.0 |
| 2008-03-12 02:00:00 | ES | Futures | 1232.93 | 1233.63 | 1232.0 | 1232.0 | 2967.0 |
| 2008-03-12 03:00:00 | ES | Futures | 1232.0 | 1234.8 | 1230.6 | 1234.8 | 13841.0 |
| 2008-03-12 04:00:00 | ES | Futures | 1234.56 | 1235.26 | 1230.83 | 1232.7 | 25652.0 |
| 2008-03-12 05:00:00 | ES | Futures | 1232.7 | 1238.99 | 1232.7 | 1238.76 | 23340.0 |
| 2008-03-12 06:00:00 | ES | Futures | 1238.53 | 1240.86 | 1235.26 | 1235.26 | 28253.0 |
| 2008-03-12 07:00:00 | ES | Futures | 1235.26 | 1237.36 | 1232.7 | 1234.56 | 25226.0 |
| 2008-03-12 08:00:00 | ES | Futures | 1234.56 | 1235.03 | 1230.83 | 1232.23 | 44003.0 |
| 2008-03-12 09:00:00 | ES | Futures | 1232.46 | 1237.13 | 1229.2 | 1231.3 | 245149.0 |
| 2008-03-12 10:00:00 | ES | Futures | 1231.53 | 1236.89 | 1227.1 | 1235.96 | 347920.0 |
| 2008-03-12 11:00:00 | ES | Futures | 1235.96 | 1244.35 | 1235.96 | 1236.89 | 382148.0 |
| 2008-03-12 12:00:00 | ES | Futures | 1236.89 | 1237.36 | 1231.3 | 1233.63 | 242320.0 |
| 2008-03-12 13:00:00 | ES | Futures | 1233.63 | 1236.66 | 1228.73 | 1230.37 | 180582.0 |
| 2008-03-12 14:00:00 | ES | Futures | 1230.13 | 1234.56 | 1227.57 | 1230.6 | 208512.0 |
| 2008-03-12 15:00:00 | ES | Futures | 1230.37 | 1230.6 | 1219.87 | 1221.04 | 420035.0 |
| 2008-03-12 16:00:00 | ES | Futures | 1221.27 | 1223.37 | 1220.57 | 1221.74 | 102333.0 |
| 2008-03-12 17:00:00 | ES | Futures | 1221.74 | 1222.2 | 1220.57 | 1221.04 | 3108.0 |
| 2008-03-12 18:00:00 | ES | Futures | 1220.34 | 1220.34 | 1216.61 | 1216.84 | 7752.0 |
| 2008-03-12 19:00:00 | ES | Futures | 1216.84 | 1217.77 | 1216.61 | 1217.54 | 2021.0 |
| 2008-03-12 20:00:00 | ES | Futures | 1217.54 | 1218.01 | 1214.74 | 1216.38 | 3629.0 |
| 2008-03-12 21:00:00 | ES | Futures | 1216.38 | 1216.61 | 1213.81 | 1214.51 | 2933.0 |
| 2008-03-12 22:00:00 | ES | Futures | 1214.51 | 1215.68 | 1214.04 | 1214.98 | 1444.0 |
| 2008-03-12 23:00:00 | ES | Futures | 1214.98 | 1215.21 | 1207.75 | 1208.22 | 12376.0 |
| 2008-03-12 00:00:00 | NQ | Futures | 1986.05 | 1987.19 | 1984.35 | 1985.2 | 283.0 |
| 2008-03-12 01:00:00 | NQ | Futures | 1984.92 | 1985.77 | 1983.78 | 1985.2 | 170.0 |
| 2008-03-12 02:00:00 | NQ | Futures | 1985.2 | 1986.91 | 1983.78 | 1984.35 | 355.0 |
| 2008-03-12 03:00:00 | NQ | Futures | 1984.07 | 1987.76 | 1981.8 | 1986.62 | 1681.0 |
| 2008-03-12 04:00:00 | NQ | Futures | 1987.47 | 1988.61 | 1980.38 | 1983.5 | 619.0 |
| 2008-03-12 05:00:00 | NQ | Futures | 1983.5 | 1996.27 | 1983.5 | 1995.99 | 1837.0 |
| 2008-03-12 06:00:00 | NQ | Futures | 1996.56 | 1998.83 | 1986.62 | 1988.61 | 2817.0 |
| 2008-03-12 07:00:00 | NQ | Futures | 1988.61 | 1990.6 | 1982.36 | 1986.91 | 3761.0 |
| 2008-03-12 08:00:00 | NQ | Futures | 1986.62 | 1987.47 | 1980.66 | 1982.36 | 5912.0 |
| 2008-03-12 09:00:00 | NQ | Futures | 1982.36 | 1987.47 | 1974.42 | 1978.96 | 43881.0 |
| 2008-03-12 10:00:00 | NQ | Futures | 1978.67 | 1994.57 | 1972.43 | 1991.16 | 54164.0 |
| 2008-03-12 11:00:00 | NQ | Futures | 1991.16 | 2005.36 | 1988.32 | 1991.45 | 62622.0 |
| 2008-03-12 12:00:00 | NQ | Futures | 1991.45 | 1997.41 | 1988.61 | 1991.73 | 36291.0 |
| 2008-03-12 13:00:00 | NQ | Futures | 1991.73 | 1998.26 | 1986.62 | 1989.18 | 30752.0 |
| 2008-03-12 14:00:00 | NQ | Futures | 1988.89 | 1995.7 | 1983.22 | 1992.01 | 33057.0 |
| 2008-03-12 15:00:00 | NQ | Futures | 1991.73 | 1992.87 | 1965.9 | 1970.73 | 65649.0 |
| 2008-03-12 16:00:00 | NQ | Futures | 1970.73 | 1974.42 | 1968.74 | 1971.29 | 9222.0 |
| 2008-03-12 17:00:00 | NQ | Futures | 1970.73 | 1971.29 | 1969.59 | 1971.01 | 208.0 |
| 2008-03-12 18:00:00 | NQ | Futures | 1970.73 | 1970.73 | 1965.05 | 1965.05 | 435.0 |
| 2008-03-12 19:00:00 | NQ | Futures | 1965.33 | 1965.9 | 1963.91 | 1965.05 | 248.0 |
| 2008-03-12 20:00:00 | NQ | Futures | 1964.77 | 1964.77 | 1961.36 | 1963.91 | 368.0 |
| 2008-03-12 21:00:00 | NQ | Futures | 1963.06 | 1963.06 | 1959.09 | 1959.37 | 326.0 |
| 2008-03-12 22:00:00 | NQ | Futures | 1959.94 | 1961.64 | 1959.37 | 1961.36 | 97.0 |
| 2008-03-12 23:00:00 | NQ | Futures | 1961.08 | 1961.36 | 1949.44 | 1950.57 | 591.0 |
| 2008-03-12 00:00:00 | YM | Futures | 11072.8 | 11073.7 | 11071.9 | 11073.7 | 56.0 |
| 2008-03-12 01:00:00 | YM | Futures | 11072.8 | 11075.6 | 11071.9 | 11075.6 | 17.0 |
> showing 50 of 1,183 rows — these rows as CSV