PREVIEW / futures_1hour / 2015-06-25

all futures 1-hour files

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

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-25 00:00:00	ES	Futures	2240.75	2241.28	2240.21	2240.75	1967.0
2015-06-25 01:00:00	ES	Futures	2241.01	2241.28	2240.21	2240.48	1923.0
2015-06-25 02:00:00	ES	Futures	2240.75	2240.75	2238.62	2238.62	8602.0
2015-06-25 03:00:00	ES	Futures	2238.62	2244.47	2238.62	2243.14	20641.0
2015-06-25 04:00:00	ES	Futures	2243.14	2250.06	2242.88	2245.01	30890.0
2015-06-25 05:00:00	ES	Futures	2245.01	2246.34	2241.81	2244.47	27369.0
2015-06-25 06:00:00	ES	Futures	2244.47	2249.53	2243.41	2246.07	40766.0
2015-06-25 07:00:00	ES	Futures	2245.8	2247.93	2242.61	2243.67	22120.0
2015-06-25 08:00:00	ES	Futures	2243.67	2244.74	2240.48	2243.41	27659.0
2015-06-25 09:00:00	ES	Futures	2243.41	2244.47	2234.62	2239.68	232884.0
2015-06-25 10:00:00	ES	Futures	2239.68	2242.61	2237.55	2241.54	156843.0
2015-06-25 11:00:00	ES	Futures	2241.54	2244.74	2240.21	2241.81	108171.0
2015-06-25 12:00:00	ES	Futures	2241.54	2242.08	2236.75	2238.35	64679.0
2015-06-25 13:00:00	ES	Futures	2238.08	2239.68	2236.49	2237.82	50760.0
2015-06-25 14:00:00	ES	Futures	2237.55	2237.55	2228.5	2231.43	141119.0
2015-06-25 15:00:00	ES	Futures	2231.16	2234.89	2228.76	2229.03	187306.0
2015-06-25 16:00:00	ES	Futures	2229.03	2230.63	2227.97	2229.56	72880.0
2015-06-25 17:00:00	ES	Futures	2229.83	2230.89	2229.56	2230.63	1394.0
2015-06-25 18:00:00	ES	Futures	2230.89	2231.16	2229.83	2231.16	2236.0
2015-06-25 19:00:00	ES	Futures	2231.16	2231.16	2229.83	2230.63	954.0
2015-06-25 20:00:00	ES	Futures	2230.63	2231.16	2229.3	2229.83	3401.0
2015-06-25 21:00:00	ES	Futures	2229.83	2230.36	2226.63	2227.43	5404.0
2015-06-25 22:00:00	ES	Futures	2227.7	2228.23	2226.37	2226.9	2604.0
2015-06-25 23:00:00	ES	Futures	2226.9	2229.3	2226.63	2229.03	2870.0
2015-06-25 00:00:00	NQ	Futures	5354.68	5357.04	5353.49	5356.75	241.0
2015-06-25 01:00:00	NQ	Futures	5356.75	5358.23	5354.08	5354.08	518.0
2015-06-25 02:00:00	NQ	Futures	5354.08	5357.04	5352.31	5352.61	894.0
2015-06-25 03:00:00	NQ	Futures	5352.9	5365.92	5350.83	5363.25	2937.0
2015-06-25 04:00:00	NQ	Futures	5363.25	5380.41	5362.66	5366.21	6077.0
2015-06-25 05:00:00	NQ	Futures	5366.51	5368.87	5354.97	5360.0	6806.0
2015-06-25 06:00:00	NQ	Futures	5360.3	5376.86	5358.82	5367.99	8336.0
2015-06-25 07:00:00	NQ	Futures	5367.69	5370.94	5360.0	5362.07	2777.0
2015-06-25 08:00:00	NQ	Futures	5362.37	5365.92	5357.04	5363.55	4071.0
2015-06-25 09:00:00	NQ	Futures	5363.55	5367.69	5345.8	5357.93	32738.0
2015-06-25 10:00:00	NQ	Futures	5357.63	5365.32	5350.83	5362.07	20550.0
2015-06-25 11:00:00	NQ	Futures	5362.37	5371.24	5361.48	5363.55	15295.0
2015-06-25 12:00:00	NQ	Futures	5363.55	5364.44	5351.13	5354.68	10037.0
2015-06-25 13:00:00	NQ	Futures	5354.68	5356.15	5346.69	5348.76	7185.0
2015-06-25 14:00:00	NQ	Futures	5348.76	5348.76	5324.21	5333.08	21429.0
2015-06-25 15:00:00	NQ	Futures	5333.67	5344.62	5331.6	5331.9	21172.0
2015-06-25 16:00:00	NQ	Futures	5331.9	5336.04	5329.24	5331.01	6029.0
2015-06-25 17:00:00	NQ	Futures	5331.01	5333.38	5331.01	5332.79	83.0
2015-06-25 18:00:00	NQ	Futures	5331.9	5333.97	5330.72	5333.67	317.0
2015-06-25 19:00:00	NQ	Futures	5333.67	5333.97	5331.9	5333.08	102.0
2015-06-25 20:00:00	NQ	Futures	5333.08	5333.97	5329.83	5331.01	269.0
2015-06-25 21:00:00	NQ	Futures	5330.72	5331.9	5322.73	5326.28	776.0
2015-06-25 22:00:00	NQ	Futures	5326.28	5326.87	5323.62	5323.62	394.0
2015-06-25 23:00:00	NQ	Futures	5323.62	5329.24	5323.62	5329.24	420.0
2015-06-25 00:00:00	YM	Futures	18874.8	18881.2	18872.7	18880.1	262.0
2015-06-25 01:00:00	YM	Futures	18880.1	18881.2	18871.7	18873.8	367.0

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

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