PREVIEW / futures_1hour / 2013-03-18

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-18.parquet
  size:    49 KB
  rows:    1,507

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-18 00:00:00	ES	Futures	1580.02	1580.28	1577.45	1577.45	15944.0
2013-03-18 01:00:00	ES	Futures	1577.45	1578.48	1575.9	1578.22	19899.0
2013-03-18 02:00:00	ES	Futures	1577.96	1579.25	1576.16	1576.16	12657.0
2013-03-18 03:00:00	ES	Futures	1576.42	1582.86	1575.9	1582.34	33768.0
2013-03-18 04:00:00	ES	Futures	1582.34	1586.2	1582.08	1585.43	53921.0
2013-03-18 05:00:00	ES	Futures	1585.43	1588.52	1584.66	1588.01	41705.0
2013-03-18 06:00:00	ES	Futures	1588.27	1588.52	1584.14	1584.92	40179.0
2013-03-18 07:00:00	ES	Futures	1585.17	1587.75	1584.92	1587.23	36998.0
2013-03-18 08:00:00	ES	Futures	1587.23	1589.81	1586.46	1587.75	69706.0
2013-03-18 09:00:00	ES	Futures	1587.75	1591.36	1584.4	1590.84	275839.0
2013-03-18 10:00:00	ES	Futures	1590.58	1594.45	1589.55	1592.13	331602.0
2013-03-18 11:00:00	ES	Futures	1592.39	1595.73	1591.87	1595.73	159365.0
2013-03-18 12:00:00	ES	Futures	1595.73	1599.34	1595.48	1597.28	232199.0
2013-03-18 13:00:00	ES	Futures	1597.28	1597.8	1594.7	1594.96	107053.0
2013-03-18 14:00:00	ES	Futures	1594.96	1599.6	1594.45	1595.73	154639.0
2013-03-18 15:00:00	ES	Futures	1595.73	1597.8	1590.33	1592.39	328802.0
2013-03-18 16:00:00	ES	Futures	1592.64	1595.73	1591.87	1594.7	112308.0
2013-03-18 17:00:00	ES	Futures	1594.96	1594.96	1594.19	1594.7	2473.0
2013-03-18 18:00:00	ES	Futures	1594.19	1594.7	1593.42	1594.45	4482.0
2013-03-18 19:00:00	ES	Futures	1594.45	1594.96	1593.42	1594.45	2630.0
2013-03-18 20:00:00	ES	Futures	1594.7	1597.54	1593.93	1597.54	9845.0
2013-03-18 21:00:00	ES	Futures	1597.28	1597.54	1596.25	1597.28	5033.0
2013-03-18 22:00:00	ES	Futures	1597.02	1597.8	1595.22	1595.99	6139.0
2013-03-18 23:00:00	ES	Futures	1595.73	1595.99	1595.22	1595.73	3887.0
2013-03-18 00:00:00	NQ	Futures	3216.22	3217.39	3211.56	3211.56	633.0
2013-03-18 01:00:00	NQ	Futures	3211.85	3212.43	3206.31	3209.81	1748.0
2013-03-18 02:00:00	NQ	Futures	3210.1	3212.43	3206.6	3206.89	1060.0
2013-03-18 03:00:00	NQ	Futures	3207.18	3216.81	3206.89	3215.93	3479.0
2013-03-18 04:00:00	NQ	Futures	3216.22	3220.89	3215.64	3220.6	3913.0
2013-03-18 05:00:00	NQ	Futures	3220.6	3225.56	3219.43	3224.68	2859.0
2013-03-18 06:00:00	NQ	Futures	3224.68	3225.26	3218.56	3220.89	3069.0
2013-03-18 07:00:00	NQ	Futures	3220.89	3229.64	3220.6	3229.06	3781.0
2013-03-18 08:00:00	NQ	Futures	3229.06	3235.47	3229.06	3230.22	10770.0
2013-03-18 09:00:00	NQ	Futures	3229.93	3239.56	3219.72	3238.39	41748.0
2013-03-18 10:00:00	NQ	Futures	3237.81	3250.64	3236.64	3244.51	47109.0
2013-03-18 11:00:00	NQ	Futures	3244.51	3252.97	3243.64	3252.68	19349.0
2013-03-18 12:00:00	NQ	Futures	3252.68	3262.31	3252.68	3255.01	25568.0
2013-03-18 13:00:00	NQ	Futures	3255.01	3259.68	3251.81	3252.1	13854.0
2013-03-18 14:00:00	NQ	Futures	3252.1	3263.47	3251.22	3255.89	22722.0
2013-03-18 15:00:00	NQ	Futures	3255.89	3259.97	3244.81	3249.47	42700.0
2013-03-18 16:00:00	NQ	Futures	3249.47	3256.47	3248.89	3252.97	5819.0
2013-03-18 17:00:00	NQ	Futures	3253.56	3253.85	3251.81	3251.81	144.0
2013-03-18 18:00:00	NQ	Futures	3251.81	3253.56	3250.93	3252.39	183.0
2013-03-18 19:00:00	NQ	Futures	3252.39	3253.56	3251.51	3252.97	162.0
2013-03-18 20:00:00	NQ	Futures	3252.97	3259.68	3252.68	3259.1	617.0
2013-03-18 21:00:00	NQ	Futures	3258.81	3259.68	3257.93	3259.68	386.0
2013-03-18 22:00:00	NQ	Futures	3259.97	3260.56	3256.47	3257.64	355.0
2013-03-18 23:00:00	NQ	Futures	3257.64	3258.51	3256.76	3257.93	154.0
2013-03-18 00:00:00	YM	Futures	14456.5	14460.6	14438.3	14438.3	1185.0
2013-03-18 01:00:00	YM	Futures	14438.3	14445.4	14426.2	14444.4	1374.0

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

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