PREVIEW / futures_1hour / 2014-07-11

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-11.parquet
  size:    39 KB
  rows:    1,246

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-11 00:00:00	ES	Futures	2041.39	2041.65	2040.35	2041.13	2704.0
2014-07-11 01:00:00	ES	Futures	2041.13	2041.91	2040.61	2041.39	1943.0
2014-07-11 02:00:00	ES	Futures	2041.13	2042.43	2040.61	2041.65	5891.0
2014-07-11 03:00:00	ES	Futures	2041.39	2045.3	2040.61	2045.3	29990.0
2014-07-11 04:00:00	ES	Futures	2045.04	2046.86	2045.04	2045.82	19923.0
2014-07-11 05:00:00	ES	Futures	2045.82	2046.08	2044.52	2045.3	10207.0
2014-07-11 06:00:00	ES	Futures	2045.3	2046.08	2042.43	2043.47	17666.0
2014-07-11 07:00:00	ES	Futures	2043.21	2045.3	2043.21	2045.3	15497.0
2014-07-11 08:00:00	ES	Futures	2045.04	2045.3	2040.35	2040.61	35802.0
2014-07-11 09:00:00	ES	Futures	2040.61	2043.21	2035.92	2039.04	269528.0
2014-07-11 10:00:00	ES	Futures	2039.04	2042.95	2036.96	2040.09	252107.0
2014-07-11 11:00:00	ES	Futures	2040.09	2041.13	2037.22	2038.78	172258.0
2014-07-11 12:00:00	ES	Futures	2038.78	2040.35	2038.0	2040.09	90456.0
2014-07-11 13:00:00	ES	Futures	2040.09	2042.95	2039.83	2041.91	95018.0
2014-07-11 14:00:00	ES	Futures	2041.91	2044.78	2041.91	2043.21	107410.0
2014-07-11 15:00:00	ES	Futures	2043.47	2046.34	2042.69	2044.78	151639.0
2014-07-11 16:00:00	ES	Futures	2044.52	2046.08	2044.52	2046.08	60586.0
2014-07-11 17:00:00	ES	Futures	2045.82	2046.34	2045.82	2046.08	1443.0
2014-07-11 00:00:00	NQ	Futures	4526.81	4527.98	4526.23	4527.1	431.0
2014-07-11 01:00:00	NQ	Futures	4527.4	4529.44	4526.52	4527.69	381.0
2014-07-11 02:00:00	NQ	Futures	4527.1	4529.73	4525.64	4527.69	741.0
2014-07-11 03:00:00	NQ	Futures	4527.98	4538.49	4526.23	4538.49	3813.0
2014-07-11 04:00:00	NQ	Futures	4538.49	4542.87	4537.32	4538.49	2844.0
2014-07-11 05:00:00	NQ	Futures	4538.49	4539.95	4535.28	4536.74	1560.0
2014-07-11 06:00:00	NQ	Futures	4536.74	4539.66	4533.53	4534.99	2824.0
2014-07-11 07:00:00	NQ	Futures	4535.28	4539.66	4534.99	4539.37	2569.0
2014-07-11 08:00:00	NQ	Futures	4539.66	4539.66	4530.32	4531.19	4882.0
2014-07-11 09:00:00	NQ	Futures	4530.9	4542.87	4522.43	4534.4	41488.0
2014-07-11 10:00:00	NQ	Futures	4534.7	4544.33	4530.61	4541.7	41759.0
2014-07-11 11:00:00	NQ	Futures	4542.0	4544.04	4533.24	4536.16	26531.0
2014-07-11 12:00:00	NQ	Futures	4536.16	4539.95	4535.28	4538.78	10319.0
2014-07-11 13:00:00	NQ	Futures	4538.78	4551.92	4538.78	4548.42	16616.0
2014-07-11 14:00:00	NQ	Futures	4548.13	4553.68	4547.84	4549.0	11773.0
2014-07-11 15:00:00	NQ	Futures	4549.0	4553.97	4546.96	4553.09	23496.0
2014-07-11 16:00:00	NQ	Futures	4553.09	4554.26	4551.92	4553.68	5119.0
2014-07-11 17:00:00	NQ	Futures	4553.97	4554.26	4553.38	4554.26	287.0
2014-07-11 00:00:00	YM	Futures	17426.3	17428.3	17421.1	17425.2	335.0
2014-07-11 01:00:00	YM	Futures	17424.2	17431.4	17423.2	17428.3	317.0
2014-07-11 02:00:00	YM	Futures	17426.3	17432.5	17423.2	17425.2	740.0
2014-07-11 03:00:00	YM	Futures	17426.3	17463.5	17420.0	17463.5	4138.0
2014-07-11 04:00:00	YM	Futures	17463.5	17475.9	17459.4	17465.6	2825.0
2014-07-11 05:00:00	YM	Futures	17466.6	17468.7	17453.2	17460.4	1519.0
2014-07-11 06:00:00	YM	Futures	17460.4	17468.7	17439.7	17444.9	2368.0
2014-07-11 07:00:00	YM	Futures	17443.8	17458.3	17443.8	17456.3	2322.0
2014-07-11 08:00:00	YM	Futures	17455.2	17456.3	17413.8	17413.8	4318.0
2014-07-11 09:00:00	YM	Futures	17412.8	17431.4	17365.2	17390.0	22974.0
2014-07-11 10:00:00	YM	Futures	17391.1	17426.3	17373.5	17399.4	17423.0
2014-07-11 11:00:00	YM	Futures	17400.4	17408.7	17375.6	17394.2	11770.0
2014-07-11 12:00:00	YM	Futures	17393.2	17408.7	17386.9	17403.5	4934.0
2014-07-11 13:00:00	YM	Futures	17404.5	17423.2	17402.5	17420.0	5789.0

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

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