PREVIEW / futures_1hour / 2010-08-16

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-16.parquet
  size:    44 KB
  rows:    1,291

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-08-16 00:00:00	ES	Futures	1052.19	1057.34	1051.94	1055.87	6493.0
2010-08-16 01:00:00	ES	Futures	1055.87	1058.32	1055.62	1057.59	5251.0
2010-08-16 02:00:00	ES	Futures	1057.34	1060.04	1057.34	1059.06	10990.0
2010-08-16 03:00:00	ES	Futures	1058.81	1061.51	1057.09	1057.09	27029.0
2010-08-16 04:00:00	ES	Futures	1056.85	1057.09	1051.45	1053.41	39183.0
2010-08-16 05:00:00	ES	Futures	1053.17	1056.6	1051.94	1053.41	22548.0
2010-08-16 06:00:00	ES	Futures	1053.41	1055.38	1052.68	1053.66	14761.0
2010-08-16 07:00:00	ES	Futures	1053.41	1054.64	1051.21	1052.92	25109.0
2010-08-16 08:00:00	ES	Futures	1052.68	1055.38	1050.72	1053.41	42302.0
2010-08-16 09:00:00	ES	Futures	1053.41	1054.89	1046.54	1052.68	283950.0
2010-08-16 10:00:00	ES	Futures	1052.68	1059.55	1051.21	1057.83	304313.0
2010-08-16 11:00:00	ES	Futures	1058.08	1059.06	1055.13	1058.32	147178.0
2010-08-16 12:00:00	ES	Futures	1058.32	1060.78	1058.08	1059.3	117682.0
2010-08-16 13:00:00	ES	Futures	1059.3	1060.28	1057.59	1058.32	81148.0
2010-08-16 14:00:00	ES	Futures	1058.32	1059.3	1053.41	1053.91	153255.0
2010-08-16 15:00:00	ES	Futures	1053.66	1058.08	1052.92	1057.59	206371.0
2010-08-16 16:00:00	ES	Futures	1057.34	1058.32	1056.85	1057.34	74077.0
2010-08-16 17:00:00	ES	Futures	1057.34	1058.57	1057.34	1057.59	1396.0
2010-08-16 18:00:00	ES	Futures	1057.83	1058.57	1057.09	1057.34	2058.0
2010-08-16 19:00:00	ES	Futures	1057.09	1057.59	1055.13	1055.62	3003.0
2010-08-16 20:00:00	ES	Futures	1055.87	1057.34	1054.64	1055.38	6678.0
2010-08-16 21:00:00	ES	Futures	1055.62	1058.32	1055.38	1058.32	6387.0
2010-08-16 22:00:00	ES	Futures	1058.08	1059.79	1056.85	1059.55	6440.0
2010-08-16 23:00:00	ES	Futures	1059.79	1061.51	1059.55	1060.28	5720.0
2010-08-16 00:00:00	NQ	Futures	2075.31	2084.77	2075.02	2082.48	540.0
2010-08-16 01:00:00	NQ	Futures	2083.05	2087.35	2082.48	2085.91	444.0
2010-08-16 02:00:00	NQ	Futures	2086.2	2089.93	2085.91	2087.63	919.0
2010-08-16 03:00:00	NQ	Futures	2087.92	2092.22	2083.91	2084.19	1519.0
2010-08-16 04:00:00	NQ	Futures	2084.19	2084.77	2072.45	2077.32	2543.0
2010-08-16 05:00:00	NQ	Futures	2076.46	2083.05	2074.16	2077.32	1590.0
2010-08-16 06:00:00	NQ	Futures	2077.89	2081.04	2076.17	2078.46	1176.0
2010-08-16 07:00:00	NQ	Futures	2078.46	2079.9	2073.59	2075.88	1542.0
2010-08-16 08:00:00	NQ	Futures	2075.88	2080.18	2073.02	2077.32	3433.0
2010-08-16 09:00:00	NQ	Futures	2077.03	2087.06	2063.28	2083.62	55022.0
2010-08-16 10:00:00	NQ	Futures	2083.91	2097.95	2080.76	2095.37	54835.0
2010-08-16 11:00:00	NQ	Futures	2095.37	2096.52	2088.49	2094.8	31047.0
2010-08-16 12:00:00	NQ	Futures	2094.8	2101.39	2094.22	2095.66	29568.0
2010-08-16 13:00:00	NQ	Futures	2095.66	2097.09	2090.79	2092.51	18486.0
2010-08-16 14:00:00	NQ	Futures	2092.22	2094.51	2080.47	2081.04	30030.0
2010-08-16 15:00:00	NQ	Futures	2080.76	2088.21	2076.46	2087.06	43090.0
2010-08-16 16:00:00	NQ	Futures	2087.06	2088.21	2085.34	2087.35	7182.0
2010-08-16 17:00:00	NQ	Futures	2087.06	2089.07	2087.06	2087.06	51.0
2010-08-16 18:00:00	NQ	Futures	2088.78	2089.35	2087.06	2087.06	107.0
2010-08-16 19:00:00	NQ	Futures	2087.06	2087.92	2083.62	2084.19	231.0
2010-08-16 20:00:00	NQ	Futures	2084.48	2087.35	2082.76	2083.91	326.0
2010-08-16 21:00:00	NQ	Futures	2084.19	2090.5	2084.19	2089.93	542.0
2010-08-16 22:00:00	NQ	Futures	2089.93	2092.79	2087.63	2092.79	468.0
2010-08-16 23:00:00	NQ	Futures	2092.51	2094.51	2091.93	2093.08	463.0
2010-08-16 00:00:00	YM	Futures	9687.6	9730.2	9686.6	9717.9	542.0
2010-08-16 01:00:00	YM	Futures	9718.8	9738.7	9715.0	9730.2	405.0

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

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