PREVIEW / futures_1hour / 2014-09-25

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-25.parquet
  size:    51 KB
  rows:    1,568

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-09-25 00:00:00	ES	Futures	2084.47	2085.0	2084.21	2085.0	1035.0
2014-09-25 01:00:00	ES	Futures	2085.0	2085.78	2084.74	2085.52	1602.0
2014-09-25 02:00:00	ES	Futures	2085.26	2085.52	2082.38	2082.64	8709.0
2014-09-25 03:00:00	ES	Futures	2082.64	2085.52	2082.38	2084.74	22382.0
2014-09-25 04:00:00	ES	Futures	2084.47	2086.57	2084.21	2085.26	14458.0
2014-09-25 05:00:00	ES	Futures	2085.26	2085.78	2084.21	2085.0	8207.0
2014-09-25 06:00:00	ES	Futures	2085.0	2086.31	2083.95	2085.78	11754.0
2014-09-25 07:00:00	ES	Futures	2085.52	2086.83	2085.0	2085.78	13004.0
2014-09-25 08:00:00	ES	Futures	2085.78	2085.78	2080.02	2080.54	47009.0
2014-09-25 09:00:00	ES	Futures	2080.54	2081.33	2068.49	2070.33	320693.0
2014-09-25 10:00:00	ES	Futures	2070.59	2071.38	2055.66	2061.68	599629.0
2014-09-25 11:00:00	ES	Futures	2061.68	2062.47	2056.71	2057.23	294101.0
2014-09-25 12:00:00	ES	Futures	2057.49	2060.37	2053.3	2055.92	197546.0
2014-09-25 13:00:00	ES	Futures	2055.92	2058.8	2052.25	2053.56	170228.0
2014-09-25 14:00:00	ES	Futures	2053.82	2058.8	2051.99	2055.92	177851.0
2014-09-25 15:00:00	ES	Futures	2055.92	2059.06	2051.99	2052.25	272030.0
2014-09-25 16:00:00	ES	Futures	2052.25	2057.49	2051.47	2054.87	136160.0
2014-09-25 17:00:00	ES	Futures	2054.87	2055.92	2054.87	2055.92	1579.0
2014-09-25 18:00:00	ES	Futures	2054.87	2056.97	2054.87	2056.44	4640.0
2014-09-25 19:00:00	ES	Futures	2056.44	2058.02	2056.44	2057.75	3030.0
2014-09-25 20:00:00	ES	Futures	2058.02	2058.28	2056.97	2057.23	6019.0
2014-09-25 21:00:00	ES	Futures	2057.23	2058.28	2056.97	2057.75	3787.0
2014-09-25 22:00:00	ES	Futures	2058.02	2058.54	2057.23	2058.02	3575.0
2014-09-25 23:00:00	ES	Futures	2058.02	2058.28	2056.97	2057.23	1964.0
2014-09-25 00:00:00	NQ	Futures	4786.25	4788.3	4785.96	4787.71	265.0
2014-09-25 01:00:00	NQ	Futures	4788.01	4789.76	4787.71	4789.47	219.0
2014-09-25 02:00:00	NQ	Futures	4789.18	4789.76	4782.44	4783.32	1176.0
2014-09-25 03:00:00	NQ	Futures	4783.32	4790.35	4781.85	4789.18	3576.0
2014-09-25 04:00:00	NQ	Futures	4788.89	4791.82	4785.96	4788.59	2293.0
2014-09-25 05:00:00	NQ	Futures	4788.89	4789.47	4785.66	4787.71	1320.0
2014-09-25 06:00:00	NQ	Futures	4787.71	4790.35	4784.78	4788.59	1969.0
2014-09-25 07:00:00	NQ	Futures	4788.3	4790.64	4787.13	4788.59	1507.0
2014-09-25 08:00:00	NQ	Futures	4788.3	4788.3	4773.65	4775.99	9462.0
2014-09-25 09:00:00	NQ	Futures	4775.7	4780.68	4737.02	4742.3	65249.0
2014-09-25 10:00:00	NQ	Futures	4742.3	4744.93	4700.1	4713.58	120148.0
2014-09-25 11:00:00	NQ	Futures	4713.88	4714.17	4697.47	4698.35	68239.0
2014-09-25 12:00:00	NQ	Futures	4698.35	4708.02	4689.85	4697.17	41782.0
2014-09-25 13:00:00	NQ	Futures	4696.88	4707.43	4686.33	4691.9	32967.0
2014-09-25 14:00:00	NQ	Futures	4691.61	4703.03	4686.04	4695.12	32403.0
2014-09-25 15:00:00	NQ	Futures	4695.12	4704.5	4688.38	4688.38	45182.0
2014-09-25 16:00:00	NQ	Futures	4688.38	4700.69	4687.51	4695.71	12254.0
2014-09-25 17:00:00	NQ	Futures	4695.42	4696.88	4694.83	4696.88	152.0
2014-09-25 18:00:00	NQ	Futures	4693.95	4700.69	4693.95	4699.81	1151.0
2014-09-25 19:00:00	NQ	Futures	4700.1	4702.45	4699.81	4702.16	478.0
2014-09-25 20:00:00	NQ	Futures	4702.16	4703.03	4700.69	4700.98	848.0
2014-09-25 21:00:00	NQ	Futures	4700.69	4703.33	4700.69	4702.16	415.0
2014-09-25 22:00:00	NQ	Futures	4701.86	4703.62	4700.69	4702.74	382.0
2014-09-25 23:00:00	NQ	Futures	4703.03	4703.03	4699.81	4700.69	408.0
2014-09-25 00:00:00	YM	Futures	17803.9	17809.1	17801.8	17808.0	224.0
2014-09-25 01:00:00	YM	Futures	17808.0	17814.3	17807.0	17814.3	290.0

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

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