PREVIEW / futures_1hour / 2014-01-22

all futures 1-hour files

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

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-22 00:00:00	ES	Futures	1903.95	1907.05	1903.95	1905.24	11324.0
2014-01-22 01:00:00	ES	Futures	1905.5	1905.5	1904.21	1904.21	2581.0
2014-01-22 02:00:00	ES	Futures	1903.95	1904.46	1903.43	1904.46	4743.0
2014-01-22 03:00:00	ES	Futures	1904.46	1905.5	1902.14	1902.91	16655.0
2014-01-22 04:00:00	ES	Futures	1902.65	1903.43	1900.84	1901.1	15604.0
2014-01-22 05:00:00	ES	Futures	1901.1	1902.14	1899.29	1900.07	12762.0
2014-01-22 06:00:00	ES	Futures	1900.07	1900.84	1898.26	1900.84	18180.0
2014-01-22 07:00:00	ES	Futures	1900.58	1901.62	1899.81	1900.07	11032.0
2014-01-22 08:00:00	ES	Futures	1900.07	1903.43	1899.55	1902.91	20005.0
2014-01-22 09:00:00	ES	Futures	1902.91	1906.02	1900.58	1902.14	151888.0
2014-01-22 10:00:00	ES	Futures	1902.14	1904.46	1898.77	1899.55	171423.0
2014-01-22 11:00:00	ES	Futures	1899.55	1901.88	1898.52	1900.33	98643.0
2014-01-22 12:00:00	ES	Futures	1900.58	1904.21	1899.81	1903.17	70636.0
2014-01-22 13:00:00	ES	Futures	1903.43	1905.24	1900.58	1901.88	70271.0
2014-01-22 14:00:00	ES	Futures	1901.88	1903.95	1901.62	1903.17	56877.0
2014-01-22 15:00:00	ES	Futures	1902.91	1905.5	1902.65	1902.91	118045.0
2014-01-22 16:00:00	ES	Futures	1903.17	1904.21	1901.88	1902.91	65775.0
2014-01-22 17:00:00	ES	Futures	1902.65	1903.17	1902.14	1902.39	2229.0
2014-01-22 18:00:00	ES	Futures	1902.65	1907.83	1902.39	1907.05	12024.0
2014-01-22 19:00:00	ES	Futures	1907.05	1907.05	1904.72	1905.24	5262.0
2014-01-22 20:00:00	ES	Futures	1905.24	1906.27	1899.55	1901.1	15797.0
2014-01-22 21:00:00	ES	Futures	1901.36	1901.36	1899.03	1899.55	8271.0
2014-01-22 22:00:00	ES	Futures	1899.55	1899.81	1892.05	1893.86	28476.0
2014-01-22 23:00:00	ES	Futures	1894.12	1896.19	1893.6	1895.67	8682.0
2014-01-22 00:00:00	NQ	Futures	4202.14	4210.28	4202.14	4206.5	2210.0
2014-01-22 01:00:00	NQ	Futures	4206.5	4207.37	4203.88	4203.88	384.0
2014-01-22 02:00:00	NQ	Futures	4203.59	4205.63	4201.85	4205.34	984.0
2014-01-22 03:00:00	NQ	Futures	4205.63	4207.66	4199.23	4200.1	2896.0
2014-01-22 04:00:00	NQ	Futures	4200.39	4202.14	4196.32	4197.49	2184.0
2014-01-22 05:00:00	NQ	Futures	4197.49	4200.39	4193.42	4196.03	1636.0
2014-01-22 06:00:00	NQ	Futures	4196.03	4198.36	4191.67	4197.49	2149.0
2014-01-22 07:00:00	NQ	Futures	4197.78	4200.39	4195.74	4195.74	1610.0
2014-01-22 08:00:00	NQ	Futures	4196.03	4206.5	4195.45	4204.46	3013.0
2014-01-22 09:00:00	NQ	Futures	4204.75	4209.7	4198.36	4201.85	32142.0
2014-01-22 10:00:00	NQ	Futures	4201.85	4210.28	4195.74	4201.85	36824.0
2014-01-22 11:00:00	NQ	Futures	4202.14	4209.7	4200.39	4208.24	18027.0
2014-01-22 12:00:00	NQ	Futures	4208.24	4216.67	4205.92	4214.93	17601.0
2014-01-22 13:00:00	NQ	Futures	4215.22	4218.42	4207.08	4209.99	15503.0
2014-01-22 14:00:00	NQ	Futures	4210.28	4214.93	4207.66	4209.41	13929.0
2014-01-22 15:00:00	NQ	Futures	4209.7	4215.51	4208.82	4209.99	21657.0
2014-01-22 16:00:00	NQ	Futures	4209.99	4220.16	4207.66	4216.38	8132.0
2014-01-22 17:00:00	NQ	Futures	4216.38	4217.25	4215.51	4215.51	257.0
2014-01-22 18:00:00	NQ	Futures	4215.51	4226.85	4214.64	4225.68	1452.0
2014-01-22 19:00:00	NQ	Futures	4225.68	4226.56	4221.32	4222.2	885.0
2014-01-22 20:00:00	NQ	Futures	4222.49	4225.97	4213.18	4217.84	3269.0
2014-01-22 21:00:00	NQ	Futures	4217.84	4217.84	4213.18	4214.93	1141.0
2014-01-22 22:00:00	NQ	Futures	4214.93	4214.93	4197.49	4202.14	4121.0
2014-01-22 23:00:00	NQ	Futures	4201.85	4206.79	4200.98	4205.92	1072.0
2014-01-22 00:00:00	YM	Futures	16770.5	16798.2	16770.5	16783.8	1314.0
2014-01-22 01:00:00	YM	Futures	16783.8	16784.8	16767.4	16768.4	657.0

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

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