PREVIEW / etf_1hour / 2005-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-05.parquet
  size:    28 KB
  rows:    833

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-04-05 08:00:00	SPY	ETF	117.81	117.89	117.77	117.83	414500.0
2005-04-05 09:00:00	SPY	ETF	117.83	118.26	117.77	118.24	6019300.0
2005-04-05 10:00:00	SPY	ETF	118.24	118.38	118.07	118.2	10095300.0
2005-04-05 11:00:00	SPY	ETF	118.2	118.21	117.9	117.95	5234300.0
2005-04-05 12:00:00	SPY	ETF	117.96	118.2	117.9	118.03	4528100.0
2005-04-05 13:00:00	SPY	ETF	118.04	118.32	118.01	118.24	3889200.0
2005-04-05 14:00:00	SPY	ETF	118.24	118.32	117.67	118.0	8434100.0
2005-04-05 15:00:00	SPY	ETF	118.0	118.22	117.97	118.08	5796900.0
2005-04-05 16:00:00	SPY	ETF	118.08	118.19	118.0	118.1	3534500.0
2005-04-05 17:00:00	SPY	ETF	118.12	118.14	118.08	118.14	57700.0
2005-04-05 18:00:00	SPY	ETF	118.07	118.09	118.07	118.09	1100.0
2005-04-05 19:00:00	SPY	ETF	118.1	118.1	118.1	118.1	200.0
2005-04-05 09:00:00	QQQ	ETF	36.49	36.66	36.44	36.64	10007200.0
2005-04-05 10:00:00	QQQ	ETF	36.65	36.67	36.49	36.56	14077600.0
2005-04-05 11:00:00	QQQ	ETF	36.56	36.56	36.45	36.5	8791200.0
2005-04-05 12:00:00	QQQ	ETF	36.5	36.59	36.47	36.54	4006800.0
2005-04-05 13:00:00	QQQ	ETF	36.54	36.63	36.52	36.6	7582900.0
2005-04-05 14:00:00	QQQ	ETF	36.6	36.63	36.42	36.52	9196800.0
2005-04-05 15:00:00	QQQ	ETF	36.52	36.6	36.51	36.55	7413400.0
2005-04-05 08:00:00	IWM	ETF	61.165	61.165	61.155	61.155	4200.0
2005-04-05 09:00:00	IWM	ETF	61.145	61.3	61.0	61.285	2863000.0
2005-04-05 10:00:00	IWM	ETF	61.29	61.325	61.065	61.125	2559200.0
2005-04-05 11:00:00	IWM	ETF	61.125	61.125	60.875	60.9	2872200.0
2005-04-05 12:00:00	IWM	ETF	60.89	61.15	60.885	61.1	1233400.0
2005-04-05 13:00:00	IWM	ETF	61.09	61.215	61.04	61.125	2818800.0
2005-04-05 14:00:00	IWM	ETF	61.125	61.18	60.875	61.04	2219200.0
2005-04-05 15:00:00	IWM	ETF	61.045	61.141	61.0	61.115	2793800.0
2005-04-05 16:00:00	IWM	ETF	61.15	61.185	61.08	61.08	139400.0
2005-04-05 08:00:00	DIA	ETF	104.32	104.36	104.31	104.31	6200.0
2005-04-05 09:00:00	DIA	ETF	104.3	104.62	104.26	104.58	519300.0
2005-04-05 10:00:00	DIA	ETF	104.59	104.67	104.41	104.6	1614500.0
2005-04-05 11:00:00	DIA	ETF	104.59	104.6	104.38	104.43	734800.0
2005-04-05 12:00:00	DIA	ETF	104.43	104.62	104.39	104.52	204400.0
2005-04-05 13:00:00	DIA	ETF	104.52	104.68	104.44	104.63	309100.0
2005-04-05 14:00:00	DIA	ETF	104.6	104.68	104.15	104.44	501900.0
2005-04-05 15:00:00	DIA	ETF	104.47	104.64	104.25	104.53	416100.0
2005-04-05 16:00:00	DIA	ETF	104.52	104.61	104.52	104.6	8500.0
2005-04-05 17:00:00	DIA	ETF	104.55	104.55	104.54	104.54	300.0
2005-04-05 18:00:00	DIA	ETF	104.55	104.55	104.55	104.55	100.0
2005-04-05 19:00:00	DIA	ETF	104.6	104.6	104.6	104.6	100.0
2005-04-05 08:00:00	GLD	ETF	42.46	42.55	42.45	42.55	108000.0
2005-04-05 09:00:00	GLD	ETF	42.5	42.54	42.46	42.49	139200.0
2005-04-05 10:00:00	GLD	ETF	42.48	42.48	42.4	42.43	69200.0
2005-04-05 11:00:00	GLD	ETF	42.41	42.5	42.41	42.48	143500.0
2005-04-05 12:00:00	GLD	ETF	42.48	42.5	42.44	42.48	61900.0
2005-04-05 13:00:00	GLD	ETF	42.48	42.48	42.38	42.41	204400.0
2005-04-05 14:00:00	GLD	ETF	42.39	42.49	42.39	42.49	33500.0
2005-04-05 15:00:00	GLD	ETF	42.47	42.48	42.42	42.45	127600.0
2005-04-05 09:00:00	TLT	ETF	89.24	89.24	89.17	89.2	212900.0
2005-04-05 10:00:00	TLT	ETF	89.2	89.23	89.02	89.02	68300.0

> showing 50 of 833 rows — these rows as CSV

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