PREVIEW / futures_1hour / 2013-11-05

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-05.parquet
  size:    49 KB
  rows:    1,525

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-11-05 00:00:00	ES	Futures	1818.36	1819.65	1818.11	1819.65	2242.0
2013-11-05 01:00:00	ES	Futures	1819.39	1819.91	1819.14	1819.91	1781.0
2013-11-05 02:00:00	ES	Futures	1819.91	1820.17	1818.88	1819.65	7488.0
2013-11-05 03:00:00	ES	Futures	1819.65	1819.91	1816.04	1816.82	15762.0
2013-11-05 04:00:00	ES	Futures	1816.56	1817.33	1813.2	1813.98	19629.0
2013-11-05 05:00:00	ES	Futures	1813.72	1815.27	1813.2	1813.98	11940.0
2013-11-05 06:00:00	ES	Futures	1813.98	1815.53	1813.2	1813.72	16394.0
2013-11-05 07:00:00	ES	Futures	1813.72	1814.49	1812.69	1813.98	16800.0
2013-11-05 08:00:00	ES	Futures	1813.98	1814.75	1811.14	1811.91	40786.0
2013-11-05 09:00:00	ES	Futures	1811.91	1813.2	1807.27	1808.82	239544.0
2013-11-05 10:00:00	ES	Futures	1808.82	1815.01	1806.24	1814.24	298368.0
2013-11-05 11:00:00	ES	Futures	1814.24	1815.78	1812.95	1815.27	151375.0
2013-11-05 12:00:00	ES	Futures	1815.27	1818.36	1814.75	1816.3	121038.0
2013-11-05 13:00:00	ES	Futures	1816.3	1817.85	1814.24	1814.49	87948.0
2013-11-05 14:00:00	ES	Futures	1814.49	1818.11	1814.24	1816.56	81731.0
2013-11-05 15:00:00	ES	Futures	1816.56	1818.11	1813.2	1813.72	234523.0
2013-11-05 16:00:00	ES	Futures	1813.98	1815.01	1812.17	1813.2	96624.0
2013-11-05 17:00:00	ES	Futures	1813.2	1813.46	1812.69	1812.95	2908.0
2013-11-05 18:00:00	ES	Futures	1813.2	1813.72	1811.66	1812.69	3585.0
2013-11-05 19:00:00	ES	Futures	1812.69	1815.53	1812.69	1814.49	4028.0
2013-11-05 20:00:00	ES	Futures	1814.49	1816.82	1814.24	1815.53	7269.0
2013-11-05 21:00:00	ES	Futures	1815.53	1816.82	1815.27	1816.3	2243.0
2013-11-05 22:00:00	ES	Futures	1816.56	1819.91	1815.53	1819.39	9777.0
2013-11-05 23:00:00	ES	Futures	1819.39	1823.78	1818.88	1821.46	16879.0
2013-11-05 00:00:00	NQ	Futures	3922.29	3925.2	3922.0	3924.9	412.0
2013-11-05 01:00:00	NQ	Futures	3924.9	3925.2	3923.74	3924.32	193.0
2013-11-05 02:00:00	NQ	Futures	3924.03	3924.9	3922.29	3924.03	700.0
2013-11-05 03:00:00	NQ	Futures	3923.74	3923.74	3917.06	3917.93	1750.0
2013-11-05 04:00:00	NQ	Futures	3917.93	3919.1	3909.22	3910.38	3247.0
2013-11-05 05:00:00	NQ	Futures	3910.38	3913.29	3909.22	3911.25	2376.0
2013-11-05 06:00:00	NQ	Futures	3911.25	3914.16	3910.09	3911.25	2024.0
2013-11-05 07:00:00	NQ	Futures	3911.25	3913.0	3909.51	3911.84	1914.0
2013-11-05 08:00:00	NQ	Futures	3911.84	3914.16	3907.19	3908.93	4517.0
2013-11-05 09:00:00	NQ	Futures	3908.35	3915.9	3902.54	3905.45	39904.0
2013-11-05 10:00:00	NQ	Futures	3905.74	3924.61	3898.48	3922.87	44706.0
2013-11-05 11:00:00	NQ	Futures	3923.16	3926.94	3920.84	3924.03	22455.0
2013-11-05 12:00:00	NQ	Futures	3923.74	3932.17	3922.0	3928.97	15996.0
2013-11-05 13:00:00	NQ	Futures	3928.97	3933.91	3926.65	3927.23	12547.0
2013-11-05 14:00:00	NQ	Futures	3927.23	3937.68	3926.36	3934.2	15473.0
2013-11-05 15:00:00	NQ	Futures	3934.49	3938.85	3928.39	3931.0	46224.0
2013-11-05 16:00:00	NQ	Futures	3930.71	3934.2	3925.2	3927.52	7602.0
2013-11-05 17:00:00	NQ	Futures	3927.81	3928.39	3927.23	3927.23	176.0
2013-11-05 18:00:00	NQ	Futures	3926.65	3928.39	3924.03	3926.07	477.0
2013-11-05 19:00:00	NQ	Futures	3926.07	3931.88	3925.78	3929.84	614.0
2013-11-05 20:00:00	NQ	Futures	3929.84	3933.33	3929.26	3931.0	1040.0
2013-11-05 21:00:00	NQ	Futures	3931.29	3933.33	3930.13	3932.17	441.0
2013-11-05 22:00:00	NQ	Futures	3932.17	3939.72	3931.29	3939.43	1637.0
2013-11-05 23:00:00	NQ	Futures	3939.14	3947.56	3938.85	3944.36	2432.0
2013-11-05 00:00:00	YM	Futures	15893.7	15905.9	15891.6	15904.9	499.0
2013-11-05 01:00:00	YM	Futures	15905.9	15910.0	15903.9	15908.0	374.0

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

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