PREVIEW / futures_1hour / 2013-09-19

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-19.parquet
  size:    50 KB
  rows:    1,527

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-19 00:00:00	ES	Futures	1773.48	1774.51	1773.48	1773.99	1976.0
2013-09-19 01:00:00	ES	Futures	1773.99	1775.54	1773.74	1775.28	5983.0
2013-09-19 02:00:00	ES	Futures	1775.28	1776.06	1773.74	1775.54	13145.0
2013-09-19 03:00:00	ES	Futures	1775.8	1778.64	1775.03	1777.61	45397.0
2013-09-19 04:00:00	ES	Futures	1777.61	1778.38	1777.09	1778.38	22250.0
2013-09-19 05:00:00	ES	Futures	1778.38	1781.73	1778.12	1780.44	39974.0
2013-09-19 06:00:00	ES	Futures	1780.7	1781.47	1779.93	1780.18	17537.0
2013-09-19 07:00:00	ES	Futures	1779.93	1780.7	1776.57	1777.86	23343.0
2013-09-19 08:00:00	ES	Futures	1777.86	1777.86	1775.8	1776.57	50252.0
2013-09-19 09:00:00	ES	Futures	1776.57	1778.64	1772.96	1776.57	264173.0
2013-09-19 10:00:00	ES	Futures	1776.83	1777.61	1772.45	1774.51	290565.0
2013-09-19 11:00:00	ES	Futures	1774.51	1774.77	1770.12	1771.41	195523.0
2013-09-19 12:00:00	ES	Futures	1771.41	1773.48	1770.64	1770.64	99547.0
2013-09-19 13:00:00	ES	Futures	1770.64	1771.67	1768.06	1768.32	138805.0
2013-09-19 14:00:00	ES	Futures	1768.32	1771.16	1767.8	1770.38	98484.0
2013-09-19 15:00:00	ES	Futures	1770.12	1772.19	1769.09	1770.12	182101.0
2013-09-19 16:00:00	ES	Futures	1770.12	1772.45	1769.61	1771.16	76130.0
2013-09-19 17:00:00	ES	Futures	1771.16	1772.19	1770.9	1771.67	3601.0
2013-09-19 18:00:00	ES	Futures	1771.93	1772.19	1770.64	1771.16	5322.0
2013-09-19 19:00:00	ES	Futures	1771.16	1771.41	1770.12	1770.64	1557.0
2013-09-19 20:00:00	ES	Futures	1770.38	1770.64	1769.87	1770.38	2674.0
2013-09-19 21:00:00	ES	Futures	1770.12	1770.38	1768.83	1769.61	4057.0
2013-09-19 22:00:00	ES	Futures	1769.61	1770.38	1769.61	1770.12	1112.0
2013-09-19 23:00:00	ES	Futures	1770.12	1770.38	1769.61	1769.87	1787.0
2013-09-19 00:00:00	NQ	Futures	3748.9	3750.94	3748.9	3750.35	149.0
2013-09-19 01:00:00	NQ	Futures	3750.06	3752.97	3750.06	3752.97	530.0
2013-09-19 02:00:00	NQ	Futures	3752.68	3752.97	3749.48	3752.68	1206.0
2013-09-19 03:00:00	NQ	Futures	3752.39	3755.0	3749.77	3753.55	3405.0
2013-09-19 04:00:00	NQ	Futures	3753.55	3753.84	3750.35	3753.26	3362.0
2013-09-19 05:00:00	NQ	Futures	3753.55	3759.07	3753.26	3757.91	3547.0
2013-09-19 06:00:00	NQ	Futures	3757.91	3758.49	3756.45	3756.74	1556.0
2013-09-19 07:00:00	NQ	Futures	3756.45	3757.62	3751.23	3752.68	2726.0
2013-09-19 08:00:00	NQ	Futures	3752.68	3754.42	3750.06	3751.81	5429.0
2013-09-19 09:00:00	NQ	Futures	3751.52	3761.39	3748.32	3759.65	35261.0
2013-09-19 10:00:00	NQ	Futures	3759.65	3760.52	3746.29	3753.26	28126.0
2013-09-19 11:00:00	NQ	Futures	3753.55	3754.13	3746.58	3748.9	20727.0
2013-09-19 12:00:00	NQ	Futures	3748.9	3754.71	3748.32	3750.94	11693.0
2013-09-19 13:00:00	NQ	Futures	3750.65	3755.29	3746.58	3747.45	15486.0
2013-09-19 14:00:00	NQ	Futures	3747.16	3754.13	3746.58	3754.13	10572.0
2013-09-19 15:00:00	NQ	Futures	3754.13	3757.62	3750.65	3752.1	27102.0
2013-09-19 16:00:00	NQ	Futures	3752.1	3757.62	3751.23	3753.26	6919.0
2013-09-19 17:00:00	NQ	Futures	3753.26	3755.29	3752.68	3754.71	208.0
2013-09-19 18:00:00	NQ	Futures	3757.03	3757.03	3750.94	3752.97	716.0
2013-09-19 19:00:00	NQ	Futures	3752.97	3752.97	3750.35	3751.23	253.0
2013-09-19 20:00:00	NQ	Futures	3750.94	3751.52	3750.06	3750.94	408.0
2013-09-19 21:00:00	NQ	Futures	3750.94	3751.23	3748.61	3749.48	701.0
2013-09-19 22:00:00	NQ	Futures	3749.48	3750.94	3749.19	3750.35	169.0
2013-09-19 23:00:00	NQ	Futures	3750.35	3750.94	3749.77	3750.06	218.0
2013-09-19 00:00:00	YM	Futures	15936.6	15941.7	15935.5	15939.6	252.0
2013-09-19 01:00:00	YM	Futures	15938.6	15947.8	15935.5	15946.8	665.0

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

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