PREVIEW / futures_1hour / 2009-12-23

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-23.parquet
  size:    42 KB
  rows:    1,293

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-23 00:00:00	ES	Futures	1084.69	1084.93	1084.2	1084.45	810.0
2009-12-23 01:00:00	ES	Futures	1084.69	1088.83	1084.69	1087.85	8126.0
2009-12-23 02:00:00	ES	Futures	1087.85	1088.83	1086.64	1087.12	6029.0
2009-12-23 03:00:00	ES	Futures	1087.12	1087.85	1085.18	1087.37	8950.0
2009-12-23 04:00:00	ES	Futures	1087.37	1088.58	1086.15	1088.34	7356.0
2009-12-23 05:00:00	ES	Futures	1088.34	1089.8	1087.61	1088.1	8910.0
2009-12-23 06:00:00	ES	Futures	1088.34	1088.58	1087.12	1088.1	6594.0
2009-12-23 07:00:00	ES	Futures	1088.1	1088.58	1086.88	1088.34	5925.0
2009-12-23 08:00:00	ES	Futures	1088.34	1088.83	1085.66	1086.64	20201.0
2009-12-23 09:00:00	ES	Futures	1086.39	1087.12	1084.93	1085.66	97623.0
2009-12-23 10:00:00	ES	Futures	1085.42	1085.42	1081.29	1083.47	170631.0
2009-12-23 11:00:00	ES	Futures	1083.72	1085.66	1083.23	1085.18	77583.0
2009-12-23 12:00:00	ES	Futures	1085.18	1086.39	1084.2	1085.91	39899.0
2009-12-23 13:00:00	ES	Futures	1085.91	1087.12	1085.18	1086.15	38938.0
2009-12-23 14:00:00	ES	Futures	1086.39	1087.12	1085.91	1086.15	53692.0
2009-12-23 15:00:00	ES	Futures	1086.15	1087.12	1084.69	1085.66	107129.0
2009-12-23 16:00:00	ES	Futures	1085.91	1086.39	1084.69	1086.15	59955.0
2009-12-23 17:00:00	ES	Futures	1086.15	1086.39	1085.91	1085.91	443.0
2009-12-23 18:00:00	ES	Futures	1086.39	1086.39	1085.66	1085.91	844.0
2009-12-23 19:00:00	ES	Futures	1085.91	1086.15	1085.18	1085.66	905.0
2009-12-23 20:00:00	ES	Futures	1085.42	1086.88	1085.18	1086.39	1289.0
2009-12-23 21:00:00	ES	Futures	1086.39	1087.12	1086.15	1086.15	1440.0
2009-12-23 22:00:00	ES	Futures	1086.15	1087.12	1085.91	1086.88	1645.0
2009-12-23 23:00:00	ES	Futures	1086.88	1087.12	1085.91	1086.15	982.0
2009-12-23 00:00:00	NQ	Futures	2104.8	2105.94	2104.8	2105.37	78.0
2009-12-23 01:00:00	NQ	Futures	2105.66	2111.08	2105.37	2111.08	671.0
2009-12-23 02:00:00	NQ	Futures	2111.08	2113.08	2108.51	2109.66	1204.0
2009-12-23 03:00:00	NQ	Futures	2109.37	2111.37	2105.94	2109.37	1155.0
2009-12-23 04:00:00	NQ	Futures	2109.66	2111.37	2107.37	2110.8	485.0
2009-12-23 05:00:00	NQ	Futures	2110.51	2113.37	2110.51	2111.94	1285.0
2009-12-23 06:00:00	NQ	Futures	2111.94	2112.23	2109.94	2111.08	345.0
2009-12-23 07:00:00	NQ	Futures	2111.08	2111.08	2107.94	2110.8	1046.0
2009-12-23 08:00:00	NQ	Futures	2111.08	2111.37	2105.09	2105.94	1994.0
2009-12-23 09:00:00	NQ	Futures	2105.94	2108.8	2101.66	2106.51	22052.0
2009-12-23 10:00:00	NQ	Futures	2106.23	2108.23	2098.8	2106.23	29836.0
2009-12-23 11:00:00	NQ	Futures	2106.51	2111.37	2104.52	2109.66	15608.0
2009-12-23 12:00:00	NQ	Futures	2109.66	2112.51	2108.51	2111.08	7436.0
2009-12-23 13:00:00	NQ	Futures	2110.8	2113.66	2109.94	2112.8	10130.0
2009-12-23 14:00:00	NQ	Futures	2112.8	2115.66	2112.51	2113.94	10938.0
2009-12-23 15:00:00	NQ	Futures	2113.94	2115.94	2110.51	2114.51	20997.0
2009-12-23 16:00:00	NQ	Futures	2114.51	2117.08	2113.94	2117.08	9268.0
2009-12-23 17:00:00	NQ	Futures	2117.08	2118.51	2116.8	2116.8	73.0
2009-12-23 18:00:00	NQ	Futures	2116.23	2118.51	2115.66	2117.65	116.0
2009-12-23 19:00:00	NQ	Futures	2117.37	2117.65	2116.23	2117.08	143.0
2009-12-23 20:00:00	NQ	Futures	2117.08	2119.08	2116.23	2118.8	231.0
2009-12-23 21:00:00	NQ	Futures	2118.51	2119.37	2118.23	2118.23	153.0
2009-12-23 22:00:00	NQ	Futures	2118.23	2119.37	2117.65	2119.08	121.0
2009-12-23 23:00:00	NQ	Futures	2118.8	2119.37	2116.8	2117.65	140.0
2009-12-23 00:00:00	YM	Futures	9744.6	9754.0	9741.8	9751.2	211.0
2009-12-23 01:00:00	YM	Futures	9751.2	9772.7	9750.2	9769.9	490.0

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

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