PREVIEW / etf_1hour / 2004-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-18.parquet
  size:    24 KB
  rows:    674

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-18 08:00:00	SPY	ETF	113.13	113.33	113.12	113.33	103400.0
2004-06-18 09:00:00	SPY	ETF	113.32	113.65	113.2	113.55	5282200.0
2004-06-18 10:00:00	SPY	ETF	113.56	114.22	113.54	114.04	7432900.0
2004-06-18 11:00:00	SPY	ETF	114.04	114.14	113.98	113.99	3199200.0
2004-06-18 12:00:00	SPY	ETF	113.97	114.02	113.84	113.88	1954100.0
2004-06-18 13:00:00	SPY	ETF	113.88	114.07	113.85	113.9	2093900.0
2004-06-18 14:00:00	SPY	ETF	113.91	114.04	113.48	113.68	4096800.0
2004-06-18 15:00:00	SPY	ETF	113.67	113.89	113.58	113.71	3846900.0
2004-06-18 16:00:00	SPY	ETF	113.71	113.85	113.63	113.81	2097600.0
2004-06-18 17:00:00	SPY	ETF	113.8	113.89	113.78	113.85	22900.0
2004-06-18 18:00:00	SPY	ETF	113.81	113.84	113.76	113.76	1700.0
2004-06-18 19:00:00	SPY	ETF	113.8	113.8	113.76	113.79	2300.0
2004-06-18 08:00:00	QQQ	ETF	36.27	36.33	36.26	36.32	68300.0
2004-06-18 09:00:00	QQQ	ETF	36.33	36.51	36.26	36.47	10803100.0
2004-06-18 10:00:00	QQQ	ETF	36.47	36.84	36.47	36.7	21071200.0
2004-06-18 11:00:00	QQQ	ETF	36.69	36.73	36.57	36.61	7654100.0
2004-06-18 12:00:00	QQQ	ETF	36.61	36.62	36.49	36.51	8445300.0
2004-06-18 13:00:00	QQQ	ETF	36.52	36.59	36.49	36.54	5757800.0
2004-06-18 14:00:00	QQQ	ETF	36.54	36.61	36.389	36.47	8775900.0
2004-06-18 15:00:00	QQQ	ETF	36.47	36.55	36.4	36.415	10917800.0
2004-06-18 16:00:00	QQQ	ETF	36.42	36.47	36.38	36.46	2349500.0
2004-06-18 17:00:00	QQQ	ETF	36.46	36.55	36.45	36.47	114200.0
2004-06-18 18:00:00	QQQ	ETF	36.48	36.49	36.41	36.44	80500.0
2004-06-18 19:00:00	QQQ	ETF	36.45	36.48	36.43	36.46	8100.0
2004-06-18 09:00:00	IWM	ETF	56.63	56.875	56.5	56.725	686000.0
2004-06-18 10:00:00	IWM	ETF	56.695	57.18	56.695	57.05	1481600.0
2004-06-18 11:00:00	IWM	ETF	57.065	57.14	57.015	57.05	326600.0
2004-06-18 12:00:00	IWM	ETF	57.04	57.12	56.96	57.04	274400.0
2004-06-18 13:00:00	IWM	ETF	57.045	57.155	57.035	57.12	415000.0
2004-06-18 14:00:00	IWM	ETF	57.11	57.16	56.94	56.975	916600.0
2004-06-18 15:00:00	IWM	ETF	56.965	56.99	56.84	56.875	2726000.0
2004-06-18 16:00:00	IWM	ETF	56.89	56.945	56.845	56.925	4555200.0
2004-06-18 08:00:00	DIA	ETF	103.78	103.78	103.78	103.78	3200.0
2004-06-18 09:00:00	DIA	ETF	103.88	104.1	103.76	104.03	586500.0
2004-06-18 10:00:00	DIA	ETF	104.01	104.53	104.01	104.39	895200.0
2004-06-18 11:00:00	DIA	ETF	104.39	104.49	104.33	104.37	302000.0
2004-06-18 12:00:00	DIA	ETF	104.37	104.4	104.21	104.23	290700.0
2004-06-18 13:00:00	DIA	ETF	104.22	104.38	104.19	104.24	268600.0
2004-06-18 14:00:00	DIA	ETF	104.25	104.35	103.93	104.03	382700.0
2004-06-18 15:00:00	DIA	ETF	104.03	104.27	103.96	104.2	642300.0
2004-06-18 16:00:00	DIA	ETF	104.19	104.24	104.17	104.24	105100.0
2004-06-18 17:00:00	DIA	ETF	104.26	104.39	104.22	104.39	5100.0
2004-06-18 08:00:00	TLT	ETF	82.9	82.95	82.87	82.92	5000.0
2004-06-18 09:00:00	TLT	ETF	82.76	82.85	82.72	82.75	61800.0
2004-06-18 10:00:00	TLT	ETF	82.75	82.77	82.62	82.75	92200.0
2004-06-18 11:00:00	TLT	ETF	82.75	82.76	82.47	82.51	57600.0
2004-06-18 12:00:00	TLT	ETF	82.55	82.57	82.37	82.42	32800.0
2004-06-18 13:00:00	TLT	ETF	82.45	82.6	82.45	82.6	3700.0
2004-06-18 14:00:00	TLT	ETF	82.58	82.65	82.5	82.55	16700.0
2004-06-18 15:00:00	TLT	ETF	82.56	82.59	82.51	82.58	115100.0

> showing 50 of 674 rows — these rows as CSV

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