PREVIEW / futures_1hour / 2014-07-30

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-30.parquet
  size:    51 KB
  rows:    1,543

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
2014-07-30 00:00:00	ES	Futures	2048.69	2049.47	2048.17	2048.69	1155.0
2014-07-30 01:00:00	ES	Futures	2048.95	2049.47	2048.69	2049.21	1986.0
2014-07-30 02:00:00	ES	Futures	2049.47	2052.34	2048.69	2051.03	11268.0
2014-07-30 03:00:00	ES	Futures	2051.03	2051.81	2048.69	2048.95	28729.0
2014-07-30 04:00:00	ES	Futures	2048.69	2050.25	2048.17	2049.21	17974.0
2014-07-30 05:00:00	ES	Futures	2049.47	2051.29	2049.21	2049.99	15047.0
2014-07-30 06:00:00	ES	Futures	2049.99	2051.29	2049.21	2051.03	12748.0
2014-07-30 07:00:00	ES	Futures	2051.03	2053.64	2050.51	2053.12	21340.0
2014-07-30 08:00:00	ES	Futures	2053.12	2057.55	2049.73	2055.46	83568.0
2014-07-30 09:00:00	ES	Futures	2055.46	2058.07	2050.25	2050.77	206563.0
2014-07-30 10:00:00	ES	Futures	2051.03	2051.55	2042.95	2045.04	311985.0
2014-07-30 11:00:00	ES	Futures	2044.78	2047.38	2040.35	2041.13	219859.0
2014-07-30 12:00:00	ES	Futures	2041.13	2046.34	2039.57	2045.56	133440.0
2014-07-30 13:00:00	ES	Futures	2045.3	2045.82	2041.39	2044.52	79705.0
2014-07-30 14:00:00	ES	Futures	2044.52	2055.2	2041.65	2047.9	327373.0
2014-07-30 15:00:00	ES	Futures	2047.9	2050.51	2044.26	2048.43	181468.0
2014-07-30 16:00:00	ES	Futures	2048.69	2048.95	2047.38	2048.69	84262.0
2014-07-30 17:00:00	ES	Futures	2048.69	2048.95	2048.43	2048.69	2751.0
2014-07-30 18:00:00	ES	Futures	2048.43	2048.95	2047.64	2048.17	2930.0
2014-07-30 19:00:00	ES	Futures	2048.17	2048.43	2047.12	2047.38	1081.0
2014-07-30 20:00:00	ES	Futures	2047.12	2047.64	2046.34	2047.38	4171.0
2014-07-30 21:00:00	ES	Futures	2047.12	2047.9	2046.86	2047.38	3949.0
2014-07-30 22:00:00	ES	Futures	2047.12	2047.38	2046.08	2046.08	3066.0
2014-07-30 23:00:00	ES	Futures	2046.08	2046.34	2044.78	2046.08	4517.0
2014-07-30 00:00:00	NQ	Futures	4625.22	4626.1	4624.05	4625.22	167.0
2014-07-30 01:00:00	NQ	Futures	4624.93	4626.68	4624.64	4626.68	299.0
2014-07-30 02:00:00	NQ	Futures	4626.68	4632.52	4624.93	4630.48	1210.0
2014-07-30 03:00:00	NQ	Futures	4630.18	4631.06	4622.59	4622.88	3750.0
2014-07-30 04:00:00	NQ	Futures	4622.88	4627.56	4621.42	4626.39	1762.0
2014-07-30 05:00:00	NQ	Futures	4626.39	4631.06	4626.1	4628.43	1926.0
2014-07-30 06:00:00	NQ	Futures	4628.43	4632.52	4626.97	4631.06	1767.0
2014-07-30 07:00:00	NQ	Futures	4631.35	4637.19	4630.18	4636.61	3456.0
2014-07-30 08:00:00	NQ	Futures	4636.61	4647.41	4630.48	4643.62	12055.0
2014-07-30 09:00:00	NQ	Futures	4643.91	4652.38	4636.03	4637.49	37431.0
2014-07-30 10:00:00	NQ	Futures	4638.07	4641.28	4620.26	4626.97	47141.0
2014-07-30 11:00:00	NQ	Futures	4626.97	4634.86	4618.8	4622.01	35440.0
2014-07-30 12:00:00	NQ	Futures	4622.01	4631.06	4617.63	4629.02	20925.0
2014-07-30 13:00:00	NQ	Futures	4629.02	4633.4	4622.01	4630.18	12044.0
2014-07-30 14:00:00	NQ	Futures	4630.48	4648.58	4624.34	4635.73	58098.0
2014-07-30 15:00:00	NQ	Futures	4635.73	4641.28	4626.68	4635.73	29426.0
2014-07-30 16:00:00	NQ	Futures	4635.73	4638.65	4634.57	4636.61	5430.0
2014-07-30 17:00:00	NQ	Futures	4636.32	4637.49	4636.03	4636.61	86.0
2014-07-30 18:00:00	NQ	Futures	4635.73	4637.49	4634.57	4636.03	187.0
2014-07-30 19:00:00	NQ	Futures	4636.03	4636.32	4633.4	4633.98	172.0
2014-07-30 20:00:00	NQ	Futures	4633.69	4635.73	4631.94	4635.44	458.0
2014-07-30 21:00:00	NQ	Futures	4635.15	4636.32	4632.52	4633.4	544.0
2014-07-30 22:00:00	NQ	Futures	4633.4	4633.98	4630.48	4630.48	590.0
2014-07-30 23:00:00	NQ	Futures	4630.18	4631.94	4628.14	4630.77	668.0
2014-07-30 00:00:00	YM	Futures	17448.0	17452.1	17446.9	17449.0	157.0
2014-07-30 01:00:00	YM	Futures	17448.0	17453.2	17446.9	17452.1	420.0

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

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