PREVIEW / futures_1hour / 2013-04-19

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-19.parquet
  size:    42 KB
  rows:    1,263

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-19 00:00:00	ES	Futures	1587.49	1588.01	1586.98	1587.23	2112.0
2013-04-19 01:00:00	ES	Futures	1586.98	1589.3	1586.98	1588.52	6474.0
2013-04-19 02:00:00	ES	Futures	1588.27	1590.58	1588.27	1589.55	16955.0
2013-04-19 03:00:00	ES	Futures	1589.3	1590.07	1586.98	1589.81	32371.0
2013-04-19 04:00:00	ES	Futures	1589.81	1591.61	1589.04	1591.36	27190.0
2013-04-19 05:00:00	ES	Futures	1591.1	1592.39	1589.55	1591.1	22941.0
2013-04-19 06:00:00	ES	Futures	1590.84	1592.64	1590.58	1591.36	22401.0
2013-04-19 07:00:00	ES	Futures	1591.36	1591.61	1588.78	1590.33	29237.0
2013-04-19 08:00:00	ES	Futures	1590.33	1591.1	1585.17	1587.23	76210.0
2013-04-19 09:00:00	ES	Futures	1587.23	1589.55	1582.86	1586.46	297235.0
2013-04-19 10:00:00	ES	Futures	1586.46	1591.61	1586.2	1590.58	330336.0
2013-04-19 11:00:00	ES	Futures	1590.84	1597.02	1589.81	1595.22	260758.0
2013-04-19 12:00:00	ES	Futures	1595.22	1596.25	1591.36	1592.39	142258.0
2013-04-19 13:00:00	ES	Futures	1592.39	1594.7	1590.84	1593.16	92802.0
2013-04-19 14:00:00	ES	Futures	1593.42	1596.25	1592.39	1593.42	122540.0
2013-04-19 15:00:00	ES	Futures	1593.42	1597.8	1592.13	1596.25	225787.0
2013-04-19 16:00:00	ES	Futures	1596.51	1597.28	1593.93	1595.22	97980.0
2013-04-19 17:00:00	ES	Futures	1595.48	1595.73	1594.96	1595.48	2267.0
2013-04-19 00:00:00	NQ	Futures	3210.1	3211.56	3210.1	3210.39	216.0
2013-04-19 01:00:00	NQ	Futures	3210.39	3214.47	3210.1	3213.89	439.0
2013-04-19 02:00:00	NQ	Futures	3213.31	3216.81	3213.01	3215.06	1328.0
2013-04-19 03:00:00	NQ	Futures	3215.06	3215.35	3209.51	3215.06	4319.0
2013-04-19 04:00:00	NQ	Futures	3215.35	3217.97	3212.72	3217.39	2075.0
2013-04-19 05:00:00	NQ	Futures	3217.39	3218.56	3210.68	3215.93	3610.0
2013-04-19 06:00:00	NQ	Futures	3216.22	3218.56	3215.35	3217.1	2612.0
2013-04-19 07:00:00	NQ	Futures	3217.1	3217.97	3213.6	3215.06	3924.0
2013-04-19 08:00:00	NQ	Futures	3215.35	3219.43	3206.89	3209.51	8438.0
2013-04-19 09:00:00	NQ	Futures	3209.51	3213.31	3192.89	3211.56	63330.0
2013-04-19 10:00:00	NQ	Futures	3211.85	3228.18	3211.26	3227.01	54747.0
2013-04-19 11:00:00	NQ	Futures	3227.01	3242.76	3224.39	3236.64	35146.0
2013-04-19 12:00:00	NQ	Futures	3236.35	3239.26	3229.06	3231.39	17370.0
2013-04-19 13:00:00	NQ	Futures	3231.1	3234.89	3226.43	3231.39	13529.0
2013-04-19 14:00:00	NQ	Futures	3231.39	3241.89	3230.81	3231.1	19715.0
2013-04-19 15:00:00	NQ	Futures	3231.1	3239.85	3228.47	3234.89	31169.0
2013-04-19 16:00:00	NQ	Futures	3235.18	3236.93	3230.22	3233.72	6453.0
2013-04-19 17:00:00	NQ	Futures	3233.72	3234.31	3233.43	3233.43	129.0
2013-04-19 00:00:00	YM	Futures	14622.3	14627.4	14620.3	14623.3	263.0
2013-04-19 01:00:00	YM	Futures	14623.3	14634.4	14622.3	14631.4	561.0
2013-04-19 02:00:00	YM	Futures	14632.4	14646.6	14631.4	14640.5	1553.0
2013-04-19 03:00:00	YM	Futures	14641.5	14651.6	14625.3	14648.6	3276.0
2013-04-19 04:00:00	YM	Futures	14648.6	14657.7	14635.5	14652.6	2689.0
2013-04-19 05:00:00	YM	Futures	14652.6	14663.8	14640.5	14652.6	2907.0
2013-04-19 06:00:00	YM	Futures	14653.6	14663.8	14648.6	14656.7	2035.0
2013-04-19 07:00:00	YM	Futures	14656.7	14658.7	14624.3	14627.4	3555.0
2013-04-19 08:00:00	YM	Futures	14626.4	14634.4	14590.0	14603.1	8005.0
2013-04-19 09:00:00	YM	Futures	14602.1	14614.2	14564.7	14581.9	26476.0
2013-04-19 10:00:00	YM	Futures	14581.9	14612.2	14566.7	14591.0	30219.0
2013-04-19 11:00:00	YM	Futures	14591.0	14636.5	14588.9	14620.3	19263.0
2013-04-19 12:00:00	YM	Futures	14621.3	14629.4	14593.0	14600.1	10111.0
2013-04-19 13:00:00	YM	Futures	14599.1	14621.3	14590.0	14608.2	8608.0

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

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