PREVIEW / futures_1hour / 2015-09-23

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-23.parquet
  size:    51 KB
  rows:    1,518

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
2015-09-23 00:00:00	ES	Futures	2049.37	2050.44	2046.96	2048.03	3923.0
2015-09-23 01:00:00	ES	Futures	2048.3	2050.97	2047.23	2049.9	6208.0
2015-09-23 02:00:00	ES	Futures	2049.64	2058.73	2049.1	2057.13	18366.0
2015-09-23 03:00:00	ES	Futures	2057.13	2065.42	2054.72	2064.35	44369.0
2015-09-23 04:00:00	ES	Futures	2064.35	2075.32	2062.75	2072.65	43828.0
2015-09-23 05:00:00	ES	Futures	2072.65	2073.72	2069.17	2072.11	18082.0
2015-09-23 06:00:00	ES	Futures	2072.11	2073.72	2067.83	2073.72	18774.0
2015-09-23 07:00:00	ES	Futures	2073.72	2078.27	2066.23	2069.17	63219.0
2015-09-23 08:00:00	ES	Futures	2069.44	2074.25	2067.56	2070.24	46213.0
2015-09-23 09:00:00	ES	Futures	2069.97	2072.11	2061.41	2065.69	176160.0
2015-09-23 10:00:00	ES	Futures	2065.96	2075.06	2064.89	2072.38	175156.0
2015-09-23 11:00:00	ES	Futures	2072.11	2072.92	2057.13	2059.8	163606.0
2015-09-23 12:00:00	ES	Futures	2059.8	2061.14	2055.79	2060.34	106459.0
2015-09-23 13:00:00	ES	Futures	2060.34	2068.1	2057.93	2065.69	119372.0
2015-09-23 14:00:00	ES	Futures	2065.42	2070.78	2060.88	2063.02	124533.0
2015-09-23 15:00:00	ES	Futures	2062.75	2067.03	2060.07	2063.28	166492.0
2015-09-23 16:00:00	ES	Futures	2063.28	2067.56	2062.48	2067.3	57064.0
2015-09-23 18:00:00	ES	Futures	2067.56	2070.78	2065.96	2066.49	3921.0
2015-09-23 19:00:00	ES	Futures	2066.76	2067.83	2064.35	2065.16	2341.0
2015-09-23 20:00:00	ES	Futures	2065.16	2069.44	2061.14	2061.41	11018.0
2015-09-23 21:00:00	ES	Futures	2061.68	2066.49	2061.14	2064.62	8613.0
2015-09-23 22:00:00	ES	Futures	2064.35	2064.62	2055.26	2057.4	11836.0
2015-09-23 23:00:00	ES	Futures	2057.13	2057.66	2051.78	2057.13	11988.0
2015-09-23 00:00:00	NQ	Futures	5015.74	5019.3	5010.7	5013.07	626.0
2015-09-23 01:00:00	NQ	Futures	5013.07	5019.3	5010.4	5017.22	1182.0
2015-09-23 02:00:00	NQ	Futures	5016.92	5038.57	5012.48	5035.31	3651.0
2015-09-23 03:00:00	NQ	Futures	5035.9	5061.1	5026.71	5058.14	10049.0
2015-09-23 04:00:00	NQ	Futures	5058.14	5085.12	5054.58	5079.48	8855.0
2015-09-23 05:00:00	NQ	Futures	5079.19	5080.67	5070.0	5076.22	2869.0
2015-09-23 06:00:00	NQ	Futures	5076.52	5078.0	5066.74	5078.0	2581.0
2015-09-23 07:00:00	NQ	Futures	5078.3	5091.05	5063.77	5069.7	7989.0
2015-09-23 08:00:00	NQ	Futures	5069.4	5081.26	5065.55	5072.37	6770.0
2015-09-23 09:00:00	NQ	Futures	5072.37	5076.52	5037.38	5051.32	34142.0
2015-09-23 10:00:00	NQ	Futures	5051.91	5080.67	5049.84	5075.33	29910.0
2015-09-23 11:00:00	NQ	Futures	5075.63	5078.0	5035.6	5044.2	25990.0
2015-09-23 12:00:00	NQ	Futures	5044.2	5053.69	5030.86	5051.02	17379.0
2015-09-23 13:00:00	NQ	Futures	5051.32	5067.03	5041.53	5063.18	18336.0
2015-09-23 14:00:00	NQ	Futures	5063.18	5077.41	5047.76	5052.5	22345.0
2015-09-23 15:00:00	NQ	Futures	5052.21	5067.03	5045.09	5055.76	26519.0
2015-09-23 16:00:00	NQ	Futures	5056.06	5063.47	5053.69	5061.99	6399.0
2015-09-23 18:00:00	NQ	Futures	5062.29	5072.96	5061.1	5063.18	1133.0
2015-09-23 19:00:00	NQ	Futures	5062.88	5067.03	5057.25	5059.03	439.0
2015-09-23 20:00:00	NQ	Futures	5059.32	5071.18	5048.95	5050.13	1695.0
2015-09-23 21:00:00	NQ	Futures	5049.84	5061.99	5048.95	5056.36	1558.0
2015-09-23 22:00:00	NQ	Futures	5056.65	5056.95	5035.01	5040.35	2434.0
2015-09-23 23:00:00	NQ	Futures	5040.35	5041.24	5027.6	5039.75	2688.0
2015-09-23 00:00:00	YM	Futures	17039.2	17049.7	17021.1	17032.8	523.0
2015-09-23 01:00:00	YM	Futures	17033.9	17045.5	17022.2	17036.0	1338.0
2015-09-23 02:00:00	YM	Futures	17034.9	17109.1	17029.6	17093.2	2949.0
2015-09-23 03:00:00	YM	Futures	17095.3	17164.1	17080.5	17155.7	6139.0

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

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