PREVIEW / futures_1hour / 2014-12-03

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-03.parquet
  size:    49 KB
  rows:    1,530

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-03 00:00:00	ES	Futures	2164.64	2165.42	2164.11	2164.64	2929.0
2014-12-03 01:00:00	ES	Futures	2164.64	2165.16	2164.11	2164.64	1674.0
2014-12-03 02:00:00	ES	Futures	2164.64	2164.9	2163.85	2163.85	4085.0
2014-12-03 03:00:00	ES	Futures	2163.85	2165.16	2162.28	2162.28	15383.0
2014-12-03 04:00:00	ES	Futures	2162.28	2165.16	2162.02	2164.64	11077.0
2014-12-03 05:00:00	ES	Futures	2164.9	2165.16	2162.02	2163.33	9224.0
2014-12-03 06:00:00	ES	Futures	2163.59	2165.68	2162.8	2163.85	11620.0
2014-12-03 07:00:00	ES	Futures	2164.11	2165.68	2163.59	2164.9	8464.0
2014-12-03 08:00:00	ES	Futures	2164.9	2165.42	2163.59	2164.37	15679.0
2014-12-03 09:00:00	ES	Futures	2164.11	2170.14	2163.85	2168.83	137237.0
2014-12-03 10:00:00	ES	Futures	2168.83	2171.45	2166.47	2170.14	171789.0
2014-12-03 11:00:00	ES	Futures	2169.88	2171.45	2167.52	2168.3	125071.0
2014-12-03 12:00:00	ES	Futures	2168.3	2169.61	2166.73	2169.61	53780.0
2014-12-03 13:00:00	ES	Futures	2169.35	2170.14	2168.83	2170.14	35578.0
2014-12-03 14:00:00	ES	Futures	2170.14	2171.45	2169.35	2170.14	51371.0
2014-12-03 15:00:00	ES	Futures	2170.4	2175.38	2170.14	2172.76	154815.0
2014-12-03 16:00:00	ES	Futures	2173.02	2173.02	2170.4	2171.97	69194.0
2014-12-03 17:00:00	ES	Futures	2171.71	2172.23	2171.45	2172.23	1972.0
2014-12-03 18:00:00	ES	Futures	2172.23	2172.76	2171.71	2171.97	3900.0
2014-12-03 19:00:00	ES	Futures	2171.97	2172.23	2171.45	2171.71	2529.0
2014-12-03 20:00:00	ES	Futures	2171.71	2172.23	2170.92	2170.92	3199.0
2014-12-03 21:00:00	ES	Futures	2170.92	2171.97	2170.92	2171.71	1876.0
2014-12-03 22:00:00	ES	Futures	2171.45	2172.76	2171.19	2172.23	2978.0
2014-12-03 23:00:00	ES	Futures	2172.5	2172.76	2172.23	2172.23	2008.0
2014-12-03 00:00:00	NQ	Futures	5047.61	5049.66	5046.14	5048.78	552.0
2014-12-03 01:00:00	NQ	Futures	5048.49	5049.95	5047.9	5048.78	229.0
2014-12-03 02:00:00	NQ	Futures	5048.49	5048.49	5044.39	5044.68	731.0
2014-12-03 03:00:00	NQ	Futures	5044.68	5047.61	5042.34	5042.34	1255.0
2014-12-03 04:00:00	NQ	Futures	5042.63	5049.07	5041.46	5048.49	1394.0
2014-12-03 05:00:00	NQ	Futures	5048.49	5049.07	5042.04	5045.56	929.0
2014-12-03 06:00:00	NQ	Futures	5045.85	5049.07	5044.39	5046.14	1316.0
2014-12-03 07:00:00	NQ	Futures	5046.14	5051.42	5045.27	5050.54	1485.0
2014-12-03 08:00:00	NQ	Futures	5050.54	5052.59	5044.97	5046.14	2822.0
2014-12-03 09:00:00	NQ	Futures	5046.14	5061.38	5039.7	5043.21	41387.0
2014-12-03 10:00:00	NQ	Futures	5043.51	5046.14	5025.05	5036.77	49420.0
2014-12-03 11:00:00	NQ	Futures	5037.06	5048.2	5035.3	5044.97	25052.0
2014-12-03 12:00:00	NQ	Futures	5045.27	5047.61	5040.28	5044.68	9620.0
2014-12-03 13:00:00	NQ	Futures	5044.39	5055.23	5043.51	5054.93	8908.0
2014-12-03 14:00:00	NQ	Futures	5054.93	5057.28	5052.0	5053.76	10596.0
2014-12-03 15:00:00	NQ	Futures	5053.76	5063.14	5053.47	5056.69	22040.0
2014-12-03 16:00:00	NQ	Futures	5056.4	5056.99	5050.83	5054.06	7937.0
2014-12-03 17:00:00	NQ	Futures	5054.64	5055.23	5053.76	5054.93	143.0
2014-12-03 18:00:00	NQ	Futures	5053.76	5056.4	5053.76	5054.64	662.0
2014-12-03 19:00:00	NQ	Futures	5054.93	5055.23	5052.59	5054.64	568.0
2014-12-03 20:00:00	NQ	Futures	5054.93	5055.23	5052.0	5052.88	376.0
2014-12-03 21:00:00	NQ	Futures	5052.88	5055.23	5052.59	5053.47	257.0
2014-12-03 22:00:00	NQ	Futures	5053.47	5056.69	5053.18	5055.52	312.0
2014-12-03 23:00:00	NQ	Futures	5055.52	5056.99	5055.52	5056.4	223.0
2014-12-03 00:00:00	YM	Futures	18572.3	18577.4	18563.9	18572.3	1796.0
2014-12-03 01:00:00	YM	Futures	18571.2	18575.4	18569.1	18574.3	301.0

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

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