PREVIEW / futures_1hour / 2015-07-06

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-06.parquet
  size:    52 KB
  rows:    1,552

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-07-06 00:00:00	ES	Futures	2177.91	2178.44	2173.65	2173.65	6254.0
2015-07-06 01:00:00	ES	Futures	2173.92	2182.97	2172.85	2178.71	21339.0
2015-07-06 02:00:00	ES	Futures	2178.44	2187.23	2178.18	2186.43	25720.0
2015-07-06 03:00:00	ES	Futures	2186.43	2190.96	2184.57	2189.09	43665.0
2015-07-06 04:00:00	ES	Futures	2188.83	2189.63	2184.83	2187.5	20145.0
2015-07-06 05:00:00	ES	Futures	2187.5	2193.09	2185.63	2191.49	26610.0
2015-07-06 06:00:00	ES	Futures	2191.76	2193.09	2188.56	2189.63	24774.0
2015-07-06 07:00:00	ES	Futures	2189.89	2191.49	2181.9	2182.7	49350.0
2015-07-06 08:00:00	ES	Futures	2182.97	2186.7	2182.97	2185.1	52763.0
2015-07-06 09:00:00	ES	Futures	2184.83	2193.62	2182.44	2191.49	224178.0
2015-07-06 10:00:00	ES	Futures	2191.22	2205.07	2189.89	2200.01	333413.0
2015-07-06 11:00:00	ES	Futures	2200.28	2201.07	2194.15	2197.88	197946.0
2015-07-06 12:00:00	ES	Futures	2197.88	2199.21	2194.68	2196.02	101662.0
2015-07-06 13:00:00	ES	Futures	2196.02	2197.08	2186.96	2188.03	161683.0
2015-07-06 14:00:00	ES	Futures	2188.03	2189.63	2184.03	2186.16	152332.0
2015-07-06 15:00:00	ES	Futures	2186.16	2195.22	2185.63	2195.22	227420.0
2015-07-06 16:00:00	ES	Futures	2195.22	2201.61	2193.62	2201.61	84873.0
2015-07-06 17:00:00	ES	Futures	2201.61	2203.2	2201.34	2202.67	3636.0
2015-07-06 18:00:00	ES	Futures	2202.14	2207.46	2202.14	2205.87	8719.0
2015-07-06 19:00:00	ES	Futures	2205.87	2205.87	2202.94	2203.2	4387.0
2015-07-06 20:00:00	ES	Futures	2203.47	2205.33	2201.07	2205.07	6184.0
2015-07-06 21:00:00	ES	Futures	2205.07	2205.87	2204.0	2204.27	3935.0
2015-07-06 22:00:00	ES	Futures	2204.27	2205.87	2204.0	2204.27	3747.0
2015-07-06 23:00:00	ES	Futures	2204.27	2205.07	2203.47	2204.8	3420.0
2015-07-06 00:00:00	NQ	Futures	5175.43	5175.43	5165.37	5165.37	775.0
2015-07-06 01:00:00	NQ	Futures	5165.67	5184.6	5163.89	5175.13	2632.0
2015-07-06 02:00:00	NQ	Futures	5175.13	5195.25	5173.95	5194.06	2752.0
2015-07-06 03:00:00	NQ	Futures	5193.77	5207.08	5189.33	5198.5	5643.0
2015-07-06 04:00:00	NQ	Futures	5198.5	5200.27	5186.37	5194.06	3085.0
2015-07-06 05:00:00	NQ	Futures	5194.06	5207.67	5188.74	5205.3	3509.0
2015-07-06 06:00:00	NQ	Futures	5205.01	5209.15	5196.13	5200.57	3140.0
2015-07-06 07:00:00	NQ	Futures	5200.27	5203.23	5187.85	5190.51	9709.0
2015-07-06 08:00:00	NQ	Futures	5190.81	5201.75	5190.22	5196.72	18202.0
2015-07-06 09:00:00	NQ	Futures	5196.72	5219.8	5187.85	5215.65	41911.0
2015-07-06 10:00:00	NQ	Futures	5215.65	5249.97	5209.44	5236.36	45731.0
2015-07-06 11:00:00	NQ	Futures	5236.36	5238.73	5216.54	5224.53	24334.0
2015-07-06 12:00:00	NQ	Futures	5224.53	5228.97	5217.43	5222.75	11549.0
2015-07-06 13:00:00	NQ	Futures	5223.05	5225.42	5199.98	5203.23	20270.0
2015-07-06 14:00:00	NQ	Futures	5202.94	5207.08	5192.29	5196.13	19180.0
2015-07-06 15:00:00	NQ	Futures	5196.13	5220.39	5194.95	5220.39	31043.0
2015-07-06 16:00:00	NQ	Futures	5220.39	5239.91	5218.61	5237.84	10007.0
2015-07-06 17:00:00	NQ	Futures	5238.13	5241.98	5237.84	5241.68	384.0
2015-07-06 18:00:00	NQ	Futures	5240.8	5248.49	5240.21	5245.23	1616.0
2015-07-06 19:00:00	NQ	Futures	5245.23	5245.23	5239.61	5241.39	588.0
2015-07-06 20:00:00	NQ	Futures	5240.8	5244.64	5236.66	5244.05	840.0
2015-07-06 21:00:00	NQ	Futures	5243.16	5245.53	5241.68	5241.98	276.0
2015-07-06 22:00:00	NQ	Futures	5242.57	5245.53	5241.98	5242.87	365.0
2015-07-06 23:00:00	NQ	Futures	5243.16	5244.05	5240.8	5243.75	363.0
2015-07-06 00:00:00	YM	Futures	18388.1	18389.2	18358.6	18358.6	713.0
2015-07-06 01:00:00	YM	Futures	18359.7	18421.9	18352.3	18394.5	3301.0

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

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