PREVIEW / futures_1hour / 2010-06-01

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-01.parquet
  size:    47 KB
  rows:    1,373

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-01 00:00:00	ES	Futures	1058.12	1058.37	1055.92	1057.88	4553.0
2010-06-01 01:00:00	ES	Futures	1058.12	1061.79	1057.88	1060.08	5345.0
2010-06-01 02:00:00	ES	Futures	1060.08	1063.5	1058.37	1060.57	12517.0
2010-06-01 03:00:00	ES	Futures	1060.57	1061.79	1049.08	1051.77	54685.0
2010-06-01 04:00:00	ES	Futures	1052.01	1053.23	1045.17	1048.1	40637.0
2010-06-01 05:00:00	ES	Futures	1048.1	1049.32	1045.41	1048.59	23869.0
2010-06-01 06:00:00	ES	Futures	1048.83	1050.06	1047.86	1049.57	14337.0
2010-06-01 07:00:00	ES	Futures	1049.57	1052.01	1048.34	1049.81	43966.0
2010-06-01 08:00:00	ES	Futures	1049.81	1051.52	1048.34	1050.3	43606.0
2010-06-01 09:00:00	ES	Futures	1050.06	1059.59	1050.06	1056.41	289806.0
2010-06-01 10:00:00	ES	Futures	1056.17	1070.1	1056.17	1065.94	462213.0
2010-06-01 11:00:00	ES	Futures	1066.19	1066.43	1058.61	1059.59	280429.0
2010-06-01 12:00:00	ES	Futures	1059.34	1064.23	1058.61	1060.32	161219.0
2010-06-01 13:00:00	ES	Futures	1060.08	1068.14	1060.08	1063.01	174478.0
2010-06-01 14:00:00	ES	Futures	1063.25	1064.72	1057.63	1061.54	258046.0
2010-06-01 15:00:00	ES	Futures	1061.54	1062.28	1044.68	1046.14	468187.0
2010-06-01 16:00:00	ES	Futures	1046.14	1047.12	1043.7	1046.39	122946.0
2010-06-01 17:00:00	ES	Futures	1046.14	1046.39	1043.94	1044.19	3169.0
2010-06-01 18:00:00	ES	Futures	1043.7	1045.66	1043.46	1045.66	6184.0
2010-06-01 19:00:00	ES	Futures	1045.66	1047.86	1045.17	1047.61	7594.0
2010-06-01 20:00:00	ES	Futures	1047.86	1049.08	1046.14	1049.08	7803.0
2010-06-01 21:00:00	ES	Futures	1049.08	1052.01	1048.34	1051.77	13433.0
2010-06-01 22:00:00	ES	Futures	1051.77	1052.01	1050.79	1051.52	6165.0
2010-06-01 23:00:00	ES	Futures	1051.52	1051.77	1047.12	1047.86	9288.0
2010-06-01 00:00:00	NQ	Futures	2116.87	2117.44	2113.43	2116.01	468.0
2010-06-01 01:00:00	NQ	Futures	2116.01	2122.59	2116.01	2118.3	840.0
2010-06-01 02:00:00	NQ	Futures	2118.87	2124.88	2116.87	2120.88	1444.0
2010-06-01 03:00:00	NQ	Futures	2120.88	2122.31	2098.25	2103.69	6235.0
2010-06-01 04:00:00	NQ	Futures	2103.69	2106.27	2089.66	2095.39	3742.0
2010-06-01 05:00:00	NQ	Futures	2095.67	2097.68	2090.23	2096.25	2282.0
2010-06-01 06:00:00	NQ	Futures	2096.25	2098.82	2094.24	2097.39	1723.0
2010-06-01 07:00:00	NQ	Futures	2097.39	2103.98	2097.39	2102.83	4929.0
2010-06-01 08:00:00	NQ	Futures	2103.12	2109.42	2102.83	2108.56	8400.0
2010-06-01 09:00:00	NQ	Futures	2108.28	2127.46	2108.28	2118.87	48467.0
2010-06-01 10:00:00	NQ	Futures	2119.16	2151.23	2118.58	2139.78	72712.0
2010-06-01 11:00:00	NQ	Futures	2140.06	2140.64	2122.59	2124.03	35559.0
2010-06-01 12:00:00	NQ	Futures	2124.03	2136.34	2122.02	2129.47	20595.0
2010-06-01 13:00:00	NQ	Futures	2129.18	2146.08	2129.18	2133.48	25143.0
2010-06-01 14:00:00	NQ	Futures	2133.48	2138.34	2124.6	2132.62	31713.0
2010-06-01 15:00:00	NQ	Futures	2133.19	2134.62	2098.54	2100.83	73041.0
2010-06-01 16:00:00	NQ	Futures	2100.83	2101.97	2094.53	2101.4	16953.0
2010-06-01 17:00:00	NQ	Futures	2101.4	2101.69	2098.25	2098.54	560.0
2010-06-01 18:00:00	NQ	Futures	2098.54	2101.4	2097.97	2101.12	654.0
2010-06-01 19:00:00	NQ	Futures	2101.4	2105.98	2101.12	2104.27	772.0
2010-06-01 20:00:00	NQ	Futures	2104.27	2107.42	2101.4	2107.42	535.0
2010-06-01 21:00:00	NQ	Futures	2107.42	2112.86	2106.27	2112.0	670.0
2010-06-01 22:00:00	NQ	Futures	2112.0	2112.57	2110.57	2112.0	464.0
2010-06-01 23:00:00	NQ	Futures	2111.43	2111.43	2102.26	2104.84	718.0
2010-06-01 00:00:00	YM	Futures	9484.1	9487.0	9471.0	9483.2	459.0
2010-06-01 01:00:00	YM	Futures	9484.1	9510.5	9482.3	9499.2	363.0

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

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