PREVIEW / futures_1hour / 2010-05-27

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-27.parquet
  size:    48 KB
  rows:    1,406

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-05-27 00:00:00	ES	Futures	1044.43	1051.77	1043.94	1049.57	15504.0
2010-05-27 01:00:00	ES	Futures	1049.57	1051.52	1048.34	1051.28	7503.0
2010-05-27 02:00:00	ES	Futures	1051.03	1057.88	1050.79	1057.63	29375.0
2010-05-27 03:00:00	ES	Futures	1057.39	1061.54	1056.41	1056.9	54954.0
2010-05-27 04:00:00	ES	Futures	1056.65	1059.59	1054.7	1058.37	34034.0
2010-05-27 05:00:00	ES	Futures	1058.61	1066.43	1058.37	1065.94	60368.0
2010-05-27 06:00:00	ES	Futures	1065.7	1067.65	1062.77	1063.01	53539.0
2010-05-27 07:00:00	ES	Futures	1063.01	1063.74	1060.32	1061.3	48803.0
2010-05-27 08:00:00	ES	Futures	1061.3	1063.99	1056.17	1059.1	144620.0
2010-05-27 09:00:00	ES	Futures	1059.1	1064.97	1058.37	1062.03	351102.0
2010-05-27 10:00:00	ES	Futures	1062.03	1070.34	1058.37	1067.41	438003.0
2010-05-27 11:00:00	ES	Futures	1067.65	1069.61	1064.48	1068.88	286490.0
2010-05-27 12:00:00	ES	Futures	1069.12	1069.36	1065.94	1066.43	127874.0
2010-05-27 13:00:00	ES	Futures	1066.19	1070.34	1063.25	1067.9	175833.0
2010-05-27 14:00:00	ES	Futures	1067.9	1073.28	1067.17	1070.59	185315.0
2010-05-27 15:00:00	ES	Futures	1070.59	1078.41	1068.63	1078.16	355408.0
2010-05-27 16:00:00	ES	Futures	1078.16	1078.16	1074.5	1076.45	141172.0
2010-05-27 17:00:00	ES	Futures	1076.7	1077.68	1075.72	1077.43	2591.0
2010-05-27 18:00:00	ES	Futures	1076.94	1079.39	1075.96	1076.21	7414.0
2010-05-27 19:00:00	ES	Futures	1076.45	1078.16	1075.72	1077.19	4180.0
2010-05-27 20:00:00	ES	Futures	1077.19	1077.92	1072.54	1075.48	15844.0
2010-05-27 21:00:00	ES	Futures	1075.48	1079.14	1075.23	1077.68	6386.0
2010-05-27 22:00:00	ES	Futures	1077.68	1077.92	1074.5	1074.74	3635.0
2010-05-27 23:00:00	ES	Futures	1074.74	1075.48	1072.79	1074.01	4787.0
2010-05-27 00:00:00	NQ	Futures	2065.32	2080.21	2065.03	2076.49	1459.0
2010-05-27 01:00:00	NQ	Futures	2075.91	2078.78	2073.62	2077.92	777.0
2010-05-27 02:00:00	NQ	Futures	2077.92	2090.23	2077.35	2088.8	2461.0
2010-05-27 03:00:00	NQ	Futures	2088.8	2097.39	2088.23	2088.8	4021.0
2010-05-27 04:00:00	NQ	Futures	2088.8	2094.53	2085.65	2091.67	2298.0
2010-05-27 05:00:00	NQ	Futures	2092.24	2107.13	2092.24	2106.56	2785.0
2010-05-27 06:00:00	NQ	Futures	2106.56	2109.42	2100.83	2101.12	3783.0
2010-05-27 07:00:00	NQ	Futures	2100.54	2102.55	2095.39	2096.82	4096.0
2010-05-27 08:00:00	NQ	Futures	2096.82	2103.41	2089.09	2094.82	12094.0
2010-05-27 09:00:00	NQ	Futures	2094.82	2109.99	2093.67	2102.55	47874.0
2010-05-27 10:00:00	NQ	Futures	2102.83	2118.3	2097.11	2109.99	51093.0
2010-05-27 11:00:00	NQ	Futures	2109.99	2116.29	2105.41	2114.0	37967.0
2010-05-27 12:00:00	NQ	Futures	2114.29	2116.58	2109.99	2112.86	26102.0
2010-05-27 13:00:00	NQ	Futures	2113.14	2122.02	2108.28	2116.87	26871.0
2010-05-27 14:00:00	NQ	Futures	2117.15	2126.32	2115.72	2120.88	22969.0
2010-05-27 15:00:00	NQ	Futures	2120.88	2133.76	2118.01	2133.48	53185.0
2010-05-27 16:00:00	NQ	Futures	2133.48	2135.77	2129.18	2134.91	18875.0
2010-05-27 17:00:00	NQ	Futures	2134.05	2142.64	2132.9	2137.49	1022.0
2010-05-27 18:00:00	NQ	Futures	2135.19	2140.35	2134.33	2134.33	635.0
2010-05-27 19:00:00	NQ	Futures	2134.33	2138.06	2133.76	2136.05	381.0
2010-05-27 20:00:00	NQ	Futures	2136.05	2137.77	2128.61	2132.62	1380.0
2010-05-27 21:00:00	NQ	Futures	2132.9	2140.35	2132.62	2137.49	967.0
2010-05-27 22:00:00	NQ	Futures	2136.91	2137.49	2130.04	2130.61	691.0
2010-05-27 23:00:00	NQ	Futures	2130.61	2132.62	2128.32	2130.33	687.0
2010-05-27 00:00:00	YM	Futures	9382.5	9438.0	9380.6	9423.0	910.0
2010-05-27 01:00:00	YM	Futures	9422.0	9435.2	9415.4	9433.3	534.0

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

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