PREVIEW / futures_1hour / 2010-07-20

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-20.parquet
  size:    46 KB
  rows:    1,387

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-07-20 00:00:00	ES	Futures	1046.05	1047.03	1045.32	1045.56	4789.0
2010-07-20 01:00:00	ES	Futures	1045.56	1047.03	1043.35	1043.6	8343.0
2010-07-20 02:00:00	ES	Futures	1043.6	1046.79	1043.35	1045.81	12210.0
2010-07-20 03:00:00	ES	Futures	1045.81	1046.79	1040.41	1040.65	37227.0
2010-07-20 04:00:00	ES	Futures	1040.65	1043.11	1039.92	1042.13	24056.0
2010-07-20 05:00:00	ES	Futures	1041.88	1042.37	1035.5	1036.48	41516.0
2010-07-20 06:00:00	ES	Futures	1036.48	1036.48	1033.05	1035.75	39628.0
2010-07-20 07:00:00	ES	Futures	1035.75	1037.22	1033.78	1036.24	28368.0
2010-07-20 08:00:00	ES	Futures	1036.24	1036.73	1031.33	1035.26	153029.0
2010-07-20 09:00:00	ES	Futures	1035.26	1040.16	1033.54	1038.69	230172.0
2010-07-20 10:00:00	ES	Futures	1038.69	1042.13	1035.5	1040.16	305725.0
2010-07-20 11:00:00	ES	Futures	1040.41	1045.56	1039.92	1041.64	222698.0
2010-07-20 12:00:00	ES	Futures	1041.64	1044.34	1040.16	1043.84	108102.0
2010-07-20 13:00:00	ES	Futures	1044.09	1055.13	1043.35	1054.89	289464.0
2010-07-20 14:00:00	ES	Futures	1054.64	1054.89	1050.47	1052.43	240203.0
2010-07-20 15:00:00	ES	Futures	1052.68	1060.53	1051.45	1059.55	397484.0
2010-07-20 16:00:00	ES	Futures	1059.55	1064.95	1057.34	1061.51	106785.0
2010-07-20 17:00:00	ES	Futures	1061.76	1062.25	1060.53	1060.78	3417.0
2010-07-20 18:00:00	ES	Futures	1060.78	1061.51	1060.04	1060.04	5012.0
2010-07-20 19:00:00	ES	Futures	1060.04	1061.76	1059.79	1061.02	3105.0
2010-07-20 20:00:00	ES	Futures	1061.02	1061.27	1057.83	1057.83	8006.0
2010-07-20 21:00:00	ES	Futures	1058.08	1060.53	1057.34	1058.81	7081.0
2010-07-20 22:00:00	ES	Futures	1058.81	1059.79	1057.59	1059.3	3249.0
2010-07-20 23:00:00	ES	Futures	1059.06	1059.3	1056.6	1057.59	4494.0
2010-07-20 00:00:00	NQ	Futures	2071.59	2072.73	2069.29	2070.44	473.0
2010-07-20 01:00:00	NQ	Futures	2070.44	2075.88	2067.86	2068.43	904.0
2010-07-20 02:00:00	NQ	Futures	2068.72	2074.45	2068.72	2072.73	870.0
2010-07-20 03:00:00	NQ	Futures	2072.45	2074.74	2060.41	2061.27	3674.0
2010-07-20 04:00:00	NQ	Futures	2061.27	2066.14	2060.41	2063.85	1555.0
2010-07-20 05:00:00	NQ	Futures	2063.85	2064.71	2052.67	2054.39	2588.0
2010-07-20 06:00:00	NQ	Futures	2054.39	2054.96	2046.94	2052.39	3174.0
2010-07-20 07:00:00	NQ	Futures	2052.39	2055.25	2049.81	2054.39	2504.0
2010-07-20 08:00:00	NQ	Futures	2053.82	2054.68	2042.36	2053.53	15403.0
2010-07-20 09:00:00	NQ	Futures	2053.53	2056.11	2043.22	2053.25	45675.0
2010-07-20 10:00:00	NQ	Futures	2052.96	2064.14	2044.94	2060.7	51012.0
2010-07-20 11:00:00	NQ	Futures	2060.41	2072.73	2059.84	2065.85	34805.0
2010-07-20 12:00:00	NQ	Futures	2065.57	2072.45	2063.28	2071.87	20647.0
2010-07-20 13:00:00	NQ	Futures	2072.16	2093.36	2070.73	2092.22	49259.0
2010-07-20 14:00:00	NQ	Futures	2092.51	2095.08	2084.48	2089.64	35350.0
2010-07-20 15:00:00	NQ	Futures	2089.93	2109.13	2087.63	2108.27	65392.0
2010-07-20 16:00:00	NQ	Futures	2108.55	2129.19	2101.68	2122.88	20456.0
2010-07-20 17:00:00	NQ	Futures	2123.17	2124.31	2121.16	2122.31	625.0
2010-07-20 18:00:00	NQ	Futures	2120.88	2121.73	2118.87	2119.44	448.0
2010-07-20 19:00:00	NQ	Futures	2119.73	2122.31	2119.44	2121.73	221.0
2010-07-20 20:00:00	NQ	Futures	2121.16	2121.45	2115.72	2116.0	553.0
2010-07-20 21:00:00	NQ	Futures	2116.0	2120.02	2115.14	2117.44	561.0
2010-07-20 22:00:00	NQ	Futures	2117.15	2118.3	2114.28	2117.15	424.0
2010-07-20 23:00:00	NQ	Futures	2116.86	2116.86	2112.56	2115.14	364.0
2010-07-20 00:00:00	YM	Futures	9539.0	9547.5	9534.2	9535.2	795.0
2010-07-20 01:00:00	YM	Futures	9535.2	9546.5	9520.0	9522.9	671.0

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

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