PREVIEW / futures_1hour / 2010-06-07

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-07.parquet
  size:    45 KB
  rows:    1,338

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-06-07 00:00:00	ES	Futures	1033.19	1036.12	1032.7	1035.15	5830.0
2010-06-07 01:00:00	ES	Futures	1035.15	1038.08	1033.68	1036.12	9816.0
2010-06-07 02:00:00	ES	Futures	1036.12	1037.59	1032.7	1036.86	13887.0
2010-06-07 03:00:00	ES	Futures	1036.86	1040.28	1034.66	1035.63	43653.0
2010-06-07 04:00:00	ES	Futures	1035.39	1039.79	1034.41	1039.06	29754.0
2010-06-07 05:00:00	ES	Futures	1039.3	1042.48	1037.35	1042.23	24708.0
2010-06-07 06:00:00	ES	Futures	1042.23	1044.68	1040.77	1043.7	27133.0
2010-06-07 07:00:00	ES	Futures	1043.7	1045.9	1042.72	1043.94	39672.0
2010-06-07 08:00:00	ES	Futures	1043.7	1046.88	1042.97	1043.94	51001.0
2010-06-07 09:00:00	ES	Futures	1043.94	1045.17	1036.86	1043.7	318587.0
2010-06-07 10:00:00	ES	Futures	1043.7	1046.88	1034.66	1035.39	379000.0
2010-06-07 11:00:00	ES	Futures	1035.39	1041.26	1033.92	1041.26	254468.0
2010-06-07 12:00:00	ES	Futures	1041.26	1043.94	1040.03	1042.23	134047.0
2010-06-07 13:00:00	ES	Futures	1042.48	1044.92	1037.83	1039.06	134451.0
2010-06-07 14:00:00	ES	Futures	1039.06	1040.77	1032.7	1034.41	201972.0
2010-06-07 15:00:00	ES	Futures	1034.41	1037.83	1025.37	1026.35	456536.0
2010-06-07 16:00:00	ES	Futures	1026.35	1027.57	1023.66	1025.86	124575.0
2010-06-07 17:00:00	ES	Futures	1026.1	1026.35	1025.37	1025.86	3394.0
2010-06-07 18:00:00	ES	Futures	1025.61	1026.1	1024.15	1025.86	4984.0
2010-06-07 19:00:00	ES	Futures	1025.86	1028.55	1025.86	1028.06	6451.0
2010-06-07 20:00:00	ES	Futures	1028.06	1030.01	1027.57	1029.52	11759.0
2010-06-07 21:00:00	ES	Futures	1029.52	1033.19	1029.52	1031.72	15805.0
2010-06-07 22:00:00	ES	Futures	1031.97	1032.46	1030.5	1031.23	6400.0
2010-06-07 23:00:00	ES	Futures	1031.23	1033.43	1030.99	1032.95	6099.0
2010-06-07 00:00:00	NQ	Futures	2085.08	2088.52	2083.36	2088.52	1263.0
2010-06-07 01:00:00	NQ	Futures	2088.23	2092.52	2084.22	2089.09	1442.0
2010-06-07 02:00:00	NQ	Futures	2088.52	2091.38	2081.93	2089.66	1529.0
2010-06-07 03:00:00	NQ	Futures	2090.23	2097.39	2088.52	2090.23	4572.0
2010-06-07 04:00:00	NQ	Futures	2090.23	2097.68	2087.66	2096.82	2572.0
2010-06-07 05:00:00	NQ	Futures	2097.11	2103.12	2093.67	2102.83	2473.0
2010-06-07 06:00:00	NQ	Futures	2102.83	2106.56	2101.12	2104.84	1809.0
2010-06-07 07:00:00	NQ	Futures	2104.84	2109.42	2104.27	2106.27	3647.0
2010-06-07 08:00:00	NQ	Futures	2106.27	2113.43	2105.12	2107.99	5432.0
2010-06-07 09:00:00	NQ	Futures	2108.28	2112.57	2091.95	2108.56	45988.0
2010-06-07 10:00:00	NQ	Futures	2108.28	2114.0	2077.63	2078.78	55803.0
2010-06-07 11:00:00	NQ	Futures	2079.07	2090.81	2074.77	2089.95	41055.0
2010-06-07 12:00:00	NQ	Futures	2089.95	2096.25	2087.08	2094.53	22363.0
2010-06-07 13:00:00	NQ	Futures	2094.82	2100.83	2083.07	2086.22	23146.0
2010-06-07 14:00:00	NQ	Futures	2085.94	2089.09	2067.61	2072.48	33444.0
2010-06-07 15:00:00	NQ	Futures	2072.76	2079.35	2056.16	2058.73	66375.0
2010-06-07 16:00:00	NQ	Futures	2059.02	2061.02	2054.72	2057.3	12682.0
2010-06-07 17:00:00	NQ	Futures	2057.87	2058.73	2056.44	2057.87	301.0
2010-06-07 18:00:00	NQ	Futures	2057.01	2058.73	2055.01	2058.45	185.0
2010-06-07 19:00:00	NQ	Futures	2058.45	2065.03	2057.87	2064.46	683.0
2010-06-07 20:00:00	NQ	Futures	2064.17	2068.47	2063.6	2067.61	977.0
2010-06-07 21:00:00	NQ	Futures	2067.61	2073.34	2067.61	2070.19	1200.0
2010-06-07 22:00:00	NQ	Futures	2070.19	2073.05	2068.18	2069.9	623.0
2010-06-07 23:00:00	NQ	Futures	2069.9	2074.48	2069.61	2073.05	505.0
2010-06-07 00:00:00	YM	Futures	9276.2	9305.4	9273.4	9294.1	618.0
2010-06-07 01:00:00	YM	Futures	9295.9	9313.8	9285.6	9303.5	938.0

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

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