PREVIEW / etf_1hour / 2004-11-11

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-11.parquet
  size:    27 KB
  rows:    759

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-11-11 08:00:00	SPY	ETF	117.37	117.37	117.28	117.3	97600.0
2004-11-11 09:00:00	SPY	ETF	117.28	117.35	117.11	117.28	1857000.0
2004-11-11 10:00:00	SPY	ETF	117.29	117.5	117.12	117.39	4880800.0
2004-11-11 11:00:00	SPY	ETF	117.39	117.46	117.26	117.4	2810300.0
2004-11-11 12:00:00	SPY	ETF	117.4	117.65	117.37	117.58	5233600.0
2004-11-11 13:00:00	SPY	ETF	117.58	117.67	117.46	117.62	2348600.0
2004-11-11 14:00:00	SPY	ETF	117.61	118.06	117.59	117.95	7776600.0
2004-11-11 15:00:00	SPY	ETF	117.94	118.12	117.88	117.99	8452500.0
2004-11-11 16:00:00	SPY	ETF	117.99	118.02	117.8	117.85	1665300.0
2004-11-11 17:00:00	SPY	ETF	117.84	117.94	117.81	117.85	565600.0
2004-11-11 18:00:00	SPY	ETF	117.91	117.91	117.86	117.89	9100.0
2004-11-11 19:00:00	SPY	ETF	117.86	117.87	117.86	117.87	2500.0
2004-11-11 08:00:00	QQQ	ETF	37.99	37.99	37.94	37.95	116700.0
2004-11-11 09:00:00	QQQ	ETF	37.95	37.98	37.86	37.921	4283400.0
2004-11-11 10:00:00	QQQ	ETF	37.92	38.13	37.88	38.05	17499800.0
2004-11-11 11:00:00	QQQ	ETF	38.05	38.07	37.93	38.0	13328700.0
2004-11-11 12:00:00	QQQ	ETF	38.008	38.07	37.99	38.04	5977700.0
2004-11-11 13:00:00	QQQ	ETF	38.048	38.13	37.99	38.091	7173800.0
2004-11-11 14:00:00	QQQ	ETF	38.1	38.33	38.09	38.27	21006000.0
2004-11-11 15:00:00	QQQ	ETF	38.27	38.38	38.23	38.32	17691000.0
2004-11-11 16:00:00	QQQ	ETF	38.33	38.34	38.22	38.28	4711800.0
2004-11-11 17:00:00	QQQ	ETF	38.28	38.41	38.26	38.39	397800.0
2004-11-11 18:00:00	QQQ	ETF	38.39	38.39	38.332	38.34	165400.0
2004-11-11 19:00:00	QQQ	ETF	38.34	38.37	38.34	38.35	56400.0
2004-11-11 08:00:00	IWM	ETF	60.95	60.95	60.95	60.95	2000.0
2004-11-11 09:00:00	IWM	ETF	60.955	60.955	60.765	60.845	323800.0
2004-11-11 10:00:00	IWM	ETF	60.88	61.0	60.75	60.99	968000.0
2004-11-11 11:00:00	IWM	ETF	60.995	61.075	60.94	61.02	1357400.0
2004-11-11 12:00:00	IWM	ETF	61.025	61.135	61.02	61.08	1120200.0
2004-11-11 13:00:00	IWM	ETF	61.085	61.13	61.04	61.1	450600.0
2004-11-11 14:00:00	IWM	ETF	61.085	61.365	61.065	61.325	1571600.0
2004-11-11 15:00:00	IWM	ETF	61.33	61.49	61.26	61.415	1619200.0
2004-11-11 16:00:00	IWM	ETF	61.42	61.465	61.3	61.305	947400.0
2004-11-11 17:00:00	IWM	ETF	61.305	61.305	61.305	61.305	600.0
2004-11-11 18:00:00	IWM	ETF	61.43	61.43	61.43	61.43	200.0
2004-11-11 08:00:00	DIA	ETF	104.68	105.0	104.6	104.63	7000.0
2004-11-11 09:00:00	DIA	ETF	104.6	104.7	104.48	104.61	171600.0
2004-11-11 10:00:00	DIA	ETF	104.6	104.7	104.42	104.6	780700.0
2004-11-11 11:00:00	DIA	ETF	104.6	104.7	104.52	104.65	362200.0
2004-11-11 12:00:00	DIA	ETF	104.66	104.9	104.63	104.84	508500.0
2004-11-11 13:00:00	DIA	ETF	104.85	104.9	104.7	104.87	396000.0
2004-11-11 14:00:00	DIA	ETF	104.87	105.22	104.86	105.13	1036800.0
2004-11-11 15:00:00	DIA	ETF	105.13	105.26	105.06	105.15	1090500.0
2004-11-11 16:00:00	DIA	ETF	105.14	105.19	105.0	105.03	59200.0
2004-11-11 17:00:00	DIA	ETF	105.05	105.15	105.05	105.15	800.0
2004-11-11 18:00:00	DIA	ETF	105.12	105.12	105.12	105.12	100.0
2004-11-11 19:00:00	DIA	ETF	105.12	105.12	105.12	105.12	400.0
2004-11-11 09:00:00	TLT	ETF	87.45	87.45	87.17	87.27	6200.0
2004-11-11 10:00:00	TLT	ETF	87.2	87.2	87.1	87.12	20300.0
2004-11-11 11:00:00	TLT	ETF	87.11	87.16	87.01	87.16	13000.0

> showing 50 of 759 rows — these rows as CSV

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