PREVIEW / futures_1hour / 2016-06-29

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-29.parquet
  size:    55 KB
  rows:    1,648

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-06-29 00:00:00	ES	Futures	2206.1	2206.37	2204.47	2205.29	3024.0
2016-06-29 01:00:00	ES	Futures	2205.29	2205.56	2203.12	2204.2	4788.0
2016-06-29 02:00:00	ES	Futures	2204.47	2209.63	2203.66	2206.37	19494.0
2016-06-29 03:00:00	ES	Futures	2206.64	2209.08	2203.66	2206.64	41696.0
2016-06-29 04:00:00	ES	Futures	2206.64	2211.8	2206.37	2209.9	32912.0
2016-06-29 05:00:00	ES	Futures	2209.63	2211.8	2208.54	2211.25	24494.0
2016-06-29 06:00:00	ES	Futures	2211.25	2216.41	2211.25	2213.15	40484.0
2016-06-29 07:00:00	ES	Futures	2213.15	2215.05	2209.9	2214.78	40710.0
2016-06-29 08:00:00	ES	Futures	2214.51	2218.58	2212.88	2217.22	58569.0
2016-06-29 09:00:00	ES	Futures	2217.22	2221.02	2214.24	2218.3	264059.0
2016-06-29 10:00:00	ES	Futures	2218.58	2226.44	2217.22	2224.54	321765.0
2016-06-29 11:00:00	ES	Futures	2224.81	2232.14	2224.81	2230.51	251821.0
2016-06-29 12:00:00	ES	Futures	2230.78	2234.3	2229.69	2230.51	161166.0
2016-06-29 13:00:00	ES	Futures	2230.51	2232.14	2228.07	2232.14	116921.0
2016-06-29 14:00:00	ES	Futures	2232.14	2237.29	2231.59	2236.2	205166.0
2016-06-29 15:00:00	ES	Futures	2236.2	2239.46	2233.76	2236.75	285622.0
2016-06-29 16:00:00	ES	Futures	2236.47	2250.58	2236.2	2250.03	118326.0
2016-06-29 18:00:00	ES	Futures	2247.86	2248.68	2244.61	2244.88	9490.0
2016-06-29 19:00:00	ES	Futures	2244.88	2245.15	2241.9	2243.25	9370.0
2016-06-29 20:00:00	ES	Futures	2243.53	2244.34	2241.63	2241.63	7037.0
2016-06-29 21:00:00	ES	Futures	2241.63	2242.44	2240.27	2241.9	10664.0
2016-06-29 22:00:00	ES	Futures	2241.9	2244.34	2241.63	2242.71	6330.0
2016-06-29 23:00:00	ES	Futures	2242.98	2242.98	2240.54	2241.63	4231.0
2016-06-29 00:00:00	NQ	Futures	5116.95	5117.55	5112.78	5114.86	470.0
2016-06-29 01:00:00	NQ	Futures	5114.56	5115.16	5108.9	5111.88	970.0
2016-06-29 02:00:00	NQ	Futures	5112.48	5126.19	5110.69	5120.53	2295.0
2016-06-29 03:00:00	NQ	Futures	5120.53	5126.49	5113.97	5122.61	4323.0
2016-06-29 04:00:00	NQ	Futures	5122.61	5134.83	5121.12	5130.06	3543.0
2016-06-29 05:00:00	NQ	Futures	5130.66	5132.75	5124.4	5131.85	2437.0
2016-06-29 06:00:00	NQ	Futures	5131.85	5145.26	5131.85	5137.81	4452.0
2016-06-29 07:00:00	NQ	Futures	5137.22	5141.69	5130.06	5141.09	4056.0
2016-06-29 08:00:00	NQ	Futures	5141.09	5146.16	5133.04	5143.48	6659.0
2016-06-29 09:00:00	NQ	Futures	5143.48	5165.23	5137.51	5160.17	42666.0
2016-06-29 10:00:00	NQ	Futures	5160.17	5171.19	5153.91	5161.06	42335.0
2016-06-29 11:00:00	NQ	Futures	5161.06	5186.69	5161.06	5184.31	33532.0
2016-06-29 12:00:00	NQ	Futures	5184.61	5193.85	5182.22	5184.01	22339.0
2016-06-29 13:00:00	NQ	Futures	5184.01	5192.06	5179.84	5190.27	16350.0
2016-06-29 14:00:00	NQ	Futures	5190.57	5202.19	5189.38	5198.32	21082.0
2016-06-29 15:00:00	NQ	Futures	5198.32	5204.58	5187.29	5192.65	34586.0
2016-06-29 16:00:00	NQ	Futures	5192.36	5221.86	5191.76	5221.27	9355.0
2016-06-29 18:00:00	NQ	Futures	5215.9	5217.09	5209.35	5209.94	1220.0
2016-06-29 19:00:00	NQ	Futures	5209.94	5210.54	5202.19	5205.17	1190.0
2016-06-29 20:00:00	NQ	Futures	5205.47	5206.96	5198.91	5200.11	1230.0
2016-06-29 21:00:00	NQ	Futures	5199.81	5202.19	5194.44	5198.32	1612.0
2016-06-29 22:00:00	NQ	Futures	5198.62	5206.07	5198.32	5201.0	925.0
2016-06-29 23:00:00	NQ	Futures	5201.0	5202.49	5195.63	5198.02	560.0
2016-06-29 00:00:00	YM	Futures	18672.2	18672.2	18658.2	18666.8	550.0
2016-06-29 01:00:00	YM	Futures	18665.7	18666.8	18644.2	18656.0	934.0
2016-06-29 02:00:00	YM	Futures	18657.1	18696.9	18651.7	18679.7	1853.0
2016-06-29 03:00:00	YM	Futures	18679.7	18701.2	18662.5	18686.1	4799.0

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

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