PREVIEW / futures_1hour / 2013-10-28

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-28.parquet
  size:    47 KB
  rows:    1,485

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-28 00:00:00	ES	Futures	1815.78	1816.56	1815.27	1815.78	1512.0
2013-10-28 01:00:00	ES	Futures	1815.53	1816.82	1815.53	1816.82	2666.0
2013-10-28 02:00:00	ES	Futures	1816.82	1817.07	1814.75	1815.27	3673.0
2013-10-28 03:00:00	ES	Futures	1815.27	1815.78	1813.98	1815.01	4921.0
2013-10-28 04:00:00	ES	Futures	1815.01	1815.01	1813.2	1813.2	12207.0
2013-10-28 05:00:00	ES	Futures	1813.2	1814.49	1813.2	1814.24	7257.0
2013-10-28 06:00:00	ES	Futures	1814.24	1814.49	1811.66	1812.17	14648.0
2013-10-28 07:00:00	ES	Futures	1812.17	1812.43	1810.62	1811.4	14288.0
2013-10-28 08:00:00	ES	Futures	1811.4	1811.66	1807.27	1809.08	41283.0
2013-10-28 09:00:00	ES	Futures	1808.82	1811.66	1808.04	1810.11	120850.0
2013-10-28 10:00:00	ES	Futures	1810.11	1813.72	1807.79	1808.82	201880.0
2013-10-28 11:00:00	ES	Futures	1808.82	1812.43	1808.04	1811.91	148676.0
2013-10-28 12:00:00	ES	Futures	1812.17	1815.01	1811.66	1814.49	113396.0
2013-10-28 13:00:00	ES	Futures	1814.49	1815.01	1813.2	1813.72	50201.0
2013-10-28 14:00:00	ES	Futures	1813.98	1816.04	1813.2	1815.53	80405.0
2013-10-28 15:00:00	ES	Futures	1815.53	1815.53	1810.11	1813.46	202290.0
2013-10-28 16:00:00	ES	Futures	1813.46	1816.3	1812.43	1813.72	88862.0
2013-10-28 17:00:00	ES	Futures	1813.72	1814.75	1812.95	1813.46	3251.0
2013-10-28 18:00:00	ES	Futures	1815.01	1815.27	1811.91	1812.69	6247.0
2013-10-28 19:00:00	ES	Futures	1812.69	1813.2	1812.17	1812.69	1802.0
2013-10-28 20:00:00	ES	Futures	1812.69	1812.95	1810.37	1811.4	5526.0
2013-10-28 21:00:00	ES	Futures	1811.66	1814.24	1810.88	1813.98	5705.0
2013-10-28 22:00:00	ES	Futures	1813.98	1814.49	1812.43	1812.43	2802.0
2013-10-28 23:00:00	ES	Futures	1812.43	1813.46	1811.91	1812.95	2928.0
2013-10-28 00:00:00	NQ	Futures	3933.33	3935.94	3933.33	3934.49	318.0
2013-10-28 01:00:00	NQ	Futures	3934.49	3936.52	3933.91	3935.94	499.0
2013-10-28 02:00:00	NQ	Futures	3936.23	3936.81	3933.04	3933.91	413.0
2013-10-28 03:00:00	NQ	Futures	3934.2	3934.78	3931.0	3931.88	819.0
2013-10-28 04:00:00	NQ	Futures	3932.17	3932.17	3928.39	3929.55	1579.0
2013-10-28 05:00:00	NQ	Futures	3929.55	3934.49	3929.26	3934.2	1288.0
2013-10-28 06:00:00	NQ	Futures	3933.91	3935.07	3928.39	3928.97	1522.0
2013-10-28 07:00:00	NQ	Futures	3928.68	3929.26	3924.9	3927.81	1575.0
2013-10-28 08:00:00	NQ	Futures	3927.52	3928.39	3918.81	3922.87	3929.0
2013-10-28 09:00:00	NQ	Futures	3922.87	3926.36	3914.74	3918.52	25552.0
2013-10-28 10:00:00	NQ	Futures	3918.52	3927.23	3907.19	3910.38	32068.0
2013-10-28 11:00:00	NQ	Futures	3910.38	3918.81	3907.48	3917.35	24449.0
2013-10-28 12:00:00	NQ	Futures	3917.35	3929.55	3916.19	3928.1	19903.0
2013-10-28 13:00:00	NQ	Futures	3928.39	3929.55	3924.9	3926.94	9191.0
2013-10-28 14:00:00	NQ	Futures	3926.94	3931.0	3924.9	3929.26	9499.0
2013-10-28 15:00:00	NQ	Futures	3929.26	3929.55	3914.16	3924.03	35371.0
2013-10-28 16:00:00	NQ	Futures	3924.03	3939.43	3904.28	3915.61	21918.0
2013-10-28 17:00:00	NQ	Futures	3915.9	3919.39	3914.16	3914.16	746.0
2013-10-28 18:00:00	NQ	Futures	3924.03	3925.78	3917.64	3919.1	1709.0
2013-10-28 19:00:00	NQ	Futures	3919.39	3919.68	3916.77	3918.52	387.0
2013-10-28 20:00:00	NQ	Futures	3917.93	3918.22	3913.29	3917.35	1098.0
2013-10-28 21:00:00	NQ	Futures	3917.06	3924.03	3915.9	3922.58	1199.0
2013-10-28 22:00:00	NQ	Futures	3922.58	3924.03	3918.22	3918.81	575.0
2013-10-28 23:00:00	NQ	Futures	3918.81	3920.84	3917.93	3918.81	558.0
2013-10-28 00:00:00	YM	Futures	15885.5	15892.6	15883.5	15886.5	231.0
2013-10-28 01:00:00	YM	Futures	15886.5	15893.7	15884.5	15891.6	448.0

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

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