PREVIEW / futures_1hour / 2010-06-03

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-03.parquet
  size:    45 KB
  rows:    1,351

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
2010-06-03 00:00:00	ES	Futures	1075.72	1077.43	1074.25	1077.19	4692.0
2010-06-03 01:00:00	ES	Futures	1077.19	1080.12	1076.7	1078.9	9119.0
2010-06-03 02:00:00	ES	Futures	1078.65	1079.63	1076.21	1076.94	17161.0
2010-06-03 03:00:00	ES	Futures	1076.7	1079.39	1075.96	1077.92	32427.0
2010-06-03 04:00:00	ES	Futures	1077.92	1080.12	1077.43	1079.14	18607.0
2010-06-03 05:00:00	ES	Futures	1079.39	1079.88	1076.45	1078.41	14808.0
2010-06-03 06:00:00	ES	Futures	1078.41	1078.41	1074.5	1074.74	25188.0
2010-06-03 07:00:00	ES	Futures	1074.99	1077.19	1074.5	1076.21	26835.0
2010-06-03 08:00:00	ES	Futures	1076.21	1078.41	1074.25	1077.43	65846.0
2010-06-03 09:00:00	ES	Futures	1077.19	1080.61	1074.74	1080.61	242309.0
2010-06-03 10:00:00	ES	Futures	1080.36	1080.36	1072.05	1076.21	360010.0
2010-06-03 11:00:00	ES	Futures	1076.45	1078.41	1073.52	1074.99	189325.0
2010-06-03 12:00:00	ES	Futures	1074.74	1075.23	1066.43	1069.36	246888.0
2010-06-03 13:00:00	ES	Futures	1069.61	1073.03	1067.9	1070.83	135994.0
2010-06-03 14:00:00	ES	Futures	1071.08	1077.19	1069.85	1075.96	202370.0
2010-06-03 15:00:00	ES	Futures	1075.96	1078.9	1072.79	1077.43	254512.0
2010-06-03 16:00:00	ES	Futures	1077.19	1079.63	1076.45	1077.43	81983.0
2010-06-03 17:00:00	ES	Futures	1077.68	1077.92	1075.48	1076.7	4378.0
2010-06-03 18:00:00	ES	Futures	1076.94	1077.43	1075.96	1076.7	2320.0
2010-06-03 19:00:00	ES	Futures	1076.94	1077.92	1076.45	1077.43	2297.0
2010-06-03 20:00:00	ES	Futures	1077.43	1079.39	1076.7	1078.65	7430.0
2010-06-03 21:00:00	ES	Futures	1078.65	1079.14	1077.92	1078.41	2601.0
2010-06-03 22:00:00	ES	Futures	1078.65	1078.9	1075.72	1077.19	6795.0
2010-06-03 23:00:00	ES	Futures	1077.43	1077.92	1076.94	1077.43	1877.0
2010-06-03 00:00:00	NQ	Futures	2156.96	2160.39	2154.67	2158.96	537.0
2010-06-03 01:00:00	NQ	Futures	2158.96	2164.98	2158.68	2162.69	844.0
2010-06-03 02:00:00	NQ	Futures	2162.97	2164.12	2157.24	2158.68	1453.0
2010-06-03 03:00:00	NQ	Futures	2158.39	2163.54	2156.96	2161.54	2912.0
2010-06-03 04:00:00	NQ	Futures	2161.83	2164.4	2161.25	2163.26	1453.0
2010-06-03 05:00:00	NQ	Futures	2163.26	2164.12	2157.53	2161.54	927.0
2010-06-03 06:00:00	NQ	Futures	2161.25	2161.25	2154.95	2154.95	1556.0
2010-06-03 07:00:00	NQ	Futures	2154.95	2158.68	2152.66	2154.67	4160.0
2010-06-03 08:00:00	NQ	Futures	2154.38	2158.68	2152.09	2155.53	9569.0
2010-06-03 09:00:00	NQ	Futures	2155.53	2170.13	2154.09	2169.27	45503.0
2010-06-03 10:00:00	NQ	Futures	2169.56	2169.56	2151.52	2162.4	48704.0
2010-06-03 11:00:00	NQ	Futures	2162.69	2168.13	2158.39	2163.54	31453.0
2010-06-03 12:00:00	NQ	Futures	2163.26	2164.12	2143.21	2152.66	31669.0
2010-06-03 13:00:00	NQ	Futures	2152.95	2161.54	2148.65	2157.53	24292.0
2010-06-03 14:00:00	NQ	Futures	2157.53	2169.85	2155.24	2166.41	25723.0
2010-06-03 15:00:00	NQ	Futures	2166.41	2175.57	2160.11	2170.42	42633.0
2010-06-03 16:00:00	NQ	Futures	2170.42	2175.0	2165.55	2168.13	9025.0
2010-06-03 17:00:00	NQ	Futures	2168.41	2168.7	2164.98	2168.41	627.0
2010-06-03 18:00:00	NQ	Futures	2168.13	2169.27	2166.41	2167.84	148.0
2010-06-03 19:00:00	NQ	Futures	2168.99	2169.85	2166.98	2168.99	102.0
2010-06-03 20:00:00	NQ	Futures	2169.27	2173.0	2168.7	2171.85	575.0
2010-06-03 21:00:00	NQ	Futures	2171.85	2172.71	2170.13	2171.85	299.0
2010-06-03 22:00:00	NQ	Futures	2171.85	2171.85	2166.12	2169.56	564.0
2010-06-03 23:00:00	NQ	Futures	2169.85	2171.28	2168.13	2168.99	276.0
2010-06-03 00:00:00	YM	Futures	9651.6	9666.7	9646.0	9662.9	302.0
2010-06-03 01:00:00	YM	Futures	9663.9	9686.4	9660.1	9677.0	592.0

> showing 50 of 1,351 rows — these rows as CSV

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