PREVIEW / futures_1hour / 2014-11-10

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-10.parquet
  size:    50 KB
  rows:    1,515

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-10 00:00:00	ES	Futures	2123.77	2125.34	2123.25	2124.29	3298.0
2014-11-10 01:00:00	ES	Futures	2124.29	2125.08	2124.03	2124.82	2211.0
2014-11-10 02:00:00	ES	Futures	2124.56	2125.08	2117.74	2119.58	15235.0
2014-11-10 03:00:00	ES	Futures	2119.58	2125.08	2118.27	2124.03	25972.0
2014-11-10 04:00:00	ES	Futures	2124.03	2125.34	2120.89	2124.03	14825.0
2014-11-10 05:00:00	ES	Futures	2124.29	2126.91	2124.03	2124.56	10519.0
2014-11-10 06:00:00	ES	Futures	2124.82	2126.13	2123.77	2126.13	9984.0
2014-11-10 07:00:00	ES	Futures	2126.13	2126.91	2124.29	2126.13	16380.0
2014-11-10 08:00:00	ES	Futures	2125.87	2126.91	2124.29	2125.08	18191.0
2014-11-10 09:00:00	ES	Futures	2125.08	2127.18	2122.72	2125.08	141141.0
2014-11-10 10:00:00	ES	Futures	2124.82	2131.37	2122.98	2130.06	189173.0
2014-11-10 11:00:00	ES	Futures	2130.32	2132.41	2129.01	2130.32	141443.0
2014-11-10 12:00:00	ES	Futures	2130.06	2130.58	2128.48	2130.06	57971.0
2014-11-10 13:00:00	ES	Futures	2129.79	2131.37	2127.7	2128.48	50650.0
2014-11-10 14:00:00	ES	Futures	2128.22	2130.84	2127.96	2130.58	58278.0
2014-11-10 15:00:00	ES	Futures	2130.32	2132.15	2129.27	2131.63	121415.0
2014-11-10 16:00:00	ES	Futures	2131.37	2132.41	2130.84	2131.63	54767.0
2014-11-10 17:00:00	ES	Futures	2131.89	2132.41	2131.63	2131.63	1596.0
2014-11-10 18:00:00	ES	Futures	2131.1	2131.37	2129.27	2129.53	4952.0
2014-11-10 19:00:00	ES	Futures	2129.53	2131.37	2129.01	2130.84	4248.0
2014-11-10 20:00:00	ES	Futures	2130.58	2132.41	2130.32	2131.63	2427.0
2014-11-10 21:00:00	ES	Futures	2131.63	2131.89	2130.84	2131.63	1822.0
2014-11-10 22:00:00	ES	Futures	2131.63	2133.99	2131.37	2132.68	4521.0
2014-11-10 23:00:00	ES	Futures	2132.68	2136.61	2132.68	2136.08	6356.0
2014-11-10 00:00:00	NQ	Futures	4870.93	4873.86	4868.88	4872.39	663.0
2014-11-10 01:00:00	NQ	Futures	4872.1	4874.15	4871.81	4872.69	240.0
2014-11-10 02:00:00	NQ	Futures	4872.69	4873.27	4856.86	4861.55	1577.0
2014-11-10 03:00:00	NQ	Futures	4861.55	4876.49	4857.74	4873.56	4333.0
2014-11-10 04:00:00	NQ	Futures	4873.56	4876.49	4864.77	4872.39	2618.0
2014-11-10 05:00:00	NQ	Futures	4872.39	4880.6	4871.22	4871.22	2373.0
2014-11-10 06:00:00	NQ	Futures	4871.22	4876.2	4870.05	4876.2	1505.0
2014-11-10 07:00:00	NQ	Futures	4875.91	4880.3	4874.74	4877.67	2607.0
2014-11-10 08:00:00	NQ	Futures	4877.67	4879.72	4874.15	4876.79	3178.0
2014-11-10 09:00:00	NQ	Futures	4876.49	4877.96	4862.72	4868.88	26943.0
2014-11-10 10:00:00	NQ	Futures	4868.88	4893.2	4867.7	4889.09	31006.0
2014-11-10 11:00:00	NQ	Futures	4889.39	4897.3	4887.04	4891.73	25863.0
2014-11-10 12:00:00	NQ	Futures	4891.44	4892.32	4883.23	4885.87	12436.0
2014-11-10 13:00:00	NQ	Futures	4885.87	4891.73	4884.11	4885.87	9171.0
2014-11-10 14:00:00	NQ	Futures	4885.87	4892.9	4885.58	4891.14	10409.0
2014-11-10 15:00:00	NQ	Futures	4891.44	4894.07	4885.28	4890.85	20085.0
2014-11-10 16:00:00	NQ	Futures	4890.56	4892.61	4886.75	4889.09	5834.0
2014-11-10 17:00:00	NQ	Futures	4889.09	4890.56	4888.8	4888.8	66.0
2014-11-10 18:00:00	NQ	Futures	4887.92	4887.92	4883.82	4884.7	670.0
2014-11-10 19:00:00	NQ	Futures	4884.7	4887.92	4884.11	4886.46	675.0
2014-11-10 20:00:00	NQ	Futures	4887.04	4890.56	4885.58	4889.09	526.0
2014-11-10 21:00:00	NQ	Futures	4889.39	4889.68	4887.63	4889.68	451.0
2014-11-10 22:00:00	NQ	Futures	4889.68	4894.37	4889.68	4892.61	774.0
2014-11-10 23:00:00	NQ	Futures	4892.61	4901.11	4892.32	4900.23	1211.0
2014-11-10 00:00:00	YM	Futures	18210.4	18221.8	18205.2	18214.6	514.0
2014-11-10 01:00:00	YM	Futures	18214.6	18220.8	18213.5	18215.6	408.0

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

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