PREVIEW / futures_1hour / 2010-08-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	1053.17	1054.15	1052.43	1052.92	2613.0
2010-08-23 01:00:00	ES	Futures	1052.92	1053.41	1052.19	1052.19	4524.0
2010-08-23 02:00:00	ES	Futures	1052.43	1053.66	1051.21	1051.94	9218.0
2010-08-23 03:00:00	ES	Futures	1052.19	1053.17	1049.24	1052.68	34479.0
2010-08-23 04:00:00	ES	Futures	1052.92	1055.13	1051.94	1054.89	21181.0
2010-08-23 05:00:00	ES	Futures	1054.89	1055.62	1053.41	1055.13	16121.0
2010-08-23 06:00:00	ES	Futures	1055.38	1057.09	1054.89	1056.36	15917.0
2010-08-23 07:00:00	ES	Futures	1056.36	1057.34	1055.38	1057.09	14339.0
2010-08-23 08:00:00	ES	Futures	1057.09	1057.34	1053.91	1054.15	24177.0
2010-08-23 09:00:00	ES	Futures	1054.4	1060.28	1053.17	1058.32	222218.0
2010-08-23 10:00:00	ES	Futures	1058.08	1058.57	1048.75	1050.47	351578.0
2010-08-23 11:00:00	ES	Futures	1050.47	1051.21	1047.53	1049.0	195012.0
2010-08-23 12:00:00	ES	Futures	1049.24	1052.19	1048.75	1050.22	84695.0
2010-08-23 13:00:00	ES	Futures	1050.22	1051.7	1048.75	1050.72	76454.0
2010-08-23 14:00:00	ES	Futures	1050.72	1054.15	1050.22	1051.45	124666.0
2010-08-23 15:00:00	ES	Futures	1051.45	1052.68	1045.32	1046.05	235225.0
2010-08-23 16:00:00	ES	Futures	1046.05	1046.3	1044.58	1045.56	90299.0
2010-08-23 17:00:00	ES	Futures	1045.56	1046.05	1045.32	1045.56	1350.0
2010-08-23 18:00:00	ES	Futures	1045.81	1045.81	1043.84	1043.84	4485.0
2010-08-23 19:00:00	ES	Futures	1044.09	1044.58	1041.39	1042.37	11132.0
2010-08-23 20:00:00	ES	Futures	1042.62	1043.35	1041.64	1043.11	6332.0
2010-08-23 21:00:00	ES	Futures	1043.11	1043.84	1041.88	1042.86	5822.0
2010-08-23 22:00:00	ES	Futures	1043.11	1044.34	1042.37	1043.84	3552.0
2010-08-23 23:00:00	ES	Futures	1044.09	1045.56	1044.09	1044.09	4118.0
2010-08-23 00:00:00	NQ	Futures	2097.95	2100.24	2097.38	2098.24	274.0
2010-08-23 01:00:00	NQ	Futures	2097.95	2099.1	2097.09	2097.38	357.0
2010-08-23 02:00:00	NQ	Futures	2097.38	2099.96	2095.94	2097.38	411.0
2010-08-23 03:00:00	NQ	Futures	2097.38	2098.52	2091.65	2097.95	2976.0
2010-08-23 04:00:00	NQ	Futures	2098.24	2103.68	2096.23	2103.39	2162.0
2010-08-23 05:00:00	NQ	Futures	2103.39	2103.97	2099.96	2103.39	1151.0
2010-08-23 06:00:00	NQ	Futures	2103.39	2107.69	2102.82	2106.83	1910.0
2010-08-23 07:00:00	NQ	Futures	2106.26	2107.98	2104.25	2107.98	1068.0
2010-08-23 08:00:00	NQ	Futures	2107.41	2108.27	2101.68	2101.96	2864.0
2010-08-23 09:00:00	NQ	Futures	2102.25	2112.28	2100.24	2106.83	39420.0
2010-08-23 10:00:00	NQ	Futures	2106.55	2107.12	2077.89	2081.33	66911.0
2010-08-23 11:00:00	NQ	Futures	2081.04	2081.62	2074.16	2078.18	36976.0
2010-08-23 12:00:00	NQ	Futures	2078.18	2083.91	2077.89	2079.04	19888.0
2010-08-23 13:00:00	NQ	Futures	2079.04	2082.48	2075.31	2081.04	18320.0
2010-08-23 14:00:00	NQ	Futures	2081.04	2086.77	2079.32	2079.9	23264.0
2010-08-23 15:00:00	NQ	Futures	2080.18	2084.19	2071.01	2071.3	41230.0
2010-08-23 16:00:00	NQ	Futures	2071.3	2075.88	2068.72	2073.88	13340.0
2010-08-23 17:00:00	NQ	Futures	2074.16	2074.74	2073.31	2073.31	94.0
2010-08-23 18:00:00	NQ	Futures	2074.74	2074.74	2070.73	2070.73	315.0
2010-08-23 19:00:00	NQ	Futures	2070.44	2071.59	2065.57	2067.57	467.0
2010-08-23 20:00:00	NQ	Futures	2067.29	2069.01	2065.85	2068.72	358.0
2010-08-23 21:00:00	NQ	Futures	2069.01	2070.15	2066.71	2068.43	264.0
2010-08-23 22:00:00	NQ	Futures	2068.15	2070.73	2067.29	2070.15	177.0
2010-08-23 23:00:00	NQ	Futures	2070.15	2073.59	2070.15	2071.59	278.0
2010-08-23 00:00:00	YM	Futures	9671.5	9684.7	9670.5	9676.2	172.0
2010-08-23 01:00:00	YM	Futures	9672.4	9679.1	9668.6	9670.5	345.0

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

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