PREVIEW / futures_1hour / 2010-07-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	1057.59	1058.08	1056.85	1057.83	3772.0
2010-07-21 01:00:00	ES	Futures	1057.83	1058.08	1056.6	1057.59	6076.0
2010-07-21 02:00:00	ES	Futures	1057.59	1059.55	1057.09	1058.57	11716.0
2010-07-21 03:00:00	ES	Futures	1058.81	1063.97	1058.08	1062.0	39116.0
2010-07-21 04:00:00	ES	Futures	1062.0	1063.72	1060.53	1062.49	20276.0
2010-07-21 05:00:00	ES	Futures	1062.49	1064.95	1062.25	1063.97	20954.0
2010-07-21 06:00:00	ES	Futures	1063.72	1064.46	1061.02	1062.49	17856.0
2010-07-21 07:00:00	ES	Futures	1062.25	1063.97	1061.76	1062.74	30430.0
2010-07-21 08:00:00	ES	Futures	1062.74	1067.65	1062.74	1067.16	75631.0
2010-07-21 09:00:00	ES	Futures	1067.16	1067.4	1057.09	1059.3	332660.0
2010-07-21 10:00:00	ES	Futures	1059.3	1061.51	1056.85	1059.06	280874.0
2010-07-21 11:00:00	ES	Futures	1059.06	1059.55	1054.64	1058.81	239695.0
2010-07-21 12:00:00	ES	Futures	1058.57	1061.27	1057.59	1058.32	151447.0
2010-07-21 13:00:00	ES	Futures	1058.32	1061.51	1057.83	1059.3	80418.0
2010-07-21 14:00:00	ES	Futures	1059.3	1060.28	1041.39	1042.86	563779.0
2010-07-21 15:00:00	ES	Futures	1042.62	1048.02	1041.64	1046.05	402564.0
2010-07-21 16:00:00	ES	Futures	1046.05	1046.3	1042.86	1043.11	89783.0
2010-07-21 17:00:00	ES	Futures	1043.35	1044.34	1042.86	1043.11	1405.0
2010-07-21 18:00:00	ES	Futures	1043.6	1045.07	1042.62	1044.34	2252.0
2010-07-21 19:00:00	ES	Futures	1044.34	1045.56	1044.34	1045.32	2136.0
2010-07-21 20:00:00	ES	Futures	1045.07	1046.05	1043.35	1043.84	9893.0
2010-07-21 21:00:00	ES	Futures	1043.6	1045.32	1043.6	1044.34	5496.0
2010-07-21 22:00:00	ES	Futures	1044.34	1044.58	1042.37	1043.6	4796.0
2010-07-21 23:00:00	ES	Futures	1043.6	1043.6	1042.13	1042.37	2730.0
2010-07-21 00:00:00	NQ	Futures	2115.72	2116.0	2113.42	2115.43	215.0
2010-07-21 01:00:00	NQ	Futures	2115.43	2116.0	2113.42	2113.71	170.0
2010-07-21 02:00:00	NQ	Futures	2113.42	2116.86	2112.85	2114.57	1368.0
2010-07-21 03:00:00	NQ	Futures	2114.57	2122.59	2112.85	2118.01	2625.0
2010-07-21 04:00:00	NQ	Futures	2118.01	2121.73	2115.43	2119.44	1642.0
2010-07-21 05:00:00	NQ	Futures	2119.16	2124.31	2118.87	2121.16	1251.0
2010-07-21 06:00:00	NQ	Futures	2120.88	2122.31	2116.86	2121.73	1946.0
2010-07-21 07:00:00	NQ	Futures	2122.02	2123.74	2120.02	2122.88	3424.0
2010-07-21 08:00:00	NQ	Futures	2122.59	2130.62	2122.31	2130.05	7067.0
2010-07-21 09:00:00	NQ	Futures	2130.05	2132.05	2097.66	2103.68	75094.0
2010-07-21 10:00:00	NQ	Futures	2103.68	2109.13	2096.23	2103.97	54563.0
2010-07-21 11:00:00	NQ	Futures	2103.97	2106.83	2094.51	2106.26	40930.0
2010-07-21 12:00:00	NQ	Futures	2106.55	2114.28	2105.97	2107.69	32044.0
2010-07-21 13:00:00	NQ	Futures	2107.69	2116.29	2106.55	2110.56	17935.0
2010-07-21 14:00:00	NQ	Futures	2110.56	2111.42	2077.03	2079.61	78807.0
2010-07-21 15:00:00	NQ	Futures	2079.61	2090.79	2075.88	2079.9	60218.0
2010-07-21 16:00:00	NQ	Futures	2079.61	2085.05	2078.75	2079.61	10012.0
2010-07-21 17:00:00	NQ	Futures	2079.9	2081.62	2079.04	2079.04	257.0
2010-07-21 18:00:00	NQ	Futures	2080.47	2082.76	2077.6	2081.33	221.0
2010-07-21 19:00:00	NQ	Futures	2081.62	2084.19	2081.33	2083.91	484.0
2010-07-21 20:00:00	NQ	Futures	2083.62	2084.77	2080.18	2081.33	1177.0
2010-07-21 21:00:00	NQ	Futures	2081.9	2085.05	2081.33	2083.34	889.0
2010-07-21 22:00:00	NQ	Futures	2083.05	2083.62	2078.75	2082.48	534.0
2010-07-21 23:00:00	NQ	Futures	2081.9	2081.9	2079.04	2079.9	158.0
2010-07-21 00:00:00	YM	Futures	9612.8	9615.6	9605.2	9612.8	228.0
2010-07-21 01:00:00	YM	Futures	9615.6	9619.4	9606.2	9616.6	210.0

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

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