PREVIEW / futures_1hour / 2014-08-18

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-18.parquet
  size:    46 KB
  rows:    1,483

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-18 00:00:00	ES	Futures	2041.39	2042.17	2041.39	2041.65	1005.0
2014-08-18 01:00:00	ES	Futures	2041.39	2042.43	2041.13	2041.91	2699.0
2014-08-18 02:00:00	ES	Futures	2042.17	2044.0	2041.65	2042.69	10759.0
2014-08-18 03:00:00	ES	Futures	2042.69	2046.86	2042.69	2045.82	32305.0
2014-08-18 04:00:00	ES	Futures	2045.56	2046.08	2043.47	2044.52	17385.0
2014-08-18 05:00:00	ES	Futures	2044.52	2044.52	2042.69	2043.21	11809.0
2014-08-18 06:00:00	ES	Futures	2043.21	2045.56	2042.95	2045.04	7687.0
2014-08-18 07:00:00	ES	Futures	2045.3	2047.38	2044.26	2047.38	19358.0
2014-08-18 08:00:00	ES	Futures	2047.38	2047.64	2045.04	2046.86	29575.0
2014-08-18 09:00:00	ES	Futures	2047.12	2049.21	2044.52	2048.95	139526.0
2014-08-18 10:00:00	ES	Futures	2048.95	2052.07	2047.9	2051.29	162758.0
2014-08-18 11:00:00	ES	Futures	2051.55	2051.81	2049.73	2051.03	76517.0
2014-08-18 12:00:00	ES	Futures	2051.29	2052.6	2050.77	2050.77	57428.0
2014-08-18 13:00:00	ES	Futures	2051.03	2051.81	2049.99	2051.03	44146.0
2014-08-18 14:00:00	ES	Futures	2051.03	2051.03	2049.21	2049.99	54562.0
2014-08-18 15:00:00	ES	Futures	2050.25	2051.81	2049.21	2051.55	105888.0
2014-08-18 16:00:00	ES	Futures	2051.55	2052.34	2050.25	2052.34	72192.0
2014-08-18 17:00:00	ES	Futures	2052.07	2052.34	2052.07	2052.07	1708.0
2014-08-18 18:00:00	ES	Futures	2052.07	2052.6	2051.81	2052.34	3664.0
2014-08-18 19:00:00	ES	Futures	2052.07	2053.38	2052.07	2052.34	4228.0
2014-08-18 20:00:00	ES	Futures	2052.34	2053.12	2052.34	2052.6	3002.0
2014-08-18 21:00:00	ES	Futures	2052.6	2053.12	2052.34	2053.12	2509.0
2014-08-18 22:00:00	ES	Futures	2053.12	2053.38	2052.86	2053.12	1414.0
2014-08-18 23:00:00	ES	Futures	2053.12	2053.64	2052.86	2052.86	2318.0
2014-08-18 00:00:00	NQ	Futures	4666.98	4668.44	4666.98	4666.98	256.0
2014-08-18 01:00:00	NQ	Futures	4666.98	4669.02	4666.39	4667.56	698.0
2014-08-18 02:00:00	NQ	Futures	4667.85	4672.53	4667.56	4669.02	1472.0
2014-08-18 03:00:00	NQ	Futures	4669.61	4678.37	4669.31	4676.32	6060.0
2014-08-18 04:00:00	NQ	Futures	4676.32	4678.66	4673.11	4674.86	3105.0
2014-08-18 05:00:00	NQ	Futures	4674.86	4676.03	4671.65	4672.23	1884.0
2014-08-18 06:00:00	NQ	Futures	4672.23	4678.08	4672.23	4677.2	1764.0
2014-08-18 07:00:00	NQ	Futures	4677.49	4681.29	4675.45	4680.41	3591.0
2014-08-18 08:00:00	NQ	Futures	4680.41	4681.0	4676.03	4679.54	4588.0
2014-08-18 09:00:00	NQ	Futures	4679.54	4685.96	4672.53	4685.08	31127.0
2014-08-18 10:00:00	NQ	Futures	4684.79	4692.97	4682.16	4692.97	27296.0
2014-08-18 11:00:00	NQ	Futures	4692.68	4693.26	4687.42	4690.34	17023.0
2014-08-18 12:00:00	NQ	Futures	4690.34	4695.01	4687.71	4687.71	11687.0
2014-08-18 13:00:00	NQ	Futures	4688.0	4695.01	4686.25	4692.38	10269.0
2014-08-18 14:00:00	NQ	Futures	4692.38	4693.84	4688.0	4689.76	7194.0
2014-08-18 15:00:00	NQ	Futures	4690.05	4692.68	4686.25	4690.92	18886.0
2014-08-18 16:00:00	NQ	Futures	4690.63	4691.22	4686.84	4690.34	5862.0
2014-08-18 17:00:00	NQ	Futures	4690.34	4693.26	4689.76	4692.09	712.0
2014-08-18 18:00:00	NQ	Futures	4692.09	4692.68	4690.63	4691.8	430.0
2014-08-18 19:00:00	NQ	Futures	4691.8	4694.14	4691.8	4692.38	246.0
2014-08-18 20:00:00	NQ	Futures	4692.09	4693.84	4691.8	4692.68	428.0
2014-08-18 21:00:00	NQ	Futures	4692.68	4694.43	4692.38	4694.14	351.0
2014-08-18 22:00:00	NQ	Futures	4694.14	4695.3	4694.14	4694.72	320.0
2014-08-18 23:00:00	NQ	Futures	4694.43	4695.6	4694.43	4694.43	333.0
2014-08-18 00:00:00	YM	Futures	17254.5	17257.6	17253.5	17256.6	185.0
2014-08-18 01:00:00	YM	Futures	17254.5	17261.8	17253.5	17258.7	419.0

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

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