PREVIEW / futures_1hour / 2016-05-03

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-03.parquet
  size:    56 KB
  rows:    1,663

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-03 00:00:00	ES	Futures	2241.37	2241.64	2238.4	2239.21	3383.0
2016-05-03 01:00:00	ES	Futures	2238.94	2240.29	2238.4	2238.94	2742.0
2016-05-03 02:00:00	ES	Futures	2238.67	2240.56	2237.59	2238.4	12206.0
2016-05-03 03:00:00	ES	Futures	2238.4	2238.4	2228.95	2229.76	49779.0
2016-05-03 04:00:00	ES	Futures	2230.03	2230.3	2225.45	2227.6	30954.0
2016-05-03 05:00:00	ES	Futures	2227.6	2228.41	2224.64	2226.25	22153.0
2016-05-03 06:00:00	ES	Futures	2226.25	2226.52	2221.67	2223.29	22843.0
2016-05-03 07:00:00	ES	Futures	2223.02	2226.79	2221.94	2225.45	35901.0
2016-05-03 08:00:00	ES	Futures	2225.45	2227.33	2223.56	2226.79	41567.0
2016-05-03 09:00:00	ES	Futures	2226.79	2227.33	2217.62	2220.32	239207.0
2016-05-03 10:00:00	ES	Futures	2220.59	2220.59	2213.57	2214.65	301138.0
2016-05-03 11:00:00	ES	Futures	2214.92	2219.24	2211.68	2217.35	231528.0
2016-05-03 12:00:00	ES	Futures	2217.62	2221.67	2214.92	2220.86	119499.0
2016-05-03 13:00:00	ES	Futures	2220.86	2228.14	2220.05	2224.37	171711.0
2016-05-03 14:00:00	ES	Futures	2224.37	2225.45	2220.05	2222.75	156129.0
2016-05-03 15:00:00	ES	Futures	2223.02	2223.83	2216.54	2221.4	264694.0
2016-05-03 16:00:00	ES	Futures	2221.4	2223.83	2219.78	2222.48	88638.0
2016-05-03 18:00:00	ES	Futures	2221.94	2223.56	2221.67	2221.94	3863.0
2016-05-03 19:00:00	ES	Futures	2222.21	2224.64	2221.94	2224.1	3445.0
2016-05-03 20:00:00	ES	Futures	2224.1	2224.91	2219.78	2220.59	7183.0
2016-05-03 21:00:00	ES	Futures	2220.59	2223.83	2220.59	2221.4	6349.0
2016-05-03 22:00:00	ES	Futures	2221.67	2221.67	2215.19	2216.54	10170.0
2016-05-03 23:00:00	ES	Futures	2216.54	2218.7	2215.73	2217.62	3731.0
2016-05-03 00:00:00	NQ	Futures	5202.01	5202.31	5193.98	5195.46	416.0
2016-05-03 01:00:00	NQ	Futures	5195.76	5199.33	5195.17	5196.06	371.0
2016-05-03 02:00:00	NQ	Futures	5195.76	5202.31	5192.79	5198.44	1327.0
2016-05-03 03:00:00	NQ	Futures	5199.03	5199.03	5171.96	5174.64	5848.0
2016-05-03 04:00:00	NQ	Futures	5174.64	5175.23	5161.84	5168.69	4011.0
2016-05-03 05:00:00	NQ	Futures	5168.09	5168.69	5160.06	5164.22	2738.0
2016-05-03 06:00:00	NQ	Futures	5163.93	5166.01	5154.4	5158.87	3129.0
2016-05-03 07:00:00	NQ	Futures	5158.87	5168.09	5156.19	5166.9	3466.0
2016-05-03 08:00:00	NQ	Futures	5166.6	5171.96	5161.55	5169.28	5607.0
2016-05-03 09:00:00	NQ	Futures	5169.28	5178.8	5148.45	5158.57	46119.0
2016-05-03 10:00:00	NQ	Futures	5158.57	5160.36	5140.72	5150.24	45304.0
2016-05-03 11:00:00	NQ	Futures	5150.54	5160.95	5142.21	5155.0	25997.0
2016-05-03 12:00:00	NQ	Futures	5155.0	5172.26	5145.78	5170.47	18662.0
2016-05-03 13:00:00	NQ	Futures	5170.17	5189.51	5166.9	5180.29	23214.0
2016-05-03 14:00:00	NQ	Futures	5180.29	5182.97	5159.76	5169.28	25157.0
2016-05-03 15:00:00	NQ	Futures	5169.58	5172.26	5147.56	5154.4	40298.0
2016-05-03 16:00:00	NQ	Futures	5154.7	5163.03	5154.11	5160.95	9460.0
2016-05-03 18:00:00	NQ	Futures	5159.76	5163.33	5159.17	5160.06	836.0
2016-05-03 19:00:00	NQ	Futures	5160.36	5166.31	5160.06	5164.52	584.0
2016-05-03 20:00:00	NQ	Futures	5164.82	5167.5	5153.81	5155.89	1003.0
2016-05-03 21:00:00	NQ	Futures	5155.89	5163.93	5155.3	5158.57	919.0
2016-05-03 22:00:00	NQ	Futures	5157.97	5158.87	5141.91	5146.37	1470.0
2016-05-03 23:00:00	NQ	Futures	5146.07	5153.21	5144.29	5150.83	872.0
2016-05-03 00:00:00	YM	Futures	19057.2	19058.3	19034.7	19040.1	709.0
2016-05-03 01:00:00	YM	Futures	19041.2	19049.7	19036.9	19041.2	468.0
2016-05-03 02:00:00	YM	Futures	19040.1	19054.0	19029.4	19040.1	2062.0
2016-05-03 03:00:00	YM	Futures	19041.2	19041.2	18955.5	18960.9	6851.0

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

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