PREVIEW / etf_1hour / 2006-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-28.parquet
  size:    50 KB
  rows:    1,601

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-08-28 04:00:00	SPY	ETF	129.66	129.66	129.58	129.58	400.0
2006-08-28 05:00:00	SPY	ETF	129.54	129.54	129.54	129.54	100.0
2006-08-28 06:00:00	SPY	ETF	129.65	129.65	129.65	129.65	100.0
2006-08-28 07:00:00	SPY	ETF	129.62	129.7	129.62	129.64	9000.0
2006-08-28 08:00:00	SPY	ETF	129.72	129.81	129.65	129.78	508400.0
2006-08-28 09:00:00	SPY	ETF	129.78	130.06	129.64	129.96	6775900.0
2006-08-28 10:00:00	SPY	ETF	129.97	130.46	129.97	130.38	11191100.0
2006-08-28 11:00:00	SPY	ETF	130.38	130.64	130.27	130.54	7148100.0
2006-08-28 12:00:00	SPY	ETF	130.55	130.7	130.5	130.58	5302600.0
2006-08-28 13:00:00	SPY	ETF	130.58	130.74	130.49	130.72	5283500.0
2006-08-28 14:00:00	SPY	ETF	130.72	130.82	130.53	130.69	7833800.0
2006-08-28 15:00:00	SPY	ETF	130.68	130.72	130.4	130.48	7012600.0
2006-08-28 16:00:00	SPY	ETF	130.49	130.56	130.43	130.48	934500.0
2006-08-28 17:00:00	SPY	ETF	130.47	130.48	130.47	130.47	13000.0
2006-08-28 18:00:00	SPY	ETF	130.46	130.46	130.46	130.46	700.0
2006-08-28 19:00:00	SPY	ETF	130.48	130.49	130.47	130.49	2000.0
2006-08-28 09:00:00	QQQ	ETF	38.28	38.45	38.24	38.39	10958800.0
2006-08-28 10:00:00	QQQ	ETF	38.38	38.62	38.38	38.55	17815500.0
2006-08-28 11:00:00	QQQ	ETF	38.56	38.69	38.46	38.66	13102100.0
2006-08-28 12:00:00	QQQ	ETF	38.66	38.79	38.62	38.62	8162200.0
2006-08-28 13:00:00	QQQ	ETF	38.62	38.7	38.57	38.7	6642300.0
2006-08-28 14:00:00	QQQ	ETF	38.69	38.73	38.58	38.65	7494400.0
2006-08-28 15:00:00	QQQ	ETF	38.65	38.68	38.52	38.61	10910800.0
2006-08-28 07:00:00	IWM	ETF	69.5	69.5	69.5	69.5	100.0
2006-08-28 08:00:00	IWM	ETF	69.42	69.62	69.4	69.62	2300.0
2006-08-28 09:00:00	IWM	ETF	69.6	69.94	69.52	69.82	3942800.0
2006-08-28 10:00:00	IWM	ETF	69.84	70.28	69.84	70.22	5897900.0
2006-08-28 11:00:00	IWM	ETF	70.22	70.35	70.09	70.26	3689300.0
2006-08-28 12:00:00	IWM	ETF	70.26	70.37	70.21	70.25	2568700.0
2006-08-28 13:00:00	IWM	ETF	70.24	70.4	70.15	70.39	2033900.0
2006-08-28 14:00:00	IWM	ETF	70.4	70.47	70.27	70.38	2829000.0
2006-08-28 15:00:00	IWM	ETF	70.4	70.43	70.18	70.27	4387100.0
2006-08-28 16:00:00	IWM	ETF	70.29	70.47	70.29	70.34	471300.0
2006-08-28 17:00:00	IWM	ETF	70.37	70.43	70.37	70.43	5900.0
2006-08-28 18:00:00	IWM	ETF	70.42	70.42	70.42	70.42	100.0
2006-08-28 19:00:00	IWM	ETF	70.35	70.35	70.35	70.35	300.0
2006-08-28 08:00:00	DIA	ETF	112.8	112.82	112.8	112.82	4300.0
2006-08-28 09:00:00	DIA	ETF	112.82	113.08	112.68	112.98	590300.0
2006-08-28 10:00:00	DIA	ETF	112.99	113.45	112.99	113.36	934100.0
2006-08-28 11:00:00	DIA	ETF	113.38	113.59	113.3	113.54	418000.0
2006-08-28 12:00:00	DIA	ETF	113.54	113.68	113.51	113.53	342200.0
2006-08-28 13:00:00	DIA	ETF	113.53	113.8	113.48	113.8	433100.0
2006-08-28 14:00:00	DIA	ETF	113.8	113.87	113.56	113.67	538000.0
2006-08-28 15:00:00	DIA	ETF	113.67	113.7	113.42	113.47	366500.0
2006-08-28 16:00:00	DIA	ETF	113.46	113.53	113.41	113.45	22700.0
2006-08-28 17:00:00	DIA	ETF	113.48	113.48	113.48	113.48	200000.0
2006-08-28 18:00:00	DIA	ETF	113.55	113.6	113.55	113.6	600.0
2006-08-28 19:00:00	DIA	ETF	113.6	113.6	113.6	113.6	700.0
2006-08-28 08:00:00	GLD	ETF	61.83	61.88	61.72	61.72	8100.0
2006-08-28 09:00:00	GLD	ETF	61.72	61.82	61.57	61.6	326600.0

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

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