PREVIEW / futures_1hour / 2014-10-28

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-28.parquet
  size:    51 KB
  rows:    1,566

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-10-28 00:00:00	ES	Futures	2051.99	2055.13	2051.73	2054.61	4620.0
2014-10-28 01:00:00	ES	Futures	2054.35	2055.13	2053.04	2053.56	2391.0
2014-10-28 02:00:00	ES	Futures	2053.56	2055.13	2053.04	2054.61	2399.0
2014-10-28 03:00:00	ES	Futures	2054.87	2058.54	2054.61	2056.18	14134.0
2014-10-28 04:00:00	ES	Futures	2055.92	2063.26	2055.92	2060.37	46823.0
2014-10-28 05:00:00	ES	Futures	2060.37	2062.73	2059.59	2061.42	20085.0
2014-10-28 06:00:00	ES	Futures	2061.42	2062.21	2060.11	2060.9	18570.0
2014-10-28 07:00:00	ES	Futures	2061.16	2062.21	2059.59	2061.68	29855.0
2014-10-28 08:00:00	ES	Futures	2061.95	2062.21	2056.44	2056.97	52336.0
2014-10-28 09:00:00	ES	Futures	2056.97	2060.9	2055.13	2058.54	204425.0
2014-10-28 10:00:00	ES	Futures	2058.8	2061.68	2056.18	2059.06	233523.0
2014-10-28 11:00:00	ES	Futures	2059.33	2062.73	2057.75	2058.02	160179.0
2014-10-28 12:00:00	ES	Futures	2058.02	2061.16	2057.23	2059.33	116170.0
2014-10-28 13:00:00	ES	Futures	2059.59	2063.52	2059.06	2062.99	114067.0
2014-10-28 14:00:00	ES	Futures	2062.73	2065.61	2061.68	2064.83	133106.0
2014-10-28 15:00:00	ES	Futures	2064.56	2073.47	2064.56	2072.42	300596.0
2014-10-28 16:00:00	ES	Futures	2072.42	2075.57	2071.9	2074.26	94239.0
2014-10-28 17:00:00	ES	Futures	2074.26	2074.52	2073.73	2074.26	2487.0
2014-10-28 18:00:00	ES	Futures	2070.59	2071.9	2069.02	2069.54	11362.0
2014-10-28 19:00:00	ES	Futures	2069.28	2071.11	2069.02	2070.07	3762.0
2014-10-28 20:00:00	ES	Futures	2070.07	2072.42	2069.02	2072.42	6573.0
2014-10-28 21:00:00	ES	Futures	2072.16	2072.95	2070.33	2070.85	4963.0
2014-10-28 22:00:00	ES	Futures	2070.85	2071.64	2070.33	2070.85	3062.0
2014-10-28 23:00:00	ES	Futures	2070.85	2072.16	2069.8	2070.59	3939.0
2014-10-28 00:00:00	NQ	Futures	4735.85	4743.76	4735.27	4743.18	964.0
2014-10-28 01:00:00	NQ	Futures	4743.47	4744.06	4739.66	4740.83	320.0
2014-10-28 02:00:00	NQ	Futures	4740.83	4744.93	4740.54	4744.06	477.0
2014-10-28 03:00:00	NQ	Futures	4744.06	4753.43	4744.06	4746.4	1982.0
2014-10-28 04:00:00	NQ	Futures	4746.4	4762.22	4746.4	4757.83	7250.0
2014-10-28 05:00:00	NQ	Futures	4758.12	4762.51	4755.78	4760.76	3010.0
2014-10-28 06:00:00	NQ	Futures	4760.76	4761.93	4757.24	4759.29	2664.0
2014-10-28 07:00:00	NQ	Futures	4759.29	4761.93	4757.24	4761.05	3763.0
2014-10-28 08:00:00	NQ	Futures	4761.34	4761.34	4749.62	4750.79	8700.0
2014-10-28 09:00:00	NQ	Futures	4751.38	4774.53	4748.16	4770.43	41320.0
2014-10-28 10:00:00	NQ	Futures	4770.72	4777.75	4768.38	4774.24	43593.0
2014-10-28 11:00:00	NQ	Futures	4774.24	4783.9	4770.13	4770.43	27936.0
2014-10-28 12:00:00	NQ	Futures	4770.72	4776.29	4766.32	4771.31	22088.0
2014-10-28 13:00:00	NQ	Futures	4771.31	4785.37	4770.72	4783.9	17843.0
2014-10-28 14:00:00	NQ	Futures	4783.9	4790.35	4782.15	4784.49	20551.0
2014-10-28 15:00:00	NQ	Futures	4784.2	4805.0	4784.2	4803.54	40005.0
2014-10-28 16:00:00	NQ	Futures	4803.83	4805.0	4792.11	4797.68	13853.0
2014-10-28 17:00:00	NQ	Futures	4797.68	4797.97	4796.5	4796.8	221.0
2014-10-28 18:00:00	NQ	Futures	4782.73	4782.73	4771.01	4773.06	4532.0
2014-10-28 19:00:00	NQ	Futures	4773.06	4776.58	4772.48	4774.82	1266.0
2014-10-28 20:00:00	NQ	Futures	4774.53	4780.68	4773.36	4780.39	1110.0
2014-10-28 21:00:00	NQ	Futures	4780.39	4781.56	4777.17	4779.51	1097.0
2014-10-28 22:00:00	NQ	Futures	4779.22	4780.39	4777.75	4780.39	815.0
2014-10-28 23:00:00	NQ	Futures	4780.68	4782.15	4778.04	4778.04	794.0
2014-10-28 00:00:00	YM	Futures	17431.6	17453.5	17430.6	17451.4	715.0
2014-10-28 01:00:00	YM	Futures	17451.4	17455.5	17441.0	17442.0	498.0

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

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