PREVIEW / futures_1hour / 2015-01-14

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-14.parquet
  size:    54 KB
  rows:    1,599

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
2015-01-14 00:00:00	ES	Futures	2115.21	2115.74	2110.48	2112.85	4811.0
2015-01-14 01:00:00	ES	Futures	2112.85	2115.21	2101.27	2102.85	20431.0
2015-01-14 02:00:00	ES	Futures	2102.85	2110.21	2102.32	2109.43	16408.0
2015-01-14 03:00:00	ES	Futures	2109.43	2117.58	2106.53	2110.21	54343.0
2015-01-14 04:00:00	ES	Futures	2110.21	2121.0	2108.11	2120.74	27494.0
2015-01-14 05:00:00	ES	Futures	2121.0	2125.74	2114.95	2116.79	27229.0
2015-01-14 06:00:00	ES	Futures	2117.06	2118.9	2112.32	2112.32	23457.0
2015-01-14 07:00:00	ES	Futures	2112.32	2116.0	2108.64	2108.9	37193.0
2015-01-14 08:00:00	ES	Futures	2108.9	2111.27	2089.69	2097.06	159446.0
2015-01-14 09:00:00	ES	Futures	2096.79	2105.48	2092.85	2102.32	307937.0
2015-01-14 10:00:00	ES	Futures	2102.32	2112.58	2101.79	2106.79	446672.0
2015-01-14 11:00:00	ES	Futures	2106.79	2107.32	2096.79	2098.11	278988.0
2015-01-14 12:00:00	ES	Futures	2098.37	2100.74	2093.37	2096.79	195337.0
2015-01-14 13:00:00	ES	Futures	2097.06	2099.16	2085.48	2090.48	179875.0
2015-01-14 14:00:00	ES	Futures	2090.48	2108.64	2089.43	2098.64	294458.0
2015-01-14 15:00:00	ES	Futures	2098.37	2112.06	2098.11	2110.21	292785.0
2015-01-14 16:00:00	ES	Futures	2109.95	2116.79	2108.9	2116.27	83849.0
2015-01-14 17:00:00	ES	Futures	2116.27	2116.79	2115.74	2116.0	2978.0
2015-01-14 18:00:00	ES	Futures	2115.48	2117.32	2114.43	2115.48	5345.0
2015-01-14 19:00:00	ES	Futures	2115.48	2117.85	2113.11	2114.43	7029.0
2015-01-14 20:00:00	ES	Futures	2114.69	2116.79	2112.85	2114.43	5859.0
2015-01-14 21:00:00	ES	Futures	2114.43	2116.53	2114.43	2116.27	3524.0
2015-01-14 22:00:00	ES	Futures	2116.27	2116.53	2112.85	2113.9	3325.0
2015-01-14 23:00:00	ES	Futures	2114.16	2116.0	2113.37	2115.74	2142.0
2015-01-14 00:00:00	NQ	Futures	4870.82	4872.0	4860.25	4865.54	837.0
2015-01-14 01:00:00	NQ	Futures	4865.24	4870.53	4836.17	4839.69	4038.0
2015-01-14 02:00:00	NQ	Futures	4839.4	4861.13	4837.93	4858.19	2543.0
2015-01-14 03:00:00	NQ	Futures	4858.19	4879.05	4851.44	4862.89	14261.0
2015-01-14 04:00:00	NQ	Futures	4862.31	4886.97	4854.96	4886.97	5610.0
2015-01-14 05:00:00	NQ	Futures	4887.27	4897.84	4871.12	4874.35	5231.0
2015-01-14 06:00:00	NQ	Futures	4874.93	4880.51	4867.3	4867.3	2825.0
2015-01-14 07:00:00	NQ	Futures	4867.0	4875.23	4860.25	4862.01	5100.0
2015-01-14 08:00:00	NQ	Futures	4861.72	4866.12	4820.6	4840.87	28857.0
2015-01-14 09:00:00	NQ	Futures	4840.57	4865.83	4830.29	4861.13	68416.0
2015-01-14 10:00:00	NQ	Futures	4861.42	4885.8	4852.03	4863.19	66522.0
2015-01-14 11:00:00	NQ	Futures	4863.48	4864.95	4841.45	4844.68	46128.0
2015-01-14 12:00:00	NQ	Futures	4844.98	4852.61	4834.4	4845.27	32218.0
2015-01-14 13:00:00	NQ	Futures	4845.27	4850.26	4817.08	4830.0	30169.0
2015-01-14 14:00:00	NQ	Futures	4829.71	4866.12	4827.06	4840.28	49313.0
2015-01-14 15:00:00	NQ	Futures	4840.57	4870.23	4839.98	4861.72	66639.0
2015-01-14 16:00:00	NQ	Futures	4861.72	4877.58	4859.37	4874.93	9265.0
2015-01-14 17:00:00	NQ	Futures	4875.23	4876.4	4874.35	4874.35	156.0
2015-01-14 18:00:00	NQ	Futures	4872.29	4878.16	4872.29	4875.23	850.0
2015-01-14 19:00:00	NQ	Futures	4875.23	4880.22	4871.12	4874.05	1474.0
2015-01-14 20:00:00	NQ	Futures	4874.05	4879.05	4870.53	4874.35	904.0
2015-01-14 21:00:00	NQ	Futures	4874.35	4878.46	4874.05	4876.7	784.0
2015-01-14 22:00:00	NQ	Futures	4877.28	4878.16	4871.12	4873.47	628.0
2015-01-14 23:00:00	NQ	Futures	4873.76	4878.16	4872.29	4877.28	409.0
2015-01-14 00:00:00	YM	Futures	18249.1	18253.2	18212.5	18231.3	666.0
2015-01-14 01:00:00	YM	Futures	18231.3	18249.1	18136.3	18154.1	5172.0

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

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