PREVIEW / futures_1hour / 2013-09-16

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-16.parquet
  size:    49 KB
  rows:    1,482

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
2013-09-16 00:00:00	ES	Futures	1754.65	1755.16	1754.13	1754.39	3212.0
2013-09-16 01:00:00	ES	Futures	1754.39	1754.65	1753.36	1753.87	4641.0
2013-09-16 02:00:00	ES	Futures	1753.87	1753.87	1752.58	1753.36	12049.0
2013-09-16 03:00:00	ES	Futures	1753.36	1753.87	1751.55	1753.36	27640.0
2013-09-16 04:00:00	ES	Futures	1753.36	1756.71	1753.1	1754.9	23300.0
2013-09-16 05:00:00	ES	Futures	1754.9	1755.94	1753.87	1754.39	9129.0
2013-09-16 06:00:00	ES	Futures	1754.39	1755.68	1753.61	1753.61	12367.0
2013-09-16 07:00:00	ES	Futures	1753.61	1754.65	1753.1	1753.87	15986.0
2013-09-16 08:00:00	ES	Futures	1753.87	1754.13	1751.55	1751.81	25724.0
2013-09-16 09:00:00	ES	Futures	1752.07	1754.65	1747.42	1748.71	236557.0
2013-09-16 10:00:00	ES	Futures	1748.71	1750.78	1745.62	1748.46	214634.0
2013-09-16 11:00:00	ES	Futures	1748.46	1751.29	1747.68	1751.04	108175.0
2013-09-16 12:00:00	ES	Futures	1751.04	1752.58	1748.97	1749.23	95927.0
2013-09-16 13:00:00	ES	Futures	1748.97	1750.0	1743.81	1746.65	104726.0
2013-09-16 14:00:00	ES	Futures	1746.65	1747.17	1742.78	1743.81	128289.0
2013-09-16 15:00:00	ES	Futures	1743.55	1746.39	1741.75	1744.59	189775.0
2013-09-16 16:00:00	ES	Futures	1744.59	1746.13	1743.3	1744.59	64938.0
2013-09-16 17:00:00	ES	Futures	1744.59	1744.84	1742.78	1743.04	3899.0
2013-09-16 18:00:00	ES	Futures	1742.78	1744.59	1742.52	1744.59	5087.0
2013-09-16 19:00:00	ES	Futures	1744.33	1744.33	1742.01	1742.26	3201.0
2013-09-16 20:00:00	ES	Futures	1742.26	1743.81	1741.75	1742.78	4943.0
2013-09-16 21:00:00	ES	Futures	1743.04	1744.07	1742.52	1742.52	2356.0
2013-09-16 22:00:00	ES	Futures	1742.78	1744.07	1742.52	1744.07	1777.0
2013-09-16 23:00:00	ES	Futures	1744.07	1744.59	1743.04	1743.3	3190.0
2013-09-16 00:00:00	NQ	Futures	3723.64	3724.22	3723.34	3723.64	462.0
2013-09-16 01:00:00	NQ	Futures	3723.34	3723.93	3721.6	3722.76	466.0
2013-09-16 02:00:00	NQ	Futures	3722.18	3723.05	3719.86	3721.02	1590.0
2013-09-16 03:00:00	NQ	Futures	3721.31	3721.6	3716.08	3720.15	4409.0
2013-09-16 04:00:00	NQ	Futures	3719.86	3726.25	3719.86	3724.22	3365.0
2013-09-16 05:00:00	NQ	Futures	3724.51	3725.09	3721.6	3721.6	1403.0
2013-09-16 06:00:00	NQ	Futures	3721.89	3724.22	3720.73	3720.73	1710.0
2013-09-16 07:00:00	NQ	Futures	3721.02	3721.89	3719.86	3720.73	2004.0
2013-09-16 08:00:00	NQ	Futures	3721.02	3721.02	3710.28	3711.73	6812.0
2013-09-16 09:00:00	NQ	Futures	3712.02	3717.25	3696.04	3698.08	35631.0
2013-09-16 10:00:00	NQ	Futures	3698.08	3700.11	3687.33	3690.24	38258.0
2013-09-16 11:00:00	NQ	Futures	3690.24	3696.33	3687.33	3693.43	18289.0
2013-09-16 12:00:00	NQ	Futures	3693.43	3694.88	3683.27	3683.56	12676.0
2013-09-16 13:00:00	NQ	Futures	3683.56	3690.24	3673.68	3680.36	22326.0
2013-09-16 14:00:00	NQ	Futures	3680.65	3682.39	3669.32	3671.07	23145.0
2013-09-16 15:00:00	NQ	Futures	3671.07	3676.59	3666.71	3674.55	29114.0
2013-09-16 16:00:00	NQ	Futures	3674.84	3676.29	3672.52	3672.81	4959.0
2013-09-16 17:00:00	NQ	Futures	3672.52	3672.81	3669.32	3669.61	319.0
2013-09-16 18:00:00	NQ	Futures	3669.32	3672.52	3669.03	3671.36	389.0
2013-09-16 19:00:00	NQ	Futures	3671.07	3671.94	3667.0	3667.29	433.0
2013-09-16 20:00:00	NQ	Futures	3667.58	3670.78	3666.71	3669.32	426.0
2013-09-16 21:00:00	NQ	Futures	3669.32	3671.07	3668.45	3669.03	390.0
2013-09-16 22:00:00	NQ	Futures	3669.03	3671.94	3669.03	3671.65	240.0
2013-09-16 23:00:00	NQ	Futures	3671.65	3673.68	3670.78	3670.78	564.0
2013-09-16 00:00:00	YM	Futures	15808.9	15813.0	15807.9	15809.9	374.0
2013-09-16 01:00:00	YM	Futures	15809.9	15809.9	15799.7	15803.8	587.0

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

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