PREVIEW / futures_1hour / 2014-07-25

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-25.parquet
  size:    42 KB
  rows:    1,257

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-07-25 00:00:00	ES	Futures	2063.54	2063.54	2061.98	2062.24	1042.0
2014-07-25 01:00:00	ES	Futures	2062.24	2063.8	2061.98	2063.28	2670.0
2014-07-25 02:00:00	ES	Futures	2063.28	2064.84	2063.02	2064.58	6258.0
2014-07-25 03:00:00	ES	Futures	2064.58	2064.84	2062.76	2064.06	20716.0
2014-07-25 04:00:00	ES	Futures	2064.06	2064.84	2063.28	2063.28	15607.0
2014-07-25 05:00:00	ES	Futures	2063.28	2064.06	2061.46	2061.46	16320.0
2014-07-25 06:00:00	ES	Futures	2061.46	2062.5	2059.37	2060.67	22656.0
2014-07-25 07:00:00	ES	Futures	2060.94	2063.02	2060.15	2062.24	14413.0
2014-07-25 08:00:00	ES	Futures	2061.98	2062.24	2060.94	2061.72	24134.0
2014-07-25 09:00:00	ES	Futures	2061.72	2061.72	2056.24	2059.89	227548.0
2014-07-25 10:00:00	ES	Futures	2059.89	2061.46	2056.5	2057.29	178721.0
2014-07-25 11:00:00	ES	Futures	2057.03	2057.29	2051.55	2055.2	264302.0
2014-07-25 12:00:00	ES	Futures	2055.2	2058.07	2055.2	2057.55	100520.0
2014-07-25 13:00:00	ES	Futures	2057.55	2057.55	2053.64	2053.64	112688.0
2014-07-25 14:00:00	ES	Futures	2053.9	2057.55	2052.6	2055.98	103023.0
2014-07-25 15:00:00	ES	Futures	2055.98	2056.24	2053.38	2055.98	213523.0
2014-07-25 16:00:00	ES	Futures	2055.98	2056.24	2054.68	2054.94	80148.0
2014-07-25 17:00:00	ES	Futures	2054.94	2054.94	2054.16	2054.42	1845.0
2014-07-25 00:00:00	NQ	Futures	4627.85	4628.43	4624.93	4624.93	258.0
2014-07-25 01:00:00	NQ	Futures	4625.51	4629.31	4625.22	4628.72	357.0
2014-07-25 02:00:00	NQ	Futures	4629.31	4631.35	4628.14	4631.06	723.0
2014-07-25 03:00:00	NQ	Futures	4631.06	4631.94	4626.97	4629.89	2847.0
2014-07-25 04:00:00	NQ	Futures	4629.6	4631.35	4627.85	4628.43	3057.0
2014-07-25 05:00:00	NQ	Futures	4628.14	4629.6	4623.18	4623.18	3077.0
2014-07-25 06:00:00	NQ	Futures	4623.18	4625.8	4619.96	4624.05	3464.0
2014-07-25 07:00:00	NQ	Futures	4624.05	4628.43	4622.01	4627.26	2527.0
2014-07-25 08:00:00	NQ	Futures	4627.26	4627.26	4621.72	4622.59	4729.0
2014-07-25 09:00:00	NQ	Futures	4622.3	4625.51	4609.16	4622.88	38785.0
2014-07-25 10:00:00	NQ	Futures	4623.18	4629.89	4607.7	4610.62	31106.0
2014-07-25 11:00:00	NQ	Futures	4610.33	4613.83	4599.23	4611.79	39001.0
2014-07-25 12:00:00	NQ	Futures	4611.79	4623.18	4611.79	4622.3	15032.0
2014-07-25 13:00:00	NQ	Futures	4622.3	4622.3	4613.25	4615.0	15632.0
2014-07-25 14:00:00	NQ	Futures	4615.29	4622.59	4611.79	4617.04	15752.0
2014-07-25 15:00:00	NQ	Futures	4617.04	4623.18	4613.25	4622.88	23914.0
2014-07-25 16:00:00	NQ	Futures	4623.18	4624.64	4618.8	4619.67	4786.0
2014-07-25 17:00:00	NQ	Futures	4619.38	4620.84	4619.09	4620.55	114.0
2014-07-25 00:00:00	YM	Futures	17577.3	17578.3	17561.8	17562.8	1080.0
2014-07-25 01:00:00	YM	Futures	17562.8	17580.4	17561.8	17580.4	884.0
2014-07-25 02:00:00	YM	Futures	17580.4	17591.8	17576.3	17590.7	1889.0
2014-07-25 03:00:00	YM	Futures	17589.7	17591.8	17573.2	17582.5	2979.0
2014-07-25 04:00:00	YM	Futures	17582.5	17588.7	17576.3	17576.3	2578.0
2014-07-25 05:00:00	YM	Futures	17575.2	17580.4	17560.7	17560.7	2548.0
2014-07-25 06:00:00	YM	Futures	17560.7	17566.9	17545.2	17556.6	3725.0
2014-07-25 07:00:00	YM	Futures	17556.6	17576.3	17553.5	17572.1	3003.0
2014-07-25 08:00:00	YM	Futures	17572.1	17572.1	17555.6	17559.7	3900.0
2014-07-25 09:00:00	YM	Futures	17559.7	17559.7	17473.8	17497.6	31965.0
2014-07-25 10:00:00	YM	Futures	17498.7	17504.9	17458.3	17463.5	20024.0
2014-07-25 11:00:00	YM	Futures	17462.5	17471.8	17427.3	17461.4	27881.0
2014-07-25 12:00:00	YM	Futures	17460.4	17482.1	17459.4	17478.0	7556.0
2014-07-25 13:00:00	YM	Futures	17478.0	17478.0	17444.9	17445.9	9931.0

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

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