PREVIEW / futures_1hour / 2014-02-13

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-13.parquet
  size:    51 KB
  rows:    1,565

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
2014-02-13 00:00:00	ES	Futures	1874.98	1875.24	1869.8	1870.06	20260.0
2014-02-13 01:00:00	ES	Futures	1870.06	1871.87	1869.55	1870.84	6959.0
2014-02-13 02:00:00	ES	Futures	1870.84	1872.65	1870.58	1872.39	8557.0
2014-02-13 03:00:00	ES	Futures	1872.39	1874.2	1871.87	1872.91	21456.0
2014-02-13 04:00:00	ES	Futures	1872.91	1873.17	1869.55	1871.36	19748.0
2014-02-13 05:00:00	ES	Futures	1871.36	1873.94	1870.84	1871.36	24962.0
2014-02-13 06:00:00	ES	Futures	1871.36	1871.62	1869.03	1870.32	22636.0
2014-02-13 07:00:00	ES	Futures	1870.06	1872.39	1870.06	1870.84	20408.0
2014-02-13 08:00:00	ES	Futures	1870.84	1871.1	1864.63	1868.51	105503.0
2014-02-13 09:00:00	ES	Futures	1868.51	1873.68	1865.41	1872.91	224760.0
2014-02-13 10:00:00	ES	Futures	1873.17	1882.48	1871.87	1881.44	295666.0
2014-02-13 11:00:00	ES	Futures	1881.19	1884.81	1879.89	1882.22	174796.0
2014-02-13 12:00:00	ES	Futures	1882.48	1884.55	1880.93	1883.77	107252.0
2014-02-13 13:00:00	ES	Futures	1883.77	1888.94	1883.51	1888.94	129745.0
2014-02-13 14:00:00	ES	Futures	1888.69	1890.24	1886.88	1889.72	156117.0
2014-02-13 15:00:00	ES	Futures	1889.46	1889.98	1887.39	1888.69	176352.0
2014-02-13 16:00:00	ES	Futures	1888.69	1888.69	1886.1	1887.91	97327.0
2014-02-13 17:00:00	ES	Futures	1888.17	1888.17	1887.13	1887.39	1780.0
2014-02-13 18:00:00	ES	Futures	1886.88	1887.13	1884.81	1886.62	7440.0
2014-02-13 19:00:00	ES	Futures	1886.88	1888.69	1886.1	1887.91	6338.0
2014-02-13 20:00:00	ES	Futures	1887.65	1890.76	1887.39	1888.69	7413.0
2014-02-13 21:00:00	ES	Futures	1888.94	1889.2	1885.07	1885.32	6217.0
2014-02-13 22:00:00	ES	Futures	1885.32	1885.58	1881.96	1883.25	16181.0
2014-02-13 23:00:00	ES	Futures	1883.25	1884.29	1880.93	1881.44	9272.0
2014-02-13 00:00:00	NQ	Futures	4202.43	4202.43	4194.0	4194.0	2858.0
2014-02-13 01:00:00	NQ	Futures	4194.29	4196.32	4193.71	4195.16	939.0
2014-02-13 02:00:00	NQ	Futures	4195.16	4198.94	4195.16	4198.36	1030.0
2014-02-13 03:00:00	NQ	Futures	4198.65	4202.72	4197.2	4200.1	2150.0
2014-02-13 04:00:00	NQ	Futures	4200.1	4200.1	4192.84	4195.74	2765.0
2014-02-13 05:00:00	NQ	Futures	4195.45	4199.81	4193.71	4194.29	2875.0
2014-02-13 06:00:00	NQ	Futures	4194.29	4195.16	4189.64	4194.0	2968.0
2014-02-13 07:00:00	NQ	Futures	4194.0	4198.07	4190.8	4193.42	4254.0
2014-02-13 08:00:00	NQ	Futures	4193.71	4194.0	4182.08	4189.06	13772.0
2014-02-13 09:00:00	NQ	Futures	4189.06	4212.02	4182.66	4209.7	52846.0
2014-02-13 10:00:00	NQ	Futures	4209.99	4236.15	4207.66	4233.82	56481.0
2014-02-13 11:00:00	NQ	Futures	4233.82	4238.76	4230.33	4231.79	35369.0
2014-02-13 12:00:00	NQ	Futures	4232.37	4239.06	4230.63	4237.02	20070.0
2014-02-13 13:00:00	NQ	Futures	4237.02	4249.52	4236.44	4248.65	21319.0
2014-02-13 14:00:00	NQ	Futures	4248.65	4250.68	4240.51	4247.49	24972.0
2014-02-13 15:00:00	NQ	Futures	4247.49	4250.97	4242.83	4248.36	32429.0
2014-02-13 16:00:00	NQ	Futures	4248.65	4248.65	4244.0	4247.49	6507.0
2014-02-13 17:00:00	NQ	Futures	4247.49	4247.78	4244.87	4245.74	145.0
2014-02-13 18:00:00	NQ	Futures	4244.58	4244.87	4239.35	4243.71	924.0
2014-02-13 19:00:00	NQ	Futures	4243.71	4249.23	4243.13	4246.32	1005.0
2014-02-13 20:00:00	NQ	Futures	4246.32	4253.01	4245.45	4249.23	1158.0
2014-02-13 21:00:00	NQ	Futures	4249.52	4250.68	4242.25	4242.54	977.0
2014-02-13 22:00:00	NQ	Futures	4242.83	4243.13	4234.4	4237.89	2089.0
2014-02-13 23:00:00	NQ	Futures	4237.6	4239.64	4233.82	4234.4	967.0
2014-02-13 00:00:00	YM	Futures	16303.9	16303.9	16258.8	16260.8	2834.0
2014-02-13 01:00:00	YM	Futures	16260.8	16275.2	16257.8	16268.0	874.0

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

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