PREVIEW / futures_1hour / 2015-03-05

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-05.parquet
  size:    48 KB
  rows:    1,516

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-03-05 00:00:00	ES	Futures	2208.11	2208.63	2206.53	2207.58	2976.0
2015-03-05 01:00:00	ES	Futures	2208.11	2208.9	2207.05	2208.9	1921.0
2015-03-05 02:00:00	ES	Futures	2208.9	2209.42	2207.58	2208.37	5640.0
2015-03-05 03:00:00	ES	Futures	2208.37	2209.69	2207.05	2208.37	13083.0
2015-03-05 04:00:00	ES	Futures	2208.37	2208.9	2206.0	2206.53	10246.0
2015-03-05 05:00:00	ES	Futures	2206.53	2208.63	2206.53	2208.11	6359.0
2015-03-05 06:00:00	ES	Futures	2208.11	2210.74	2208.11	2208.9	13137.0
2015-03-05 07:00:00	ES	Futures	2209.16	2211.0	2208.37	2211.0	14376.0
2015-03-05 08:00:00	ES	Futures	2211.0	2214.16	2209.16	2211.27	53514.0
2015-03-05 09:00:00	ES	Futures	2211.53	2213.11	2206.27	2211.0	188332.0
2015-03-05 10:00:00	ES	Futures	2210.74	2213.37	2209.42	2212.05	158409.0
2015-03-05 11:00:00	ES	Futures	2212.05	2212.32	2206.53	2211.53	141244.0
2015-03-05 12:00:00	ES	Futures	2211.27	2211.53	2203.37	2204.42	98483.0
2015-03-05 13:00:00	ES	Futures	2204.16	2209.16	2203.63	2208.9	72887.0
2015-03-05 14:00:00	ES	Futures	2208.9	2211.79	2208.11	2210.74	70381.0
2015-03-05 15:00:00	ES	Futures	2210.74	2211.53	2207.84	2209.69	158072.0
2015-03-05 16:00:00	ES	Futures	2209.95	2210.74	2209.69	2209.95	60303.0
2015-03-05 17:00:00	ES	Futures	2210.21	2210.21	2209.69	2209.95	1482.0
2015-03-05 18:00:00	ES	Futures	2209.95	2210.48	2209.42	2210.21	2658.0
2015-03-05 19:00:00	ES	Futures	2210.48	2210.48	2209.69	2209.95	1572.0
2015-03-05 20:00:00	ES	Futures	2209.69	2211.0	2209.42	2210.74	1210.0
2015-03-05 21:00:00	ES	Futures	2211.0	2211.27	2209.95	2210.48	1502.0
2015-03-05 22:00:00	ES	Futures	2210.48	2210.48	2209.95	2209.95	767.0
2015-03-05 23:00:00	ES	Futures	2210.21	2210.21	2208.9	2209.42	1875.0
2015-03-05 00:00:00	NQ	Futures	5222.66	5223.25	5219.43	5221.49	389.0
2015-03-05 01:00:00	NQ	Futures	5221.49	5223.25	5220.02	5223.25	148.0
2015-03-05 02:00:00	NQ	Futures	5223.25	5225.01	5221.78	5223.54	525.0
2015-03-05 03:00:00	NQ	Futures	5223.54	5228.83	5222.37	5225.89	2630.0
2015-03-05 04:00:00	NQ	Futures	5225.89	5227.36	5220.6	5221.49	1496.0
2015-03-05 05:00:00	NQ	Futures	5221.78	5227.36	5221.49	5226.19	856.0
2015-03-05 06:00:00	NQ	Futures	5226.48	5232.35	5226.48	5227.36	2314.0
2015-03-05 07:00:00	NQ	Futures	5227.36	5231.18	5226.19	5229.12	1629.0
2015-03-05 08:00:00	NQ	Futures	5229.42	5237.93	5227.95	5231.47	7944.0
2015-03-05 09:00:00	NQ	Futures	5231.77	5240.28	5226.48	5235.29	28978.0
2015-03-05 10:00:00	NQ	Futures	5235.29	5244.98	5232.94	5237.93	27090.0
2015-03-05 11:00:00	NQ	Futures	5237.64	5237.93	5218.84	5233.23	26598.0
2015-03-05 12:00:00	NQ	Futures	5233.23	5233.23	5207.39	5210.33	19129.0
2015-03-05 13:00:00	NQ	Futures	5210.03	5226.77	5208.27	5226.19	16791.0
2015-03-05 14:00:00	NQ	Futures	5226.19	5236.17	5224.42	5233.53	14175.0
2015-03-05 15:00:00	NQ	Futures	5233.82	5233.82	5224.13	5228.24	27101.0
2015-03-05 16:00:00	NQ	Futures	5228.24	5230.0	5226.77	5228.53	4577.0
2015-03-05 17:00:00	NQ	Futures	5228.24	5230.59	5226.77	5227.65	558.0
2015-03-05 18:00:00	NQ	Futures	5229.42	5229.71	5226.19	5229.71	303.0
2015-03-05 19:00:00	NQ	Futures	5229.42	5229.42	5227.95	5228.24	112.0
2015-03-05 20:00:00	NQ	Futures	5228.24	5230.3	5227.95	5229.42	215.0
2015-03-05 21:00:00	NQ	Futures	5229.71	5230.3	5228.53	5228.83	132.0
2015-03-05 22:00:00	NQ	Futures	5228.53	5229.71	5228.24	5228.83	121.0
2015-03-05 23:00:00	NQ	Futures	5228.83	5228.83	5226.19	5227.95	281.0
2015-03-05 00:00:00	YM	Futures	18892.1	18893.1	18879.6	18890.0	366.0
2015-03-05 01:00:00	YM	Futures	18890.0	18896.3	18884.8	18895.2	257.0

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

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