PREVIEW / futures_1hour / 2014-12-01

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-01.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
2014-12-01 00:00:00	ES	Futures	2157.3	2158.09	2155.73	2157.83	2662.0
2014-12-01 01:00:00	ES	Futures	2157.83	2158.09	2155.73	2156.52	2269.0
2014-12-01 02:00:00	ES	Futures	2156.25	2156.52	2150.23	2152.32	21386.0
2014-12-01 03:00:00	ES	Futures	2152.59	2156.52	2151.28	2152.59	26429.0
2014-12-01 04:00:00	ES	Futures	2152.32	2156.78	2150.49	2154.94	20080.0
2014-12-01 05:00:00	ES	Futures	2154.94	2155.99	2153.37	2155.47	9479.0
2014-12-01 06:00:00	ES	Futures	2155.47	2158.09	2154.68	2157.83	19190.0
2014-12-01 07:00:00	ES	Futures	2158.09	2159.66	2154.68	2155.99	24936.0
2014-12-01 08:00:00	ES	Futures	2155.99	2158.09	2152.85	2156.25	32134.0
2014-12-01 09:00:00	ES	Futures	2155.99	2159.4	2147.35	2149.97	207598.0
2014-12-01 10:00:00	ES	Futures	2150.23	2157.56	2146.3	2147.87	292475.0
2014-12-01 11:00:00	ES	Futures	2147.61	2153.11	2147.08	2148.92	172224.0
2014-12-01 12:00:00	ES	Futures	2148.92	2154.68	2148.39	2154.16	102091.0
2014-12-01 13:00:00	ES	Futures	2154.16	2157.04	2154.16	2154.94	103553.0
2014-12-01 14:00:00	ES	Futures	2154.94	2155.21	2148.92	2151.8	101953.0
2014-12-01 15:00:00	ES	Futures	2151.54	2156.25	2150.23	2150.75	176011.0
2014-12-01 16:00:00	ES	Futures	2151.01	2151.28	2147.61	2148.92	84442.0
2014-12-01 17:00:00	ES	Futures	2148.66	2149.44	2148.66	2148.92	1805.0
2014-12-01 18:00:00	ES	Futures	2149.18	2150.23	2148.92	2149.7	4178.0
2014-12-01 19:00:00	ES	Futures	2149.44	2150.75	2149.18	2149.7	5541.0
2014-12-01 20:00:00	ES	Futures	2149.44	2151.28	2149.18	2149.7	6368.0
2014-12-01 21:00:00	ES	Futures	2149.7	2150.23	2149.18	2149.97	1903.0
2014-12-01 22:00:00	ES	Futures	2149.97	2151.54	2149.7	2151.54	3439.0
2014-12-01 23:00:00	ES	Futures	2151.28	2151.54	2150.75	2151.01	1588.0
2014-12-01 00:00:00	NQ	Futures	5071.93	5074.27	5069.0	5073.69	602.0
2014-12-01 01:00:00	NQ	Futures	5073.98	5075.15	5069.88	5071.34	372.0
2014-12-01 02:00:00	NQ	Futures	5071.05	5071.34	5059.04	5065.19	2666.0
2014-12-01 03:00:00	NQ	Futures	5065.19	5075.74	5061.97	5066.65	3791.0
2014-12-01 04:00:00	NQ	Futures	5066.65	5076.91	5063.43	5073.39	2614.0
2014-12-01 05:00:00	NQ	Futures	5073.1	5075.15	5069.29	5073.1	1386.0
2014-12-01 06:00:00	NQ	Futures	5073.69	5077.79	5072.22	5077.2	2236.0
2014-12-01 07:00:00	NQ	Futures	5077.5	5081.31	5069.58	5071.34	3471.0
2014-12-01 08:00:00	NQ	Futures	5071.64	5075.74	5060.79	5069.88	6534.0
2014-12-01 09:00:00	NQ	Futures	5069.88	5080.43	5008.64	5037.35	74686.0
2014-12-01 10:00:00	NQ	Futures	5037.94	5055.81	5019.48	5023.29	73302.0
2014-12-01 11:00:00	NQ	Futures	5023.0	5034.42	5021.53	5023.58	37108.0
2014-12-01 12:00:00	NQ	Futures	5023.29	5039.11	5021.53	5038.23	18259.0
2014-12-01 13:00:00	NQ	Futures	5038.23	5051.13	5038.23	5042.04	21301.0
2014-12-01 14:00:00	NQ	Futures	5041.75	5043.21	5018.31	5027.98	23203.0
2014-12-01 15:00:00	NQ	Futures	5027.98	5038.23	5021.24	5028.56	32572.0
2014-12-01 16:00:00	NQ	Futures	5028.27	5029.15	5020.36	5023.88	6743.0
2014-12-01 17:00:00	NQ	Futures	5023.58	5025.93	5023.29	5024.46	172.0
2014-12-01 18:00:00	NQ	Futures	5024.46	5027.1	5023.88	5026.51	443.0
2014-12-01 19:00:00	NQ	Futures	5026.51	5029.44	5025.63	5026.81	518.0
2014-12-01 20:00:00	NQ	Futures	5026.51	5029.44	5025.34	5025.93	1152.0
2014-12-01 21:00:00	NQ	Futures	5026.51	5027.69	5023.88	5025.63	593.0
2014-12-01 22:00:00	NQ	Futures	5025.63	5030.03	5025.63	5029.74	711.0
2014-12-01 23:00:00	NQ	Futures	5029.44	5030.03	5028.86	5028.86	249.0
2014-12-01 00:00:00	YM	Futures	18464.1	18469.3	18455.8	18469.3	433.0
2014-12-01 01:00:00	YM	Futures	18469.3	18470.4	18452.7	18457.9	507.0

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

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