PREVIEW / futures_1hour / 2008-04-07

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-04-07.parquet
  size:    42 KB
  rows:    1,208

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
2008-04-07 00:00:00	ES	Futures	1284.83	1286.0	1283.43	1284.83	2572.0
2008-04-07 01:00:00	ES	Futures	1284.6	1285.53	1282.97	1283.2	1710.0
2008-04-07 02:00:00	ES	Futures	1283.2	1285.76	1282.97	1284.37	4914.0
2008-04-07 03:00:00	ES	Futures	1284.37	1288.09	1282.74	1288.09	11438.0
2008-04-07 04:00:00	ES	Futures	1288.09	1290.19	1287.63	1288.32	14141.0
2008-04-07 05:00:00	ES	Futures	1288.09	1289.49	1287.16	1289.26	6592.0
2008-04-07 06:00:00	ES	Futures	1289.26	1289.72	1287.16	1287.86	9515.0
2008-04-07 07:00:00	ES	Futures	1288.09	1288.56	1286.69	1288.32	14653.0
2008-04-07 08:00:00	ES	Futures	1288.09	1289.02	1286.69	1286.69	27022.0
2008-04-07 09:00:00	ES	Futures	1286.93	1288.56	1282.97	1287.16	177150.0
2008-04-07 10:00:00	ES	Futures	1287.16	1287.39	1281.57	1284.83	182919.0
2008-04-07 11:00:00	ES	Futures	1284.83	1290.42	1283.2	1289.02	187961.0
2008-04-07 12:00:00	ES	Futures	1289.02	1293.68	1288.09	1291.82	129339.0
2008-04-07 13:00:00	ES	Futures	1292.05	1292.52	1286.23	1287.63	130518.0
2008-04-07 14:00:00	ES	Futures	1287.86	1288.09	1280.17	1280.87	216931.0
2008-04-07 15:00:00	ES	Futures	1280.87	1281.8	1276.22	1279.24	274262.0
2008-04-07 16:00:00	ES	Futures	1279.24	1281.11	1273.19	1274.82	76734.0
2008-04-07 17:00:00	ES	Futures	1275.05	1276.68	1274.59	1275.75	4621.0
2008-04-07 18:00:00	ES	Futures	1275.98	1276.68	1275.52	1276.45	1506.0
2008-04-07 19:00:00	ES	Futures	1276.45	1276.68	1274.59	1275.05	1738.0
2008-04-07 20:00:00	ES	Futures	1274.82	1275.52	1274.35	1274.59	2388.0
2008-04-07 21:00:00	ES	Futures	1274.59	1274.82	1273.19	1273.42	2702.0
2008-04-07 22:00:00	ES	Futures	1273.42	1273.66	1272.72	1273.19	1062.0
2008-04-07 23:00:00	ES	Futures	1272.96	1274.35	1272.96	1273.89	840.0
2008-04-07 00:00:00	NQ	Futures	2126.31	2128.0	2124.61	2125.46	133.0
2008-04-07 01:00:00	NQ	Futures	2126.02	2126.87	2123.76	2124.89	106.0
2008-04-07 02:00:00	NQ	Futures	2124.33	2130.27	2124.33	2128.0	500.0
2008-04-07 03:00:00	NQ	Futures	2128.0	2132.24	2125.17	2132.24	913.0
2008-04-07 04:00:00	NQ	Futures	2132.24	2136.49	2132.24	2133.66	1048.0
2008-04-07 05:00:00	NQ	Futures	2133.38	2135.36	2130.83	2134.79	731.0
2008-04-07 06:00:00	NQ	Futures	2134.79	2135.36	2131.11	2132.81	523.0
2008-04-07 07:00:00	NQ	Futures	2132.53	2133.38	2129.7	2132.81	999.0
2008-04-07 08:00:00	NQ	Futures	2132.81	2134.22	2127.44	2128.0	4659.0
2008-04-07 09:00:00	NQ	Futures	2128.0	2135.07	2124.33	2135.07	42595.0
2008-04-07 10:00:00	NQ	Futures	2134.79	2136.49	2121.21	2129.7	48976.0
2008-04-07 11:00:00	NQ	Futures	2129.7	2140.16	2125.46	2137.05	34480.0
2008-04-07 12:00:00	NQ	Futures	2137.05	2142.43	2134.22	2135.64	24416.0
2008-04-07 13:00:00	NQ	Futures	2135.64	2137.05	2124.89	2126.87	23969.0
2008-04-07 14:00:00	NQ	Futures	2126.87	2128.29	2113.01	2114.99	43315.0
2008-04-07 15:00:00	NQ	Futures	2114.71	2116.97	2107.36	2113.01	50616.0
2008-04-07 16:00:00	NQ	Futures	2113.3	2116.41	2103.68	2107.64	13003.0
2008-04-07 17:00:00	NQ	Futures	2107.07	2109.62	2106.79	2108.49	182.0
2008-04-07 18:00:00	NQ	Futures	2108.49	2110.47	2107.36	2109.9	144.0
2008-04-07 19:00:00	NQ	Futures	2109.9	2109.9	2107.07	2107.07	128.0
2008-04-07 20:00:00	NQ	Futures	2107.64	2108.49	2104.81	2105.94	129.0
2008-04-07 21:00:00	NQ	Futures	2106.22	2106.22	2103.96	2104.24	69.0
2008-04-07 22:00:00	NQ	Futures	2104.53	2105.09	2103.11	2103.11	208.0
2008-04-07 23:00:00	NQ	Futures	2103.11	2105.09	2102.55	2104.24	74.0
2008-04-07 00:00:00	YM	Futures	11506.3	11514.4	11499.0	11505.3	109.0
2008-04-07 01:00:00	YM	Futures	11505.3	11510.8	11492.6	11497.2	92.0

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

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