PREVIEW / futures_1hour / 2015-09-16

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-16.parquet
  size:    52 KB
  rows:    1,573

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
2015-09-16 00:00:00	ES	Futures	2102.35	2106.1	2102.35	2104.76	3535.0
2015-09-16 01:00:00	ES	Futures	2104.49	2105.83	2102.88	2104.22	2802.0
2015-09-16 02:00:00	ES	Futures	2104.22	2109.04	2103.96	2107.97	14564.0
2015-09-16 03:00:00	ES	Futures	2107.97	2111.45	2103.69	2104.76	27417.0
2015-09-16 04:00:00	ES	Futures	2105.03	2108.5	2103.96	2105.56	13413.0
2015-09-16 05:00:00	ES	Futures	2105.56	2108.5	2103.15	2104.22	14601.0
2015-09-16 06:00:00	ES	Futures	2104.22	2107.7	2102.62	2107.43	10543.0
2015-09-16 07:00:00	ES	Futures	2107.7	2109.04	2106.1	2108.5	17400.0
2015-09-16 08:00:00	ES	Futures	2108.5	2109.04	2104.76	2106.1	25227.0
2015-09-16 09:00:00	ES	Futures	2106.36	2113.05	2105.83	2107.97	165691.0
2015-09-16 10:00:00	ES	Futures	2107.97	2112.25	2105.29	2109.31	149355.0
2015-09-16 11:00:00	ES	Futures	2109.31	2119.74	2108.24	2118.67	172119.0
2015-09-16 12:00:00	ES	Futures	2118.67	2123.22	2117.07	2122.69	112597.0
2015-09-16 13:00:00	ES	Futures	2122.42	2122.69	2117.07	2120.81	67914.0
2015-09-16 14:00:00	ES	Futures	2120.81	2122.95	2113.86	2121.88	123309.0
2015-09-16 15:00:00	ES	Futures	2121.88	2126.7	2120.54	2124.02	228705.0
2015-09-16 16:00:00	ES	Futures	2124.02	2128.84	2122.69	2127.23	62835.0
2015-09-16 17:00:00	ES	Futures	2126.97	2127.23	2126.16	2126.7	2315.0
2015-09-16 18:00:00	ES	Futures	2126.16	2126.7	2124.83	2125.9	2971.0
2015-09-16 19:00:00	ES	Futures	2125.9	2126.43	2124.29	2124.29	1853.0
2015-09-16 20:00:00	ES	Futures	2124.56	2126.43	2123.76	2124.56	5198.0
2015-09-16 21:00:00	ES	Futures	2124.56	2125.36	2122.69	2123.22	4661.0
2015-09-16 22:00:00	ES	Futures	2123.22	2124.83	2121.62	2124.02	4269.0
2015-09-16 23:00:00	ES	Futures	2124.29	2125.36	2123.76	2124.56	2097.0
2015-09-16 00:00:00	NQ	Futures	5147.08	5155.98	5147.08	5152.72	617.0
2015-09-16 01:00:00	NQ	Futures	5151.83	5154.5	5147.08	5151.83	571.0
2015-09-16 02:00:00	NQ	Futures	5150.94	5163.39	5150.94	5160.43	1477.0
2015-09-16 03:00:00	NQ	Futures	5159.83	5169.62	5153.01	5155.39	3922.0
2015-09-16 04:00:00	NQ	Futures	5155.39	5163.39	5153.01	5156.87	1507.0
2015-09-16 05:00:00	NQ	Futures	5156.28	5163.39	5150.94	5152.42	1420.0
2015-09-16 06:00:00	NQ	Futures	5152.42	5162.8	5149.46	5162.21	1918.0
2015-09-16 07:00:00	NQ	Futures	5162.5	5165.76	5159.54	5164.87	1668.0
2015-09-16 08:00:00	NQ	Futures	5164.58	5165.76	5153.61	5156.57	3507.0
2015-09-16 09:00:00	NQ	Futures	5156.28	5169.32	5142.04	5148.27	27738.0
2015-09-16 10:00:00	NQ	Futures	5147.97	5161.61	5141.15	5151.24	22759.0
2015-09-16 11:00:00	NQ	Futures	5151.53	5176.44	5148.27	5172.29	23347.0
2015-09-16 12:00:00	NQ	Futures	5172.29	5185.04	5167.54	5181.48	15692.0
2015-09-16 13:00:00	NQ	Futures	5181.48	5181.48	5166.06	5175.55	9858.0
2015-09-16 14:00:00	NQ	Futures	5175.84	5180.29	5155.68	5177.33	17322.0
2015-09-16 15:00:00	NQ	Futures	5177.92	5192.45	5175.55	5187.41	32741.0
2015-09-16 16:00:00	NQ	Futures	5187.41	5197.19	5184.74	5192.45	7085.0
2015-09-16 17:00:00	NQ	Futures	5193.04	5193.04	5191.56	5193.04	145.0
2015-09-16 18:00:00	NQ	Futures	5191.26	5192.15	5188.59	5190.67	400.0
2015-09-16 19:00:00	NQ	Futures	5190.96	5192.45	5188.0	5188.3	228.0
2015-09-16 20:00:00	NQ	Futures	5188.59	5193.34	5186.22	5190.08	894.0
2015-09-16 21:00:00	NQ	Futures	5190.08	5192.45	5185.63	5187.11	822.0
2015-09-16 22:00:00	NQ	Futures	5187.11	5192.15	5184.44	5190.67	755.0
2015-09-16 23:00:00	NQ	Futures	5190.67	5194.52	5189.48	5192.15	426.0
2015-09-16 00:00:00	YM	Futures	17460.7	17483.0	17457.6	17469.2	661.0
2015-09-16 01:00:00	YM	Futures	17467.1	17476.6	17453.3	17465.0	492.0

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

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