PREVIEW / futures_1hour / 2016-05-23

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-23.parquet
  size:    50 KB
  rows:    1,598

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
2016-05-23 00:00:00	ES	Futures	2216.81	2217.35	2215.46	2216.27	3179.0
2016-05-23 01:00:00	ES	Futures	2216.27	2216.27	2213.84	2214.38	3780.0
2016-05-23 02:00:00	ES	Futures	2214.65	2216.54	2213.84	2214.11	9714.0
2016-05-23 03:00:00	ES	Futures	2214.11	2214.38	2206.82	2210.6	38177.0
2016-05-23 04:00:00	ES	Futures	2210.87	2220.32	2210.06	2218.16	31663.0
2016-05-23 05:00:00	ES	Futures	2217.89	2218.7	2210.06	2210.6	21767.0
2016-05-23 06:00:00	ES	Futures	2210.6	2211.95	2208.44	2210.6	19690.0
2016-05-23 07:00:00	ES	Futures	2210.6	2215.73	2209.25	2214.11	18962.0
2016-05-23 08:00:00	ES	Futures	2214.11	2214.65	2210.87	2211.14	21961.0
2016-05-23 09:00:00	ES	Futures	2211.14	2215.19	2209.79	2212.49	189519.0
2016-05-23 10:00:00	ES	Futures	2212.49	2216.81	2210.87	2211.95	202220.0
2016-05-23 11:00:00	ES	Futures	2211.95	2215.46	2209.25	2210.06	131517.0
2016-05-23 12:00:00	ES	Futures	2210.33	2213.84	2209.79	2213.57	76971.0
2016-05-23 13:00:00	ES	Futures	2213.57	2215.19	2212.22	2213.3	78986.0
2016-05-23 14:00:00	ES	Futures	2213.57	2215.73	2212.76	2213.3	73923.0
2016-05-23 15:00:00	ES	Futures	2213.3	2214.38	2207.63	2209.52	162744.0
2016-05-23 16:00:00	ES	Futures	2209.52	2210.6	2207.36	2208.44	51977.0
2016-05-23 18:00:00	ES	Futures	2208.44	2209.52	2207.9	2209.25	2385.0
2016-05-23 19:00:00	ES	Futures	2208.98	2209.52	2208.71	2208.98	1357.0
2016-05-23 20:00:00	ES	Futures	2208.98	2210.87	2208.71	2209.52	4608.0
2016-05-23 21:00:00	ES	Futures	2209.79	2211.14	2209.52	2210.06	4547.0
2016-05-23 22:00:00	ES	Futures	2210.33	2211.14	2208.98	2210.33	3558.0
2016-05-23 23:00:00	ES	Futures	2210.33	2210.6	2207.9	2209.52	4485.0
2016-05-23 00:00:00	NQ	Futures	5204.09	5204.69	5199.63	5203.5	648.0
2016-05-23 01:00:00	NQ	Futures	5203.2	5203.5	5195.46	5196.95	587.0
2016-05-23 02:00:00	NQ	Futures	5196.95	5203.5	5194.87	5195.17	1231.0
2016-05-23 03:00:00	NQ	Futures	5195.76	5196.06	5174.93	5184.75	5078.0
2016-05-23 04:00:00	NQ	Futures	5184.75	5210.64	5182.37	5204.09	4044.0
2016-05-23 05:00:00	NQ	Futures	5203.79	5207.66	5182.67	5183.86	2558.0
2016-05-23 06:00:00	NQ	Futures	5183.86	5189.51	5178.21	5186.84	2896.0
2016-05-23 07:00:00	NQ	Futures	5186.24	5202.01	5184.46	5198.74	2144.0
2016-05-23 08:00:00	NQ	Futures	5198.44	5199.03	5189.22	5190.11	3033.0
2016-05-23 09:00:00	NQ	Futures	5189.81	5212.72	5189.22	5206.47	31587.0
2016-05-23 10:00:00	NQ	Futures	5206.47	5214.51	5197.25	5200.22	28835.0
2016-05-23 11:00:00	NQ	Futures	5200.22	5209.15	5191.0	5194.27	18028.0
2016-05-23 12:00:00	NQ	Futures	5194.57	5203.2	5192.49	5201.41	10918.0
2016-05-23 13:00:00	NQ	Futures	5201.71	5204.39	5191.89	5196.95	9538.0
2016-05-23 14:00:00	NQ	Futures	5196.95	5203.2	5193.68	5195.46	8952.0
2016-05-23 15:00:00	NQ	Futures	5195.17	5197.84	5177.61	5180.29	24031.0
2016-05-23 16:00:00	NQ	Futures	5180.29	5182.67	5176.42	5180.59	5635.0
2016-05-23 18:00:00	NQ	Futures	5178.8	5181.48	5178.8	5180.88	403.0
2016-05-23 19:00:00	NQ	Futures	5181.18	5181.48	5179.4	5179.99	252.0
2016-05-23 20:00:00	NQ	Futures	5179.99	5183.86	5178.5	5180.88	580.0
2016-05-23 21:00:00	NQ	Futures	5180.88	5185.05	5180.29	5182.07	689.0
2016-05-23 22:00:00	NQ	Futures	5182.07	5185.05	5179.69	5183.26	581.0
2016-05-23 23:00:00	NQ	Futures	5183.56	5184.75	5177.31	5180.88	910.0
2016-05-23 00:00:00	YM	Futures	18744.7	18747.9	18731.8	18740.4	685.0
2016-05-23 01:00:00	YM	Futures	18740.4	18741.5	18717.9	18723.3	689.0
2016-05-23 02:00:00	YM	Futures	18724.3	18741.5	18717.9	18720.0	1335.0
2016-05-23 03:00:00	YM	Futures	18720.0	18721.1	18658.0	18686.9	5996.0

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

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