PREVIEW / futures_1hour / 2015-06-17

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-17.parquet
  size:    52 KB
  rows:    1,571

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-17 00:00:00	ES	Futures	2225.04	2225.84	2225.04	2225.3	925.0
2015-06-17 01:00:00	ES	Futures	2225.57	2228.76	2225.3	2226.9	5338.0
2015-06-17 02:00:00	ES	Futures	2227.17	2229.56	2226.63	2228.76	9265.0
2015-06-17 03:00:00	ES	Futures	2228.5	2231.69	2226.9	2229.56	28504.0
2015-06-17 04:00:00	ES	Futures	2229.56	2232.76	2228.5	2231.69	14802.0
2015-06-17 05:00:00	ES	Futures	2231.69	2232.23	2229.56	2230.89	12361.0
2015-06-17 06:00:00	ES	Futures	2230.89	2231.16	2227.43	2228.23	11079.0
2015-06-17 07:00:00	ES	Futures	2228.23	2229.83	2225.04	2225.57	26404.0
2015-06-17 08:00:00	ES	Futures	2225.57	2228.76	2225.3	2227.7	18736.0
2015-06-17 09:00:00	ES	Futures	2227.7	2231.43	2226.9	2228.5	121286.0
2015-06-17 10:00:00	ES	Futures	2228.5	2229.83	2225.84	2228.23	110020.0
2015-06-17 11:00:00	ES	Futures	2228.5	2229.03	2222.11	2224.24	111667.0
2015-06-17 12:00:00	ES	Futures	2224.5	2224.5	2215.19	2217.05	128935.0
2015-06-17 13:00:00	ES	Futures	2216.78	2221.04	2215.72	2219.98	84828.0
2015-06-17 14:00:00	ES	Futures	2219.71	2235.15	2213.85	2232.49	326068.0
2015-06-17 15:00:00	ES	Futures	2232.49	2233.56	2227.17	2227.7	178460.0
2015-06-17 16:00:00	ES	Futures	2227.43	2227.97	2222.37	2223.97	55152.0
2015-06-17 17:00:00	ES	Futures	2223.71	2224.5	2223.44	2224.24	951.0
2015-06-17 18:00:00	ES	Futures	2224.77	2225.3	2223.44	2224.5	1767.0
2015-06-17 19:00:00	ES	Futures	2224.24	2225.57	2224.24	2225.04	1108.0
2015-06-17 20:00:00	ES	Futures	2224.77	2225.04	2222.91	2223.17	3125.0
2015-06-17 21:00:00	ES	Futures	2223.17	2223.17	2220.51	2221.58	6721.0
2015-06-17 22:00:00	ES	Futures	2221.58	2222.37	2221.04	2221.84	3275.0
2015-06-17 23:00:00	ES	Futures	2221.58	2221.84	2219.71	2219.98	3277.0
2015-06-17 00:00:00	NQ	Futures	5265.35	5267.12	5264.46	5265.05	244.0
2015-06-17 01:00:00	NQ	Futures	5265.35	5273.33	5265.35	5268.9	804.0
2015-06-17 02:00:00	NQ	Futures	5268.9	5275.7	5268.01	5272.15	805.0
2015-06-17 03:00:00	NQ	Futures	5272.15	5281.02	5267.42	5274.52	2692.0
2015-06-17 04:00:00	NQ	Futures	5274.52	5282.5	5272.15	5281.62	1739.0
2015-06-17 05:00:00	NQ	Futures	5280.43	5281.62	5274.81	5278.95	1303.0
2015-06-17 06:00:00	NQ	Futures	5278.66	5279.55	5270.38	5272.15	1336.0
2015-06-17 07:00:00	NQ	Futures	5271.85	5275.11	5264.76	5265.94	2598.0
2015-06-17 08:00:00	NQ	Futures	5265.64	5273.93	5265.35	5271.85	2809.0
2015-06-17 09:00:00	NQ	Futures	5271.56	5283.39	5270.97	5278.36	19373.0
2015-06-17 10:00:00	NQ	Futures	5278.66	5282.5	5275.11	5281.91	14778.0
2015-06-17 11:00:00	NQ	Futures	5281.91	5283.39	5261.5	5268.01	15286.0
2015-06-17 12:00:00	NQ	Futures	5268.31	5269.19	5245.23	5248.49	17094.0
2015-06-17 13:00:00	NQ	Futures	5248.49	5260.32	5247.01	5256.77	11231.0
2015-06-17 14:00:00	NQ	Futures	5256.18	5295.81	5242.87	5291.38	57360.0
2015-06-17 15:00:00	NQ	Futures	5291.67	5294.63	5277.47	5277.47	28970.0
2015-06-17 16:00:00	NQ	Futures	5277.47	5280.43	5265.35	5267.71	5984.0
2015-06-17 17:00:00	NQ	Futures	5267.71	5269.49	5267.12	5268.01	128.0
2015-06-17 18:00:00	NQ	Futures	5270.08	5271.56	5267.42	5268.6	345.0
2015-06-17 19:00:00	NQ	Futures	5268.31	5270.97	5268.31	5270.08	187.0
2015-06-17 20:00:00	NQ	Futures	5269.49	5269.78	5266.53	5266.83	278.0
2015-06-17 21:00:00	NQ	Futures	5266.83	5266.83	5260.61	5262.69	775.0
2015-06-17 22:00:00	NQ	Futures	5262.98	5264.46	5260.91	5263.28	369.0
2015-06-17 23:00:00	NQ	Futures	5262.98	5262.98	5258.25	5258.25	279.0
2015-06-17 00:00:00	YM	Futures	18784.2	18786.4	18781.1	18783.2	220.0
2015-06-17 01:00:00	YM	Futures	18783.2	18813.7	18783.2	18801.1	1186.0

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

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