PREVIEW / futures_1hour / 2015-05-04

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-04.parquet
  size:    48 KB
  rows:    1,494

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-05-04 00:00:00	ES	Futures	2218.59	2218.85	2218.33	2218.85	305.0
2015-05-04 01:00:00	ES	Futures	2218.59	2219.12	2218.06	2218.59	1333.0
2015-05-04 02:00:00	ES	Futures	2218.85	2219.12	2217.0	2217.53	5660.0
2015-05-04 03:00:00	ES	Futures	2217.8	2220.97	2216.48	2219.12	22856.0
2015-05-04 04:00:00	ES	Futures	2219.38	2225.98	2218.59	2225.19	17374.0
2015-05-04 05:00:00	ES	Futures	2225.19	2225.72	2223.34	2224.4	10944.0
2015-05-04 06:00:00	ES	Futures	2224.4	2225.98	2223.08	2225.46	7030.0
2015-05-04 07:00:00	ES	Futures	2225.46	2227.83	2224.93	2226.78	13670.0
2015-05-04 08:00:00	ES	Futures	2226.78	2227.57	2225.98	2226.78	13002.0
2015-05-04 09:00:00	ES	Futures	2226.78	2234.44	2224.4	2233.12	203204.0
2015-05-04 10:00:00	ES	Futures	2233.38	2234.44	2229.15	2230.21	171935.0
2015-05-04 11:00:00	ES	Futures	2230.21	2231.8	2227.83	2230.74	85623.0
2015-05-04 12:00:00	ES	Futures	2230.74	2231.53	2227.57	2228.1	74439.0
2015-05-04 13:00:00	ES	Futures	2228.36	2229.42	2225.46	2229.42	71309.0
2015-05-04 14:00:00	ES	Futures	2229.42	2231.8	2227.83	2229.68	83229.0
2015-05-04 15:00:00	ES	Futures	2229.42	2231.27	2227.04	2227.57	138682.0
2015-05-04 16:00:00	ES	Futures	2227.31	2229.42	2226.51	2228.36	65887.0
2015-05-04 17:00:00	ES	Futures	2228.36	2228.89	2228.36	2228.89	809.0
2015-05-04 18:00:00	ES	Futures	2228.63	2229.15	2227.31	2228.1	2610.0
2015-05-04 19:00:00	ES	Futures	2228.1	2228.63	2227.57	2228.36	953.0
2015-05-04 20:00:00	ES	Futures	2228.1	2228.63	2227.57	2228.1	1358.0
2015-05-04 21:00:00	ES	Futures	2227.83	2228.36	2227.04	2227.83	1275.0
2015-05-04 22:00:00	ES	Futures	2227.83	2228.1	2226.25	2227.04	1524.0
2015-05-04 23:00:00	ES	Futures	2227.31	2227.31	2225.46	2225.72	1849.0
2015-05-04 00:00:00	NQ	Futures	5248.45	5249.33	5247.56	5249.03	75.0
2015-05-04 01:00:00	NQ	Futures	5248.45	5249.33	5247.56	5248.74	242.0
2015-05-04 02:00:00	NQ	Futures	5248.45	5249.33	5243.15	5245.8	1135.0
2015-05-04 03:00:00	NQ	Futures	5246.39	5254.92	5242.56	5247.86	3687.0
2015-05-04 04:00:00	NQ	Futures	5248.15	5264.62	5246.09	5262.27	3988.0
2015-05-04 05:00:00	NQ	Futures	5262.56	5263.44	5256.97	5259.91	2559.0
2015-05-04 06:00:00	NQ	Futures	5259.91	5264.03	5258.15	5261.97	2141.0
2015-05-04 07:00:00	NQ	Futures	5261.97	5271.38	5261.09	5269.03	3214.0
2015-05-04 08:00:00	NQ	Futures	5268.74	5272.85	5267.27	5269.91	4290.0
2015-05-04 09:00:00	NQ	Futures	5269.91	5297.26	5266.97	5295.79	39724.0
2015-05-04 10:00:00	NQ	Futures	5295.79	5297.26	5276.09	5278.15	35358.0
2015-05-04 11:00:00	NQ	Futures	5278.44	5282.85	5273.15	5280.79	16498.0
2015-05-04 12:00:00	NQ	Futures	5281.09	5285.5	5270.21	5271.97	13444.0
2015-05-04 13:00:00	NQ	Futures	5272.27	5275.79	5260.8	5275.21	16372.0
2015-05-04 14:00:00	NQ	Futures	5275.21	5280.5	5269.62	5274.62	12694.0
2015-05-04 15:00:00	NQ	Futures	5274.62	5275.21	5261.09	5262.86	24331.0
2015-05-04 16:00:00	NQ	Futures	5262.86	5266.68	5257.86	5262.86	8438.0
2015-05-04 17:00:00	NQ	Futures	5263.15	5264.33	5262.27	5264.33	100.0
2015-05-04 18:00:00	NQ	Futures	5262.56	5265.5	5260.5	5262.86	424.0
2015-05-04 19:00:00	NQ	Futures	5263.15	5263.15	5261.38	5262.27	181.0
2015-05-04 20:00:00	NQ	Futures	5262.56	5264.03	5261.97	5262.27	271.0
2015-05-04 21:00:00	NQ	Futures	5262.56	5263.74	5261.38	5262.56	275.0
2015-05-04 22:00:00	NQ	Futures	5262.56	5262.56	5259.03	5260.8	216.0
2015-05-04 23:00:00	NQ	Futures	5261.09	5261.09	5257.27	5257.86	306.0
2015-05-04 00:00:00	YM	Futures	18796.3	18799.4	18795.3	18799.4	68.0
2015-05-04 01:00:00	YM	Futures	18799.4	18799.4	18793.2	18799.4	234.0

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

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