PREVIEW / futures_1hour / 2010-06-25

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-25.parquet
  size:    38 KB
  rows:    1,088

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-25 00:00:00	ES	Futures	1052.19	1052.43	1050.72	1052.43	4374.0
2010-06-25 01:00:00	ES	Futures	1052.43	1053.91	1052.43	1053.91	4344.0
2010-06-25 02:00:00	ES	Futures	1054.15	1054.15	1050.96	1052.92	8752.0
2010-06-25 03:00:00	ES	Futures	1052.92	1055.87	1050.72	1053.91	37727.0
2010-06-25 04:00:00	ES	Futures	1053.91	1054.89	1048.26	1049.0	37639.0
2010-06-25 05:00:00	ES	Futures	1048.75	1049.49	1045.56	1047.77	37917.0
2010-06-25 06:00:00	ES	Futures	1047.77	1051.45	1047.28	1051.45	24769.0
2010-06-25 07:00:00	ES	Futures	1051.21	1055.38	1050.22	1054.4	47912.0
2010-06-25 08:00:00	ES	Futures	1054.4	1054.64	1047.77	1050.22	103467.0
2010-06-25 09:00:00	ES	Futures	1050.22	1052.92	1046.3	1049.98	277808.0
2010-06-25 10:00:00	ES	Futures	1050.22	1053.66	1043.11	1044.34	400249.0
2010-06-25 11:00:00	ES	Futures	1044.34	1050.96	1044.09	1049.24	255989.0
2010-06-25 12:00:00	ES	Futures	1049.0	1052.43	1047.77	1049.73	188009.0
2010-06-25 13:00:00	ES	Futures	1049.73	1059.55	1049.24	1057.59	256220.0
2010-06-25 14:00:00	ES	Futures	1057.59	1059.06	1055.38	1056.85	146663.0
2010-06-25 15:00:00	ES	Futures	1056.6	1057.59	1050.72	1054.4	414428.0
2010-06-25 16:00:00	ES	Futures	1054.4	1055.13	1050.96	1054.89	154232.0
2010-06-25 00:00:00	NQ	Futures	2116.0	2117.44	2113.71	2116.29	369.0
2010-06-25 01:00:00	NQ	Futures	2116.58	2120.3	2116.0	2120.3	251.0
2010-06-25 02:00:00	NQ	Futures	2120.02	2120.02	2115.43	2118.87	881.0
2010-06-25 03:00:00	NQ	Futures	2118.58	2126.32	2114.0	2121.45	3269.0
2010-06-25 04:00:00	NQ	Futures	2121.73	2122.88	2111.13	2113.42	2883.0
2010-06-25 05:00:00	NQ	Futures	2113.42	2114.28	2105.97	2110.27	2208.0
2010-06-25 06:00:00	NQ	Futures	2110.56	2117.44	2109.41	2117.44	1644.0
2010-06-25 07:00:00	NQ	Futures	2117.44	2124.31	2114.28	2122.59	3013.0
2010-06-25 08:00:00	NQ	Futures	2122.31	2122.59	2110.56	2118.01	11625.0
2010-06-25 09:00:00	NQ	Futures	2117.72	2122.59	2099.38	2109.13	45470.0
2010-06-25 10:00:00	NQ	Futures	2109.13	2117.15	2094.51	2097.09	54004.0
2010-06-25 11:00:00	NQ	Futures	2097.38	2109.41	2096.8	2105.97	38877.0
2010-06-25 12:00:00	NQ	Futures	2105.97	2116.0	2103.39	2109.41	30801.0
2010-06-25 13:00:00	NQ	Futures	2109.41	2128.04	2108.27	2122.88	36769.0
2010-06-25 14:00:00	NQ	Futures	2123.17	2125.46	2115.43	2118.3	22811.0
2010-06-25 15:00:00	NQ	Futures	2118.58	2120.02	2106.26	2109.41	48696.0
2010-06-25 16:00:00	NQ	Futures	2109.41	2109.7	2102.25	2108.55	15562.0
2010-06-25 00:00:00	YM	Futures	9568.3	9571.1	9561.7	9569.2	126.0
2010-06-25 01:00:00	YM	Futures	9572.1	9582.5	9571.1	9582.5	187.0
2010-06-25 02:00:00	YM	Futures	9584.4	9585.3	9561.7	9576.8	826.0
2010-06-25 03:00:00	YM	Futures	9575.9	9595.8	9556.9	9582.5	2696.0
2010-06-25 04:00:00	YM	Futures	9583.4	9591.0	9540.8	9543.7	2267.0
2010-06-25 05:00:00	YM	Futures	9542.7	9547.5	9519.1	9537.1	1820.0
2010-06-25 06:00:00	YM	Futures	9536.1	9562.6	9532.3	9562.6	1167.0
2010-06-25 07:00:00	YM	Futures	9561.7	9592.0	9553.2	9587.2	1592.0
2010-06-25 08:00:00	YM	Futures	9586.3	9587.2	9535.2	9556.0	6063.0
2010-06-25 09:00:00	YM	Futures	9555.0	9578.7	9517.2	9548.4	20011.0
2010-06-25 10:00:00	YM	Futures	9547.5	9573.0	9485.0	9491.6	28122.0
2010-06-25 11:00:00	YM	Futures	9492.6	9540.8	9489.7	9524.8	19016.0
2010-06-25 12:00:00	YM	Futures	9525.7	9554.1	9516.2	9530.4	14447.0
2010-06-25 13:00:00	YM	Futures	9530.4	9599.5	9525.7	9585.3	17718.0
2010-06-25 14:00:00	YM	Futures	9585.3	9598.6	9566.4	9577.8	10560.0
2010-06-25 15:00:00	YM	Futures	9576.8	9588.2	9539.0	9572.1	23990.0

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

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