PREVIEW / futures_1hour / 2016-01-07

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-07.parquet
  size:    56 KB
  rows:    1,630

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
2016-01-07 00:00:00	ES	Futures	2108.83	2112.59	2103.99	2106.14	16894.0
2016-01-07 01:00:00	ES	Futures	2106.14	2106.14	2097.81	2103.19	22265.0
2016-01-07 02:00:00	ES	Futures	2103.45	2104.8	2092.97	2099.42	45056.0
2016-01-07 03:00:00	ES	Futures	2099.15	2104.8	2079.0	2080.88	93160.0
2016-01-07 04:00:00	ES	Futures	2081.15	2084.91	2075.51	2083.57	78544.0
2016-01-07 05:00:00	ES	Futures	2083.57	2087.87	2076.05	2082.23	57064.0
2016-01-07 06:00:00	ES	Futures	2082.23	2090.02	2081.96	2086.26	41756.0
2016-01-07 07:00:00	ES	Futures	2086.26	2092.17	2083.84	2088.94	47541.0
2016-01-07 08:00:00	ES	Futures	2088.94	2094.32	2083.3	2092.97	75134.0
2016-01-07 09:00:00	ES	Futures	2093.24	2107.48	2090.56	2102.92	380950.0
2016-01-07 10:00:00	ES	Futures	2102.92	2116.35	2097.27	2113.67	352797.0
2016-01-07 11:00:00	ES	Futures	2113.93	2115.81	2102.92	2103.45	228549.0
2016-01-07 12:00:00	ES	Futures	2103.19	2106.41	2097.27	2098.08	151454.0
2016-01-07 13:00:00	ES	Futures	2097.81	2098.62	2078.73	2084.38	312010.0
2016-01-07 14:00:00	ES	Futures	2084.38	2091.9	2077.12	2083.03	275787.0
2016-01-07 15:00:00	ES	Futures	2083.03	2090.29	2074.7	2079.54	465654.0
2016-01-07 16:00:00	ES	Futures	2079.81	2081.69	2072.82	2079.27	146839.0
2016-01-07 18:00:00	ES	Futures	2081.42	2082.76	2072.82	2080.88	13865.0
2016-01-07 19:00:00	ES	Futures	2080.88	2084.91	2078.46	2079.27	16056.0
2016-01-07 20:00:00	ES	Futures	2079.27	2107.22	2078.73	2095.66	91261.0
2016-01-07 21:00:00	ES	Futures	2095.66	2101.3	2093.51	2095.12	20543.0
2016-01-07 22:00:00	ES	Futures	2095.12	2102.38	2094.86	2097.81	13128.0
2016-01-07 23:00:00	ES	Futures	2098.08	2098.89	2094.05	2097.54	9117.0
2016-01-07 00:00:00	NQ	Futures	5213.52	5224.21	5200.75	5205.21	2950.0
2016-01-07 01:00:00	NQ	Futures	5204.61	5204.61	5187.09	5200.75	3755.0
2016-01-07 02:00:00	NQ	Futures	5200.75	5206.1	5168.39	5184.42	8477.0
2016-01-07 03:00:00	NQ	Futures	5184.42	5198.38	5125.03	5130.97	17648.0
2016-01-07 04:00:00	NQ	Futures	5130.97	5136.91	5109.3	5131.86	14568.0
2016-01-07 05:00:00	NQ	Futures	5131.57	5141.07	5103.95	5111.67	13603.0
2016-01-07 06:00:00	NQ	Futures	5111.67	5134.54	5111.38	5125.03	6271.0
2016-01-07 07:00:00	NQ	Futures	5125.03	5140.77	5118.5	5135.43	7759.0
2016-01-07 08:00:00	NQ	Futures	5134.83	5149.98	5118.21	5148.2	14343.0
2016-01-07 09:00:00	NQ	Futures	5148.49	5186.2	5141.96	5173.43	56650.0
2016-01-07 10:00:00	NQ	Futures	5172.84	5220.05	5155.03	5214.41	58370.0
2016-01-07 11:00:00	NQ	Futures	5214.11	5220.94	5181.45	5183.83	35578.0
2016-01-07 12:00:00	NQ	Futures	5184.12	5193.33	5164.82	5167.5	26273.0
2016-01-07 13:00:00	NQ	Futures	5166.9	5168.68	5106.03	5119.39	58992.0
2016-01-07 14:00:00	NQ	Futures	5119.69	5147.3	5099.2	5125.03	54449.0
2016-01-07 15:00:00	NQ	Futures	5124.44	5138.1	5102.17	5102.77	69525.0
2016-01-07 16:00:00	NQ	Futures	5102.47	5108.11	5087.03	5099.2	16112.0
2016-01-07 18:00:00	NQ	Futures	5104.84	5108.41	5084.65	5103.06	2257.0
2016-01-07 19:00:00	NQ	Futures	5103.06	5113.16	5097.42	5100.39	2762.0
2016-01-07 20:00:00	NQ	Futures	5100.69	5170.47	5099.2	5141.96	14862.0
2016-01-07 21:00:00	NQ	Futures	5142.85	5155.92	5135.13	5138.1	3966.0
2016-01-07 22:00:00	NQ	Futures	5137.8	5160.07	5137.21	5149.09	2281.0
2016-01-07 23:00:00	NQ	Futures	5149.38	5152.95	5140.77	5150.87	1984.0
2016-01-07 00:00:00	YM	Futures	17716.1	17744.9	17682.0	17698.0	3187.0
2016-01-07 01:00:00	YM	Futures	17697.0	17699.1	17632.0	17670.3	4731.0
2016-01-07 02:00:00	YM	Futures	17669.3	17682.0	17589.4	17636.3	7730.0
2016-01-07 03:00:00	YM	Futures	17636.3	17675.7	17472.3	17490.4	14019.0

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

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