PREVIEW / futures_1hour / 2010-08-03

all futures 1-hour files

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

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-03 00:00:00	ES	Futures	1098.81	1099.3	1098.07	1098.81	1687.0
2010-08-03 01:00:00	ES	Futures	1098.81	1100.04	1098.07	1098.32	5666.0
2010-08-03 02:00:00	ES	Futures	1098.32	1100.28	1098.07	1098.32	8509.0
2010-08-03 03:00:00	ES	Futures	1098.56	1098.81	1096.11	1097.83	28779.0
2010-08-03 04:00:00	ES	Futures	1098.07	1099.79	1097.58	1099.05	18236.0
2010-08-03 05:00:00	ES	Futures	1098.81	1100.77	1098.32	1099.55	12638.0
2010-08-03 06:00:00	ES	Futures	1099.79	1101.26	1099.3	1099.55	13455.0
2010-08-03 07:00:00	ES	Futures	1099.55	1100.04	1097.09	1099.3	29977.0
2010-08-03 08:00:00	ES	Futures	1099.3	1100.77	1097.58	1100.04	40921.0
2010-08-03 09:00:00	ES	Futures	1100.28	1100.28	1094.88	1095.62	193137.0
2010-08-03 10:00:00	ES	Futures	1095.86	1099.55	1092.67	1099.05	303100.0
2010-08-03 11:00:00	ES	Futures	1099.05	1102.0	1097.58	1099.79	174776.0
2010-08-03 12:00:00	ES	Futures	1100.04	1100.04	1095.62	1097.58	153946.0
2010-08-03 13:00:00	ES	Futures	1097.34	1098.56	1095.37	1097.58	100387.0
2010-08-03 14:00:00	ES	Futures	1097.58	1099.3	1096.85	1098.07	94556.0
2010-08-03 15:00:00	ES	Futures	1098.32	1098.56	1093.9	1096.11	206427.0
2010-08-03 16:00:00	ES	Futures	1096.36	1098.32	1095.86	1098.07	80725.0
2010-08-03 17:00:00	ES	Futures	1098.32	1098.32	1097.58	1098.07	1213.0
2010-08-03 18:00:00	ES	Futures	1098.07	1098.07	1097.09	1097.34	1219.0
2010-08-03 19:00:00	ES	Futures	1097.09	1097.83	1097.09	1097.58	1196.0
2010-08-03 20:00:00	ES	Futures	1097.58	1097.83	1095.86	1096.36	6274.0
2010-08-03 21:00:00	ES	Futures	1096.36	1098.32	1096.36	1098.07	4850.0
2010-08-03 22:00:00	ES	Futures	1098.07	1098.56	1096.85	1097.58	3230.0
2010-08-03 23:00:00	ES	Futures	1097.34	1097.58	1095.62	1095.86	4631.0
2010-08-03 00:00:00	NQ	Futures	2168.73	2169.02	2167.01	2167.87	133.0
2010-08-03 01:00:00	NQ	Futures	2167.87	2170.16	2167.3	2167.3	202.0
2010-08-03 02:00:00	NQ	Futures	2167.59	2171.6	2167.3	2167.87	674.0
2010-08-03 03:00:00	NQ	Futures	2167.87	2168.16	2164.43	2168.16	1842.0
2010-08-03 04:00:00	NQ	Futures	2167.87	2171.31	2167.01	2170.74	1271.0
2010-08-03 05:00:00	NQ	Futures	2170.16	2172.46	2169.3	2171.88	803.0
2010-08-03 06:00:00	NQ	Futures	2172.17	2173.89	2171.02	2171.02	1120.0
2010-08-03 07:00:00	NQ	Futures	2171.02	2172.17	2167.01	2170.74	1676.0
2010-08-03 08:00:00	NQ	Futures	2170.74	2174.18	2167.87	2173.03	3373.0
2010-08-03 09:00:00	NQ	Futures	2173.03	2175.9	2158.13	2160.13	35333.0
2010-08-03 10:00:00	NQ	Futures	2160.71	2169.88	2154.69	2169.3	41673.0
2010-08-03 11:00:00	NQ	Futures	2169.59	2175.04	2165.87	2172.46	28675.0
2010-08-03 12:00:00	NQ	Futures	2172.74	2172.74	2160.71	2164.72	22189.0
2010-08-03 13:00:00	NQ	Futures	2164.72	2168.73	2161.28	2165.58	17663.0
2010-08-03 14:00:00	NQ	Futures	2165.58	2169.59	2164.15	2167.87	16568.0
2010-08-03 15:00:00	NQ	Futures	2167.87	2169.02	2159.85	2165.58	33606.0
2010-08-03 16:00:00	NQ	Futures	2165.87	2172.17	2165.58	2171.88	7307.0
2010-08-03 17:00:00	NQ	Futures	2172.17	2172.17	2171.02	2171.88	20.0
2010-08-03 18:00:00	NQ	Futures	2171.88	2171.88	2170.16	2171.02	81.0
2010-08-03 19:00:00	NQ	Futures	2170.74	2171.31	2170.45	2171.31	57.0
2010-08-03 20:00:00	NQ	Futures	2171.02	2171.6	2167.59	2168.45	258.0
2010-08-03 21:00:00	NQ	Futures	2169.3	2172.74	2169.02	2172.46	521.0
2010-08-03 22:00:00	NQ	Futures	2172.17	2173.03	2169.88	2170.45	189.0
2010-08-03 23:00:00	NQ	Futures	2170.45	2171.02	2167.87	2168.16	299.0
2010-08-03 00:00:00	YM	Futures	10032.1	10034.0	10027.4	10028.3	145.0
2010-08-03 01:00:00	YM	Futures	10032.1	10039.7	10028.3	10029.3	271.0

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

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