PREVIEW / futures_1hour / 2015-06-16

all futures 1-hour files

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

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-16 00:00:00	ES	Futures	2207.46	2207.73	2206.93	2206.93	1184.0
2015-06-16 01:00:00	ES	Futures	2206.93	2207.46	2206.67	2206.93	1668.0
2015-06-16 02:00:00	ES	Futures	2207.2	2207.46	2201.61	2201.61	17438.0
2015-06-16 03:00:00	ES	Futures	2201.61	2204.0	2196.02	2197.08	31605.0
2015-06-16 04:00:00	ES	Futures	2197.08	2204.0	2196.81	2202.14	22897.0
2015-06-16 05:00:00	ES	Futures	2201.87	2202.41	2197.88	2198.68	13279.0
2015-06-16 06:00:00	ES	Futures	2198.68	2201.07	2197.88	2200.81	15556.0
2015-06-16 07:00:00	ES	Futures	2201.07	2207.46	2200.54	2204.8	43655.0
2015-06-16 08:00:00	ES	Futures	2205.07	2207.2	2201.87	2206.93	36581.0
2015-06-16 09:00:00	ES	Futures	2206.93	2217.58	2205.07	2214.39	210288.0
2015-06-16 10:00:00	ES	Futures	2214.12	2215.98	2208.53	2212.52	186541.0
2015-06-16 11:00:00	ES	Futures	2212.79	2219.18	2211.99	2217.05	105683.0
2015-06-16 12:00:00	ES	Futures	2217.32	2221.04	2215.98	2220.78	59276.0
2015-06-16 13:00:00	ES	Futures	2220.78	2223.17	2219.71	2221.84	67086.0
2015-06-16 14:00:00	ES	Futures	2222.11	2224.5	2222.11	2223.97	79167.0
2015-06-16 15:00:00	ES	Futures	2223.71	2224.5	2222.11	2223.71	117657.0
2015-06-16 16:00:00	ES	Futures	2223.44	2225.84	2222.91	2225.3	53879.0
2015-06-16 17:00:00	ES	Futures	2225.3	2225.3	2224.77	2225.3	1481.0
2015-06-16 18:00:00	ES	Futures	2225.57	2226.63	2225.04	2225.3	1943.0
2015-06-16 19:00:00	ES	Futures	2225.57	2225.84	2224.77	2225.57	1051.0
2015-06-16 20:00:00	ES	Futures	2225.57	2226.1	2224.77	2225.57	3011.0
2015-06-16 21:00:00	ES	Futures	2225.57	2226.1	2224.5	2225.04	2503.0
2015-06-16 22:00:00	ES	Futures	2225.3	2225.3	2224.5	2225.04	1483.0
2015-06-16 23:00:00	ES	Futures	2225.04	2226.1	2224.5	2225.3	1786.0
2015-06-16 00:00:00	NQ	Futures	5228.67	5229.85	5228.37	5228.67	144.0
2015-06-16 01:00:00	NQ	Futures	5228.67	5229.56	5226.89	5228.37	274.0
2015-06-16 02:00:00	NQ	Futures	5228.37	5228.67	5215.95	5216.54	1426.0
2015-06-16 03:00:00	NQ	Futures	5216.54	5220.68	5200.87	5203.23	3798.0
2015-06-16 04:00:00	NQ	Futures	5203.53	5219.2	5203.23	5215.06	4292.0
2015-06-16 05:00:00	NQ	Futures	5215.06	5215.06	5202.34	5204.41	1690.0
2015-06-16 06:00:00	NQ	Futures	5204.12	5211.22	5202.05	5211.22	1848.0
2015-06-16 07:00:00	NQ	Futures	5211.22	5226.89	5210.33	5219.8	5450.0
2015-06-16 08:00:00	NQ	Futures	5219.5	5226.01	5214.47	5225.42	5111.0
2015-06-16 09:00:00	NQ	Futures	5225.12	5252.92	5220.98	5242.28	31126.0
2015-06-16 10:00:00	NQ	Futures	5242.28	5249.08	5226.3	5236.95	25268.0
2015-06-16 11:00:00	NQ	Futures	5236.95	5253.52	5236.36	5246.12	13077.0
2015-06-16 12:00:00	NQ	Futures	5246.42	5261.21	5243.75	5260.32	10280.0
2015-06-16 13:00:00	NQ	Futures	5260.61	5268.01	5257.07	5264.76	10704.0
2015-06-16 14:00:00	NQ	Futures	5265.05	5272.74	5265.05	5270.08	10714.0
2015-06-16 15:00:00	NQ	Futures	5270.38	5270.97	5260.02	5262.39	15028.0
2015-06-16 16:00:00	NQ	Futures	5262.69	5268.31	5262.09	5266.83	4524.0
2015-06-16 17:00:00	NQ	Futures	5267.12	5268.01	5266.83	5267.71	51.0
2015-06-16 18:00:00	NQ	Futures	5267.71	5269.19	5266.23	5266.83	411.0
2015-06-16 19:00:00	NQ	Futures	5267.12	5267.71	5265.64	5267.12	136.0
2015-06-16 20:00:00	NQ	Futures	5266.83	5267.71	5264.46	5266.53	404.0
2015-06-16 21:00:00	NQ	Futures	5266.83	5266.83	5262.69	5265.05	521.0
2015-06-16 22:00:00	NQ	Futures	5265.05	5265.94	5264.16	5265.35	165.0
2015-06-16 23:00:00	NQ	Futures	5265.35	5267.42	5264.76	5265.64	178.0
2015-06-16 00:00:00	YM	Futures	18633.6	18638.9	18633.6	18635.7	167.0
2015-06-16 01:00:00	YM	Futures	18635.7	18637.8	18632.5	18634.7	309.0

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

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