PREVIEW / futures_1hour / 2014-07-09

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-09.parquet
  size:    48 KB
  rows:    1,543

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-09 00:00:00	ES	Futures	2044.26	2044.52	2043.47	2043.73	1523.0
2014-07-09 01:00:00	ES	Futures	2043.73	2045.56	2043.73	2044.52	4694.0
2014-07-09 02:00:00	ES	Futures	2044.52	2045.04	2043.73	2044.78	7272.0
2014-07-09 03:00:00	ES	Futures	2045.04	2045.3	2043.21	2043.21	20051.0
2014-07-09 04:00:00	ES	Futures	2043.47	2044.52	2042.69	2042.69	15057.0
2014-07-09 05:00:00	ES	Futures	2042.95	2043.73	2042.17	2043.47	10001.0
2014-07-09 06:00:00	ES	Futures	2043.47	2045.04	2042.95	2044.0	13296.0
2014-07-09 07:00:00	ES	Futures	2044.26	2046.08	2043.73	2045.82	17613.0
2014-07-09 08:00:00	ES	Futures	2045.82	2047.38	2045.3	2045.3	36075.0
2014-07-09 09:00:00	ES	Futures	2045.56	2048.69	2042.69	2043.21	226753.0
2014-07-09 10:00:00	ES	Futures	2043.21	2048.69	2041.39	2046.86	277613.0
2014-07-09 11:00:00	ES	Futures	2046.86	2047.38	2043.73	2045.04	119939.0
2014-07-09 12:00:00	ES	Futures	2045.04	2046.34	2044.52	2046.34	53422.0
2014-07-09 13:00:00	ES	Futures	2046.08	2047.38	2045.56	2046.6	55718.0
2014-07-09 14:00:00	ES	Futures	2046.86	2050.77	2042.69	2048.95	233225.0
2014-07-09 15:00:00	ES	Futures	2049.21	2051.81	2048.69	2049.99	199243.0
2014-07-09 16:00:00	ES	Futures	2050.25	2051.55	2049.99	2051.03	75616.0
2014-07-09 17:00:00	ES	Futures	2051.03	2051.55	2051.03	2051.29	2650.0
2014-07-09 18:00:00	ES	Futures	2051.03	2051.81	2050.25	2050.25	2546.0
2014-07-09 19:00:00	ES	Futures	2050.25	2050.77	2050.25	2050.51	759.0
2014-07-09 20:00:00	ES	Futures	2050.51	2050.77	2049.73	2050.77	2385.0
2014-07-09 21:00:00	ES	Futures	2050.77	2051.29	2048.69	2048.95	3536.0
2014-07-09 22:00:00	ES	Futures	2048.95	2049.47	2048.43	2048.95	2864.0
2014-07-09 23:00:00	ES	Futures	2048.95	2049.21	2047.64	2048.17	3905.0
2014-07-09 00:00:00	NQ	Futures	4512.21	4512.21	4510.17	4510.46	449.0
2014-07-09 01:00:00	NQ	Futures	4510.75	4513.96	4510.46	4512.21	428.0
2014-07-09 02:00:00	NQ	Futures	4512.21	4514.26	4511.04	4513.67	597.0
2014-07-09 03:00:00	NQ	Futures	4513.38	4516.3	4510.75	4513.09	3170.0
2014-07-09 04:00:00	NQ	Futures	4513.09	4517.18	4511.33	4511.63	2917.0
2014-07-09 05:00:00	NQ	Futures	4512.21	4515.42	4511.04	4515.42	1066.0
2014-07-09 06:00:00	NQ	Futures	4515.13	4517.76	4513.38	4515.13	1605.0
2014-07-09 07:00:00	NQ	Futures	4515.13	4517.18	4513.67	4517.18	1947.0
2014-07-09 08:00:00	NQ	Futures	4516.88	4520.68	4516.59	4517.47	4691.0
2014-07-09 09:00:00	NQ	Futures	4517.47	4530.32	4509.0	4510.17	47409.0
2014-07-09 10:00:00	NQ	Futures	4510.17	4533.82	4504.62	4530.02	54072.0
2014-07-09 11:00:00	NQ	Futures	4530.32	4533.53	4523.02	4528.56	22719.0
2014-07-09 12:00:00	NQ	Futures	4528.27	4532.65	4525.94	4531.19	10091.0
2014-07-09 13:00:00	NQ	Futures	4531.19	4535.57	4529.15	4531.48	10208.0
2014-07-09 14:00:00	NQ	Futures	4531.48	4540.83	4519.51	4536.74	41783.0
2014-07-09 15:00:00	NQ	Futures	4536.74	4544.62	4535.57	4539.66	32945.0
2014-07-09 16:00:00	NQ	Futures	4539.08	4541.41	4537.91	4540.83	5407.0
2014-07-09 17:00:00	NQ	Futures	4540.54	4541.41	4540.24	4540.54	80.0
2014-07-09 18:00:00	NQ	Futures	4539.66	4542.0	4537.91	4537.91	463.0
2014-07-09 19:00:00	NQ	Futures	4537.91	4539.37	4537.91	4538.78	217.0
2014-07-09 20:00:00	NQ	Futures	4538.78	4540.54	4536.74	4540.24	548.0
2014-07-09 21:00:00	NQ	Futures	4540.24	4541.12	4535.86	4536.45	541.0
2014-07-09 22:00:00	NQ	Futures	4536.16	4537.32	4534.99	4536.74	574.0
2014-07-09 23:00:00	NQ	Futures	4536.45	4537.03	4534.4	4534.99	478.0
2014-07-09 00:00:00	YM	Futures	17440.7	17440.7	17432.5	17434.5	406.0
2014-07-09 01:00:00	YM	Futures	17434.5	17446.9	17433.5	17441.8	792.0

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

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