PREVIEW / futures_1hour / 2014-07-14

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-14.parquet
  size:    46 KB
  rows:    1,509

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-14 00:00:00	ES	Futures	2047.64	2048.95	2047.64	2048.95	2072.0
2014-07-14 01:00:00	ES	Futures	2048.95	2049.99	2048.69	2049.21	3351.0
2014-07-14 02:00:00	ES	Futures	2049.21	2049.99	2048.43	2048.69	4458.0
2014-07-14 03:00:00	ES	Futures	2048.69	2050.25	2047.9	2049.73	16232.0
2014-07-14 04:00:00	ES	Futures	2049.73	2053.38	2049.73	2052.6	21532.0
2014-07-14 05:00:00	ES	Futures	2052.34	2053.12	2051.55	2052.6	12752.0
2014-07-14 06:00:00	ES	Futures	2052.6	2053.12	2051.81	2052.07	10083.0
2014-07-14 07:00:00	ES	Futures	2052.07	2053.9	2051.81	2053.64	19901.0
2014-07-14 08:00:00	ES	Futures	2053.64	2055.2	2053.64	2053.9	20475.0
2014-07-14 09:00:00	ES	Futures	2054.16	2057.03	2053.38	2055.2	196025.0
2014-07-14 10:00:00	ES	Futures	2054.94	2057.29	2054.42	2056.24	162507.0
2014-07-14 11:00:00	ES	Futures	2056.5	2057.81	2055.72	2055.72	99453.0
2014-07-14 12:00:00	ES	Futures	2055.72	2057.03	2054.16	2055.2	96978.0
2014-07-14 13:00:00	ES	Futures	2054.94	2056.24	2054.68	2055.46	54281.0
2014-07-14 14:00:00	ES	Futures	2055.72	2056.24	2054.68	2056.24	64681.0
2014-07-14 15:00:00	ES	Futures	2056.24	2056.24	2053.9	2054.94	131013.0
2014-07-14 16:00:00	ES	Futures	2054.94	2055.46	2054.16	2054.94	67424.0
2014-07-14 17:00:00	ES	Futures	2054.68	2055.2	2054.68	2054.94	2187.0
2014-07-14 18:00:00	ES	Futures	2054.94	2055.46	2054.42	2054.42	2854.0
2014-07-14 19:00:00	ES	Futures	2054.42	2054.94	2053.9	2054.42	1442.0
2014-07-14 20:00:00	ES	Futures	2054.68	2056.24	2054.42	2056.24	4197.0
2014-07-14 21:00:00	ES	Futures	2055.98	2057.03	2055.72	2056.24	5316.0
2014-07-14 22:00:00	ES	Futures	2056.24	2056.5	2055.98	2056.24	1380.0
2014-07-14 23:00:00	ES	Futures	2056.24	2056.5	2055.2	2055.72	2257.0
2014-07-14 00:00:00	NQ	Futures	4558.06	4560.98	4558.06	4560.98	220.0
2014-07-14 01:00:00	NQ	Futures	4560.98	4562.44	4560.39	4561.85	486.0
2014-07-14 02:00:00	NQ	Futures	4561.56	4563.61	4560.69	4561.27	856.0
2014-07-14 03:00:00	NQ	Futures	4561.27	4565.65	4558.64	4565.07	2880.0
2014-07-14 04:00:00	NQ	Futures	4565.07	4574.41	4564.77	4573.24	3863.0
2014-07-14 05:00:00	NQ	Futures	4572.95	4576.16	4572.66	4575.58	2593.0
2014-07-14 06:00:00	NQ	Futures	4575.29	4575.58	4572.37	4572.66	2172.0
2014-07-14 07:00:00	NQ	Futures	4572.66	4575.87	4572.66	4575.87	2837.0
2014-07-14 08:00:00	NQ	Futures	4575.58	4576.75	4572.95	4573.83	3479.0
2014-07-14 09:00:00	NQ	Futures	4573.83	4577.33	4566.53	4574.7	31058.0
2014-07-14 10:00:00	NQ	Futures	4574.41	4585.8	4574.41	4584.05	26660.0
2014-07-14 11:00:00	NQ	Futures	4584.34	4591.35	4582.88	4584.34	21070.0
2014-07-14 12:00:00	NQ	Futures	4584.05	4589.59	4579.67	4581.71	15283.0
2014-07-14 13:00:00	NQ	Futures	4581.71	4588.72	4581.42	4586.67	10008.0
2014-07-14 14:00:00	NQ	Futures	4586.97	4587.84	4581.42	4587.26	9208.0
2014-07-14 15:00:00	NQ	Futures	4587.26	4587.26	4578.21	4581.13	21843.0
2014-07-14 16:00:00	NQ	Futures	4581.13	4581.42	4577.62	4580.25	5705.0
2014-07-14 17:00:00	NQ	Futures	4580.25	4582.59	4579.67	4582.0	534.0
2014-07-14 18:00:00	NQ	Futures	4581.71	4582.29	4579.37	4579.37	267.0
2014-07-14 19:00:00	NQ	Futures	4579.37	4580.83	4579.37	4580.54	258.0
2014-07-14 20:00:00	NQ	Futures	4580.83	4584.34	4580.83	4584.34	611.0
2014-07-14 21:00:00	NQ	Futures	4584.05	4585.21	4582.88	4584.05	578.0
2014-07-14 22:00:00	NQ	Futures	4584.34	4584.34	4583.46	4583.75	213.0
2014-07-14 23:00:00	NQ	Futures	4583.75	4584.92	4582.88	4583.46	288.0
2014-07-14 00:00:00	YM	Futures	17479.0	17484.2	17476.9	17484.2	384.0
2014-07-14 01:00:00	YM	Futures	17484.2	17491.4	17483.2	17488.3	490.0

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

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