PREVIEW / futures_1hour / 2008-01-22

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-22.parquet
  size:    32 KB
  rows:    803

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-01-22 00:00:00	ES	Futures	1177.91	1179.54	1172.54	1174.64	10357.0
2008-01-22 01:00:00	ES	Futures	1174.64	1176.04	1171.14	1172.78	15530.0
2008-01-22 02:00:00	ES	Futures	1173.01	1174.64	1170.91	1170.91	12487.0
2008-01-22 03:00:00	ES	Futures	1170.91	1175.11	1170.91	1174.17	18533.0
2008-01-22 04:00:00	ES	Futures	1173.94	1179.54	1170.91	1178.84	60138.0
2008-01-22 05:00:00	ES	Futures	1178.6	1180.24	1170.91	1176.51	44466.0
2008-01-22 06:00:00	ES	Futures	1176.74	1187.23	1176.51	1182.8	64909.0
2008-01-22 07:00:00	ES	Futures	1182.8	1183.5	1170.91	1174.64	86473.0
2008-01-22 08:00:00	ES	Futures	1174.41	1217.08	1171.14	1182.57	348798.0
2008-01-22 09:00:00	ES	Futures	1182.33	1213.11	1176.97	1200.99	642462.0
2008-01-22 10:00:00	ES	Futures	1201.22	1225.94	1199.36	1218.94	754869.0
2008-01-22 11:00:00	ES	Futures	1218.71	1234.8	1213.81	1216.14	573031.0
2008-01-22 12:00:00	ES	Futures	1216.14	1227.1	1214.74	1225.7	246920.0
2008-01-22 13:00:00	ES	Futures	1225.7	1232.93	1217.77	1222.44	328379.0
2008-01-22 14:00:00	ES	Futures	1222.44	1226.63	1215.91	1222.9	288589.0
2008-01-22 15:00:00	ES	Futures	1223.14	1235.73	1220.81	1224.54	460952.0
2008-01-22 16:00:00	ES	Futures	1224.54	1225.0	1209.15	1213.81	133331.0
2008-01-22 17:00:00	ES	Futures	1213.81	1214.74	1212.65	1213.34	4607.0
2008-01-22 18:00:00	ES	Futures	1214.51	1218.94	1212.65	1218.71	6546.0
2008-01-22 19:00:00	ES	Futures	1218.71	1220.57	1217.31	1218.94	4556.0
2008-01-22 20:00:00	ES	Futures	1219.17	1219.64	1214.98	1218.01	3778.0
2008-01-22 21:00:00	ES	Futures	1217.77	1217.77	1207.75	1208.45	5578.0
2008-01-22 22:00:00	ES	Futures	1208.45	1211.48	1205.88	1206.58	7169.0
2008-01-22 23:00:00	ES	Futures	1206.58	1207.75	1205.42	1205.88	3072.0
2008-01-22 00:00:00	NQ	Futures	2011.32	2011.32	2003.94	2005.07	612.0
2008-01-22 01:00:00	NQ	Futures	2007.06	2007.91	1998.26	2004.5	1025.0
2008-01-22 02:00:00	NQ	Futures	2003.94	2003.94	1980.66	1980.66	3702.0
2008-01-22 03:00:00	NQ	Futures	1980.66	1995.7	1980.66	1995.7	1403.0
2008-01-22 04:00:00	NQ	Futures	1993.43	2008.48	1982.93	2002.23	4827.0
2008-01-22 05:00:00	NQ	Futures	2001.95	2009.61	1986.91	2000.25	1866.0
2008-01-22 06:00:00	NQ	Futures	2001.1	2026.93	2001.1	2018.98	4964.0
2008-01-22 07:00:00	NQ	Futures	2018.98	2019.83	2000.81	2008.19	7739.0
2008-01-22 08:00:00	NQ	Futures	2007.91	2067.52	1990.03	2009.33	49372.0
2008-01-22 09:00:00	NQ	Futures	2008.76	2050.49	1982.65	2032.6	105252.0
2008-01-22 10:00:00	NQ	Futures	2032.32	2061.56	2027.21	2045.38	117362.0
2008-01-22 11:00:00	NQ	Futures	2045.66	2072.63	2036.01	2041.12	97456.0
2008-01-22 12:00:00	NQ	Futures	2041.4	2062.41	2038.57	2056.16	61518.0
2008-01-22 13:00:00	NQ	Futures	2056.45	2070.92	2047.36	2053.89	69337.0
2008-01-22 14:00:00	NQ	Futures	2053.33	2061.27	2043.11	2054.18	51409.0
2008-01-22 15:00:00	NQ	Futures	2054.46	2076.03	2045.38	2049.35	100399.0
2008-01-22 16:00:00	NQ	Futures	2049.07	2054.46	2005.92	2014.72	31260.0
2008-01-22 17:00:00	NQ	Futures	2015.29	2018.7	2013.59	2016.43	1577.0
2008-01-22 18:00:00	NQ	Futures	2018.98	2025.51	2017.56	2025.22	1093.0
2008-01-22 19:00:00	NQ	Futures	2025.51	2027.78	2022.1	2025.79	417.0
2008-01-22 20:00:00	NQ	Futures	2025.79	2026.64	2021.82	2024.09	206.0
2008-01-22 21:00:00	NQ	Futures	2024.09	2024.66	2012.45	2013.02	593.0
2008-01-22 22:00:00	NQ	Futures	2012.74	2015.01	2002.23	2003.37	1455.0
2008-01-22 23:00:00	NQ	Futures	2003.65	2007.34	2002.8	2002.8	263.0
2008-01-22 00:00:00	YM	Futures	10548.6	10557.7	10518.6	10525.9	879.0
2008-01-22 01:00:00	YM	Futures	10525.9	10534.9	10473.2	10505.9	1162.0

> showing 50 of 803 rows — these rows as CSV

> unlock the full archive -- $79 one-time