PREVIEW / futures_1hour / 2013-08-02

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-02.parquet
  size:    43 KB
  rows:    1,247

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-08-02 00:00:00	ES	Futures	1759.06	1759.83	1758.54	1759.57	1649.0
2013-08-02 01:00:00	ES	Futures	1759.57	1761.13	1759.06	1761.13	5580.0
2013-08-02 02:00:00	ES	Futures	1760.87	1761.13	1759.83	1760.61	5891.0
2013-08-02 03:00:00	ES	Futures	1760.87	1760.87	1758.28	1759.32	19568.0
2013-08-02 04:00:00	ES	Futures	1759.32	1760.35	1758.8	1759.32	11164.0
2013-08-02 05:00:00	ES	Futures	1759.32	1759.57	1758.02	1758.54	12698.0
2013-08-02 06:00:00	ES	Futures	1758.54	1760.61	1758.28	1759.32	10254.0
2013-08-02 07:00:00	ES	Futures	1759.32	1760.61	1759.06	1759.83	12679.0
2013-08-02 08:00:00	ES	Futures	1759.57	1761.64	1753.63	1755.96	122985.0
2013-08-02 09:00:00	ES	Futures	1755.96	1758.02	1753.37	1755.18	201094.0
2013-08-02 10:00:00	ES	Futures	1755.44	1758.54	1754.15	1755.44	182287.0
2013-08-02 11:00:00	ES	Futures	1755.44	1758.28	1754.15	1757.51	124895.0
2013-08-02 12:00:00	ES	Futures	1757.51	1760.09	1757.25	1759.32	82182.0
2013-08-02 13:00:00	ES	Futures	1759.32	1760.61	1757.76	1758.28	89063.0
2013-08-02 14:00:00	ES	Futures	1758.28	1760.35	1757.51	1759.32	70018.0
2013-08-02 15:00:00	ES	Futures	1759.57	1762.93	1758.8	1762.42	168221.0
2013-08-02 16:00:00	ES	Futures	1762.42	1762.93	1761.13	1761.13	70059.0
2013-08-02 17:00:00	ES	Futures	1761.38	1761.64	1761.13	1761.13	1595.0
2013-08-02 00:00:00	NQ	Futures	3644.77	3647.4	3643.89	3646.23	369.0
2013-08-02 01:00:00	NQ	Futures	3646.52	3648.86	3645.93	3648.56	539.0
2013-08-02 02:00:00	NQ	Futures	3648.27	3649.15	3646.81	3647.98	616.0
2013-08-02 03:00:00	NQ	Futures	3648.27	3648.27	3643.6	3645.06	2493.0
2013-08-02 04:00:00	NQ	Futures	3645.06	3647.69	3643.89	3645.35	1860.0
2013-08-02 05:00:00	NQ	Futures	3645.64	3646.23	3643.89	3645.35	1441.0
2013-08-02 06:00:00	NQ	Futures	3645.35	3648.27	3645.06	3646.52	1756.0
2013-08-02 07:00:00	NQ	Futures	3646.23	3648.56	3645.93	3647.1	2091.0
2013-08-02 08:00:00	NQ	Futures	3647.1	3654.99	3641.84	3647.4	15690.0
2013-08-02 09:00:00	NQ	Futures	3647.1	3650.32	3638.04	3642.14	28237.0
2013-08-02 10:00:00	NQ	Futures	3642.43	3652.95	3640.09	3644.77	24756.0
2013-08-02 11:00:00	NQ	Futures	3645.06	3650.9	3642.72	3650.03	15341.0
2013-08-02 12:00:00	NQ	Futures	3650.03	3654.41	3649.44	3654.41	9947.0
2013-08-02 13:00:00	NQ	Futures	3654.41	3659.09	3652.36	3654.7	15607.0
2013-08-02 14:00:00	NQ	Futures	3654.99	3659.09	3653.82	3657.92	9231.0
2013-08-02 15:00:00	NQ	Futures	3657.92	3666.39	3657.33	3665.81	23209.0
2013-08-02 16:00:00	NQ	Futures	3665.81	3668.14	3664.93	3666.39	6722.0
2013-08-02 17:00:00	NQ	Futures	3666.1	3666.98	3665.81	3665.81	177.0
2013-08-02 00:00:00	YM	Futures	15807.0	15814.2	15804.0	15810.1	353.0
2013-08-02 01:00:00	YM	Futures	15811.1	15823.3	15808.1	15823.3	954.0
2013-08-02 02:00:00	YM	Futures	15822.3	15825.3	15814.2	15821.3	694.0
2013-08-02 03:00:00	YM	Futures	15818.2	15820.3	15802.0	15808.1	2051.0
2013-08-02 04:00:00	YM	Futures	15808.1	15818.2	15803.0	15809.1	1180.0
2013-08-02 05:00:00	YM	Futures	15808.1	15811.1	15801.0	15806.0	800.0
2013-08-02 06:00:00	YM	Futures	15806.0	15817.2	15804.0	15808.1	736.0
2013-08-02 07:00:00	YM	Futures	15808.1	15814.2	15807.0	15809.1	1207.0
2013-08-02 08:00:00	YM	Futures	15809.1	15819.2	15764.4	15771.5	9284.0
2013-08-02 09:00:00	YM	Futures	15772.5	15785.7	15739.0	15758.3	18840.0
2013-08-02 10:00:00	YM	Futures	15759.3	15789.8	15753.2	15755.2	13782.0
2013-08-02 11:00:00	YM	Futures	15756.3	15791.8	15746.1	15788.8	9920.0
2013-08-02 12:00:00	YM	Futures	15788.8	15805.0	15786.7	15797.9	6289.0
2013-08-02 13:00:00	YM	Futures	15796.9	15811.1	15786.7	15797.9	6611.0

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

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