PREVIEW / futures_1hour / 2015-02-17

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-02-17.parquet
  size:    51 KB
  rows:    1,554

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
2015-02-17 00:00:00	ES	Futures	2195.21	2195.74	2193.37	2193.63	2188.0
2015-02-17 01:00:00	ES	Futures	2193.63	2194.95	2192.84	2194.16	1954.0
2015-02-17 02:00:00	ES	Futures	2194.16	2194.42	2192.84	2193.63	2782.0
2015-02-17 03:00:00	ES	Futures	2193.63	2194.16	2190.21	2192.84	19853.0
2015-02-17 04:00:00	ES	Futures	2193.11	2199.16	2192.84	2197.58	16814.0
2015-02-17 05:00:00	ES	Futures	2197.58	2202.05	2196.79	2201.0	11515.0
2015-02-17 06:00:00	ES	Futures	2201.27	2203.11	2200.48	2201.27	11434.0
2015-02-17 07:00:00	ES	Futures	2201.0	2203.11	2200.74	2201.53	12400.0
2015-02-17 08:00:00	ES	Futures	2201.53	2202.32	2198.37	2200.74	33607.0
2015-02-17 09:00:00	ES	Futures	2200.48	2201.53	2196.0	2199.95	169654.0
2015-02-17 10:00:00	ES	Futures	2199.69	2202.32	2197.84	2198.9	151773.0
2015-02-17 11:00:00	ES	Futures	2198.9	2202.58	2197.84	2202.05	124864.0
2015-02-17 12:00:00	ES	Futures	2202.05	2204.95	2201.27	2204.69	109031.0
2015-02-17 13:00:00	ES	Futures	2204.69	2209.16	2203.9	2207.05	124620.0
2015-02-17 14:00:00	ES	Futures	2207.32	2207.58	2204.69	2205.21	85302.0
2015-02-17 15:00:00	ES	Futures	2205.21	2207.58	2203.37	2207.32	162549.0
2015-02-17 16:00:00	ES	Futures	2207.05	2208.11	2206.0	2207.84	58145.0
2015-02-17 17:00:00	ES	Futures	2207.84	2207.84	2206.27	2206.79	2337.0
2015-02-17 18:00:00	ES	Futures	2206.79	2207.05	2205.74	2206.79	4906.0
2015-02-17 19:00:00	ES	Futures	2207.05	2207.58	2206.27	2206.53	3171.0
2015-02-17 20:00:00	ES	Futures	2206.53	2206.79	2206.27	2206.27	1480.0
2015-02-17 21:00:00	ES	Futures	2206.27	2207.32	2206.27	2207.05	1017.0
2015-02-17 22:00:00	ES	Futures	2207.05	2207.84	2206.79	2206.79	1550.0
2015-02-17 23:00:00	ES	Futures	2206.79	2207.32	2206.27	2206.53	1481.0
2015-02-17 00:00:00	NQ	Futures	5137.49	5138.96	5134.26	5134.26	254.0
2015-02-17 01:00:00	NQ	Futures	5134.55	5138.67	5133.09	5137.2	393.0
2015-02-17 02:00:00	NQ	Futures	5136.9	5137.49	5133.97	5136.02	615.0
2015-02-17 03:00:00	NQ	Futures	5136.02	5137.2	5127.8	5132.2	3262.0
2015-02-17 04:00:00	NQ	Futures	5132.2	5144.83	5132.2	5141.6	2709.0
2015-02-17 05:00:00	NQ	Futures	5141.02	5149.83	5138.96	5147.48	2418.0
2015-02-17 06:00:00	NQ	Futures	5147.18	5151.88	5146.3	5146.6	2412.0
2015-02-17 07:00:00	NQ	Futures	5147.18	5152.18	5146.6	5150.41	2311.0
2015-02-17 08:00:00	NQ	Futures	5150.41	5151.29	5142.19	5147.18	4029.0
2015-02-17 09:00:00	NQ	Futures	5147.18	5148.94	5133.97	5141.9	31525.0
2015-02-17 10:00:00	NQ	Futures	5142.48	5151.59	5136.32	5140.13	26239.0
2015-02-17 11:00:00	NQ	Futures	5139.84	5147.48	5136.61	5145.71	16379.0
2015-02-17 12:00:00	NQ	Futures	5145.71	5148.36	5139.84	5142.48	12671.0
2015-02-17 13:00:00	NQ	Futures	5142.48	5154.82	5142.19	5147.18	17655.0
2015-02-17 14:00:00	NQ	Futures	5147.18	5149.53	5142.19	5145.13	12294.0
2015-02-17 15:00:00	NQ	Futures	5145.42	5151.88	5141.31	5151.88	27327.0
2015-02-17 16:00:00	NQ	Futures	5151.88	5154.82	5147.48	5151.0	6406.0
2015-02-17 17:00:00	NQ	Futures	5151.59	5151.59	5150.12	5150.71	80.0
2015-02-17 18:00:00	NQ	Futures	5150.71	5151.88	5147.77	5151.0	339.0
2015-02-17 19:00:00	NQ	Futures	5151.0	5151.88	5149.53	5149.83	298.0
2015-02-17 20:00:00	NQ	Futures	5149.83	5150.12	5148.65	5149.53	165.0
2015-02-17 21:00:00	NQ	Futures	5149.53	5151.29	5149.24	5150.71	173.0
2015-02-17 22:00:00	NQ	Futures	5150.71	5153.06	5150.12	5151.29	199.0
2015-02-17 23:00:00	NQ	Futures	5151.59	5151.88	5150.12	5150.41	174.0
2015-02-17 00:00:00	YM	Futures	18721.9	18724.0	18709.4	18709.4	343.0
2015-02-17 01:00:00	YM	Futures	18709.4	18718.8	18704.2	18710.5	565.0

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

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