PREVIEW / futures_1hour / 2015-04-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	2211.46	2212.78	2211.19	2212.25	1158.0
2015-04-13 01:00:00	ES	Futures	2212.25	2212.51	2211.46	2211.46	1487.0
2015-04-13 02:00:00	ES	Futures	2211.72	2213.31	2210.93	2211.19	5534.0
2015-04-13 03:00:00	ES	Futures	2211.19	2211.72	2208.29	2209.61	17716.0
2015-04-13 04:00:00	ES	Futures	2209.61	2210.4	2206.97	2208.82	12995.0
2015-04-13 05:00:00	ES	Futures	2208.82	2212.25	2208.82	2211.99	10926.0
2015-04-13 06:00:00	ES	Futures	2211.99	2211.99	2209.87	2210.4	6139.0
2015-04-13 07:00:00	ES	Futures	2210.67	2211.46	2209.08	2209.35	8193.0
2015-04-13 08:00:00	ES	Futures	2209.35	2211.19	2208.02	2209.61	20368.0
2015-04-13 09:00:00	ES	Futures	2209.61	2218.59	2208.82	2218.06	153577.0
2015-04-13 10:00:00	ES	Futures	2218.06	2219.91	2215.42	2215.42	146665.0
2015-04-13 11:00:00	ES	Futures	2215.68	2218.06	2214.63	2214.89	122006.0
2015-04-13 12:00:00	ES	Futures	2215.16	2215.68	2211.99	2214.1	68367.0
2015-04-13 13:00:00	ES	Futures	2213.84	2214.1	2206.7	2209.87	106843.0
2015-04-13 14:00:00	ES	Futures	2209.61	2210.93	2205.38	2207.23	99531.0
2015-04-13 15:00:00	ES	Futures	2207.23	2209.87	2203.01	2203.53	202869.0
2015-04-13 16:00:00	ES	Futures	2203.53	2204.86	2203.01	2204.33	63693.0
2015-04-13 17:00:00	ES	Futures	2204.33	2205.91	2204.33	2205.65	2927.0
2015-04-13 18:00:00	ES	Futures	2204.86	2205.65	2203.8	2204.59	3123.0
2015-04-13 19:00:00	ES	Futures	2204.59	2204.86	2203.8	2204.59	929.0
2015-04-13 20:00:00	ES	Futures	2204.33	2205.12	2204.33	2204.86	2182.0
2015-04-13 21:00:00	ES	Futures	2204.86	2207.5	2204.59	2206.97	3714.0
2015-04-13 22:00:00	ES	Futures	2207.23	2207.5	2206.18	2207.5	1981.0
2015-04-13 23:00:00	ES	Futures	2207.5	2207.76	2206.97	2207.23	1181.0
2015-04-13 00:00:00	NQ	Futures	5189.63	5190.81	5187.57	5189.93	269.0
2015-04-13 01:00:00	NQ	Futures	5190.22	5190.22	5188.46	5188.75	128.0
2015-04-13 02:00:00	NQ	Futures	5189.05	5193.46	5188.75	5189.93	590.0
2015-04-13 03:00:00	NQ	Futures	5190.22	5191.69	5185.52	5189.93	2187.0
2015-04-13 04:00:00	NQ	Futures	5189.63	5191.1	5182.87	5187.57	2071.0
2015-04-13 05:00:00	NQ	Futures	5187.87	5192.87	5184.93	5192.28	1563.0
2015-04-13 06:00:00	NQ	Futures	5192.28	5192.28	5188.16	5189.63	997.0
2015-04-13 07:00:00	NQ	Futures	5189.93	5192.57	5189.63	5191.69	1349.0
2015-04-13 08:00:00	NQ	Futures	5191.4	5194.63	5188.46	5192.28	3152.0
2015-04-13 09:00:00	NQ	Futures	5192.28	5221.1	5190.81	5218.75	31114.0
2015-04-13 10:00:00	NQ	Futures	5218.45	5224.33	5212.57	5213.45	23864.0
2015-04-13 11:00:00	NQ	Futures	5213.45	5219.04	5210.22	5211.69	17033.0
2015-04-13 12:00:00	NQ	Futures	5211.69	5214.04	5203.45	5204.92	12926.0
2015-04-13 13:00:00	NQ	Futures	5204.92	5205.22	5180.52	5189.34	23342.0
2015-04-13 14:00:00	NQ	Futures	5189.34	5195.51	5183.46	5188.75	15826.0
2015-04-13 15:00:00	NQ	Futures	5188.75	5195.22	5174.93	5180.52	26738.0
2015-04-13 16:00:00	NQ	Futures	5180.81	5181.69	5175.52	5179.34	5782.0
2015-04-13 17:00:00	NQ	Futures	5179.64	5183.46	5179.64	5183.46	223.0
2015-04-13 18:00:00	NQ	Futures	5181.99	5182.87	5179.34	5181.4	492.0
2015-04-13 19:00:00	NQ	Futures	5181.11	5181.99	5179.64	5180.22	283.0
2015-04-13 20:00:00	NQ	Futures	5180.52	5181.69	5179.64	5180.22	395.0
2015-04-13 21:00:00	NQ	Futures	5179.93	5186.99	5179.93	5185.52	609.0
2015-04-13 22:00:00	NQ	Futures	5185.81	5186.1	5183.75	5185.52	245.0
2015-04-13 23:00:00	NQ	Futures	5185.22	5186.69	5184.63	5185.22	192.0
2015-04-13 00:00:00	YM	Futures	18830.9	18843.5	18828.8	18837.2	233.0
2015-04-13 01:00:00	YM	Futures	18837.2	18840.3	18830.9	18834.1	462.0

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

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