PREVIEW / futures_1hour / 2010-08-18

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-18.parquet
  size:    45 KB
  rows:    1,344

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-18 00:00:00	ES	Futures	1066.91	1068.63	1066.66	1067.89	3996.0
2010-08-18 01:00:00	ES	Futures	1067.89	1069.61	1067.4	1067.89	4723.0
2010-08-18 02:00:00	ES	Futures	1067.89	1069.61	1067.65	1068.38	8324.0
2010-08-18 03:00:00	ES	Futures	1068.63	1068.87	1064.46	1065.44	28957.0
2010-08-18 04:00:00	ES	Futures	1065.19	1067.4	1065.19	1066.42	16095.0
2010-08-18 05:00:00	ES	Futures	1066.42	1070.1	1066.17	1069.61	32701.0
2010-08-18 06:00:00	ES	Futures	1069.36	1069.36	1067.16	1067.4	13802.0
2010-08-18 07:00:00	ES	Futures	1067.4	1070.59	1067.4	1069.61	21501.0
2010-08-18 08:00:00	ES	Futures	1069.36	1072.8	1069.12	1072.06	40847.0
2010-08-18 09:00:00	ES	Futures	1072.31	1072.8	1063.72	1066.42	287652.0
2010-08-18 10:00:00	ES	Futures	1066.42	1069.36	1064.46	1066.91	270580.0
2010-08-18 11:00:00	ES	Futures	1067.16	1071.82	1066.42	1070.59	218872.0
2010-08-18 12:00:00	ES	Futures	1070.59	1074.52	1069.36	1074.03	132031.0
2010-08-18 13:00:00	ES	Futures	1074.03	1077.71	1073.54	1077.22	172899.0
2010-08-18 14:00:00	ES	Futures	1077.22	1078.2	1074.76	1075.5	129139.0
2010-08-18 15:00:00	ES	Futures	1075.74	1076.48	1072.06	1072.31	251901.0
2010-08-18 16:00:00	ES	Futures	1072.31	1072.55	1065.93	1068.38	146749.0
2010-08-18 17:00:00	ES	Futures	1068.14	1068.38	1066.91	1067.65	1945.0
2010-08-18 18:00:00	ES	Futures	1067.4	1067.65	1066.17	1067.4	2746.0
2010-08-18 19:00:00	ES	Futures	1067.4	1067.65	1065.68	1065.68	3666.0
2010-08-18 20:00:00	ES	Futures	1065.93	1068.87	1065.44	1068.38	8192.0
2010-08-18 21:00:00	ES	Futures	1068.63	1069.12	1067.16	1068.63	5402.0
2010-08-18 22:00:00	ES	Futures	1068.63	1069.36	1065.93	1067.65	6189.0
2010-08-18 23:00:00	ES	Futures	1067.65	1068.14	1066.66	1067.65	4033.0
2010-08-18 00:00:00	NQ	Futures	2105.69	2107.98	2105.4	2106.83	312.0
2010-08-18 01:00:00	NQ	Futures	2106.83	2109.99	2106.26	2107.69	530.0
2010-08-18 02:00:00	NQ	Futures	2107.41	2109.99	2107.12	2107.98	591.0
2010-08-18 03:00:00	NQ	Futures	2108.55	2109.13	2098.81	2099.96	3481.0
2010-08-18 04:00:00	NQ	Futures	2099.96	2104.83	2099.96	2102.53	1732.0
2010-08-18 05:00:00	NQ	Futures	2102.25	2109.99	2102.25	2108.27	1838.0
2010-08-18 06:00:00	NQ	Futures	2108.27	2108.55	2102.53	2102.82	2155.0
2010-08-18 07:00:00	NQ	Futures	2102.82	2110.27	2102.82	2107.69	1943.0
2010-08-18 08:00:00	NQ	Futures	2107.41	2114.0	2106.83	2113.14	4998.0
2010-08-18 09:00:00	NQ	Futures	2113.14	2113.71	2100.82	2111.13	53712.0
2010-08-18 10:00:00	NQ	Futures	2111.13	2118.87	2107.12	2112.56	47645.0
2010-08-18 11:00:00	NQ	Futures	2112.28	2124.31	2111.13	2122.31	36474.0
2010-08-18 12:00:00	NQ	Futures	2122.02	2129.76	2120.3	2128.04	24410.0
2010-08-18 13:00:00	NQ	Futures	2128.33	2134.63	2127.47	2132.91	29122.0
2010-08-18 14:00:00	NQ	Futures	2132.91	2134.34	2126.89	2127.75	23451.0
2010-08-18 15:00:00	NQ	Futures	2127.75	2129.47	2119.73	2121.45	42822.0
2010-08-18 16:00:00	NQ	Futures	2121.16	2121.73	2103.97	2109.13	21603.0
2010-08-18 17:00:00	NQ	Futures	2109.41	2109.7	2106.26	2107.98	122.0
2010-08-18 18:00:00	NQ	Futures	2108.27	2108.27	2104.83	2107.69	616.0
2010-08-18 19:00:00	NQ	Futures	2107.98	2108.27	2104.83	2105.11	424.0
2010-08-18 20:00:00	NQ	Futures	2105.11	2109.7	2102.53	2109.13	571.0
2010-08-18 21:00:00	NQ	Futures	2109.41	2110.56	2107.41	2109.99	372.0
2010-08-18 22:00:00	NQ	Futures	2109.99	2110.56	2103.97	2107.69	357.0
2010-08-18 23:00:00	NQ	Futures	2107.41	2109.13	2105.97	2107.41	217.0
2010-08-18 00:00:00	YM	Futures	9798.3	9810.6	9798.3	9807.8	373.0
2010-08-18 01:00:00	YM	Futures	9805.9	9819.1	9798.3	9805.9	467.0

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

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