PREVIEW / futures_1hour / 2010-08-04

all futures 1-hour files

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

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-04 00:00:00	ES	Futures	1095.86	1096.36	1094.39	1094.88	6269.0
2010-08-04 01:00:00	ES	Futures	1095.13	1095.37	1093.66	1094.15	3584.0
2010-08-04 02:00:00	ES	Futures	1094.39	1096.36	1093.17	1096.11	10044.0
2010-08-04 03:00:00	ES	Futures	1095.86	1096.36	1093.41	1093.9	22863.0
2010-08-04 04:00:00	ES	Futures	1093.9	1094.64	1092.18	1093.17	24346.0
2010-08-04 05:00:00	ES	Futures	1093.41	1094.15	1091.69	1093.17	15931.0
2010-08-04 06:00:00	ES	Futures	1093.41	1094.88	1092.67	1094.15	12026.0
2010-08-04 07:00:00	ES	Futures	1094.39	1096.36	1094.15	1094.64	25274.0
2010-08-04 08:00:00	ES	Futures	1094.88	1100.77	1093.41	1099.3	96994.0
2010-08-04 09:00:00	ES	Futures	1099.55	1101.51	1097.58	1100.77	185232.0
2010-08-04 10:00:00	ES	Futures	1100.77	1104.45	1095.62	1098.07	403449.0
2010-08-04 11:00:00	ES	Futures	1098.32	1102.0	1097.34	1100.04	134377.0
2010-08-04 12:00:00	ES	Futures	1100.28	1103.23	1099.55	1101.51	96656.0
2010-08-04 13:00:00	ES	Futures	1101.75	1102.0	1098.56	1100.04	114246.0
2010-08-04 14:00:00	ES	Futures	1100.04	1103.23	1099.55	1102.49	110275.0
2010-08-04 15:00:00	ES	Futures	1102.49	1105.19	1101.51	1103.72	226751.0
2010-08-04 16:00:00	ES	Futures	1103.96	1104.7	1103.23	1104.21	76641.0
2010-08-04 17:00:00	ES	Futures	1104.45	1104.45	1102.74	1103.23	2839.0
2010-08-04 18:00:00	ES	Futures	1103.23	1103.72	1102.24	1102.74	2515.0
2010-08-04 19:00:00	ES	Futures	1102.49	1103.96	1102.24	1103.72	2389.0
2010-08-04 20:00:00	ES	Futures	1103.96	1104.94	1103.72	1103.96	3661.0
2010-08-04 21:00:00	ES	Futures	1103.96	1104.45	1102.49	1102.98	4469.0
2010-08-04 22:00:00	ES	Futures	1102.74	1103.47	1102.0	1102.98	3802.0
2010-08-04 23:00:00	ES	Futures	1102.98	1102.98	1101.75	1102.0	3136.0
2010-08-04 00:00:00	NQ	Futures	2168.45	2168.73	2165.58	2166.44	241.0
2010-08-04 01:00:00	NQ	Futures	2166.44	2166.44	2163.86	2164.72	172.0
2010-08-04 02:00:00	NQ	Futures	2164.43	2168.45	2162.71	2167.59	517.0
2010-08-04 03:00:00	NQ	Futures	2167.59	2167.59	2161.57	2163.0	2085.0
2010-08-04 04:00:00	NQ	Futures	2163.0	2163.86	2159.56	2161.85	842.0
2010-08-04 05:00:00	NQ	Futures	2162.14	2163.0	2158.7	2161.85	809.0
2010-08-04 06:00:00	NQ	Futures	2162.43	2164.43	2161.57	2163.57	664.0
2010-08-04 07:00:00	NQ	Futures	2163.29	2169.02	2163.29	2165.29	1393.0
2010-08-04 08:00:00	NQ	Futures	2165.01	2178.47	2163.57	2175.32	8834.0
2010-08-04 09:00:00	NQ	Futures	2175.32	2184.49	2173.03	2179.33	39840.0
2010-08-04 10:00:00	NQ	Futures	2179.91	2186.5	2165.87	2172.46	72916.0
2010-08-04 11:00:00	NQ	Futures	2172.46	2182.2	2171.31	2177.9	30589.0
2010-08-04 12:00:00	NQ	Futures	2177.9	2188.22	2177.04	2183.63	25542.0
2010-08-04 13:00:00	NQ	Futures	2183.92	2185.07	2176.18	2179.62	22354.0
2010-08-04 14:00:00	NQ	Futures	2179.62	2185.93	2179.05	2183.92	22634.0
2010-08-04 15:00:00	NQ	Futures	2183.92	2189.36	2180.77	2186.79	36496.0
2010-08-04 16:00:00	NQ	Futures	2186.79	2187.36	2184.78	2185.35	8901.0
2010-08-04 17:00:00	NQ	Futures	2185.35	2185.35	2183.06	2184.21	199.0
2010-08-04 18:00:00	NQ	Futures	2185.07	2185.35	2181.91	2183.06	200.0
2010-08-04 19:00:00	NQ	Futures	2183.06	2185.93	2182.49	2185.35	174.0
2010-08-04 20:00:00	NQ	Futures	2185.64	2186.79	2185.35	2185.64	209.0
2010-08-04 21:00:00	NQ	Futures	2185.35	2185.64	2182.49	2183.63	226.0
2010-08-04 22:00:00	NQ	Futures	2183.35	2184.78	2182.2	2182.77	236.0
2010-08-04 23:00:00	NQ	Futures	2183.35	2183.92	2181.91	2182.2	115.0
2010-08-04 00:00:00	YM	Futures	10014.2	10017.9	10003.7	10009.4	291.0
2010-08-04 01:00:00	YM	Futures	10011.3	10013.2	10002.8	10003.7	127.0

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

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