PREVIEW / futures_1hour / 2016-05-02

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-02.parquet
  size:    51 KB
  rows:    1,534

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-02 00:00:00	ES	Futures	2222.21	2223.29	2221.94	2223.02	3186.0
2016-05-02 01:00:00	ES	Futures	2223.29	2224.37	2223.02	2223.29	3175.0
2016-05-02 02:00:00	ES	Futures	2223.29	2227.06	2223.02	2224.91	12208.0
2016-05-02 03:00:00	ES	Futures	2224.91	2227.6	2221.4	2225.18	19502.0
2016-05-02 04:00:00	ES	Futures	2225.45	2227.87	2224.64	2225.18	14751.0
2016-05-02 05:00:00	ES	Futures	2224.91	2228.41	2224.64	2225.72	10162.0
2016-05-02 06:00:00	ES	Futures	2225.98	2227.33	2224.91	2227.33	8745.0
2016-05-02 07:00:00	ES	Futures	2227.33	2231.11	2227.06	2229.49	17616.0
2016-05-02 08:00:00	ES	Futures	2229.49	2231.38	2228.14	2230.03	21853.0
2016-05-02 09:00:00	ES	Futures	2230.03	2231.65	2224.1	2226.79	202127.0
2016-05-02 10:00:00	ES	Futures	2226.79	2234.08	2224.64	2228.41	240637.0
2016-05-02 11:00:00	ES	Futures	2228.68	2234.62	2228.41	2229.76	159216.0
2016-05-02 12:00:00	ES	Futures	2229.49	2234.08	2228.14	2233.81	95447.0
2016-05-02 13:00:00	ES	Futures	2233.81	2238.67	2233.27	2236.78	98872.0
2016-05-02 14:00:00	ES	Futures	2237.05	2239.75	2236.51	2238.94	81582.0
2016-05-02 15:00:00	ES	Futures	2238.94	2243.53	2238.67	2241.1	196410.0
2016-05-02 16:00:00	ES	Futures	2241.37	2242.18	2239.48	2241.64	65116.0
2016-05-02 18:00:00	ES	Futures	2241.37	2242.18	2239.75	2241.37	4548.0
2016-05-02 19:00:00	ES	Futures	2241.37	2241.64	2239.75	2239.75	2282.0
2016-05-02 20:00:00	ES	Futures	2240.02	2240.29	2238.4	2240.29	5756.0
2016-05-02 21:00:00	ES	Futures	2240.02	2241.37	2238.13	2238.13	6356.0
2016-05-02 22:00:00	ES	Futures	2238.13	2240.02	2238.13	2239.75	3215.0
2016-05-02 23:00:00	ES	Futures	2239.75	2241.91	2239.75	2241.64	2368.0
2016-05-02 00:00:00	NQ	Futures	5146.97	5150.24	5146.67	5150.24	691.0
2016-05-02 01:00:00	NQ	Futures	5149.64	5152.02	5149.35	5151.13	338.0
2016-05-02 02:00:00	NQ	Futures	5150.83	5159.76	5150.24	5155.0	1475.0
2016-05-02 03:00:00	NQ	Futures	5154.7	5165.41	5143.99	5153.81	3933.0
2016-05-02 04:00:00	NQ	Futures	5154.11	5161.25	5152.62	5153.81	1942.0
2016-05-02 05:00:00	NQ	Futures	5153.51	5163.63	5152.92	5155.0	1364.0
2016-05-02 06:00:00	NQ	Futures	5155.3	5159.76	5153.51	5159.46	1325.0
2016-05-02 07:00:00	NQ	Futures	5159.76	5170.17	5159.76	5165.71	1949.0
2016-05-02 08:00:00	NQ	Futures	5165.12	5170.17	5162.74	5166.9	3032.0
2016-05-02 09:00:00	NQ	Futures	5166.9	5170.17	5149.05	5153.51	40096.0
2016-05-02 10:00:00	NQ	Futures	5153.21	5174.64	5146.37	5151.73	45839.0
2016-05-02 11:00:00	NQ	Futures	5151.73	5168.98	5151.13	5158.57	27249.0
2016-05-02 12:00:00	NQ	Futures	5158.27	5174.64	5153.51	5170.17	18037.0
2016-05-02 13:00:00	NQ	Futures	5170.17	5188.03	5166.31	5181.78	14056.0
2016-05-02 14:00:00	NQ	Futures	5182.07	5199.93	5181.18	5198.74	16054.0
2016-05-02 15:00:00	NQ	Futures	5198.74	5210.94	5197.55	5203.2	26377.0
2016-05-02 16:00:00	NQ	Futures	5203.2	5205.28	5197.84	5203.5	7041.0
2016-05-02 18:00:00	NQ	Futures	5203.2	5206.17	5199.63	5203.2	386.0
2016-05-02 19:00:00	NQ	Futures	5203.5	5203.79	5198.74	5199.63	376.0
2016-05-02 20:00:00	NQ	Futures	5199.63	5200.82	5194.87	5199.63	1030.0
2016-05-02 21:00:00	NQ	Futures	5199.33	5202.6	5195.17	5195.46	524.0
2016-05-02 22:00:00	NQ	Futures	5195.46	5199.03	5193.38	5199.03	385.0
2016-05-02 23:00:00	NQ	Futures	5199.03	5203.2	5197.84	5202.31	287.0
2016-05-02 00:00:00	YM	Futures	18930.9	18936.3	18927.7	18936.3	473.0
2016-05-02 01:00:00	YM	Futures	18934.1	18941.6	18934.1	18937.3	338.0
2016-05-02 02:00:00	YM	Futures	18936.3	18966.2	18934.1	18954.5	1689.0
2016-05-02 03:00:00	YM	Futures	18954.5	18973.7	18922.4	18950.2	2893.0

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

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