PREVIEW / futures_1hour / 2014-07-07

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-07.parquet
  size:    45 KB
  rows:    1,455

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-07 00:00:00	ES	Futures	2059.89	2060.41	2059.11	2059.11	896.0
2014-07-07 01:00:00	ES	Futures	2059.11	2060.15	2058.85	2059.37	1806.0
2014-07-07 02:00:00	ES	Futures	2059.37	2059.63	2058.07	2058.07	6397.0
2014-07-07 03:00:00	ES	Futures	2058.07	2059.63	2057.29	2057.81	13784.0
2014-07-07 04:00:00	ES	Futures	2057.81	2058.59	2057.03	2057.81	12291.0
2014-07-07 05:00:00	ES	Futures	2058.07	2058.85	2057.55	2058.33	6411.0
2014-07-07 06:00:00	ES	Futures	2058.59	2059.63	2057.81	2057.81	9302.0
2014-07-07 07:00:00	ES	Futures	2058.07	2058.33	2056.5	2057.03	11046.0
2014-07-07 08:00:00	ES	Futures	2057.29	2057.29	2054.94	2056.5	24739.0
2014-07-07 09:00:00	ES	Futures	2056.5	2058.07	2054.16	2055.72	169098.0
2014-07-07 10:00:00	ES	Futures	2055.98	2058.85	2053.12	2053.64	200159.0
2014-07-07 11:00:00	ES	Futures	2053.9	2054.42	2051.29	2052.6	179729.0
2014-07-07 12:00:00	ES	Futures	2052.34	2054.68	2051.55	2052.34	79050.0
2014-07-07 13:00:00	ES	Futures	2052.6	2055.72	2052.07	2054.68	71686.0
2014-07-07 14:00:00	ES	Futures	2054.68	2054.94	2050.77	2052.86	94976.0
2014-07-07 15:00:00	ES	Futures	2052.6	2054.42	2051.81	2054.16	138647.0
2014-07-07 16:00:00	ES	Futures	2053.9	2055.2	2053.9	2054.16	64196.0
2014-07-07 17:00:00	ES	Futures	2054.16	2054.68	2053.9	2054.42	1048.0
2014-07-07 18:00:00	ES	Futures	2054.16	2054.42	2053.64	2053.9	1696.0
2014-07-07 19:00:00	ES	Futures	2053.9	2054.16	2052.86	2053.64	2080.0
2014-07-07 20:00:00	ES	Futures	2053.64	2053.9	2052.07	2052.6	4850.0
2014-07-07 21:00:00	ES	Futures	2052.34	2052.6	2051.81	2052.34	3071.0
2014-07-07 22:00:00	ES	Futures	2052.07	2052.34	2051.55	2051.81	1535.0
2014-07-07 23:00:00	ES	Futures	2052.07	2053.38	2051.81	2052.86	3023.0
2014-07-07 00:00:00	NQ	Futures	4571.2	4571.78	4569.74	4569.74	180.0
2014-07-07 01:00:00	NQ	Futures	4569.45	4571.2	4569.15	4570.32	255.0
2014-07-07 02:00:00	NQ	Futures	4570.03	4570.03	4566.82	4567.11	856.0
2014-07-07 03:00:00	NQ	Futures	4567.4	4569.45	4565.36	4565.65	1640.0
2014-07-07 04:00:00	NQ	Futures	4566.23	4567.4	4564.19	4566.53	1618.0
2014-07-07 05:00:00	NQ	Futures	4566.53	4568.57	4565.94	4567.4	539.0
2014-07-07 06:00:00	NQ	Futures	4567.4	4569.45	4565.65	4565.65	1332.0
2014-07-07 07:00:00	NQ	Futures	4565.65	4566.53	4563.31	4564.48	3049.0
2014-07-07 08:00:00	NQ	Futures	4564.19	4565.07	4560.98	4564.48	4353.0
2014-07-07 09:00:00	NQ	Futures	4564.48	4569.74	4563.31	4568.86	25271.0
2014-07-07 10:00:00	NQ	Futures	4568.57	4573.83	4558.64	4561.56	33021.0
2014-07-07 11:00:00	NQ	Futures	4561.27	4562.73	4553.38	4554.55	29940.0
2014-07-07 12:00:00	NQ	Futures	4554.55	4559.23	4552.22	4556.6	14159.0
2014-07-07 13:00:00	NQ	Futures	4556.6	4562.73	4554.55	4560.1	9930.0
2014-07-07 14:00:00	NQ	Futures	4559.81	4561.85	4550.76	4556.01	13279.0
2014-07-07 15:00:00	NQ	Futures	4556.01	4559.23	4551.92	4558.93	21807.0
2014-07-07 16:00:00	NQ	Futures	4558.93	4561.85	4558.64	4560.39	5052.0
2014-07-07 17:00:00	NQ	Futures	4560.1	4562.44	4560.1	4562.15	201.0
2014-07-07 18:00:00	NQ	Futures	4561.27	4562.15	4559.52	4559.81	465.0
2014-07-07 19:00:00	NQ	Futures	4559.81	4560.1	4557.47	4558.64	216.0
2014-07-07 20:00:00	NQ	Futures	4558.93	4558.93	4556.01	4556.89	511.0
2014-07-07 21:00:00	NQ	Futures	4556.6	4557.77	4556.01	4557.18	442.0
2014-07-07 22:00:00	NQ	Futures	4556.89	4557.18	4556.01	4557.18	319.0
2014-07-07 23:00:00	NQ	Futures	4556.89	4560.1	4556.6	4559.23	428.0
2014-07-07 00:00:00	YM	Futures	17554.5	17555.6	17547.3	17547.3	195.0
2014-07-07 01:00:00	YM	Futures	17546.3	17553.5	17546.3	17550.4	356.0

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

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