PREVIEW / futures_1hour / 2015-02-18

all futures 1-hour files

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

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-18 00:00:00	ES	Futures	2206.53	2207.05	2206.53	2207.05	1174.0
2015-02-18 01:00:00	ES	Futures	2207.05	2207.58	2206.53	2206.53	807.0
2015-02-18 02:00:00	ES	Futures	2206.79	2208.9	2206.53	2207.32	5343.0
2015-02-18 03:00:00	ES	Futures	2207.32	2208.11	2205.74	2207.32	13059.0
2015-02-18 04:00:00	ES	Futures	2207.05	2208.37	2206.27	2206.53	11351.0
2015-02-18 05:00:00	ES	Futures	2206.27	2206.53	2203.63	2205.21	12415.0
2015-02-18 06:00:00	ES	Futures	2204.95	2206.53	2204.42	2206.0	6526.0
2015-02-18 07:00:00	ES	Futures	2206.0	2206.53	2203.63	2204.95	13431.0
2015-02-18 08:00:00	ES	Futures	2204.95	2205.21	2202.32	2202.58	17547.0
2015-02-18 09:00:00	ES	Futures	2202.58	2204.69	2199.95	2202.84	170183.0
2015-02-18 10:00:00	ES	Futures	2202.84	2203.63	2198.37	2202.58	185055.0
2015-02-18 11:00:00	ES	Futures	2202.32	2204.42	2201.27	2202.58	121388.0
2015-02-18 12:00:00	ES	Futures	2202.58	2203.9	2199.69	2200.21	72332.0
2015-02-18 13:00:00	ES	Futures	2200.21	2202.58	2199.42	2201.0	73605.0
2015-02-18 14:00:00	ES	Futures	2201.27	2207.32	2200.74	2203.9	153227.0
2015-02-18 15:00:00	ES	Futures	2203.63	2207.84	2203.63	2207.05	154315.0
2015-02-18 16:00:00	ES	Futures	2207.05	2207.32	2204.95	2205.74	58758.0
2015-02-18 17:00:00	ES	Futures	2205.74	2206.0	2205.48	2205.74	1491.0
2015-02-18 18:00:00	ES	Futures	2205.48	2205.74	2204.69	2204.95	2652.0
2015-02-18 19:00:00	ES	Futures	2204.95	2204.95	2203.63	2204.16	4336.0
2015-02-18 20:00:00	ES	Futures	2204.16	2204.16	2203.37	2203.37	1600.0
2015-02-18 21:00:00	ES	Futures	2203.63	2204.69	2203.37	2204.42	1512.0
2015-02-18 22:00:00	ES	Futures	2204.69	2204.69	2203.9	2204.16	853.0
2015-02-18 23:00:00	ES	Futures	2204.16	2204.69	2204.16	2204.16	431.0
2015-02-18 00:00:00	NQ	Futures	5150.71	5152.76	5150.41	5152.76	165.0
2015-02-18 01:00:00	NQ	Futures	5152.76	5153.64	5151.59	5151.59	209.0
2015-02-18 02:00:00	NQ	Futures	5151.59	5157.76	5151.29	5153.64	770.0
2015-02-18 03:00:00	NQ	Futures	5153.94	5156.29	5150.71	5154.53	1829.0
2015-02-18 04:00:00	NQ	Futures	5154.82	5156.58	5151.59	5152.76	1794.0
2015-02-18 05:00:00	NQ	Futures	5152.47	5152.47	5147.18	5150.71	1657.0
2015-02-18 06:00:00	NQ	Futures	5150.71	5152.47	5148.06	5151.59	1372.0
2015-02-18 07:00:00	NQ	Futures	5151.88	5153.06	5146.3	5149.24	2235.0
2015-02-18 08:00:00	NQ	Futures	5149.24	5150.41	5143.66	5144.83	2509.0
2015-02-18 09:00:00	NQ	Futures	5144.54	5152.47	5141.31	5150.41	23327.0
2015-02-18 10:00:00	NQ	Futures	5150.12	5153.06	5138.08	5149.83	24747.0
2015-02-18 11:00:00	NQ	Futures	5149.53	5151.29	5145.42	5146.89	10855.0
2015-02-18 12:00:00	NQ	Futures	5147.18	5150.41	5141.02	5143.07	8895.0
2015-02-18 13:00:00	NQ	Futures	5142.78	5148.65	5142.19	5143.36	9410.0
2015-02-18 14:00:00	NQ	Futures	5143.36	5155.99	5139.84	5150.41	25207.0
2015-02-18 15:00:00	NQ	Futures	5150.12	5161.28	5149.83	5158.34	25195.0
2015-02-18 16:00:00	NQ	Futures	5158.34	5158.64	5152.18	5155.99	4557.0
2015-02-18 17:00:00	NQ	Futures	5156.29	5158.64	5155.7	5157.76	358.0
2015-02-18 18:00:00	NQ	Futures	5157.46	5157.76	5153.64	5153.94	507.0
2015-02-18 19:00:00	NQ	Futures	5154.23	5154.23	5152.18	5153.06	296.0
2015-02-18 20:00:00	NQ	Futures	5153.06	5153.64	5151.59	5152.47	167.0
2015-02-18 21:00:00	NQ	Futures	5152.76	5154.53	5151.88	5153.94	166.0
2015-02-18 22:00:00	NQ	Futures	5153.94	5154.23	5153.35	5153.94	98.0
2015-02-18 23:00:00	NQ	Futures	5153.94	5154.53	5153.64	5154.23	107.0
2015-02-18 00:00:00	YM	Futures	18798.1	18802.3	18797.1	18801.3	135.0
2015-02-18 01:00:00	YM	Futures	18802.3	18807.5	18800.2	18800.2	212.0

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

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