PREVIEW / futures_1hour / 2014-09-11

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-11.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
2014-09-11 00:00:00	ES	Futures	2077.35	2078.14	2077.35	2077.35	2033.0
2014-09-11 01:00:00	ES	Futures	2077.61	2077.61	2076.57	2077.09	2906.0
2014-09-11 02:00:00	ES	Futures	2077.09	2078.14	2077.09	2077.88	5015.0
2014-09-11 03:00:00	ES	Futures	2077.88	2078.14	2075.79	2077.61	20649.0
2014-09-11 04:00:00	ES	Futures	2077.88	2077.88	2072.14	2074.49	23405.0
2014-09-11 05:00:00	ES	Futures	2074.23	2076.05	2072.92	2075.53	16946.0
2014-09-11 06:00:00	ES	Futures	2075.27	2076.31	2073.44	2073.44	14497.0
2014-09-11 07:00:00	ES	Futures	2073.44	2074.75	2071.62	2071.88	27612.0
2014-09-11 08:00:00	ES	Futures	2071.62	2073.18	2069.28	2070.32	47264.0
2014-09-11 09:00:00	ES	Futures	2070.06	2077.61	2069.8	2077.09	182703.0
2014-09-11 10:00:00	ES	Futures	2077.35	2078.14	2069.54	2072.92	237628.0
2014-09-11 11:00:00	ES	Futures	2073.18	2078.4	2072.92	2077.09	146476.0
2014-09-11 12:00:00	ES	Futures	2077.09	2080.22	2075.53	2077.35	93645.0
2014-09-11 13:00:00	ES	Futures	2077.35	2078.4	2073.44	2075.53	83668.0
2014-09-11 14:00:00	ES	Futures	2075.27	2080.74	2075.01	2079.18	91886.0
2014-09-11 15:00:00	ES	Futures	2079.18	2082.31	2077.61	2081.78	135874.0
2014-09-11 16:00:00	ES	Futures	2081.52	2084.13	2081.0	2083.87	53853.0
2014-09-11 17:00:00	ES	Futures	2083.87	2084.39	2083.61	2083.87	2279.0
2014-09-11 18:00:00	ES	Futures	2084.13	2084.13	2081.78	2082.31	5736.0
2014-09-11 19:00:00	ES	Futures	2082.05	2082.57	2081.78	2081.78	1403.0
2014-09-11 20:00:00	ES	Futures	2082.05	2082.57	2081.78	2082.57	1369.0
2014-09-11 21:00:00	ES	Futures	2082.83	2083.09	2081.52	2082.05	2156.0
2014-09-11 22:00:00	ES	Futures	2082.05	2082.05	2081.52	2082.05	1358.0
2014-09-11 23:00:00	ES	Futures	2082.05	2082.31	2081.78	2082.05	470.0
2014-09-11 00:00:00	NQ	Futures	4778.82	4781.16	4778.53	4779.7	713.0
2014-09-11 01:00:00	NQ	Futures	4779.7	4779.7	4777.36	4779.11	381.0
2014-09-11 02:00:00	NQ	Futures	4778.24	4780.86	4778.24	4780.28	581.0
2014-09-11 03:00:00	NQ	Futures	4780.28	4780.57	4775.32	4779.99	2932.0
2014-09-11 04:00:00	NQ	Futures	4780.28	4780.28	4765.97	4770.64	3965.0
2014-09-11 05:00:00	NQ	Futures	4770.64	4775.61	4767.72	4773.56	2862.0
2014-09-11 06:00:00	NQ	Futures	4773.56	4775.32	4768.89	4769.77	3507.0
2014-09-11 07:00:00	NQ	Futures	4769.48	4773.56	4766.26	4766.85	4996.0
2014-09-11 08:00:00	NQ	Futures	4766.85	4770.06	4758.67	4760.13	9695.0
2014-09-11 09:00:00	NQ	Futures	4760.13	4775.61	4756.92	4775.02	35999.0
2014-09-11 10:00:00	NQ	Futures	4775.02	4775.9	4749.03	4757.21	45772.0
2014-09-11 11:00:00	NQ	Futures	4757.21	4769.77	4755.75	4764.22	26358.0
2014-09-11 12:00:00	NQ	Futures	4764.22	4771.23	4756.34	4760.42	18693.0
2014-09-11 13:00:00	NQ	Futures	4760.72	4762.47	4742.32	4747.87	28332.0
2014-09-11 14:00:00	NQ	Futures	4748.16	4768.02	4747.28	4764.51	23627.0
2014-09-11 15:00:00	NQ	Futures	4764.51	4781.16	4762.76	4779.11	31193.0
2014-09-11 16:00:00	NQ	Futures	4779.4	4784.66	4777.65	4784.37	5201.0
2014-09-11 17:00:00	NQ	Futures	4784.66	4785.54	4783.78	4784.95	445.0
2014-09-11 18:00:00	NQ	Futures	4784.95	4784.95	4778.82	4780.57	997.0
2014-09-11 19:00:00	NQ	Futures	4780.57	4781.45	4779.7	4779.99	259.0
2014-09-11 20:00:00	NQ	Futures	4779.7	4782.03	4779.7	4780.86	219.0
2014-09-11 21:00:00	NQ	Futures	4780.86	4782.91	4779.11	4779.4	390.0
2014-09-11 22:00:00	NQ	Futures	4779.99	4780.57	4779.4	4780.28	94.0
2014-09-11 23:00:00	NQ	Futures	4780.57	4780.86	4779.99	4780.28	105.0
2014-09-11 00:00:00	YM	Futures	17641.7	17641.7	17641.7	17641.7	4.0
2014-09-11 01:00:00	YM	Futures	17637.5	17638.5	17632.3	17637.5	19.0

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

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