PREVIEW / futures_1hour / 2010-08-12

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-12.parquet
  size:    46 KB
  rows:    1,369

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-12 00:00:00	ES	Futures	1060.53	1062.98	1059.79	1061.51	7123.0
2010-08-12 01:00:00	ES	Futures	1061.76	1063.97	1060.04	1063.47	7165.0
2010-08-12 02:00:00	ES	Futures	1063.72	1064.7	1061.76	1062.25	19497.0
2010-08-12 03:00:00	ES	Futures	1062.49	1067.4	1062.49	1066.91	41822.0
2010-08-12 04:00:00	ES	Futures	1066.66	1066.91	1062.49	1063.72	32735.0
2010-08-12 05:00:00	ES	Futures	1063.72	1064.95	1061.27	1061.76	28871.0
2010-08-12 06:00:00	ES	Futures	1061.76	1064.7	1061.51	1063.23	19653.0
2010-08-12 07:00:00	ES	Futures	1063.23	1064.95	1060.28	1061.02	41677.0
2010-08-12 08:00:00	ES	Futures	1061.02	1061.02	1052.92	1054.89	159660.0
2010-08-12 09:00:00	ES	Futures	1054.89	1059.55	1050.72	1058.08	393639.0
2010-08-12 10:00:00	ES	Futures	1058.32	1063.72	1057.09	1061.76	356803.0
2010-08-12 11:00:00	ES	Futures	1062.0	1064.46	1059.3	1062.25	210211.0
2010-08-12 12:00:00	ES	Futures	1062.0	1063.97	1060.28	1063.97	104120.0
2010-08-12 13:00:00	ES	Futures	1063.97	1064.46	1058.32	1059.06	139772.0
2010-08-12 14:00:00	ES	Futures	1058.81	1061.27	1057.34	1060.53	139198.0
2010-08-12 15:00:00	ES	Futures	1060.28	1064.7	1059.3	1061.27	290150.0
2010-08-12 16:00:00	ES	Futures	1061.27	1061.27	1058.57	1059.55	88720.0
2010-08-12 17:00:00	ES	Futures	1059.55	1060.53	1059.3	1059.79	1240.0
2010-08-12 18:00:00	ES	Futures	1060.04	1061.02	1059.55	1061.02	1661.0
2010-08-12 19:00:00	ES	Futures	1060.78	1062.49	1060.78	1061.51	4395.0
2010-08-12 20:00:00	ES	Futures	1061.51	1063.72	1060.04	1062.25	8412.0
2010-08-12 21:00:00	ES	Futures	1062.49	1062.74	1060.28	1062.74	3933.0
2010-08-12 22:00:00	ES	Futures	1062.74	1064.7	1062.0	1063.23	4822.0
2010-08-12 23:00:00	ES	Futures	1063.23	1065.93	1062.25	1065.93	5843.0
2010-08-12 00:00:00	NQ	Futures	2091.36	2097.09	2090.5	2095.08	727.0
2010-08-12 01:00:00	NQ	Futures	2094.8	2099.38	2092.22	2099.1	517.0
2010-08-12 02:00:00	NQ	Futures	2099.1	2102.82	2097.09	2097.95	1572.0
2010-08-12 03:00:00	NQ	Futures	2098.24	2106.55	2098.24	2105.69	2371.0
2010-08-12 04:00:00	NQ	Futures	2105.97	2105.97	2099.38	2101.96	2269.0
2010-08-12 05:00:00	NQ	Futures	2101.68	2104.54	2097.38	2097.66	1883.0
2010-08-12 06:00:00	NQ	Futures	2097.66	2102.53	2097.38	2099.96	2451.0
2010-08-12 07:00:00	NQ	Futures	2099.96	2103.11	2095.66	2096.8	3250.0
2010-08-12 08:00:00	NQ	Futures	2096.8	2096.8	2078.46	2081.9	16681.0
2010-08-12 09:00:00	NQ	Futures	2081.62	2094.51	2070.44	2091.65	69809.0
2010-08-12 10:00:00	NQ	Futures	2091.65	2105.69	2089.93	2101.39	59201.0
2010-08-12 11:00:00	NQ	Futures	2101.39	2106.26	2096.52	2102.25	35024.0
2010-08-12 12:00:00	NQ	Futures	2102.53	2105.97	2097.38	2105.4	24025.0
2010-08-12 13:00:00	NQ	Futures	2105.4	2107.12	2092.22	2094.51	26839.0
2010-08-12 14:00:00	NQ	Futures	2094.51	2098.81	2089.93	2096.8	28585.0
2010-08-12 15:00:00	NQ	Futures	2096.8	2105.97	2094.51	2098.24	50284.0
2010-08-12 16:00:00	NQ	Futures	2097.95	2099.1	2095.37	2097.09	10448.0
2010-08-12 17:00:00	NQ	Futures	2097.38	2097.95	2096.52	2097.66	83.0
2010-08-12 18:00:00	NQ	Futures	2098.52	2099.38	2096.23	2099.38	122.0
2010-08-12 19:00:00	NQ	Futures	2099.38	2101.68	2098.81	2099.67	255.0
2010-08-12 20:00:00	NQ	Futures	2100.24	2103.97	2097.95	2101.39	379.0
2010-08-12 21:00:00	NQ	Futures	2099.96	2101.96	2098.24	2101.68	252.0
2010-08-12 22:00:00	NQ	Futures	2102.25	2105.4	2101.39	2102.82	687.0
2010-08-12 23:00:00	NQ	Futures	2102.53	2107.12	2100.53	2106.83	505.0
2010-08-12 00:00:00	YM	Futures	9746.3	9766.1	9741.5	9759.5	526.0
2010-08-12 01:00:00	YM	Futures	9756.7	9781.3	9743.4	9777.5	718.0

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

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