PREVIEW / futures_1hour / 2015-06-12

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-12.parquet
  size:    42 KB
  rows:    1,236

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-06-12 00:00:00	ES	Futures	2223.87	2224.4	2223.08	2224.14	1748.0
2015-06-12 01:00:00	ES	Futures	2224.14	2224.66	2223.87	2224.14	1378.0
2015-06-12 02:00:00	ES	Futures	2223.87	2225.98	2223.34	2225.19	3318.0
2015-06-12 03:00:00	ES	Futures	2225.46	2226.78	2223.34	2224.66	8555.0
2015-06-12 04:00:00	ES	Futures	2224.93	2225.46	2221.23	2222.55	8124.0
2015-06-12 05:00:00	ES	Futures	2222.55	2227.57	2221.76	2225.46	6859.0
2015-06-12 06:00:00	ES	Futures	2225.46	2228.1	2223.08	2223.87	5461.0
2015-06-12 07:00:00	ES	Futures	2223.87	2224.4	2218.33	2220.97	16174.0
2015-06-12 08:00:00	ES	Futures	2220.7	2222.55	2218.85	2219.91	18199.0
2015-06-12 09:00:00	ES	Futures	2219.65	2220.7	2213.31	2215.95	94075.0
2015-06-12 10:00:00	ES	Futures	2215.68	2219.65	2208.55	2209.08	108105.0
2015-06-12 11:00:00	ES	Futures	2208.82	2217.53	2208.29	2212.25	72490.0
2015-06-12 12:00:00	ES	Futures	2212.25	2213.57	2210.4	2211.19	26235.0
2015-06-12 13:00:00	ES	Futures	2211.19	2214.89	2210.67	2213.57	25964.0
2015-06-12 14:00:00	ES	Futures	2213.57	2213.84	2208.55	2209.08	28441.0
2015-06-12 15:00:00	ES	Futures	2209.08	2213.57	2208.55	2211.46	48114.0
2015-06-12 16:00:00	ES	Futures	2211.72	2212.51	2209.87	2211.72	33380.0
2015-06-12 17:00:00	ES	Futures	2211.72	2211.99	2211.19	2211.46	548.0
2015-06-12 00:00:00	NQ	Futures	5272.85	5274.32	5270.21	5272.56	137.0
2015-06-12 01:00:00	NQ	Futures	5272.56	5274.32	5271.68	5272.27	120.0
2015-06-12 02:00:00	NQ	Futures	5272.27	5276.09	5271.09	5274.62	291.0
2015-06-12 03:00:00	NQ	Futures	5274.91	5278.15	5267.85	5270.79	883.0
2015-06-12 04:00:00	NQ	Futures	5271.09	5272.56	5260.21	5262.86	1171.0
2015-06-12 05:00:00	NQ	Futures	5262.86	5278.44	5259.62	5273.74	1199.0
2015-06-12 06:00:00	NQ	Futures	5273.74	5279.32	5265.5	5268.15	764.0
2015-06-12 07:00:00	NQ	Futures	5267.85	5268.44	5250.8	5258.15	2156.0
2015-06-12 08:00:00	NQ	Futures	5257.86	5262.27	5253.15	5253.45	1811.0
2015-06-12 09:00:00	NQ	Futures	5253.15	5264.62	5244.33	5250.8	19773.0
2015-06-12 10:00:00	NQ	Futures	5251.68	5265.8	5233.74	5234.62	19843.0
2015-06-12 11:00:00	NQ	Futures	5234.62	5252.27	5231.68	5241.09	12987.0
2015-06-12 12:00:00	NQ	Futures	5240.51	5246.68	5235.51	5241.09	4974.0
2015-06-12 13:00:00	NQ	Futures	5241.39	5248.45	5239.33	5246.39	3648.0
2015-06-12 14:00:00	NQ	Futures	5246.68	5247.27	5234.04	5234.33	3890.0
2015-06-12 15:00:00	NQ	Futures	5234.33	5246.98	5233.45	5239.04	9181.0
2015-06-12 16:00:00	NQ	Futures	5239.04	5241.68	5234.33	5241.39	2235.0
2015-06-12 17:00:00	NQ	Futures	5241.09	5242.56	5239.62	5241.39	93.0
2015-06-12 00:00:00	YM	Futures	18893.8	18899.1	18886.4	18898.0	429.0
2015-06-12 01:00:00	YM	Futures	18898.0	18901.2	18895.9	18897.0	119.0
2015-06-12 02:00:00	YM	Futures	18898.0	18912.8	18893.8	18907.5	668.0
2015-06-12 03:00:00	YM	Futures	18908.6	18919.1	18889.6	18900.1	1640.0
2015-06-12 04:00:00	YM	Futures	18901.2	18905.4	18871.7	18881.2	1359.0
2015-06-12 05:00:00	YM	Futures	18881.2	18922.3	18872.7	18903.3	1860.0
2015-06-12 06:00:00	YM	Futures	18905.4	18921.2	18881.2	18887.5	795.0
2015-06-12 07:00:00	YM	Futures	18888.5	18890.6	18840.1	18863.3	2339.0
2015-06-12 08:00:00	YM	Futures	18863.3	18875.9	18846.4	18852.7	3673.0
2015-06-12 09:00:00	YM	Futures	18851.7	18865.4	18784.2	18811.6	19298.0
2015-06-12 10:00:00	YM	Futures	18810.6	18839.0	18725.3	18727.4	22656.0
2015-06-12 11:00:00	YM	Futures	18727.4	18809.5	18720.0	18760.0	15703.0
2015-06-12 12:00:00	YM	Futures	18760.0	18770.6	18743.2	18752.6	5283.0
2015-06-12 13:00:00	YM	Futures	18751.6	18790.6	18747.4	18779.0	4313.0

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

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