PREVIEW / etf_1hour / 2004-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-22.parquet
  size:    26 KB
  rows:    708

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-07-22 08:00:00	SPY	ETF	109.6	109.76	109.38	109.39	110400.0
2004-07-22 09:00:00	SPY	ETF	109.34	109.83	109.15	109.45	9211100.0
2004-07-22 10:00:00	SPY	ETF	109.45	109.66	109.18	109.31	11436300.0
2004-07-22 11:00:00	SPY	ETF	109.33	109.43	108.77	109.0	10302500.0
2004-07-22 12:00:00	SPY	ETF	109.0	109.78	108.95	109.58	8564700.0
2004-07-22 13:00:00	SPY	ETF	109.59	109.68	109.28	109.59	3725000.0
2004-07-22 14:00:00	SPY	ETF	109.59	110.26	109.55	110.07	10957900.0
2004-07-22 15:00:00	SPY	ETF	110.09	110.39	109.92	109.99	9683400.0
2004-07-22 16:00:00	SPY	ETF	110.01	110.08	109.39	109.5	3443300.0
2004-07-22 17:00:00	SPY	ETF	109.5	109.8	109.5	109.75	491600.0
2004-07-22 18:00:00	SPY	ETF	109.75	109.8	109.72	109.72	121800.0
2004-07-22 19:00:00	SPY	ETF	109.75	109.75	109.74	109.74	7000.0
2004-07-22 08:00:00	QQQ	ETF	34.47	34.54	34.39	34.39	417400.0
2004-07-22 09:00:00	QQQ	ETF	34.39	34.7	34.32	34.53	19046300.0
2004-07-22 10:00:00	QQQ	ETF	34.53	34.64	34.42	34.5	17790800.0
2004-07-22 11:00:00	QQQ	ETF	34.5	34.52	34.25	34.382	17686400.0
2004-07-22 12:00:00	QQQ	ETF	34.38	34.72	34.36	34.61	15750900.0
2004-07-22 13:00:00	QQQ	ETF	34.604	34.65	34.448	34.6	8843600.0
2004-07-22 14:00:00	QQQ	ETF	34.6	34.99	34.59	34.92	19293500.0
2004-07-22 15:00:00	QQQ	ETF	34.91	35.1	34.83	34.96	20148300.0
2004-07-22 16:00:00	QQQ	ETF	34.97	35.03	34.48	34.543	7702100.0
2004-07-22 17:00:00	QQQ	ETF	34.54	34.81	34.52	34.75	2327700.0
2004-07-22 18:00:00	QQQ	ETF	34.75	34.75	34.7	34.72	220100.0
2004-07-22 19:00:00	QQQ	ETF	34.71	34.79	34.7	34.7	3200.0
2004-07-22 08:00:00	IWM	ETF	54.605	54.68	54.48	54.515	75800.0
2004-07-22 09:00:00	IWM	ETF	54.435	54.765	54.37	54.375	2017400.0
2004-07-22 10:00:00	IWM	ETF	54.36	54.45	54.125	54.19	2580600.0
2004-07-22 11:00:00	IWM	ETF	54.175	54.205	53.605	53.77	2331000.0
2004-07-22 12:00:00	IWM	ETF	53.76	54.315	53.745	54.155	2425800.0
2004-07-22 13:00:00	IWM	ETF	54.15	54.195	53.93	54.115	1410200.0
2004-07-22 14:00:00	IWM	ETF	54.11	54.655	54.11	54.435	2893800.0
2004-07-22 15:00:00	IWM	ETF	54.455	54.725	54.365	54.53	1905200.0
2004-07-22 16:00:00	IWM	ETF	54.52	54.665	54.21	54.21	627200.0
2004-07-22 08:00:00	DIA	ETF	100.51	100.72	100.12	100.13	72500.0
2004-07-22 09:00:00	DIA	ETF	100.11	100.58	99.93	100.25	1720000.0
2004-07-22 10:00:00	DIA	ETF	100.22	100.57	100.01	100.14	1849200.0
2004-07-22 11:00:00	DIA	ETF	100.13	100.21	99.63	99.84	1889800.0
2004-07-22 12:00:00	DIA	ETF	99.82	100.46	99.75	100.27	2681300.0
2004-07-22 13:00:00	DIA	ETF	100.26	100.37	100.0	100.25	540800.0
2004-07-22 14:00:00	DIA	ETF	100.25	100.79	100.25	100.6	1186400.0
2004-07-22 15:00:00	DIA	ETF	100.61	100.97	100.49	100.69	1186700.0
2004-07-22 16:00:00	DIA	ETF	100.69	100.74	99.66	100.31	193900.0
2004-07-22 17:00:00	DIA	ETF	100.33	100.55	100.25	100.55	8200.0
2004-07-22 08:00:00	TLT	ETF	84.44	84.5	84.44	84.5	400.0
2004-07-22 09:00:00	TLT	ETF	84.64	84.72	84.58	84.7	15700.0
2004-07-22 10:00:00	TLT	ETF	84.73	84.81	84.68	84.81	25900.0
2004-07-22 11:00:00	TLT	ETF	84.78	84.85	84.68	84.68	32100.0
2004-07-22 12:00:00	TLT	ETF	84.7	84.75	84.63	84.66	21400.0
2004-07-22 13:00:00	TLT	ETF	84.68	84.73	84.66	84.7	25300.0
2004-07-22 14:00:00	TLT	ETF	84.72	84.75	84.66	84.66	4900.0

> showing 50 of 708 rows — these rows as CSV

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