PREVIEW / futures_1hour / 2013-04-01

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-01.parquet
  size:    41 KB
  rows:    1,231

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
2013-04-01 00:00:00	ES	Futures	1608.87	1610.16	1606.55	1608.1	6045.0
2013-04-01 01:00:00	ES	Futures	1608.36	1608.87	1606.81	1607.33	3472.0
2013-04-01 02:00:00	ES	Futures	1607.07	1607.84	1606.81	1607.33	1809.0
2013-04-01 03:00:00	ES	Futures	1607.33	1608.87	1607.33	1607.58	2507.0
2013-04-01 04:00:00	ES	Futures	1607.58	1607.84	1606.81	1607.84	3389.0
2013-04-01 05:00:00	ES	Futures	1607.84	1608.1	1606.55	1607.33	2089.0
2013-04-01 06:00:00	ES	Futures	1607.33	1609.39	1607.07	1608.87	4417.0
2013-04-01 07:00:00	ES	Futures	1609.13	1611.45	1608.87	1609.9	5977.0
2013-04-01 08:00:00	ES	Futures	1609.9	1611.19	1609.39	1609.9	13055.0
2013-04-01 09:00:00	ES	Futures	1609.64	1612.48	1608.61	1609.39	103186.0
2013-04-01 10:00:00	ES	Futures	1609.39	1610.67	1601.4	1601.66	308346.0
2013-04-01 11:00:00	ES	Futures	1601.4	1603.98	1600.37	1602.43	146572.0
2013-04-01 12:00:00	ES	Futures	1602.43	1603.72	1600.89	1603.46	86833.0
2013-04-01 13:00:00	ES	Futures	1603.72	1605.78	1603.2	1603.98	80231.0
2013-04-01 14:00:00	ES	Futures	1603.98	1605.27	1601.66	1602.17	74424.0
2013-04-01 15:00:00	ES	Futures	1602.17	1603.72	1599.6	1603.72	195619.0
2013-04-01 16:00:00	ES	Futures	1603.72	1603.98	1602.17	1602.95	71549.0
2013-04-01 17:00:00	ES	Futures	1602.95	1603.98	1602.95	1603.72	2000.0
2013-04-01 18:00:00	ES	Futures	1603.46	1603.98	1602.43	1603.2	3308.0
2013-04-01 19:00:00	ES	Futures	1603.2	1604.24	1602.69	1603.98	3287.0
2013-04-01 20:00:00	ES	Futures	1603.72	1603.98	1601.4	1602.17	9797.0
2013-04-01 21:00:00	ES	Futures	1602.43	1605.01	1601.92	1604.75	7641.0
2013-04-01 22:00:00	ES	Futures	1604.49	1605.78	1603.98	1604.49	6280.0
2013-04-01 23:00:00	ES	Futures	1604.75	1605.01	1603.46	1603.72	3629.0
2013-04-01 00:00:00	NQ	Futures	3280.39	3282.14	3275.43	3277.76	572.0
2013-04-01 01:00:00	NQ	Futures	3278.35	3279.51	3276.31	3276.31	227.0
2013-04-01 02:00:00	NQ	Futures	3276.6	3277.76	3276.01	3277.18	137.0
2013-04-01 03:00:00	NQ	Futures	3277.18	3278.64	3276.01	3276.01	252.0
2013-04-01 04:00:00	NQ	Futures	3277.18	3277.18	3274.85	3276.31	192.0
2013-04-01 05:00:00	NQ	Futures	3276.01	3276.6	3275.14	3276.31	222.0
2013-04-01 06:00:00	NQ	Futures	3276.31	3281.56	3276.31	3281.26	499.0
2013-04-01 07:00:00	NQ	Futures	3281.26	3285.06	3280.68	3282.72	854.0
2013-04-01 08:00:00	NQ	Futures	3282.72	3284.76	3282.14	3283.6	1875.0
2013-04-01 09:00:00	NQ	Futures	3283.89	3285.06	3279.81	3280.1	14875.0
2013-04-01 10:00:00	NQ	Futures	3280.39	3282.14	3260.56	3260.85	36110.0
2013-04-01 11:00:00	NQ	Futures	3260.56	3268.43	3257.64	3264.93	23266.0
2013-04-01 12:00:00	NQ	Futures	3264.93	3265.22	3257.06	3262.6	15296.0
2013-04-01 13:00:00	NQ	Futures	3262.6	3267.26	3260.85	3261.43	7862.0
2013-04-01 14:00:00	NQ	Futures	3261.72	3265.51	3255.6	3255.89	10153.0
2013-04-01 15:00:00	NQ	Futures	3256.18	3257.64	3248.31	3256.76	24666.0
2013-04-01 16:00:00	NQ	Futures	3257.06	3258.22	3252.1	3253.85	6362.0
2013-04-01 17:00:00	NQ	Futures	3254.14	3256.18	3254.14	3255.31	123.0
2013-04-01 18:00:00	NQ	Futures	3254.72	3255.6	3252.68	3253.56	248.0
2013-04-01 19:00:00	NQ	Futures	3253.56	3255.31	3252.97	3254.43	344.0
2013-04-01 20:00:00	NQ	Futures	3254.43	3254.43	3250.64	3251.51	670.0
2013-04-01 21:00:00	NQ	Futures	3251.51	3255.89	3251.51	3255.31	1327.0
2013-04-01 22:00:00	NQ	Futures	3255.31	3257.06	3254.43	3255.6	825.0
2013-04-01 23:00:00	NQ	Futures	3255.6	3255.89	3253.85	3254.43	422.0
2013-04-01 00:00:00	YM	Futures	14652.6	14662.7	14635.5	14646.6	837.0
2013-04-01 01:00:00	YM	Futures	14646.6	14652.6	14636.5	14638.5	453.0

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

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