PREVIEW / futures_1hour / 2014-05-27

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-27.parquet
  size:    47 KB
  rows:    1,504

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
2014-05-27 00:00:00	ES	Futures	1976.62	1977.14	1976.36	1976.88	952.0
2014-05-27 01:00:00	ES	Futures	1976.88	1977.4	1976.88	1976.88	1996.0
2014-05-27 02:00:00	ES	Futures	1976.88	1977.4	1975.58	1975.84	5546.0
2014-05-27 03:00:00	ES	Futures	1976.1	1977.4	1975.84	1977.4	13975.0
2014-05-27 04:00:00	ES	Futures	1977.14	1979.73	1976.62	1979.47	14807.0
2014-05-27 05:00:00	ES	Futures	1979.47	1979.73	1977.92	1978.95	10384.0
2014-05-27 06:00:00	ES	Futures	1978.95	1979.73	1978.43	1978.69	8096.0
2014-05-27 07:00:00	ES	Futures	1978.69	1978.95	1976.88	1977.4	10791.0
2014-05-27 08:00:00	ES	Futures	1977.4	1979.21	1976.62	1978.43	21729.0
2014-05-27 09:00:00	ES	Futures	1978.69	1980.77	1977.14	1978.95	149791.0
2014-05-27 10:00:00	ES	Futures	1978.69	1983.11	1978.69	1982.33	161768.0
2014-05-27 11:00:00	ES	Futures	1982.07	1982.85	1979.99	1980.51	77980.0
2014-05-27 12:00:00	ES	Futures	1980.77	1981.55	1978.43	1980.25	64745.0
2014-05-27 13:00:00	ES	Futures	1980.25	1981.03	1978.43	1981.03	51999.0
2014-05-27 14:00:00	ES	Futures	1980.77	1981.55	1979.99	1981.03	44754.0
2014-05-27 15:00:00	ES	Futures	1981.03	1983.89	1981.03	1983.11	128278.0
2014-05-27 16:00:00	ES	Futures	1983.11	1983.89	1982.59	1983.63	59784.0
2014-05-27 17:00:00	ES	Futures	1983.37	1983.63	1982.85	1983.37	2786.0
2014-05-27 18:00:00	ES	Futures	1983.63	1983.63	1982.07	1982.59	3156.0
2014-05-27 19:00:00	ES	Futures	1982.85	1983.37	1982.59	1983.11	1449.0
2014-05-27 20:00:00	ES	Futures	1982.85	1983.63	1982.33	1983.11	3179.0
2014-05-27 21:00:00	ES	Futures	1983.11	1984.41	1983.11	1983.89	4642.0
2014-05-27 22:00:00	ES	Futures	1984.15	1984.15	1983.11	1983.37	2158.0
2014-05-27 23:00:00	ES	Futures	1983.37	1983.63	1982.85	1983.37	1928.0
2014-05-27 00:00:00	NQ	Futures	4295.82	4296.4	4294.95	4295.82	186.0
2014-05-27 01:00:00	NQ	Futures	4296.11	4297.57	4295.82	4297.28	185.0
2014-05-27 02:00:00	NQ	Futures	4296.4	4297.86	4293.2	4294.07	566.0
2014-05-27 03:00:00	NQ	Futures	4294.65	4297.86	4294.36	4297.57	1483.0
2014-05-27 04:00:00	NQ	Futures	4297.86	4302.52	4296.11	4302.23	1829.0
2014-05-27 05:00:00	NQ	Futures	4302.23	4303.68	4299.02	4302.23	1584.0
2014-05-27 06:00:00	NQ	Futures	4302.23	4305.43	4301.06	4302.52	1744.0
2014-05-27 07:00:00	NQ	Futures	4302.52	4303.97	4299.61	4300.19	2538.0
2014-05-27 08:00:00	NQ	Futures	4299.9	4302.23	4296.98	4301.06	4905.0
2014-05-27 09:00:00	NQ	Futures	4301.35	4310.96	4297.28	4303.39	35321.0
2014-05-27 10:00:00	NQ	Futures	4303.39	4318.24	4302.52	4315.62	37026.0
2014-05-27 11:00:00	NQ	Futures	4315.62	4320.57	4312.42	4313.88	21941.0
2014-05-27 12:00:00	NQ	Futures	4314.17	4318.83	4310.38	4316.21	14080.0
2014-05-27 13:00:00	NQ	Futures	4315.91	4319.7	4311.55	4319.7	13067.0
2014-05-27 14:00:00	NQ	Futures	4319.7	4322.9	4317.08	4320.57	13901.0
2014-05-27 15:00:00	NQ	Futures	4320.86	4336.88	4320.28	4336.88	31688.0
2014-05-27 16:00:00	NQ	Futures	4336.59	4336.88	4333.68	4336.59	7542.0
2014-05-27 17:00:00	NQ	Futures	4336.3	4336.88	4335.13	4335.43	204.0
2014-05-27 18:00:00	NQ	Futures	4333.97	4335.13	4332.81	4333.68	494.0
2014-05-27 19:00:00	NQ	Futures	4333.97	4335.13	4333.39	4334.26	343.0
2014-05-27 20:00:00	NQ	Futures	4334.26	4334.84	4333.39	4334.26	478.0
2014-05-27 21:00:00	NQ	Futures	4334.84	4337.46	4334.55	4335.43	816.0
2014-05-27 22:00:00	NQ	Futures	4335.43	4336.59	4334.26	4336.59	491.0
2014-05-27 23:00:00	NQ	Futures	4336.3	4337.76	4334.55	4337.46	645.0
2014-05-27 00:00:00	YM	Futures	17126.6	17128.6	17122.4	17126.6	101.0
2014-05-27 01:00:00	YM	Futures	17126.6	17135.8	17125.5	17129.7	409.0

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

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