PREVIEW / etf_1hour / 2006-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-03.parquet
  size:    41 KB
  rows:    1,282

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-05-03 05:00:00	SPY	ETF	131.18	131.18	131.18	131.18	100.0
2006-05-03 06:00:00	SPY	ETF	131.16	131.19	131.16	131.18	6000.0
2006-05-03 07:00:00	SPY	ETF	131.1	131.33	131.1	131.28	72300.0
2006-05-03 08:00:00	SPY	ETF	131.3	131.33	131.08	131.24	271800.0
2006-05-03 09:00:00	SPY	ETF	131.24	131.32	131.02	131.11	5713400.0
2006-05-03 10:00:00	SPY	ETF	131.11	131.12	130.65	130.75	15607100.0
2006-05-03 11:00:00	SPY	ETF	130.75	130.99	130.63	130.83	9905400.0
2006-05-03 12:00:00	SPY	ETF	130.85	130.99	130.72	130.81	2652300.0
2006-05-03 13:00:00	SPY	ETF	130.79	130.95	130.57	130.6999	5805000.0
2006-05-03 14:00:00	SPY	ETF	130.68	130.75	130.45	130.5625	8172300.0
2006-05-03 15:00:00	SPY	ETF	130.56	131.0	130.51	130.91	7830200.0
2006-05-03 16:00:00	SPY	ETF	130.9	130.95	130.62	130.85	1238900.0
2006-05-03 17:00:00	SPY	ETF	130.85	130.9	130.83	130.9	39100.0
2006-05-03 18:00:00	SPY	ETF	130.91	130.92	130.89	130.89	2300.0
2006-05-03 19:00:00	SPY	ETF	130.9	130.9	130.9	130.9	400.0
2006-05-03 09:00:00	QQQ	ETF	41.58	41.64	41.51	41.53	9146000.0
2006-05-03 10:00:00	QQQ	ETF	41.53	41.55	41.37	41.42	14779700.0
2006-05-03 11:00:00	QQQ	ETF	41.42	41.55	41.41	41.47	11438400.0
2006-05-03 12:00:00	QQQ	ETF	41.48	41.5	41.41	41.46	5746800.0
2006-05-03 13:00:00	QQQ	ETF	41.46	41.52	41.34	41.4	5149200.0
2006-05-03 14:00:00	QQQ	ETF	41.4	41.42	41.28	41.34	11567100.0
2006-05-03 15:00:00	QQQ	ETF	41.34	41.54	41.33	41.49	10479100.0
2006-05-03 08:00:00	IWM	ETF	76.14	76.3	76.14	76.22	1006100.0
2006-05-03 09:00:00	IWM	ETF	76.23	76.37	75.98	76.01	5244700.0
2006-05-03 10:00:00	IWM	ETF	76.0	76.15	75.75	76.15	4615100.0
2006-05-03 11:00:00	IWM	ETF	76.16	76.34	76.0	76.12	4485600.0
2006-05-03 12:00:00	IWM	ETF	76.11	76.17	76.0	76.11	1761500.0
2006-05-03 13:00:00	IWM	ETF	76.11	76.2681	75.87	75.94	3098000.0
2006-05-03 14:00:00	IWM	ETF	75.94	76.07	75.69	75.96	6809600.0
2006-05-03 15:00:00	IWM	ETF	75.95	76.51	75.93	76.27	5779900.0
2006-05-03 16:00:00	IWM	ETF	76.28	76.54	76.14	76.14	2086200.0
2006-05-03 06:00:00	DIA	ETF	113.95	113.95	113.95	113.95	100.0
2006-05-03 07:00:00	DIA	ETF	113.94	113.99	113.93	113.99	700.0
2006-05-03 08:00:00	DIA	ETF	114.01	114.01	113.91	113.92	66800.0
2006-05-03 09:00:00	DIA	ETF	113.94	114.06	113.81	113.896	406100.0
2006-05-03 10:00:00	DIA	ETF	113.92	113.98	113.61	113.68	1261700.0
2006-05-03 11:00:00	DIA	ETF	113.7	113.85	113.56	113.7	1044300.0
2006-05-03 12:00:00	DIA	ETF	113.74	113.82	113.67	113.74	261100.0
2006-05-03 13:00:00	DIA	ETF	113.74	113.86	113.64	113.75	255900.0
2006-05-03 14:00:00	DIA	ETF	113.74	113.84	113.6	113.72	465100.0
2006-05-03 15:00:00	DIA	ETF	113.7	114.05	113.68	113.98	904600.0
2006-05-03 16:00:00	DIA	ETF	114.0	114.05	113.97	114.01	49700.0
2006-05-03 17:00:00	DIA	ETF	113.96	113.96	113.96	113.96	100.0
2006-05-03 18:00:00	DIA	ETF	113.95	113.95	113.93	113.93	300.0
2006-05-03 19:00:00	DIA	ETF	113.92	113.92	113.89	113.89	700.0
2006-05-03 07:00:00	GLD	ETF	66.92	66.93	66.92	66.93	800.0
2006-05-03 08:00:00	GLD	ETF	66.91	67.34	66.78	67.19	265100.0
2006-05-03 09:00:00	GLD	ETF	67.2	67.36	66.83	67.0	1417200.0
2006-05-03 10:00:00	GLD	ETF	67.0	67.0	65.33	65.95	4450300.0
2006-05-03 11:00:00	GLD	ETF	65.95	66.6	65.7	66.42	1760300.0

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

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