PREVIEW / etf_1hour / 2004-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-05.parquet
  size:    25 KB
  rows:    691

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-08-05 08:00:00	SPY	ETF	110.31	110.41	110.27	110.39	51500.0
2004-08-05 09:00:00	SPY	ETF	110.38	110.42	110.18	110.29	2775800.0
2004-08-05 10:00:00	SPY	ETF	110.29	110.3	109.9	110.03	5754700.0
2004-08-05 11:00:00	SPY	ETF	110.02	110.11	109.51	109.55	5473600.0
2004-08-05 12:00:00	SPY	ETF	109.56	109.56	109.07	109.3	6707200.0
2004-08-05 13:00:00	SPY	ETF	109.29	109.43	109.12	109.38	4968400.0
2004-08-05 14:00:00	SPY	ETF	109.38	109.49	108.76	108.84	7749200.0
2004-08-05 15:00:00	SPY	ETF	108.87	109.19	108.37	108.52	12634700.0
2004-08-05 16:00:00	SPY	ETF	108.51	108.54	108.27	108.4	2312700.0
2004-08-05 17:00:00	SPY	ETF	108.4	108.45	108.35	108.4	13600.0
2004-08-05 18:00:00	SPY	ETF	108.4	108.45	108.38	108.38	46700.0
2004-08-05 19:00:00	SPY	ETF	108.42	108.43	108.39	108.43	3000.0
2004-08-05 08:00:00	QQQ	ETF	34.36	34.43	34.35	34.42	163800.0
2004-08-05 09:00:00	QQQ	ETF	34.41	34.41	34.3	34.37	8201100.0
2004-08-05 10:00:00	QQQ	ETF	34.37	34.39	34.188	34.28	13312900.0
2004-08-05 11:00:00	QQQ	ETF	34.282	34.3	34.02	34.061	12353100.0
2004-08-05 12:00:00	QQQ	ETF	34.061	34.07	33.8	33.94	17388800.0
2004-08-05 13:00:00	QQQ	ETF	33.94	34.0	33.859	33.95	9336200.0
2004-08-05 14:00:00	QQQ	ETF	33.95	33.99	33.73	33.75	15420100.0
2004-08-05 15:00:00	QQQ	ETF	33.75	33.88	33.61	33.64	25300000.0
2004-08-05 16:00:00	QQQ	ETF	33.65	33.65	33.56	33.59	6605000.0
2004-08-05 17:00:00	QQQ	ETF	33.59	33.61	33.55	33.58	267200.0
2004-08-05 18:00:00	QQQ	ETF	33.57	33.62	33.57	33.6	91100.0
2004-08-05 19:00:00	QQQ	ETF	33.6	33.62	33.6	33.6	7200.0
2004-08-05 08:00:00	IWM	ETF	54.15	54.155	54.125	54.125	25600.0
2004-08-05 09:00:00	IWM	ETF	54.125	54.13	53.8	53.955	1407600.0
2004-08-05 10:00:00	IWM	ETF	53.965	53.965	53.65	53.835	1840800.0
2004-08-05 11:00:00	IWM	ETF	53.83	53.87	53.4	53.54	2296600.0
2004-08-05 12:00:00	IWM	ETF	53.54	53.545	53.29	53.45	1562200.0
2004-08-05 13:00:00	IWM	ETF	53.45	53.535	53.315	53.5	1079800.0
2004-08-05 14:00:00	IWM	ETF	53.505	53.61	53.18	53.205	869800.0
2004-08-05 15:00:00	IWM	ETF	53.21	53.385	52.955	53.01	3553600.0
2004-08-05 16:00:00	IWM	ETF	52.99	53.155	52.84	52.935	2173800.0
2004-08-05 17:00:00	IWM	ETF	52.975	52.975	52.975	52.975	20000.0
2004-08-05 08:00:00	DIA	ETF	101.51	101.59	101.49	101.58	16200.0
2004-08-05 09:00:00	DIA	ETF	101.53	101.59	101.33	101.44	274700.0
2004-08-05 10:00:00	DIA	ETF	101.45	101.47	101.16	101.31	644700.0
2004-08-05 11:00:00	DIA	ETF	101.31	101.38	100.87	100.9	734300.0
2004-08-05 12:00:00	DIA	ETF	100.88	100.88	100.44	100.63	1273400.0
2004-08-05 13:00:00	DIA	ETF	100.62	100.69	100.44	100.64	1079300.0
2004-08-05 14:00:00	DIA	ETF	100.65	100.8	100.1	100.19	1500500.0
2004-08-05 15:00:00	DIA	ETF	100.18	100.45	99.76	99.84	1898100.0
2004-08-05 16:00:00	DIA	ETF	99.82	99.84	99.64	99.7	248700.0
2004-08-05 18:00:00	DIA	ETF	99.72	99.72	99.7	99.7	1100.0
2004-08-05 19:00:00	DIA	ETF	99.65	99.65	99.65	99.65	400.0
2004-08-05 09:00:00	TLT	ETF	84.88	84.98	84.86	84.87	28300.0
2004-08-05 10:00:00	TLT	ETF	84.86	84.99	84.86	84.91	38200.0
2004-08-05 11:00:00	TLT	ETF	84.94	85.0	84.92	84.96	62700.0
2004-08-05 12:00:00	TLT	ETF	84.96	85.09	84.96	85.04	110300.0
2004-08-05 13:00:00	TLT	ETF	85.04	85.06	84.97	84.98	207000.0

> showing 50 of 691 rows — these rows as CSV

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