PREVIEW / futures_1hour / 2013-08-08

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-08.parquet
  size:    50 KB
  rows:    1,532

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-08-08 00:00:00	ES	Futures	1751.04	1751.3	1750.53	1750.53	1150.0
2013-08-08 01:00:00	ES	Futures	1750.53	1750.79	1748.46	1748.72	5751.0
2013-08-08 02:00:00	ES	Futures	1748.98	1750.01	1748.2	1748.46	7843.0
2013-08-08 03:00:00	ES	Futures	1748.46	1750.27	1747.42	1747.42	20603.0
2013-08-08 04:00:00	ES	Futures	1747.42	1749.75	1747.17	1748.72	18634.0
2013-08-08 05:00:00	ES	Futures	1748.46	1750.01	1747.94	1748.72	8625.0
2013-08-08 06:00:00	ES	Futures	1748.72	1752.08	1748.46	1751.56	15942.0
2013-08-08 07:00:00	ES	Futures	1751.56	1753.11	1751.56	1751.82	20412.0
2013-08-08 08:00:00	ES	Futures	1752.08	1752.85	1750.79	1752.08	33897.0
2013-08-08 09:00:00	ES	Futures	1751.82	1754.66	1749.49	1751.04	200270.0
2013-08-08 10:00:00	ES	Futures	1751.3	1751.82	1741.74	1744.58	320785.0
2013-08-08 11:00:00	ES	Futures	1744.32	1747.68	1743.29	1747.42	145708.0
2013-08-08 12:00:00	ES	Futures	1747.42	1753.37	1747.17	1752.34	190902.0
2013-08-08 13:00:00	ES	Futures	1752.59	1754.4	1751.56	1753.37	119644.0
2013-08-08 14:00:00	ES	Futures	1753.37	1754.66	1752.08	1753.11	108272.0
2013-08-08 15:00:00	ES	Futures	1753.11	1753.63	1750.53	1750.53	179827.0
2013-08-08 16:00:00	ES	Futures	1750.53	1752.34	1749.75	1751.82	72388.0
2013-08-08 17:00:00	ES	Futures	1751.82	1752.34	1751.82	1752.08	960.0
2013-08-08 18:00:00	ES	Futures	1751.56	1752.59	1750.79	1751.04	2945.0
2013-08-08 19:00:00	ES	Futures	1751.3	1752.08	1750.01	1750.01	2990.0
2013-08-08 20:00:00	ES	Futures	1750.01	1750.53	1748.72	1749.75	5978.0
2013-08-08 21:00:00	ES	Futures	1749.75	1750.53	1748.98	1750.01	4599.0
2013-08-08 22:00:00	ES	Futures	1750.01	1752.85	1749.75	1751.82	4722.0
2013-08-08 23:00:00	ES	Futures	1752.08	1752.34	1749.75	1750.01	3438.0
2013-08-08 00:00:00	NQ	Futures	3654.7	3655.58	3653.82	3654.12	262.0
2013-08-08 01:00:00	NQ	Futures	3653.82	3653.82	3650.03	3650.32	760.0
2013-08-08 02:00:00	NQ	Futures	3650.03	3652.36	3648.86	3649.15	593.0
2013-08-08 03:00:00	NQ	Futures	3649.15	3652.66	3647.69	3648.56	3248.0
2013-08-08 04:00:00	NQ	Futures	3648.56	3654.12	3647.4	3652.95	3996.0
2013-08-08 05:00:00	NQ	Futures	3652.66	3654.7	3651.49	3653.24	1311.0
2013-08-08 06:00:00	NQ	Futures	3652.95	3657.92	3652.36	3657.62	2528.0
2013-08-08 07:00:00	NQ	Futures	3657.62	3659.38	3657.33	3658.21	2415.0
2013-08-08 08:00:00	NQ	Futures	3658.21	3659.96	3656.46	3658.21	3427.0
2013-08-08 09:00:00	NQ	Futures	3657.92	3662.59	3648.56	3651.19	28385.0
2013-08-08 10:00:00	NQ	Futures	3651.19	3651.19	3633.66	3645.06	41848.0
2013-08-08 11:00:00	NQ	Futures	3645.06	3657.62	3644.47	3657.62	24578.0
2013-08-08 12:00:00	NQ	Futures	3657.33	3666.39	3657.33	3662.3	25121.0
2013-08-08 13:00:00	NQ	Futures	3662.01	3665.22	3660.25	3663.18	12626.0
2013-08-08 14:00:00	NQ	Futures	3663.18	3665.22	3657.04	3659.96	21268.0
2013-08-08 15:00:00	NQ	Futures	3659.67	3662.3	3656.46	3656.75	30816.0
2013-08-08 16:00:00	NQ	Futures	3657.04	3661.13	3655.87	3658.79	6594.0
2013-08-08 17:00:00	NQ	Futures	3658.5	3658.79	3658.5	3658.79	124.0
2013-08-08 18:00:00	NQ	Futures	3657.92	3659.38	3656.46	3657.04	508.0
2013-08-08 19:00:00	NQ	Futures	3657.04	3659.38	3654.7	3655.58	471.0
2013-08-08 20:00:00	NQ	Futures	3655.29	3655.87	3652.95	3654.12	979.0
2013-08-08 21:00:00	NQ	Futures	3654.41	3656.75	3653.24	3656.16	1190.0
2013-08-08 22:00:00	NQ	Futures	3656.16	3660.84	3656.16	3659.09	733.0
2013-08-08 23:00:00	NQ	Futures	3659.09	3660.25	3654.41	3654.99	833.0
2013-08-08 00:00:00	YM	Futures	15736.0	15736.0	15726.8	15729.9	214.0
2013-08-08 01:00:00	YM	Futures	15729.9	15729.9	15712.6	15714.6	877.0

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

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