PREVIEW / futures_1hour / 2014-09-22

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-22.parquet
  size:    50 KB
  rows:    1,562

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-22 00:00:00	ES	Futures	2087.62	2088.93	2087.36	2088.67	3237.0
2014-09-22 01:00:00	ES	Futures	2088.67	2089.98	2088.4	2089.45	5325.0
2014-09-22 02:00:00	ES	Futures	2089.19	2089.98	2087.36	2087.88	12852.0
2014-09-22 03:00:00	ES	Futures	2087.88	2089.45	2087.36	2088.4	25497.0
2014-09-22 04:00:00	ES	Futures	2088.4	2090.76	2088.14	2089.71	19368.0
2014-09-22 05:00:00	ES	Futures	2089.98	2091.02	2089.19	2090.24	9625.0
2014-09-22 06:00:00	ES	Futures	2090.24	2093.12	2089.98	2093.12	16591.0
2014-09-22 07:00:00	ES	Futures	2093.12	2094.43	2091.81	2092.6	19305.0
2014-09-22 08:00:00	ES	Futures	2092.6	2093.64	2091.02	2092.86	24865.0
2014-09-22 09:00:00	ES	Futures	2092.86	2094.95	2089.19	2090.5	169305.0
2014-09-22 10:00:00	ES	Futures	2090.76	2093.38	2082.12	2083.43	341984.0
2014-09-22 11:00:00	ES	Futures	2083.16	2085.26	2079.5	2080.54	202399.0
2014-09-22 12:00:00	ES	Futures	2080.54	2083.16	2078.71	2081.85	138064.0
2014-09-22 13:00:00	ES	Futures	2081.85	2084.21	2079.76	2080.54	127706.0
2014-09-22 14:00:00	ES	Futures	2080.81	2081.85	2077.4	2080.54	155449.0
2014-09-22 15:00:00	ES	Futures	2080.54	2083.43	2078.19	2081.85	169463.0
2014-09-22 16:00:00	ES	Futures	2081.85	2082.38	2079.76	2079.76	78688.0
2014-09-22 17:00:00	ES	Futures	2080.02	2080.02	2077.66	2078.45	6012.0
2014-09-22 18:00:00	ES	Futures	2078.97	2080.54	2078.97	2080.54	5869.0
2014-09-22 19:00:00	ES	Futures	2080.54	2080.54	2079.5	2080.02	1886.0
2014-09-22 20:00:00	ES	Futures	2080.02	2080.81	2080.02	2080.28	2559.0
2014-09-22 21:00:00	ES	Futures	2080.54	2081.85	2079.76	2081.59	9616.0
2014-09-22 22:00:00	ES	Futures	2081.85	2082.12	2080.81	2081.07	4101.0
2014-09-22 23:00:00	ES	Futures	2081.07	2082.64	2081.07	2082.64	2931.0
2014-09-22 00:00:00	NQ	Futures	4770.72	4773.36	4770.13	4772.18	551.0
2014-09-22 01:00:00	NQ	Futures	4772.18	4775.41	4771.89	4773.36	877.0
2014-09-22 02:00:00	NQ	Futures	4773.94	4775.41	4766.62	4769.25	2495.0
2014-09-22 03:00:00	NQ	Futures	4768.96	4772.18	4765.15	4766.32	3326.0
2014-09-22 04:00:00	NQ	Futures	4766.62	4771.89	4765.45	4769.25	2800.0
2014-09-22 05:00:00	NQ	Futures	4769.55	4771.89	4767.2	4770.43	1644.0
2014-09-22 06:00:00	NQ	Futures	4770.43	4781.27	4770.43	4780.68	3236.0
2014-09-22 07:00:00	NQ	Futures	4780.68	4783.9	4779.22	4779.8	2658.0
2014-09-22 08:00:00	NQ	Futures	4779.8	4784.78	4775.7	4780.39	6272.0
2014-09-22 09:00:00	NQ	Futures	4780.68	4785.37	4771.31	4774.24	34671.0
2014-09-22 10:00:00	NQ	Futures	4774.53	4781.56	4742.0	4745.81	68465.0
2014-09-22 11:00:00	NQ	Futures	4745.23	4750.5	4733.51	4738.49	41896.0
2014-09-22 12:00:00	NQ	Futures	4738.78	4743.76	4732.04	4740.83	26343.0
2014-09-22 13:00:00	NQ	Futures	4740.83	4742.88	4733.51	4734.39	22734.0
2014-09-22 14:00:00	NQ	Futures	4734.39	4746.11	4729.99	4744.06	27851.0
2014-09-22 15:00:00	NQ	Futures	4744.35	4754.9	4739.95	4750.79	34946.0
2014-09-22 16:00:00	NQ	Futures	4750.79	4752.55	4745.52	4746.4	5970.0
2014-09-22 17:00:00	NQ	Futures	4746.11	4746.69	4740.25	4740.25	501.0
2014-09-22 18:00:00	NQ	Futures	4740.25	4746.4	4740.25	4745.81	1174.0
2014-09-22 19:00:00	NQ	Futures	4745.81	4746.69	4743.47	4744.06	240.0
2014-09-22 20:00:00	NQ	Futures	4744.35	4746.69	4744.35	4745.52	474.0
2014-09-22 21:00:00	NQ	Futures	4745.52	4749.92	4744.35	4749.33	932.0
2014-09-22 22:00:00	NQ	Futures	4749.04	4749.62	4745.52	4746.69	414.0
2014-09-22 23:00:00	NQ	Futures	4746.69	4750.79	4745.52	4750.79	472.0
2014-09-22 00:00:00	YM	Futures	17807.0	17819.5	17807.0	17818.4	1415.0
2014-09-22 01:00:00	YM	Futures	17818.4	17833.0	17818.4	17826.7	2605.0

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

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