PREVIEW / futures_1hour / 2010-07-12

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-12.parquet
  size:    44 KB
  rows:    1,331

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
2010-07-12 00:00:00	ES	Futures	1050.96	1051.7	1049.73	1050.22	970.0
2010-07-12 01:00:00	ES	Futures	1049.98	1050.22	1047.53	1047.53	5100.0
2010-07-12 02:00:00	ES	Futures	1047.53	1048.75	1046.54	1048.26	9273.0
2010-07-12 03:00:00	ES	Futures	1048.26	1049.24	1045.81	1047.03	26203.0
2010-07-12 04:00:00	ES	Futures	1047.03	1049.24	1045.81	1046.54	21309.0
2010-07-12 05:00:00	ES	Futures	1046.79	1047.77	1045.81	1047.53	8849.0
2010-07-12 06:00:00	ES	Futures	1047.77	1048.75	1046.54	1047.77	9504.0
2010-07-12 07:00:00	ES	Futures	1047.77	1049.98	1047.77	1049.24	14233.0
2010-07-12 08:00:00	ES	Futures	1049.24	1051.45	1049.0	1050.96	23302.0
2010-07-12 09:00:00	ES	Futures	1050.96	1057.34	1049.73	1056.36	228709.0
2010-07-12 10:00:00	ES	Futures	1056.11	1056.85	1049.98	1051.45	240778.0
2010-07-12 11:00:00	ES	Futures	1051.21	1051.21	1046.79	1049.98	200845.0
2010-07-12 12:00:00	ES	Futures	1049.73	1054.64	1049.73	1050.96	138290.0
2010-07-12 13:00:00	ES	Futures	1050.96	1055.87	1050.47	1055.38	89252.0
2010-07-12 14:00:00	ES	Futures	1055.13	1055.62	1051.7	1053.66	90039.0
2010-07-12 15:00:00	ES	Futures	1053.91	1055.87	1051.45	1055.38	179951.0
2010-07-12 16:00:00	ES	Futures	1055.13	1058.81	1054.89	1058.57	78729.0
2010-07-12 17:00:00	ES	Futures	1058.57	1061.02	1058.57	1059.06	6793.0
2010-07-12 18:00:00	ES	Futures	1058.81	1059.06	1058.08	1058.81	2515.0
2010-07-12 19:00:00	ES	Futures	1058.81	1059.79	1058.57	1059.55	2345.0
2010-07-12 20:00:00	ES	Futures	1059.55	1062.0	1059.3	1061.02	8259.0
2010-07-12 21:00:00	ES	Futures	1061.27	1061.51	1059.55	1059.55	8759.0
2010-07-12 22:00:00	ES	Futures	1059.79	1059.79	1057.34	1057.59	4719.0
2010-07-12 23:00:00	ES	Futures	1057.83	1057.83	1055.13	1055.62	5297.0
2010-07-12 00:00:00	NQ	Futures	2073.02	2074.45	2071.59	2072.16	140.0
2010-07-12 01:00:00	NQ	Futures	2072.16	2072.45	2067.57	2067.86	328.0
2010-07-12 02:00:00	NQ	Futures	2068.43	2069.29	2066.14	2069.01	492.0
2010-07-12 03:00:00	NQ	Futures	2069.29	2070.44	2064.71	2067.0	1176.0
2010-07-12 04:00:00	NQ	Futures	2067.29	2071.3	2065.28	2067.0	1471.0
2010-07-12 05:00:00	NQ	Futures	2067.0	2068.43	2065.28	2068.43	805.0
2010-07-12 06:00:00	NQ	Futures	2068.43	2070.15	2067.0	2069.01	603.0
2010-07-12 07:00:00	NQ	Futures	2069.01	2072.16	2069.01	2071.3	916.0
2010-07-12 08:00:00	NQ	Futures	2071.59	2076.46	2071.01	2075.88	3207.0
2010-07-12 09:00:00	NQ	Futures	2075.88	2097.38	2073.88	2094.51	49109.0
2010-07-12 10:00:00	NQ	Futures	2094.51	2095.94	2076.46	2080.18	42945.0
2010-07-12 11:00:00	NQ	Futures	2079.9	2079.9	2070.44	2071.59	31612.0
2010-07-12 12:00:00	NQ	Futures	2071.59	2083.05	2070.44	2074.74	23130.0
2010-07-12 13:00:00	NQ	Futures	2075.02	2086.77	2073.59	2085.63	19133.0
2010-07-12 14:00:00	NQ	Futures	2085.63	2087.06	2079.04	2082.76	17834.0
2010-07-12 15:00:00	NQ	Futures	2083.05	2087.92	2077.6	2084.48	37018.0
2010-07-12 16:00:00	NQ	Futures	2084.19	2092.79	2083.62	2091.65	8009.0
2010-07-12 17:00:00	NQ	Futures	2091.65	2095.66	2091.36	2091.36	524.0
2010-07-12 18:00:00	NQ	Futures	2091.65	2091.93	2091.36	2091.93	106.0
2010-07-12 19:00:00	NQ	Futures	2092.22	2093.08	2091.65	2092.22	176.0
2010-07-12 20:00:00	NQ	Futures	2092.22	2097.09	2092.22	2095.08	590.0
2010-07-12 21:00:00	NQ	Futures	2095.08	2095.94	2093.08	2093.36	496.0
2010-07-12 22:00:00	NQ	Futures	2093.08	2093.36	2089.35	2090.5	395.0
2010-07-12 23:00:00	NQ	Futures	2090.21	2090.21	2085.91	2086.77	353.0
2010-07-12 00:00:00	YM	Futures	9578.7	9582.5	9571.1	9571.1	106.0
2010-07-12 01:00:00	YM	Futures	9570.2	9572.1	9551.3	9554.1	314.0

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

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