PREVIEW / futures_1hour / 2013-12-26

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-26.parquet
  size:    32 KB
  rows:    954

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
2013-12-26 06:00:00	ES	Futures	1893.34	1896.96	1893.08	1895.15	9848.0
2013-12-26 07:00:00	ES	Futures	1894.89	1895.93	1893.6	1894.89	3224.0
2013-12-26 08:00:00	ES	Futures	1894.89	1896.45	1894.12	1896.45	8577.0
2013-12-26 09:00:00	ES	Futures	1896.19	1896.7	1894.38	1894.89	69011.0
2013-12-26 10:00:00	ES	Futures	1894.89	1897.22	1894.89	1895.93	58015.0
2013-12-26 11:00:00	ES	Futures	1896.19	1898.0	1895.15	1897.22	45237.0
2013-12-26 12:00:00	ES	Futures	1896.96	1898.77	1896.19	1898.26	47517.0
2013-12-26 13:00:00	ES	Futures	1898.26	1900.33	1898.0	1900.07	36457.0
2013-12-26 14:00:00	ES	Futures	1900.33	1900.58	1898.77	1900.07	38730.0
2013-12-26 15:00:00	ES	Futures	1899.81	1901.36	1899.29	1900.07	85757.0
2013-12-26 16:00:00	ES	Futures	1900.33	1900.33	1899.29	1900.07	34458.0
2013-12-26 17:00:00	ES	Futures	1900.07	1900.33	1900.07	1900.07	888.0
2013-12-26 18:00:00	ES	Futures	1900.07	1900.07	1898.77	1898.77	2138.0
2013-12-26 19:00:00	ES	Futures	1898.77	1899.55	1897.74	1898.0	3848.0
2013-12-26 20:00:00	ES	Futures	1898.0	1898.0	1896.96	1898.0	3280.0
2013-12-26 21:00:00	ES	Futures	1898.0	1898.77	1897.74	1898.26	2348.0
2013-12-26 22:00:00	ES	Futures	1898.26	1899.03	1898.0	1898.77	1522.0
2013-12-26 23:00:00	ES	Futures	1898.77	1899.03	1898.26	1898.52	1681.0
2013-12-26 06:00:00	NQ	Futures	4154.18	4161.15	4151.56	4155.92	1150.0
2013-12-26 07:00:00	NQ	Futures	4155.92	4158.25	4154.76	4157.08	335.0
2013-12-26 08:00:00	NQ	Futures	4157.66	4159.99	4156.21	4159.12	867.0
2013-12-26 09:00:00	NQ	Futures	4159.12	4160.57	4148.94	4149.52	10471.0
2013-12-26 10:00:00	NQ	Futures	4149.23	4159.7	4149.23	4157.95	9214.0
2013-12-26 11:00:00	NQ	Futures	4157.95	4163.77	4157.08	4160.28	6088.0
2013-12-26 12:00:00	NQ	Futures	4160.28	4163.19	4158.54	4162.9	4872.0
2013-12-26 13:00:00	NQ	Futures	4163.19	4165.51	4161.44	4165.51	4617.0
2013-12-26 14:00:00	NQ	Futures	4165.22	4165.51	4159.99	4162.9	3584.0
2013-12-26 15:00:00	NQ	Futures	4162.9	4166.38	4162.02	4162.61	10135.0
2013-12-26 16:00:00	NQ	Futures	4162.9	4166.09	4161.73	4166.09	2412.0
2013-12-26 17:00:00	NQ	Futures	4166.09	4166.97	4165.51	4166.68	264.0
2013-12-26 18:00:00	NQ	Futures	4165.8	4166.09	4163.19	4163.48	314.0
2013-12-26 19:00:00	NQ	Futures	4163.48	4163.77	4159.41	4160.28	595.0
2013-12-26 20:00:00	NQ	Futures	4160.28	4162.02	4159.99	4162.02	426.0
2013-12-26 21:00:00	NQ	Futures	4162.02	4163.48	4162.02	4162.31	329.0
2013-12-26 22:00:00	NQ	Futures	4162.61	4165.22	4162.61	4164.35	341.0
2013-12-26 23:00:00	NQ	Futures	4164.35	4165.22	4164.35	4164.35	191.0
2013-12-26 06:00:00	YM	Futures	16720.2	16783.8	16720.2	16758.2	2385.0
2013-12-26 07:00:00	YM	Futures	16757.1	16763.3	16751.0	16760.2	725.0
2013-12-26 08:00:00	YM	Futures	16760.2	16770.5	16757.1	16769.4	745.0
2013-12-26 09:00:00	YM	Futures	16771.5	16781.7	16752.0	16779.7	7259.0
2013-12-26 10:00:00	YM	Futures	16779.7	16787.9	16763.3	16770.5	5379.0
2013-12-26 11:00:00	YM	Futures	16770.5	16791.0	16764.3	16785.8	3304.0
2013-12-26 12:00:00	YM	Futures	16786.9	16807.4	16782.8	16804.3	3063.0
2013-12-26 13:00:00	YM	Futures	16804.3	16834.0	16804.3	16831.0	4646.0
2013-12-26 14:00:00	YM	Futures	16831.0	16838.1	16821.7	16826.9	3757.0
2013-12-26 15:00:00	YM	Futures	16827.9	16839.2	16825.8	16835.1	5038.0
2013-12-26 16:00:00	YM	Futures	16834.0	16843.3	16826.9	16841.2	1381.0
2013-12-26 17:00:00	YM	Futures	16841.2	16845.3	16840.2	16845.3	119.0
2013-12-26 18:00:00	YM	Futures	16843.3	16843.3	16827.9	16828.9	322.0
2013-12-26 19:00:00	YM	Futures	16828.9	16834.0	16811.5	16812.5	930.0

> showing 50 of 954 rows — these rows as CSV

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