PREVIEW / etf_1hour / 2004-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-09.parquet
  size:    24 KB
  rows:    672

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-09-09 08:00:00	SPY	ETF	112.25	112.61	112.25	112.61	142200.0
2004-09-09 09:00:00	SPY	ETF	112.59	112.78	112.48	112.53	5156900.0
2004-09-09 10:00:00	SPY	ETF	112.54	112.55	112.24	112.4	6105100.0
2004-09-09 11:00:00	SPY	ETF	112.4	112.43	112.03	112.13	4682000.0
2004-09-09 12:00:00	SPY	ETF	112.13	112.4	112.07	112.4	3358800.0
2004-09-09 13:00:00	SPY	ETF	112.4	112.68	112.31	112.5	4103600.0
2004-09-09 14:00:00	SPY	ETF	112.51	112.88	112.4	112.84	3745900.0
2004-09-09 15:00:00	SPY	ETF	112.87	112.87	112.43	112.5	4401300.0
2004-09-09 16:00:00	SPY	ETF	112.5	112.53	112.4	112.43	1688200.0
2004-09-09 17:00:00	SPY	ETF	112.43	112.45	112.35	112.38	21300.0
2004-09-09 18:00:00	SPY	ETF	112.45	112.45	112.45	112.45	1000.0
2004-09-09 19:00:00	SPY	ETF	112.43	112.44	112.43	112.43	3000.0
2004-09-09 08:00:00	QQQ	ETF	34.18	34.48	34.18	34.47	616700.0
2004-09-09 09:00:00	QQQ	ETF	34.47	34.58	34.4	34.434	11953500.0
2004-09-09 10:00:00	QQQ	ETF	34.431	34.47	34.311	34.37	13877200.0
2004-09-09 11:00:00	QQQ	ETF	34.369	34.38	34.2	34.26	10977300.0
2004-09-09 12:00:00	QQQ	ETF	34.25	34.35	34.14	34.34	13370900.0
2004-09-09 13:00:00	QQQ	ETF	34.34	34.62	34.32	34.5	18252100.0
2004-09-09 14:00:00	QQQ	ETF	34.49	34.75	34.47	34.724	15011800.0
2004-09-09 15:00:00	QQQ	ETF	34.725	34.75	34.53	34.57	15106700.0
2004-09-09 16:00:00	QQQ	ETF	34.578	34.62	34.55	34.58	1734100.0
2004-09-09 17:00:00	QQQ	ETF	34.59	34.6	34.54	34.6	156500.0
2004-09-09 18:00:00	QQQ	ETF	34.6	34.6	34.575	34.6	59100.0
2004-09-09 19:00:00	QQQ	ETF	34.58	34.6	34.58	34.59	4300.0
2004-09-09 08:00:00	IWM	ETF	55.89	55.89	55.89	55.89	3000.0
2004-09-09 09:00:00	IWM	ETF	55.94	56.11	55.835	56.02	1297000.0
2004-09-09 10:00:00	IWM	ETF	55.99	56.025	55.9	56.01	1936600.0
2004-09-09 11:00:00	IWM	ETF	56.02	56.05	55.905	55.95	1281200.0
2004-09-09 12:00:00	IWM	ETF	55.95	56.09	55.945	56.09	1166000.0
2004-09-09 13:00:00	IWM	ETF	56.09	56.415	56.07	56.33	1530400.0
2004-09-09 14:00:00	IWM	ETF	56.325	56.74	56.275	56.685	1656400.0
2004-09-09 15:00:00	IWM	ETF	56.69	56.705	56.45	56.525	2239200.0
2004-09-09 16:00:00	IWM	ETF	56.52	56.55	56.34	56.5	608400.0
2004-09-09 17:00:00	IWM	ETF	56.5	56.5	56.5	56.5	1000.0
2004-09-09 08:00:00	DIA	ETF	103.3	103.4	103.28	103.4	46600.0
2004-09-09 09:00:00	DIA	ETF	103.39	103.57	103.35	103.4	1134500.0
2004-09-09 10:00:00	DIA	ETF	103.4	103.41	103.05	103.21	581400.0
2004-09-09 11:00:00	DIA	ETF	103.21	103.23	102.87	102.94	618400.0
2004-09-09 12:00:00	DIA	ETF	102.93	103.13	102.87	103.13	309300.0
2004-09-09 13:00:00	DIA	ETF	103.1	103.32	103.0	103.06	775100.0
2004-09-09 14:00:00	DIA	ETF	103.07	103.33	102.98	103.28	786600.0
2004-09-09 15:00:00	DIA	ETF	103.27	103.27	102.97	103.05	852200.0
2004-09-09 16:00:00	DIA	ETF	103.05	103.07	102.95	102.98	94700.0
2004-09-09 17:00:00	DIA	ETF	103.0	103.0	103.0	103.0	2000.0
2004-09-09 18:00:00	DIA	ETF	103.0	103.0	103.0	103.0	100.0
2004-09-09 19:00:00	DIA	ETF	103.03	103.03	103.03	103.03	1000.0
2004-09-09 08:00:00	TLT	ETF	87.27	87.27	87.24	87.24	2800.0
2004-09-09 09:00:00	TLT	ETF	87.22	87.32	87.19	87.23	84500.0
2004-09-09 10:00:00	TLT	ETF	87.25	87.32	87.08	87.26	38000.0
2004-09-09 11:00:00	TLT	ETF	87.27	87.58	87.27	87.54	34500.0

> showing 50 of 672 rows — these rows as CSV

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