PREVIEW / futures_1hour / 2014-01-02

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-02.parquet
  size:    44 KB
  rows:    1,301

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-01-02 06:00:00	ES	Futures	1901.36	1904.46	1897.74	1902.39	47672.0
2014-01-02 07:00:00	ES	Futures	1902.39	1902.65	1899.03	1899.29	23792.0
2014-01-02 08:00:00	ES	Futures	1899.55	1902.91	1899.03	1900.07	26367.0
2014-01-02 09:00:00	ES	Futures	1900.07	1901.62	1893.6	1896.19	231392.0
2014-01-02 10:00:00	ES	Futures	1896.45	1897.48	1891.53	1895.67	184727.0
2014-01-02 11:00:00	ES	Futures	1895.41	1896.7	1888.69	1890.5	144514.0
2014-01-02 12:00:00	ES	Futures	1890.76	1891.79	1887.39	1890.5	117491.0
2014-01-02 13:00:00	ES	Futures	1890.5	1891.27	1887.39	1889.98	86089.0
2014-01-02 14:00:00	ES	Futures	1889.98	1891.27	1884.81	1887.91	116576.0
2014-01-02 15:00:00	ES	Futures	1887.65	1892.57	1887.39	1889.46	173973.0
2014-01-02 16:00:00	ES	Futures	1889.46	1891.27	1889.2	1889.98	65287.0
2014-01-02 17:00:00	ES	Futures	1889.98	1890.24	1889.72	1889.72	1432.0
2014-01-02 18:00:00	ES	Futures	1890.5	1891.27	1890.24	1891.27	2584.0
2014-01-02 19:00:00	ES	Futures	1891.01	1891.53	1890.5	1891.27	1865.0
2014-01-02 20:00:00	ES	Futures	1891.27	1892.82	1890.76	1891.01	4996.0
2014-01-02 21:00:00	ES	Futures	1891.01	1891.27	1889.2	1889.72	4318.0
2014-01-02 22:00:00	ES	Futures	1889.72	1889.72	1888.94	1889.46	1805.0
2014-01-02 23:00:00	ES	Futures	1889.46	1889.98	1888.43	1888.69	1609.0
2014-01-02 06:00:00	NQ	Futures	4157.66	4161.44	4148.94	4156.21	5818.0
2014-01-02 07:00:00	NQ	Futures	4155.92	4158.54	4152.43	4153.3	2374.0
2014-01-02 08:00:00	NQ	Futures	4152.72	4159.41	4151.85	4153.3	4173.0
2014-01-02 09:00:00	NQ	Futures	4153.59	4156.5	4133.25	4135.57	46032.0
2014-01-02 10:00:00	NQ	Futures	4134.7	4145.16	4130.34	4140.51	37055.0
2014-01-02 11:00:00	NQ	Futures	4140.8	4147.78	4132.66	4134.99	23282.0
2014-01-02 12:00:00	NQ	Futures	4135.28	4140.22	4132.37	4139.93	13857.0
2014-01-02 13:00:00	NQ	Futures	4139.93	4140.8	4129.47	4137.9	16805.0
2014-01-02 14:00:00	NQ	Futures	4137.9	4139.64	4126.56	4132.66	16766.0
2014-01-02 15:00:00	NQ	Futures	4132.66	4141.68	4132.66	4139.06	25800.0
2014-01-02 16:00:00	NQ	Futures	4139.06	4142.55	4137.9	4139.64	4538.0
2014-01-02 17:00:00	NQ	Futures	4139.93	4140.8	4139.64	4140.8	59.0
2014-01-02 18:00:00	NQ	Futures	4139.64	4142.84	4139.35	4140.22	469.0
2014-01-02 19:00:00	NQ	Futures	4140.22	4141.39	4138.77	4141.09	347.0
2014-01-02 20:00:00	NQ	Futures	4140.8	4143.13	4139.35	4139.64	917.0
2014-01-02 21:00:00	NQ	Futures	4139.35	4139.93	4136.15	4137.9	867.0
2014-01-02 22:00:00	NQ	Futures	4137.61	4137.9	4136.44	4136.73	305.0
2014-01-02 23:00:00	NQ	Futures	4137.03	4138.48	4135.86	4135.86	224.0
2014-01-02 06:00:00	YM	Futures	16891.5	16914.0	16853.5	16897.6	4686.0
2014-01-02 07:00:00	YM	Futures	16897.6	16900.7	16864.8	16868.9	2585.0
2014-01-02 08:00:00	YM	Futures	16868.9	16893.5	16866.9	16868.9	2378.0
2014-01-02 09:00:00	YM	Futures	16869.9	16891.5	16825.8	16852.5	22734.0
2014-01-02 10:00:00	YM	Futures	16851.5	16864.8	16807.4	16841.2	15856.0
2014-01-02 11:00:00	YM	Futures	16841.2	16855.6	16795.1	16809.4	10750.0
2014-01-02 12:00:00	YM	Futures	16810.5	16819.7	16781.7	16806.4	7896.0
2014-01-02 13:00:00	YM	Futures	16806.4	16815.6	16783.8	16809.4	6882.0
2014-01-02 14:00:00	YM	Futures	16809.4	16821.7	16768.4	16786.9	9210.0
2014-01-02 15:00:00	YM	Futures	16786.9	16823.8	16784.8	16796.1	12482.0
2014-01-02 16:00:00	YM	Futures	16796.1	16811.5	16795.1	16805.3	2239.0
2014-01-02 17:00:00	YM	Futures	16804.3	16808.4	16804.3	16807.4	89.0
2014-01-02 18:00:00	YM	Futures	16807.4	16814.6	16806.4	16813.5	312.0
2014-01-02 19:00:00	YM	Futures	16815.6	16816.6	16808.4	16814.6	267.0

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

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