PREVIEW / futures_1hour / 2015-05-18

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-18.parquet
  size:    51 KB
  rows:    1,556

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-18 00:00:00	ES	Futures	2237.08	2237.34	2236.81	2237.08	841.0
2015-05-18 01:00:00	ES	Futures	2237.08	2237.34	2236.29	2237.08	2834.0
2015-05-18 02:00:00	ES	Futures	2237.08	2238.13	2233.38	2233.64	12691.0
2015-05-18 03:00:00	ES	Futures	2233.64	2238.66	2231.53	2236.55	24911.0
2015-05-18 04:00:00	ES	Futures	2236.81	2239.19	2235.76	2238.93	12587.0
2015-05-18 05:00:00	ES	Futures	2238.93	2239.72	2236.81	2237.34	13775.0
2015-05-18 06:00:00	ES	Futures	2237.34	2237.34	2233.38	2236.29	19750.0
2015-05-18 07:00:00	ES	Futures	2236.29	2236.29	2232.59	2234.17	23322.0
2015-05-18 08:00:00	ES	Futures	2234.17	2235.76	2233.64	2235.23	16157.0
2015-05-18 09:00:00	ES	Futures	2235.49	2240.51	2233.91	2239.72	143119.0
2015-05-18 10:00:00	ES	Futures	2239.72	2240.25	2236.55	2238.4	128729.0
2015-05-18 11:00:00	ES	Futures	2238.4	2244.74	2238.13	2243.15	114195.0
2015-05-18 12:00:00	ES	Futures	2243.42	2244.47	2242.36	2243.15	45554.0
2015-05-18 13:00:00	ES	Futures	2243.42	2246.59	2243.15	2246.06	65859.0
2015-05-18 14:00:00	ES	Futures	2246.06	2247.64	2245.27	2246.85	60671.0
2015-05-18 15:00:00	ES	Futures	2246.85	2248.96	2244.74	2245.27	144061.0
2015-05-18 16:00:00	ES	Futures	2245.27	2246.85	2244.74	2246.85	62499.0
2015-05-18 17:00:00	ES	Futures	2246.85	2246.85	2246.32	2246.85	1660.0
2015-05-18 18:00:00	ES	Futures	2246.85	2247.11	2246.32	2246.85	1559.0
2015-05-18 19:00:00	ES	Futures	2246.85	2246.85	2246.06	2246.85	824.0
2015-05-18 20:00:00	ES	Futures	2246.85	2247.64	2246.32	2247.38	3103.0
2015-05-18 21:00:00	ES	Futures	2247.64	2248.17	2247.11	2248.17	3021.0
2015-05-18 22:00:00	ES	Futures	2247.91	2248.43	2247.64	2248.43	1623.0
2015-05-18 23:00:00	ES	Futures	2248.17	2249.23	2247.91	2248.96	2723.0
2015-05-18 00:00:00	NQ	Futures	5276.38	5278.44	5275.5	5278.15	207.0
2015-05-18 01:00:00	NQ	Futures	5278.15	5278.15	5275.21	5276.09	330.0
2015-05-18 02:00:00	NQ	Futures	5276.68	5279.03	5267.56	5268.74	745.0
2015-05-18 03:00:00	NQ	Futures	5268.74	5279.32	5261.68	5271.38	2657.0
2015-05-18 04:00:00	NQ	Futures	5271.97	5276.97	5267.56	5276.68	1506.0
2015-05-18 05:00:00	NQ	Futures	5276.97	5278.44	5270.5	5271.97	1241.0
2015-05-18 06:00:00	NQ	Futures	5271.68	5271.68	5262.86	5270.5	2539.0
2015-05-18 07:00:00	NQ	Futures	5270.5	5270.79	5258.44	5263.15	4443.0
2015-05-18 08:00:00	NQ	Futures	5262.56	5267.85	5261.09	5266.68	2557.0
2015-05-18 09:00:00	NQ	Futures	5266.68	5283.15	5263.74	5281.09	22801.0
2015-05-18 10:00:00	NQ	Futures	5281.38	5284.91	5272.56	5275.5	17328.0
2015-05-18 11:00:00	NQ	Futures	5275.5	5299.91	5275.21	5295.2	20438.0
2015-05-18 12:00:00	NQ	Futures	5295.5	5298.14	5291.97	5297.26	7161.0
2015-05-18 13:00:00	NQ	Futures	5297.26	5308.14	5296.97	5306.96	10023.0
2015-05-18 14:00:00	NQ	Futures	5306.96	5311.67	5304.02	5308.14	9293.0
2015-05-18 15:00:00	NQ	Futures	5308.73	5314.02	5302.26	5302.85	18298.0
2015-05-18 16:00:00	NQ	Futures	5303.14	5304.61	5300.79	5303.73	4845.0
2015-05-18 17:00:00	NQ	Futures	5303.73	5304.32	5302.26	5304.32	321.0
2015-05-18 18:00:00	NQ	Futures	5304.61	5304.91	5302.26	5304.32	230.0
2015-05-18 19:00:00	NQ	Futures	5304.02	5304.02	5302.85	5304.02	105.0
2015-05-18 20:00:00	NQ	Futures	5304.02	5305.49	5303.14	5305.49	247.0
2015-05-18 21:00:00	NQ	Futures	5305.79	5307.26	5305.2	5307.26	310.0
2015-05-18 22:00:00	NQ	Futures	5307.26	5308.14	5306.67	5307.55	181.0
2015-05-18 23:00:00	NQ	Futures	5307.55	5309.91	5306.67	5309.61	405.0
2015-05-18 00:00:00	YM	Futures	19107.8	19113.0	19107.8	19111.9	153.0
2015-05-18 01:00:00	YM	Futures	19110.9	19113.0	19105.7	19106.7	263.0

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

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