PREVIEW / futures_1hour / 2010-05-31

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-31.parquet
  size:    29 KB
  rows:    839

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-31 00:00:00	ES	Futures	1071.08	1071.08	1069.12	1070.83	2149.0
2010-05-31 01:00:00	ES	Futures	1070.59	1071.56	1068.88	1070.1	3321.0
2010-05-31 02:00:00	ES	Futures	1070.1	1070.59	1066.68	1066.92	5462.0
2010-05-31 03:00:00	ES	Futures	1066.92	1070.34	1066.43	1070.34	6644.0
2010-05-31 04:00:00	ES	Futures	1070.1	1070.34	1067.9	1068.39	3645.0
2010-05-31 05:00:00	ES	Futures	1068.39	1069.12	1067.41	1068.39	2041.0
2010-05-31 06:00:00	ES	Futures	1068.39	1069.36	1067.17	1067.65	2449.0
2010-05-31 07:00:00	ES	Futures	1067.41	1068.63	1067.41	1068.39	2632.0
2010-05-31 08:00:00	ES	Futures	1068.39	1070.34	1068.14	1068.39	3617.0
2010-05-31 09:00:00	ES	Futures	1068.39	1069.85	1067.9	1068.63	5571.0
2010-05-31 10:00:00	ES	Futures	1068.39	1068.88	1067.17	1067.41	7511.0
2010-05-31 11:00:00	ES	Futures	1067.41	1067.65	1064.48	1066.43	9948.0
2010-05-31 18:00:00	ES	Futures	1066.68	1067.9	1064.72	1066.92	5464.0
2010-05-31 19:00:00	ES	Futures	1066.92	1067.17	1064.48	1064.72	2755.0
2010-05-31 20:00:00	ES	Futures	1064.48	1064.72	1055.19	1057.63	19723.0
2010-05-31 21:00:00	ES	Futures	1057.63	1058.85	1055.68	1056.41	9108.0
2010-05-31 22:00:00	ES	Futures	1056.41	1060.57	1056.41	1059.59	7796.0
2010-05-31 23:00:00	ES	Futures	1059.59	1060.32	1057.88	1058.12	2278.0
2010-05-31 00:00:00	NQ	Futures	2136.91	2136.91	2134.05	2136.91	236.0
2010-05-31 01:00:00	NQ	Futures	2136.91	2137.49	2133.76	2134.05	295.0
2010-05-31 02:00:00	NQ	Futures	2134.62	2135.19	2129.47	2129.75	569.0
2010-05-31 03:00:00	NQ	Futures	2129.47	2135.19	2129.47	2134.91	381.0
2010-05-31 04:00:00	NQ	Futures	2135.19	2136.05	2132.9	2134.33	443.0
2010-05-31 05:00:00	NQ	Futures	2133.48	2134.62	2132.04	2132.9	160.0
2010-05-31 06:00:00	NQ	Futures	2133.19	2134.62	2131.76	2131.76	275.0
2010-05-31 07:00:00	NQ	Futures	2132.04	2133.76	2131.76	2133.76	163.0
2010-05-31 08:00:00	NQ	Futures	2134.05	2136.63	2133.48	2133.48	637.0
2010-05-31 09:00:00	NQ	Futures	2133.76	2135.77	2132.04	2134.91	982.0
2010-05-31 10:00:00	NQ	Futures	2134.91	2135.77	2132.9	2134.33	955.0
2010-05-31 11:00:00	NQ	Futures	2133.76	2133.76	2127.75	2131.47	1083.0
2010-05-31 18:00:00	NQ	Futures	2131.18	2132.62	2128.32	2132.33	741.0
2010-05-31 19:00:00	NQ	Futures	2132.33	2132.9	2127.75	2127.75	266.0
2010-05-31 20:00:00	NQ	Futures	2128.03	2128.32	2111.14	2115.72	2351.0
2010-05-31 21:00:00	NQ	Futures	2115.72	2117.73	2111.43	2113.14	1063.0
2010-05-31 22:00:00	NQ	Futures	2113.43	2121.45	2113.14	2120.02	774.0
2010-05-31 23:00:00	NQ	Futures	2120.59	2121.16	2116.01	2116.58	266.0
2010-05-31 00:00:00	YM	Futures	9578.2	9578.2	9568.8	9575.4	255.0
2010-05-31 01:00:00	YM	Futures	9574.5	9583.9	9567.9	9571.6	227.0
2010-05-31 02:00:00	YM	Futures	9572.6	9573.5	9552.8	9554.7	317.0
2010-05-31 03:00:00	YM	Futures	9552.8	9579.2	9550.9	9574.5	408.0
2010-05-31 04:00:00	YM	Futures	9575.4	9577.3	9562.2	9567.9	187.0
2010-05-31 05:00:00	YM	Futures	9564.1	9570.7	9559.4	9566.9	53.0
2010-05-31 06:00:00	YM	Futures	9565.1	9570.7	9557.5	9558.5	86.0
2010-05-31 07:00:00	YM	Futures	9558.5	9565.1	9557.5	9564.1	35.0
2010-05-31 08:00:00	YM	Futures	9566.0	9579.2	9565.1	9566.0	542.0
2010-05-31 09:00:00	YM	Futures	9565.1	9575.4	9557.5	9565.1	392.0
2010-05-31 10:00:00	YM	Futures	9565.1	9567.9	9555.7	9558.5	330.0
2010-05-31 11:00:00	YM	Futures	9557.5	9559.4	9534.0	9550.0	1252.0
2010-05-31 18:00:00	YM	Futures	9556.6	9562.2	9538.7	9555.7	254.0
2010-05-31 19:00:00	YM	Futures	9553.8	9559.4	9535.9	9535.9	225.0

> showing 50 of 839 rows — these rows as CSV

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