PREVIEW / etf_1hour / 2005-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-22.parquet
  size:    30 KB
  rows:    880

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
2005-03-22 08:00:00	SPY	ETF	118.18	118.38	118.17	118.31	267600.0
2005-03-22 09:00:00	SPY	ETF	118.31	118.68	118.29	118.56	7301600.0
2005-03-22 10:00:00	SPY	ETF	118.57	118.76	118.38	118.74	8667000.0
2005-03-22 11:00:00	SPY	ETF	118.74	118.75	118.53	118.65	3743600.0
2005-03-22 12:00:00	SPY	ETF	118.65	118.74	118.63	118.68	1500200.0
2005-03-22 13:00:00	SPY	ETF	118.66	118.85	118.65	118.82	3068300.0
2005-03-22 14:00:00	SPY	ETF	118.82	118.93	117.64	117.94	36000400.0
2005-03-22 15:00:00	SPY	ETF	117.95	117.98	117.06	117.13	20932500.0
2005-03-22 16:00:00	SPY	ETF	117.11	117.24	116.52	116.99	7279600.0
2005-03-22 17:00:00	SPY	ETF	116.97	116.97	116.85	116.92	519600.0
2005-03-22 18:00:00	SPY	ETF	116.92	116.95	116.92	116.95	89000.0
2005-03-22 19:00:00	SPY	ETF	116.95	117.0	116.93	116.93	3900.0
2005-03-22 09:00:00	QQQ	ETF	36.63	38.67	36.59	36.64	9487800.0
2005-03-22 10:00:00	QQQ	ETF	36.64	36.67	36.52	36.65	11412000.0
2005-03-22 11:00:00	QQQ	ETF	36.65	36.66	36.58	36.59	5290900.0
2005-03-22 12:00:00	QQQ	ETF	36.59	36.6	36.58	36.59	2879400.0
2005-03-22 13:00:00	QQQ	ETF	36.58	36.71	36.57	36.7	5712800.0
2005-03-22 14:00:00	QQQ	ETF	36.69	36.75	36.28	36.38	35371700.0
2005-03-22 15:00:00	QQQ	ETF	36.38	36.38	36.11	36.12	32934500.0
2005-03-22 08:00:00	IWM	ETF	62.075	62.075	62.075	62.075	3000.0
2005-03-22 09:00:00	IWM	ETF	61.995	62.34	61.945	62.34	2500200.0
2005-03-22 10:00:00	IWM	ETF	62.345	62.495	62.275	62.48	3359800.0
2005-03-22 11:00:00	IWM	ETF	62.49	62.49	62.395	62.44	1733200.0
2005-03-22 12:00:00	IWM	ETF	62.44	62.46	62.4	62.42	1062600.0
2005-03-22 13:00:00	IWM	ETF	62.415	62.665	62.41	62.6245	4226400.0
2005-03-22 14:00:00	IWM	ETF	62.625	62.755	61.75	62.14	8889600.0
2005-03-22 15:00:00	IWM	ETF	62.13	62.145	61.605	61.62	7938000.0
2005-03-22 16:00:00	IWM	ETF	66.14	66.14	61.37	61.525	348200.0
2005-03-22 17:00:00	IWM	ETF	61.555	61.555	61.545	61.545	3000.0
2005-03-22 18:00:00	IWM	ETF	61.56	61.56	61.56	61.56	4000.0
2005-03-22 08:00:00	DIA	ETF	105.41	105.56	105.38	105.56	66400.0
2005-03-22 09:00:00	DIA	ETF	105.55	105.77	105.53	105.74	402900.0
2005-03-22 10:00:00	DIA	ETF	105.75	105.91	105.51	105.87	1109600.0
2005-03-22 11:00:00	DIA	ETF	105.87	105.88	105.69	105.8	373700.0
2005-03-22 12:00:00	DIA	ETF	105.84	105.87	105.77	105.81	210700.0
2005-03-22 13:00:00	DIA	ETF	105.8	105.96	105.77	105.95	387000.0
2005-03-22 14:00:00	DIA	ETF	105.94	106.03	105.01	105.24	2523400.0
2005-03-22 15:00:00	DIA	ETF	105.24	105.26	104.59	104.67	1688700.0
2005-03-22 16:00:00	DIA	ETF	104.65	104.65	104.39	104.5	98800.0
2005-03-22 17:00:00	DIA	ETF	104.4	104.4	104.4	104.4	3500.0
2005-03-22 18:00:00	DIA	ETF	104.44	104.45	104.44	104.45	1700.0
2005-03-22 19:00:00	DIA	ETF	104.45	104.5	104.45	104.5	1800.0
2005-03-22 08:00:00	GLD	ETF	43.1	43.14	43.1	43.11	9000.0
2005-03-22 09:00:00	GLD	ETF	43.12	43.21	43.12	43.2	99800.0
2005-03-22 10:00:00	GLD	ETF	43.19	43.22	43.12	43.14	89400.0
2005-03-22 11:00:00	GLD	ETF	43.15	43.18	43.07	43.16	154300.0
2005-03-22 12:00:00	GLD	ETF	43.16	43.16	43.06	43.11	99700.0
2005-03-22 13:00:00	GLD	ETF	43.12	43.17	43.1	43.15	119200.0
2005-03-22 14:00:00	GLD	ETF	43.15	43.18	42.73	42.75	619900.0
2005-03-22 15:00:00	GLD	ETF	42.74	42.8	42.55	42.63	1388600.0

> showing 50 of 880 rows — these rows as CSV

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