PREVIEW / futures_1hour / 2013-12-31

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-31.parquet
  size:    35 KB
  rows:    1,017

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-12-31 00:00:00	ES	Futures	1898.52	1898.77	1898.26	1898.26	269.0
2013-12-31 01:00:00	ES	Futures	1898.52	1898.77	1898.26	1898.52	360.0
2013-12-31 02:00:00	ES	Futures	1898.26	1899.03	1898.26	1898.52	1103.0
2013-12-31 03:00:00	ES	Futures	1898.77	1899.03	1898.52	1899.03	1511.0
2013-12-31 04:00:00	ES	Futures	1899.03	1899.29	1898.77	1899.29	1512.0
2013-12-31 05:00:00	ES	Futures	1899.03	1899.55	1898.52	1899.29	2168.0
2013-12-31 06:00:00	ES	Futures	1899.29	1899.55	1899.03	1899.03	1869.0
2013-12-31 07:00:00	ES	Futures	1899.29	1900.84	1898.77	1900.58	6357.0
2013-12-31 08:00:00	ES	Futures	1900.58	1902.39	1900.58	1901.88	10897.0
2013-12-31 09:00:00	ES	Futures	1901.88	1902.91	1900.84	1902.39	41472.0
2013-12-31 10:00:00	ES	Futures	1902.39	1904.46	1902.39	1904.46	70343.0
2013-12-31 11:00:00	ES	Futures	1904.46	1907.31	1904.46	1905.24	64763.0
2013-12-31 12:00:00	ES	Futures	1905.5	1906.02	1903.69	1905.24	39737.0
2013-12-31 13:00:00	ES	Futures	1904.98	1905.24	1903.69	1904.72	24844.0
2013-12-31 14:00:00	ES	Futures	1904.98	1904.98	1900.58	1901.88	61639.0
2013-12-31 15:00:00	ES	Futures	1901.88	1908.09	1900.33	1906.53	210962.0
2013-12-31 16:00:00	ES	Futures	1906.53	1910.41	1906.53	1909.38	102428.0
2013-12-31 17:00:00	ES	Futures	1909.38	1910.41	1909.38	1910.15	1305.0
2013-12-31 00:00:00	NQ	Futures	4146.91	4146.91	4146.04	4146.62	32.0
2013-12-31 01:00:00	NQ	Futures	4146.91	4147.2	4146.33	4146.91	21.0
2013-12-31 02:00:00	NQ	Futures	4146.91	4148.07	4146.91	4147.2	63.0
2013-12-31 03:00:00	NQ	Futures	4147.2	4147.78	4146.91	4146.91	46.0
2013-12-31 04:00:00	NQ	Futures	4146.91	4148.36	4146.91	4148.36	90.0
2013-12-31 05:00:00	NQ	Futures	4148.36	4148.36	4146.91	4147.78	93.0
2013-12-31 06:00:00	NQ	Futures	4147.49	4148.94	4147.49	4148.94	83.0
2013-12-31 07:00:00	NQ	Futures	4148.65	4152.14	4148.36	4151.56	323.0
2013-12-31 08:00:00	NQ	Futures	4151.27	4154.47	4150.98	4152.72	837.0
2013-12-31 09:00:00	NQ	Futures	4152.72	4159.7	4152.43	4158.54	8248.0
2013-12-31 10:00:00	NQ	Futures	4158.83	4166.09	4154.47	4166.09	10329.0
2013-12-31 11:00:00	NQ	Futures	4166.38	4172.2	4165.51	4166.97	11811.0
2013-12-31 12:00:00	NQ	Futures	4167.26	4168.13	4164.35	4167.26	5908.0
2013-12-31 13:00:00	NQ	Futures	4167.26	4168.13	4163.77	4166.09	3882.0
2013-12-31 14:00:00	NQ	Futures	4166.38	4167.55	4158.83	4161.44	6767.0
2013-12-31 15:00:00	NQ	Futures	4161.73	4173.07	4158.25	4172.78	16339.0
2013-12-31 16:00:00	NQ	Futures	4173.07	4179.76	4172.2	4177.14	5960.0
2013-12-31 17:00:00	NQ	Futures	4176.85	4178.3	4176.85	4178.01	331.0
2013-12-31 00:00:00	YM	Futures	16861.7	16862.8	16860.7	16861.7	64.0
2013-12-31 01:00:00	YM	Futures	16861.7	16861.7	16855.6	16855.6	143.0
2013-12-31 02:00:00	YM	Futures	16855.6	16865.8	16855.6	16862.8	194.0
2013-12-31 03:00:00	YM	Futures	16860.7	16861.7	16854.5	16857.6	239.0
2013-12-31 04:00:00	YM	Futures	16856.6	16856.6	16853.5	16854.5	133.0
2013-12-31 05:00:00	YM	Futures	16854.5	16857.6	16853.5	16856.6	58.0
2013-12-31 06:00:00	YM	Futures	16855.6	16858.6	16855.6	16858.6	77.0
2013-12-31 07:00:00	YM	Futures	16858.6	16877.1	16857.6	16875.1	642.0
2013-12-31 08:00:00	YM	Futures	16875.1	16894.5	16874.0	16888.4	926.0
2013-12-31 09:00:00	YM	Futures	16887.4	16902.7	16881.2	16889.4	4320.0
2013-12-31 10:00:00	YM	Futures	16890.4	16906.8	16890.4	16900.7	5004.0
2013-12-31 11:00:00	YM	Futures	16901.7	16927.4	16901.7	16918.1	5359.0
2013-12-31 12:00:00	YM	Futures	16919.1	16924.3	16908.9	16917.1	2503.0
2013-12-31 13:00:00	YM	Futures	16918.1	16918.1	16904.8	16915.0	1867.0

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

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