PREVIEW / futures_1hour / 2014-04-17

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-17.parquet
  size:    43 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
2014-04-17 00:00:00	ES	Futures	1920.27	1921.05	1920.01	1920.79	1502.0
2014-04-17 01:00:00	ES	Futures	1921.05	1922.35	1920.79	1921.31	3767.0
2014-04-17 02:00:00	ES	Futures	1921.31	1922.09	1919.75	1921.31	7129.0
2014-04-17 03:00:00	ES	Futures	1921.57	1922.09	1919.49	1922.09	21884.0
2014-04-17 04:00:00	ES	Futures	1922.09	1922.61	1920.27	1920.53	14698.0
2014-04-17 05:00:00	ES	Futures	1920.27	1921.05	1919.23	1919.49	12892.0
2014-04-17 06:00:00	ES	Futures	1919.75	1921.31	1918.71	1920.27	14834.0
2014-04-17 07:00:00	ES	Futures	1920.53	1924.68	1920.27	1924.42	19639.0
2014-04-17 08:00:00	ES	Futures	1924.16	1928.84	1923.64	1927.54	49491.0
2014-04-17 09:00:00	ES	Futures	1927.54	1928.32	1921.83	1924.42	244237.0
2014-04-17 10:00:00	ES	Futures	1924.68	1930.66	1922.61	1929.62	241392.0
2014-04-17 11:00:00	ES	Futures	1929.62	1931.17	1925.98	1927.8	124801.0
2014-04-17 12:00:00	ES	Futures	1927.8	1930.66	1926.24	1930.4	77725.0
2014-04-17 13:00:00	ES	Futures	1930.4	1935.33	1929.88	1934.29	108780.0
2014-04-17 14:00:00	ES	Futures	1934.29	1935.07	1931.95	1932.73	61474.0
2014-04-17 15:00:00	ES	Futures	1932.73	1935.85	1929.88	1930.14	147449.0
2014-04-17 16:00:00	ES	Futures	1930.14	1931.43	1928.58	1931.17	70174.0
2014-04-17 17:00:00	ES	Futures	1931.43	1931.43	1928.58	1929.36	2885.0
2014-04-17 00:00:00	NQ	Futures	4069.54	4073.91	4069.54	4073.33	303.0
2014-04-17 01:00:00	NQ	Futures	4073.03	4077.11	4072.74	4073.62	580.0
2014-04-17 02:00:00	NQ	Futures	4073.91	4075.36	4070.12	4074.2	1468.0
2014-04-17 03:00:00	NQ	Futures	4074.49	4077.11	4068.67	4076.24	3315.0
2014-04-17 04:00:00	NQ	Futures	4076.82	4077.69	4074.2	4074.49	1801.0
2014-04-17 05:00:00	NQ	Futures	4074.49	4077.69	4071.58	4073.91	1476.0
2014-04-17 06:00:00	NQ	Futures	4073.62	4074.49	4068.38	4071.87	1846.0
2014-04-17 07:00:00	NQ	Futures	4071.87	4087.89	4071.87	4085.85	3940.0
2014-04-17 08:00:00	NQ	Futures	4085.85	4096.04	4084.1	4091.67	9643.0
2014-04-17 09:00:00	NQ	Futures	4091.96	4108.27	4079.44	4094.0	57848.0
2014-04-17 10:00:00	NQ	Futures	4094.0	4115.84	4088.76	4106.82	62777.0
2014-04-17 11:00:00	NQ	Futures	4107.11	4112.06	4092.26	4101.28	29721.0
2014-04-17 12:00:00	NQ	Futures	4100.99	4111.77	4096.33	4109.44	18121.0
2014-04-17 13:00:00	NQ	Futures	4110.02	4126.62	4108.27	4122.25	21822.0
2014-04-17 14:00:00	NQ	Futures	4121.96	4123.71	4114.39	4117.59	13933.0
2014-04-17 15:00:00	NQ	Futures	4117.59	4123.12	4105.94	4106.53	25782.0
2014-04-17 16:00:00	NQ	Futures	4106.23	4107.69	4101.57	4107.69	8053.0
2014-04-17 17:00:00	NQ	Futures	4107.69	4107.69	4104.2	4105.07	112.0
2014-04-17 00:00:00	YM	Futures	16773.3	16783.6	16773.3	16780.5	320.0
2014-04-17 01:00:00	YM	Futures	16780.5	16790.8	16778.5	16782.6	701.0
2014-04-17 02:00:00	YM	Futures	16785.7	16791.9	16771.3	16784.7	1012.0
2014-04-17 03:00:00	YM	Futures	16786.7	16793.9	16771.3	16792.9	2485.0
2014-04-17 04:00:00	YM	Futures	16792.9	16794.9	16776.4	16777.4	1639.0
2014-04-17 05:00:00	YM	Futures	16776.4	16783.6	16769.2	16772.3	1702.0
2014-04-17 06:00:00	YM	Futures	16774.4	16784.7	16767.1	16778.5	1886.0
2014-04-17 07:00:00	YM	Futures	16779.5	16819.7	16778.5	16807.3	3666.0
2014-04-17 08:00:00	YM	Futures	16807.3	16843.4	16804.2	16834.1	4899.0
2014-04-17 09:00:00	YM	Futures	16834.1	16837.2	16785.7	16803.2	23030.0
2014-04-17 10:00:00	YM	Futures	16805.2	16853.7	16791.9	16847.5	24576.0
2014-04-17 11:00:00	YM	Futures	16848.5	16858.8	16811.4	16820.7	12329.0
2014-04-17 12:00:00	YM	Futures	16820.7	16842.3	16810.4	16834.1	8109.0
2014-04-17 13:00:00	YM	Futures	16835.1	16875.3	16830.0	16866.0	10864.0

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

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