PREVIEW / futures_1hour / 2014-09-30

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-30.parquet
  size:    51 KB
  rows:    1,597

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-30 00:00:00	ES	Futures	2064.04	2065.61	2063.52	2065.35	5351.0
2014-09-30 01:00:00	ES	Futures	2065.35	2065.61	2064.04	2064.56	3263.0
2014-09-30 02:00:00	ES	Futures	2064.56	2068.49	2064.3	2067.97	12265.0
2014-09-30 03:00:00	ES	Futures	2067.97	2068.23	2065.61	2067.97	18286.0
2014-09-30 04:00:00	ES	Futures	2067.97	2068.76	2066.4	2067.71	18323.0
2014-09-30 05:00:00	ES	Futures	2067.45	2072.16	2067.45	2070.85	29699.0
2014-09-30 06:00:00	ES	Futures	2070.85	2071.64	2069.02	2070.85	16087.0
2014-09-30 07:00:00	ES	Futures	2071.11	2072.16	2069.02	2071.11	26629.0
2014-09-30 08:00:00	ES	Futures	2071.38	2071.38	2068.49	2068.76	28432.0
2014-09-30 09:00:00	ES	Futures	2068.76	2069.02	2058.28	2061.16	268737.0
2014-09-30 10:00:00	ES	Futures	2061.16	2070.07	2056.71	2068.76	313984.0
2014-09-30 11:00:00	ES	Futures	2068.76	2072.95	2066.92	2067.97	204532.0
2014-09-30 12:00:00	ES	Futures	2067.97	2068.49	2059.33	2061.68	173279.0
2014-09-30 13:00:00	ES	Futures	2061.68	2065.61	2054.87	2058.02	195284.0
2014-09-30 14:00:00	ES	Futures	2057.75	2062.21	2055.13	2060.37	171627.0
2014-09-30 15:00:00	ES	Futures	2060.11	2065.09	2057.23	2059.33	319741.0
2014-09-30 16:00:00	ES	Futures	2059.33	2059.59	2054.61	2055.4	151522.0
2014-09-30 17:00:00	ES	Futures	2055.4	2055.66	2054.35	2054.61	3766.0
2014-09-30 18:00:00	ES	Futures	2054.87	2056.44	2053.82	2055.66	12334.0
2014-09-30 19:00:00	ES	Futures	2055.66	2055.92	2054.35	2055.13	2493.0
2014-09-30 20:00:00	ES	Futures	2055.13	2055.66	2052.78	2054.35	8739.0
2014-09-30 21:00:00	ES	Futures	2054.35	2055.66	2053.56	2055.13	5949.0
2014-09-30 22:00:00	ES	Futures	2055.13	2056.97	2055.13	2056.97	4414.0
2014-09-30 23:00:00	ES	Futures	2056.97	2058.8	2056.44	2057.23	5220.0
2014-09-30 00:00:00	NQ	Futures	4729.99	4734.97	4729.41	4734.39	586.0
2014-09-30 01:00:00	NQ	Futures	4734.39	4734.68	4730.87	4732.04	428.0
2014-09-30 02:00:00	NQ	Futures	4732.34	4741.71	4732.04	4741.42	2576.0
2014-09-30 03:00:00	NQ	Futures	4741.13	4743.76	4736.44	4742.88	3939.0
2014-09-30 04:00:00	NQ	Futures	4743.18	4744.35	4739.95	4742.0	2899.0
2014-09-30 05:00:00	NQ	Futures	4742.0	4752.26	4742.0	4750.21	6823.0
2014-09-30 06:00:00	NQ	Futures	4750.21	4751.67	4746.4	4750.5	2599.0
2014-09-30 07:00:00	NQ	Futures	4750.5	4761.93	4750.5	4758.12	9796.0
2014-09-30 08:00:00	NQ	Futures	4757.83	4758.12	4751.09	4751.67	6062.0
2014-09-30 09:00:00	NQ	Futures	4751.97	4753.43	4719.74	4731.75	58786.0
2014-09-30 10:00:00	NQ	Futures	4731.46	4755.78	4716.51	4751.97	54108.0
2014-09-30 11:00:00	NQ	Futures	4751.67	4763.98	4750.5	4754.6	39498.0
2014-09-30 12:00:00	NQ	Futures	4754.6	4757.53	4734.97	4742.88	28328.0
2014-09-30 13:00:00	NQ	Futures	4742.59	4751.97	4725.6	4731.46	28306.0
2014-09-30 14:00:00	NQ	Futures	4731.75	4739.66	4722.37	4735.85	30182.0
2014-09-30 15:00:00	NQ	Futures	4735.56	4750.5	4729.11	4740.54	41713.0
2014-09-30 16:00:00	NQ	Futures	4740.83	4741.71	4729.11	4731.46	14459.0
2014-09-30 17:00:00	NQ	Futures	4731.46	4731.46	4727.94	4729.7	278.0
2014-09-30 18:00:00	NQ	Futures	4730.58	4733.8	4727.06	4730.28	2008.0
2014-09-30 19:00:00	NQ	Futures	4730.28	4730.87	4727.06	4729.99	990.0
2014-09-30 20:00:00	NQ	Futures	4729.99	4730.58	4722.67	4727.35	1607.0
2014-09-30 21:00:00	NQ	Futures	4727.65	4731.16	4725.01	4730.58	803.0
2014-09-30 22:00:00	NQ	Futures	4730.58	4734.97	4730.58	4734.09	961.0
2014-09-30 23:00:00	NQ	Futures	4734.39	4737.61	4732.92	4733.51	1491.0
2014-09-30 00:00:00	YM	Futures	17658.3	17674.9	17657.3	17673.9	505.0
2014-09-30 01:00:00	YM	Futures	17673.9	17674.9	17659.3	17661.4	995.0

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

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