PREVIEW / futures_1hour / 2014-01-09

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-09.parquet
  size:    50 KB
  rows:    1,552

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-01-09 00:00:00	ES	Futures	1896.19	1896.96	1894.89	1896.19	3261.0
2014-01-09 01:00:00	ES	Futures	1896.19	1897.48	1895.93	1896.19	3128.0
2014-01-09 02:00:00	ES	Futures	1896.19	1896.19	1894.12	1895.41	5843.0
2014-01-09 03:00:00	ES	Futures	1895.41	1896.45	1892.05	1893.6	18651.0
2014-01-09 04:00:00	ES	Futures	1893.34	1901.62	1893.34	1901.62	31379.0
2014-01-09 05:00:00	ES	Futures	1901.36	1902.65	1900.84	1901.62	11309.0
2014-01-09 06:00:00	ES	Futures	1901.62	1902.14	1900.58	1900.58	6707.0
2014-01-09 07:00:00	ES	Futures	1900.84	1901.62	1900.58	1900.58	10519.0
2014-01-09 08:00:00	ES	Futures	1900.58	1901.62	1898.77	1899.29	36116.0
2014-01-09 09:00:00	ES	Futures	1899.03	1901.62	1897.74	1900.33	115230.0
2014-01-09 10:00:00	ES	Futures	1900.07	1901.1	1888.69	1891.01	290165.0
2014-01-09 11:00:00	ES	Futures	1890.76	1891.79	1887.39	1891.53	205455.0
2014-01-09 12:00:00	ES	Futures	1891.27	1895.67	1890.76	1895.67	103463.0
2014-01-09 13:00:00	ES	Futures	1895.41	1895.93	1892.05	1892.31	95232.0
2014-01-09 14:00:00	ES	Futures	1892.31	1895.41	1889.2	1893.86	123135.0
2014-01-09 15:00:00	ES	Futures	1894.12	1897.74	1893.34	1896.19	188732.0
2014-01-09 16:00:00	ES	Futures	1896.19	1897.22	1895.93	1896.96	52725.0
2014-01-09 17:00:00	ES	Futures	1896.96	1897.22	1896.7	1896.96	1290.0
2014-01-09 18:00:00	ES	Futures	1896.7	1896.96	1895.93	1896.45	2435.0
2014-01-09 19:00:00	ES	Futures	1896.19	1897.48	1896.19	1896.96	3282.0
2014-01-09 20:00:00	ES	Futures	1896.7	1898.0	1896.45	1897.22	2748.0
2014-01-09 21:00:00	ES	Futures	1897.48	1898.52	1897.22	1898.26	2183.0
2014-01-09 22:00:00	ES	Futures	1898.26	1898.52	1898.0	1898.52	2294.0
2014-01-09 23:00:00	ES	Futures	1898.26	1898.52	1897.74	1898.52	1784.0
2014-01-09 00:00:00	NQ	Futures	4145.16	4146.91	4143.42	4145.75	434.0
2014-01-09 01:00:00	NQ	Futures	4145.75	4147.78	4144.87	4145.16	284.0
2014-01-09 02:00:00	NQ	Futures	4144.87	4144.87	4140.51	4142.26	623.0
2014-01-09 03:00:00	NQ	Futures	4142.55	4145.75	4135.57	4139.06	2329.0
2014-01-09 04:00:00	NQ	Futures	4139.06	4156.21	4139.06	4156.21	5339.0
2014-01-09 05:00:00	NQ	Futures	4156.21	4159.12	4154.76	4157.08	1980.0
2014-01-09 06:00:00	NQ	Futures	4157.08	4157.66	4152.72	4153.01	1586.0
2014-01-09 07:00:00	NQ	Futures	4153.3	4156.21	4152.72	4154.18	1128.0
2014-01-09 08:00:00	NQ	Futures	4153.88	4155.05	4148.36	4150.69	4990.0
2014-01-09 09:00:00	NQ	Futures	4150.4	4155.92	4144.87	4151.27	23355.0
2014-01-09 10:00:00	NQ	Futures	4151.56	4153.3	4117.84	4122.49	50479.0
2014-01-09 11:00:00	NQ	Futures	4122.2	4123.07	4112.9	4121.04	33785.0
2014-01-09 12:00:00	NQ	Futures	4121.04	4131.21	4118.71	4130.05	14357.0
2014-01-09 13:00:00	NQ	Futures	4129.76	4130.34	4118.71	4119.29	15243.0
2014-01-09 14:00:00	NQ	Futures	4119.29	4125.98	4110.86	4122.2	27458.0
2014-01-09 15:00:00	NQ	Futures	4121.91	4128.89	4119.87	4125.4	26172.0
2014-01-09 16:00:00	NQ	Futures	4125.11	4126.85	4124.53	4126.85	2891.0
2014-01-09 17:00:00	NQ	Futures	4127.14	4128.3	4126.56	4128.3	72.0
2014-01-09 18:00:00	NQ	Futures	4127.43	4128.6	4125.98	4127.72	328.0
2014-01-09 19:00:00	NQ	Futures	4127.72	4130.05	4127.72	4128.89	584.0
2014-01-09 20:00:00	NQ	Futures	4129.18	4132.08	4128.6	4130.92	745.0
2014-01-09 21:00:00	NQ	Futures	4130.92	4132.08	4130.92	4131.5	535.0
2014-01-09 22:00:00	NQ	Futures	4131.5	4132.37	4130.63	4131.5	238.0
2014-01-09 23:00:00	NQ	Futures	4131.5	4131.79	4129.76	4131.21	158.0
2014-01-09 00:00:00	YM	Futures	16824.8	16832.0	16818.7	16827.9	430.0
2014-01-09 01:00:00	YM	Futures	16827.9	16837.1	16824.8	16826.9	339.0

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

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