PREVIEW / futures_1hour / 2016-01-13

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-13.parquet
  size:    55 KB
  rows:    1,641

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-13 00:00:00	ES	Futures	2089.48	2089.48	2083.57	2087.33	11435.0
2016-01-13 01:00:00	ES	Futures	2087.33	2088.41	2082.49	2083.03	11994.0
2016-01-13 02:00:00	ES	Futures	2083.3	2085.72	2076.58	2085.18	22656.0
2016-01-13 03:00:00	ES	Futures	2084.91	2092.17	2081.15	2087.87	51265.0
2016-01-13 04:00:00	ES	Futures	2087.87	2091.36	2084.38	2084.91	28459.0
2016-01-13 05:00:00	ES	Futures	2084.64	2087.06	2083.03	2084.91	11357.0
2016-01-13 06:00:00	ES	Futures	2084.91	2084.91	2079.0	2080.08	17598.0
2016-01-13 07:00:00	ES	Futures	2079.81	2084.11	2079.0	2079.54	25138.0
2016-01-13 08:00:00	ES	Futures	2079.54	2089.21	2077.12	2085.45	68335.0
2016-01-13 09:00:00	ES	Futures	2085.45	2088.68	2077.66	2080.35	254915.0
2016-01-13 10:00:00	ES	Futures	2080.35	2083.84	2066.91	2075.78	371648.0
2016-01-13 11:00:00	ES	Futures	2075.78	2078.2	2061.54	2062.88	299700.0
2016-01-13 12:00:00	ES	Futures	2062.88	2065.57	2053.21	2054.55	200931.0
2016-01-13 13:00:00	ES	Futures	2054.82	2057.77	2038.7	2039.77	267117.0
2016-01-13 14:00:00	ES	Futures	2040.04	2043.8	2018.54	2029.02	499362.0
2016-01-13 15:00:00	ES	Futures	2029.02	2037.89	2020.15	2023.65	525597.0
2016-01-13 16:00:00	ES	Futures	2023.38	2027.95	2021.23	2023.92	135106.0
2016-01-13 18:00:00	ES	Futures	2024.72	2027.68	2023.38	2023.38	11533.0
2016-01-13 19:00:00	ES	Futures	2023.65	2026.87	2022.04	2024.19	16341.0
2016-01-13 20:00:00	ES	Futures	2024.19	2026.07	2014.78	2025.8	34055.0
2016-01-13 21:00:00	ES	Futures	2025.53	2029.02	2022.57	2026.6	19541.0
2016-01-13 22:00:00	ES	Futures	2026.33	2030.37	2024.99	2025.53	12073.0
2016-01-13 23:00:00	ES	Futures	2025.8	2026.6	2018.54	2023.65	13248.0
2016-01-13 00:00:00	NQ	Futures	5171.36	5171.65	5156.21	5165.71	1827.0
2016-01-13 01:00:00	NQ	Futures	5165.71	5167.79	5152.95	5154.73	1469.0
2016-01-13 02:00:00	NQ	Futures	5155.32	5163.64	5140.48	5162.75	3533.0
2016-01-13 03:00:00	NQ	Futures	5161.85	5184.42	5151.16	5173.43	8086.0
2016-01-13 04:00:00	NQ	Futures	5173.43	5182.64	5163.93	5164.82	4614.0
2016-01-13 05:00:00	NQ	Futures	5164.82	5171.95	5159.78	5165.12	3004.0
2016-01-13 06:00:00	NQ	Futures	5164.23	5164.53	5152.95	5155.92	3441.0
2016-01-13 07:00:00	NQ	Futures	5155.62	5165.42	5150.87	5152.06	3096.0
2016-01-13 08:00:00	NQ	Futures	5152.35	5171.06	5146.12	5160.67	7776.0
2016-01-13 09:00:00	NQ	Futures	5160.67	5168.98	5134.83	5140.77	44567.0
2016-01-13 10:00:00	NQ	Futures	5140.77	5148.79	5111.38	5125.33	65386.0
2016-01-13 11:00:00	NQ	Futures	5125.33	5138.1	5085.84	5090.29	56076.0
2016-01-13 12:00:00	NQ	Futures	5090.0	5096.53	5064.16	5067.43	32197.0
2016-01-13 13:00:00	NQ	Futures	5067.43	5076.04	5006.86	5010.12	50130.0
2016-01-13 14:00:00	NQ	Futures	5010.42	5017.84	4950.14	4986.66	105229.0
2016-01-13 15:00:00	NQ	Futures	4986.66	5012.2	4949.55	4956.97	91223.0
2016-01-13 16:00:00	NQ	Futures	4956.67	4971.22	4953.11	4963.5	15623.0
2016-01-13 18:00:00	NQ	Futures	4966.47	4970.63	4958.16	4958.16	1684.0
2016-01-13 19:00:00	NQ	Futures	4958.16	4967.66	4953.41	4959.94	2748.0
2016-01-13 20:00:00	NQ	Futures	4959.64	4968.26	4937.67	4966.77	5631.0
2016-01-13 21:00:00	NQ	Futures	4967.36	4976.27	4959.94	4968.85	2549.0
2016-01-13 22:00:00	NQ	Futures	4968.85	4981.02	4966.18	4968.55	1719.0
2016-01-13 23:00:00	NQ	Futures	4968.26	4970.33	4950.44	4963.5	2408.0
2016-01-13 00:00:00	YM	Futures	17574.5	17574.5	17530.9	17559.6	3072.0
2016-01-13 01:00:00	YM	Futures	17560.7	17566.0	17521.3	17525.6	2942.0
2016-01-13 02:00:00	YM	Futures	17525.6	17546.9	17475.5	17542.6	5257.0
2016-01-13 03:00:00	YM	Futures	17540.5	17599.0	17510.7	17568.1	9553.0

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

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