PREVIEW / futures_1hour / 2015-07-14

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-14.parquet
  size:    50 KB
  rows:    1,548

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-07-14 00:00:00	ES	Futures	2229.83	2229.83	2229.3	2229.83	1005.0
2015-07-14 01:00:00	ES	Futures	2229.83	2229.83	2228.76	2229.83	3241.0
2015-07-14 02:00:00	ES	Futures	2229.56	2231.43	2227.7	2229.03	14051.0
2015-07-14 03:00:00	ES	Futures	2229.03	2229.56	2227.43	2228.23	14315.0
2015-07-14 04:00:00	ES	Futures	2227.97	2229.56	2227.43	2228.76	12868.0
2015-07-14 05:00:00	ES	Futures	2228.76	2229.56	2228.23	2229.03	6837.0
2015-07-14 06:00:00	ES	Futures	2228.76	2229.83	2228.5	2229.56	6915.0
2015-07-14 07:00:00	ES	Futures	2229.56	2230.89	2229.03	2229.03	10136.0
2015-07-14 08:00:00	ES	Futures	2229.03	2230.63	2226.37	2226.63	39896.0
2015-07-14 09:00:00	ES	Futures	2226.63	2233.82	2226.37	2233.02	152597.0
2015-07-14 10:00:00	ES	Futures	2233.02	2235.95	2231.43	2235.15	139913.0
2015-07-14 11:00:00	ES	Futures	2235.15	2238.88	2234.89	2238.35	118187.0
2015-07-14 12:00:00	ES	Futures	2238.35	2239.41	2234.89	2236.22	64679.0
2015-07-14 13:00:00	ES	Futures	2236.49	2238.08	2235.42	2238.08	46473.0
2015-07-14 14:00:00	ES	Futures	2238.08	2241.28	2237.28	2240.75	87772.0
2015-07-14 15:00:00	ES	Futures	2240.48	2242.34	2238.08	2238.08	147317.0
2015-07-14 16:00:00	ES	Futures	2238.08	2240.21	2237.55	2239.41	63804.0
2015-07-14 17:00:00	ES	Futures	2239.41	2240.21	2239.15	2239.41	2367.0
2015-07-14 18:00:00	ES	Futures	2239.15	2239.15	2236.75	2237.28	4280.0
2015-07-14 19:00:00	ES	Futures	2237.02	2237.28	2235.69	2236.22	2693.0
2015-07-14 20:00:00	ES	Futures	2236.22	2238.35	2235.95	2238.08	4144.0
2015-07-14 21:00:00	ES	Futures	2237.82	2241.28	2237.28	2240.48	7183.0
2015-07-14 22:00:00	ES	Futures	2240.75	2244.47	2240.75	2241.01	13194.0
2015-07-14 23:00:00	ES	Futures	2241.01	2241.81	2241.01	2241.54	2681.0
2015-07-14 00:00:00	NQ	Futures	5309.72	5310.9	5309.72	5310.6	74.0
2015-07-14 01:00:00	NQ	Futures	5310.01	5310.9	5309.12	5310.6	629.0
2015-07-14 02:00:00	NQ	Futures	5310.9	5317.7	5309.72	5312.67	2192.0
2015-07-14 03:00:00	NQ	Futures	5313.27	5315.34	5310.31	5311.49	1327.0
2015-07-14 04:00:00	NQ	Futures	5311.79	5315.63	5310.01	5314.45	1397.0
2015-07-14 05:00:00	NQ	Futures	5314.45	5314.45	5310.6	5310.9	1291.0
2015-07-14 06:00:00	NQ	Futures	5310.9	5313.86	5310.6	5312.08	1124.0
2015-07-14 07:00:00	NQ	Futures	5312.38	5314.74	5311.49	5312.97	1883.0
2015-07-14 08:00:00	NQ	Futures	5312.97	5318.89	5311.49	5312.38	6762.0
2015-07-14 09:00:00	NQ	Futures	5312.38	5329.53	5311.79	5327.76	29045.0
2015-07-14 10:00:00	NQ	Futures	5327.76	5338.11	5323.91	5336.34	26277.0
2015-07-14 11:00:00	NQ	Futures	5336.34	5352.31	5336.04	5349.65	21708.0
2015-07-14 12:00:00	NQ	Futures	5349.65	5352.31	5341.37	5344.62	11055.0
2015-07-14 13:00:00	NQ	Futures	5344.62	5352.01	5341.37	5350.83	7787.0
2015-07-14 14:00:00	NQ	Futures	5350.83	5358.23	5347.87	5355.27	13322.0
2015-07-14 15:00:00	NQ	Futures	5355.27	5359.41	5343.14	5344.03	21674.0
2015-07-14 16:00:00	NQ	Futures	5344.03	5348.46	5342.84	5348.46	5697.0
2015-07-14 17:00:00	NQ	Futures	5348.17	5349.94	5347.87	5348.76	310.0
2015-07-14 18:00:00	NQ	Futures	5346.99	5348.76	5343.73	5344.32	530.0
2015-07-14 19:00:00	NQ	Futures	5344.62	5345.21	5342.55	5342.55	307.0
2015-07-14 20:00:00	NQ	Futures	5342.55	5347.87	5342.55	5347.58	460.0
2015-07-14 21:00:00	NQ	Futures	5346.99	5357.04	5346.39	5353.79	886.0
2015-07-14 22:00:00	NQ	Futures	5354.08	5362.66	5353.49	5353.79	1808.0
2015-07-14 23:00:00	NQ	Futures	5353.49	5355.27	5353.2	5354.97	309.0
2015-07-14 00:00:00	YM	Futures	18845.3	18849.6	18845.3	18849.6	175.0
2015-07-14 01:00:00	YM	Futures	18848.5	18848.5	18838.0	18843.2	425.0

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

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