PREVIEW / futures_1hour / 2009-12-14

all futures 1-hour files

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

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-14 00:00:00	ES	Futures	1079.58	1081.29	1079.34	1080.8	5657.0
2009-12-14 01:00:00	ES	Futures	1080.8	1082.99	1080.56	1082.26	5858.0
2009-12-14 02:00:00	ES	Futures	1082.26	1082.99	1080.56	1080.56	8581.0
2009-12-14 03:00:00	ES	Futures	1080.8	1081.29	1078.37	1079.58	18729.0
2009-12-14 04:00:00	ES	Futures	1079.83	1080.07	1078.61	1078.61	9403.0
2009-12-14 05:00:00	ES	Futures	1078.61	1079.58	1077.64	1077.64	11610.0
2009-12-14 06:00:00	ES	Futures	1077.88	1078.61	1076.42	1078.12	13201.0
2009-12-14 07:00:00	ES	Futures	1078.12	1079.34	1077.88	1078.61	10987.0
2009-12-14 08:00:00	ES	Futures	1078.61	1080.07	1078.37	1078.61	18913.0
2009-12-14 09:00:00	ES	Futures	1078.61	1079.83	1075.69	1076.66	192118.0
2009-12-14 10:00:00	ES	Futures	1076.42	1078.12	1074.23	1076.91	228777.0
2009-12-14 11:00:00	ES	Futures	1076.91	1079.58	1075.93	1078.12	134103.0
2009-12-14 12:00:00	ES	Futures	1078.12	1080.31	1077.64	1079.34	94209.0
2009-12-14 13:00:00	ES	Futures	1079.34	1079.58	1076.66	1078.61	113461.0
2009-12-14 14:00:00	ES	Futures	1078.61	1079.58	1077.64	1078.37	85292.0
2009-12-14 15:00:00	ES	Futures	1078.61	1079.83	1077.88	1079.34	142969.0
2009-12-14 16:00:00	ES	Futures	1079.34	1079.34	1077.15	1077.64	66309.0
2009-12-14 17:00:00	ES	Futures	1077.39	1077.88	1077.15	1077.64	1355.0
2009-12-14 18:00:00	ES	Futures	1077.64	1077.88	1075.93	1077.64	7803.0
2009-12-14 19:00:00	ES	Futures	1077.39	1078.85	1076.91	1078.37	5525.0
2009-12-14 20:00:00	ES	Futures	1078.37	1078.61	1077.64	1078.12	1251.0
2009-12-14 21:00:00	ES	Futures	1077.88	1078.61	1077.39	1078.37	1778.0
2009-12-14 22:00:00	ES	Futures	1078.61	1080.07	1078.37	1080.07	5307.0
2009-12-14 23:00:00	ES	Futures	1079.83	1081.04	1079.58	1080.07	2853.0
2009-12-14 00:00:00	NQ	Futures	2059.96	2064.24	2059.96	2062.81	551.0
2009-12-14 01:00:00	NQ	Futures	2063.38	2066.24	2063.1	2064.81	359.0
2009-12-14 02:00:00	NQ	Futures	2065.38	2065.96	2060.24	2060.53	683.0
2009-12-14 03:00:00	NQ	Futures	2060.53	2062.53	2056.82	2061.1	1869.0
2009-12-14 04:00:00	NQ	Futures	2061.39	2061.67	2057.96	2058.81	599.0
2009-12-14 05:00:00	NQ	Futures	2058.24	2059.96	2056.53	2056.53	690.0
2009-12-14 06:00:00	NQ	Futures	2056.53	2058.53	2054.24	2057.1	720.0
2009-12-14 07:00:00	NQ	Futures	2057.39	2059.96	2056.82	2058.24	816.0
2009-12-14 08:00:00	NQ	Futures	2058.53	2061.39	2057.96	2059.67	1563.0
2009-12-14 09:00:00	NQ	Futures	2059.67	2060.24	2054.24	2055.67	30061.0
2009-12-14 10:00:00	NQ	Futures	2055.96	2057.67	2047.96	2055.67	35583.0
2009-12-14 11:00:00	NQ	Futures	2055.96	2062.24	2055.39	2058.81	22659.0
2009-12-14 12:00:00	NQ	Futures	2058.81	2066.53	2058.53	2064.24	18198.0
2009-12-14 13:00:00	NQ	Futures	2064.24	2064.81	2059.67	2063.38	15122.0
2009-12-14 14:00:00	NQ	Futures	2063.38	2065.67	2061.67	2063.96	14893.0
2009-12-14 15:00:00	NQ	Futures	2063.67	2066.81	2062.24	2064.53	26000.0
2009-12-14 16:00:00	NQ	Futures	2064.24	2065.67	2061.96	2063.1	8941.0
2009-12-14 17:00:00	NQ	Futures	2062.81	2063.96	2062.53	2063.38	82.0
2009-12-14 18:00:00	NQ	Futures	2063.38	2063.67	2060.24	2063.67	338.0
2009-12-14 19:00:00	NQ	Futures	2063.1	2065.67	2062.53	2065.1	141.0
2009-12-14 20:00:00	NQ	Futures	2065.1	2065.1	2063.67	2064.53	157.0
2009-12-14 21:00:00	NQ	Futures	2064.53	2064.81	2063.96	2064.81	386.0
2009-12-14 22:00:00	NQ	Futures	2064.81	2067.38	2064.53	2067.1	921.0
2009-12-14 23:00:00	NQ	Futures	2067.38	2068.81	2066.53	2067.38	150.0
2009-12-14 00:00:00	YM	Futures	9801.7	9816.7	9801.7	9811.0	435.0
2009-12-14 01:00:00	YM	Futures	9812.9	9825.1	9808.2	9821.3	408.0

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

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