PREVIEW / etf_1hour / 2005-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-28.parquet
  size:    30 KB
  rows:    911

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-28 07:00:00	SPY	ETF	119.4	119.47	119.4	119.44	18300.0
2005-06-28 08:00:00	SPY	ETF	119.42	119.52	119.42	119.46	134700.0
2005-06-28 09:00:00	SPY	ETF	119.46	119.71	119.37	119.65	7182400.0
2005-06-28 10:00:00	SPY	ETF	119.69	119.87	119.6	119.69	9138600.0
2005-06-28 11:00:00	SPY	ETF	119.69	119.95	119.68	119.87	3747500.0
2005-06-28 12:00:00	SPY	ETF	119.87	119.94	119.76	119.8	2189900.0
2005-06-28 13:00:00	SPY	ETF	119.82	120.1	119.79	119.97	4387700.0
2005-06-28 14:00:00	SPY	ETF	119.97	120.2	119.9	120.1	3998400.0
2005-06-28 15:00:00	SPY	ETF	120.09	120.24	120.05	120.15	9164800.0
2005-06-28 16:00:00	SPY	ETF	120.16	120.22	119.8774	120.18	778800.0
2005-06-28 17:00:00	SPY	ETF	120.14	120.15	120.13	120.15	5000.0
2005-06-28 18:00:00	SPY	ETF	120.17	120.19	120.16	120.19	3900.0
2005-06-28 09:00:00	QQQ	ETF	36.94	37.05	36.9	37.01	11646200.0
2005-06-28 10:00:00	QQQ	ETF	37.01	37.1	36.95	36.97	14886100.0
2005-06-28 11:00:00	QQQ	ETF	36.97	37.11	36.96	37.06	6655300.0
2005-06-28 12:00:00	QQQ	ETF	37.06	37.1	36.98	37.04	4265400.0
2005-06-28 13:00:00	QQQ	ETF	37.03	37.17	37.03	37.13	6986600.0
2005-06-28 14:00:00	QQQ	ETF	37.14	37.25	37.12	37.2	9787100.0
2005-06-28 15:00:00	QQQ	ETF	37.2	37.26	37.15	37.15	16304800.0
2005-06-28 08:00:00	IWM	ETF	62.76	62.76	62.76	62.76	600.0
2005-06-28 09:00:00	IWM	ETF	62.75	63.08	62.72	63.06	2942800.0
2005-06-28 10:00:00	IWM	ETF	63.07	63.27	63.06	63.17	3255500.0
2005-06-28 11:00:00	IWM	ETF	63.17	63.45	63.17	63.42	1911100.0
2005-06-28 12:00:00	IWM	ETF	63.42	63.52	63.33	63.36	1346500.0
2005-06-28 13:00:00	IWM	ETF	63.36	63.58	63.36	63.47	1482600.0
2005-06-28 14:00:00	IWM	ETF	63.47	63.65	63.39	63.58	2638900.0
2005-06-28 15:00:00	IWM	ETF	63.59	63.81	63.58	63.8	4177200.0
2005-06-28 16:00:00	IWM	ETF	63.81	63.97	63.34	63.34	1485800.0
2005-06-28 17:00:00	IWM	ETF	63.84	63.84	63.84	63.84	200.0
2005-06-28 18:00:00	IWM	ETF	63.84	63.94	63.84	63.94	200.0
2005-06-28 07:00:00	DIA	ETF	103.26	103.3	103.26	103.3	24800.0
2005-06-28 08:00:00	DIA	ETF	103.22	103.28	103.19	103.21	47600.0
2005-06-28 09:00:00	DIA	ETF	103.19	103.46	103.17	103.46	1028200.0
2005-06-28 10:00:00	DIA	ETF	103.45	103.64	103.44	103.48	1148100.0
2005-06-28 11:00:00	DIA	ETF	103.49	103.66	103.41	103.54	543000.0
2005-06-28 12:00:00	DIA	ETF	103.55	103.62	103.48	103.53	546700.0
2005-06-28 13:00:00	DIA	ETF	103.55	103.79	103.53	103.73	1180400.0
2005-06-28 14:00:00	DIA	ETF	103.7	103.92	103.64	103.82	659200.0
2005-06-28 15:00:00	DIA	ETF	103.83	104.0	103.82	103.9	1142200.0
2005-06-28 16:00:00	DIA	ETF	103.96	104.01	103.96	104.0	50300.0
2005-06-28 17:00:00	DIA	ETF	103.99	103.99	103.99	103.99	100.0
2005-06-28 07:00:00	GLD	ETF	43.63	43.63	43.63	43.63	2000.0
2005-06-28 08:00:00	GLD	ETF	43.6	43.6	43.6	43.6	1000.0
2005-06-28 09:00:00	GLD	ETF	43.59	43.64	43.56	43.63	229600.0
2005-06-28 10:00:00	GLD	ETF	43.6	43.63	43.47	43.51	294400.0
2005-06-28 11:00:00	GLD	ETF	43.52	43.54	43.48	43.52	143500.0
2005-06-28 12:00:00	GLD	ETF	43.53	43.57	43.47	43.55	163000.0
2005-06-28 13:00:00	GLD	ETF	43.55	43.56	43.45	43.49	53500.0
2005-06-28 14:00:00	GLD	ETF	43.47	43.48	43.39	43.44	242500.0
2005-06-28 15:00:00	GLD	ETF	43.44	43.44	43.37	43.39	151100.0

> showing 50 of 911 rows — these rows as CSV

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