PREVIEW / etf_1hour / 2004-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-29.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-09-29 08:00:00	SPY	ETF	111.24	111.34	111.22	111.22	81400.0
2004-09-29 09:00:00	SPY	ETF	111.22	111.31	111.05	111.28	4212100.0
2004-09-29 10:00:00	SPY	ETF	111.28	111.49	111.0	111.37	9314200.0
2004-09-29 11:00:00	SPY	ETF	111.37	111.46	111.2	111.29	2988100.0
2004-09-29 12:00:00	SPY	ETF	111.29	111.59	111.18	111.5	3360200.0
2004-09-29 13:00:00	SPY	ETF	111.5	111.54	111.33	111.4	3237700.0
2004-09-29 14:00:00	SPY	ETF	111.4	111.53	111.2	111.47	3326300.0
2004-09-29 15:00:00	SPY	ETF	111.47	111.79	111.45	111.74	4177200.0
2004-09-29 16:00:00	SPY	ETF	111.74	111.88	111.67	111.84	1884200.0
2004-09-29 17:00:00	SPY	ETF	111.81	111.85	111.79	111.82	537000.0
2004-09-29 18:00:00	SPY	ETF	111.84	111.85	111.78	111.78	4000.0
2004-09-29 19:00:00	SPY	ETF	111.83	111.83	111.83	111.83	100.0
2004-09-29 08:00:00	QQQ	ETF	34.56	34.62	34.56	34.57	284200.0
2004-09-29 09:00:00	QQQ	ETF	34.56	34.76	34.52	34.75	14650200.0
2004-09-29 10:00:00	QQQ	ETF	34.75	35.03	34.65	34.97	24118800.0
2004-09-29 11:00:00	QQQ	ETF	34.97	35.03	34.88	34.95	11219100.0
2004-09-29 12:00:00	QQQ	ETF	34.96	35.12	34.9	35.08	9926700.0
2004-09-29 13:00:00	QQQ	ETF	35.08	35.09	35.0	35.05	6715200.0
2004-09-29 14:00:00	QQQ	ETF	35.045	35.06	34.96	35.03	9948300.0
2004-09-29 15:00:00	QQQ	ETF	35.023	35.11	34.97	35.089	14398300.0
2004-09-29 16:00:00	QQQ	ETF	35.09	35.12	35.06	35.07	2891900.0
2004-09-29 17:00:00	QQQ	ETF	35.08	35.1	35.06	35.09	727000.0
2004-09-29 18:00:00	QQQ	ETF	35.08	35.08	35.05	35.07	115300.0
2004-09-29 19:00:00	QQQ	ETF	35.06	35.08	35.06	35.06	10500.0
2004-09-29 08:00:00	IWM	ETF	56.355	56.36	56.35	56.35	35800.0
2004-09-29 09:00:00	IWM	ETF	56.33	56.605	56.235	56.605	2507400.0
2004-09-29 10:00:00	IWM	ETF	56.59	56.865	56.435	56.82	4289400.0
2004-09-29 11:00:00	IWM	ETF	56.805	56.85	56.725	56.75	1372600.0
2004-09-29 12:00:00	IWM	ETF	56.73	56.83	56.675	56.765	959200.0
2004-09-29 13:00:00	IWM	ETF	56.775	56.8	56.64	56.66	871000.0
2004-09-29 14:00:00	IWM	ETF	56.69	56.75	56.555	56.735	1284200.0
2004-09-29 15:00:00	IWM	ETF	56.73	56.9	56.625	56.865	2672200.0
2004-09-29 16:00:00	IWM	ETF	56.865	56.965	56.8	56.965	1038000.0
2004-09-29 08:00:00	DIA	ETF	100.89	100.92	100.79	100.79	23000.0
2004-09-29 09:00:00	DIA	ETF	100.77	100.9	100.62	100.9	1320600.0
2004-09-29 10:00:00	DIA	ETF	100.9	101.11	100.7	100.99	1818200.0
2004-09-29 11:00:00	DIA	ETF	101.01	101.1	100.85	100.94	818700.0
2004-09-29 12:00:00	DIA	ETF	100.93	101.15	100.8	101.05	670300.0
2004-09-29 13:00:00	DIA	ETF	101.04	101.11	100.94	100.98	299100.0
2004-09-29 14:00:00	DIA	ETF	101.02	101.16	100.88	101.1	381300.0
2004-09-29 15:00:00	DIA	ETF	101.09	101.45	101.08	101.41	1369200.0
2004-09-29 16:00:00	DIA	ETF	101.41	101.5	101.4	101.48	274600.0
2004-09-29 17:00:00	DIA	ETF	101.45	101.45	101.41	101.41	1800.0
2004-09-29 19:00:00	DIA	ETF	101.4	101.4	101.4	101.4	200.0
2004-09-29 08:00:00	TLT	ETF	89.27	89.27	89.01	89.01	15800.0
2004-09-29 09:00:00	TLT	ETF	88.9	88.9	88.69	88.81	656800.0
2004-09-29 10:00:00	TLT	ETF	88.82	88.85	88.6	88.73	238200.0
2004-09-29 11:00:00	TLT	ETF	88.67	88.8	88.62	88.8	115800.0
2004-09-29 12:00:00	TLT	ETF	88.75	88.76	88.64	88.68	80300.0
2004-09-29 13:00:00	TLT	ETF	88.68	88.68	88.56	88.6	314300.0

> showing 50 of 674 rows — these rows as CSV

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