PREVIEW / futures_1hour / 2013-11-04

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-04.parquet
  size:    47 KB
  rows:    1,499

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-04 00:00:00	ES	Futures	1814.75	1815.01	1814.24	1814.24	3651.0
2013-11-04 01:00:00	ES	Futures	1814.49	1814.49	1813.2	1813.2	1710.0
2013-11-04 02:00:00	ES	Futures	1813.46	1813.98	1812.95	1813.72	4199.0
2013-11-04 03:00:00	ES	Futures	1813.98	1814.75	1811.66	1813.98	17439.0
2013-11-04 04:00:00	ES	Futures	1814.24	1814.75	1812.69	1812.95	6444.0
2013-11-04 05:00:00	ES	Futures	1813.2	1813.46	1811.91	1813.46	6668.0
2013-11-04 06:00:00	ES	Futures	1813.46	1815.27	1812.95	1815.01	7503.0
2013-11-04 07:00:00	ES	Futures	1814.75	1817.07	1814.49	1816.56	19067.0
2013-11-04 08:00:00	ES	Futures	1816.56	1818.36	1815.78	1817.85	27743.0
2013-11-04 09:00:00	ES	Futures	1817.85	1819.14	1813.98	1815.27	149631.0
2013-11-04 10:00:00	ES	Futures	1815.53	1817.07	1812.95	1812.95	160085.0
2013-11-04 11:00:00	ES	Futures	1812.95	1815.53	1811.91	1814.49	141862.0
2013-11-04 12:00:00	ES	Futures	1814.49	1815.78	1813.98	1814.24	71550.0
2013-11-04 13:00:00	ES	Futures	1814.24	1816.3	1813.98	1816.04	63842.0
2013-11-04 14:00:00	ES	Futures	1816.3	1818.11	1816.04	1817.07	82266.0
2013-11-04 15:00:00	ES	Futures	1816.82	1819.91	1815.27	1819.14	134729.0
2013-11-04 16:00:00	ES	Futures	1819.39	1820.17	1818.11	1818.88	67857.0
2013-11-04 17:00:00	ES	Futures	1818.88	1819.14	1818.62	1819.14	2091.0
2013-11-04 18:00:00	ES	Futures	1818.88	1819.39	1817.59	1819.39	4771.0
2013-11-04 19:00:00	ES	Futures	1819.39	1819.65	1818.62	1818.62	2012.0
2013-11-04 20:00:00	ES	Futures	1818.88	1819.39	1817.33	1817.59	5177.0
2013-11-04 21:00:00	ES	Futures	1817.85	1819.14	1817.33	1818.11	4218.0
2013-11-04 22:00:00	ES	Futures	1818.11	1818.62	1817.33	1817.59	2239.0
2013-11-04 23:00:00	ES	Futures	1817.59	1818.62	1817.33	1818.36	2106.0
2013-11-04 00:00:00	NQ	Futures	3922.29	3923.16	3922.0	3922.0	134.0
2013-11-04 01:00:00	NQ	Futures	3922.0	3922.29	3919.68	3919.97	212.0
2013-11-04 02:00:00	NQ	Futures	3919.97	3921.13	3917.93	3920.84	511.0
2013-11-04 03:00:00	NQ	Futures	3920.84	3924.03	3915.9	3923.16	2281.0
2013-11-04 04:00:00	NQ	Futures	3922.87	3925.2	3922.29	3922.58	1412.0
2013-11-04 05:00:00	NQ	Futures	3922.58	3923.74	3919.68	3923.45	1113.0
2013-11-04 06:00:00	NQ	Futures	3923.16	3928.97	3922.87	3927.81	1682.0
2013-11-04 07:00:00	NQ	Futures	3927.81	3932.17	3926.94	3931.29	2309.0
2013-11-04 08:00:00	NQ	Futures	3931.29	3934.2	3928.39	3933.62	3866.0
2013-11-04 09:00:00	NQ	Futures	3933.62	3935.07	3911.25	3916.19	29188.0
2013-11-04 10:00:00	NQ	Futures	3916.19	3926.36	3911.84	3914.45	26710.0
2013-11-04 11:00:00	NQ	Futures	3914.45	3924.03	3913.0	3921.71	18864.0
2013-11-04 12:00:00	NQ	Futures	3922.0	3922.58	3914.74	3914.74	9913.0
2013-11-04 13:00:00	NQ	Futures	3915.03	3918.81	3912.13	3916.19	9654.0
2013-11-04 14:00:00	NQ	Futures	3916.19	3922.58	3915.9	3919.68	8924.0
2013-11-04 15:00:00	NQ	Futures	3919.68	3925.2	3914.45	3924.32	17575.0
2013-11-04 16:00:00	NQ	Futures	3924.61	3926.07	3923.16	3924.9	4809.0
2013-11-04 17:00:00	NQ	Futures	3924.61	3926.07	3924.61	3926.07	183.0
2013-11-04 18:00:00	NQ	Futures	3924.32	3925.49	3922.0	3925.49	429.0
2013-11-04 19:00:00	NQ	Futures	3925.49	3925.78	3923.45	3923.74	346.0
2013-11-04 20:00:00	NQ	Futures	3923.74	3925.2	3920.55	3921.71	826.0
2013-11-04 21:00:00	NQ	Futures	3921.71	3923.45	3920.26	3921.71	343.0
2013-11-04 22:00:00	NQ	Futures	3922.0	3923.45	3920.84	3921.42	181.0
2013-11-04 23:00:00	NQ	Futures	3921.42	3923.45	3920.84	3922.58	228.0
2013-11-04 00:00:00	YM	Futures	15906.9	15911.0	15904.9	15906.9	188.0
2013-11-04 01:00:00	YM	Futures	15905.9	15906.9	15895.7	15895.7	316.0

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

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