PREVIEW / futures_1hour / 2014-07-01

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-01.parquet
  size:    47 KB
  rows:    1,521

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-01 00:00:00	ES	Futures	2038.0	2038.52	2037.74	2038.0	1304.0
2014-07-01 01:00:00	ES	Futures	2038.0	2038.0	2037.48	2037.74	2151.0
2014-07-01 02:00:00	ES	Futures	2037.74	2038.52	2037.48	2038.0	3352.0
2014-07-01 03:00:00	ES	Futures	2038.26	2039.57	2037.74	2039.57	15708.0
2014-07-01 04:00:00	ES	Futures	2039.3	2039.57	2038.0	2039.57	10385.0
2014-07-01 05:00:00	ES	Futures	2039.57	2040.09	2039.04	2039.3	8224.0
2014-07-01 06:00:00	ES	Futures	2039.3	2040.87	2039.3	2039.83	12064.0
2014-07-01 07:00:00	ES	Futures	2039.83	2040.35	2039.04	2039.3	9593.0
2014-07-01 08:00:00	ES	Futures	2039.57	2041.39	2039.3	2040.61	15587.0
2014-07-01 09:00:00	ES	Futures	2040.61	2044.52	2039.3	2043.47	170441.0
2014-07-01 10:00:00	ES	Futures	2043.21	2048.69	2041.91	2047.64	324592.0
2014-07-01 11:00:00	ES	Futures	2047.9	2051.03	2047.38	2049.47	168043.0
2014-07-01 12:00:00	ES	Futures	2049.21	2052.34	2048.69	2051.81	111071.0
2014-07-01 13:00:00	ES	Futures	2051.81	2055.46	2051.55	2053.64	143666.0
2014-07-01 14:00:00	ES	Futures	2053.64	2053.9	2050.77	2052.07	120214.0
2014-07-01 15:00:00	ES	Futures	2051.81	2053.12	2048.69	2049.21	220094.0
2014-07-01 16:00:00	ES	Futures	2049.21	2049.73	2048.43	2049.73	95407.0
2014-07-01 17:00:00	ES	Futures	2049.47	2049.73	2049.47	2049.73	1600.0
2014-07-01 18:00:00	ES	Futures	2049.73	2050.51	2049.21	2049.73	3349.0
2014-07-01 19:00:00	ES	Futures	2049.73	2050.25	2049.73	2049.99	860.0
2014-07-01 20:00:00	ES	Futures	2049.99	2050.25	2049.73	2049.73	1655.0
2014-07-01 21:00:00	ES	Futures	2049.73	2051.29	2049.73	2050.77	2612.0
2014-07-01 22:00:00	ES	Futures	2050.77	2051.55	2050.25	2051.29	1880.0
2014-07-01 23:00:00	ES	Futures	2051.29	2051.29	2050.51	2050.51	733.0
2014-07-01 00:00:00	NQ	Futures	4494.11	4494.98	4493.52	4494.69	259.0
2014-07-01 01:00:00	NQ	Futures	4494.69	4494.69	4493.81	4494.4	341.0
2014-07-01 02:00:00	NQ	Futures	4494.69	4495.27	4493.81	4494.69	705.0
2014-07-01 03:00:00	NQ	Futures	4494.98	4496.44	4494.11	4496.15	1916.0
2014-07-01 04:00:00	NQ	Futures	4496.15	4496.44	4494.11	4496.44	1569.0
2014-07-01 05:00:00	NQ	Futures	4496.44	4497.9	4496.15	4497.61	1336.0
2014-07-01 06:00:00	NQ	Futures	4497.9	4501.41	4497.61	4498.78	2499.0
2014-07-01 07:00:00	NQ	Futures	4499.07	4500.53	4498.19	4499.07	1525.0
2014-07-01 08:00:00	NQ	Futures	4499.07	4502.28	4498.19	4501.41	3166.0
2014-07-01 09:00:00	NQ	Futures	4501.7	4517.47	4501.11	4514.84	29953.0
2014-07-01 10:00:00	NQ	Futures	4515.13	4534.99	4514.55	4532.36	44778.0
2014-07-01 11:00:00	NQ	Futures	4532.36	4539.66	4530.9	4536.16	24230.0
2014-07-01 12:00:00	NQ	Futures	4535.86	4543.16	4534.4	4541.7	15515.0
2014-07-01 13:00:00	NQ	Futures	4541.7	4549.0	4541.7	4545.79	16932.0
2014-07-01 14:00:00	NQ	Futures	4545.79	4546.08	4539.37	4543.46	15814.0
2014-07-01 15:00:00	NQ	Futures	4543.16	4545.5	4536.45	4537.91	26555.0
2014-07-01 16:00:00	NQ	Futures	4537.91	4539.08	4535.57	4539.08	6289.0
2014-07-01 17:00:00	NQ	Futures	4539.08	4539.37	4538.49	4539.08	180.0
2014-07-01 18:00:00	NQ	Futures	4538.49	4540.54	4537.03	4539.08	564.0
2014-07-01 19:00:00	NQ	Futures	4539.66	4540.54	4539.37	4539.66	130.0
2014-07-01 20:00:00	NQ	Futures	4539.95	4540.83	4539.66	4540.24	434.0
2014-07-01 21:00:00	NQ	Futures	4539.66	4542.58	4539.66	4541.12	427.0
2014-07-01 22:00:00	NQ	Futures	4541.12	4543.16	4541.12	4542.87	245.0
2014-07-01 23:00:00	NQ	Futures	4542.87	4543.46	4541.12	4541.12	289.0
2014-07-01 00:00:00	YM	Futures	17344.5	17346.6	17341.4	17343.5	133.0
2014-07-01 01:00:00	YM	Futures	17343.5	17343.5	17339.4	17340.4	247.0

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

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