PREVIEW / futures_1hour / 2014-12-08

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-08.parquet
  size:    51 KB
  rows:    1,537

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-08 00:00:00	ES	Futures	2174.85	2175.38	2174.07	2174.59	2523.0
2014-12-08 01:00:00	ES	Futures	2174.33	2175.64	2174.07	2174.85	1935.0
2014-12-08 02:00:00	ES	Futures	2174.85	2175.12	2171.19	2171.19	9025.0
2014-12-08 03:00:00	ES	Futures	2171.19	2172.23	2170.4	2170.92	15244.0
2014-12-08 04:00:00	ES	Futures	2170.66	2170.92	2167.52	2168.57	15320.0
2014-12-08 05:00:00	ES	Futures	2168.57	2169.88	2166.73	2168.83	13760.0
2014-12-08 06:00:00	ES	Futures	2169.09	2169.88	2168.04	2168.57	10757.0
2014-12-08 07:00:00	ES	Futures	2168.57	2169.35	2167.52	2168.83	12597.0
2014-12-08 08:00:00	ES	Futures	2168.83	2169.35	2167.52	2168.04	11399.0
2014-12-08 09:00:00	ES	Futures	2168.04	2173.28	2166.47	2172.76	151496.0
2014-12-08 10:00:00	ES	Futures	2172.76	2175.12	2171.19	2173.54	138996.0
2014-12-08 11:00:00	ES	Futures	2173.54	2174.33	2171.45	2172.23	90923.0
2014-12-08 12:00:00	ES	Futures	2172.5	2173.54	2163.06	2164.37	191759.0
2014-12-08 13:00:00	ES	Futures	2164.64	2166.47	2154.42	2155.21	198556.0
2014-12-08 14:00:00	ES	Futures	2155.21	2162.02	2152.06	2159.4	187887.0
2014-12-08 15:00:00	ES	Futures	2159.4	2161.23	2156.25	2159.4	229249.0
2014-12-08 16:00:00	ES	Futures	2159.4	2159.92	2157.83	2159.4	69535.0
2014-12-08 17:00:00	ES	Futures	2159.4	2159.4	2158.61	2159.14	1535.0
2014-12-08 18:00:00	ES	Futures	2158.87	2160.71	2158.61	2160.18	3191.0
2014-12-08 19:00:00	ES	Futures	2160.18	2160.97	2159.4	2159.92	2987.0
2014-12-08 20:00:00	ES	Futures	2159.66	2160.18	2158.35	2158.61	3791.0
2014-12-08 21:00:00	ES	Futures	2158.61	2158.61	2153.9	2154.16	12061.0
2014-12-08 22:00:00	ES	Futures	2154.42	2155.21	2151.54	2152.59	9427.0
2014-12-08 23:00:00	ES	Futures	2152.59	2153.9	2151.28	2152.06	6524.0
2014-12-08 00:00:00	NQ	Futures	5055.52	5057.57	5054.93	5055.52	485.0
2014-12-08 01:00:00	NQ	Futures	5055.23	5058.16	5054.93	5056.4	242.0
2014-12-08 02:00:00	NQ	Futures	5056.4	5057.86	5047.32	5047.61	1303.0
2014-12-08 03:00:00	NQ	Futures	5047.61	5047.9	5042.34	5042.92	2987.0
2014-12-08 04:00:00	NQ	Futures	5043.21	5043.51	5036.48	5039.11	4022.0
2014-12-08 05:00:00	NQ	Futures	5038.82	5041.75	5034.13	5039.11	2300.0
2014-12-08 06:00:00	NQ	Futures	5039.41	5041.75	5037.35	5038.82	2234.0
2014-12-08 07:00:00	NQ	Futures	5038.82	5041.16	5037.06	5040.87	2621.0
2014-12-08 08:00:00	NQ	Futures	5040.58	5041.75	5035.6	5038.23	4173.0
2014-12-08 09:00:00	NQ	Futures	5037.94	5063.43	5034.42	5060.5	45644.0
2014-12-08 10:00:00	NQ	Futures	5060.79	5063.43	5049.66	5059.04	34056.0
2014-12-08 11:00:00	NQ	Futures	5059.04	5059.33	5050.83	5054.35	22423.0
2014-12-08 12:00:00	NQ	Futures	5054.06	5055.52	5015.38	5019.77	55593.0
2014-12-08 13:00:00	NQ	Futures	5020.07	5028.27	4995.16	4998.68	43701.0
2014-12-08 14:00:00	NQ	Futures	4998.68	5016.55	4991.65	5011.57	35500.0
2014-12-08 15:00:00	NQ	Futures	5011.86	5018.31	5004.83	5018.02	50298.0
2014-12-08 16:00:00	NQ	Futures	5017.72	5020.07	5015.09	5019.48	8333.0
2014-12-08 17:00:00	NQ	Futures	5018.89	5019.77	5018.31	5019.77	70.0
2014-12-08 18:00:00	NQ	Futures	5019.48	5023.29	5019.48	5021.53	691.0
2014-12-08 19:00:00	NQ	Futures	5021.53	5023.58	5019.77	5021.24	589.0
2014-12-08 20:00:00	NQ	Futures	5021.24	5021.53	5017.72	5017.72	1141.0
2014-12-08 21:00:00	NQ	Futures	5018.02	5018.6	5008.64	5009.23	2085.0
2014-12-08 22:00:00	NQ	Futures	5009.52	5011.86	5003.07	5005.42	1933.0
2014-12-08 23:00:00	NQ	Futures	5005.12	5008.93	5003.07	5006.0	1561.0
2014-12-08 00:00:00	YM	Futures	18660.6	18665.8	18656.5	18658.6	459.0
2014-12-08 01:00:00	YM	Futures	18657.5	18666.9	18656.5	18662.7	295.0

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

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