PREVIEW / futures_1hour / 2015-06-03

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-03.parquet
  size:    51 KB
  rows:    1,544

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-03 00:00:00	ES	Futures	2226.51	2227.31	2226.25	2227.04	1172.0
2015-06-03 01:00:00	ES	Futures	2227.04	2227.83	2226.78	2227.04	2372.0
2015-06-03 02:00:00	ES	Futures	2227.31	2230.74	2227.04	2230.47	9695.0
2015-06-03 03:00:00	ES	Futures	2230.74	2231.53	2225.98	2231.0	26356.0
2015-06-03 04:00:00	ES	Futures	2231.0	2231.8	2226.78	2228.63	17430.0
2015-06-03 05:00:00	ES	Futures	2228.89	2230.21	2227.83	2229.15	11096.0
2015-06-03 06:00:00	ES	Futures	2228.89	2232.85	2228.63	2230.74	15295.0
2015-06-03 07:00:00	ES	Futures	2231.0	2239.45	2230.47	2238.13	56735.0
2015-06-03 08:00:00	ES	Futures	2238.13	2238.4	2232.59	2233.64	40153.0
2015-06-03 09:00:00	ES	Futures	2233.64	2235.23	2226.25	2232.59	211979.0
2015-06-03 10:00:00	ES	Futures	2232.85	2240.51	2228.63	2239.19	235295.0
2015-06-03 11:00:00	ES	Futures	2239.19	2240.25	2229.95	2232.32	175637.0
2015-06-03 12:00:00	ES	Futures	2232.59	2233.12	2228.1	2231.53	127060.0
2015-06-03 13:00:00	ES	Futures	2231.53	2232.85	2229.95	2232.32	80085.0
2015-06-03 14:00:00	ES	Futures	2232.32	2236.29	2232.32	2232.85	74387.0
2015-06-03 15:00:00	ES	Futures	2232.85	2234.44	2230.47	2232.59	128010.0
2015-06-03 16:00:00	ES	Futures	2232.59	2236.02	2232.59	2235.49	62861.0
2015-06-03 17:00:00	ES	Futures	2235.49	2236.02	2234.96	2235.76	1425.0
2015-06-03 18:00:00	ES	Futures	2235.76	2236.02	2234.17	2234.96	2430.0
2015-06-03 19:00:00	ES	Futures	2235.23	2235.76	2234.7	2234.96	1490.0
2015-06-03 20:00:00	ES	Futures	2235.23	2235.23	2233.12	2233.64	3816.0
2015-06-03 21:00:00	ES	Futures	2233.64	2234.17	2232.59	2234.17	3112.0
2015-06-03 22:00:00	ES	Futures	2233.91	2234.7	2233.64	2233.91	1122.0
2015-06-03 23:00:00	ES	Futures	2233.91	2234.44	2231.53	2232.06	3307.0
2015-06-03 00:00:00	NQ	Futures	5297.26	5298.44	5296.67	5298.44	356.0
2015-06-03 01:00:00	NQ	Futures	5298.14	5300.5	5297.55	5299.32	360.0
2015-06-03 02:00:00	NQ	Futures	5299.32	5308.43	5299.32	5308.14	1385.0
2015-06-03 03:00:00	NQ	Futures	5308.14	5311.38	5294.61	5309.91	4693.0
2015-06-03 04:00:00	NQ	Futures	5309.91	5312.85	5299.32	5304.61	3807.0
2015-06-03 05:00:00	NQ	Futures	5304.61	5308.43	5302.55	5306.67	1814.0
2015-06-03 06:00:00	NQ	Futures	5306.67	5317.26	5306.08	5314.02	3113.0
2015-06-03 07:00:00	NQ	Futures	5313.73	5341.08	5313.14	5336.96	8782.0
2015-06-03 08:00:00	NQ	Futures	5336.67	5338.72	5329.31	5331.08	7753.0
2015-06-03 09:00:00	NQ	Futures	5331.37	5333.72	5309.32	5325.78	35940.0
2015-06-03 10:00:00	NQ	Futures	5325.2	5339.9	5314.61	5336.37	30498.0
2015-06-03 11:00:00	NQ	Futures	5336.37	5339.02	5313.14	5319.61	23510.0
2015-06-03 12:00:00	NQ	Futures	5319.61	5321.96	5306.08	5315.2	20368.0
2015-06-03 13:00:00	NQ	Futures	5315.49	5320.49	5311.38	5318.14	11524.0
2015-06-03 14:00:00	NQ	Futures	5318.43	5325.49	5316.37	5318.43	11291.0
2015-06-03 15:00:00	NQ	Futures	5318.43	5321.37	5311.38	5318.43	17140.0
2015-06-03 16:00:00	NQ	Futures	5318.43	5328.43	5318.43	5324.9	5385.0
2015-06-03 17:00:00	NQ	Futures	5324.9	5326.96	5324.31	5325.78	95.0
2015-06-03 18:00:00	NQ	Futures	5324.61	5324.9	5322.26	5324.31	400.0
2015-06-03 19:00:00	NQ	Futures	5324.31	5325.2	5323.14	5324.02	167.0
2015-06-03 20:00:00	NQ	Futures	5323.43	5323.73	5319.02	5320.2	554.0
2015-06-03 21:00:00	NQ	Futures	5320.49	5322.55	5319.32	5322.26	463.0
2015-06-03 22:00:00	NQ	Futures	5322.55	5323.73	5321.67	5321.67	290.0
2015-06-03 23:00:00	NQ	Futures	5321.96	5322.26	5314.02	5316.67	839.0
2015-06-03 00:00:00	YM	Futures	18884.4	18887.5	18882.3	18887.5	159.0
2015-06-03 01:00:00	YM	Futures	18886.5	18893.8	18884.4	18889.6	385.0

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

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