PREVIEW / futures_1hour / 2015-04-16

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-04-16.parquet
  size:    52 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-04-16 00:00:00	ES	Futures	2220.97	2221.23	2220.44	2221.23	1255.0
2015-04-16 01:00:00	ES	Futures	2221.23	2221.49	2220.17	2220.7	2453.0
2015-04-16 02:00:00	ES	Futures	2220.44	2221.49	2218.59	2219.12	6278.0
2015-04-16 03:00:00	ES	Futures	2219.12	2219.38	2216.21	2217.0	23928.0
2015-04-16 04:00:00	ES	Futures	2216.74	2218.85	2216.21	2217.27	9082.0
2015-04-16 05:00:00	ES	Futures	2217.53	2218.59	2215.16	2215.16	8903.0
2015-04-16 06:00:00	ES	Futures	2215.42	2216.21	2209.61	2210.67	33393.0
2015-04-16 07:00:00	ES	Futures	2210.4	2210.93	2206.97	2209.35	42402.0
2015-04-16 08:00:00	ES	Futures	2209.08	2211.72	2208.82	2208.82	32579.0
2015-04-16 09:00:00	ES	Futures	2209.08	2215.95	2208.55	2213.31	169128.0
2015-04-16 10:00:00	ES	Futures	2213.04	2217.53	2210.93	2215.68	180940.0
2015-04-16 11:00:00	ES	Futures	2215.42	2218.06	2213.31	2215.42	108492.0
2015-04-16 12:00:00	ES	Futures	2215.42	2218.33	2215.16	2217.0	53629.0
2015-04-16 13:00:00	ES	Futures	2217.0	2223.34	2215.95	2223.08	87852.0
2015-04-16 14:00:00	ES	Futures	2223.08	2223.61	2219.91	2219.91	70012.0
2015-04-16 15:00:00	ES	Futures	2220.17	2220.7	2215.68	2217.0	181211.0
2015-04-16 16:00:00	ES	Futures	2217.0	2219.91	2216.48	2219.12	81159.0
2015-04-16 17:00:00	ES	Futures	2219.12	2219.91	2218.85	2219.91	1572.0
2015-04-16 18:00:00	ES	Futures	2219.91	2220.44	2219.12	2219.65	2896.0
2015-04-16 19:00:00	ES	Futures	2219.91	2220.17	2219.38	2219.65	819.0
2015-04-16 20:00:00	ES	Futures	2219.65	2219.65	2216.74	2217.8	8573.0
2015-04-16 21:00:00	ES	Futures	2218.06	2218.85	2217.53	2218.59	2822.0
2015-04-16 22:00:00	ES	Futures	2218.59	2219.12	2217.27	2217.8	4570.0
2015-04-16 23:00:00	ES	Futures	2217.8	2218.33	2217.27	2217.53	2481.0
2015-04-16 00:00:00	NQ	Futures	5209.34	5209.63	5207.87	5209.04	167.0
2015-04-16 01:00:00	NQ	Futures	5208.75	5210.22	5206.69	5208.45	346.0
2015-04-16 02:00:00	NQ	Futures	5208.16	5209.63	5203.45	5205.81	821.0
2015-04-16 03:00:00	NQ	Futures	5206.1	5206.39	5198.16	5199.34	2861.0
2015-04-16 04:00:00	NQ	Futures	5199.63	5203.75	5197.87	5201.4	1011.0
2015-04-16 05:00:00	NQ	Futures	5201.69	5202.87	5195.81	5196.4	1205.0
2015-04-16 06:00:00	NQ	Futures	5196.69	5198.46	5186.69	5189.05	4879.0
2015-04-16 07:00:00	NQ	Futures	5188.75	5189.34	5173.17	5178.75	7121.0
2015-04-16 08:00:00	NQ	Futures	5179.05	5183.46	5177.28	5179.05	4153.0
2015-04-16 09:00:00	NQ	Futures	5179.05	5197.87	5178.75	5190.22	33113.0
2015-04-16 10:00:00	NQ	Futures	5189.93	5195.81	5176.69	5187.28	31290.0
2015-04-16 11:00:00	NQ	Futures	5187.28	5193.75	5183.75	5189.05	14584.0
2015-04-16 12:00:00	NQ	Futures	5189.05	5193.16	5186.4	5189.05	8220.0
2015-04-16 13:00:00	NQ	Futures	5188.75	5199.34	5184.05	5198.16	12741.0
2015-04-16 14:00:00	NQ	Futures	5198.16	5199.93	5190.81	5190.81	9115.0
2015-04-16 15:00:00	NQ	Futures	5190.81	5195.51	5184.93	5190.22	23503.0
2015-04-16 16:00:00	NQ	Futures	5190.22	5194.63	5187.28	5192.28	5694.0
2015-04-16 17:00:00	NQ	Futures	5192.28	5193.16	5191.69	5192.87	127.0
2015-04-16 18:00:00	NQ	Futures	5194.63	5196.1	5193.16	5194.93	371.0
2015-04-16 19:00:00	NQ	Futures	5194.34	5194.93	5193.16	5193.75	84.0
2015-04-16 20:00:00	NQ	Futures	5193.46	5194.04	5188.46	5190.52	876.0
2015-04-16 21:00:00	NQ	Futures	5190.22	5192.57	5189.93	5191.99	167.0
2015-04-16 22:00:00	NQ	Futures	5191.99	5193.16	5188.75	5190.22	472.0
2015-04-16 23:00:00	NQ	Futures	5190.22	5190.52	5188.75	5188.75	144.0
2015-04-16 00:00:00	YM	Futures	18922.1	18925.3	18917.9	18925.3	452.0
2015-04-16 01:00:00	YM	Futures	18922.1	18927.4	18917.9	18920.0	289.0

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

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