PREVIEW / futures_1hour / 2014-04-25

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-25.parquet
  size:    41 KB
  rows:    1,250

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-25 00:00:00	ES	Futures	1944.42	1944.68	1943.9	1943.9	1404.0
2014-04-25 01:00:00	ES	Futures	1943.9	1945.46	1943.64	1945.2	1438.0
2014-04-25 02:00:00	ES	Futures	1945.2	1945.98	1943.12	1943.12	6979.0
2014-04-25 03:00:00	ES	Futures	1943.38	1945.46	1941.04	1943.38	26303.0
2014-04-25 04:00:00	ES	Futures	1943.38	1944.16	1941.82	1943.64	18259.0
2014-04-25 05:00:00	ES	Futures	1943.64	1943.9	1941.82	1942.86	15130.0
2014-04-25 06:00:00	ES	Futures	1942.86	1943.64	1938.96	1938.96	27550.0
2014-04-25 07:00:00	ES	Futures	1939.22	1940.52	1937.93	1940.0	26658.0
2014-04-25 08:00:00	ES	Futures	1940.0	1941.04	1938.45	1941.04	31590.0
2014-04-25 09:00:00	ES	Futures	1941.04	1941.04	1934.03	1935.07	242281.0
2014-04-25 10:00:00	ES	Futures	1935.07	1938.19	1929.36	1929.88	301352.0
2014-04-25 11:00:00	ES	Futures	1929.88	1934.81	1926.76	1932.99	219458.0
2014-04-25 12:00:00	ES	Futures	1932.99	1935.07	1930.91	1931.69	81240.0
2014-04-25 13:00:00	ES	Futures	1931.69	1931.69	1928.06	1929.88	89385.0
2014-04-25 14:00:00	ES	Futures	1929.88	1930.4	1924.68	1927.54	140740.0
2014-04-25 15:00:00	ES	Futures	1927.54	1932.47	1926.5	1929.62	188483.0
2014-04-25 16:00:00	ES	Futures	1929.62	1932.73	1929.1	1931.95	72126.0
2014-04-25 17:00:00	ES	Futures	1932.21	1932.73	1931.69	1932.21	2438.0
2014-04-25 00:00:00	NQ	Futures	4176.13	4177.58	4174.67	4175.25	271.0
2014-04-25 01:00:00	NQ	Futures	4175.25	4178.75	4175.25	4177.58	318.0
2014-04-25 02:00:00	NQ	Futures	4177.58	4179.33	4170.89	4172.05	1594.0
2014-04-25 03:00:00	NQ	Futures	4172.34	4177.87	4166.52	4171.47	4609.0
2014-04-25 04:00:00	NQ	Futures	4171.47	4173.22	4167.1	4171.18	2833.0
2014-04-25 05:00:00	NQ	Futures	4171.47	4172.05	4167.1	4168.26	2399.0
2014-04-25 06:00:00	NQ	Futures	4168.56	4171.76	4155.74	4156.91	4511.0
2014-04-25 07:00:00	NQ	Futures	4156.91	4162.73	4153.41	4161.57	6577.0
2014-04-25 08:00:00	NQ	Futures	4161.86	4161.86	4150.5	4156.91	8584.0
2014-04-25 09:00:00	NQ	Futures	4156.91	4157.2	4133.32	4135.65	54140.0
2014-04-25 10:00:00	NQ	Futures	4135.36	4136.52	4103.61	4107.69	73790.0
2014-04-25 11:00:00	NQ	Futures	4107.69	4126.04	4098.37	4118.76	49292.0
2014-04-25 12:00:00	NQ	Futures	4118.76	4126.04	4111.48	4114.39	22767.0
2014-04-25 13:00:00	NQ	Futures	4114.39	4116.72	4105.65	4110.6	19826.0
2014-04-25 14:00:00	NQ	Futures	4110.6	4111.48	4096.33	4104.49	30435.0
2014-04-25 15:00:00	NQ	Futures	4104.49	4114.68	4101.28	4105.65	37549.0
2014-04-25 16:00:00	NQ	Futures	4105.07	4114.1	4105.07	4111.77	7120.0
2014-04-25 17:00:00	NQ	Futures	4112.06	4113.22	4111.18	4113.22	181.0
2014-04-25 00:00:00	YM	Futures	16888.7	16891.8	16883.5	16884.5	312.0
2014-04-25 01:00:00	YM	Futures	16884.5	16899.0	16883.5	16895.9	576.0
2014-04-25 02:00:00	YM	Futures	16896.9	16904.1	16886.6	16886.6	1459.0
2014-04-25 03:00:00	YM	Futures	16887.6	16904.1	16867.0	16884.5	3957.0
2014-04-25 04:00:00	YM	Futures	16885.6	16896.9	16874.2	16891.8	2780.0
2014-04-25 05:00:00	YM	Futures	16892.8	16895.9	16879.4	16885.6	2082.0
2014-04-25 06:00:00	YM	Futures	16886.6	16895.9	16856.7	16856.7	3153.0
2014-04-25 07:00:00	YM	Futures	16856.7	16864.0	16846.4	16860.9	4106.0
2014-04-25 08:00:00	YM	Futures	16859.8	16877.3	16849.5	16876.3	3859.0
2014-04-25 09:00:00	YM	Futures	16876.3	16877.3	16797.0	16808.3	28969.0
2014-04-25 10:00:00	YM	Futures	16809.4	16834.1	16773.3	16775.4	28826.0
2014-04-25 11:00:00	YM	Futures	16776.4	16810.4	16756.8	16804.2	20786.0
2014-04-25 12:00:00	YM	Futures	16803.2	16819.7	16787.7	16794.9	9556.0
2014-04-25 13:00:00	YM	Futures	16794.9	16794.9	16766.1	16780.5	9142.0

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

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