PREVIEW / futures_1hour / 2010-05-18

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-18.parquet
  size:    48 KB
  rows:    1,388

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-18 00:00:00	ES	Futures	1108.23	1108.96	1107.01	1107.25	2646.0
2010-05-18 01:00:00	ES	Futures	1107.01	1108.96	1105.78	1108.47	7345.0
2010-05-18 02:00:00	ES	Futures	1108.72	1114.09	1107.98	1113.85	18632.0
2010-05-18 03:00:00	ES	Futures	1113.61	1116.54	1111.65	1113.61	38630.0
2010-05-18 04:00:00	ES	Futures	1113.61	1115.56	1111.41	1111.65	35172.0
2010-05-18 05:00:00	ES	Futures	1111.41	1113.36	1110.18	1112.63	18952.0
2010-05-18 06:00:00	ES	Futures	1112.87	1115.81	1111.9	1115.07	22342.0
2010-05-18 07:00:00	ES	Futures	1114.83	1117.27	1113.85	1116.54	33457.0
2010-05-18 08:00:00	ES	Futures	1116.29	1118.98	1114.83	1118.01	75984.0
2010-05-18 09:00:00	ES	Futures	1118.25	1121.92	1116.54	1117.76	254287.0
2010-05-18 10:00:00	ES	Futures	1117.76	1119.23	1107.74	1110.67	500613.0
2010-05-18 11:00:00	ES	Futures	1110.67	1114.34	1105.54	1106.76	306119.0
2010-05-18 12:00:00	ES	Futures	1107.01	1111.65	1103.1	1106.52	258137.0
2010-05-18 13:00:00	ES	Futures	1106.52	1107.74	1097.96	1098.21	407617.0
2010-05-18 14:00:00	ES	Futures	1098.21	1103.1	1092.1	1093.56	435367.0
2010-05-18 15:00:00	ES	Futures	1093.81	1099.18	1090.39	1094.05	514892.0
2010-05-18 16:00:00	ES	Futures	1094.05	1095.03	1090.39	1090.63	124039.0
2010-05-18 17:00:00	ES	Futures	1090.63	1090.63	1085.25	1086.96	14988.0
2010-05-18 18:00:00	ES	Futures	1086.72	1089.16	1086.72	1087.21	10603.0
2010-05-18 19:00:00	ES	Futures	1087.21	1087.21	1083.3	1083.54	18106.0
2010-05-18 20:00:00	ES	Futures	1083.79	1086.72	1081.34	1082.81	23244.0
2010-05-18 21:00:00	ES	Futures	1083.05	1086.47	1081.83	1085.5	11133.0
2010-05-18 22:00:00	ES	Futures	1085.5	1086.96	1084.76	1086.47	6051.0
2010-05-18 23:00:00	ES	Futures	1086.47	1089.41	1086.23	1087.7	10553.0
2010-05-18 00:00:00	NQ	Futures	2189.6	2191.04	2187.03	2187.03	182.0
2010-05-18 01:00:00	NQ	Futures	2187.03	2191.32	2184.74	2190.75	500.0
2010-05-18 02:00:00	NQ	Futures	2190.75	2202.49	2189.89	2201.92	1698.0
2010-05-18 03:00:00	NQ	Futures	2201.63	2206.5	2197.62	2202.21	3059.0
2010-05-18 04:00:00	NQ	Futures	2201.92	2205.07	2197.05	2197.05	3027.0
2010-05-18 05:00:00	NQ	Futures	2196.76	2200.77	2193.9	2199.06	1600.0
2010-05-18 06:00:00	NQ	Futures	2199.06	2203.35	2197.05	2203.06	1341.0
2010-05-18 07:00:00	NQ	Futures	2203.35	2207.93	2202.49	2205.64	2224.0
2010-05-18 08:00:00	NQ	Futures	2205.93	2209.65	2200.77	2208.22	6915.0
2010-05-18 09:00:00	NQ	Futures	2207.93	2213.09	2201.35	2203.92	34529.0
2010-05-18 10:00:00	NQ	Futures	2203.92	2205.93	2167.55	2177.86	72481.0
2010-05-18 11:00:00	NQ	Futures	2177.86	2188.75	2171.28	2174.14	43913.0
2010-05-18 12:00:00	NQ	Futures	2174.43	2185.31	2167.27	2177.58	36980.0
2010-05-18 13:00:00	NQ	Futures	2177.58	2178.72	2161.25	2162.11	51661.0
2010-05-18 14:00:00	NQ	Futures	2162.11	2171.85	2149.8	2156.1	56628.0
2010-05-18 15:00:00	NQ	Futures	2156.39	2169.56	2150.37	2159.54	68346.0
2010-05-18 16:00:00	NQ	Futures	2159.54	2163.83	2155.81	2156.67	18012.0
2010-05-18 17:00:00	NQ	Futures	2156.39	2157.53	2148.08	2150.66	732.0
2010-05-18 18:00:00	NQ	Futures	2150.94	2154.38	2150.37	2150.66	339.0
2010-05-18 19:00:00	NQ	Futures	2151.23	2151.8	2144.93	2146.36	706.0
2010-05-18 20:00:00	NQ	Futures	2146.65	2152.09	2140.35	2143.5	1882.0
2010-05-18 21:00:00	NQ	Futures	2143.79	2150.66	2141.49	2146.94	1196.0
2010-05-18 22:00:00	NQ	Futures	2147.22	2149.8	2146.08	2149.23	607.0
2010-05-18 23:00:00	NQ	Futures	2149.23	2154.38	2148.37	2150.37	791.0
2010-05-18 00:00:00	YM	Futures	9963.1	9970.6	9953.7	9953.7	175.0
2010-05-18 01:00:00	YM	Futures	9952.7	9969.7	9943.3	9968.7	519.0

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

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