PREVIEW / futures_1hour / 2013-09-18

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-18.parquet
  size:    51 KB
  rows:    1,533

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-18 00:00:00	ES	Futures	1753.61	1753.87	1753.1	1753.36	972.0
2013-09-18 01:00:00	ES	Futures	1753.36	1754.13	1753.1	1753.87	1901.0
2013-09-18 02:00:00	ES	Futures	1754.13	1754.13	1752.84	1753.61	4459.0
2013-09-18 03:00:00	ES	Futures	1753.36	1754.13	1752.07	1752.84	13829.0
2013-09-18 04:00:00	ES	Futures	1753.1	1754.9	1753.1	1754.65	14234.0
2013-09-18 05:00:00	ES	Futures	1754.9	1755.94	1753.87	1754.65	16116.0
2013-09-18 06:00:00	ES	Futures	1754.39	1754.9	1753.36	1754.39	15214.0
2013-09-18 07:00:00	ES	Futures	1754.39	1754.65	1753.1	1753.61	12205.0
2013-09-18 08:00:00	ES	Futures	1753.61	1754.39	1752.33	1752.58	34451.0
2013-09-18 09:00:00	ES	Futures	1752.58	1753.1	1751.04	1751.81	132714.0
2013-09-18 10:00:00	ES	Futures	1751.81	1753.36	1748.46	1750.0	164055.0
2013-09-18 11:00:00	ES	Futures	1750.0	1750.52	1747.94	1748.46	96103.0
2013-09-18 12:00:00	ES	Futures	1748.2	1749.49	1747.17	1749.23	86621.0
2013-09-18 13:00:00	ES	Futures	1748.97	1751.55	1748.97	1749.49	88337.0
2013-09-18 14:00:00	ES	Futures	1749.75	1777.35	1749.75	1777.09	710109.0
2013-09-18 15:00:00	ES	Futures	1777.35	1778.12	1770.9	1773.48	400843.0
2013-09-18 16:00:00	ES	Futures	1773.48	1773.99	1771.93	1773.22	111934.0
2013-09-18 17:00:00	ES	Futures	1772.96	1773.74	1772.96	1773.74	3837.0
2013-09-18 18:00:00	ES	Futures	1773.22	1774.51	1773.22	1773.99	7304.0
2013-09-18 19:00:00	ES	Futures	1774.25	1775.28	1773.74	1774.25	8099.0
2013-09-18 20:00:00	ES	Futures	1774.25	1774.51	1772.96	1773.48	5858.0
2013-09-18 21:00:00	ES	Futures	1773.48	1774.25	1772.96	1774.25	4411.0
2013-09-18 22:00:00	ES	Futures	1774.25	1775.54	1773.99	1775.28	6909.0
2013-09-18 23:00:00	ES	Futures	1775.28	1775.54	1773.48	1773.74	5801.0
2013-09-18 00:00:00	NQ	Futures	3706.21	3707.08	3705.92	3706.21	221.0
2013-09-18 01:00:00	NQ	Futures	3705.92	3707.95	3705.92	3707.66	285.0
2013-09-18 02:00:00	NQ	Futures	3707.37	3707.37	3704.76	3706.79	704.0
2013-09-18 03:00:00	NQ	Futures	3706.79	3707.66	3703.3	3705.05	2123.0
2013-09-18 04:00:00	NQ	Futures	3705.34	3709.4	3705.34	3709.4	2027.0
2013-09-18 05:00:00	NQ	Futures	3709.11	3711.44	3707.37	3709.11	2320.0
2013-09-18 06:00:00	NQ	Futures	3709.11	3711.15	3706.79	3709.69	1794.0
2013-09-18 07:00:00	NQ	Futures	3709.69	3709.98	3707.37	3708.24	1427.0
2013-09-18 08:00:00	NQ	Futures	3708.24	3709.98	3704.76	3705.92	5582.0
2013-09-18 09:00:00	NQ	Futures	3705.92	3710.28	3704.18	3706.79	19835.0
2013-09-18 10:00:00	NQ	Futures	3707.08	3711.44	3703.89	3707.08	19103.0
2013-09-18 11:00:00	NQ	Futures	3707.08	3708.53	3698.66	3698.95	12538.0
2013-09-18 12:00:00	NQ	Futures	3699.24	3704.47	3698.08	3703.3	10325.0
2013-09-18 13:00:00	NQ	Futures	3703.3	3707.08	3699.53	3702.72	11151.0
2013-09-18 14:00:00	NQ	Futures	3703.3	3749.19	3703.3	3748.9	84243.0
2013-09-18 15:00:00	NQ	Futures	3748.61	3752.1	3741.64	3744.26	39225.0
2013-09-18 16:00:00	NQ	Futures	3744.26	3746.87	3740.77	3746.87	7325.0
2013-09-18 17:00:00	NQ	Futures	3746.87	3748.32	3746.58	3748.03	351.0
2013-09-18 18:00:00	NQ	Futures	3746.0	3750.65	3746.0	3750.35	1229.0
2013-09-18 19:00:00	NQ	Futures	3750.35	3752.97	3749.48	3750.94	808.0
2013-09-18 20:00:00	NQ	Futures	3750.94	3750.94	3747.74	3748.9	701.0
2013-09-18 21:00:00	NQ	Futures	3749.19	3749.77	3747.74	3749.77	660.0
2013-09-18 22:00:00	NQ	Futures	3749.48	3751.81	3749.19	3750.94	648.0
2013-09-18 23:00:00	NQ	Futures	3750.94	3751.52	3748.32	3749.48	399.0
2013-09-18 00:00:00	YM	Futures	15803.8	15804.8	15800.7	15802.8	73.0
2013-09-18 01:00:00	YM	Futures	15801.8	15805.8	15799.7	15802.8	409.0

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

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