PREVIEW / etf_1hour / 2005-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-29.parquet
  size:    32 KB
  rows:    947

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-08-29 06:00:00	SPY	ETF	120.2	120.2	120.17	120.17	1000.0
2005-08-29 07:00:00	SPY	ETF	120.2	120.21	120.1	120.14	242900.0
2005-08-29 08:00:00	SPY	ETF	120.14	120.58	119.6	120.4	1674300.0
2005-08-29 09:00:00	SPY	ETF	120.4	120.69	120.13	120.67	6296300.0
2005-08-29 10:00:00	SPY	ETF	120.68	121.16	120.55	120.78	12813300.0
2005-08-29 11:00:00	SPY	ETF	120.78	121.07	120.73	120.93	3877800.0
2005-08-29 12:00:00	SPY	ETF	120.95	121.03	120.84	120.95	3054600.0
2005-08-29 13:00:00	SPY	ETF	120.97	121.64	120.95	121.56	10693800.0
2005-08-29 14:00:00	SPY	ETF	121.56	121.59	121.38	121.49	4809400.0
2005-08-29 15:00:00	SPY	ETF	121.48	121.78	121.45	121.6	8694800.0
2005-08-29 16:00:00	SPY	ETF	121.59	128.6	121.2559	121.65	2772100.0
2005-08-29 17:00:00	SPY	ETF	121.65	121.67	121.65	121.67	3300.0
2005-08-29 18:00:00	SPY	ETF	121.69	121.7	121.68	121.68	4200.0
2005-08-29 19:00:00	SPY	ETF	121.64	121.65	121.63	121.63	20600.0
2005-08-29 09:00:00	QQQ	ETF	38.26	38.43	38.26	38.42	9825300.0
2005-08-29 10:00:00	QQQ	ETF	38.42	38.6	38.39	38.48	14507700.0
2005-08-29 11:00:00	QQQ	ETF	38.49	38.55	38.47	38.51	5035900.0
2005-08-29 12:00:00	QQQ	ETF	38.51	38.58	38.47	38.55	4129400.0
2005-08-29 13:00:00	QQQ	ETF	38.54	38.84	38.54	38.83	14855800.0
2005-08-29 14:00:00	QQQ	ETF	38.83	38.84	38.71	38.76	7336100.0
2005-08-29 15:00:00	QQQ	ETF	38.76	38.85	38.73	38.74	11720300.0
2005-08-29 07:00:00	IWM	ETF	64.18	64.18	64.15	64.15	1000.0
2005-08-29 08:00:00	IWM	ETF	64.13	64.3	64.1	64.23	54100.0
2005-08-29 09:00:00	IWM	ETF	64.2	64.45	64.2	64.35	3100100.0
2005-08-29 10:00:00	IWM	ETF	64.33	64.6	64.24	64.41	3608300.0
2005-08-29 11:00:00	IWM	ETF	64.39	64.64	64.36	64.58	2914200.0
2005-08-29 12:00:00	IWM	ETF	64.58	64.71	64.56	64.66	997000.0
2005-08-29 13:00:00	IWM	ETF	64.66	65.16	64.66	65.08	4897500.0
2005-08-29 14:00:00	IWM	ETF	65.08	65.1	64.83	65.04	1206700.0
2005-08-29 15:00:00	IWM	ETF	65.05	65.25	65.0	65.22	4123800.0
2005-08-29 16:00:00	IWM	ETF	65.23	65.37	65.19	65.37	1133000.0
2005-08-29 17:00:00	IWM	ETF	65.3	65.35	65.29	65.35	11100.0
2005-08-29 18:00:00	IWM	ETF	65.35	65.35	65.35	65.35	300.0
2005-08-29 07:00:00	DIA	ETF	103.41	103.42	103.4	103.4	900.0
2005-08-29 08:00:00	DIA	ETF	103.34	103.61	103.34	103.53	46100.0
2005-08-29 09:00:00	DIA	ETF	103.51	103.85	103.45	103.84	1421000.0
2005-08-29 10:00:00	DIA	ETF	103.83	104.25	103.77	103.97	2084900.0
2005-08-29 11:00:00	DIA	ETF	103.96	104.22	103.94	104.1	319100.0
2005-08-29 12:00:00	DIA	ETF	104.11	104.2	104.02	104.1	338300.0
2005-08-29 13:00:00	DIA	ETF	104.15	104.7	104.15	104.63	918000.0
2005-08-29 14:00:00	DIA	ETF	104.63	104.65	104.45	104.54	388100.0
2005-08-29 15:00:00	DIA	ETF	104.51	104.81	104.48	104.61	969600.0
2005-08-29 16:00:00	DIA	ETF	104.64	104.69	104.63	104.67	12600.0
2005-08-29 17:00:00	DIA	ETF	104.62	104.62	104.62	104.62	300.0
2005-08-29 18:00:00	DIA	ETF	104.66	104.66	104.62	104.62	800.0
2005-08-29 19:00:00	DIA	ETF	104.7	104.7	104.7	104.7	2500.0
2005-08-29 08:00:00	GLD	ETF	43.71	43.71	43.71	43.71	2500.0
2005-08-29 09:00:00	GLD	ETF	43.81	43.96	43.72	43.9	500200.0
2005-08-29 10:00:00	GLD	ETF	43.89	43.9	43.79	43.8115	323100.0
2005-08-29 11:00:00	GLD	ETF	43.83	43.84	43.68	43.68	102700.0

> showing 50 of 947 rows — these rows as CSV

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