PREVIEW / etf_1hour / 2005-07-05

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-05.parquet
  size:    31 KB
  rows:    925

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
2005-07-05 07:00:00	SPY	ETF	119.24	119.29	119.2	119.2	80200.0
2005-07-05 08:00:00	SPY	ETF	119.24	119.24	119.15	119.2	206300.0
2005-07-05 09:00:00	SPY	ETF	119.22	119.39	119.19	119.35	5076100.0
2005-07-05 10:00:00	SPY	ETF	119.36	120.22	119.29	120.18	13591500.0
2005-07-05 11:00:00	SPY	ETF	120.18	120.28	120.04	120.13	3987700.0
2005-07-05 12:00:00	SPY	ETF	120.13	120.6	120.12	120.47	5587700.0
2005-07-05 13:00:00	SPY	ETF	120.47	120.48	120.23	120.33	4405300.0
2005-07-05 14:00:00	SPY	ETF	120.33	120.53	120.13	120.41	6652700.0
2005-07-05 15:00:00	SPY	ETF	120.41	120.65	120.29	120.48	7937500.0
2005-07-05 16:00:00	SPY	ETF	120.47	120.52	119.998	120.47	2843100.0
2005-07-05 17:00:00	SPY	ETF	120.48	120.51	120.47	120.49	9800.0
2005-07-05 18:00:00	SPY	ETF	120.49	120.49	120.49	120.49	100.0
2005-07-05 19:00:00	SPY	ETF	120.46	120.5	120.46	120.5	1900.0
2005-07-05 09:00:00	QQQ	ETF	36.63	36.71	36.6	36.67	8345700.0
2005-07-05 10:00:00	QQQ	ETF	36.68	37.14	36.65	37.08	24089100.0
2005-07-05 11:00:00	QQQ	ETF	37.08	37.1	36.96	37.02	7107200.0
2005-07-05 12:00:00	QQQ	ETF	37.02	37.19	37.02	37.16	8309800.0
2005-07-05 13:00:00	QQQ	ETF	37.16	37.17	37.05	37.11	4572700.0
2005-07-05 14:00:00	QQQ	ETF	37.1	37.17	37.05	37.12	5835900.0
2005-07-05 15:00:00	QQQ	ETF	37.12	37.18	37.07	37.1	7961200.0
2005-07-05 07:00:00	IWM	ETF	63.77	63.77	63.77	63.77	100.0
2005-07-05 08:00:00	IWM	ETF	63.83	63.85	63.75	63.8	47800.0
2005-07-05 09:00:00	IWM	ETF	63.83	63.97	63.76	63.9	3236700.0
2005-07-05 10:00:00	IWM	ETF	63.9	64.51	63.83	64.45	5644100.0
2005-07-05 11:00:00	IWM	ETF	64.46	64.48	64.33	64.4	1602400.0
2005-07-05 12:00:00	IWM	ETF	64.4	64.8	64.4	64.75	4331400.0
2005-07-05 13:00:00	IWM	ETF	64.75	64.85	64.71	64.76	2870500.0
2005-07-05 14:00:00	IWM	ETF	64.76	64.85	64.61	64.78	2100300.0
2005-07-05 15:00:00	IWM	ETF	64.79	64.95	64.58	64.94	5479700.0
2005-07-05 16:00:00	IWM	ETF	64.94	65.15	64.93	64.94	430500.0
2005-07-05 08:00:00	DIA	ETF	102.82	102.86	102.82	102.86	1400.0
2005-07-05 09:00:00	DIA	ETF	102.83	102.97	102.8	102.96	520300.0
2005-07-05 10:00:00	DIA	ETF	102.97	103.57	102.87	103.57	1294800.0
2005-07-05 11:00:00	DIA	ETF	103.58	103.65	103.36	103.41	622600.0
2005-07-05 12:00:00	DIA	ETF	103.39	103.74	103.39	103.68	517200.0
2005-07-05 13:00:00	DIA	ETF	103.69	103.69	103.46	103.53	370300.0
2005-07-05 14:00:00	DIA	ETF	103.54	103.71	103.38	103.62	338600.0
2005-07-05 15:00:00	DIA	ETF	103.62	103.87	103.52	103.72	785200.0
2005-07-05 16:00:00	DIA	ETF	103.67	103.69	103.59	103.59	15700.0
2005-07-05 17:00:00	DIA	ETF	103.57	103.57	103.57	103.57	300.0
2005-07-05 08:00:00	GLD	ETF	42.54	42.54	42.3	42.4	16800.0
2005-07-05 09:00:00	GLD	ETF	42.38	42.38	42.2	42.2	319700.0
2005-07-05 10:00:00	GLD	ETF	42.2	42.31	42.19	42.24	541800.0
2005-07-05 11:00:00	GLD	ETF	42.21	42.25	42.06	42.2	914300.0
2005-07-05 12:00:00	GLD	ETF	42.19	42.26	42.13	42.14	222600.0
2005-07-05 13:00:00	GLD	ETF	42.15	42.23	42.12	42.22	165200.0
2005-07-05 14:00:00	GLD	ETF	42.23	42.28	42.22	42.28	116500.0
2005-07-05 15:00:00	GLD	ETF	42.28	42.32	42.23	42.29	273700.0
2005-07-05 16:00:00	GLD	ETF	42.27	42.27	42.26	42.26	800.0
2005-07-05 08:00:00	TLT	ETF	94.8	94.8	94.65	94.7	3700.0

> showing 50 of 925 rows — these rows as CSV

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