PREVIEW / futures_1hour / 2015-05-20

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-20.parquet
  size:    49 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-05-20 00:00:00	ES	Futures	2243.42	2245.79	2243.15	2245.53	2612.0
2015-05-20 01:00:00	ES	Futures	2245.53	2245.79	2243.68	2244.74	3168.0
2015-05-20 02:00:00	ES	Futures	2244.74	2245.53	2242.89	2244.47	6752.0
2015-05-20 03:00:00	ES	Futures	2244.47	2246.85	2243.42	2243.94	17424.0
2015-05-20 04:00:00	ES	Futures	2243.94	2243.94	2241.57	2242.62	11873.0
2015-05-20 05:00:00	ES	Futures	2242.36	2244.47	2242.1	2242.89	7756.0
2015-05-20 06:00:00	ES	Futures	2243.15	2246.32	2242.62	2245.27	8218.0
2015-05-20 07:00:00	ES	Futures	2245.27	2246.32	2243.42	2243.68	13686.0
2015-05-20 08:00:00	ES	Futures	2243.94	2246.59	2242.62	2245.53	25769.0
2015-05-20 09:00:00	ES	Futures	2245.79	2246.85	2238.93	2239.98	145629.0
2015-05-20 10:00:00	ES	Futures	2240.25	2246.32	2239.19	2244.47	104522.0
2015-05-20 11:00:00	ES	Futures	2244.47	2245.53	2240.78	2242.1	99191.0
2015-05-20 12:00:00	ES	Futures	2242.1	2245.27	2241.83	2243.42	52325.0
2015-05-20 13:00:00	ES	Futures	2243.42	2243.68	2241.3	2242.89	43187.0
2015-05-20 14:00:00	ES	Futures	2242.89	2252.66	2242.89	2248.7	184428.0
2015-05-20 15:00:00	ES	Futures	2248.96	2249.49	2241.3	2242.89	199985.0
2015-05-20 16:00:00	ES	Futures	2242.62	2243.42	2241.3	2241.3	57548.0
2015-05-20 17:00:00	ES	Futures	2241.57	2241.57	2239.98	2240.25	2855.0
2015-05-20 18:00:00	ES	Futures	2240.51	2240.51	2234.44	2237.34	10808.0
2015-05-20 19:00:00	ES	Futures	2237.61	2238.13	2236.29	2237.08	2721.0
2015-05-20 20:00:00	ES	Futures	2236.81	2238.66	2236.55	2238.13	4396.0
2015-05-20 21:00:00	ES	Futures	2237.87	2238.4	2236.81	2236.81	2840.0
2015-05-20 22:00:00	ES	Futures	2236.55	2238.13	2236.02	2238.13	3917.0
2015-05-20 23:00:00	ES	Futures	2238.13	2238.4	2237.34	2238.13	1909.0
2015-05-20 00:00:00	NQ	Futures	5294.32	5300.79	5294.03	5299.91	573.0
2015-05-20 01:00:00	NQ	Futures	5299.91	5301.08	5295.2	5299.32	734.0
2015-05-20 02:00:00	NQ	Futures	5299.32	5301.38	5294.91	5299.61	1146.0
2015-05-20 03:00:00	NQ	Futures	5299.32	5305.49	5296.08	5296.38	1670.0
2015-05-20 04:00:00	NQ	Futures	5296.38	5296.97	5290.2	5292.26	1870.0
2015-05-20 05:00:00	NQ	Futures	5291.97	5299.32	5291.38	5295.2	1183.0
2015-05-20 06:00:00	NQ	Futures	5295.2	5303.73	5294.91	5301.67	1518.0
2015-05-20 07:00:00	NQ	Futures	5301.08	5303.14	5296.08	5296.97	1561.0
2015-05-20 08:00:00	NQ	Futures	5297.26	5304.32	5295.2	5301.38	3270.0
2015-05-20 09:00:00	NQ	Futures	5301.38	5304.61	5272.27	5278.15	29734.0
2015-05-20 10:00:00	NQ	Futures	5278.15	5301.08	5272.85	5295.79	22996.0
2015-05-20 11:00:00	NQ	Futures	5296.08	5299.02	5289.03	5294.32	11638.0
2015-05-20 12:00:00	NQ	Futures	5294.32	5302.85	5293.73	5298.44	7443.0
2015-05-20 13:00:00	NQ	Futures	5298.73	5301.08	5294.32	5299.61	5813.0
2015-05-20 14:00:00	NQ	Futures	5300.2	5333.14	5299.02	5319.9	40509.0
2015-05-20 15:00:00	NQ	Futures	5320.2	5321.67	5291.67	5300.5	31649.0
2015-05-20 16:00:00	NQ	Futures	5300.79	5302.26	5294.61	5295.79	4804.0
2015-05-20 17:00:00	NQ	Futures	5295.79	5296.08	5291.38	5292.26	312.0
2015-05-20 18:00:00	NQ	Futures	5293.14	5293.44	5277.26	5284.03	1474.0
2015-05-20 19:00:00	NQ	Futures	5284.03	5286.09	5281.09	5281.68	384.0
2015-05-20 20:00:00	NQ	Futures	5282.26	5287.26	5281.68	5285.2	593.0
2015-05-20 21:00:00	NQ	Futures	5285.2	5286.38	5282.85	5282.85	289.0
2015-05-20 22:00:00	NQ	Futures	5282.56	5287.26	5281.09	5286.67	396.0
2015-05-20 23:00:00	NQ	Futures	5286.97	5287.56	5285.2	5285.79	302.0
2015-05-20 00:00:00	YM	Futures	19167.5	19192.7	19166.5	19189.5	1250.0
2015-05-20 01:00:00	YM	Futures	19189.5	19189.5	19163.3	19177.0	2940.0

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

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