PREVIEW / futures_1hour / 2014-09-26

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-26.parquet
  size:    43 KB
  rows:    1,280

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-26 00:00:00	ES	Futures	2057.49	2058.02	2057.23	2057.75	1799.0
2014-09-26 01:00:00	ES	Futures	2057.75	2058.28	2057.23	2057.23	2337.0
2014-09-26 02:00:00	ES	Futures	2057.49	2058.54	2056.18	2056.71	8606.0
2014-09-26 03:00:00	ES	Futures	2056.71	2056.97	2052.25	2054.35	42262.0
2014-09-26 04:00:00	ES	Futures	2054.09	2056.71	2053.04	2054.35	22932.0
2014-09-26 05:00:00	ES	Futures	2054.61	2059.85	2053.82	2058.28	30202.0
2014-09-26 06:00:00	ES	Futures	2058.54	2058.8	2055.66	2057.75	14852.0
2014-09-26 07:00:00	ES	Futures	2057.49	2058.8	2056.18	2056.97	18421.0
2014-09-26 08:00:00	ES	Futures	2056.71	2061.42	2054.09	2054.61	77725.0
2014-09-26 09:00:00	ES	Futures	2054.35	2058.8	2050.16	2056.44	291537.0
2014-09-26 10:00:00	ES	Futures	2056.71	2062.73	2055.66	2059.59	314566.0
2014-09-26 11:00:00	ES	Futures	2059.59	2061.42	2053.56	2055.92	174636.0
2014-09-26 12:00:00	ES	Futures	2055.92	2059.59	2055.92	2058.02	86902.0
2014-09-26 13:00:00	ES	Futures	2058.02	2062.73	2057.49	2061.95	78428.0
2014-09-26 14:00:00	ES	Futures	2062.21	2074.0	2061.95	2071.38	231095.0
2014-09-26 15:00:00	ES	Futures	2071.38	2072.95	2067.71	2069.02	174196.0
2014-09-26 16:00:00	ES	Futures	2069.28	2071.11	2068.76	2070.33	78661.0
2014-09-26 17:00:00	ES	Futures	2070.59	2070.59	2068.49	2068.76	2486.0
2014-09-26 00:00:00	NQ	Futures	4700.4	4702.45	4700.4	4702.45	256.0
2014-09-26 01:00:00	NQ	Futures	4702.45	4702.74	4700.98	4700.98	281.0
2014-09-26 02:00:00	NQ	Futures	4701.57	4703.91	4697.47	4698.64	1513.0
2014-09-26 03:00:00	NQ	Futures	4698.93	4701.86	4690.14	4698.64	6457.0
2014-09-26 04:00:00	NQ	Futures	4698.64	4703.62	4694.54	4698.64	3271.0
2014-09-26 05:00:00	NQ	Futures	4698.35	4712.12	4696.88	4709.48	5778.0
2014-09-26 06:00:00	NQ	Futures	4709.48	4710.36	4696.59	4700.98	5431.0
2014-09-26 07:00:00	NQ	Futures	4701.28	4706.26	4698.05	4701.86	3798.0
2014-09-26 08:00:00	NQ	Futures	4701.86	4712.41	4699.52	4700.4	12749.0
2014-09-26 09:00:00	NQ	Futures	4700.4	4710.65	4692.78	4706.55	52183.0
2014-09-26 10:00:00	NQ	Futures	4706.26	4718.86	4699.52	4709.48	53704.0
2014-09-26 11:00:00	NQ	Futures	4709.19	4713.0	4695.71	4700.69	33929.0
2014-09-26 12:00:00	NQ	Futures	4700.98	4709.77	4700.69	4705.96	17054.0
2014-09-26 13:00:00	NQ	Futures	4705.96	4715.93	4705.96	4715.05	13347.0
2014-09-26 14:00:00	NQ	Futures	4715.34	4747.28	4714.76	4741.71	43202.0
2014-09-26 15:00:00	NQ	Futures	4741.71	4745.23	4734.39	4740.54	41846.0
2014-09-26 16:00:00	NQ	Futures	4740.54	4746.4	4739.07	4742.88	11292.0
2014-09-26 17:00:00	NQ	Futures	4742.0	4742.59	4738.49	4739.37	218.0
2014-09-26 00:00:00	YM	Futures	17587.6	17595.9	17587.6	17595.9	380.0
2014-09-26 01:00:00	YM	Futures	17597.0	17600.1	17592.8	17592.8	435.0
2014-09-26 02:00:00	YM	Futures	17593.8	17598.0	17579.3	17584.5	1374.0
2014-09-26 03:00:00	YM	Futures	17584.5	17588.6	17551.2	17573.0	5496.0
2014-09-26 04:00:00	YM	Futures	17573.0	17590.7	17565.8	17575.1	2243.0
2014-09-26 05:00:00	YM	Futures	17574.1	17614.6	17569.9	17603.2	3537.0
2014-09-26 06:00:00	YM	Futures	17603.2	17607.3	17584.5	17599.0	2380.0
2014-09-26 07:00:00	YM	Futures	17600.1	17606.3	17590.7	17594.9	2429.0
2014-09-26 08:00:00	YM	Futures	17595.9	17630.2	17585.5	17588.6	9180.0
2014-09-26 09:00:00	YM	Futures	17588.6	17622.9	17565.8	17592.8	25218.0
2014-09-26 10:00:00	YM	Futures	17592.8	17643.7	17586.6	17619.8	24720.0
2014-09-26 11:00:00	YM	Futures	17619.8	17634.4	17578.2	17597.0	15591.0
2014-09-26 12:00:00	YM	Futures	17597.0	17624.0	17595.9	17613.6	7732.0
2014-09-26 13:00:00	YM	Futures	17613.6	17645.8	17611.5	17640.6	6608.0

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

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