PREVIEW / futures_1hour / 2015-04-28

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-04-28.parquet
  size:    52 KB
  rows:    1,585

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-28 00:00:00	ES	Futures	2221.49	2222.82	2221.23	2222.02	893.0
2015-04-28 01:00:00	ES	Futures	2222.02	2222.29	2220.7	2221.49	1946.0
2015-04-28 02:00:00	ES	Futures	2221.23	2223.08	2220.44	2222.02	7218.0
2015-04-28 03:00:00	ES	Futures	2222.02	2222.29	2217.8	2218.06	23995.0
2015-04-28 04:00:00	ES	Futures	2218.06	2220.97	2217.27	2219.65	11856.0
2015-04-28 05:00:00	ES	Futures	2219.91	2220.17	2217.53	2218.33	7947.0
2015-04-28 06:00:00	ES	Futures	2218.33	2220.17	2214.89	2215.68	17424.0
2015-04-28 07:00:00	ES	Futures	2215.42	2216.48	2213.57	2216.48	20175.0
2015-04-28 08:00:00	ES	Futures	2216.48	2219.38	2216.21	2219.12	35238.0
2015-04-28 09:00:00	ES	Futures	2218.85	2223.08	2217.53	2219.65	213842.0
2015-04-28 10:00:00	ES	Futures	2219.91	2219.91	2206.18	2217.53	405841.0
2015-04-28 11:00:00	ES	Futures	2217.53	2226.78	2217.27	2224.93	209477.0
2015-04-28 12:00:00	ES	Futures	2224.93	2228.89	2223.08	2227.04	90947.0
2015-04-28 13:00:00	ES	Futures	2227.04	2229.42	2225.72	2227.04	73835.0
2015-04-28 14:00:00	ES	Futures	2227.04	2227.31	2223.34	2225.72	93299.0
2015-04-28 15:00:00	ES	Futures	2225.72	2228.89	2224.4	2228.36	154226.0
2015-04-28 16:00:00	ES	Futures	2228.36	2231.8	2228.36	2231.0	84922.0
2015-04-28 17:00:00	ES	Futures	2231.0	2231.27	2230.47	2230.47	1416.0
2015-04-28 18:00:00	ES	Futures	2229.95	2230.74	2229.42	2229.42	3163.0
2015-04-28 19:00:00	ES	Futures	2229.42	2230.21	2229.15	2229.42	1234.0
2015-04-28 20:00:00	ES	Futures	2229.42	2231.27	2229.42	2231.0	2301.0
2015-04-28 21:00:00	ES	Futures	2231.0	2231.27	2230.21	2230.47	2639.0
2015-04-28 22:00:00	ES	Futures	2230.74	2230.74	2227.83	2228.36	3664.0
2015-04-28 23:00:00	ES	Futures	2228.1	2229.68	2228.1	2229.15	960.0
2015-04-28 00:00:00	NQ	Futures	5321.67	5324.61	5321.37	5323.73	176.0
2015-04-28 01:00:00	NQ	Futures	5323.73	5324.02	5320.79	5321.96	489.0
2015-04-28 02:00:00	NQ	Futures	5321.08	5325.49	5319.61	5324.02	663.0
2015-04-28 03:00:00	NQ	Futures	5324.02	5324.31	5313.43	5314.02	3801.0
2015-04-28 04:00:00	NQ	Futures	5313.73	5319.61	5312.26	5317.55	2010.0
2015-04-28 05:00:00	NQ	Futures	5316.96	5317.26	5313.73	5316.08	1361.0
2015-04-28 06:00:00	NQ	Futures	5315.79	5320.79	5313.73	5314.9	3183.0
2015-04-28 07:00:00	NQ	Futures	5314.61	5317.84	5309.91	5316.96	4606.0
2015-04-28 08:00:00	NQ	Futures	5316.96	5319.9	5313.73	5316.96	5553.0
2015-04-28 09:00:00	NQ	Futures	5316.96	5322.84	5293.44	5294.32	53646.0
2015-04-28 10:00:00	NQ	Futures	5294.32	5304.61	5259.91	5296.38	81964.0
2015-04-28 11:00:00	NQ	Futures	5296.38	5319.9	5295.5	5317.55	37711.0
2015-04-28 12:00:00	NQ	Futures	5317.55	5329.9	5314.61	5324.31	17566.0
2015-04-28 13:00:00	NQ	Futures	5324.02	5329.31	5313.73	5316.08	13034.0
2015-04-28 14:00:00	NQ	Futures	5316.08	5316.08	5301.67	5305.79	16618.0
2015-04-28 15:00:00	NQ	Futures	5305.49	5311.96	5293.73	5304.61	30985.0
2015-04-28 16:00:00	NQ	Futures	5304.91	5313.14	5304.02	5310.49	6683.0
2015-04-28 17:00:00	NQ	Futures	5310.79	5311.08	5308.43	5308.43	248.0
2015-04-28 18:00:00	NQ	Futures	5307.55	5308.73	5304.02	5305.2	381.0
2015-04-28 19:00:00	NQ	Futures	5304.91	5306.67	5304.32	5305.2	110.0
2015-04-28 20:00:00	NQ	Futures	5305.2	5309.61	5304.61	5309.32	316.0
2015-04-28 21:00:00	NQ	Futures	5309.32	5309.61	5306.96	5306.96	208.0
2015-04-28 22:00:00	NQ	Futures	5307.26	5307.26	5299.61	5300.2	655.0
2015-04-28 23:00:00	NQ	Futures	5300.5	5303.73	5300.5	5303.14	165.0
2015-04-28 00:00:00	YM	Futures	18852.9	18862.4	18852.9	18858.2	191.0
2015-04-28 01:00:00	YM	Futures	18856.1	18857.1	18846.6	18851.9	393.0

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

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