PREVIEW / futures_1hour / 2013-04-22

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-22.parquet
  size:    49 KB
  rows:    1,508

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-22 00:00:00	ES	Futures	1603.98	1604.24	1601.4	1601.66	3099.0
2013-04-22 01:00:00	ES	Futures	1601.66	1602.17	1600.63	1601.4	4867.0
2013-04-22 02:00:00	ES	Futures	1601.4	1603.46	1600.37	1603.46	11546.0
2013-04-22 03:00:00	ES	Futures	1603.2	1604.24	1599.34	1599.6	31311.0
2013-04-22 04:00:00	ES	Futures	1599.34	1603.2	1598.31	1602.69	26311.0
2013-04-22 05:00:00	ES	Futures	1602.95	1603.98	1602.17	1603.72	11607.0
2013-04-22 06:00:00	ES	Futures	1603.72	1604.24	1602.69	1603.46	17504.0
2013-04-22 07:00:00	ES	Futures	1603.46	1603.98	1600.37	1600.89	29549.0
2013-04-22 08:00:00	ES	Futures	1600.63	1602.17	1598.31	1599.34	34987.0
2013-04-22 09:00:00	ES	Futures	1599.08	1602.43	1594.19	1597.8	245803.0
2013-04-22 10:00:00	ES	Futures	1597.8	1597.8	1589.55	1594.7	374092.0
2013-04-22 11:00:00	ES	Futures	1594.96	1598.83	1592.64	1597.8	170836.0
2013-04-22 12:00:00	ES	Futures	1597.8	1602.69	1597.8	1600.37	121369.0
2013-04-22 13:00:00	ES	Futures	1600.63	1602.43	1599.34	1600.37	74859.0
2013-04-22 14:00:00	ES	Futures	1600.37	1608.36	1600.37	1605.78	171238.0
2013-04-22 15:00:00	ES	Futures	1605.52	1607.07	1603.72	1604.24	148956.0
2013-04-22 16:00:00	ES	Futures	1604.49	1605.52	1602.43	1605.01	68372.0
2013-04-22 17:00:00	ES	Futures	1605.01	1605.52	1604.75	1605.01	1535.0
2013-04-22 18:00:00	ES	Futures	1604.49	1604.75	1602.69	1603.2	5944.0
2013-04-22 19:00:00	ES	Futures	1603.2	1603.46	1602.17	1602.69	2211.0
2013-04-22 20:00:00	ES	Futures	1602.43	1602.95	1600.37	1600.89	6340.0
2013-04-22 21:00:00	ES	Futures	1601.14	1601.4	1599.08	1599.34	9342.0
2013-04-22 22:00:00	ES	Futures	1599.6	1600.37	1598.57	1598.83	11385.0
2013-04-22 23:00:00	ES	Futures	1599.08	1599.86	1598.57	1599.34	3486.0
2013-04-22 00:00:00	NQ	Futures	3250.06	3250.35	3245.97	3246.85	367.0
2013-04-22 01:00:00	NQ	Futures	3246.85	3248.01	3244.51	3245.68	355.0
2013-04-22 02:00:00	NQ	Futures	3246.26	3250.06	3243.93	3250.06	774.0
2013-04-22 03:00:00	NQ	Futures	3249.76	3253.26	3241.01	3241.6	3456.0
2013-04-22 04:00:00	NQ	Futures	3241.6	3250.93	3238.68	3250.06	2194.0
2013-04-22 05:00:00	NQ	Futures	3250.06	3254.43	3248.89	3254.14	1544.0
2013-04-22 06:00:00	NQ	Futures	3254.43	3254.72	3251.22	3252.1	1497.0
2013-04-22 07:00:00	NQ	Futures	3252.1	3253.56	3244.51	3246.26	2596.0
2013-04-22 08:00:00	NQ	Futures	3245.97	3250.35	3240.14	3242.47	3955.0
2013-04-22 09:00:00	NQ	Futures	3242.47	3259.1	3239.56	3255.01	48052.0
2013-04-22 10:00:00	NQ	Futures	3255.31	3255.89	3234.89	3248.6	46234.0
2013-04-22 11:00:00	NQ	Futures	3248.6	3257.35	3244.22	3255.01	20395.0
2013-04-22 12:00:00	NQ	Futures	3255.31	3266.97	3254.72	3261.72	22418.0
2013-04-22 13:00:00	NQ	Futures	3262.01	3266.97	3258.51	3260.85	11659.0
2013-04-22 14:00:00	NQ	Futures	3260.85	3278.35	3260.56	3275.72	21782.0
2013-04-22 15:00:00	NQ	Futures	3275.14	3281.26	3268.72	3269.31	30591.0
2013-04-22 16:00:00	NQ	Futures	3269.01	3269.6	3264.93	3269.31	8075.0
2013-04-22 17:00:00	NQ	Futures	3269.6	3270.47	3268.14	3268.43	194.0
2013-04-22 18:00:00	NQ	Futures	3267.56	3268.43	3265.22	3266.1	332.0
2013-04-22 19:00:00	NQ	Futures	3265.81	3266.68	3264.64	3265.22	171.0
2013-04-22 20:00:00	NQ	Futures	3265.22	3265.81	3262.6	3263.76	718.0
2013-04-22 21:00:00	NQ	Futures	3263.76	3263.76	3259.97	3260.85	937.0
2013-04-22 22:00:00	NQ	Futures	3260.85	3262.01	3258.51	3258.81	1127.0
2013-04-22 23:00:00	NQ	Futures	3258.51	3260.56	3258.22	3259.1	468.0
2013-04-22 00:00:00	YM	Futures	14703.2	14704.2	14687.0	14690.0	384.0
2013-04-22 01:00:00	YM	Futures	14689.0	14692.1	14679.9	14684.0	551.0

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

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