PREVIEW / futures_1hour / 2014-02-18

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-18.parquet
  size:    49 KB
  rows:    1,516

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-18 00:00:00	ES	Futures	1900.84	1902.91	1900.58	1901.88	4427.0
2014-02-18 01:00:00	ES	Futures	1902.14	1903.43	1901.62	1902.91	2949.0
2014-02-18 02:00:00	ES	Futures	1902.65	1903.43	1901.62	1902.14	4988.0
2014-02-18 03:00:00	ES	Futures	1902.14	1902.14	1899.03	1899.81	25169.0
2014-02-18 04:00:00	ES	Futures	1899.55	1899.81	1895.93	1896.7	20756.0
2014-02-18 05:00:00	ES	Futures	1896.45	1898.26	1895.93	1896.96	14061.0
2014-02-18 06:00:00	ES	Futures	1896.7	1898.0	1895.67	1897.22	13315.0
2014-02-18 07:00:00	ES	Futures	1897.48	1902.14	1897.22	1901.36	26935.0
2014-02-18 08:00:00	ES	Futures	1901.1	1901.36	1897.22	1899.03	41223.0
2014-02-18 09:00:00	ES	Futures	1898.77	1903.43	1897.48	1899.03	181398.0
2014-02-18 10:00:00	ES	Futures	1898.77	1901.36	1894.89	1900.58	195828.0
2014-02-18 11:00:00	ES	Futures	1900.58	1903.69	1899.55	1900.58	114793.0
2014-02-18 12:00:00	ES	Futures	1900.84	1903.17	1900.33	1901.88	58957.0
2014-02-18 13:00:00	ES	Futures	1902.14	1902.65	1899.55	1901.1	72297.0
2014-02-18 14:00:00	ES	Futures	1900.84	1903.43	1900.84	1901.88	80691.0
2014-02-18 15:00:00	ES	Futures	1901.88	1903.43	1900.33	1901.1	137751.0
2014-02-18 16:00:00	ES	Futures	1901.1	1901.88	1900.07	1901.36	64117.0
2014-02-18 17:00:00	ES	Futures	1901.1	1901.62	1900.84	1901.1	2641.0
2014-02-18 18:00:00	ES	Futures	1900.84	1901.1	1897.74	1898.0	7310.0
2014-02-18 19:00:00	ES	Futures	1898.0	1899.55	1897.48	1898.52	6663.0
2014-02-18 20:00:00	ES	Futures	1898.52	1900.58	1897.74	1900.33	5191.0
2014-02-18 21:00:00	ES	Futures	1900.33	1900.58	1898.0	1899.29	3630.0
2014-02-18 22:00:00	ES	Futures	1899.29	1899.81	1898.26	1898.26	2663.0
2014-02-18 23:00:00	ES	Futures	1898.52	1899.03	1898.26	1898.77	1950.0
2014-02-18 00:00:00	NQ	Futures	4264.05	4267.83	4264.05	4265.51	618.0
2014-02-18 01:00:00	NQ	Futures	4265.22	4269.29	4264.35	4268.71	470.0
2014-02-18 02:00:00	NQ	Futures	4268.71	4269.87	4265.8	4267.25	533.0
2014-02-18 03:00:00	NQ	Futures	4266.96	4266.96	4259.98	4260.86	2759.0
2014-02-18 04:00:00	NQ	Futures	4261.15	4262.02	4253.59	4254.75	1762.0
2014-02-18 05:00:00	NQ	Futures	4254.75	4257.37	4251.85	4253.01	2531.0
2014-02-18 06:00:00	NQ	Futures	4253.01	4256.5	4248.65	4254.75	1403.0
2014-02-18 07:00:00	NQ	Futures	4254.75	4264.05	4254.17	4261.73	3993.0
2014-02-18 08:00:00	NQ	Futures	4261.73	4262.02	4256.21	4259.4	6485.0
2014-02-18 09:00:00	NQ	Futures	4259.4	4273.07	4257.66	4260.28	31291.0
2014-02-18 10:00:00	NQ	Futures	4259.98	4280.91	4251.85	4278.59	42798.0
2014-02-18 11:00:00	NQ	Futures	4278.59	4282.08	4271.03	4272.19	23427.0
2014-02-18 12:00:00	NQ	Futures	4271.9	4281.2	4271.61	4277.43	11259.0
2014-02-18 13:00:00	NQ	Futures	4277.43	4279.17	4273.07	4276.84	17620.0
2014-02-18 14:00:00	NQ	Futures	4277.14	4284.4	4276.84	4281.5	22522.0
2014-02-18 15:00:00	NQ	Futures	4281.79	4284.11	4275.1	4276.26	25245.0
2014-02-18 16:00:00	NQ	Futures	4276.26	4278.59	4271.9	4274.81	6808.0
2014-02-18 17:00:00	NQ	Futures	4274.52	4275.1	4273.94	4274.23	131.0
2014-02-18 18:00:00	NQ	Futures	4274.23	4274.23	4267.54	4267.54	878.0
2014-02-18 19:00:00	NQ	Futures	4267.25	4270.45	4266.67	4269.0	791.0
2014-02-18 20:00:00	NQ	Futures	4269.0	4273.36	4267.54	4272.19	680.0
2014-02-18 21:00:00	NQ	Futures	4272.48	4273.07	4268.12	4271.03	467.0
2014-02-18 22:00:00	NQ	Futures	4271.03	4272.48	4269.58	4269.58	344.0
2014-02-18 23:00:00	NQ	Futures	4269.87	4271.32	4269.29	4269.87	321.0
2014-02-18 00:00:00	YM	Futures	16565.4	16579.7	16565.4	16574.6	543.0
2014-02-18 01:00:00	YM	Futures	16574.6	16587.9	16569.5	16580.8	409.0

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

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