PREVIEW / etf_1hour / 2004-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-07.parquet
  size:    25 KB
  rows:    703

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-07 08:00:00	SPY	ETF	113.58	113.6	113.47	113.55	83500.0
2004-06-07 09:00:00	SPY	ETF	113.55	113.76	113.42	113.72	4212600.0
2004-06-07 10:00:00	SPY	ETF	113.71	113.82	113.57	113.73	5518800.0
2004-06-07 11:00:00	SPY	ETF	113.74	114.09	113.67	113.97	6255800.0
2004-06-07 12:00:00	SPY	ETF	113.97	114.07	113.86	113.98	1317600.0
2004-06-07 13:00:00	SPY	ETF	113.98	114.27	113.95	114.23	2339500.0
2004-06-07 14:00:00	SPY	ETF	114.2	114.45	114.09	114.4	3000400.0
2004-06-07 15:00:00	SPY	ETF	114.39	114.7	114.35	114.65	5788900.0
2004-06-07 16:00:00	SPY	ETF	114.65	114.81	114.55	114.62	1963800.0
2004-06-07 17:00:00	SPY	ETF	114.63	114.66	114.62	114.63	49600.0
2004-06-07 18:00:00	SPY	ETF	114.66	114.69	114.66	114.67	10900.0
2004-06-07 19:00:00	SPY	ETF	114.66	114.69	114.65	114.65	3000.0
2004-06-07 08:00:00	QQQ	ETF	36.49	36.5	36.46	36.47	94100.0
2004-06-07 09:00:00	QQQ	ETF	36.47	36.56	36.39	36.54	13695400.0
2004-06-07 10:00:00	QQQ	ETF	36.541	36.541	36.4	36.47	12432300.0
2004-06-07 11:00:00	QQQ	ETF	36.47	36.7	36.45	36.65	19745000.0
2004-06-07 12:00:00	QQQ	ETF	36.65	36.737	36.61	36.65	8688200.0
2004-06-07 13:00:00	QQQ	ETF	36.65	36.8	36.64	36.78	8963900.0
2004-06-07 14:00:00	QQQ	ETF	36.777	36.9	36.73	36.87	11461100.0
2004-06-07 15:00:00	QQQ	ETF	36.87	37.09	36.86	37.066	23320600.0
2004-06-07 16:00:00	QQQ	ETF	37.06	37.1	36.98	37.01	4809800.0
2004-06-07 17:00:00	QQQ	ETF	37.0	37.01	36.96	36.98	112600.0
2004-06-07 18:00:00	QQQ	ETF	36.98	37.0	36.98	36.99	61700.0
2004-06-07 19:00:00	QQQ	ETF	37.0	37.04	36.99	37.0	7400.0
2004-06-07 08:00:00	IWM	ETF	57.03	57.03	57.03	57.03	2000.0
2004-06-07 09:00:00	IWM	ETF	57.06	57.245	56.8	57.2	1920200.0
2004-06-07 10:00:00	IWM	ETF	57.215	57.215	57.04	57.155	1138600.0
2004-06-07 11:00:00	IWM	ETF	57.135	57.39	57.135	57.325	776200.0
2004-06-07 12:00:00	IWM	ETF	57.31	57.385	57.25	57.31	536000.0
2004-06-07 13:00:00	IWM	ETF	57.32	57.495	57.31	57.475	686400.0
2004-06-07 14:00:00	IWM	ETF	57.48	57.585	57.385	57.56	566600.0
2004-06-07 15:00:00	IWM	ETF	57.565	57.77	57.51	57.73	2389000.0
2004-06-07 16:00:00	IWM	ETF	57.68	57.755	57.645	57.645	596400.0
2004-06-07 17:00:00	IWM	ETF	57.675	57.675	57.675	57.675	1000.0
2004-06-07 08:00:00	DIA	ETF	103.24	103.35	103.24	103.28	3500.0
2004-06-07 09:00:00	DIA	ETF	103.26	103.4	103.121	103.33	588800.0
2004-06-07 10:00:00	DIA	ETF	103.33	103.47	103.21	103.36	562400.0
2004-06-07 11:00:00	DIA	ETF	103.36	103.63	103.35	103.53	813200.0
2004-06-07 12:00:00	DIA	ETF	103.53	103.57	103.38	103.49	250500.0
2004-06-07 13:00:00	DIA	ETF	103.5	103.68	103.45	103.62	165300.0
2004-06-07 14:00:00	DIA	ETF	103.63	103.83	103.49	103.78	490500.0
2004-06-07 15:00:00	DIA	ETF	103.78	104.02	103.74	104.0	1216400.0
2004-06-07 16:00:00	DIA	ETF	103.99	104.1	103.89	103.98	1240200.0
2004-06-07 17:00:00	DIA	ETF	104.03	104.03	104.03	104.03	800.0
2004-06-07 18:00:00	DIA	ETF	104.0	104.0	104.0	104.0	1800.0
2004-06-07 19:00:00	DIA	ETF	104.0	104.0	103.82	104.0	1500.0
2004-06-07 09:00:00	TLT	ETF	81.42	81.42	81.29	81.29	22200.0
2004-06-07 10:00:00	TLT	ETF	81.3	81.35	81.22	81.35	32300.0
2004-06-07 11:00:00	TLT	ETF	81.33	81.34	81.24	81.31	78900.0
2004-06-07 12:00:00	TLT	ETF	81.3	81.41	81.26	81.35	124600.0

> showing 50 of 703 rows — these rows as CSV

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