PREVIEW / futures_1hour / 2009-12-24

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-24.parquet
  size:    27 KB
  rows:    735

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-24 00:00:00	ES	Futures	1086.15	1086.88	1086.15	1086.88	819.0
2009-12-24 01:00:00	ES	Futures	1086.64	1088.58	1086.64	1088.34	2433.0
2009-12-24 02:00:00	ES	Futures	1088.34	1088.58	1087.61	1087.85	1378.0
2009-12-24 03:00:00	ES	Futures	1088.1	1088.1	1087.12	1087.85	2258.0
2009-12-24 04:00:00	ES	Futures	1087.85	1089.07	1087.85	1088.83	1547.0
2009-12-24 05:00:00	ES	Futures	1089.07	1089.56	1088.34	1089.31	2894.0
2009-12-24 06:00:00	ES	Futures	1089.31	1089.56	1088.83	1089.31	1374.0
2009-12-24 07:00:00	ES	Futures	1089.31	1089.31	1087.37	1088.1	2883.0
2009-12-24 08:00:00	ES	Futures	1088.1	1089.31	1086.64	1088.34	12422.0
2009-12-24 09:00:00	ES	Futures	1088.34	1090.29	1087.85	1089.8	53968.0
2009-12-24 10:00:00	ES	Futures	1089.8	1092.23	1089.56	1090.53	70608.0
2009-12-24 11:00:00	ES	Futures	1090.53	1091.02	1089.8	1091.02	15495.0
2009-12-24 12:00:00	ES	Futures	1090.77	1091.99	1090.53	1091.75	42742.0
2009-12-24 13:00:00	ES	Futures	1091.99	1092.23	1091.02	1091.75	27666.0
2009-12-24 00:00:00	NQ	Futures	2117.94	2119.08	2117.65	2118.8	41.0
2009-12-24 01:00:00	NQ	Futures	2118.8	2121.65	2118.23	2120.51	147.0
2009-12-24 02:00:00	NQ	Futures	2120.51	2121.08	2118.8	2119.08	265.0
2009-12-24 03:00:00	NQ	Futures	2119.37	2121.08	2118.8	2120.8	288.0
2009-12-24 04:00:00	NQ	Futures	2120.8	2121.37	2119.94	2121.37	148.0
2009-12-24 05:00:00	NQ	Futures	2121.37	2122.22	2120.51	2121.65	264.0
2009-12-24 06:00:00	NQ	Futures	2121.94	2122.22	2121.37	2121.65	124.0
2009-12-24 07:00:00	NQ	Futures	2121.65	2121.65	2118.51	2120.51	756.0
2009-12-24 08:00:00	NQ	Futures	2119.94	2122.22	2117.37	2119.94	1736.0
2009-12-24 09:00:00	NQ	Futures	2119.94	2126.51	2117.08	2125.65	17043.0
2009-12-24 10:00:00	NQ	Futures	2125.94	2130.51	2125.65	2128.79	15647.0
2009-12-24 11:00:00	NQ	Futures	2129.08	2133.08	2127.37	2132.51	9324.0
2009-12-24 12:00:00	NQ	Futures	2132.22	2135.08	2130.79	2134.79	12428.0
2009-12-24 13:00:00	NQ	Futures	2135.08	2135.93	2133.65	2134.79	6676.0
2009-12-24 00:00:00	YM	Futures	9744.6	9749.3	9743.7	9746.5	90.0
2009-12-24 01:00:00	YM	Futures	9749.3	9757.7	9748.4	9755.8	113.0
2009-12-24 02:00:00	YM	Futures	9754.9	9754.9	9746.5	9753.0	35.0
2009-12-24 03:00:00	YM	Futures	9750.2	9751.2	9744.6	9749.3	442.0
2009-12-24 04:00:00	YM	Futures	9750.2	9758.6	9750.2	9757.7	272.0
2009-12-24 05:00:00	YM	Futures	9758.6	9765.2	9756.8	9759.6	279.0
2009-12-24 06:00:00	YM	Futures	9756.8	9758.6	9755.8	9757.7	60.0
2009-12-24 07:00:00	YM	Futures	9756.8	9765.2	9753.0	9755.8	303.0
2009-12-24 08:00:00	YM	Futures	9753.0	9764.3	9746.5	9754.9	1055.0
2009-12-24 09:00:00	YM	Futures	9755.8	9768.9	9740.9	9765.2	3551.0
2009-12-24 10:00:00	YM	Futures	9766.1	9788.6	9766.1	9782.0	6429.0
2009-12-24 11:00:00	YM	Futures	9781.1	9783.9	9775.5	9783.9	1576.0
2009-12-24 12:00:00	YM	Futures	9783.9	9792.3	9778.3	9791.4	3536.0
2009-12-24 13:00:00	YM	Futures	9791.4	9799.8	9786.7	9795.1	2232.0
2009-12-24 00:00:00	CL	Futures	165.71	165.82	165.65	165.8	308.0
2009-12-24 01:00:00	CL	Futures	165.82	166.36	165.8	166.21	644.0
2009-12-24 02:00:00	CL	Futures	166.21	166.25	165.65	165.71	722.0
2009-12-24 03:00:00	CL	Futures	165.71	165.93	164.7	164.96	2096.0
2009-12-24 04:00:00	CL	Futures	164.96	165.63	164.94	165.48	1748.0
2009-12-24 05:00:00	CL	Futures	165.46	165.97	165.24	165.43	1550.0
2009-12-24 06:00:00	CL	Futures	165.46	165.65	164.64	164.98	1621.0
2009-12-24 07:00:00	CL	Futures	165.07	165.07	163.74	163.91	4029.0

> showing 50 of 735 rows — these rows as CSV

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