PREVIEW / futures_1hour / 2015-06-10

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-10.parquet
  size:    49 KB
  rows:    1,471

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-10 00:00:00	ES	Futures	2201.42	2201.69	2199.57	2200.1	3873.0
2015-06-10 01:00:00	ES	Futures	2200.1	2200.89	2198.52	2200.63	3893.0
2015-06-10 02:00:00	ES	Futures	2200.37	2200.89	2197.46	2199.57	10960.0
2015-06-10 03:00:00	ES	Futures	2199.57	2204.86	2197.72	2202.48	31967.0
2015-06-10 04:00:00	ES	Futures	2202.48	2203.8	2200.1	2202.21	20238.0
2015-06-10 05:00:00	ES	Futures	2202.48	2206.97	2201.42	2206.18	24318.0
2015-06-10 06:00:00	ES	Futures	2205.91	2207.23	2204.59	2205.38	14278.0
2015-06-10 07:00:00	ES	Futures	2205.38	2206.18	2204.06	2205.38	20198.0
2015-06-10 08:00:00	ES	Futures	2205.65	2205.91	2202.74	2204.06	23368.0
2015-06-10 09:00:00	ES	Futures	2203.8	2213.04	2203.27	2210.67	217867.0
2015-06-10 10:00:00	ES	Futures	2210.93	2218.33	2210.67	2217.53	197254.0
2015-06-10 11:00:00	ES	Futures	2217.8	2227.04	2216.74	2223.34	330814.0
2015-06-10 12:00:00	ES	Futures	2223.08	2225.46	2222.82	2224.93	88950.0
2015-06-10 13:00:00	ES	Futures	2224.66	2225.46	2221.49	2223.61	61456.0
2015-06-10 14:00:00	ES	Futures	2223.34	2226.78	2223.34	2226.51	99148.0
2015-06-10 15:00:00	ES	Futures	2226.51	2226.51	2221.49	2221.76	217866.0
2015-06-10 16:00:00	ES	Futures	2221.76	2226.51	2221.76	2225.46	90659.0
2015-06-10 17:00:00	ES	Futures	2225.46	2225.98	2225.19	2225.19	2848.0
2015-06-10 18:00:00	ES	Futures	2224.93	2225.19	2222.29	2222.82	5572.0
2015-06-10 19:00:00	ES	Futures	2223.08	2223.61	2222.55	2222.82	1792.0
2015-06-10 20:00:00	ES	Futures	2222.82	2224.14	2222.55	2224.14	3169.0
2015-06-10 21:00:00	ES	Futures	2224.4	2224.4	2222.55	2223.08	2656.0
2015-06-10 22:00:00	ES	Futures	2223.08	2223.34	2222.82	2223.34	1285.0
2015-06-10 23:00:00	ES	Futures	2223.34	2223.34	2222.02	2222.55	1223.0
2015-06-10 00:00:00	NQ	Futures	5219.92	5220.22	5215.51	5216.98	366.0
2015-06-10 01:00:00	NQ	Futures	5216.39	5219.04	5214.33	5218.75	317.0
2015-06-10 02:00:00	NQ	Futures	5218.75	5219.33	5211.39	5217.28	839.0
2015-06-10 03:00:00	NQ	Futures	5215.8	5231.98	5211.69	5225.51	3982.0
2015-06-10 04:00:00	NQ	Futures	5225.51	5227.57	5217.86	5223.16	2406.0
2015-06-10 05:00:00	NQ	Futures	5224.04	5235.51	5221.98	5231.68	2289.0
2015-06-10 06:00:00	NQ	Futures	5231.68	5236.39	5229.92	5230.51	1494.0
2015-06-10 07:00:00	NQ	Futures	5230.51	5232.27	5226.98	5231.39	7228.0
2015-06-10 08:00:00	NQ	Futures	5230.8	5231.68	5220.51	5222.86	7577.0
2015-06-10 09:00:00	NQ	Futures	5222.57	5239.92	5214.92	5234.62	32106.0
2015-06-10 10:00:00	NQ	Futures	5234.62	5263.74	5234.33	5263.15	32619.0
2015-06-10 11:00:00	NQ	Futures	5263.15	5285.2	5259.62	5278.44	45836.0
2015-06-10 12:00:00	NQ	Futures	5278.15	5283.73	5275.5	5283.15	14432.0
2015-06-10 13:00:00	NQ	Futures	5283.15	5285.5	5275.5	5281.68	11564.0
2015-06-10 14:00:00	NQ	Futures	5281.97	5291.09	5281.97	5290.5	19644.0
2015-06-10 15:00:00	NQ	Futures	5290.5	5290.5	5272.56	5272.56	31533.0
2015-06-10 16:00:00	NQ	Futures	5272.27	5281.68	5271.38	5279.32	9011.0
2015-06-10 17:00:00	NQ	Futures	5279.62	5280.5	5279.03	5279.62	135.0
2015-06-10 18:00:00	NQ	Futures	5276.97	5279.62	5271.97	5273.15	689.0
2015-06-10 19:00:00	NQ	Futures	5272.56	5275.21	5272.56	5273.74	245.0
2015-06-10 20:00:00	NQ	Futures	5273.74	5276.38	5273.15	5276.38	298.0
2015-06-10 21:00:00	NQ	Futures	5276.68	5276.68	5272.85	5274.32	222.0
2015-06-10 22:00:00	NQ	Futures	5274.32	5274.91	5273.44	5274.03	170.0
2015-06-10 23:00:00	NQ	Futures	5274.32	5274.91	5271.38	5273.44	192.0
2015-06-10 00:00:00	YM	Futures	18667.3	18667.3	18657.8	18658.9	9.0
2015-06-10 01:00:00	YM	Futures	18658.9	18658.9	18652.6	18652.6	2.0

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

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