PREVIEW / futures_1hour / 2016-05-10

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-10.parquet
  size:    53 KB
  rows:    1,623

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-05-10 00:00:00	ES	Futures	2223.83	2224.1	2221.67	2223.02	3499.0
2016-05-10 01:00:00	ES	Futures	2222.75	2224.37	2222.21	2224.1	4057.0
2016-05-10 02:00:00	ES	Futures	2224.1	2227.6	2223.29	2227.06	20187.0
2016-05-10 03:00:00	ES	Futures	2227.06	2233.54	2226.79	2231.38	51175.0
2016-05-10 04:00:00	ES	Futures	2231.38	2234.62	2228.95	2233.81	29748.0
2016-05-10 05:00:00	ES	Futures	2233.81	2234.08	2229.76	2230.3	19827.0
2016-05-10 06:00:00	ES	Futures	2230.3	2231.92	2227.6	2227.87	18273.0
2016-05-10 07:00:00	ES	Futures	2227.6	2227.87	2221.94	2224.64	45341.0
2016-05-10 08:00:00	ES	Futures	2224.91	2227.33	2224.37	2226.25	30064.0
2016-05-10 09:00:00	ES	Futures	2226.25	2234.62	2225.72	2233.27	208376.0
2016-05-10 10:00:00	ES	Futures	2233.27	2238.4	2230.57	2237.32	237121.0
2016-05-10 11:00:00	ES	Futures	2237.32	2238.4	2234.62	2238.4	137267.0
2016-05-10 12:00:00	ES	Futures	2238.4	2240.83	2238.4	2239.75	97171.0
2016-05-10 13:00:00	ES	Futures	2239.75	2241.64	2237.59	2240.83	76646.0
2016-05-10 14:00:00	ES	Futures	2241.1	2242.18	2239.75	2240.83	79570.0
2016-05-10 15:00:00	ES	Futures	2240.83	2245.96	2240.29	2245.69	206531.0
2016-05-10 16:00:00	ES	Futures	2245.69	2245.96	2242.72	2242.99	79002.0
2016-05-10 18:00:00	ES	Futures	2243.26	2243.8	2241.91	2242.99	3634.0
2016-05-10 19:00:00	ES	Futures	2242.99	2243.8	2242.18	2242.99	3990.0
2016-05-10 20:00:00	ES	Futures	2242.99	2244.88	2242.18	2244.07	6464.0
2016-05-10 21:00:00	ES	Futures	2243.8	2244.61	2240.02	2240.56	9810.0
2016-05-10 22:00:00	ES	Futures	2240.56	2241.37	2238.94	2240.02	7762.0
2016-05-10 23:00:00	ES	Futures	2240.29	2240.83	2238.67	2239.21	4652.0
2016-05-10 00:00:00	NQ	Futures	5174.04	5175.23	5169.28	5171.66	489.0
2016-05-10 01:00:00	NQ	Futures	5171.66	5175.83	5170.47	5174.64	429.0
2016-05-10 02:00:00	NQ	Futures	5174.93	5182.37	5172.85	5179.1	2279.0
2016-05-10 03:00:00	NQ	Futures	5179.1	5194.87	5178.8	5187.43	7560.0
2016-05-10 04:00:00	NQ	Futures	5187.73	5194.87	5182.07	5193.08	3680.0
2016-05-10 05:00:00	NQ	Futures	5193.38	5193.98	5183.56	5184.46	2207.0
2016-05-10 06:00:00	NQ	Futures	5184.75	5191.0	5180.29	5180.88	2779.0
2016-05-10 07:00:00	NQ	Futures	5180.59	5180.59	5162.74	5171.36	5576.0
2016-05-10 08:00:00	NQ	Futures	5171.36	5175.83	5170.17	5171.96	4904.0
2016-05-10 09:00:00	NQ	Futures	5171.66	5192.19	5169.28	5187.13	43344.0
2016-05-10 10:00:00	NQ	Futures	5186.84	5206.47	5182.07	5204.09	32468.0
2016-05-10 11:00:00	NQ	Futures	5203.79	5211.53	5200.22	5211.23	18517.0
2016-05-10 12:00:00	NQ	Futures	5211.53	5221.65	5211.23	5218.97	16168.0
2016-05-10 13:00:00	NQ	Futures	5218.97	5222.54	5212.42	5220.46	12400.0
2016-05-10 14:00:00	NQ	Futures	5220.75	5223.73	5217.78	5219.86	10656.0
2016-05-10 15:00:00	NQ	Futures	5219.86	5235.04	5218.97	5232.36	24224.0
2016-05-10 16:00:00	NQ	Futures	5232.65	5232.95	5225.51	5231.76	6745.0
2016-05-10 18:00:00	NQ	Futures	5229.68	5232.36	5226.11	5229.38	711.0
2016-05-10 19:00:00	NQ	Futures	5228.49	5230.87	5227.0	5228.19	396.0
2016-05-10 20:00:00	NQ	Futures	5228.19	5233.55	5226.11	5231.76	993.0
2016-05-10 21:00:00	NQ	Futures	5231.76	5233.25	5219.86	5221.35	1484.0
2016-05-10 22:00:00	NQ	Futures	5221.05	5223.43	5218.08	5220.46	1169.0
2016-05-10 23:00:00	NQ	Futures	5220.75	5221.65	5217.48	5217.78	616.0
2016-05-10 00:00:00	YM	Futures	18936.3	18937.3	18921.3	18932.0	678.0
2016-05-10 01:00:00	YM	Futures	18932.0	18939.5	18924.5	18937.3	786.0
2016-05-10 02:00:00	YM	Futures	18937.3	18964.1	18928.8	18952.3	3388.0
2016-05-10 03:00:00	YM	Futures	18952.3	19009.1	18951.3	18993.0	7962.0

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

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