PREVIEW / futures_1hour / 2014-08-19

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-19.parquet
  size:    48 KB
  rows:    1,540

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-08-19 00:00:00	ES	Futures	2053.12	2054.16	2052.86	2053.9	2044.0
2014-08-19 01:00:00	ES	Futures	2054.16	2055.2	2053.64	2054.42	5146.0
2014-08-19 02:00:00	ES	Futures	2054.42	2055.46	2053.64	2055.46	6357.0
2014-08-19 03:00:00	ES	Futures	2055.46	2057.55	2054.42	2055.72	24383.0
2014-08-19 04:00:00	ES	Futures	2055.98	2056.24	2054.16	2054.68	12728.0
2014-08-19 05:00:00	ES	Futures	2054.68	2055.72	2053.9	2054.16	11083.0
2014-08-19 06:00:00	ES	Futures	2054.42	2054.94	2052.6	2053.38	13444.0
2014-08-19 07:00:00	ES	Futures	2053.38	2055.46	2053.12	2055.46	18757.0
2014-08-19 08:00:00	ES	Futures	2055.46	2058.33	2053.64	2055.72	46881.0
2014-08-19 09:00:00	ES	Futures	2055.72	2058.85	2054.42	2058.07	154324.0
2014-08-19 10:00:00	ES	Futures	2058.33	2060.94	2057.03	2060.41	161206.0
2014-08-19 11:00:00	ES	Futures	2060.41	2060.67	2059.11	2059.89	75804.0
2014-08-19 12:00:00	ES	Futures	2059.89	2061.98	2059.63	2061.2	51686.0
2014-08-19 13:00:00	ES	Futures	2061.46	2061.98	2060.67	2061.46	42140.0
2014-08-19 14:00:00	ES	Futures	2061.46	2063.8	2061.2	2063.02	69075.0
2014-08-19 15:00:00	ES	Futures	2063.28	2063.8	2061.98	2061.98	96993.0
2014-08-19 16:00:00	ES	Futures	2061.98	2062.5	2060.94	2061.46	55041.0
2014-08-19 17:00:00	ES	Futures	2061.2	2061.72	2061.2	2061.72	1325.0
2014-08-19 18:00:00	ES	Futures	2061.72	2061.72	2060.41	2060.94	2659.0
2014-08-19 19:00:00	ES	Futures	2060.94	2061.2	2060.41	2060.67	1066.0
2014-08-19 20:00:00	ES	Futures	2060.67	2061.2	2060.15	2061.2	2356.0
2014-08-19 21:00:00	ES	Futures	2060.94	2060.94	2058.85	2059.63	4453.0
2014-08-19 22:00:00	ES	Futures	2059.89	2059.89	2059.11	2059.63	1229.0
2014-08-19 23:00:00	ES	Futures	2059.63	2060.67	2059.63	2060.67	1610.0
2014-08-19 00:00:00	NQ	Futures	4694.72	4696.47	4694.14	4696.47	316.0
2014-08-19 01:00:00	NQ	Futures	4696.18	4699.98	4696.18	4699.1	867.0
2014-08-19 02:00:00	NQ	Futures	4699.1	4699.1	4695.3	4698.52	1083.0
2014-08-19 03:00:00	NQ	Futures	4698.52	4702.6	4696.18	4699.1	3492.0
2014-08-19 04:00:00	NQ	Futures	4699.39	4699.68	4695.89	4697.64	1782.0
2014-08-19 05:00:00	NQ	Futures	4697.64	4699.98	4696.76	4697.35	1558.0
2014-08-19 06:00:00	NQ	Futures	4697.35	4698.52	4695.01	4695.89	2433.0
2014-08-19 07:00:00	NQ	Futures	4695.6	4700.27	4695.3	4699.98	3070.0
2014-08-19 08:00:00	NQ	Futures	4700.27	4704.94	4696.76	4699.68	7893.0
2014-08-19 09:00:00	NQ	Futures	4699.98	4707.28	4699.1	4705.52	28355.0
2014-08-19 10:00:00	NQ	Futures	4705.52	4707.86	4699.98	4705.82	28069.0
2014-08-19 11:00:00	NQ	Futures	4705.82	4707.57	4702.9	4705.82	13576.0
2014-08-19 12:00:00	NQ	Futures	4705.82	4710.78	4703.19	4708.15	12205.0
2014-08-19 13:00:00	NQ	Futures	4708.44	4713.41	4708.15	4713.41	8655.0
2014-08-19 14:00:00	NQ	Futures	4713.12	4718.37	4711.66	4717.5	12752.0
2014-08-19 15:00:00	NQ	Futures	4717.5	4719.54	4716.33	4717.5	16109.0
2014-08-19 16:00:00	NQ	Futures	4717.21	4718.08	4711.95	4712.24	6037.0
2014-08-19 17:00:00	NQ	Futures	4712.24	4716.33	4712.24	4714.58	883.0
2014-08-19 18:00:00	NQ	Futures	4714.87	4715.45	4712.53	4713.12	539.0
2014-08-19 19:00:00	NQ	Futures	4713.12	4713.12	4711.66	4711.95	228.0
2014-08-19 20:00:00	NQ	Futures	4711.95	4713.12	4711.07	4712.53	245.0
2014-08-19 21:00:00	NQ	Futures	4712.53	4712.83	4706.69	4709.03	1219.0
2014-08-19 22:00:00	NQ	Futures	4709.32	4709.9	4707.86	4709.61	375.0
2014-08-19 23:00:00	NQ	Futures	4709.61	4711.95	4709.03	4711.07	336.0
2014-08-19 00:00:00	YM	Futures	17397.3	17404.5	17397.3	17403.5	320.0
2014-08-19 01:00:00	YM	Futures	17404.5	17414.9	17403.5	17410.7	1118.0

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

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