PREVIEW / etf_1hour / 2004-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-23.parquet
  size:    25 KB
  rows:    698

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-06-23 08:00:00	SPY	ETF	113.68	113.73	113.63	113.67	21700.0
2004-06-23 09:00:00	SPY	ETF	113.64	113.8	113.58	113.65	3333300.0
2004-06-23 10:00:00	SPY	ETF	113.65	113.74	113.43	113.48	4275800.0
2004-06-23 11:00:00	SPY	ETF	113.47	113.84	113.42	113.77	2735300.0
2004-06-23 12:00:00	SPY	ETF	113.79	113.93	113.68	113.77	3062600.0
2004-06-23 13:00:00	SPY	ETF	113.77	113.93	113.67	113.76	2647800.0
2004-06-23 14:00:00	SPY	ETF	113.77	114.04	113.66	113.97	3093800.0
2004-06-23 15:00:00	SPY	ETF	113.99	114.84	113.97	114.69	11558500.0
2004-06-23 16:00:00	SPY	ETF	114.7	114.81	114.64	114.7	1357500.0
2004-06-23 17:00:00	SPY	ETF	114.7	114.7	114.64	114.65	134200.0
2004-06-23 18:00:00	SPY	ETF	114.63	114.71	114.6	114.66	183700.0
2004-06-23 19:00:00	SPY	ETF	114.64	114.64	114.64	114.64	100.0
2004-06-23 08:00:00	QQQ	ETF	36.6	36.65	36.6	36.6	75200.0
2004-06-23 09:00:00	QQQ	ETF	36.6	36.69	36.544	36.55	10231600.0
2004-06-23 10:00:00	QQQ	ETF	36.55	36.68	36.51	36.55	10738800.0
2004-06-23 11:00:00	QQQ	ETF	36.55	36.79	36.53	36.763	11542300.0
2004-06-23 12:00:00	QQQ	ETF	36.762	36.87	36.73	36.81	10906300.0
2004-06-23 13:00:00	QQQ	ETF	36.79	36.87	36.71	36.77	7632300.0
2004-06-23 14:00:00	QQQ	ETF	36.76	36.92	36.72	36.888	11732800.0
2004-06-23 15:00:00	QQQ	ETF	36.889	37.19	36.88	37.09	25657200.0
2004-06-23 16:00:00	QQQ	ETF	37.097	37.14	37.078	37.1	3380000.0
2004-06-23 17:00:00	QQQ	ETF	37.12	37.13	37.0	37.079	1488600.0
2004-06-23 18:00:00	QQQ	ETF	37.06	37.08	37.04	37.04	53700.0
2004-06-23 19:00:00	QQQ	ETF	37.04	37.07	37.04	37.06	8700.0
2004-06-23 09:00:00	IWM	ETF	57.015	57.25	56.985	57.13	846200.0
2004-06-23 10:00:00	IWM	ETF	57.105	57.27	56.975	57.05	1120600.0
2004-06-23 11:00:00	IWM	ETF	57.05	57.32	57.025	57.285	981800.0
2004-06-23 12:00:00	IWM	ETF	57.295	57.485	57.25	57.38	2935000.0
2004-06-23 13:00:00	IWM	ETF	57.405	57.515	57.38	57.49	712800.0
2004-06-23 14:00:00	IWM	ETF	57.475	57.655	57.4	57.595	1386000.0
2004-06-23 15:00:00	IWM	ETF	57.61	58.05	57.61	57.985	4650600.0
2004-06-23 16:00:00	IWM	ETF	57.985	58.025	57.905	57.905	513600.0
2004-06-23 17:00:00	IWM	ETF	57.99	57.99	57.99	57.99	9000.0
2004-06-23 08:00:00	DIA	ETF	104.07	104.07	104.04	104.04	1700.0
2004-06-23 09:00:00	DIA	ETF	104.01	104.15	103.9	104.03	515300.0
2004-06-23 10:00:00	DIA	ETF	104.01	104.11	103.77	103.81	392200.0
2004-06-23 11:00:00	DIA	ETF	103.82	104.08	103.73	104.08	579300.0
2004-06-23 12:00:00	DIA	ETF	104.03	104.19	103.99	104.09	547200.0
2004-06-23 13:00:00	DIA	ETF	104.05	104.17	103.96	104.01	153000.0
2004-06-23 14:00:00	DIA	ETF	104.01	104.23	103.94	104.15	692000.0
2004-06-23 15:00:00	DIA	ETF	104.15	105.0	104.15	104.9	1302400.0
2004-06-23 16:00:00	DIA	ETF	104.89	105.03	104.87	104.96	81200.0
2004-06-23 17:00:00	DIA	ETF	104.94	104.94	104.86	104.86	2100.0
2004-06-23 18:00:00	DIA	ETF	104.87	104.87	104.86	104.86	1200.0
2004-06-23 19:00:00	DIA	ETF	104.89	104.93	104.89	104.93	200.0
2004-06-23 09:00:00	TLT	ETF	82.35	82.35	82.2	82.24	38700.0
2004-06-23 10:00:00	TLT	ETF	82.25	82.26	82.18	82.26	47000.0
2004-06-23 11:00:00	TLT	ETF	82.26	82.36	82.26	82.34	31900.0
2004-06-23 12:00:00	TLT	ETF	82.34	82.63	82.34	82.62	32700.0
2004-06-23 13:00:00	TLT	ETF	82.61	82.68	82.55	82.59	46100.0

> showing 50 of 698 rows — these rows as CSV

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