PREVIEW / futures_1hour / 2014-04-11

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-11.parquet
  size:    43 KB
  rows:    1,271

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
2014-04-11 00:00:00	ES	Futures	1899.75	1900.01	1899.24	1899.49	2296.0
2014-04-11 01:00:00	ES	Futures	1899.49	1899.49	1897.68	1897.94	5478.0
2014-04-11 02:00:00	ES	Futures	1898.2	1900.79	1897.94	1900.01	12218.0
2014-04-11 03:00:00	ES	Futures	1900.01	1902.87	1898.46	1900.27	36810.0
2014-04-11 04:00:00	ES	Futures	1900.01	1900.79	1897.68	1897.68	22885.0
2014-04-11 05:00:00	ES	Futures	1897.68	1899.24	1896.9	1898.98	21863.0
2014-04-11 06:00:00	ES	Futures	1898.72	1898.98	1895.6	1895.6	21281.0
2014-04-11 07:00:00	ES	Futures	1895.86	1896.38	1884.69	1888.59	116429.0
2014-04-11 08:00:00	ES	Futures	1888.59	1893.0	1886.77	1890.41	92928.0
2014-04-11 09:00:00	ES	Futures	1890.15	1894.82	1883.4	1891.7	391581.0
2014-04-11 10:00:00	ES	Futures	1891.7	1898.46	1882.88	1896.12	501057.0
2014-04-11 11:00:00	ES	Futures	1896.38	1899.24	1889.37	1891.19	292394.0
2014-04-11 12:00:00	ES	Futures	1891.19	1894.3	1888.33	1890.67	136950.0
2014-04-11 13:00:00	ES	Futures	1890.67	1890.93	1883.91	1884.95	170954.0
2014-04-11 14:00:00	ES	Futures	1884.95	1887.81	1877.16	1881.84	240798.0
2014-04-11 15:00:00	ES	Futures	1881.84	1886.77	1878.46	1878.98	312558.0
2014-04-11 16:00:00	ES	Futures	1879.24	1882.36	1878.72	1881.32	104007.0
2014-04-11 17:00:00	ES	Futures	1881.32	1881.84	1880.02	1881.58	4947.0
2014-04-11 00:00:00	NQ	Futures	4056.73	4057.89	4055.85	4057.02	458.0
2014-04-11 01:00:00	NQ	Futures	4056.14	4056.44	4051.78	4052.94	725.0
2014-04-11 02:00:00	NQ	Futures	4052.94	4059.06	4052.65	4055.85	1461.0
2014-04-11 03:00:00	NQ	Futures	4056.14	4063.72	4052.36	4056.44	3882.0
2014-04-11 04:00:00	NQ	Futures	4056.14	4057.89	4050.03	4050.03	3121.0
2014-04-11 05:00:00	NQ	Futures	4050.03	4053.52	4047.12	4052.07	3337.0
2014-04-11 06:00:00	NQ	Futures	4052.07	4052.07	4044.2	4044.49	3545.0
2014-04-11 07:00:00	NQ	Futures	4044.49	4045.37	4015.08	4025.27	18020.0
2014-04-11 08:00:00	NQ	Futures	4024.98	4037.21	4020.91	4031.1	20146.0
2014-04-11 09:00:00	NQ	Futures	4030.81	4059.06	4008.09	4047.7	107018.0
2014-04-11 10:00:00	NQ	Futures	4047.99	4069.83	4012.75	4060.51	111886.0
2014-04-11 11:00:00	NQ	Futures	4060.51	4069.83	4040.42	4045.08	59754.0
2014-04-11 12:00:00	NQ	Futures	4045.08	4056.73	4035.76	4046.53	35076.0
2014-04-11 13:00:00	NQ	Futures	4046.53	4047.12	4021.78	4024.11	36066.0
2014-04-11 14:00:00	NQ	Futures	4023.82	4032.26	3997.32	4008.97	48478.0
2014-04-11 15:00:00	NQ	Futures	4008.97	4020.32	3998.77	4006.64	64585.0
2014-04-11 16:00:00	NQ	Futures	4006.64	4013.33	4005.47	4010.71	10536.0
2014-04-11 17:00:00	NQ	Futures	4010.71	4010.71	4007.8	4010.42	153.0
2014-04-11 00:00:00	YM	Futures	16606.5	16608.5	16602.4	16604.4	346.0
2014-04-11 01:00:00	YM	Futures	16603.4	16604.4	16591.0	16594.1	489.0
2014-04-11 02:00:00	YM	Futures	16594.1	16613.7	16593.1	16606.5	1181.0
2014-04-11 03:00:00	YM	Futures	16606.5	16629.1	16593.1	16608.5	4385.0
2014-04-11 04:00:00	YM	Futures	16607.5	16613.7	16585.9	16587.9	2822.0
2014-04-11 05:00:00	YM	Futures	16585.9	16598.2	16579.7	16596.2	2689.0
2014-04-11 06:00:00	YM	Futures	16597.2	16598.2	16573.5	16574.6	2219.0
2014-04-11 07:00:00	YM	Futures	16574.6	16579.7	16491.1	16512.8	12416.0
2014-04-11 08:00:00	YM	Futures	16513.8	16545.7	16502.5	16525.1	9501.0
2014-04-11 09:00:00	YM	Futures	16525.1	16532.3	16458.2	16506.6	41456.0
2014-04-11 10:00:00	YM	Futures	16506.6	16554.0	16444.8	16537.5	46834.0
2014-04-11 11:00:00	YM	Futures	16537.5	16563.2	16488.1	16502.5	27644.0
2014-04-11 12:00:00	YM	Futures	16501.4	16522.0	16485.0	16497.3	15353.0
2014-04-11 13:00:00	YM	Futures	16498.4	16502.5	16438.6	16446.9	15395.0

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

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