PREVIEW / futures_1hour / 2013-03-20

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-20.parquet
  size:    50 KB
  rows:    1,540

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-03-20 00:00:00	ES	Futures	1586.98	1588.27	1586.72	1587.49	3657.0
2013-03-20 01:00:00	ES	Futures	1587.75	1588.27	1586.98	1587.23	3295.0
2013-03-20 02:00:00	ES	Futures	1587.23	1589.55	1587.23	1588.78	6916.0
2013-03-20 03:00:00	ES	Futures	1588.78	1593.16	1588.78	1592.64	21919.0
2013-03-20 04:00:00	ES	Futures	1592.39	1595.48	1592.13	1594.45	45827.0
2013-03-20 05:00:00	ES	Futures	1594.45	1595.48	1593.16	1593.93	28422.0
2013-03-20 06:00:00	ES	Futures	1593.67	1596.25	1593.16	1593.93	34347.0
2013-03-20 07:00:00	ES	Futures	1593.93	1594.7	1592.13	1592.64	28728.0
2013-03-20 08:00:00	ES	Futures	1592.64	1599.86	1592.39	1597.54	144091.0
2013-03-20 09:00:00	ES	Futures	1597.54	1600.37	1596.77	1597.28	250161.0
2013-03-20 10:00:00	ES	Futures	1597.28	1599.6	1595.73	1598.83	244644.0
2013-03-20 11:00:00	ES	Futures	1598.83	1599.08	1596.25	1596.77	112220.0
2013-03-20 12:00:00	ES	Futures	1596.77	1598.57	1596.25	1597.8	110188.0
2013-03-20 13:00:00	ES	Futures	1597.8	1598.57	1596.25	1596.77	57103.0
2013-03-20 14:00:00	ES	Futures	1596.51	1602.69	1595.73	1600.11	273754.0
2013-03-20 15:00:00	ES	Futures	1599.86	1602.95	1597.8	1599.6	252647.0
2013-03-20 16:00:00	ES	Futures	1599.6	1599.86	1594.96	1597.28	135351.0
2013-03-20 17:00:00	ES	Futures	1597.28	1597.8	1597.28	1597.54	2504.0
2013-03-20 18:00:00	ES	Futures	1596.51	1597.54	1595.48	1596.77	7827.0
2013-03-20 19:00:00	ES	Futures	1596.77	1597.28	1595.99	1596.51	2915.0
2013-03-20 20:00:00	ES	Futures	1596.51	1597.28	1594.96	1594.96	6338.0
2013-03-20 21:00:00	ES	Futures	1594.96	1597.54	1594.45	1597.54	7884.0
2013-03-20 22:00:00	ES	Futures	1597.54	1597.54	1595.73	1597.02	4118.0
2013-03-20 23:00:00	ES	Futures	1597.02	1597.28	1596.25	1596.77	1399.0
2013-03-20 00:00:00	NQ	Futures	3241.89	3244.51	3241.6	3243.35	228.0
2013-03-20 01:00:00	NQ	Futures	3243.64	3244.22	3241.89	3241.89	205.0
2013-03-20 02:00:00	NQ	Futures	3241.89	3247.43	3241.89	3247.14	577.0
2013-03-20 03:00:00	NQ	Futures	3247.14	3259.97	3247.14	3257.93	4138.0
2013-03-20 04:00:00	NQ	Futures	3257.93	3264.35	3257.35	3260.85	4754.0
2013-03-20 05:00:00	NQ	Futures	3260.85	3262.6	3258.51	3259.39	1376.0
2013-03-20 06:00:00	NQ	Futures	3259.97	3264.35	3258.51	3259.39	1982.0
2013-03-20 07:00:00	NQ	Futures	3259.68	3260.85	3255.89	3257.35	2109.0
2013-03-20 08:00:00	NQ	Futures	3257.06	3271.06	3256.76	3268.14	13936.0
2013-03-20 09:00:00	NQ	Futures	3267.85	3274.26	3258.81	3260.85	40199.0
2013-03-20 10:00:00	NQ	Futures	3260.85	3267.26	3254.14	3260.56	31494.0
2013-03-20 11:00:00	NQ	Futures	3260.56	3261.43	3251.81	3252.39	18614.0
2013-03-20 12:00:00	NQ	Futures	3252.39	3262.6	3251.81	3261.14	16164.0
2013-03-20 13:00:00	NQ	Futures	3260.85	3262.6	3258.51	3259.39	6319.0
2013-03-20 14:00:00	NQ	Futures	3259.1	3271.06	3257.35	3266.68	28176.0
2013-03-20 15:00:00	NQ	Futures	3266.68	3271.64	3262.31	3265.51	24859.0
2013-03-20 16:00:00	NQ	Futures	3265.22	3265.81	3248.31	3252.39	12606.0
2013-03-20 17:00:00	NQ	Futures	3252.39	3253.26	3251.81	3252.68	379.0
2013-03-20 18:00:00	NQ	Futures	3252.97	3252.97	3248.6	3251.22	862.0
2013-03-20 19:00:00	NQ	Futures	3251.22	3251.22	3249.47	3250.35	288.0
2013-03-20 20:00:00	NQ	Futures	3250.06	3250.64	3247.43	3248.01	830.0
2013-03-20 21:00:00	NQ	Futures	3248.01	3252.1	3246.56	3252.1	832.0
2013-03-20 22:00:00	NQ	Futures	3252.1	3252.39	3248.6	3250.35	444.0
2013-03-20 23:00:00	NQ	Futures	3250.35	3250.35	3248.89	3249.76	123.0
2013-03-20 00:00:00	YM	Futures	14534.4	14543.5	14531.3	14541.4	487.0
2013-03-20 01:00:00	YM	Futures	14538.4	14541.4	14531.3	14532.3	547.0

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

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