PREVIEW / futures_1hour / 2010-08-10

all futures 1-hour files

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

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-10 00:00:00	ES	Futures	1100.04	1100.28	1099.3	1099.79	3863.0
2010-08-10 01:00:00	ES	Futures	1100.04	1101.02	1099.55	1100.53	3123.0
2010-08-10 02:00:00	ES	Futures	1100.77	1100.77	1099.3	1099.55	8071.0
2010-08-10 03:00:00	ES	Futures	1099.55	1100.53	1095.86	1096.36	36192.0
2010-08-10 04:00:00	ES	Futures	1096.36	1099.05	1095.86	1097.58	26691.0
2010-08-10 05:00:00	ES	Futures	1097.58	1098.07	1096.11	1097.83	15212.0
2010-08-10 06:00:00	ES	Futures	1097.83	1099.05	1097.09	1098.32	16514.0
2010-08-10 07:00:00	ES	Futures	1098.56	1099.3	1096.6	1096.85	30582.0
2010-08-10 08:00:00	ES	Futures	1096.85	1097.09	1092.18	1094.39	91566.0
2010-08-10 09:00:00	ES	Futures	1094.15	1096.36	1087.77	1090.71	282716.0
2010-08-10 10:00:00	ES	Futures	1090.96	1093.41	1089.49	1090.96	200953.0
2010-08-10 11:00:00	ES	Futures	1090.96	1094.39	1090.71	1093.9	107771.0
2010-08-10 12:00:00	ES	Futures	1093.66	1094.15	1092.43	1092.92	58891.0
2010-08-10 13:00:00	ES	Futures	1092.67	1093.17	1089.73	1091.45	89328.0
2010-08-10 14:00:00	ES	Futures	1091.45	1103.72	1091.45	1099.79	552400.0
2010-08-10 15:00:00	ES	Futures	1100.04	1102.49	1095.62	1098.32	377186.0
2010-08-10 16:00:00	ES	Futures	1098.32	1100.28	1098.07	1098.81	103623.0
2010-08-10 17:00:00	ES	Futures	1098.56	1098.81	1098.32	1098.56	973.0
2010-08-10 18:00:00	ES	Futures	1098.56	1098.81	1097.83	1098.32	2065.0
2010-08-10 19:00:00	ES	Futures	1098.07	1098.32	1096.11	1096.6	5244.0
2010-08-10 20:00:00	ES	Futures	1096.6	1096.85	1089.73	1091.94	21949.0
2010-08-10 21:00:00	ES	Futures	1091.94	1092.92	1090.71	1092.67	9039.0
2010-08-10 22:00:00	ES	Futures	1092.43	1094.64	1092.18	1093.17	6996.0
2010-08-10 23:00:00	ES	Futures	1093.17	1093.9	1091.69	1092.43	4080.0
2010-08-10 00:00:00	NQ	Futures	2187.93	2188.22	2185.64	2186.21	238.0
2010-08-10 01:00:00	NQ	Futures	2186.21	2188.5	2186.21	2187.65	253.0
2010-08-10 02:00:00	NQ	Futures	2187.65	2187.65	2184.78	2185.64	503.0
2010-08-10 03:00:00	NQ	Futures	2185.64	2187.65	2178.76	2179.62	2739.0
2010-08-10 04:00:00	NQ	Futures	2179.62	2184.49	2178.19	2181.91	1322.0
2010-08-10 05:00:00	NQ	Futures	2182.2	2182.49	2178.76	2182.49	985.0
2010-08-10 06:00:00	NQ	Futures	2182.77	2184.78	2182.2	2183.92	1571.0
2010-08-10 07:00:00	NQ	Futures	2183.92	2185.64	2179.62	2180.77	2510.0
2010-08-10 08:00:00	NQ	Futures	2180.77	2181.34	2170.74	2175.32	8448.0
2010-08-10 09:00:00	NQ	Futures	2175.32	2179.05	2155.84	2160.42	57168.0
2010-08-10 10:00:00	NQ	Futures	2160.71	2167.87	2158.42	2162.71	40967.0
2010-08-10 11:00:00	NQ	Futures	2162.71	2171.6	2162.43	2170.16	25510.0
2010-08-10 12:00:00	NQ	Futures	2170.16	2170.74	2165.29	2166.44	17183.0
2010-08-10 13:00:00	NQ	Futures	2166.44	2166.73	2157.27	2161.28	22864.0
2010-08-10 14:00:00	NQ	Futures	2161.57	2187.36	2158.13	2181.63	90143.0
2010-08-10 15:00:00	NQ	Futures	2181.34	2185.64	2173.89	2175.9	58932.0
2010-08-10 16:00:00	NQ	Futures	2175.9	2177.9	2173.6	2174.18	11074.0
2010-08-10 17:00:00	NQ	Futures	2174.46	2174.75	2173.32	2174.46	85.0
2010-08-10 18:00:00	NQ	Futures	2175.32	2175.32	2173.03	2174.18	150.0
2010-08-10 19:00:00	NQ	Futures	2173.89	2173.89	2168.45	2169.3	433.0
2010-08-10 20:00:00	NQ	Futures	2169.88	2171.31	2156.7	2159.56	2014.0
2010-08-10 21:00:00	NQ	Futures	2159.85	2162.14	2158.42	2161.57	620.0
2010-08-10 22:00:00	NQ	Futures	2161.57	2166.15	2160.99	2163.0	451.0
2010-08-10 23:00:00	NQ	Futures	2162.71	2163.57	2160.99	2162.43	183.0
2010-08-10 00:00:00	YM	Futures	10061.5	10062.4	10053.0	10057.7	155.0
2010-08-10 01:00:00	YM	Futures	10056.7	10068.1	10056.7	10065.3	219.0

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

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