PREVIEW / etf_1hour / 2004-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-29.parquet
  size:    26 KB
  rows:    732

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-10-29 08:00:00	SPY	ETF	113.26	113.3	112.94	113.13	294200.0
2004-10-29 09:00:00	SPY	ETF	113.14	113.62	113.09	113.61	6229600.0
2004-10-29 10:00:00	SPY	ETF	113.62	113.64	112.95	112.95	10164300.0
2004-10-29 11:00:00	SPY	ETF	113.01	113.16	112.9	113.12	5538100.0
2004-10-29 12:00:00	SPY	ETF	113.11	113.2	112.99	113.05	2297000.0
2004-10-29 13:00:00	SPY	ETF	113.04	113.41	113.02	113.03	3564600.0
2004-10-29 14:00:00	SPY	ETF	113.03	113.22	113.01	113.17	2965900.0
2004-10-29 15:00:00	SPY	ETF	113.18	113.52	113.13	113.38	9395600.0
2004-10-29 16:00:00	SPY	ETF	113.38	113.48	113.19	113.19	4541500.0
2004-10-29 17:00:00	SPY	ETF	113.18	113.19	113.15	113.19	6400.0
2004-10-29 18:00:00	SPY	ETF	113.2	113.2	113.18	113.18	1100.0
2004-10-29 08:00:00	QQQ	ETF	36.96	37.0	36.84	36.9	297700.0
2004-10-29 09:00:00	QQQ	ETF	36.9	37.23	36.88	37.204	16611700.0
2004-10-29 10:00:00	QQQ	ETF	37.204	37.24	36.72	36.72	28867500.0
2004-10-29 11:00:00	QQQ	ETF	36.74	36.85	36.67	36.83	14156400.0
2004-10-29 12:00:00	QQQ	ETF	36.823	36.87	36.76	36.8	8013200.0
2004-10-29 13:00:00	QQQ	ETF	36.8	36.94	36.783	36.8	7380900.0
2004-10-29 14:00:00	QQQ	ETF	36.8	36.91	36.77	36.887	5941100.0
2004-10-29 15:00:00	QQQ	ETF	36.888	36.94	36.83	36.91	11764400.0
2004-10-29 16:00:00	QQQ	ETF	36.91	36.9765	36.82	36.85	4771300.0
2004-10-29 17:00:00	QQQ	ETF	36.85	36.9	36.83	36.9	19500.0
2004-10-29 08:00:00	IWM	ETF	58.28	58.32	58.0	58.175	50400.0
2004-10-29 09:00:00	IWM	ETF	58.205	58.56	58.175	58.37	2267400.0
2004-10-29 10:00:00	IWM	ETF	58.4	58.44	58.025	58.06	2524600.0
2004-10-29 11:00:00	IWM	ETF	58.075	58.13	57.875	58.125	2074800.0
2004-10-29 12:00:00	IWM	ETF	58.13	58.16	58.04	58.13	822600.0
2004-10-29 13:00:00	IWM	ETF	58.125	58.23	58.0	58.01	805200.0
2004-10-29 14:00:00	IWM	ETF	57.99	58.16	57.9	58.125	1028200.0
2004-10-29 15:00:00	IWM	ETF	58.125	58.225	58.0258	58.125	1943400.0
2004-10-29 16:00:00	IWM	ETF	58.1	58.165	57.895	58.09	292800.0
2004-10-29 08:00:00	DIA	ETF	100.23	100.26	100.05	100.2	12600.0
2004-10-29 09:00:00	DIA	ETF	100.15	100.62	100.11	100.62	563100.0
2004-10-29 10:00:00	DIA	ETF	100.63	100.64	100.1	100.12	1003700.0
2004-10-29 11:00:00	DIA	ETF	100.12	100.36	100.09	100.33	501300.0
2004-10-29 12:00:00	DIA	ETF	100.32	100.34	100.2	100.26	229400.0
2004-10-29 13:00:00	DIA	ETF	100.26	100.53	100.21	100.23	242900.0
2004-10-29 14:00:00	DIA	ETF	100.23	100.35	100.18	100.3	371500.0
2004-10-29 15:00:00	DIA	ETF	100.3	100.54	100.23	100.47	1844000.0
2004-10-29 16:00:00	DIA	ETF	100.46	100.49	100.31	100.35	266600.0
2004-10-29 17:00:00	DIA	ETF	100.31	100.31	100.31	100.31	800.0
2004-10-29 18:00:00	DIA	ETF	100.31	100.35	100.31	100.35	1000.0
2004-10-29 08:00:00	TLT	ETF	89.25	89.25	89.17	89.2	14400.0
2004-10-29 09:00:00	TLT	ETF	89.14	89.28	89.0	89.05	47000.0
2004-10-29 10:00:00	TLT	ETF	89.04	89.27	88.92	89.27	77600.0
2004-10-29 11:00:00	TLT	ETF	89.24	89.39	89.18	89.34	133300.0
2004-10-29 12:00:00	TLT	ETF	89.34	89.35	89.28	89.34	164800.0
2004-10-29 13:00:00	TLT	ETF	89.33	89.35	89.24	89.35	222000.0
2004-10-29 14:00:00	TLT	ETF	89.35	89.49	89.31	89.45	128600.0
2004-10-29 15:00:00	TLT	ETF	89.47	89.48	89.37	89.48	376300.0
2004-10-29 16:00:00	TLT	ETF	89.48	89.48	89.44	89.44	4200.0

> showing 50 of 732 rows — these rows as CSV

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