PREVIEW / futures_1hour / 2014-05-23

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-23.parquet
  size:    41 KB
  rows:    1,271

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-23 00:00:00	ES	Futures	1964.41	1964.93	1964.15	1964.67	635.0
2014-05-23 01:00:00	ES	Futures	1964.67	1964.93	1964.15	1964.41	1258.0
2014-05-23 02:00:00	ES	Futures	1964.41	1964.93	1963.63	1964.93	4202.0
2014-05-23 03:00:00	ES	Futures	1964.93	1964.93	1962.85	1964.41	16888.0
2014-05-23 04:00:00	ES	Futures	1964.41	1965.45	1963.63	1964.67	12160.0
2014-05-23 05:00:00	ES	Futures	1964.93	1965.97	1964.15	1965.45	6960.0
2014-05-23 06:00:00	ES	Futures	1965.71	1966.23	1963.89	1965.19	11210.0
2014-05-23 07:00:00	ES	Futures	1964.93	1965.71	1964.41	1964.93	11807.0
2014-05-23 08:00:00	ES	Futures	1964.93	1965.19	1964.15	1964.15	9877.0
2014-05-23 09:00:00	ES	Futures	1964.15	1966.49	1962.85	1965.71	112017.0
2014-05-23 10:00:00	ES	Futures	1965.97	1969.61	1965.19	1969.35	141992.0
2014-05-23 11:00:00	ES	Futures	1969.09	1970.13	1968.31	1969.35	98765.0
2014-05-23 12:00:00	ES	Futures	1969.35	1971.16	1969.35	1970.13	55582.0
2014-05-23 13:00:00	ES	Futures	1970.38	1970.38	1969.09	1970.13	39988.0
2014-05-23 14:00:00	ES	Futures	1970.13	1971.16	1969.35	1970.64	37771.0
2014-05-23 15:00:00	ES	Futures	1970.9	1972.72	1970.64	1971.42	110005.0
2014-05-23 16:00:00	ES	Futures	1971.42	1971.42	1969.87	1970.9	63981.0
2014-05-23 17:00:00	ES	Futures	1970.64	1970.9	1969.61	1969.87	2111.0
2014-05-23 00:00:00	NQ	Futures	4251.85	4254.17	4251.55	4253.88	180.0
2014-05-23 01:00:00	NQ	Futures	4253.59	4254.47	4252.72	4253.3	257.0
2014-05-23 02:00:00	NQ	Futures	4253.59	4255.34	4251.85	4253.01	646.0
2014-05-23 03:00:00	NQ	Futures	4253.3	4254.47	4248.93	4253.59	2111.0
2014-05-23 04:00:00	NQ	Futures	4253.59	4256.21	4251.85	4254.76	1509.0
2014-05-23 05:00:00	NQ	Futures	4254.76	4257.67	4253.01	4257.09	1029.0
2014-05-23 06:00:00	NQ	Futures	4257.09	4257.96	4253.88	4256.21	1467.0
2014-05-23 07:00:00	NQ	Futures	4256.21	4257.09	4254.17	4255.05	1802.0
2014-05-23 08:00:00	NQ	Futures	4254.76	4256.21	4253.59	4253.59	2535.0
2014-05-23 09:00:00	NQ	Futures	4253.3	4262.91	4246.31	4257.38	34694.0
2014-05-23 10:00:00	NQ	Futures	4257.38	4263.2	4254.47	4260.87	30701.0
2014-05-23 11:00:00	NQ	Futures	4260.58	4269.32	4259.71	4267.28	23355.0
2014-05-23 12:00:00	NQ	Futures	4267.57	4272.23	4266.99	4270.77	11207.0
2014-05-23 13:00:00	NQ	Futures	4270.77	4275.14	4269.03	4273.69	11065.0
2014-05-23 14:00:00	NQ	Futures	4273.69	4279.51	4273.4	4278.93	10266.0
2014-05-23 15:00:00	NQ	Futures	4278.93	4283.3	4278.35	4282.42	24054.0
2014-05-23 16:00:00	NQ	Futures	4282.13	4283.3	4280.09	4282.71	6122.0
2014-05-23 17:00:00	NQ	Futures	4282.71	4282.71	4280.68	4281.84	202.0
2014-05-23 00:00:00	YM	Futures	17028.7	17037.0	17028.7	17035.9	134.0
2014-05-23 01:00:00	YM	Futures	17035.9	17037.0	17031.8	17032.8	143.0
2014-05-23 02:00:00	YM	Futures	17032.8	17037.0	17025.6	17035.9	621.0
2014-05-23 03:00:00	YM	Futures	17035.9	17037.0	17016.4	17032.8	3008.0
2014-05-23 04:00:00	YM	Futures	17031.8	17038.0	17023.6	17031.8	1874.0
2014-05-23 05:00:00	YM	Futures	17031.8	17039.0	17025.6	17035.9	873.0
2014-05-23 06:00:00	YM	Futures	17037.0	17042.1	17025.6	17033.9	1292.0
2014-05-23 07:00:00	YM	Futures	17033.9	17037.0	17027.7	17031.8	1351.0
2014-05-23 08:00:00	YM	Futures	17031.8	17032.8	17023.6	17024.6	1002.0
2014-05-23 09:00:00	YM	Futures	17024.6	17060.7	17015.3	17051.4	13847.0
2014-05-23 10:00:00	YM	Futures	17051.4	17078.2	17044.2	17067.9	13643.0
2014-05-23 11:00:00	YM	Futures	17067.9	17075.1	17060.7	17066.8	8251.0
2014-05-23 12:00:00	YM	Futures	17066.8	17076.1	17064.8	17064.8	6321.0
2014-05-23 13:00:00	YM	Futures	17065.8	17073.0	17060.7	17072.0	4117.0

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

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