PREVIEW / futures_1hour / 2009-12-28

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-28.parquet
  size:    39 KB
  rows:    1,221

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
2009-12-28 00:00:00	ES	Futures	1092.23	1094.66	1092.23	1093.45	2658.0
2009-12-28 01:00:00	ES	Futures	1093.45	1094.18	1092.72	1092.96	1290.0
2009-12-28 02:00:00	ES	Futures	1093.2	1093.93	1092.23	1092.96	3327.0
2009-12-28 03:00:00	ES	Futures	1092.72	1093.69	1092.23	1092.96	5422.0
2009-12-28 04:00:00	ES	Futures	1092.96	1093.93	1092.23	1093.45	2864.0
2009-12-28 05:00:00	ES	Futures	1093.69	1093.93	1092.72	1093.45	2116.0
2009-12-28 06:00:00	ES	Futures	1093.45	1094.18	1092.72	1093.69	2309.0
2009-12-28 07:00:00	ES	Futures	1093.93	1093.93	1091.75	1093.45	4151.0
2009-12-28 08:00:00	ES	Futures	1093.45	1094.42	1092.72	1094.42	8697.0
2009-12-28 09:00:00	ES	Futures	1094.18	1095.88	1093.69	1094.18	70378.0
2009-12-28 10:00:00	ES	Futures	1094.18	1094.66	1091.75	1092.23	74491.0
2009-12-28 11:00:00	ES	Futures	1092.23	1093.45	1091.99	1092.96	43364.0
2009-12-28 12:00:00	ES	Futures	1092.72	1092.96	1091.99	1092.72	25458.0
2009-12-28 13:00:00	ES	Futures	1092.96	1093.2	1091.75	1092.23	30093.0
2009-12-28 14:00:00	ES	Futures	1092.23	1092.48	1089.31	1090.29	59546.0
2009-12-28 15:00:00	ES	Futures	1090.53	1093.69	1089.8	1093.2	84253.0
2009-12-28 16:00:00	ES	Futures	1093.2	1093.69	1092.23	1092.72	36801.0
2009-12-28 17:00:00	ES	Futures	1092.48	1092.72	1092.23	1092.48	532.0
2009-12-28 18:00:00	ES	Futures	1092.48	1093.2	1092.23	1093.2	2275.0
2009-12-28 19:00:00	ES	Futures	1093.2	1094.18	1092.72	1093.2	2123.0
2009-12-28 20:00:00	ES	Futures	1092.96	1093.69	1092.72	1093.69	903.0
2009-12-28 21:00:00	ES	Futures	1093.69	1093.69	1092.96	1093.2	370.0
2009-12-28 22:00:00	ES	Futures	1093.2	1093.2	1092.23	1092.48	727.0
2009-12-28 23:00:00	ES	Futures	1092.72	1093.2	1092.23	1093.2	583.0
2009-12-28 00:00:00	NQ	Futures	2137.36	2140.79	2137.08	2139.65	322.0
2009-12-28 01:00:00	NQ	Futures	2139.93	2140.79	2138.79	2138.79	92.0
2009-12-28 02:00:00	NQ	Futures	2139.08	2141.93	2135.93	2139.93	719.0
2009-12-28 03:00:00	NQ	Futures	2139.93	2143.36	2138.22	2140.79	1471.0
2009-12-28 04:00:00	NQ	Futures	2140.5	2143.65	2138.79	2143.08	706.0
2009-12-28 05:00:00	NQ	Futures	2143.08	2143.36	2140.79	2141.65	480.0
2009-12-28 06:00:00	NQ	Futures	2141.93	2142.79	2141.08	2142.22	261.0
2009-12-28 07:00:00	NQ	Futures	2142.22	2142.22	2137.93	2139.36	1051.0
2009-12-28 08:00:00	NQ	Futures	2139.36	2140.79	2134.79	2139.65	1979.0
2009-12-28 09:00:00	NQ	Futures	2139.36	2149.64	2137.65	2145.36	20636.0
2009-12-28 10:00:00	NQ	Futures	2145.65	2147.65	2142.5	2145.36	16487.0
2009-12-28 11:00:00	NQ	Futures	2145.36	2146.5	2143.93	2144.5	8622.0
2009-12-28 12:00:00	NQ	Futures	2144.5	2145.93	2143.36	2144.79	7934.0
2009-12-28 13:00:00	NQ	Futures	2144.5	2146.22	2142.5	2143.93	7630.0
2009-12-28 14:00:00	NQ	Futures	2143.65	2144.5	2133.36	2138.51	19404.0
2009-12-28 15:00:00	NQ	Futures	2138.79	2145.93	2136.51	2145.65	22121.0
2009-12-28 16:00:00	NQ	Futures	2145.65	2146.22	2139.65	2141.65	9894.0
2009-12-28 17:00:00	NQ	Futures	2141.65	2141.65	2140.22	2140.22	70.0
2009-12-28 18:00:00	NQ	Futures	2139.93	2141.93	2139.93	2141.93	148.0
2009-12-28 19:00:00	NQ	Futures	2142.22	2143.36	2141.36	2142.5	161.0
2009-12-28 20:00:00	NQ	Futures	2142.22	2143.65	2141.65	2142.79	217.0
2009-12-28 21:00:00	NQ	Futures	2142.5	2143.93	2141.93	2143.08	252.0
2009-12-28 22:00:00	NQ	Futures	2143.08	2143.08	2140.5	2140.79	147.0
2009-12-28 23:00:00	NQ	Futures	2140.5	2142.5	2140.5	2142.5	74.0
2009-12-28 00:00:00	YM	Futures	9797.0	9812.0	9797.0	9807.3	158.0
2009-12-28 01:00:00	YM	Futures	9807.3	9812.0	9799.8	9803.6	84.0

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

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