PREVIEW / futures_1hour / 2013-10-31

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-31.parquet
  size:    51 KB
  rows:    1,554

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-10-31 00:00:00	ES	Futures	1810.37	1810.62	1809.08	1809.33	2167.0
2013-10-31 01:00:00	ES	Futures	1809.33	1809.59	1807.53	1808.3	4712.0
2013-10-31 02:00:00	ES	Futures	1808.3	1810.62	1808.04	1810.37	4185.0
2013-10-31 03:00:00	ES	Futures	1810.37	1811.14	1809.33	1809.59	6381.0
2013-10-31 04:00:00	ES	Futures	1809.85	1812.17	1809.33	1810.88	23446.0
2013-10-31 05:00:00	ES	Futures	1810.62	1812.69	1809.59	1811.91	12975.0
2013-10-31 06:00:00	ES	Futures	1811.91	1812.95	1811.14	1811.91	11383.0
2013-10-31 07:00:00	ES	Futures	1811.91	1814.75	1810.88	1813.46	25564.0
2013-10-31 08:00:00	ES	Futures	1813.46	1815.53	1812.95	1813.46	35063.0
2013-10-31 09:00:00	ES	Futures	1813.46	1818.11	1809.33	1810.37	265184.0
2013-10-31 10:00:00	ES	Futures	1810.11	1811.66	1805.98	1810.37	325103.0
2013-10-31 11:00:00	ES	Futures	1810.37	1815.78	1809.59	1813.46	200052.0
2013-10-31 12:00:00	ES	Futures	1813.2	1816.82	1812.43	1814.49	135408.0
2013-10-31 13:00:00	ES	Futures	1814.49	1816.56	1814.24	1815.78	75320.0
2013-10-31 14:00:00	ES	Futures	1815.53	1820.17	1814.75	1815.78	179374.0
2013-10-31 15:00:00	ES	Futures	1815.78	1816.3	1808.04	1808.04	369420.0
2013-10-31 16:00:00	ES	Futures	1808.04	1811.91	1807.53	1811.66	134618.0
2013-10-31 17:00:00	ES	Futures	1811.66	1811.91	1811.14	1811.14	1948.0
2013-10-31 18:00:00	ES	Futures	1811.4	1811.66	1808.56	1810.62	7144.0
2013-10-31 19:00:00	ES	Futures	1810.88	1810.88	1808.82	1810.11	2599.0
2013-10-31 20:00:00	ES	Futures	1809.85	1810.88	1809.59	1810.37	5672.0
2013-10-31 21:00:00	ES	Futures	1810.37	1810.62	1809.08	1809.59	3804.0
2013-10-31 22:00:00	ES	Futures	1809.33	1810.11	1808.56	1809.08	5189.0
2013-10-31 23:00:00	ES	Futures	1809.08	1810.11	1807.27	1807.27	7120.0
2013-10-31 00:00:00	NQ	Futures	3919.68	3919.97	3916.77	3916.77	306.0
2013-10-31 01:00:00	NQ	Futures	3917.06	3917.64	3914.16	3915.9	582.0
2013-10-31 02:00:00	NQ	Futures	3915.61	3920.84	3915.03	3920.55	335.0
2013-10-31 03:00:00	NQ	Futures	3920.55	3922.58	3918.52	3919.39	894.0
2013-10-31 04:00:00	NQ	Futures	3919.68	3925.49	3919.1	3921.42	2648.0
2013-10-31 05:00:00	NQ	Futures	3921.13	3924.9	3918.81	3922.87	1861.0
2013-10-31 06:00:00	NQ	Futures	3922.58	3924.9	3921.42	3923.45	1548.0
2013-10-31 07:00:00	NQ	Futures	3923.16	3927.81	3919.97	3925.78	2979.0
2013-10-31 08:00:00	NQ	Futures	3925.78	3930.13	3921.42	3921.71	4709.0
2013-10-31 09:00:00	NQ	Futures	3921.71	3933.33	3908.35	3909.8	43162.0
2013-10-31 10:00:00	NQ	Futures	3909.8	3927.23	3904.28	3924.9	55812.0
2013-10-31 11:00:00	NQ	Futures	3924.9	3938.85	3924.9	3933.62	28765.0
2013-10-31 12:00:00	NQ	Futures	3933.91	3941.46	3930.13	3934.2	17839.0
2013-10-31 13:00:00	NQ	Futures	3934.2	3939.14	3933.04	3935.07	10828.0
2013-10-31 14:00:00	NQ	Futures	3935.07	3942.91	3931.88	3932.17	18409.0
2013-10-31 15:00:00	NQ	Futures	3931.88	3932.17	3917.64	3918.81	45917.0
2013-10-31 16:00:00	NQ	Futures	3918.81	3925.2	3917.93	3924.32	7482.0
2013-10-31 17:00:00	NQ	Futures	3924.32	3924.61	3923.45	3924.03	199.0
2013-10-31 18:00:00	NQ	Futures	3923.45	3924.61	3919.68	3923.16	603.0
2013-10-31 19:00:00	NQ	Futures	3922.29	3922.58	3919.1	3921.13	217.0
2013-10-31 20:00:00	NQ	Futures	3921.13	3922.29	3920.55	3921.71	530.0
2013-10-31 21:00:00	NQ	Futures	3922.0	3922.0	3917.64	3919.39	541.0
2013-10-31 22:00:00	NQ	Futures	3919.1	3920.84	3917.06	3919.97	811.0
2013-10-31 23:00:00	NQ	Futures	3919.39	3922.0	3917.06	3917.35	717.0
2013-10-31 00:00:00	YM	Futures	15847.7	15854.9	15839.5	15840.6	565.0
2013-10-31 01:00:00	YM	Futures	15840.6	15843.6	15826.3	15833.4	974.0

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

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