PREVIEW / futures_1hour / 2014-12-05

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-05.parquet
  size:    43 KB
  rows:    1,266

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
2014-12-05 00:00:00	ES	Futures	2171.19	2171.19	2170.4	2170.66	1561.0
2014-12-05 01:00:00	ES	Futures	2170.66	2170.66	2169.88	2170.14	1607.0
2014-12-05 02:00:00	ES	Futures	2170.4	2171.71	2170.14	2171.45	6061.0
2014-12-05 03:00:00	ES	Futures	2171.19	2174.33	2170.92	2173.28	21045.0
2014-12-05 04:00:00	ES	Futures	2173.02	2174.33	2172.76	2173.02	8488.0
2014-12-05 05:00:00	ES	Futures	2172.76	2173.28	2171.45	2173.28	6178.0
2014-12-05 06:00:00	ES	Futures	2173.02	2174.07	2172.23	2173.54	6821.0
2014-12-05 07:00:00	ES	Futures	2173.54	2174.07	2171.97	2173.28	10029.0
2014-12-05 08:00:00	ES	Futures	2173.28	2176.43	2167.52	2171.19	105787.0
2014-12-05 09:00:00	ES	Futures	2171.19	2175.12	2168.57	2174.07	182951.0
2014-12-05 10:00:00	ES	Futures	2174.07	2176.16	2171.19	2172.5	174211.0
2014-12-05 11:00:00	ES	Futures	2172.76	2178.52	2172.5	2177.21	125724.0
2014-12-05 12:00:00	ES	Futures	2176.95	2178.26	2175.9	2176.95	56125.0
2014-12-05 13:00:00	ES	Futures	2177.21	2177.73	2174.85	2175.9	52668.0
2014-12-05 14:00:00	ES	Futures	2176.16	2176.43	2171.97	2172.76	69799.0
2014-12-05 15:00:00	ES	Futures	2172.76	2174.59	2168.83	2174.07	194999.0
2014-12-05 16:00:00	ES	Futures	2174.07	2176.16	2173.54	2175.9	86386.0
2014-12-05 17:00:00	ES	Futures	2175.9	2176.43	2175.64	2175.9	1372.0
2014-12-05 00:00:00	NQ	Futures	5054.06	5054.06	5052.88	5053.18	442.0
2014-12-05 01:00:00	NQ	Futures	5053.18	5053.47	5052.3	5053.18	213.0
2014-12-05 02:00:00	NQ	Futures	5053.18	5054.93	5052.88	5054.35	1063.0
2014-12-05 03:00:00	NQ	Futures	5054.35	5062.55	5053.76	5060.79	2996.0
2014-12-05 04:00:00	NQ	Futures	5060.79	5065.78	5060.79	5062.55	1709.0
2014-12-05 05:00:00	NQ	Futures	5062.55	5064.6	5059.33	5063.72	739.0
2014-12-05 06:00:00	NQ	Futures	5064.02	5066.07	5061.67	5064.6	974.0
2014-12-05 07:00:00	NQ	Futures	5064.9	5065.19	5059.92	5062.26	1586.0
2014-12-05 08:00:00	NQ	Futures	5061.67	5071.05	5052.3	5058.45	16786.0
2014-12-05 09:00:00	NQ	Futures	5058.45	5069.58	5049.66	5061.09	45128.0
2014-12-05 10:00:00	NQ	Futures	5061.09	5065.19	5050.25	5054.93	34517.0
2014-12-05 11:00:00	NQ	Futures	5054.93	5064.02	5054.64	5060.79	16330.0
2014-12-05 12:00:00	NQ	Futures	5060.79	5065.19	5059.33	5060.79	9950.0
2014-12-05 13:00:00	NQ	Futures	5060.5	5060.79	5051.71	5058.74	15749.0
2014-12-05 14:00:00	NQ	Futures	5058.74	5060.5	5051.71	5053.76	9369.0
2014-12-05 15:00:00	NQ	Futures	5053.76	5058.16	5042.92	5054.06	30725.0
2014-12-05 16:00:00	NQ	Futures	5054.35	5058.16	5053.76	5056.99	8010.0
2014-12-05 17:00:00	NQ	Futures	5056.4	5057.28	5055.52	5056.69	254.0
2014-12-05 00:00:00	YM	Futures	18602.4	18603.4	18597.2	18597.2	423.0
2014-12-05 01:00:00	YM	Futures	18599.3	18603.4	18597.2	18599.3	392.0
2014-12-05 02:00:00	YM	Futures	18599.3	18609.7	18599.3	18609.7	795.0
2014-12-05 03:00:00	YM	Futures	18607.6	18633.6	18606.6	18623.2	2651.0
2014-12-05 04:00:00	YM	Futures	18623.2	18635.7	18623.2	18627.4	1396.0
2014-12-05 05:00:00	YM	Futures	18625.3	18628.4	18613.8	18627.4	961.0
2014-12-05 06:00:00	YM	Futures	18627.4	18630.5	18621.1	18629.4	1039.0
2014-12-05 07:00:00	YM	Futures	18628.4	18632.6	18623.2	18630.5	1656.0
2014-12-05 08:00:00	YM	Futures	18631.5	18655.4	18593.0	18629.4	12663.0
2014-12-05 09:00:00	YM	Futures	18630.5	18651.3	18608.6	18639.8	19864.0
2014-12-05 10:00:00	YM	Futures	18639.8	18667.9	18622.2	18653.4	14208.0
2014-12-05 11:00:00	YM	Futures	18653.4	18694.9	18650.2	18687.7	9167.0
2014-12-05 12:00:00	YM	Futures	18687.7	18691.8	18676.2	18682.5	5286.0
2014-12-05 13:00:00	YM	Futures	18683.5	18691.8	18665.8	18673.1	4932.0

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

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