PREVIEW / futures_1hour / 2014-08-25

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-25.parquet
  size:    43 KB
  rows:    1,400

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-08-25 00:00:00	ES	Futures	2079.18	2079.7	2078.66	2079.44	4832.0
2014-08-25 01:00:00	ES	Futures	2079.18	2080.74	2078.14	2079.44	7808.0
2014-08-25 02:00:00	ES	Futures	2079.7	2082.31	2079.44	2081.0	18492.0
2014-08-25 03:00:00	ES	Futures	2081.0	2082.05	2079.18	2079.44	14773.0
2014-08-25 04:00:00	ES	Futures	2079.44	2079.96	2078.14	2078.14	11282.0
2014-08-25 05:00:00	ES	Futures	2078.14	2078.92	2077.35	2077.61	7592.0
2014-08-25 06:00:00	ES	Futures	2077.35	2079.44	2077.35	2078.66	9036.0
2014-08-25 07:00:00	ES	Futures	2078.66	2080.48	2078.14	2079.96	12026.0
2014-08-25 08:00:00	ES	Futures	2079.96	2081.26	2078.92	2081.26	19213.0
2014-08-25 09:00:00	ES	Futures	2081.26	2082.57	2077.88	2081.52	112936.0
2014-08-25 10:00:00	ES	Futures	2081.78	2084.39	2079.96	2083.61	154603.0
2014-08-25 11:00:00	ES	Futures	2083.87	2084.65	2082.83	2083.61	90168.0
2014-08-25 12:00:00	ES	Futures	2083.61	2083.87	2078.4	2079.18	91589.0
2014-08-25 13:00:00	ES	Futures	2078.92	2081.52	2077.35	2080.74	74206.0
2014-08-25 14:00:00	ES	Futures	2080.74	2081.0	2078.66	2080.22	48430.0
2014-08-25 15:00:00	ES	Futures	2080.48	2081.26	2079.44	2081.0	101193.0
2014-08-25 16:00:00	ES	Futures	2080.74	2081.26	2079.18	2079.18	47545.0
2014-08-25 17:00:00	ES	Futures	2079.44	2079.7	2079.18	2079.7	1348.0
2014-08-25 18:00:00	ES	Futures	2079.18	2079.96	2078.66	2079.44	4232.0
2014-08-25 19:00:00	ES	Futures	2079.44	2080.22	2079.44	2079.96	1181.0
2014-08-25 20:00:00	ES	Futures	2079.96	2080.22	2078.14	2078.4	3418.0
2014-08-25 21:00:00	ES	Futures	2078.4	2078.92	2078.14	2078.14	3342.0
2014-08-25 22:00:00	ES	Futures	2078.14	2078.4	2077.88	2077.88	2054.0
2014-08-25 23:00:00	ES	Futures	2078.14	2078.4	2077.09	2077.35	3259.0
2014-08-25 00:00:00	NQ	Futures	4754.29	4756.04	4754.0	4755.17	906.0
2014-08-25 01:00:00	NQ	Futures	4755.17	4758.09	4752.25	4756.04	1586.0
2014-08-25 02:00:00	NQ	Futures	4756.04	4762.76	4755.75	4758.67	2781.0
2014-08-25 03:00:00	NQ	Futures	4758.96	4761.59	4756.04	4757.21	2404.0
2014-08-25 04:00:00	NQ	Futures	4756.92	4758.09	4752.83	4753.42	2226.0
2014-08-25 05:00:00	NQ	Futures	4753.12	4755.17	4752.54	4753.12	1378.0
2014-08-25 06:00:00	NQ	Futures	4753.12	4756.04	4753.12	4754.58	1918.0
2014-08-25 07:00:00	NQ	Futures	4754.58	4758.38	4752.54	4756.63	2361.0
2014-08-25 08:00:00	NQ	Futures	4756.63	4758.09	4754.0	4757.8	3611.0
2014-08-25 09:00:00	NQ	Futures	4757.8	4760.72	4754.0	4758.96	21301.0
2014-08-25 10:00:00	NQ	Futures	4759.26	4763.93	4754.0	4761.01	29982.0
2014-08-25 11:00:00	NQ	Futures	4761.01	4761.88	4757.5	4759.55	16105.0
2014-08-25 12:00:00	NQ	Futures	4759.84	4760.13	4741.73	4745.82	26787.0
2014-08-25 13:00:00	NQ	Futures	4745.82	4753.42	4738.52	4749.33	19017.0
2014-08-25 14:00:00	NQ	Futures	4749.33	4750.49	4744.07	4749.03	11096.0
2014-08-25 15:00:00	NQ	Futures	4748.74	4753.71	4747.87	4749.91	15471.0
2014-08-25 16:00:00	NQ	Futures	4750.2	4751.37	4745.82	4746.41	4642.0
2014-08-25 17:00:00	NQ	Futures	4746.41	4748.74	4746.11	4748.16	607.0
2014-08-25 18:00:00	NQ	Futures	4747.28	4749.03	4745.82	4747.87	452.0
2014-08-25 19:00:00	NQ	Futures	4747.87	4749.62	4747.57	4749.33	162.0
2014-08-25 20:00:00	NQ	Futures	4749.33	4749.91	4746.41	4746.99	484.0
2014-08-25 21:00:00	NQ	Futures	4746.99	4747.28	4746.11	4746.99	413.0
2014-08-25 22:00:00	NQ	Futures	4747.28	4747.57	4746.11	4746.41	381.0
2014-08-25 23:00:00	NQ	Futures	4746.41	4746.7	4744.36	4745.53	291.0
2014-08-25 00:00:00	YM	Futures	17632.1	17636.3	17630.1	17634.2	491.0
2014-08-25 01:00:00	YM	Futures	17635.2	17644.5	17623.8	17636.3	1424.0

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

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