PREVIEW / futures_1hour / 2014-01-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	1905.76	1906.02	1904.72	1904.98	2428.0
2014-01-21 01:00:00	ES	Futures	1904.72	1904.98	1903.95	1904.21	3066.0
2014-01-21 02:00:00	ES	Futures	1904.21	1904.98	1902.91	1902.91	5730.0
2014-01-21 03:00:00	ES	Futures	1902.91	1904.21	1901.62	1902.14	19111.0
2014-01-21 04:00:00	ES	Futures	1902.39	1902.91	1900.84	1900.84	8867.0
2014-01-21 05:00:00	ES	Futures	1900.84	1903.43	1900.58	1902.39	8443.0
2014-01-21 06:00:00	ES	Futures	1902.39	1903.95	1902.14	1902.91	9381.0
2014-01-21 07:00:00	ES	Futures	1903.17	1904.72	1901.88	1903.95	13393.0
2014-01-21 08:00:00	ES	Futures	1903.69	1905.76	1903.43	1905.5	22333.0
2014-01-21 09:00:00	ES	Futures	1905.24	1907.83	1904.72	1906.02	166437.0
2014-01-21 10:00:00	ES	Futures	1905.76	1906.27	1897.74	1899.81	231681.0
2014-01-21 11:00:00	ES	Futures	1899.81	1900.33	1890.24	1893.08	221610.0
2014-01-21 12:00:00	ES	Futures	1892.82	1896.96	1889.46	1896.7	98440.0
2014-01-21 13:00:00	ES	Futures	1896.7	1901.62	1896.7	1900.33	99443.0
2014-01-21 14:00:00	ES	Futures	1900.33	1902.14	1898.77	1900.33	70243.0
2014-01-21 15:00:00	ES	Futures	1900.33	1902.14	1898.52	1901.88	149717.0
2014-01-21 16:00:00	ES	Futures	1901.88	1902.65	1900.33	1900.84	74513.0
2014-01-21 17:00:00	ES	Futures	1900.84	1901.36	1900.58	1901.1	2539.0
2014-01-21 18:00:00	ES	Futures	1901.1	1901.36	1899.55	1900.07	5127.0
2014-01-21 19:00:00	ES	Futures	1899.81	1901.36	1899.81	1901.1	2244.0
2014-01-21 20:00:00	ES	Futures	1901.1	1901.88	1900.84	1901.62	2291.0
2014-01-21 21:00:00	ES	Futures	1901.62	1901.62	1900.84	1901.36	1456.0
2014-01-21 22:00:00	ES	Futures	1901.36	1901.88	1900.07	1900.58	3326.0
2014-01-21 23:00:00	ES	Futures	1900.58	1904.21	1899.81	1903.95	6502.0
2014-01-21 00:00:00	NQ	Futures	4194.0	4196.03	4192.55	4192.84	924.0
2014-01-21 01:00:00	NQ	Futures	4192.26	4192.26	4190.22	4190.51	387.0
2014-01-21 02:00:00	NQ	Futures	4190.51	4192.55	4187.9	4188.19	852.0
2014-01-21 03:00:00	NQ	Futures	4187.9	4191.09	4185.86	4186.44	2768.0
2014-01-21 04:00:00	NQ	Futures	4186.44	4188.48	4181.79	4181.79	1537.0
2014-01-21 05:00:00	NQ	Futures	4181.79	4187.9	4181.79	4185.57	923.0
2014-01-21 06:00:00	NQ	Futures	4185.57	4190.51	4185.28	4188.77	1314.0
2014-01-21 07:00:00	NQ	Futures	4189.06	4191.67	4185.57	4189.64	2035.0
2014-01-21 08:00:00	NQ	Futures	4189.93	4191.09	4188.19	4190.22	2488.0
2014-01-21 09:00:00	NQ	Futures	4190.51	4199.81	4190.22	4197.2	31214.0
2014-01-21 10:00:00	NQ	Futures	4196.91	4198.07	4177.14	4184.41	35283.0
2014-01-21 11:00:00	NQ	Futures	4184.41	4185.86	4162.02	4175.1	33076.0
2014-01-21 12:00:00	NQ	Futures	4175.4	4185.57	4166.97	4184.7	19569.0
2014-01-21 13:00:00	NQ	Futures	4184.7	4194.58	4184.41	4191.38	15741.0
2014-01-21 14:00:00	NQ	Futures	4191.38	4196.03	4188.48	4193.42	10353.0
2014-01-21 15:00:00	NQ	Futures	4193.13	4197.78	4189.64	4197.49	29469.0
2014-01-21 16:00:00	NQ	Futures	4197.2	4198.65	4194.0	4194.87	7318.0
2014-01-21 17:00:00	NQ	Futures	4194.87	4195.74	4194.58	4195.74	327.0
2014-01-21 18:00:00	NQ	Futures	4194.29	4194.87	4191.67	4193.13	667.0
2014-01-21 19:00:00	NQ	Futures	4192.84	4195.45	4192.84	4194.87	522.0
2014-01-21 20:00:00	NQ	Futures	4194.87	4197.49	4194.58	4196.62	374.0
2014-01-21 21:00:00	NQ	Futures	4196.62	4196.91	4195.45	4196.62	260.0
2014-01-21 22:00:00	NQ	Futures	4196.62	4197.49	4194.0	4194.0	555.0
2014-01-21 23:00:00	NQ	Futures	4194.29	4202.14	4193.13	4201.85	966.0
2014-01-21 00:00:00	YM	Futures	16892.5	16896.6	16883.3	16884.3	337.0
2014-01-21 01:00:00	YM	Futures	16884.3	16884.3	16875.1	16879.2	361.0

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

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