PREVIEW / futures_1hour / 2016-01-12

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-12.parquet
  size:    55 KB
  rows:    1,621

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
2016-01-12 00:00:00	ES	Futures	2050.25	2051.59	2045.68	2048.37	11895.0
2016-01-12 01:00:00	ES	Futures	2048.37	2048.37	2041.11	2046.76	13025.0
2016-01-12 02:00:00	ES	Futures	2046.49	2053.21	2043.26	2050.79	18532.0
2016-01-12 03:00:00	ES	Futures	2050.79	2055.09	2045.68	2052.67	37903.0
2016-01-12 04:00:00	ES	Futures	2052.4	2065.57	2050.25	2064.22	33905.0
2016-01-12 05:00:00	ES	Futures	2064.22	2074.97	2063.42	2073.09	36053.0
2016-01-12 06:00:00	ES	Futures	2073.36	2075.24	2067.98	2071.21	29297.0
2016-01-12 07:00:00	ES	Futures	2071.21	2079.54	2068.79	2077.93	32625.0
2016-01-12 08:00:00	ES	Futures	2077.93	2082.49	2075.24	2078.73	66282.0
2016-01-12 09:00:00	ES	Futures	2078.73	2085.45	2072.55	2079.0	297552.0
2016-01-12 10:00:00	ES	Futures	2079.0	2081.42	2063.95	2069.06	381163.0
2016-01-12 11:00:00	ES	Futures	2069.06	2070.94	2055.36	2063.42	271921.0
2016-01-12 12:00:00	ES	Futures	2063.15	2068.52	2051.86	2055.09	224605.0
2016-01-12 13:00:00	ES	Futures	2055.09	2063.42	2053.74	2056.43	174925.0
2016-01-12 14:00:00	ES	Futures	2056.43	2067.98	2048.37	2066.91	253777.0
2016-01-12 15:00:00	ES	Futures	2066.91	2079.54	2061.0	2075.24	383918.0
2016-01-12 16:00:00	ES	Futures	2074.97	2077.12	2065.84	2066.37	81745.0
2016-01-12 18:00:00	ES	Futures	2066.37	2072.82	2066.1	2071.21	7088.0
2016-01-12 19:00:00	ES	Futures	2071.48	2079.27	2071.21	2078.73	13634.0
2016-01-12 20:00:00	ES	Futures	2078.73	2087.6	2076.85	2083.03	20123.0
2016-01-12 21:00:00	ES	Futures	2083.03	2088.41	2083.03	2084.64	21012.0
2016-01-12 22:00:00	ES	Futures	2084.91	2085.72	2080.08	2084.64	12125.0
2016-01-12 23:00:00	ES	Futures	2084.64	2089.48	2084.38	2089.21	8563.0
2016-01-12 00:00:00	NQ	Futures	5055.85	5058.52	5044.57	5050.21	1633.0
2016-01-12 01:00:00	NQ	Futures	5049.91	5049.91	5031.8	5044.86	1824.0
2016-01-12 02:00:00	NQ	Futures	5044.86	5065.05	5035.66	5058.23	3638.0
2016-01-12 03:00:00	NQ	Futures	5057.33	5071.59	5043.68	5063.57	6339.0
2016-01-12 04:00:00	NQ	Futures	5062.98	5096.53	5057.04	5093.56	6109.0
2016-01-12 05:00:00	NQ	Futures	5094.15	5118.8	5091.18	5114.94	5330.0
2016-01-12 06:00:00	NQ	Futures	5114.94	5122.36	5105.14	5112.86	5260.0
2016-01-12 07:00:00	NQ	Futures	5113.16	5134.24	5107.22	5132.16	5902.0
2016-01-12 08:00:00	NQ	Futures	5131.86	5146.12	5121.77	5129.49	12346.0
2016-01-12 09:00:00	NQ	Futures	5129.49	5161.56	5119.39	5147.6	52463.0
2016-01-12 10:00:00	NQ	Futures	5147.9	5156.51	5111.97	5126.22	58044.0
2016-01-12 11:00:00	NQ	Futures	5125.63	5128.9	5091.18	5112.86	44119.0
2016-01-12 12:00:00	NQ	Futures	5112.86	5124.44	5080.79	5090.59	38456.0
2016-01-12 13:00:00	NQ	Futures	5090.29	5111.38	5085.25	5088.81	36043.0
2016-01-12 14:00:00	NQ	Futures	5089.4	5125.63	5063.57	5121.77	50254.0
2016-01-12 15:00:00	NQ	Futures	5121.77	5149.38	5103.06	5136.32	63073.0
2016-01-12 16:00:00	NQ	Futures	5136.32	5143.15	5115.24	5115.83	10542.0
2016-01-12 18:00:00	NQ	Futures	5117.61	5133.05	5116.72	5129.79	1348.0
2016-01-12 19:00:00	NQ	Futures	5129.19	5149.68	5129.19	5148.2	2606.0
2016-01-12 20:00:00	NQ	Futures	5148.49	5168.09	5143.74	5156.81	5336.0
2016-01-12 21:00:00	NQ	Futures	5157.7	5171.06	5156.51	5161.56	3849.0
2016-01-12 22:00:00	NQ	Futures	5161.26	5163.93	5149.38	5160.07	1994.0
2016-01-12 23:00:00	NQ	Futures	5159.48	5171.95	5159.48	5171.06	1368.0
2016-01-12 00:00:00	YM	Futures	17274.4	17283.9	17244.5	17266.9	3962.0
2016-01-12 01:00:00	YM	Futures	17263.7	17263.7	17210.5	17249.9	3935.0
2016-01-12 02:00:00	YM	Futures	17248.8	17297.8	17220.1	17276.5	4297.0
2016-01-12 03:00:00	YM	Futures	17276.5	17313.7	17235.0	17293.5	8018.0

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

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