PREVIEW / futures_1hour / 2010-05-20

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-20.parquet
  size:    49 KB
  rows:    1,410

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-20 00:00:00	ES	Futures	1085.99	1086.47	1084.27	1085.5	6460.0
2010-05-20 01:00:00	ES	Futures	1085.5	1086.23	1081.34	1082.81	13276.0
2010-05-20 02:00:00	ES	Futures	1082.56	1085.99	1080.61	1084.76	20080.0
2010-05-20 03:00:00	ES	Futures	1084.76	1090.63	1083.54	1087.94	43558.0
2010-05-20 04:00:00	ES	Futures	1088.19	1088.43	1083.05	1086.72	33138.0
2010-05-20 05:00:00	ES	Futures	1086.96	1087.7	1082.56	1082.81	20284.0
2010-05-20 06:00:00	ES	Futures	1082.81	1084.27	1077.19	1078.9	32814.0
2010-05-20 07:00:00	ES	Futures	1078.9	1079.88	1064.72	1069.12	155236.0
2010-05-20 08:00:00	ES	Futures	1069.12	1072.3	1061.05	1064.23	165797.0
2010-05-20 09:00:00	ES	Futures	1064.48	1069.61	1061.79	1066.19	447762.0
2010-05-20 10:00:00	ES	Futures	1066.19	1068.39	1050.54	1058.61	739209.0
2010-05-20 11:00:00	ES	Futures	1058.85	1065.21	1056.9	1059.1	423362.0
2010-05-20 12:00:00	ES	Futures	1059.34	1062.03	1047.37	1048.34	342155.0
2010-05-20 13:00:00	ES	Futures	1048.1	1063.5	1047.12	1057.88	497833.0
2010-05-20 14:00:00	ES	Futures	1057.88	1069.36	1052.26	1062.03	531598.0
2010-05-20 15:00:00	ES	Futures	1061.79	1064.48	1045.66	1045.9	638075.0
2010-05-20 16:00:00	ES	Futures	1045.9	1048.59	1039.3	1041.5	235737.0
2010-05-20 17:00:00	ES	Futures	1041.5	1041.99	1039.3	1041.26	8489.0
2010-05-20 18:00:00	ES	Futures	1040.52	1043.7	1038.81	1040.28	15848.0
2010-05-20 19:00:00	ES	Futures	1040.52	1043.94	1037.83	1043.21	13842.0
2010-05-20 20:00:00	ES	Futures	1043.46	1045.66	1041.26	1043.46	16175.0
2010-05-20 21:00:00	ES	Futures	1043.46	1047.86	1042.97	1046.88	11219.0
2010-05-20 22:00:00	ES	Futures	1046.88	1050.54	1046.39	1048.59	14423.0
2010-05-20 23:00:00	ES	Futures	1048.59	1052.5	1048.34	1050.54	9754.0
2010-05-20 00:00:00	NQ	Futures	2138.34	2138.63	2134.33	2136.63	324.0
2010-05-20 01:00:00	NQ	Futures	2136.91	2138.34	2129.18	2131.47	918.0
2010-05-20 02:00:00	NQ	Futures	2132.33	2139.2	2128.61	2137.49	1874.0
2010-05-20 03:00:00	NQ	Futures	2137.49	2144.64	2133.19	2140.06	5468.0
2010-05-20 04:00:00	NQ	Futures	2140.35	2140.64	2130.9	2137.77	3036.0
2010-05-20 05:00:00	NQ	Futures	2137.77	2138.92	2130.9	2130.9	1713.0
2010-05-20 06:00:00	NQ	Futures	2130.9	2133.48	2120.3	2123.45	2462.0
2010-05-20 07:00:00	NQ	Futures	2123.45	2125.46	2098.54	2106.84	10107.0
2010-05-20 08:00:00	NQ	Futures	2107.13	2113.43	2095.1	2098.54	12308.0
2010-05-20 09:00:00	NQ	Futures	2098.54	2106.27	2091.95	2097.68	63112.0
2010-05-20 10:00:00	NQ	Futures	2097.68	2103.98	2065.03	2081.64	97915.0
2010-05-20 11:00:00	NQ	Futures	2081.64	2093.38	2077.63	2083.93	53265.0
2010-05-20 12:00:00	NQ	Futures	2084.22	2087.37	2058.16	2059.31	49710.0
2010-05-20 13:00:00	NQ	Futures	2059.31	2090.81	2058.45	2079.92	76457.0
2010-05-20 14:00:00	NQ	Futures	2079.92	2105.98	2069.04	2092.52	78522.0
2010-05-20 15:00:00	NQ	Futures	2092.52	2097.11	2060.74	2061.31	90057.0
2010-05-20 16:00:00	NQ	Futures	2061.02	2063.03	2051.29	2055.01	26576.0
2010-05-20 17:00:00	NQ	Futures	2055.01	2055.87	2051.57	2053.58	698.0
2010-05-20 18:00:00	NQ	Futures	2052.43	2057.3	2051.0	2052.15	2273.0
2010-05-20 19:00:00	NQ	Futures	2052.43	2061.02	2050.71	2059.31	2376.0
2010-05-20 20:00:00	NQ	Futures	2059.31	2064.17	2054.72	2058.73	1483.0
2010-05-20 21:00:00	NQ	Futures	2058.45	2067.04	2057.87	2065.61	946.0
2010-05-20 22:00:00	NQ	Futures	2064.75	2072.76	2064.46	2069.9	1249.0
2010-05-20 23:00:00	NQ	Futures	2069.33	2077.35	2069.04	2074.2	1025.0
2010-05-20 00:00:00	YM	Futures	9800.3	9800.3	9780.5	9790.9	388.0
2010-05-20 01:00:00	YM	Futures	9790.9	9797.5	9756.1	9767.4	1040.0

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

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