PREVIEW / futures_1hour / 2015-04-06

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-04-06.parquet
  size:    42 KB
  rows:    1,232

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
2015-04-06 00:00:00	ES	Futures	2161.8	2161.8	2160.48	2161.01	955.0
2015-04-06 01:00:00	ES	Futures	2161.28	2161.54	2160.48	2160.75	1027.0
2015-04-06 02:00:00	ES	Futures	2161.01	2161.54	2158.63	2159.16	1644.0
2015-04-06 03:00:00	ES	Futures	2159.16	2159.69	2158.63	2158.9	1699.0
2015-04-06 04:00:00	ES	Futures	2158.9	2161.54	2158.63	2160.22	1788.0
2015-04-06 05:00:00	ES	Futures	2159.96	2160.75	2159.16	2159.16	1216.0
2015-04-06 06:00:00	ES	Futures	2159.16	2161.28	2159.16	2161.28	1337.0
2015-04-06 07:00:00	ES	Futures	2161.28	2162.6	2158.11	2159.43	13781.0
2015-04-06 08:00:00	ES	Futures	2159.43	2162.6	2159.16	2161.28	11992.0
2015-04-06 09:00:00	ES	Futures	2161.28	2178.44	2161.01	2176.59	176870.0
2015-04-06 10:00:00	ES	Futures	2176.59	2189.54	2176.59	2188.22	180059.0
2015-04-06 11:00:00	ES	Futures	2188.22	2192.71	2187.69	2191.39	81677.0
2015-04-06 12:00:00	ES	Futures	2191.65	2195.35	2191.39	2194.82	73098.0
2015-04-06 13:00:00	ES	Futures	2194.82	2197.46	2194.55	2195.88	57768.0
2015-04-06 14:00:00	ES	Futures	2195.88	2197.2	2193.76	2196.14	59757.0
2015-04-06 15:00:00	ES	Futures	2196.14	2196.67	2189.8	2190.86	168371.0
2015-04-06 16:00:00	ES	Futures	2190.86	2191.12	2189.27	2189.54	72509.0
2015-04-06 17:00:00	ES	Futures	2189.27	2189.54	2188.48	2188.74	2730.0
2015-04-06 18:00:00	ES	Futures	2188.48	2189.54	2187.95	2188.22	4631.0
2015-04-06 19:00:00	ES	Futures	2188.22	2188.74	2187.69	2188.22	2761.0
2015-04-06 20:00:00	ES	Futures	2188.22	2189.27	2187.42	2187.69	3916.0
2015-04-06 21:00:00	ES	Futures	2187.69	2189.01	2187.16	2188.74	3801.0
2015-04-06 22:00:00	ES	Futures	2188.74	2189.01	2187.16	2188.22	3362.0
2015-04-06 23:00:00	ES	Futures	2188.22	2190.06	2187.42	2189.54	4155.0
2015-04-06 00:00:00	NQ	Futures	5034.07	5034.07	5032.31	5032.9	124.0
2015-04-06 01:00:00	NQ	Futures	5033.19	5034.37	5030.54	5031.43	393.0
2015-04-06 02:00:00	NQ	Futures	5030.84	5032.31	5024.08	5024.96	619.0
2015-04-06 03:00:00	NQ	Futures	5024.96	5025.84	5021.43	5023.49	545.0
2015-04-06 04:00:00	NQ	Futures	5023.78	5029.66	5023.78	5026.72	444.0
2015-04-06 05:00:00	NQ	Futures	5026.72	5027.31	5026.13	5026.13	270.0
2015-04-06 06:00:00	NQ	Futures	5026.43	5029.37	5026.13	5029.37	453.0
2015-04-06 07:00:00	NQ	Futures	5029.37	5032.02	5024.96	5028.78	2294.0
2015-04-06 08:00:00	NQ	Futures	5029.07	5035.54	5027.9	5032.9	1886.0
2015-04-06 09:00:00	NQ	Futures	5032.9	5080.54	5028.78	5069.36	33867.0
2015-04-06 10:00:00	NQ	Futures	5069.66	5102.59	5067.3	5097.0	34124.0
2015-04-06 11:00:00	NQ	Futures	5097.59	5106.12	5095.24	5104.35	14256.0
2015-04-06 12:00:00	NQ	Futures	5103.77	5113.18	5103.47	5112.29	12579.0
2015-04-06 13:00:00	NQ	Futures	5112.29	5122.29	5112.29	5117.88	9706.0
2015-04-06 14:00:00	NQ	Futures	5118.18	5119.65	5111.41	5116.12	8733.0
2015-04-06 15:00:00	NQ	Futures	5116.41	5119.06	5106.71	5107.88	22422.0
2015-04-06 16:00:00	NQ	Futures	5107.88	5109.35	5104.06	5105.24	6657.0
2015-04-06 17:00:00	NQ	Futures	5104.94	5105.24	5102.59	5103.77	211.0
2015-04-06 18:00:00	NQ	Futures	5104.65	5106.41	5103.18	5104.06	462.0
2015-04-06 19:00:00	NQ	Futures	5104.06	5105.83	5103.77	5105.83	206.0
2015-04-06 20:00:00	NQ	Futures	5105.53	5105.83	5102.0	5102.3	297.0
2015-04-06 21:00:00	NQ	Futures	5102.0	5104.65	5101.41	5104.35	238.0
2015-04-06 22:00:00	NQ	Futures	5104.65	5104.94	5102.3	5104.65	361.0
2015-04-06 23:00:00	NQ	Futures	5104.35	5107.88	5102.88	5107.0	499.0
2015-04-06 00:00:00	YM	Futures	18417.7	18417.7	18407.2	18411.4	256.0
2015-04-06 01:00:00	YM	Futures	18414.6	18414.6	18402.0	18404.1	436.0

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

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