PREVIEW / futures_1hour / 2009-12-22

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-22.parquet
  size:    44 KB
  rows:    1,325

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-22 00:00:00	ES	Futures	1080.8	1082.02	1080.07	1081.77	2524.0
2009-12-22 01:00:00	ES	Futures	1081.53	1082.02	1081.29	1081.77	2696.0
2009-12-22 02:00:00	ES	Futures	1081.77	1082.5	1080.8	1080.8	6840.0
2009-12-22 03:00:00	ES	Futures	1080.8	1082.5	1080.8	1081.29	16264.0
2009-12-22 04:00:00	ES	Futures	1081.53	1082.5	1080.56	1081.77	9269.0
2009-12-22 05:00:00	ES	Futures	1081.77	1083.23	1081.53	1082.5	17524.0
2009-12-22 06:00:00	ES	Futures	1082.5	1082.99	1081.53	1082.5	16465.0
2009-12-22 07:00:00	ES	Futures	1082.5	1084.69	1082.26	1082.74	21528.0
2009-12-22 08:00:00	ES	Futures	1082.74	1083.72	1080.07	1081.53	35696.0
2009-12-22 09:00:00	ES	Futures	1081.29	1084.69	1080.8	1082.26	126478.0
2009-12-22 10:00:00	ES	Futures	1082.5	1085.66	1081.77	1082.26	198302.0
2009-12-22 11:00:00	ES	Futures	1082.5	1082.99	1080.56	1082.02	99009.0
2009-12-22 12:00:00	ES	Futures	1082.26	1084.2	1081.77	1083.72	51882.0
2009-12-22 13:00:00	ES	Futures	1083.72	1085.18	1083.23	1084.2	63686.0
2009-12-22 14:00:00	ES	Futures	1084.45	1084.45	1082.99	1083.23	45610.0
2009-12-22 15:00:00	ES	Futures	1083.23	1083.96	1082.02	1083.47	133184.0
2009-12-22 16:00:00	ES	Futures	1083.47	1084.2	1083.23	1083.72	65017.0
2009-12-22 17:00:00	ES	Futures	1083.72	1083.72	1083.23	1083.47	970.0
2009-12-22 18:00:00	ES	Futures	1083.23	1083.47	1082.99	1083.47	1145.0
2009-12-22 19:00:00	ES	Futures	1083.47	1084.45	1082.99	1083.96	2267.0
2009-12-22 20:00:00	ES	Futures	1084.2	1084.45	1083.72	1084.2	1615.0
2009-12-22 21:00:00	ES	Futures	1084.2	1084.69	1083.72	1084.45	1907.0
2009-12-22 22:00:00	ES	Futures	1084.2	1084.69	1084.2	1084.45	466.0
2009-12-22 23:00:00	ES	Futures	1084.45	1085.18	1084.45	1084.69	1072.0
2009-12-22 00:00:00	NQ	Futures	2089.95	2092.8	2089.09	2092.52	89.0
2009-12-22 01:00:00	NQ	Futures	2092.8	2093.09	2091.95	2092.23	118.0
2009-12-22 02:00:00	NQ	Futures	2092.23	2096.23	2091.66	2092.8	1054.0
2009-12-22 03:00:00	NQ	Futures	2092.8	2095.66	2092.52	2093.09	1498.0
2009-12-22 04:00:00	NQ	Futures	2093.09	2096.23	2092.52	2095.66	1687.0
2009-12-22 05:00:00	NQ	Futures	2095.66	2099.37	2095.38	2097.09	2245.0
2009-12-22 06:00:00	NQ	Futures	2097.37	2097.95	2096.52	2097.37	1364.0
2009-12-22 07:00:00	NQ	Futures	2097.09	2099.66	2095.95	2096.52	2831.0
2009-12-22 08:00:00	NQ	Futures	2096.52	2097.95	2090.23	2093.95	4639.0
2009-12-22 09:00:00	NQ	Futures	2093.95	2100.8	2090.52	2096.8	33893.0
2009-12-22 10:00:00	NQ	Futures	2097.37	2102.52	2094.52	2095.95	33549.0
2009-12-22 11:00:00	NQ	Futures	2095.95	2097.09	2091.38	2095.38	17269.0
2009-12-22 12:00:00	NQ	Futures	2095.66	2099.66	2094.8	2098.8	9923.0
2009-12-22 13:00:00	NQ	Futures	2098.8	2102.8	2098.23	2100.23	13172.0
2009-12-22 14:00:00	NQ	Futures	2099.95	2100.52	2097.09	2098.8	10745.0
2009-12-22 15:00:00	NQ	Futures	2098.8	2101.37	2096.8	2099.66	20780.0
2009-12-22 16:00:00	NQ	Futures	2099.66	2103.37	2099.37	2102.8	9460.0
2009-12-22 17:00:00	NQ	Futures	2102.8	2102.8	2101.66	2102.8	50.0
2009-12-22 18:00:00	NQ	Futures	2102.52	2102.8	2101.66	2102.8	105.0
2009-12-22 19:00:00	NQ	Futures	2102.8	2104.52	2101.37	2103.09	249.0
2009-12-22 20:00:00	NQ	Futures	2103.37	2104.52	2103.09	2103.66	76.0
2009-12-22 21:00:00	NQ	Futures	2104.52	2104.52	2102.52	2104.23	224.0
2009-12-22 22:00:00	NQ	Futures	2104.23	2105.09	2103.66	2103.94	68.0
2009-12-22 23:00:00	NQ	Futures	2104.23	2106.23	2104.23	2105.09	117.0
2009-12-22 00:00:00	YM	Futures	9700.6	9716.5	9698.8	9710.9	108.0
2009-12-22 01:00:00	YM	Futures	9710.9	9712.8	9705.3	9709.0	136.0

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

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