PREVIEW / futures_1hour / 2010-07-27

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-27.parquet
  size:    45 KB
  rows:    1,370

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-07-27 00:00:00	ES	Futures	1087.28	1087.77	1086.54	1087.28	3597.0
2010-07-27 01:00:00	ES	Futures	1087.28	1087.52	1086.54	1087.03	2847.0
2010-07-27 02:00:00	ES	Futures	1087.03	1091.94	1086.3	1090.71	14818.0
2010-07-27 03:00:00	ES	Futures	1090.71	1093.41	1090.22	1092.43	30947.0
2010-07-27 04:00:00	ES	Futures	1092.43	1094.15	1091.69	1092.67	20244.0
2010-07-27 05:00:00	ES	Futures	1092.43	1093.9	1091.94	1093.66	15801.0
2010-07-27 06:00:00	ES	Futures	1093.66	1095.13	1093.41	1094.88	20157.0
2010-07-27 07:00:00	ES	Futures	1094.88	1096.11	1093.66	1095.86	30970.0
2010-07-27 08:00:00	ES	Futures	1095.62	1096.36	1094.39	1095.62	45482.0
2010-07-27 09:00:00	ES	Futures	1095.62	1098.07	1091.94	1092.18	278233.0
2010-07-27 10:00:00	ES	Futures	1091.94	1097.09	1088.99	1090.22	376728.0
2010-07-27 11:00:00	ES	Futures	1090.22	1090.47	1085.56	1089.49	244633.0
2010-07-27 12:00:00	ES	Futures	1089.73	1092.18	1088.5	1088.99	133681.0
2010-07-27 13:00:00	ES	Futures	1089.24	1090.71	1086.54	1089.24	145081.0
2010-07-27 14:00:00	ES	Futures	1088.99	1092.18	1087.28	1088.75	128774.0
2010-07-27 15:00:00	ES	Futures	1088.75	1092.43	1088.5	1089.49	232215.0
2010-07-27 16:00:00	ES	Futures	1089.49	1091.2	1089.24	1089.98	79627.0
2010-07-27 17:00:00	ES	Futures	1089.98	1090.47	1089.73	1089.73	1818.0
2010-07-27 18:00:00	ES	Futures	1089.98	1090.22	1089.24	1089.73	2245.0
2010-07-27 19:00:00	ES	Futures	1089.98	1090.47	1089.73	1090.47	1498.0
2010-07-27 20:00:00	ES	Futures	1090.22	1091.2	1089.98	1090.47	3097.0
2010-07-27 21:00:00	ES	Futures	1090.47	1090.71	1088.5	1088.5	6622.0
2010-07-27 22:00:00	ES	Futures	1088.5	1091.2	1088.01	1091.2	5462.0
2010-07-27 23:00:00	ES	Futures	1091.2	1091.45	1090.22	1090.71	4138.0
2010-07-27 00:00:00	NQ	Futures	2161.28	2161.28	2159.85	2160.99	262.0
2010-07-27 01:00:00	NQ	Futures	2160.71	2160.71	2159.28	2159.85	224.0
2010-07-27 02:00:00	NQ	Futures	2160.13	2168.73	2158.7	2166.15	1220.0
2010-07-27 03:00:00	NQ	Futures	2166.15	2171.88	2166.15	2169.88	2111.0
2010-07-27 04:00:00	NQ	Futures	2169.88	2173.03	2169.02	2170.16	1022.0
2010-07-27 05:00:00	NQ	Futures	2170.16	2173.03	2169.02	2172.46	745.0
2010-07-27 06:00:00	NQ	Futures	2172.17	2175.32	2171.6	2174.46	1067.0
2010-07-27 07:00:00	NQ	Futures	2174.75	2175.32	2171.31	2175.32	1993.0
2010-07-27 08:00:00	NQ	Futures	2175.32	2176.76	2172.46	2175.61	5003.0
2010-07-27 09:00:00	NQ	Futures	2175.61	2178.76	2167.01	2167.01	41709.0
2010-07-27 10:00:00	NQ	Futures	2166.73	2175.9	2159.56	2160.99	64577.0
2010-07-27 11:00:00	NQ	Futures	2160.99	2161.85	2152.97	2160.71	36681.0
2010-07-27 12:00:00	NQ	Futures	2160.71	2165.58	2156.41	2158.99	20880.0
2010-07-27 13:00:00	NQ	Futures	2158.7	2161.85	2152.97	2158.99	23514.0
2010-07-27 14:00:00	NQ	Futures	2158.99	2167.3	2157.27	2160.99	21099.0
2010-07-27 15:00:00	NQ	Futures	2160.99	2167.87	2160.42	2161.85	38449.0
2010-07-27 16:00:00	NQ	Futures	2161.85	2164.15	2160.99	2162.71	7403.0
2010-07-27 17:00:00	NQ	Futures	2162.43	2162.71	2161.85	2162.14	103.0
2010-07-27 18:00:00	NQ	Futures	2162.14	2162.14	2160.71	2161.85	98.0
2010-07-27 19:00:00	NQ	Futures	2162.43	2162.71	2161.57	2162.71	43.0
2010-07-27 20:00:00	NQ	Futures	2162.71	2164.43	2162.14	2163.0	260.0
2010-07-27 21:00:00	NQ	Futures	2163.0	2164.72	2160.42	2160.42	629.0
2010-07-27 22:00:00	NQ	Futures	2160.13	2165.01	2159.28	2164.72	315.0
2010-07-27 23:00:00	NQ	Futures	2164.72	2165.01	2163.86	2164.15	122.0
2010-07-27 00:00:00	YM	Futures	9885.4	9887.3	9877.8	9880.7	183.0
2010-07-27 01:00:00	YM	Futures	9881.6	9885.4	9878.8	9884.5	111.0

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

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