PREVIEW / futures_1hour / 2009-12-16

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-16.parquet
  size:    46 KB
  rows:    1,364

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-16 00:00:00	ES	Futures	1073.74	1073.99	1073.26	1073.99	1170.0
2009-12-16 01:00:00	ES	Futures	1073.74	1074.96	1073.26	1073.99	2188.0
2009-12-16 02:00:00	ES	Futures	1073.99	1075.45	1073.5	1074.96	6580.0
2009-12-16 03:00:00	ES	Futures	1075.2	1078.85	1074.96	1078.85	23277.0
2009-12-16 04:00:00	ES	Futures	1078.61	1080.07	1078.37	1079.1	19587.0
2009-12-16 05:00:00	ES	Futures	1078.85	1082.02	1078.85	1080.56	21684.0
2009-12-16 06:00:00	ES	Futures	1080.56	1081.04	1078.85	1079.1	16388.0
2009-12-16 07:00:00	ES	Futures	1079.1	1079.83	1078.61	1079.1	15604.0
2009-12-16 08:00:00	ES	Futures	1079.1	1079.34	1077.64	1078.61	29538.0
2009-12-16 09:00:00	ES	Futures	1078.37	1081.04	1077.15	1079.83	167070.0
2009-12-16 10:00:00	ES	Futures	1079.83	1081.04	1078.12	1080.31	181946.0
2009-12-16 11:00:00	ES	Futures	1080.31	1081.77	1079.83	1080.07	121955.0
2009-12-16 12:00:00	ES	Futures	1080.07	1080.56	1079.1	1079.34	84157.0
2009-12-16 13:00:00	ES	Futures	1079.1	1080.07	1078.85	1079.1	48280.0
2009-12-16 14:00:00	ES	Futures	1078.85	1081.04	1075.69	1076.18	239337.0
2009-12-16 15:00:00	ES	Futures	1076.18	1077.39	1073.26	1075.45	321582.0
2009-12-16 16:00:00	ES	Futures	1075.45	1076.18	1074.23	1074.23	75512.0
2009-12-16 17:00:00	ES	Futures	1074.23	1074.47	1073.74	1073.99	2394.0
2009-12-16 18:00:00	ES	Futures	1073.99	1075.93	1073.74	1075.69	6141.0
2009-12-16 19:00:00	ES	Futures	1075.69	1076.42	1075.2	1076.18	5140.0
2009-12-16 20:00:00	ES	Futures	1076.18	1076.66	1074.72	1074.96	7245.0
2009-12-16 21:00:00	ES	Futures	1074.96	1075.69	1074.47	1074.47	4015.0
2009-12-16 22:00:00	ES	Futures	1074.72	1074.72	1072.53	1073.74	8370.0
2009-12-16 23:00:00	ES	Futures	1073.99	1073.99	1072.53	1073.01	2869.0
2009-12-16 00:00:00	NQ	Futures	2051.39	2051.96	2051.1	2051.96	87.0
2009-12-16 01:00:00	NQ	Futures	2051.67	2054.24	2050.82	2051.67	189.0
2009-12-16 02:00:00	NQ	Futures	2051.96	2055.1	2050.53	2053.96	1025.0
2009-12-16 03:00:00	NQ	Futures	2053.96	2061.1	2053.96	2060.81	1989.0
2009-12-16 04:00:00	NQ	Futures	2060.81	2063.96	2060.24	2061.96	1694.0
2009-12-16 05:00:00	NQ	Futures	2061.96	2068.53	2061.67	2066.81	2829.0
2009-12-16 06:00:00	NQ	Futures	2067.1	2067.95	2062.81	2063.38	906.0
2009-12-16 07:00:00	NQ	Futures	2063.1	2064.81	2061.67	2061.96	1248.0
2009-12-16 08:00:00	NQ	Futures	2061.96	2062.53	2058.81	2059.96	4261.0
2009-12-16 09:00:00	NQ	Futures	2059.96	2071.1	2057.96	2069.38	34110.0
2009-12-16 10:00:00	NQ	Futures	2069.38	2071.67	2063.1	2065.67	35927.0
2009-12-16 11:00:00	NQ	Futures	2065.96	2069.38	2065.1	2066.24	17221.0
2009-12-16 12:00:00	NQ	Futures	2066.53	2067.67	2064.53	2064.81	13012.0
2009-12-16 13:00:00	NQ	Futures	2064.81	2066.53	2059.96	2060.53	14219.0
2009-12-16 14:00:00	NQ	Futures	2060.24	2065.38	2054.24	2056.24	32015.0
2009-12-16 15:00:00	NQ	Futures	2056.24	2060.24	2052.82	2055.67	35930.0
2009-12-16 16:00:00	NQ	Futures	2055.67	2057.96	2054.82	2055.1	8082.0
2009-12-16 17:00:00	NQ	Futures	2054.82	2055.1	2053.67	2053.67	107.0
2009-12-16 18:00:00	NQ	Futures	2054.53	2057.39	2054.24	2057.1	138.0
2009-12-16 19:00:00	NQ	Futures	2057.39	2058.53	2056.53	2058.53	326.0
2009-12-16 20:00:00	NQ	Futures	2057.96	2059.67	2057.1	2057.1	773.0
2009-12-16 21:00:00	NQ	Futures	2057.1	2057.39	2055.96	2056.24	301.0
2009-12-16 22:00:00	NQ	Futures	2055.67	2055.96	2051.1	2053.1	701.0
2009-12-16 23:00:00	NQ	Futures	2052.82	2053.39	2050.82	2052.53	268.0
2009-12-16 00:00:00	YM	Futures	9727.8	9728.7	9725.0	9727.8	40.0
2009-12-16 01:00:00	YM	Futures	9728.7	9738.1	9725.9	9730.6	183.0

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

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