PREVIEW / futures_1hour / 2015-06-08

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-08.parquet
  size:    50 KB
  rows:    1,532

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-06-08 00:00:00	ES	Futures	2208.55	2209.08	2208.29	2208.55	1992.0
2015-06-08 01:00:00	ES	Futures	2208.82	2209.87	2208.02	2209.87	1895.0
2015-06-08 02:00:00	ES	Futures	2209.87	2210.93	2206.7	2210.14	11471.0
2015-06-08 03:00:00	ES	Futures	2210.4	2211.46	2206.44	2209.87	23747.0
2015-06-08 04:00:00	ES	Futures	2209.61	2211.46	2206.44	2211.19	15812.0
2015-06-08 05:00:00	ES	Futures	2211.46	2211.46	2207.76	2208.55	12052.0
2015-06-08 06:00:00	ES	Futures	2208.82	2208.82	2206.18	2208.29	10135.0
2015-06-08 07:00:00	ES	Futures	2208.55	2209.35	2206.97	2207.76	26882.0
2015-06-08 08:00:00	ES	Futures	2208.02	2210.4	2206.18	2206.44	29513.0
2015-06-08 09:00:00	ES	Futures	2206.44	2210.14	2203.01	2204.59	200116.0
2015-06-08 10:00:00	ES	Futures	2204.59	2206.7	2202.74	2203.53	142351.0
2015-06-08 11:00:00	ES	Futures	2203.8	2206.44	2200.89	2201.69	133606.0
2015-06-08 12:00:00	ES	Futures	2201.69	2203.27	2198.78	2199.04	84917.0
2015-06-08 13:00:00	ES	Futures	2199.04	2199.84	2195.08	2197.99	119997.0
2015-06-08 14:00:00	ES	Futures	2197.99	2204.06	2195.61	2202.74	131868.0
2015-06-08 15:00:00	ES	Futures	2202.48	2202.74	2194.82	2195.61	202013.0
2015-06-08 16:00:00	ES	Futures	2195.88	2197.46	2193.5	2197.46	74392.0
2015-06-08 17:00:00	ES	Futures	2197.46	2197.72	2196.93	2196.93	1717.0
2015-06-08 18:00:00	ES	Futures	2197.46	2198.78	2196.93	2198.25	4510.0
2015-06-08 19:00:00	ES	Futures	2198.25	2198.78	2197.72	2197.99	1733.0
2015-06-08 20:00:00	ES	Futures	2197.72	2200.37	2196.93	2199.57	6218.0
2015-06-08 21:00:00	ES	Futures	2199.84	2199.84	2198.25	2198.78	4130.0
2015-06-08 22:00:00	ES	Futures	2198.78	2198.78	2197.2	2197.46	1587.0
2015-06-08 23:00:00	ES	Futures	2197.72	2197.99	2196.67	2197.46	2572.0
2015-06-08 00:00:00	NQ	Futures	5265.5	5266.38	5264.33	5265.21	289.0
2015-06-08 01:00:00	NQ	Futures	5265.5	5268.44	5264.03	5268.15	377.0
2015-06-08 02:00:00	NQ	Futures	5268.15	5270.5	5259.91	5268.44	1357.0
2015-06-08 03:00:00	NQ	Futures	5268.15	5271.09	5260.5	5269.32	4074.0
2015-06-08 04:00:00	NQ	Futures	5269.32	5271.38	5259.33	5270.5	2922.0
2015-06-08 05:00:00	NQ	Futures	5270.5	5270.5	5261.68	5265.5	2080.0
2015-06-08 06:00:00	NQ	Futures	5265.5	5266.68	5259.91	5266.68	1797.0
2015-06-08 07:00:00	NQ	Futures	5266.97	5268.44	5262.56	5266.68	11422.0
2015-06-08 08:00:00	NQ	Futures	5266.38	5271.09	5261.38	5261.38	7632.0
2015-06-08 09:00:00	NQ	Futures	5261.38	5267.85	5243.15	5246.98	34162.0
2015-06-08 10:00:00	NQ	Futures	5246.68	5251.68	5238.15	5240.21	27393.0
2015-06-08 11:00:00	NQ	Futures	5240.51	5249.33	5229.33	5230.21	26337.0
2015-06-08 12:00:00	NQ	Futures	5230.51	5234.04	5213.45	5214.04	19133.0
2015-06-08 13:00:00	NQ	Futures	5213.75	5217.28	5201.4	5209.04	22193.0
2015-06-08 14:00:00	NQ	Futures	5209.34	5231.68	5201.69	5226.98	29635.0
2015-06-08 15:00:00	NQ	Futures	5226.98	5227.86	5210.22	5212.57	32381.0
2015-06-08 16:00:00	NQ	Futures	5212.28	5217.57	5207.87	5217.57	6756.0
2015-06-08 17:00:00	NQ	Futures	5217.57	5219.63	5216.98	5218.75	263.0
2015-06-08 18:00:00	NQ	Futures	5217.57	5221.98	5216.98	5219.33	852.0
2015-06-08 19:00:00	NQ	Futures	5219.63	5221.1	5218.45	5219.04	234.0
2015-06-08 20:00:00	NQ	Futures	5218.45	5224.04	5216.98	5222.86	750.0
2015-06-08 21:00:00	NQ	Futures	5223.16	5223.16	5218.45	5219.33	589.0
2015-06-08 22:00:00	NQ	Futures	5219.63	5219.63	5216.39	5217.57	360.0
2015-06-08 23:00:00	NQ	Futures	5217.57	5218.75	5216.1	5217.86	571.0
2015-06-08 00:00:00	YM	Futures	18709.3	18710.3	18703.0	18707.2	344.0
2015-06-08 01:00:00	YM	Futures	18707.2	18718.7	18703.0	18717.6	288.0

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

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