PREVIEW / futures_1hour / 2014-10-01

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-01.parquet
  size:    54 KB
  rows:    1,608

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-01 00:00:00	ES	Futures	2057.23	2058.54	2056.44	2057.75	4501.0
2014-10-01 01:00:00	ES	Futures	2057.75	2058.28	2055.92	2056.18	5184.0
2014-10-01 02:00:00	ES	Futures	2056.44	2058.8	2055.92	2057.23	7204.0
2014-10-01 03:00:00	ES	Futures	2057.49	2061.16	2057.23	2058.02	26825.0
2014-10-01 04:00:00	ES	Futures	2058.02	2060.11	2055.92	2059.59	21667.0
2014-10-01 05:00:00	ES	Futures	2059.59	2060.64	2056.71	2057.49	13533.0
2014-10-01 06:00:00	ES	Futures	2057.23	2058.54	2056.97	2057.75	13433.0
2014-10-01 07:00:00	ES	Futures	2057.75	2058.54	2054.35	2055.4	20011.0
2014-10-01 08:00:00	ES	Futures	2055.4	2056.44	2051.47	2054.87	66062.0
2014-10-01 09:00:00	ES	Futures	2054.87	2057.23	2042.3	2046.23	325522.0
2014-10-01 10:00:00	ES	Futures	2045.97	2048.06	2039.68	2047.54	415598.0
2014-10-01 11:00:00	ES	Futures	2047.28	2050.94	2042.04	2044.66	259387.0
2014-10-01 12:00:00	ES	Futures	2044.39	2045.18	2037.32	2038.63	214664.0
2014-10-01 13:00:00	ES	Futures	2038.63	2039.94	2030.51	2031.3	273126.0
2014-10-01 14:00:00	ES	Futures	2031.3	2036.27	2028.94	2029.72	187219.0
2014-10-01 15:00:00	ES	Futures	2029.72	2037.06	2026.32	2031.03	437214.0
2014-10-01 16:00:00	ES	Futures	2030.77	2034.96	2030.51	2034.7	108773.0
2014-10-01 17:00:00	ES	Futures	2034.7	2034.96	2033.13	2033.91	3938.0
2014-10-01 18:00:00	ES	Futures	2033.65	2035.49	2033.65	2034.44	4762.0
2014-10-01 19:00:00	ES	Futures	2034.44	2034.96	2033.39	2034.18	3574.0
2014-10-01 20:00:00	ES	Futures	2034.18	2035.49	2033.39	2035.22	5405.0
2014-10-01 21:00:00	ES	Futures	2035.22	2035.49	2034.7	2035.22	4189.0
2014-10-01 22:00:00	ES	Futures	2035.22	2035.22	2033.13	2034.7	5310.0
2014-10-01 23:00:00	ES	Futures	2034.96	2035.49	2034.18	2035.22	4786.0
2014-10-01 00:00:00	NQ	Futures	4733.51	4735.27	4730.87	4732.92	1294.0
2014-10-01 01:00:00	NQ	Futures	4732.34	4734.68	4730.28	4731.75	2040.0
2014-10-01 02:00:00	NQ	Futures	4732.04	4735.56	4730.28	4732.63	1789.0
2014-10-01 03:00:00	NQ	Futures	4732.34	4742.0	4731.75	4734.97	4093.0
2014-10-01 04:00:00	NQ	Futures	4735.27	4738.49	4728.23	4737.32	3367.0
2014-10-01 05:00:00	NQ	Futures	4737.02	4739.37	4731.75	4732.92	2407.0
2014-10-01 06:00:00	NQ	Futures	4732.63	4735.85	4731.46	4732.92	1870.0
2014-10-01 07:00:00	NQ	Futures	4732.63	4734.09	4724.72	4727.94	4481.0
2014-10-01 08:00:00	NQ	Futures	4727.65	4731.16	4720.62	4727.06	11441.0
2014-10-01 09:00:00	NQ	Futures	4726.77	4732.04	4695.42	4699.23	56791.0
2014-10-01 10:00:00	NQ	Futures	4699.23	4702.16	4678.42	4693.66	77835.0
2014-10-01 11:00:00	NQ	Futures	4693.66	4704.79	4684.58	4691.02	47954.0
2014-10-01 12:00:00	NQ	Futures	4691.31	4691.61	4671.68	4675.2	42838.0
2014-10-01 13:00:00	NQ	Futures	4675.49	4678.72	4654.69	4656.74	49237.0
2014-10-01 14:00:00	NQ	Futures	4657.03	4672.27	4653.81	4655.27	42247.0
2014-10-01 15:00:00	NQ	Futures	4655.27	4672.56	4647.66	4662.6	66503.0
2014-10-01 16:00:00	NQ	Futures	4662.6	4671.68	4662.31	4669.93	11369.0
2014-10-01 17:00:00	NQ	Futures	4669.63	4670.51	4665.82	4668.75	324.0
2014-10-01 18:00:00	NQ	Futures	4666.41	4671.68	4666.41	4668.46	631.0
2014-10-01 19:00:00	NQ	Futures	4669.05	4669.93	4666.41	4667.58	612.0
2014-10-01 20:00:00	NQ	Futures	4667.0	4670.8	4665.53	4669.63	878.0
2014-10-01 21:00:00	NQ	Futures	4669.34	4671.68	4668.17	4669.63	728.0
2014-10-01 22:00:00	NQ	Futures	4669.93	4670.51	4665.53	4668.75	896.0
2014-10-01 23:00:00	NQ	Futures	4669.05	4671.68	4667.87	4670.22	922.0
2014-10-01 00:00:00	YM	Futures	17626.1	17636.5	17621.9	17630.2	419.0
2014-10-01 01:00:00	YM	Futures	17630.2	17633.3	17619.8	17619.8	993.0

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

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