PREVIEW / futures_1hour / 2009-12-15

all futures 1-hour files

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

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-15 00:00:00	ES	Futures	1080.07	1080.31	1078.61	1079.34	2495.0
2009-12-15 01:00:00	ES	Futures	1079.34	1079.83	1078.85	1079.1	2346.0
2009-12-15 02:00:00	ES	Futures	1079.1	1080.07	1078.37	1078.85	3685.0
2009-12-15 03:00:00	ES	Futures	1079.1	1080.07	1075.69	1076.42	21799.0
2009-12-15 04:00:00	ES	Futures	1076.42	1077.15	1075.45	1075.69	11645.0
2009-12-15 05:00:00	ES	Futures	1075.45	1076.91	1074.96	1076.42	13514.0
2009-12-15 06:00:00	ES	Futures	1076.42	1076.91	1075.2	1076.18	6886.0
2009-12-15 07:00:00	ES	Futures	1076.18	1076.42	1074.47	1075.93	24731.0
2009-12-15 08:00:00	ES	Futures	1076.18	1076.66	1072.53	1074.23	60443.0
2009-12-15 09:00:00	ES	Futures	1074.23	1076.18	1073.5	1074.23	193602.0
2009-12-15 10:00:00	ES	Futures	1074.23	1079.58	1073.74	1078.61	228956.0
2009-12-15 11:00:00	ES	Futures	1078.61	1079.1	1076.91	1077.39	115679.0
2009-12-15 12:00:00	ES	Futures	1077.39	1078.12	1075.45	1075.93	79972.0
2009-12-15 13:00:00	ES	Futures	1075.93	1076.91	1074.23	1075.93	104612.0
2009-12-15 14:00:00	ES	Futures	1075.69	1076.42	1074.96	1074.96	76948.0
2009-12-15 15:00:00	ES	Futures	1074.96	1076.18	1070.58	1073.74	328050.0
2009-12-15 16:00:00	ES	Futures	1073.74	1075.2	1073.5	1074.72	85485.0
2009-12-15 17:00:00	ES	Futures	1074.72	1074.96	1074.23	1074.72	700.0
2009-12-15 18:00:00	ES	Futures	1074.72	1074.96	1073.99	1074.47	6489.0
2009-12-15 19:00:00	ES	Futures	1074.47	1074.72	1073.5	1073.5	5057.0
2009-12-15 20:00:00	ES	Futures	1073.5	1074.96	1073.26	1074.47	3128.0
2009-12-15 21:00:00	ES	Futures	1074.72	1074.96	1073.99	1074.72	2348.0
2009-12-15 22:00:00	ES	Futures	1074.72	1074.72	1073.26	1073.5	5684.0
2009-12-15 23:00:00	ES	Futures	1073.26	1074.23	1073.26	1073.74	1172.0
2009-12-15 00:00:00	NQ	Futures	2067.38	2067.67	2064.53	2065.67	213.0
2009-12-15 01:00:00	NQ	Futures	2065.96	2065.96	2064.53	2064.81	157.0
2009-12-15 02:00:00	NQ	Futures	2064.81	2066.81	2064.53	2065.38	456.0
2009-12-15 03:00:00	NQ	Futures	2065.67	2067.1	2058.24	2061.67	2593.0
2009-12-15 04:00:00	NQ	Futures	2061.67	2062.81	2059.39	2059.96	1013.0
2009-12-15 05:00:00	NQ	Futures	2059.67	2061.96	2058.81	2061.39	792.0
2009-12-15 06:00:00	NQ	Futures	2061.67	2062.24	2058.24	2060.81	1096.0
2009-12-15 07:00:00	NQ	Futures	2060.81	2061.1	2057.39	2059.67	1265.0
2009-12-15 08:00:00	NQ	Futures	2059.39	2060.81	2053.39	2056.82	6035.0
2009-12-15 09:00:00	NQ	Futures	2056.82	2059.67	2051.67	2052.25	31783.0
2009-12-15 10:00:00	NQ	Futures	2052.25	2070.24	2051.67	2068.81	44995.0
2009-12-15 11:00:00	NQ	Futures	2069.1	2069.95	2062.81	2063.96	25422.0
2009-12-15 12:00:00	NQ	Futures	2063.96	2065.96	2061.96	2063.96	13478.0
2009-12-15 13:00:00	NQ	Futures	2063.96	2065.38	2058.24	2061.1	20276.0
2009-12-15 14:00:00	NQ	Futures	2061.1	2061.96	2057.67	2058.53	13275.0
2009-12-15 15:00:00	NQ	Futures	2058.53	2059.39	2046.82	2052.82	53864.0
2009-12-15 16:00:00	NQ	Futures	2053.1	2053.67	2050.25	2052.82	11605.0
2009-12-15 17:00:00	NQ	Futures	2052.82	2053.1	2051.96	2052.82	249.0
2009-12-15 18:00:00	NQ	Futures	2052.53	2053.1	2051.67	2052.53	202.0
2009-12-15 19:00:00	NQ	Futures	2052.82	2053.1	2051.1	2051.39	331.0
2009-12-15 20:00:00	NQ	Futures	2051.1	2053.96	2050.82	2053.67	251.0
2009-12-15 21:00:00	NQ	Futures	2053.67	2054.53	2052.25	2053.39	336.0
2009-12-15 22:00:00	NQ	Futures	2053.1	2053.39	2050.82	2050.82	415.0
2009-12-15 23:00:00	NQ	Futures	2051.1	2053.1	2051.1	2051.39	150.0
2009-12-15 00:00:00	YM	Futures	9773.6	9775.5	9763.3	9770.8	219.0
2009-12-15 01:00:00	YM	Futures	9769.9	9773.6	9766.1	9768.9	121.0

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

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