PREVIEW / futures_1hour / 2014-06-30

all futures 1-hour files

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

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-30 00:00:00	ES	Futures	2035.66	2036.18	2035.13	2035.66	1736.0
2014-06-30 01:00:00	ES	Futures	2035.66	2035.92	2034.87	2035.92	1903.0
2014-06-30 02:00:00	ES	Futures	2035.66	2035.92	2034.09	2034.61	4795.0
2014-06-30 03:00:00	ES	Futures	2034.35	2036.18	2033.83	2035.4	21204.0
2014-06-30 04:00:00	ES	Futures	2035.13	2035.13	2033.57	2034.61	10944.0
2014-06-30 05:00:00	ES	Futures	2034.61	2034.87	2033.57	2034.61	5114.0
2014-06-30 06:00:00	ES	Futures	2034.61	2035.4	2032.27	2032.27	13216.0
2014-06-30 07:00:00	ES	Futures	2032.53	2033.31	2030.7	2033.05	18655.0
2014-06-30 08:00:00	ES	Futures	2032.79	2035.4	2032.79	2034.09	17314.0
2014-06-30 09:00:00	ES	Futures	2034.09	2036.44	2033.31	2035.66	153003.0
2014-06-30 10:00:00	ES	Futures	2035.66	2039.83	2034.61	2035.13	235538.0
2014-06-30 11:00:00	ES	Futures	2035.13	2038.78	2033.83	2036.44	129097.0
2014-06-30 12:00:00	ES	Futures	2036.44	2037.48	2035.4	2036.44	44410.0
2014-06-30 13:00:00	ES	Futures	2036.44	2037.74	2036.44	2037.22	36444.0
2014-06-30 14:00:00	ES	Futures	2037.22	2039.04	2035.13	2035.66	67203.0
2014-06-30 15:00:00	ES	Futures	2035.4	2036.96	2033.05	2034.87	241645.0
2014-06-30 16:00:00	ES	Futures	2034.87	2037.74	2034.61	2037.22	130763.0
2014-06-30 17:00:00	ES	Futures	2037.48	2038.0	2037.22	2038.0	3393.0
2014-06-30 18:00:00	ES	Futures	2037.48	2038.0	2036.44	2036.96	6047.0
2014-06-30 19:00:00	ES	Futures	2036.7	2038.0	2036.7	2037.74	2307.0
2014-06-30 20:00:00	ES	Futures	2037.74	2038.52	2036.7	2036.96	6746.0
2014-06-30 21:00:00	ES	Futures	2036.96	2038.26	2036.44	2038.0	2782.0
2014-06-30 22:00:00	ES	Futures	2038.0	2038.26	2037.74	2038.0	1304.0
2014-06-30 23:00:00	ES	Futures	2038.26	2038.52	2037.74	2038.26	1029.0
2014-06-30 00:00:00	NQ	Futures	4479.21	4479.8	4478.63	4479.51	444.0
2014-06-30 01:00:00	NQ	Futures	4479.8	4480.09	4478.34	4479.51	210.0
2014-06-30 02:00:00	NQ	Futures	4479.8	4480.09	4474.83	4476.29	858.0
2014-06-30 03:00:00	NQ	Futures	4476.29	4480.38	4475.42	4478.34	2436.0
2014-06-30 04:00:00	NQ	Futures	4478.34	4478.63	4475.71	4477.46	1470.0
2014-06-30 05:00:00	NQ	Futures	4477.46	4477.75	4475.42	4477.17	862.0
2014-06-30 06:00:00	NQ	Futures	4476.88	4478.92	4473.37	4473.37	1544.0
2014-06-30 07:00:00	NQ	Futures	4473.66	4476.29	4471.04	4476.0	2253.0
2014-06-30 08:00:00	NQ	Futures	4475.71	4479.8	4475.71	4477.75	2803.0
2014-06-30 09:00:00	NQ	Futures	4477.46	4489.14	4475.71	4485.93	29104.0
2014-06-30 10:00:00	NQ	Futures	4486.22	4492.35	4483.89	4484.47	29786.0
2014-06-30 11:00:00	NQ	Futures	4484.47	4493.81	4482.13	4489.14	18608.0
2014-06-30 12:00:00	NQ	Futures	4488.85	4493.52	4487.68	4491.19	8768.0
2014-06-30 13:00:00	NQ	Futures	4491.19	4496.44	4490.89	4494.69	9389.0
2014-06-30 14:00:00	NQ	Futures	4494.69	4498.49	4487.97	4488.85	12171.0
2014-06-30 15:00:00	NQ	Futures	4488.85	4492.94	4484.18	4487.68	24306.0
2014-06-30 16:00:00	NQ	Futures	4487.39	4494.69	4486.81	4493.52	7204.0
2014-06-30 17:00:00	NQ	Futures	4493.81	4494.69	4492.94	4493.23	173.0
2014-06-30 18:00:00	NQ	Futures	4493.52	4494.11	4490.89	4491.77	473.0
2014-06-30 19:00:00	NQ	Futures	4491.77	4493.23	4490.89	4492.94	231.0
2014-06-30 20:00:00	NQ	Futures	4493.23	4494.11	4491.48	4492.35	521.0
2014-06-30 21:00:00	NQ	Futures	4492.35	4494.11	4491.48	4493.81	408.0
2014-06-30 22:00:00	NQ	Futures	4494.11	4494.4	4493.23	4494.4	210.0
2014-06-30 23:00:00	NQ	Futures	4494.4	4494.4	4493.52	4493.81	224.0
2014-06-30 00:00:00	YM	Futures	17345.6	17345.6	17340.4	17343.5	184.0
2014-06-30 01:00:00	YM	Futures	17343.5	17345.6	17338.3	17344.5	216.0

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

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