PREVIEW / futures_1hour / 2014-11-24

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-24.parquet
  size:    48 KB
  rows:    1,495

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-11-24 00:00:00	ES	Futures	2160.71	2161.49	2160.44	2160.44	1923.0
2014-11-24 01:00:00	ES	Futures	2160.71	2160.97	2160.18	2160.18	1113.0
2014-11-24 02:00:00	ES	Futures	2160.18	2164.64	2160.18	2161.75	12785.0
2014-11-24 03:00:00	ES	Futures	2162.02	2164.9	2160.18	2164.37	15571.0
2014-11-24 04:00:00	ES	Futures	2164.37	2166.47	2163.59	2164.64	19297.0
2014-11-24 05:00:00	ES	Futures	2164.64	2165.95	2163.59	2165.68	8690.0
2014-11-24 06:00:00	ES	Futures	2165.42	2166.21	2163.06	2164.37	13288.0
2014-11-24 07:00:00	ES	Futures	2164.64	2166.47	2164.37	2164.9	18501.0
2014-11-24 08:00:00	ES	Futures	2164.9	2167.26	2164.37	2166.47	22854.0
2014-11-24 09:00:00	ES	Futures	2166.73	2168.04	2163.06	2163.85	125809.0
2014-11-24 10:00:00	ES	Futures	2163.85	2167.52	2163.33	2165.95	127685.0
2014-11-24 11:00:00	ES	Futures	2165.68	2166.47	2163.33	2164.11	88278.0
2014-11-24 12:00:00	ES	Futures	2164.11	2165.95	2162.8	2163.59	48615.0
2014-11-24 13:00:00	ES	Futures	2163.59	2164.9	2163.33	2164.37	29406.0
2014-11-24 14:00:00	ES	Futures	2164.37	2166.73	2163.85	2164.37	65066.0
2014-11-24 15:00:00	ES	Futures	2164.37	2166.99	2163.33	2166.47	108356.0
2014-11-24 16:00:00	ES	Futures	2166.47	2166.99	2166.21	2166.47	48982.0
2014-11-24 17:00:00	ES	Futures	2166.73	2166.73	2166.21	2166.47	1746.0
2014-11-24 18:00:00	ES	Futures	2166.21	2168.04	2165.68	2167.52	4413.0
2014-11-24 19:00:00	ES	Futures	2167.52	2167.52	2165.42	2165.95	3645.0
2014-11-24 20:00:00	ES	Futures	2165.95	2165.95	2164.64	2165.68	3262.0
2014-11-24 21:00:00	ES	Futures	2165.42	2165.95	2163.85	2164.64	3149.0
2014-11-24 22:00:00	ES	Futures	2164.37	2164.64	2162.8	2163.33	4961.0
2014-11-24 23:00:00	ES	Futures	2163.06	2164.11	2163.06	2163.59	1422.0
2014-11-24 00:00:00	NQ	Futures	4981.1	4984.03	4981.1	4981.98	361.0
2014-11-24 01:00:00	NQ	Futures	4981.68	4982.27	4980.51	4981.1	98.0
2014-11-24 02:00:00	NQ	Futures	4980.8	4991.06	4980.8	4984.32	1423.0
2014-11-24 03:00:00	NQ	Futures	4984.32	4991.06	4979.93	4989.89	2620.0
2014-11-24 04:00:00	NQ	Futures	4990.18	4993.99	4989.3	4992.52	3110.0
2014-11-24 05:00:00	NQ	Futures	4992.23	4994.87	4989.59	4994.58	997.0
2014-11-24 06:00:00	NQ	Futures	4994.28	4996.04	4989.01	4993.11	1791.0
2014-11-24 07:00:00	NQ	Futures	4993.4	4996.92	4991.94	4992.82	2837.0
2014-11-24 08:00:00	NQ	Futures	4992.82	5000.44	4991.94	4998.09	4418.0
2014-11-24 09:00:00	NQ	Futures	4998.38	5007.17	4991.35	5003.66	34528.0
2014-11-24 10:00:00	NQ	Futures	5003.37	5013.62	5002.78	5008.35	26720.0
2014-11-24 11:00:00	NQ	Futures	5008.35	5012.74	5006.0	5012.45	12028.0
2014-11-24 12:00:00	NQ	Futures	5012.45	5017.72	5008.05	5012.16	13908.0
2014-11-24 13:00:00	NQ	Futures	5011.86	5017.72	5010.69	5017.43	8213.0
2014-11-24 14:00:00	NQ	Futures	5017.43	5021.24	5014.79	5018.02	12434.0
2014-11-24 15:00:00	NQ	Futures	5017.43	5024.17	5013.91	5021.53	22304.0
2014-11-24 16:00:00	NQ	Futures	5021.24	5021.53	5018.02	5019.48	7308.0
2014-11-24 17:00:00	NQ	Futures	5019.77	5020.36	5018.89	5019.77	216.0
2014-11-24 18:00:00	NQ	Futures	5018.6	5023.29	5016.84	5021.53	646.0
2014-11-24 19:00:00	NQ	Futures	5021.53	5021.83	5017.43	5018.31	920.0
2014-11-24 20:00:00	NQ	Futures	5018.02	5018.89	5015.96	5018.6	711.0
2014-11-24 21:00:00	NQ	Futures	5018.31	5018.6	5014.79	5015.96	646.0
2014-11-24 22:00:00	NQ	Futures	5015.67	5015.67	5012.45	5013.33	1064.0
2014-11-24 23:00:00	NQ	Futures	5013.03	5015.67	5013.03	5013.91	423.0
2014-11-24 00:00:00	YM	Futures	18488.0	18495.3	18487.0	18487.0	209.0
2014-11-24 01:00:00	YM	Futures	18487.0	18488.0	18483.9	18484.9	120.0

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

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