PREVIEW / futures_1hour / 2014-09-09

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-09.parquet
  size:    48 KB
  rows:    1,504

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-09 00:00:00	ES	Futures	2082.05	2082.31	2081.0	2081.78	3461.0
2014-09-09 01:00:00	ES	Futures	2081.78	2082.31	2081.52	2082.05	1369.0
2014-09-09 02:00:00	ES	Futures	2082.31	2083.87	2082.05	2083.09	5215.0
2014-09-09 03:00:00	ES	Futures	2083.09	2087.0	2083.09	2084.91	29959.0
2014-09-09 04:00:00	ES	Futures	2084.91	2085.17	2082.57	2083.35	12672.0
2014-09-09 05:00:00	ES	Futures	2083.35	2084.91	2082.57	2084.91	7462.0
2014-09-09 06:00:00	ES	Futures	2084.91	2086.48	2084.39	2086.48	8673.0
2014-09-09 07:00:00	ES	Futures	2086.48	2088.04	2085.95	2086.74	16452.0
2014-09-09 08:00:00	ES	Futures	2086.48	2086.74	2083.61	2084.65	26870.0
2014-09-09 09:00:00	ES	Futures	2084.39	2084.65	2076.05	2076.57	226903.0
2014-09-09 10:00:00	ES	Futures	2076.57	2078.92	2073.97	2077.09	268033.0
2014-09-09 11:00:00	ES	Futures	2077.09	2080.74	2076.57	2078.92	148345.0
2014-09-09 12:00:00	ES	Futures	2078.66	2080.48	2076.83	2077.88	79008.0
2014-09-09 13:00:00	ES	Futures	2077.61	2084.39	2075.01	2083.35	208186.0
2014-09-09 14:00:00	ES	Futures	2083.61	2083.61	2074.23	2075.79	243942.0
2014-09-09 15:00:00	ES	Futures	2076.05	2076.05	2067.45	2071.88	339265.0
2014-09-09 16:00:00	ES	Futures	2071.88	2074.49	2071.36	2073.71	77927.0
2014-09-09 17:00:00	ES	Futures	2073.97	2074.23	2073.44	2073.97	2502.0
2014-09-09 18:00:00	ES	Futures	2073.97	2074.49	2073.18	2073.44	5200.0
2014-09-09 19:00:00	ES	Futures	2073.44	2073.44	2071.1	2072.14	5297.0
2014-09-09 20:00:00	ES	Futures	2072.14	2072.92	2071.62	2072.66	3341.0
2014-09-09 21:00:00	ES	Futures	2072.4	2073.44	2072.14	2072.4	3600.0
2014-09-09 22:00:00	ES	Futures	2072.4	2072.4	2070.58	2070.58	3781.0
2014-09-09 23:00:00	ES	Futures	2070.58	2071.62	2070.06	2071.36	3793.0
2014-09-09 00:00:00	NQ	Futures	4772.69	4773.27	4771.52	4772.98	708.0
2014-09-09 01:00:00	NQ	Futures	4772.69	4774.44	4772.4	4772.69	443.0
2014-09-09 02:00:00	NQ	Futures	4772.98	4776.19	4772.4	4773.86	1389.0
2014-09-09 03:00:00	NQ	Futures	4773.86	4783.78	4773.86	4779.99	4158.0
2014-09-09 04:00:00	NQ	Futures	4779.7	4780.57	4775.9	4777.65	2216.0
2014-09-09 05:00:00	NQ	Futures	4777.65	4781.74	4775.61	4781.74	1752.0
2014-09-09 06:00:00	NQ	Futures	4781.74	4786.7	4781.45	4786.41	2104.0
2014-09-09 07:00:00	NQ	Futures	4786.41	4790.79	4785.83	4787.58	3388.0
2014-09-09 08:00:00	NQ	Futures	4787.58	4787.58	4780.28	4783.2	4695.0
2014-09-09 09:00:00	NQ	Futures	4783.49	4783.49	4764.22	4767.72	41675.0
2014-09-09 10:00:00	NQ	Futures	4767.72	4776.78	4763.93	4765.97	38170.0
2014-09-09 11:00:00	NQ	Futures	4765.97	4776.19	4763.64	4772.4	19344.0
2014-09-09 12:00:00	NQ	Futures	4772.1	4778.53	4768.89	4773.56	13733.0
2014-09-09 13:00:00	NQ	Futures	4773.86	4801.31	4756.63	4797.51	77324.0
2014-09-09 14:00:00	NQ	Futures	4797.22	4800.14	4756.04	4762.76	80466.0
2014-09-09 15:00:00	NQ	Futures	4762.76	4763.05	4734.43	4743.49	78847.0
2014-09-09 16:00:00	NQ	Futures	4743.49	4750.49	4742.9	4748.45	5328.0
2014-09-09 17:00:00	NQ	Futures	4748.45	4750.2	4746.41	4748.16	1704.0
2014-09-09 18:00:00	NQ	Futures	4748.74	4750.79	4746.41	4746.7	549.0
2014-09-09 19:00:00	NQ	Futures	4747.28	4747.57	4742.03	4744.07	539.0
2014-09-09 20:00:00	NQ	Futures	4744.07	4746.41	4744.07	4746.41	478.0
2014-09-09 21:00:00	NQ	Futures	4746.11	4747.57	4744.07	4744.36	557.0
2014-09-09 22:00:00	NQ	Futures	4744.36	4744.36	4739.98	4739.98	951.0
2014-09-09 23:00:00	NQ	Futures	4739.69	4743.19	4738.81	4742.32	692.0
2014-09-09 00:00:00	YM	Futures	17669.4	17670.4	17664.2	17667.3	567.0
2014-09-09 01:00:00	YM	Futures	17667.3	17671.4	17662.1	17669.4	1231.0

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

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