PREVIEW / etf_1hour / 2004-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-07.parquet
  size:    25 KB
  rows:    697

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
2004-09-07 08:00:00	SPY	ETF	112.6	112.65	112.53	112.62	54800.0
2004-09-07 09:00:00	SPY	ETF	112.62	112.89	112.52	112.68	4758700.0
2004-09-07 10:00:00	SPY	ETF	112.7	112.82	112.45	112.52	6560300.0
2004-09-07 11:00:00	SPY	ETF	112.54	112.78	112.49	112.67	2538700.0
2004-09-07 12:00:00	SPY	ETF	112.69	113.03	112.67	113.0	3721000.0
2004-09-07 13:00:00	SPY	ETF	113.0	113.13	112.76	112.8	3812400.0
2004-09-07 14:00:00	SPY	ETF	112.8	112.85	112.32	112.51	6471800.0
2004-09-07 15:00:00	SPY	ETF	112.51	112.85	112.41	112.81	5369200.0
2004-09-07 16:00:00	SPY	ETF	112.82	112.99	112.8	112.83	2276900.0
2004-09-07 17:00:00	SPY	ETF	112.85	112.87	112.81	112.87	4500.0
2004-09-07 18:00:00	SPY	ETF	112.85	112.86	112.8	112.81	4100.0
2004-09-07 08:00:00	QQQ	ETF	34.35	34.41	34.34	34.39	252100.0
2004-09-07 09:00:00	QQQ	ETF	34.39	34.55	34.36	34.43	14365200.0
2004-09-07 10:00:00	QQQ	ETF	34.43	34.5	34.294	34.34	18126000.0
2004-09-07 11:00:00	QQQ	ETF	34.35	34.54	34.33	34.466	8514000.0
2004-09-07 12:00:00	QQQ	ETF	34.47	34.58	34.46	34.58	11656600.0
2004-09-07 13:00:00	QQQ	ETF	34.56	34.61	34.448	34.45	7723400.0
2004-09-07 14:00:00	QQQ	ETF	34.45	34.48	34.12	34.194	15838500.0
2004-09-07 15:00:00	QQQ	ETF	34.19	34.38	34.16	34.37	14123300.0
2004-09-07 16:00:00	QQQ	ETF	34.36	34.43	34.34	34.35	2143200.0
2004-09-07 17:00:00	QQQ	ETF	34.352	34.43	34.34	34.4	1098800.0
2004-09-07 18:00:00	QQQ	ETF	34.38	34.393	34.38	34.39	4700.0
2004-09-07 19:00:00	QQQ	ETF	34.36	34.36	34.36	34.36	1000.0
2004-09-07 08:00:00	IWM	ETF	55.94	55.94	55.905	55.905	8000.0
2004-09-07 09:00:00	IWM	ETF	55.89	56.155	55.86	56.035	3123400.0
2004-09-07 10:00:00	IWM	ETF	56.035	56.11	55.705	55.83	1815600.0
2004-09-07 11:00:00	IWM	ETF	55.83	56.19	55.82	56.13	1718600.0
2004-09-07 12:00:00	IWM	ETF	56.12	56.215	56.065	56.21	633800.0
2004-09-07 13:00:00	IWM	ETF	56.195	56.255	56.085	56.1	719000.0
2004-09-07 14:00:00	IWM	ETF	56.1	56.14	55.75	55.895	954400.0
2004-09-07 15:00:00	IWM	ETF	55.895	56.185	55.88	56.145	1570800.0
2004-09-07 16:00:00	IWM	ETF	56.1208	56.215	56.12	56.175	596400.0
2004-09-07 17:00:00	IWM	ETF	56.175	56.175	56.175	56.175	1000.0
2004-09-07 08:00:00	DIA	ETF	103.22	103.33	103.22	103.3	29100.0
2004-09-07 09:00:00	DIA	ETF	103.29	103.5	103.2	103.47	509600.0
2004-09-07 10:00:00	DIA	ETF	103.47	103.56	103.22	103.28	702000.0
2004-09-07 11:00:00	DIA	ETF	103.28	103.49	103.27	103.43	310200.0
2004-09-07 12:00:00	DIA	ETF	103.43	103.71	103.41	103.67	393100.0
2004-09-07 13:00:00	DIA	ETF	103.67	103.82	103.5	103.5	400000.0
2004-09-07 14:00:00	DIA	ETF	103.52	103.58	103.12	103.28	694600.0
2004-09-07 15:00:00	DIA	ETF	103.28	103.6	103.24	103.57	1219900.0
2004-09-07 16:00:00	DIA	ETF	103.59	103.66	103.55	103.6	101700.0
2004-09-07 17:00:00	DIA	ETF	103.59	103.65	103.59	103.65	600.0
2004-09-07 09:00:00	TLT	ETF	86.24	86.28	86.19	86.26	244100.0
2004-09-07 10:00:00	TLT	ETF	86.26	86.39	86.23	86.39	56500.0
2004-09-07 11:00:00	TLT	ETF	86.4	86.4	86.32	86.36	61200.0
2004-09-07 12:00:00	TLT	ETF	86.33	86.42	86.32	86.42	4800.0
2004-09-07 13:00:00	TLT	ETF	86.42	86.5	86.4	86.46	14300.0
2004-09-07 14:00:00	TLT	ETF	86.5	86.54	86.5	86.54	28100.0
2004-09-07 15:00:00	TLT	ETF	86.58	86.58	86.54	86.56	50700.0

> showing 50 of 697 rows — these rows as CSV

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