PREVIEW / etf_1hour / 2005-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-29.parquet
  size:    31 KB
  rows:    886

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-29 04:00:00	SPY	ETF	114.82	114.82	114.82	114.82	10000.0
2005-04-29 05:00:00	SPY	ETF	114.89	114.89	114.89	114.89	10000.0
2005-04-29 06:00:00	SPY	ETF	114.97	115.0	114.89	114.89	67500.0
2005-04-29 07:00:00	SPY	ETF	114.85	115.0	114.84	114.93	511700.0
2005-04-29 08:00:00	SPY	ETF	114.93	115.19	114.85	115.11	1228600.0
2005-04-29 09:00:00	SPY	ETF	115.12	115.16	114.73	114.94	9667100.0
2005-04-29 10:00:00	SPY	ETF	114.94	115.16	113.97	114.39	25095500.0
2005-04-29 11:00:00	SPY	ETF	114.45	114.78	114.25	114.49	15637200.0
2005-04-29 12:00:00	SPY	ETF	114.5	114.79	114.22	114.64	7827000.0
2005-04-29 13:00:00	SPY	ETF	114.65	115.02	114.57	114.77	10626400.0
2005-04-29 14:00:00	SPY	ETF	114.79	115.59	114.76	115.33	13297300.0
2005-04-29 15:00:00	SPY	ETF	115.35	115.79	115.17	115.7	13711500.0
2005-04-29 16:00:00	SPY	ETF	115.7	115.89	115.65	115.8	1493500.0
2005-04-29 17:00:00	SPY	ETF	115.78	115.94	115.69	115.84	75100.0
2005-04-29 18:00:00	SPY	ETF	115.84	115.84	115.8	115.8	3500.0
2005-04-29 19:00:00	SPY	ETF	115.82	115.82	115.75	115.76	2300.0
2005-04-29 09:00:00	QQQ	ETF	35.0	35.01	34.84	34.94	10139700.0
2005-04-29 10:00:00	QQQ	ETF	34.94	34.97	34.35	34.49	33288600.0
2005-04-29 11:00:00	QQQ	ETF	34.49	34.66	34.47	34.5	20828500.0
2005-04-29 12:00:00	QQQ	ETF	34.5	34.65	34.46	34.6	11288400.0
2005-04-29 13:00:00	QQQ	ETF	34.6	34.77	34.59	34.7	13169400.0
2005-04-29 14:00:00	QQQ	ETF	34.71	35.06	34.67	34.97	22710000.0
2005-04-29 15:00:00	QQQ	ETF	34.96	35.05	34.85	34.99	22410600.0
2005-04-29 08:00:00	IWM	ETF	57.35	57.52	57.35	57.49	50200.0
2005-04-29 09:00:00	IWM	ETF	57.48	57.715	57.185	57.295	5838000.0
2005-04-29 10:00:00	IWM	ETF	57.295	57.415	56.495	56.75	13526600.0
2005-04-29 11:00:00	IWM	ETF	56.75	57.1	56.645	56.76	8343600.0
2005-04-29 12:00:00	IWM	ETF	56.76	56.97	56.685	56.89	2049600.0
2005-04-29 13:00:00	IWM	ETF	56.855	57.365	56.855	57.145	6247200.0
2005-04-29 14:00:00	IWM	ETF	57.145	57.58	57.06	57.405	8346200.0
2005-04-29 15:00:00	IWM	ETF	57.42	57.665	57.26	57.43	9848200.0
2005-04-29 16:00:00	IWM	ETF	57.44	57.65	57.4	57.6	1399400.0
2005-04-29 17:00:00	IWM	ETF	57.55	57.55	57.5247	57.5247	5200.0
2005-04-29 08:00:00	DIA	ETF	101.17	101.4	101.15	101.29	35600.0
2005-04-29 09:00:00	DIA	ETF	101.33	101.36	101.11	101.29	553700.0
2005-04-29 10:00:00	DIA	ETF	101.28	101.44	100.44	100.82	3383000.0
2005-04-29 11:00:00	DIA	ETF	100.83	101.16	100.66	100.89	1595300.0
2005-04-29 12:00:00	DIA	ETF	100.88	101.05	100.61	100.91	627600.0
2005-04-29 13:00:00	DIA	ETF	100.9	101.29	100.9	101.1	1007500.0
2005-04-29 14:00:00	DIA	ETF	101.12	101.84	100.94	101.59	1299800.0
2005-04-29 15:00:00	DIA	ETF	101.6	101.95	101.46	101.81	1507400.0
2005-04-29 16:00:00	DIA	ETF	101.84	101.97	101.84	101.95	79900.0
2005-04-29 17:00:00	DIA	ETF	101.97	101.97	101.87	101.96	30600.0
2005-04-29 18:00:00	DIA	ETF	101.88	101.88	101.68	101.68	700.0
2005-04-29 19:00:00	DIA	ETF	101.85	101.85	101.85	101.85	300.0
2005-04-29 09:00:00	GLD	ETF	43.18	43.61	43.18	43.53	240500.0
2005-04-29 10:00:00	GLD	ETF	43.53	43.56	43.39	43.49	1978500.0
2005-04-29 11:00:00	GLD	ETF	43.49	43.57	43.43	43.57	186200.0
2005-04-29 12:00:00	GLD	ETF	43.56	43.56	43.49	43.49	1062100.0
2005-04-29 13:00:00	GLD	ETF	43.49	43.5	43.34	43.38	179700.0

> showing 50 of 886 rows — these rows as CSV

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