PREVIEW / futures_1hour / 2015-04-07

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-04-07.parquet
  size:    50 KB
  rows:    1,552

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-04-07 00:00:00	ES	Futures	2189.54	2190.06	2188.74	2189.01	2283.0
2015-04-07 01:00:00	ES	Futures	2189.01	2190.06	2188.74	2190.06	1701.0
2015-04-07 02:00:00	ES	Futures	2189.8	2191.65	2189.27	2191.39	9546.0
2015-04-07 03:00:00	ES	Futures	2191.12	2194.82	2189.8	2190.86	22544.0
2015-04-07 04:00:00	ES	Futures	2191.12	2191.91	2188.74	2189.27	11562.0
2015-04-07 05:00:00	ES	Futures	2189.01	2190.06	2187.95	2188.48	8119.0
2015-04-07 06:00:00	ES	Futures	2188.48	2191.65	2188.48	2191.39	10048.0
2015-04-07 07:00:00	ES	Futures	2191.65	2196.67	2191.39	2193.76	23366.0
2015-04-07 08:00:00	ES	Futures	2193.5	2195.08	2191.12	2191.65	34897.0
2015-04-07 09:00:00	ES	Futures	2191.91	2199.31	2189.8	2193.23	168078.0
2015-04-07 10:00:00	ES	Futures	2192.97	2200.37	2189.27	2197.72	164717.0
2015-04-07 11:00:00	ES	Futures	2197.46	2198.25	2194.55	2197.99	109140.0
2015-04-07 12:00:00	ES	Futures	2197.72	2199.57	2195.88	2196.93	73701.0
2015-04-07 13:00:00	ES	Futures	2196.93	2198.52	2194.03	2195.08	53816.0
2015-04-07 14:00:00	ES	Futures	2195.08	2197.72	2194.82	2194.82	43579.0
2015-04-07 15:00:00	ES	Futures	2194.82	2195.61	2184.25	2184.52	198980.0
2015-04-07 16:00:00	ES	Futures	2184.25	2186.9	2182.67	2185.05	73233.0
2015-04-07 17:00:00	ES	Futures	2184.78	2185.31	2184.52	2185.05	663.0
2015-04-07 18:00:00	ES	Futures	2185.31	2186.37	2182.67	2183.73	4303.0
2015-04-07 19:00:00	ES	Futures	2183.73	2184.78	2182.93	2184.78	1984.0
2015-04-07 20:00:00	ES	Futures	2184.78	2185.84	2183.99	2185.31	3229.0
2015-04-07 21:00:00	ES	Futures	2185.05	2185.31	2181.35	2182.14	5479.0
2015-04-07 22:00:00	ES	Futures	2182.41	2182.93	2181.08	2182.93	3749.0
2015-04-07 23:00:00	ES	Futures	2182.93	2185.05	2182.41	2185.05	4055.0
2015-04-07 00:00:00	NQ	Futures	5106.41	5107.88	5105.24	5105.83	152.0
2015-04-07 01:00:00	NQ	Futures	5106.12	5110.24	5105.83	5109.94	324.0
2015-04-07 02:00:00	NQ	Futures	5109.65	5114.94	5109.35	5112.29	1250.0
2015-04-07 03:00:00	NQ	Futures	5112.0	5124.06	5108.47	5114.35	3686.0
2015-04-07 04:00:00	NQ	Futures	5114.35	5116.12	5109.65	5110.82	1197.0
2015-04-07 05:00:00	NQ	Futures	5110.53	5112.59	5107.88	5108.47	1091.0
2015-04-07 06:00:00	NQ	Futures	5108.47	5114.94	5108.47	5114.65	1285.0
2015-04-07 07:00:00	NQ	Futures	5114.65	5124.94	5114.35	5117.88	3800.0
2015-04-07 08:00:00	NQ	Futures	5117.59	5121.7	5109.65	5111.71	5217.0
2015-04-07 09:00:00	NQ	Futures	5111.41	5132.58	5103.47	5118.18	39406.0
2015-04-07 10:00:00	NQ	Futures	5118.47	5142.88	5109.94	5135.82	32533.0
2015-04-07 11:00:00	NQ	Futures	5135.53	5137.58	5127.59	5134.64	14679.0
2015-04-07 12:00:00	NQ	Futures	5134.64	5140.52	5128.76	5133.17	12737.0
2015-04-07 13:00:00	NQ	Futures	5133.17	5137.0	5125.82	5128.47	8643.0
2015-04-07 14:00:00	NQ	Futures	5128.47	5133.76	5126.12	5127.0	8902.0
2015-04-07 15:00:00	NQ	Futures	5126.7	5128.47	5099.65	5099.65	28400.0
2015-04-07 16:00:00	NQ	Futures	5099.65	5103.18	5093.47	5097.89	6270.0
2015-04-07 17:00:00	NQ	Futures	5097.89	5098.77	5097.59	5097.59	57.0
2015-04-07 18:00:00	NQ	Futures	5099.36	5101.71	5094.36	5096.71	816.0
2015-04-07 19:00:00	NQ	Futures	5097.0	5099.94	5095.24	5099.94	240.0
2015-04-07 20:00:00	NQ	Futures	5100.24	5100.24	5097.3	5099.36	508.0
2015-04-07 21:00:00	NQ	Futures	5098.77	5099.36	5090.24	5093.77	798.0
2015-04-07 22:00:00	NQ	Futures	5093.47	5096.42	5091.12	5095.83	599.0
2015-04-07 23:00:00	NQ	Futures	5096.12	5100.24	5094.94	5099.36	686.0
2015-04-07 00:00:00	YM	Futures	18670.5	18673.6	18664.2	18666.3	393.0
2015-04-07 01:00:00	YM	Futures	18667.3	18676.8	18664.2	18676.8	400.0

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

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