PREVIEW / futures_1hour / 2014-08-22

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-22.parquet
  size:    41 KB
  rows:    1,258

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-08-22 00:00:00	ES	Futures	2075.27	2075.53	2074.49	2075.01	1286.0
2014-08-22 01:00:00	ES	Futures	2075.01	2075.79	2074.75	2075.53	1628.0
2014-08-22 02:00:00	ES	Futures	2075.27	2076.05	2074.49	2075.79	5694.0
2014-08-22 03:00:00	ES	Futures	2075.53	2076.05	2074.49	2075.53	12744.0
2014-08-22 04:00:00	ES	Futures	2075.53	2075.53	2074.49	2075.01	10032.0
2014-08-22 05:00:00	ES	Futures	2075.01	2075.01	2072.4	2072.92	16998.0
2014-08-22 06:00:00	ES	Futures	2072.92	2073.71	2067.19	2071.1	54648.0
2014-08-22 07:00:00	ES	Futures	2071.1	2074.23	2070.58	2073.71	25578.0
2014-08-22 08:00:00	ES	Futures	2073.44	2073.71	2069.8	2072.14	28957.0
2014-08-22 09:00:00	ES	Futures	2071.88	2073.44	2068.49	2071.88	110010.0
2014-08-22 10:00:00	ES	Futures	2071.88	2075.79	2066.41	2067.19	262374.0
2014-08-22 11:00:00	ES	Futures	2067.45	2072.4	2065.63	2071.1	176906.0
2014-08-22 12:00:00	ES	Futures	2071.1	2074.49	2070.06	2073.18	67217.0
2014-08-22 13:00:00	ES	Futures	2073.18	2074.49	2072.4	2073.18	52764.0
2014-08-22 14:00:00	ES	Futures	2073.18	2073.44	2069.01	2071.36	81201.0
2014-08-22 15:00:00	ES	Futures	2071.36	2074.23	2069.01	2070.32	133066.0
2014-08-22 16:00:00	ES	Futures	2070.58	2072.92	2070.06	2072.14	61025.0
2014-08-22 17:00:00	ES	Futures	2072.14	2072.66	2072.14	2072.14	987.0
2014-08-22 00:00:00	NQ	Futures	4731.51	4732.1	4730.35	4730.64	301.0
2014-08-22 01:00:00	NQ	Futures	4730.93	4732.39	4730.35	4731.81	419.0
2014-08-22 02:00:00	NQ	Futures	4731.51	4733.85	4730.35	4732.39	820.0
2014-08-22 03:00:00	NQ	Futures	4732.68	4732.97	4729.76	4731.22	1612.0
2014-08-22 04:00:00	NQ	Futures	4731.22	4731.51	4729.18	4731.22	840.0
2014-08-22 05:00:00	NQ	Futures	4730.93	4730.93	4725.38	4726.26	1888.0
2014-08-22 06:00:00	NQ	Futures	4726.26	4728.3	4714.87	4723.05	7611.0
2014-08-22 07:00:00	NQ	Futures	4723.05	4728.3	4721.29	4726.84	3518.0
2014-08-22 08:00:00	NQ	Futures	4726.84	4729.47	4722.46	4727.13	4468.0
2014-08-22 09:00:00	NQ	Futures	4727.13	4732.97	4718.08	4729.47	23189.0
2014-08-22 10:00:00	NQ	Futures	4729.18	4742.9	4721.59	4724.21	59931.0
2014-08-22 11:00:00	NQ	Futures	4723.92	4738.23	4719.83	4735.31	33225.0
2014-08-22 12:00:00	NQ	Futures	4735.6	4743.49	4732.68	4739.69	14876.0
2014-08-22 13:00:00	NQ	Futures	4739.69	4741.15	4735.31	4739.69	11620.0
2014-08-22 14:00:00	NQ	Futures	4739.69	4739.98	4730.05	4737.94	18779.0
2014-08-22 15:00:00	NQ	Futures	4737.94	4742.03	4731.22	4733.27	20727.0
2014-08-22 16:00:00	NQ	Futures	4733.27	4738.52	4732.68	4737.35	5033.0
2014-08-22 17:00:00	NQ	Futures	4737.65	4739.4	4737.65	4739.11	306.0
2014-08-22 00:00:00	YM	Futures	17616.6	17618.7	17613.5	17613.5	227.0
2014-08-22 01:00:00	YM	Futures	17615.6	17622.8	17614.5	17619.7	485.0
2014-08-22 02:00:00	YM	Futures	17619.7	17626.9	17614.5	17623.8	944.0
2014-08-22 03:00:00	YM	Futures	17623.8	17628.0	17615.6	17622.8	2531.0
2014-08-22 04:00:00	YM	Futures	17623.8	17623.8	17611.4	17615.6	1327.0
2014-08-22 05:00:00	YM	Futures	17615.6	17615.6	17596.9	17599.0	1988.0
2014-08-22 06:00:00	YM	Futures	17600.1	17607.3	17558.7	17586.6	7227.0
2014-08-22 07:00:00	YM	Futures	17587.6	17611.4	17582.5	17607.3	2859.0
2014-08-22 08:00:00	YM	Futures	17607.3	17607.3	17578.3	17595.9	3171.0
2014-08-22 09:00:00	YM	Futures	17594.9	17605.2	17574.2	17601.1	11921.0
2014-08-22 10:00:00	YM	Futures	17603.2	17634.2	17554.5	17559.7	24310.0
2014-08-22 11:00:00	YM	Futures	17558.7	17596.9	17547.3	17583.5	16570.0
2014-08-22 12:00:00	YM	Futures	17583.5	17606.3	17576.3	17594.9	6170.0
2014-08-22 13:00:00	YM	Futures	17594.9	17604.2	17587.6	17591.8	5432.0

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

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