PREVIEW / futures_1hour / 2014-10-07

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-07.parquet
  size:    53 KB
  rows:    1,598

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-10-07 00:00:00	ES	Futures	2048.85	2049.63	2048.58	2049.11	1618.0
2014-10-07 01:00:00	ES	Futures	2049.37	2049.63	2046.49	2046.75	3383.0
2014-10-07 02:00:00	ES	Futures	2047.01	2048.32	2045.44	2047.8	8001.0
2014-10-07 03:00:00	ES	Futures	2047.54	2047.8	2042.04	2042.82	45523.0
2014-10-07 04:00:00	ES	Futures	2042.82	2044.13	2037.84	2038.89	31553.0
2014-10-07 05:00:00	ES	Futures	2039.15	2042.04	2037.84	2041.77	23272.0
2014-10-07 06:00:00	ES	Futures	2041.51	2043.08	2040.73	2042.3	15323.0
2014-10-07 07:00:00	ES	Futures	2042.04	2045.7	2040.99	2045.7	24698.0
2014-10-07 08:00:00	ES	Futures	2045.7	2047.54	2044.39	2045.7	34164.0
2014-10-07 09:00:00	ES	Futures	2045.7	2046.23	2032.6	2038.11	300116.0
2014-10-07 10:00:00	ES	Futures	2038.11	2045.18	2037.06	2038.89	325149.0
2014-10-07 11:00:00	ES	Futures	2038.89	2039.94	2032.87	2038.63	291466.0
2014-10-07 12:00:00	ES	Futures	2038.63	2043.08	2036.27	2037.58	138293.0
2014-10-07 13:00:00	ES	Futures	2037.58	2041.25	2034.96	2038.63	128963.0
2014-10-07 14:00:00	ES	Futures	2038.37	2039.15	2029.46	2030.51	199737.0
2014-10-07 15:00:00	ES	Futures	2030.51	2032.08	2018.98	2019.24	425470.0
2014-10-07 16:00:00	ES	Futures	2019.24	2021.86	2016.62	2017.15	133782.0
2014-10-07 17:00:00	ES	Futures	2017.41	2017.67	2016.36	2017.15	3042.0
2014-10-07 18:00:00	ES	Futures	2018.46	2019.24	2017.93	2018.72	7930.0
2014-10-07 19:00:00	ES	Futures	2018.72	2021.08	2018.46	2020.82	5886.0
2014-10-07 20:00:00	ES	Futures	2020.82	2023.44	2020.55	2022.65	11250.0
2014-10-07 21:00:00	ES	Futures	2022.65	2023.7	2021.6	2022.39	6566.0
2014-10-07 22:00:00	ES	Futures	2022.39	2023.44	2021.34	2022.91	3304.0
2014-10-07 23:00:00	ES	Futures	2023.17	2023.96	2022.65	2023.44	3934.0
2014-10-07 00:00:00	NQ	Futures	4698.35	4699.81	4696.0	4698.93	453.0
2014-10-07 01:00:00	NQ	Futures	4698.93	4699.52	4692.19	4692.49	559.0
2014-10-07 02:00:00	NQ	Futures	4693.07	4696.3	4688.38	4693.37	1337.0
2014-10-07 03:00:00	NQ	Futures	4693.37	4693.95	4678.13	4679.59	7621.0
2014-10-07 04:00:00	NQ	Futures	4679.89	4682.82	4668.46	4671.1	4821.0
2014-10-07 05:00:00	NQ	Futures	4671.39	4679.59	4668.75	4678.72	4220.0
2014-10-07 06:00:00	NQ	Futures	4678.42	4683.11	4676.37	4680.47	2815.0
2014-10-07 07:00:00	NQ	Futures	4680.18	4688.09	4676.96	4688.09	4165.0
2014-10-07 08:00:00	NQ	Futures	4688.09	4693.37	4685.75	4689.26	6190.0
2014-10-07 09:00:00	NQ	Futures	4689.26	4690.73	4656.74	4666.7	58589.0
2014-10-07 10:00:00	NQ	Futures	4666.41	4689.56	4664.65	4669.93	57967.0
2014-10-07 11:00:00	NQ	Futures	4669.93	4673.44	4655.86	4670.22	55834.0
2014-10-07 12:00:00	NQ	Futures	4670.51	4681.94	4663.48	4665.53	28508.0
2014-10-07 13:00:00	NQ	Futures	4665.82	4672.27	4657.33	4667.87	25699.0
2014-10-07 14:00:00	NQ	Futures	4667.58	4669.63	4647.07	4650.29	35520.0
2014-10-07 15:00:00	NQ	Futures	4650.0	4656.15	4630.96	4631.54	68288.0
2014-10-07 16:00:00	NQ	Futures	4631.83	4640.33	4628.32	4629.49	17463.0
2014-10-07 17:00:00	NQ	Futures	4629.49	4630.08	4627.15	4628.03	619.0
2014-10-07 18:00:00	NQ	Futures	4633.59	4634.76	4631.54	4633.3	886.0
2014-10-07 19:00:00	NQ	Futures	4633.3	4639.45	4633.01	4637.99	998.0
2014-10-07 20:00:00	NQ	Futures	4638.57	4643.85	4638.28	4641.8	1943.0
2014-10-07 21:00:00	NQ	Futures	4641.8	4644.43	4638.57	4640.92	1016.0
2014-10-07 22:00:00	NQ	Futures	4640.62	4642.68	4638.28	4641.8	589.0
2014-10-07 23:00:00	NQ	Futures	4641.8	4644.14	4641.21	4643.26	506.0
2014-10-07 00:00:00	YM	Futures	17566.8	17572.0	17563.7	17568.9	155.0
2014-10-07 01:00:00	YM	Futures	17569.9	17571.0	17548.1	17550.2	530.0

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

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