PREVIEW / etf_1hour / 2006-09-05

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-05.parquet
  size:    51 KB
  rows:    1,637

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
2006-09-05 06:00:00	SPY	ETF	131.36	131.38	131.36	131.37	300.0
2006-09-05 07:00:00	SPY	ETF	131.47	131.6	131.44	131.56	21600.0
2006-09-05 08:00:00	SPY	ETF	131.56	131.69	131.42	131.54	1146000.0
2006-09-05 09:00:00	SPY	ETF	131.52	131.63	131.2	131.34	7515200.0
2006-09-05 10:00:00	SPY	ETF	131.35	131.55	131.26	131.32	8786200.0
2006-09-05 11:00:00	SPY	ETF	131.33	131.82	131.3	131.78	9124000.0
2006-09-05 12:00:00	SPY	ETF	131.79	131.84	131.61	131.63	3152100.0
2006-09-05 13:00:00	SPY	ETF	131.64	131.69	131.42	131.54	4189500.0
2006-09-05 14:00:00	SPY	ETF	131.54	131.85	131.46	131.8	10040600.0
2006-09-05 15:00:00	SPY	ETF	131.81	131.82	131.63	131.7	5485900.0
2006-09-05 16:00:00	SPY	ETF	131.69	131.72	131.61	131.67	1339500.0
2006-09-05 17:00:00	SPY	ETF	131.65	131.65	131.59	131.64	13800.0
2006-09-05 19:00:00	SPY	ETF	131.6	131.6	131.58	131.58	1600.0
2006-09-05 09:00:00	QQQ	ETF	39.12	39.13	38.85	38.94	12205400.0
2006-09-05 10:00:00	QQQ	ETF	38.93	39.08	38.9	38.95	14719100.0
2006-09-05 11:00:00	QQQ	ETF	38.96	39.4	38.94	39.38	16039500.0
2006-09-05 12:00:00	QQQ	ETF	39.38	39.43	39.31	39.32	10108100.0
2006-09-05 13:00:00	QQQ	ETF	39.32	39.35	39.06	39.29	6497600.0
2006-09-05 14:00:00	QQQ	ETF	39.29	39.48	39.25	39.47	10069000.0
2006-09-05 15:00:00	QQQ	ETF	39.47	39.47	39.38	39.46	9619500.0
2006-09-05 07:00:00	IWM	ETF	71.8	71.8	71.8	71.8	1800.0
2006-09-05 08:00:00	IWM	ETF	71.9	72.01	71.72	71.97	548700.0
2006-09-05 09:00:00	IWM	ETF	71.97	72.06	71.7	71.91	6199900.0
2006-09-05 10:00:00	IWM	ETF	71.91	72.31	71.85	72.02	7338200.0
2006-09-05 11:00:00	IWM	ETF	72.02	72.52	72.01	72.45	5532800.0
2006-09-05 12:00:00	IWM	ETF	72.45	72.5	72.27	72.28	4483800.0
2006-09-05 13:00:00	IWM	ETF	72.28	72.32	72.07	72.13	3169200.0
2006-09-05 14:00:00	IWM	ETF	72.14	72.47	72.07	72.42	4521000.0
2006-09-05 15:00:00	IWM	ETF	72.43	72.47	72.21	72.41	4520600.0
2006-09-05 16:00:00	IWM	ETF	72.41	72.47	72.39	72.41	1426800.0
2006-09-05 17:00:00	IWM	ETF	72.42	72.43	72.41	72.43	2100.0
2006-09-05 18:00:00	IWM	ETF	72.4	72.4	72.4	72.4	700.0
2006-09-05 19:00:00	IWM	ETF	72.39	72.39	72.39	72.39	1000.0
2006-09-05 08:00:00	DIA	ETF	114.77	114.77	114.6	114.61	8600.0
2006-09-05 09:00:00	DIA	ETF	114.57	114.62	114.38	114.46	803000.0
2006-09-05 10:00:00	DIA	ETF	114.46	114.69	114.41	114.48	773900.0
2006-09-05 11:00:00	DIA	ETF	114.47	114.9	114.44	114.84	1149900.0
2006-09-05 12:00:00	DIA	ETF	114.84	114.88	114.59	114.6	1153200.0
2006-09-05 13:00:00	DIA	ETF	114.59	114.63	114.43	114.54	300200.0
2006-09-05 14:00:00	DIA	ETF	114.54	114.83	114.49	114.8	395100.0
2006-09-05 15:00:00	DIA	ETF	114.79	114.79	114.65	114.77	418100.0
2006-09-05 16:00:00	DIA	ETF	114.75	114.75	114.63	114.67	18200.0
2006-09-05 17:00:00	DIA	ETF	114.65	114.69	114.65	114.69	300.0
2006-09-05 19:00:00	DIA	ETF	114.69	114.69	114.69	114.69	300.0
2006-09-05 07:00:00	GLD	ETF	63.0	63.0	63.0	63.0	500.0
2006-09-05 08:00:00	GLD	ETF	62.65	63.32	62.62	63.23	164000.0
2006-09-05 09:00:00	GLD	ETF	63.25	63.35	63.15	63.26	918600.0
2006-09-05 10:00:00	GLD	ETF	63.29	63.37	63.06	63.12	702000.0
2006-09-05 11:00:00	GLD	ETF	63.12	63.58	63.11	63.56	878700.0
2006-09-05 12:00:00	GLD	ETF	63.5575	63.63	63.36	63.4	507200.0

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

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