PREVIEW / futures_1hour / 2014-07-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	2054.16	2054.42	2053.64	2054.16	1578.0
2014-07-21 01:00:00	ES	Futures	2054.16	2054.16	2053.38	2053.9	1552.0
2014-07-21 02:00:00	ES	Futures	2053.64	2054.42	2053.38	2053.64	6526.0
2014-07-21 03:00:00	ES	Futures	2053.38	2053.64	2049.99	2050.77	39790.0
2014-07-21 04:00:00	ES	Futures	2050.77	2051.81	2048.95	2050.51	28909.0
2014-07-21 05:00:00	ES	Futures	2050.51	2053.64	2050.51	2052.6	16658.0
2014-07-21 06:00:00	ES	Futures	2052.6	2052.86	2049.99	2050.25	19010.0
2014-07-21 07:00:00	ES	Futures	2050.25	2051.81	2049.47	2050.77	22683.0
2014-07-21 08:00:00	ES	Futures	2050.77	2051.81	2049.99	2050.77	21243.0
2014-07-21 09:00:00	ES	Futures	2050.51	2051.29	2046.6	2050.25	222441.0
2014-07-21 10:00:00	ES	Futures	2050.25	2050.77	2042.17	2043.47	298849.0
2014-07-21 11:00:00	ES	Futures	2043.47	2048.69	2042.43	2048.43	199424.0
2014-07-21 12:00:00	ES	Futures	2048.43	2048.69	2046.34	2047.38	83841.0
2014-07-21 13:00:00	ES	Futures	2047.12	2053.12	2046.86	2052.34	100353.0
2014-07-21 14:00:00	ES	Futures	2052.07	2053.38	2050.25	2052.6	93992.0
2014-07-21 15:00:00	ES	Futures	2052.34	2053.64	2050.77	2051.81	144821.0
2014-07-21 16:00:00	ES	Futures	2051.81	2052.07	2048.95	2049.21	94206.0
2014-07-21 17:00:00	ES	Futures	2049.21	2049.21	2048.69	2049.21	1535.0
2014-07-21 18:00:00	ES	Futures	2049.21	2049.73	2048.69	2049.21	3647.0
2014-07-21 19:00:00	ES	Futures	2048.95	2049.47	2048.95	2049.21	1320.0
2014-07-21 20:00:00	ES	Futures	2049.47	2050.25	2049.21	2050.25	4430.0
2014-07-21 21:00:00	ES	Futures	2050.25	2052.07	2049.73	2051.55	7170.0
2014-07-21 22:00:00	ES	Futures	2051.81	2052.07	2051.55	2051.81	2299.0
2014-07-21 23:00:00	ES	Futures	2052.07	2052.34	2051.29	2051.81	3679.0
2014-07-21 00:00:00	NQ	Futures	4587.84	4589.59	4587.26	4589.01	223.0
2014-07-21 01:00:00	NQ	Futures	4589.01	4589.01	4587.55	4588.43	131.0
2014-07-21 02:00:00	NQ	Futures	4588.72	4590.18	4588.13	4588.43	495.0
2014-07-21 03:00:00	NQ	Futures	4588.43	4589.01	4581.42	4584.05	4767.0
2014-07-21 04:00:00	NQ	Futures	4583.75	4587.55	4579.96	4584.92	3088.0
2014-07-21 05:00:00	NQ	Futures	4585.51	4593.68	4585.21	4589.59	2288.0
2014-07-21 06:00:00	NQ	Futures	4589.59	4591.05	4583.75	4584.34	2185.0
2014-07-21 07:00:00	NQ	Futures	4584.34	4588.72	4583.75	4586.67	2405.0
2014-07-21 08:00:00	NQ	Futures	4586.38	4588.72	4584.34	4585.21	3669.0
2014-07-21 09:00:00	NQ	Futures	4585.21	4590.76	4576.45	4584.63	42347.0
2014-07-21 10:00:00	NQ	Futures	4584.34	4585.51	4567.11	4569.15	46380.0
2014-07-21 11:00:00	NQ	Futures	4569.15	4582.29	4566.82	4581.13	31202.0
2014-07-21 12:00:00	NQ	Futures	4581.42	4582.59	4575.87	4581.13	17922.0
2014-07-21 13:00:00	NQ	Futures	4580.83	4595.44	4579.67	4593.1	17421.0
2014-07-21 14:00:00	NQ	Futures	4593.1	4595.44	4586.67	4592.51	16701.0
2014-07-21 15:00:00	NQ	Futures	4592.22	4594.85	4585.21	4587.55	20123.0
2014-07-21 16:00:00	NQ	Futures	4587.55	4589.3	4583.75	4583.75	5945.0
2014-07-21 17:00:00	NQ	Futures	4583.46	4584.92	4582.59	4583.17	391.0
2014-07-21 18:00:00	NQ	Futures	4584.05	4585.51	4583.17	4584.34	361.0
2014-07-21 19:00:00	NQ	Futures	4584.34	4585.21	4584.05	4584.63	104.0
2014-07-21 20:00:00	NQ	Futures	4585.21	4587.26	4584.63	4586.67	662.0
2014-07-21 21:00:00	NQ	Futures	4586.38	4591.35	4585.51	4591.05	925.0
2014-07-21 22:00:00	NQ	Futures	4591.35	4592.22	4590.76	4591.93	330.0
2014-07-21 23:00:00	NQ	Futures	4591.93	4592.81	4590.76	4591.05	550.0
2014-07-21 00:00:00	YM	Futures	17606.3	17609.4	17603.2	17607.3	225.0
2014-07-21 01:00:00	YM	Futures	17607.3	17607.3	17599.0	17603.2	494.0

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

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