PREVIEW / futures_1hour / 2015-02-19

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-02-19.parquet
  size:    50 KB
  rows:    1,557

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-19 00:00:00	ES	Futures	2204.16	2204.69	2204.16	2204.42	660.0
2015-02-19 01:00:00	ES	Futures	2204.42	2204.69	2203.63	2204.16	1264.0
2015-02-19 02:00:00	ES	Futures	2204.16	2204.16	2199.95	2200.48	9879.0
2015-02-19 03:00:00	ES	Futures	2200.48	2201.27	2197.05	2200.21	17899.0
2015-02-19 04:00:00	ES	Futures	2200.21	2202.58	2200.21	2202.32	11722.0
2015-02-19 05:00:00	ES	Futures	2202.05	2203.9	2200.74	2203.11	9800.0
2015-02-19 06:00:00	ES	Futures	2203.11	2206.0	2202.05	2205.48	14505.0
2015-02-19 07:00:00	ES	Futures	2205.48	2209.95	2199.95	2201.79	48948.0
2015-02-19 08:00:00	ES	Futures	2201.79	2203.37	2200.21	2201.0	20488.0
2015-02-19 09:00:00	ES	Futures	2201.27	2201.79	2197.32	2201.27	155710.0
2015-02-19 10:00:00	ES	Futures	2201.0	2206.53	2198.9	2205.21	167593.0
2015-02-19 11:00:00	ES	Futures	2204.95	2209.95	2204.16	2208.37	150961.0
2015-02-19 12:00:00	ES	Futures	2208.11	2209.42	2201.53	2204.42	116011.0
2015-02-19 13:00:00	ES	Futures	2204.42	2206.27	2202.05	2206.0	125483.0
2015-02-19 14:00:00	ES	Futures	2205.74	2207.05	2203.63	2206.27	81230.0
2015-02-19 15:00:00	ES	Futures	2206.0	2207.84	2202.84	2205.48	137404.0
2015-02-19 16:00:00	ES	Futures	2205.21	2206.79	2205.21	2206.53	48575.0
2015-02-19 17:00:00	ES	Futures	2206.79	2206.79	2205.74	2206.0	1355.0
2015-02-19 18:00:00	ES	Futures	2206.27	2206.27	2204.69	2204.95	2953.0
2015-02-19 19:00:00	ES	Futures	2205.21	2205.74	2204.42	2205.21	2261.0
2015-02-19 20:00:00	ES	Futures	2205.21	2206.27	2204.95	2205.74	1086.0
2015-02-19 21:00:00	ES	Futures	2205.74	2206.27	2204.42	2204.69	2230.0
2015-02-19 22:00:00	ES	Futures	2204.42	2204.95	2203.9	2204.42	1348.0
2015-02-19 23:00:00	ES	Futures	2204.42	2204.69	2204.16	2204.42	381.0
2015-02-19 00:00:00	NQ	Futures	5153.94	5154.53	5153.35	5154.53	144.0
2015-02-19 01:00:00	NQ	Futures	5154.23	5154.53	5152.47	5153.94	150.0
2015-02-19 02:00:00	NQ	Futures	5153.35	5153.94	5146.3	5147.77	1342.0
2015-02-19 03:00:00	NQ	Futures	5148.06	5149.83	5140.72	5147.48	3303.0
2015-02-19 04:00:00	NQ	Futures	5147.18	5154.23	5146.89	5152.76	1945.0
2015-02-19 05:00:00	NQ	Futures	5153.35	5155.99	5149.83	5154.53	1627.0
2015-02-19 06:00:00	NQ	Futures	5154.23	5160.69	5152.47	5160.11	2117.0
2015-02-19 07:00:00	NQ	Futures	5160.11	5169.8	5148.94	5154.53	10465.0
2015-02-19 08:00:00	NQ	Futures	5154.53	5159.81	5153.35	5156.58	3580.0
2015-02-19 09:00:00	NQ	Futures	5156.58	5171.27	5151.59	5169.8	26982.0
2015-02-19 10:00:00	NQ	Futures	5169.5	5181.25	5163.04	5178.02	25823.0
2015-02-19 11:00:00	NQ	Futures	5178.31	5185.66	5173.03	5182.43	22690.0
2015-02-19 12:00:00	NQ	Futures	5182.43	5183.6	5170.68	5178.31	14119.0
2015-02-19 13:00:00	NQ	Futures	5178.31	5184.19	5175.08	5183.31	13439.0
2015-02-19 14:00:00	NQ	Futures	5183.31	5185.95	5176.85	5182.13	12464.0
2015-02-19 15:00:00	NQ	Futures	5182.13	5187.42	5177.73	5183.89	21143.0
2015-02-19 16:00:00	NQ	Futures	5183.6	5188.89	5183.31	5188.89	5298.0
2015-02-19 17:00:00	NQ	Futures	5189.18	5189.18	5187.12	5187.42	264.0
2015-02-19 18:00:00	NQ	Futures	5188.01	5188.01	5183.89	5184.77	492.0
2015-02-19 19:00:00	NQ	Futures	5185.07	5185.95	5183.31	5185.07	221.0
2015-02-19 20:00:00	NQ	Futures	5185.07	5188.3	5185.07	5187.42	159.0
2015-02-19 21:00:00	NQ	Futures	5187.42	5188.3	5184.48	5184.48	316.0
2015-02-19 22:00:00	NQ	Futures	5184.77	5186.83	5184.48	5185.95	391.0
2015-02-19 23:00:00	NQ	Futures	5185.95	5186.24	5184.77	5185.36	141.0
2015-02-19 00:00:00	YM	Futures	18768.9	18772.0	18766.8	18772.0	122.0
2015-02-19 01:00:00	YM	Futures	18770.0	18772.0	18762.7	18764.7	319.0

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

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