PREVIEW / etf_1hour / 2005-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-23.parquet
  size:    31 KB
  rows:    942

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-06-23 07:00:00	SPY	ETF	121.49	121.55	121.38	121.4	56900.0
2005-06-23 08:00:00	SPY	ETF	121.38	121.43	121.27	121.29	183800.0
2005-06-23 09:00:00	SPY	ETF	121.29	121.41	121.21	121.3	4656100.0
2005-06-23 10:00:00	SPY	ETF	121.28	121.38	121.01	121.17	7176800.0
2005-06-23 11:00:00	SPY	ETF	121.17	121.6	121.14	121.42	8173900.0
2005-06-23 12:00:00	SPY	ETF	121.41	121.57	121.27	121.31	2756200.0
2005-06-23 13:00:00	SPY	ETF	121.3	121.33	120.35	120.6	14194900.0
2005-06-23 14:00:00	SPY	ETF	120.6	120.8	120.4	120.53	8535500.0
2005-06-23 15:00:00	SPY	ETF	120.53	120.54	119.97	120.0	12835600.0
2005-06-23 16:00:00	SPY	ETF	120.0	120.0	119.83	119.83	2393900.0
2005-06-23 17:00:00	SPY	ETF	119.83	119.92	119.79	119.87	341200.0
2005-06-23 18:00:00	SPY	ETF	119.87	119.9	119.86	119.87	7800.0
2005-06-23 19:00:00	SPY	ETF	119.86	119.87	119.86	119.87	3100.0
2005-06-23 09:00:00	QQQ	ETF	37.89	38.03	37.78	37.96	13098600.0
2005-06-23 10:00:00	QQQ	ETF	37.95	37.98	37.72	37.81	12828500.0
2005-06-23 11:00:00	QQQ	ETF	37.81	38.18	37.78	38.11	19673200.0
2005-06-23 12:00:00	QQQ	ETF	38.11	38.12	37.99	38.01	6600900.0
2005-06-23 13:00:00	QQQ	ETF	38.0	38.02	37.45	37.53	27457800.0
2005-06-23 14:00:00	QQQ	ETF	37.53	37.62	37.48	37.55	12941000.0
2005-06-23 15:00:00	QQQ	ETF	37.55	37.57	37.33	37.37	21412800.0
2005-06-23 08:00:00	IWM	ETF	63.9	63.9	63.9	63.9	100.0
2005-06-23 09:00:00	IWM	ETF	63.93	64.0	63.8	63.94	1198700.0
2005-06-23 10:00:00	IWM	ETF	63.95	63.96	63.7	63.82	1754500.0
2005-06-23 11:00:00	IWM	ETF	63.81	64.11	63.75	63.99	1550700.0
2005-06-23 12:00:00	IWM	ETF	64.0	64.0	63.84	63.84	1058700.0
2005-06-23 13:00:00	IWM	ETF	63.84	63.88	63.28	63.39	2706400.0
2005-06-23 14:00:00	IWM	ETF	63.38	63.53	63.28	63.34	2478900.0
2005-06-23 15:00:00	IWM	ETF	63.36	63.37	62.97	63.07	6919700.0
2005-06-23 16:00:00	IWM	ETF	63.07	63.08	62.87	62.9	925300.0
2005-06-23 17:00:00	IWM	ETF	62.89	62.93	62.89	62.9	50800.0
2005-06-23 18:00:00	IWM	ETF	62.84	62.84	62.84	62.84	200.0
2005-06-23 19:00:00	IWM	ETF	62.85	62.85	62.85	62.85	500.0
2005-06-23 09:00:00	DIA	ETF	105.8	105.87	105.57	105.6	748900.0
2005-06-23 10:00:00	DIA	ETF	105.59	105.62	105.26	105.38	1360100.0
2005-06-23 11:00:00	DIA	ETF	105.38	105.72	105.35	105.6	825300.0
2005-06-23 12:00:00	DIA	ETF	105.57	105.72	105.37	105.4	561600.0
2005-06-23 13:00:00	DIA	ETF	105.39	105.41	104.64	104.83	1805100.0
2005-06-23 14:00:00	DIA	ETF	104.834	104.97	104.65	104.75	1212800.0
2005-06-23 15:00:00	DIA	ETF	104.76	104.76	103.13	104.13	5911000.0
2005-06-23 16:00:00	DIA	ETF	104.12	104.12	104.0	104.03	7700.0
2005-06-23 17:00:00	DIA	ETF	104.01	104.13	104.01	104.1	2600.0
2005-06-23 18:00:00	DIA	ETF	104.1	104.12	104.1	104.12	600.0
2005-06-23 19:00:00	DIA	ETF	104.12	104.12	104.12	104.12	200.0
2005-06-23 09:00:00	GLD	ETF	43.88	43.92	43.82	43.834	107500.0
2005-06-23 10:00:00	GLD	ETF	43.83	43.99	43.78	43.95	196600.0
2005-06-23 11:00:00	GLD	ETF	43.95	44.13	43.95	44.07	211000.0
2005-06-23 12:00:00	GLD	ETF	44.064	44.12	44.02	44.05	43900.0
2005-06-23 13:00:00	GLD	ETF	44.02	44.06	43.98	44.02	116200.0
2005-06-23 14:00:00	GLD	ETF	44.006	44.05	43.99	44.04	301700.0
2005-06-23 15:00:00	GLD	ETF	44.01	44.08	44.01	44.07	572900.0

> showing 50 of 942 rows — these rows as CSV

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