PREVIEW / futures_1hour / 2014-08-13

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-13.parquet
  size:    49 KB
  rows:    1,548

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
2014-08-13 00:00:00	ES	Futures	2014.02	2014.29	2013.5	2014.02	865.0
2014-08-13 01:00:00	ES	Futures	2013.76	2015.85	2013.5	2015.85	2921.0
2014-08-13 02:00:00	ES	Futures	2015.59	2018.72	2015.33	2018.19	10761.0
2014-08-13 03:00:00	ES	Futures	2018.19	2021.06	2017.93	2020.02	25406.0
2014-08-13 04:00:00	ES	Futures	2020.02	2021.06	2019.5	2020.28	13428.0
2014-08-13 05:00:00	ES	Futures	2020.28	2020.8	2018.72	2019.76	12537.0
2014-08-13 06:00:00	ES	Futures	2020.02	2023.15	2019.24	2022.89	18762.0
2014-08-13 07:00:00	ES	Futures	2022.89	2023.15	2020.54	2022.1	22263.0
2014-08-13 08:00:00	ES	Futures	2022.1	2023.41	2018.72	2019.24	47690.0
2014-08-13 09:00:00	ES	Futures	2018.98	2022.1	2016.37	2017.41	145645.0
2014-08-13 10:00:00	ES	Futures	2017.41	2021.58	2016.11	2021.32	169884.0
2014-08-13 11:00:00	ES	Futures	2021.58	2027.84	2021.06	2024.97	211881.0
2014-08-13 12:00:00	ES	Futures	2024.97	2026.27	2022.89	2025.23	93462.0
2014-08-13 13:00:00	ES	Futures	2025.49	2026.79	2024.19	2026.01	46713.0
2014-08-13 14:00:00	ES	Futures	2026.01	2026.01	2022.89	2023.93	56966.0
2014-08-13 15:00:00	ES	Futures	2024.19	2026.27	2022.89	2026.01	121273.0
2014-08-13 16:00:00	ES	Futures	2026.01	2029.14	2024.97	2028.62	95756.0
2014-08-13 17:00:00	ES	Futures	2028.88	2029.14	2028.36	2028.62	2918.0
2014-08-13 18:00:00	ES	Futures	2028.62	2028.62	2026.79	2027.32	3618.0
2014-08-13 19:00:00	ES	Futures	2027.32	2027.84	2026.53	2026.79	1690.0
2014-08-13 20:00:00	ES	Futures	2027.06	2027.58	2025.49	2026.27	3837.0
2014-08-13 21:00:00	ES	Futures	2026.53	2027.32	2026.01	2027.32	2506.0
2014-08-13 22:00:00	ES	Futures	2027.32	2028.1	2027.06	2027.58	2330.0
2014-08-13 23:00:00	ES	Futures	2027.58	2028.36	2027.32	2028.1	2406.0
2014-08-13 00:00:00	NQ	Futures	4562.15	4562.44	4560.98	4561.85	298.0
2014-08-13 01:00:00	NQ	Futures	4561.56	4566.23	4560.98	4565.36	539.0
2014-08-13 02:00:00	NQ	Futures	4565.36	4572.95	4565.36	4572.07	1172.0
2014-08-13 03:00:00	NQ	Futures	4572.37	4579.08	4571.2	4575.87	4692.0
2014-08-13 04:00:00	NQ	Futures	4576.16	4578.21	4573.83	4576.16	2366.0
2014-08-13 05:00:00	NQ	Futures	4576.45	4577.33	4572.37	4575.29	2335.0
2014-08-13 06:00:00	NQ	Futures	4574.99	4584.92	4572.95	4582.59	4390.0
2014-08-13 07:00:00	NQ	Futures	4582.88	4583.46	4577.62	4581.42	3995.0
2014-08-13 08:00:00	NQ	Futures	4581.13	4584.34	4575.29	4576.45	6541.0
2014-08-13 09:00:00	NQ	Futures	4576.45	4586.67	4572.37	4578.79	27690.0
2014-08-13 10:00:00	NQ	Futures	4578.5	4596.02	4577.62	4595.44	39586.0
2014-08-13 11:00:00	NQ	Futures	4595.44	4607.41	4595.14	4600.98	32443.0
2014-08-13 12:00:00	NQ	Futures	4601.28	4605.36	4596.02	4600.69	17027.0
2014-08-13 13:00:00	NQ	Futures	4600.98	4609.45	4600.11	4607.41	10096.0
2014-08-13 14:00:00	NQ	Futures	4607.7	4608.28	4602.15	4606.53	12917.0
2014-08-13 15:00:00	NQ	Futures	4606.24	4610.33	4603.61	4608.28	22444.0
2014-08-13 16:00:00	NQ	Futures	4608.58	4613.25	4605.66	4611.2	10123.0
2014-08-13 17:00:00	NQ	Futures	4611.2	4611.79	4610.04	4610.91	357.0
2014-08-13 18:00:00	NQ	Futures	4609.74	4610.91	4607.12	4608.58	839.0
2014-08-13 19:00:00	NQ	Futures	4608.28	4608.58	4606.24	4607.12	198.0
2014-08-13 20:00:00	NQ	Futures	4607.12	4608.58	4604.78	4607.12	466.0
2014-08-13 21:00:00	NQ	Futures	4606.82	4608.28	4606.24	4608.28	464.0
2014-08-13 22:00:00	NQ	Futures	4608.58	4610.62	4608.58	4609.74	438.0
2014-08-13 23:00:00	NQ	Futures	4609.45	4611.5	4608.87	4610.33	410.0
2014-08-13 00:00:00	YM	Futures	17100.4	17100.4	17095.2	17096.2	251.0
2014-08-13 01:00:00	YM	Futures	17095.2	17110.7	17094.2	17108.7	444.0

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

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