PREVIEW / futures_1hour / 2013-03-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	1596.51	1597.02	1595.22	1595.48	1875.0
2013-03-21 01:00:00	ES	Futures	1595.48	1596.77	1594.96	1595.22	3421.0
2013-03-21 02:00:00	ES	Futures	1594.96	1596.25	1594.7	1594.96	3077.0
2013-03-21 03:00:00	ES	Futures	1594.96	1597.8	1594.96	1596.51	7886.0
2013-03-21 04:00:00	ES	Futures	1596.51	1597.8	1592.39	1593.42	46986.0
2013-03-21 05:00:00	ES	Futures	1593.42	1595.73	1592.64	1594.45	31659.0
2013-03-21 06:00:00	ES	Futures	1594.45	1595.22	1592.64	1594.7	22187.0
2013-03-21 07:00:00	ES	Futures	1594.7	1596.77	1594.7	1595.99	30063.0
2013-03-21 08:00:00	ES	Futures	1595.99	1597.54	1594.45	1594.7	39353.0
2013-03-21 09:00:00	ES	Futures	1594.45	1595.73	1589.81	1593.93	227118.0
2013-03-21 10:00:00	ES	Futures	1593.93	1594.96	1588.27	1591.36	296204.0
2013-03-21 11:00:00	ES	Futures	1591.36	1595.99	1589.3	1594.45	195059.0
2013-03-21 12:00:00	ES	Futures	1594.19	1594.96	1591.87	1592.9	104808.0
2013-03-21 13:00:00	ES	Futures	1592.64	1593.93	1586.98	1588.01	232980.0
2013-03-21 14:00:00	ES	Futures	1588.01	1590.33	1583.11	1589.3	291283.0
2013-03-21 15:00:00	ES	Futures	1589.3	1591.36	1585.43	1585.95	238894.0
2013-03-21 16:00:00	ES	Futures	1585.95	1586.98	1585.17	1585.95	97014.0
2013-03-21 17:00:00	ES	Futures	1586.2	1586.2	1585.17	1585.69	3481.0
2013-03-21 18:00:00	ES	Futures	1585.17	1585.69	1584.14	1584.66	6490.0
2013-03-21 19:00:00	ES	Futures	1584.66	1585.69	1584.4	1585.43	3376.0
2013-03-21 20:00:00	ES	Futures	1585.69	1585.69	1584.4	1585.69	6066.0
2013-03-21 21:00:00	ES	Futures	1585.43	1586.46	1584.92	1586.2	5374.0
2013-03-21 22:00:00	ES	Futures	1586.2	1586.72	1585.17	1585.95	3332.0
2013-03-21 23:00:00	ES	Futures	1585.95	1586.46	1585.69	1586.2	1656.0
2013-03-21 00:00:00	NQ	Futures	3249.47	3250.64	3247.43	3247.43	145.0
2013-03-21 01:00:00	NQ	Futures	3247.14	3249.47	3246.85	3247.43	267.0
2013-03-21 02:00:00	NQ	Futures	3247.43	3249.47	3247.14	3247.14	239.0
2013-03-21 03:00:00	NQ	Futures	3247.43	3251.22	3247.43	3249.47	743.0
2013-03-21 04:00:00	NQ	Futures	3249.47	3252.68	3239.26	3241.6	4348.0
2013-03-21 05:00:00	NQ	Futures	3241.31	3244.22	3239.56	3242.76	2416.0
2013-03-21 06:00:00	NQ	Futures	3242.76	3244.51	3240.43	3244.22	1283.0
2013-03-21 07:00:00	NQ	Futures	3244.22	3248.89	3244.22	3247.14	2352.0
2013-03-21 08:00:00	NQ	Futures	3247.43	3247.72	3240.72	3241.01	4674.0
2013-03-21 09:00:00	NQ	Futures	3241.01	3243.64	3234.6	3241.89	29692.0
2013-03-21 10:00:00	NQ	Futures	3241.89	3243.35	3228.76	3233.72	39111.0
2013-03-21 11:00:00	NQ	Futures	3233.72	3243.35	3229.93	3240.72	23526.0
2013-03-21 12:00:00	NQ	Futures	3241.01	3244.51	3235.76	3241.89	15941.0
2013-03-21 13:00:00	NQ	Futures	3241.89	3243.93	3229.93	3232.26	24624.0
2013-03-21 14:00:00	NQ	Futures	3232.26	3235.18	3221.47	3234.31	32732.0
2013-03-21 15:00:00	NQ	Futures	3234.6	3238.97	3228.76	3229.35	28760.0
2013-03-21 16:00:00	NQ	Futures	3229.35	3234.01	3228.47	3232.26	6661.0
2013-03-21 17:00:00	NQ	Futures	3231.97	3232.56	3230.81	3230.81	316.0
2013-03-21 18:00:00	NQ	Futures	3230.81	3231.1	3229.06	3229.35	490.0
2013-03-21 19:00:00	NQ	Futures	3229.35	3230.81	3229.06	3230.81	133.0
2013-03-21 20:00:00	NQ	Futures	3230.81	3231.39	3228.47	3230.81	353.0
2013-03-21 21:00:00	NQ	Futures	3231.1	3232.26	3230.22	3231.39	440.0
2013-03-21 22:00:00	NQ	Futures	3231.97	3232.56	3230.81	3231.68	197.0
2013-03-21 23:00:00	NQ	Futures	3231.97	3232.56	3231.68	3232.26	66.0
2013-03-21 00:00:00	YM	Futures	14580.9	14584.9	14571.8	14571.8	468.0
2013-03-21 01:00:00	YM	Futures	14570.8	14579.8	14566.7	14566.7	520.0

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

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