PREVIEW / futures_1hour / 2014-06-23

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-23.parquet
  size:    47 KB
  rows:    1,487

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-06-23 00:00:00	ES	Futures	2040.35	2041.13	2040.35	2040.87	1281.0
2014-06-23 01:00:00	ES	Futures	2040.87	2040.87	2040.35	2040.61	2455.0
2014-06-23 02:00:00	ES	Futures	2040.61	2041.39	2039.57	2039.83	10959.0
2014-06-23 03:00:00	ES	Futures	2040.09	2040.35	2035.13	2036.7	44975.0
2014-06-23 04:00:00	ES	Futures	2036.7	2037.22	2034.87	2036.44	19115.0
2014-06-23 05:00:00	ES	Futures	2036.18	2039.3	2035.92	2038.78	18204.0
2014-06-23 06:00:00	ES	Futures	2038.78	2039.04	2035.4	2035.66	17528.0
2014-06-23 07:00:00	ES	Futures	2035.92	2037.48	2035.66	2036.18	16015.0
2014-06-23 08:00:00	ES	Futures	2036.18	2037.74	2035.66	2036.44	17989.0
2014-06-23 09:00:00	ES	Futures	2036.7	2038.26	2033.83	2036.18	143808.0
2014-06-23 10:00:00	ES	Futures	2036.44	2038.52	2034.35	2035.4	212044.0
2014-06-23 11:00:00	ES	Futures	2035.13	2035.92	2032.79	2033.83	138470.0
2014-06-23 12:00:00	ES	Futures	2034.09	2036.18	2033.83	2035.66	50024.0
2014-06-23 13:00:00	ES	Futures	2035.92	2035.92	2033.31	2034.61	62317.0
2014-06-23 14:00:00	ES	Futures	2034.61	2035.92	2033.83	2035.66	64110.0
2014-06-23 15:00:00	ES	Futures	2035.66	2037.48	2034.35	2036.7	92958.0
2014-06-23 16:00:00	ES	Futures	2036.44	2036.96	2034.61	2035.13	64685.0
2014-06-23 17:00:00	ES	Futures	2034.87	2035.4	2034.35	2034.35	2198.0
2014-06-23 18:00:00	ES	Futures	2034.09	2034.35	2033.05	2033.83	5255.0
2014-06-23 19:00:00	ES	Futures	2034.09	2034.61	2033.05	2034.61	1902.0
2014-06-23 20:00:00	ES	Futures	2034.35	2034.61	2032.27	2032.79	7774.0
2014-06-23 21:00:00	ES	Futures	2033.05	2033.31	2032.01	2032.53	5691.0
2014-06-23 22:00:00	ES	Futures	2032.27	2033.57	2032.27	2033.31	3430.0
2014-06-23 23:00:00	ES	Futures	2033.05	2033.31	2032.53	2032.79	1848.0
2014-06-23 00:00:00	NQ	Futures	4440.67	4442.13	4440.38	4441.54	198.0
2014-06-23 01:00:00	NQ	Futures	4441.54	4441.54	4440.38	4440.96	380.0
2014-06-23 02:00:00	NQ	Futures	4440.67	4442.13	4435.12	4436.29	1727.0
2014-06-23 03:00:00	NQ	Futures	4436.29	4436.29	4423.15	4426.07	7165.0
2014-06-23 04:00:00	NQ	Futures	4426.07	4426.07	4422.27	4424.02	2347.0
2014-06-23 05:00:00	NQ	Futures	4424.02	4431.32	4423.73	4431.03	3379.0
2014-06-23 06:00:00	NQ	Futures	4431.32	4431.61	4426.07	4426.65	2895.0
2014-06-23 07:00:00	NQ	Futures	4426.65	4429.57	4426.36	4427.53	2016.0
2014-06-23 08:00:00	NQ	Futures	4427.53	4430.15	4426.07	4428.69	2261.0
2014-06-23 09:00:00	NQ	Futures	4428.69	4434.83	4423.73	4431.32	26672.0
2014-06-23 10:00:00	NQ	Futures	4431.32	4434.24	4421.98	4424.31	35235.0
2014-06-23 11:00:00	NQ	Futures	4424.02	4428.69	4421.39	4424.9	21347.0
2014-06-23 12:00:00	NQ	Futures	4424.61	4435.7	4424.61	4431.91	11518.0
2014-06-23 13:00:00	NQ	Futures	4432.2	4433.95	4425.48	4430.45	10659.0
2014-06-23 14:00:00	NQ	Futures	4430.15	4434.54	4428.69	4433.37	10275.0
2014-06-23 15:00:00	NQ	Futures	4433.37	4434.54	4428.4	4434.54	14312.0
2014-06-23 16:00:00	NQ	Futures	4434.54	4435.41	4430.15	4431.61	4508.0
2014-06-23 17:00:00	NQ	Futures	4431.61	4431.91	4430.15	4430.45	201.0
2014-06-23 18:00:00	NQ	Futures	4429.28	4429.57	4426.94	4428.99	568.0
2014-06-23 19:00:00	NQ	Futures	4428.99	4430.45	4427.53	4430.15	190.0
2014-06-23 20:00:00	NQ	Futures	4430.15	4430.45	4425.77	4427.23	1014.0
2014-06-23 21:00:00	NQ	Futures	4426.94	4427.23	4424.9	4425.77	661.0
2014-06-23 22:00:00	NQ	Futures	4425.77	4428.4	4425.77	4427.82	390.0
2014-06-23 23:00:00	NQ	Futures	4427.82	4428.11	4426.36	4427.53	343.0
2014-06-23 00:00:00	YM	Futures	17475.9	17479.0	17474.9	17479.0	197.0
2014-06-23 01:00:00	YM	Futures	17478.0	17479.0	17472.8	17475.9	727.0

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

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