PREVIEW / futures_1hour / 2014-01-10

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-10.parquet
  size:    44 KB
  rows:    1,285

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-10 00:00:00	ES	Futures	1898.52	1899.29	1898.52	1899.29	2626.0
2014-01-10 01:00:00	ES	Futures	1899.03	1899.55	1899.03	1899.55	2297.0
2014-01-10 02:00:00	ES	Futures	1899.29	1900.33	1898.52	1899.55	5591.0
2014-01-10 03:00:00	ES	Futures	1899.55	1901.1	1899.29	1900.84	14460.0
2014-01-10 04:00:00	ES	Futures	1900.84	1901.88	1900.07	1901.1	12514.0
2014-01-10 05:00:00	ES	Futures	1901.1	1903.17	1900.84	1903.17	9977.0
2014-01-10 06:00:00	ES	Futures	1902.91	1903.43	1902.14	1902.65	10708.0
2014-01-10 07:00:00	ES	Futures	1902.91	1904.46	1902.39	1903.95	18492.0
2014-01-10 08:00:00	ES	Futures	1903.95	1906.27	1892.31	1901.62	216544.0
2014-01-10 09:00:00	ES	Futures	1901.36	1902.39	1896.45	1896.45	207166.0
2014-01-10 10:00:00	ES	Futures	1896.7	1896.7	1890.76	1894.89	279838.0
2014-01-10 11:00:00	ES	Futures	1894.89	1895.41	1889.46	1891.27	161415.0
2014-01-10 12:00:00	ES	Futures	1891.27	1897.22	1890.24	1893.86	123486.0
2014-01-10 13:00:00	ES	Futures	1894.12	1896.96	1893.34	1893.86	77000.0
2014-01-10 14:00:00	ES	Futures	1894.12	1896.7	1893.86	1895.15	65945.0
2014-01-10 15:00:00	ES	Futures	1895.15	1900.84	1894.89	1900.84	161852.0
2014-01-10 16:00:00	ES	Futures	1900.84	1902.39	1900.33	1902.14	68606.0
2014-01-10 17:00:00	ES	Futures	1902.14	1902.39	1901.88	1902.14	1171.0
2014-01-10 00:00:00	NQ	Futures	4131.5	4132.37	4131.21	4132.37	393.0
2014-01-10 01:00:00	NQ	Futures	4132.37	4134.7	4132.37	4134.12	382.0
2014-01-10 02:00:00	NQ	Futures	4134.41	4135.86	4132.66	4133.83	340.0
2014-01-10 03:00:00	NQ	Futures	4134.12	4139.64	4134.12	4139.35	1954.0
2014-01-10 04:00:00	NQ	Futures	4138.77	4141.39	4137.9	4139.35	1822.0
2014-01-10 05:00:00	NQ	Futures	4139.06	4145.75	4139.06	4145.46	1698.0
2014-01-10 06:00:00	NQ	Futures	4145.16	4148.07	4144.29	4146.62	1775.0
2014-01-10 07:00:00	NQ	Futures	4146.62	4150.4	4145.75	4149.82	1943.0
2014-01-10 08:00:00	NQ	Futures	4149.82	4153.3	4113.77	4135.57	31669.0
2014-01-10 09:00:00	NQ	Futures	4135.57	4143.42	4125.98	4128.3	37126.0
2014-01-10 10:00:00	NQ	Futures	4128.01	4128.3	4112.03	4124.82	53498.0
2014-01-10 11:00:00	NQ	Futures	4124.82	4126.56	4103.89	4110.57	42050.0
2014-01-10 12:00:00	NQ	Futures	4110.57	4120.46	4107.38	4113.48	23943.0
2014-01-10 13:00:00	NQ	Futures	4113.48	4124.82	4112.32	4117.55	13286.0
2014-01-10 14:00:00	NQ	Futures	4117.84	4124.53	4116.97	4120.75	11037.0
2014-01-10 15:00:00	NQ	Futures	4120.46	4139.06	4119.87	4138.48	33510.0
2014-01-10 16:00:00	NQ	Futures	4138.19	4142.84	4137.9	4142.55	4256.0
2014-01-10 17:00:00	NQ	Futures	4142.55	4143.71	4142.55	4143.13	139.0
2014-01-10 00:00:00	YM	Futures	16825.8	16833.0	16824.8	16832.0	393.0
2014-01-10 01:00:00	YM	Futures	16832.0	16835.1	16829.9	16831.0	433.0
2014-01-10 02:00:00	YM	Futures	16831.0	16840.2	16822.8	16828.9	613.0
2014-01-10 03:00:00	YM	Futures	16829.9	16844.3	16829.9	16839.2	1790.0
2014-01-10 04:00:00	YM	Futures	16840.2	16848.4	16832.0	16841.2	1642.0
2014-01-10 05:00:00	YM	Futures	16840.2	16861.7	16839.2	16860.7	1209.0
2014-01-10 06:00:00	YM	Futures	16860.7	16863.8	16854.5	16859.7	1234.0
2014-01-10 07:00:00	YM	Futures	16860.7	16872.0	16856.6	16869.9	1927.0
2014-01-10 08:00:00	YM	Futures	16869.9	16878.1	16768.4	16843.3	16590.0
2014-01-10 09:00:00	YM	Futures	16843.3	16851.5	16786.9	16788.9	20026.0
2014-01-10 10:00:00	YM	Futures	16791.0	16791.0	16737.7	16766.4	25194.0
2014-01-10 11:00:00	YM	Futures	16766.4	16774.6	16731.5	16742.8	17202.0
2014-01-10 12:00:00	YM	Futures	16741.8	16784.8	16734.6	16756.1	13006.0
2014-01-10 13:00:00	YM	Futures	16757.1	16776.6	16740.7	16744.8	9134.0

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

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