PREVIEW / futures_1hour / 2015-09-10

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-10.parquet
  size:    49 KB
  rows:    1,498

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
2015-09-10 00:00:00	ES	Futures	2069.28	2074.07	2066.09	2070.08	10320.0
2015-09-10 01:00:00	ES	Futures	2070.35	2080.2	2068.22	2077.8	13118.0
2015-09-10 02:00:00	ES	Futures	2077.54	2078.6	2070.88	2074.07	14274.0
2015-09-10 03:00:00	ES	Futures	2074.07	2083.66	2072.74	2081.53	38779.0
2015-09-10 04:00:00	ES	Futures	2081.26	2082.06	2068.22	2075.14	45239.0
2015-09-10 05:00:00	ES	Futures	2075.14	2095.11	2074.07	2089.52	55044.0
2015-09-10 06:00:00	ES	Futures	2089.52	2091.65	2073.54	2075.41	42325.0
2015-09-10 07:00:00	ES	Futures	2075.41	2075.41	2064.76	2066.35	35362.0
2015-09-10 08:00:00	ES	Futures	2066.35	2068.22	2053.84	2057.83	92710.0
2015-09-10 09:00:00	ES	Futures	2058.1	2073.28	2057.83	2063.42	225122.0
2015-09-10 10:00:00	ES	Futures	2063.69	2082.86	2060.5	2078.6	259112.0
2015-09-10 11:00:00	ES	Futures	2078.6	2078.87	2066.89	2076.47	208964.0
2015-09-10 12:00:00	ES	Futures	2076.74	2081.8	2073.28	2077.8	103964.0
2015-09-10 13:00:00	ES	Futures	2077.8	2092.98	2075.14	2087.65	144487.0
2015-09-10 14:00:00	ES	Futures	2087.92	2089.78	2078.33	2078.33	93045.0
2015-09-10 15:00:00	ES	Futures	2078.6	2081.8	2069.28	2077.8	235454.0
2015-09-10 16:00:00	ES	Futures	2077.8	2079.13	2073.01	2077.27	60440.0
2015-09-10 17:00:00	ES	Futures	2077.0	2078.6	2077.0	2078.33	717.0
2015-09-10 18:00:00	ES	Futures	2076.2	2079.67	2075.14	2079.67	1963.0
2015-09-10 19:00:00	ES	Futures	2079.67	2080.2	2073.54	2074.87	2602.0
2015-09-10 20:00:00	ES	Futures	2074.87	2083.13	2074.34	2077.8	5805.0
2015-09-10 21:00:00	ES	Futures	2078.6	2084.72	2078.6	2080.2	4194.0
2015-09-10 22:00:00	ES	Futures	2080.46	2086.06	2080.46	2085.26	2971.0
2015-09-10 23:00:00	ES	Futures	2084.99	2085.79	2081.53	2083.66	2237.0
2015-09-10 00:00:00	NQ	Futures	5033.15	5046.17	5025.17	5037.0	2025.0
2015-09-10 01:00:00	NQ	Futures	5038.48	5058.0	5032.86	5054.75	2426.0
2015-09-10 02:00:00	NQ	Futures	5055.34	5057.41	5039.07	5047.05	1586.0
2015-09-10 03:00:00	NQ	Futures	5046.46	5070.42	5043.51	5065.69	4845.0
2015-09-10 04:00:00	NQ	Futures	5066.28	5067.17	5033.45	5049.72	6199.0
2015-09-10 05:00:00	NQ	Futures	5049.13	5097.93	5047.35	5084.03	7914.0
2015-09-10 06:00:00	NQ	Futures	5084.03	5089.65	5046.17	5052.08	9136.0
2015-09-10 07:00:00	NQ	Futures	5051.49	5051.79	5025.76	5029.9	7066.0
2015-09-10 08:00:00	NQ	Futures	5029.6	5036.7	5000.62	5011.26	14775.0
2015-09-10 09:00:00	NQ	Futures	5010.97	5054.15	5010.97	5034.63	53145.0
2015-09-10 10:00:00	NQ	Futures	5034.63	5096.45	5023.39	5083.44	67851.0
2015-09-10 11:00:00	NQ	Futures	5083.44	5084.32	5051.2	5073.68	41789.0
2015-09-10 12:00:00	NQ	Futures	5073.68	5090.54	5069.83	5081.37	26898.0
2015-09-10 13:00:00	NQ	Futures	5081.07	5119.82	5073.38	5103.25	35542.0
2015-09-10 14:00:00	NQ	Futures	5103.25	5107.4	5078.41	5079.59	17342.0
2015-09-10 15:00:00	NQ	Futures	5079.3	5089.35	5059.18	5083.44	45875.0
2015-09-10 16:00:00	NQ	Futures	5083.44	5088.47	5073.38	5084.03	7771.0
2015-09-10 17:00:00	NQ	Futures	5084.92	5090.24	5084.92	5087.58	145.0
2015-09-10 18:00:00	NQ	Futures	5081.37	5092.9	5077.23	5092.31	369.0
2015-09-10 19:00:00	NQ	Futures	5091.42	5092.9	5074.86	5077.23	326.0
2015-09-10 20:00:00	NQ	Futures	5078.7	5099.41	5076.34	5088.17	631.0
2015-09-10 21:00:00	NQ	Futures	5088.17	5103.55	5088.17	5092.9	358.0
2015-09-10 22:00:00	NQ	Futures	5093.49	5107.1	5093.2	5103.25	501.0
2015-09-10 23:00:00	NQ	Futures	5103.25	5104.73	5096.45	5101.48	396.0
2015-09-10 00:00:00	YM	Futures	17143.0	17181.1	17114.4	17155.7	193.0
2015-09-10 01:00:00	YM	Futures	17155.7	17218.2	17149.3	17210.7	346.0

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

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