PREVIEW / etf_1hour / 2005-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-25.parquet
  size:    29 KB
  rows:    860

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-05-25 07:00:00	SPY	ETF	119.33	119.33	119.29	119.29	125900.0
2005-05-25 08:00:00	SPY	ETF	119.3	119.46	119.24	119.33	266800.0
2005-05-25 09:00:00	SPY	ETF	119.35	119.43	119.23	119.29	3966600.0
2005-05-25 10:00:00	SPY	ETF	119.29	119.34	118.95	119.05	12254200.0
2005-05-25 11:00:00	SPY	ETF	119.06	119.3	118.91	119.02	5580000.0
2005-05-25 12:00:00	SPY	ETF	119.03	119.16	119.01	119.05	3102000.0
2005-05-25 13:00:00	SPY	ETF	119.05	119.14	118.83	119.0	5282000.0
2005-05-25 14:00:00	SPY	ETF	119.0	119.47	118.98	119.3201	7888400.0
2005-05-25 15:00:00	SPY	ETF	119.32	119.87	119.19	119.32	6142700.0
2005-05-25 16:00:00	SPY	ETF	119.36	119.51	119.13	119.44	769200.0
2005-05-25 17:00:00	SPY	ETF	119.51	119.52	119.44	119.49	81000.0
2005-05-25 18:00:00	SPY	ETF	119.46	119.46	119.43	119.43	10200.0
2005-05-25 19:00:00	SPY	ETF	119.46	119.46	119.42	119.42	1700.0
2005-05-25 09:00:00	QQQ	ETF	37.84	37.87	37.81	37.86	9888600.0
2005-05-25 10:00:00	QQQ	ETF	37.86	37.88	37.66	37.71	18883400.0
2005-05-25 11:00:00	QQQ	ETF	37.7	37.75	37.65	37.69	6929700.0
2005-05-25 12:00:00	QQQ	ETF	37.69	37.74	37.68	37.69	3647300.0
2005-05-25 13:00:00	QQQ	ETF	37.69	37.7	37.59	37.65	7220300.0
2005-05-25 14:00:00	QQQ	ETF	37.64	37.75	37.64	37.73	9470700.0
2005-05-25 15:00:00	QQQ	ETF	37.72	37.85	37.71	37.81	14542300.0
2005-05-25 08:00:00	IWM	ETF	60.795	60.795	60.795	60.795	2000.0
2005-05-25 09:00:00	IWM	ETF	60.7	60.8	60.535	60.575	1752200.0
2005-05-25 10:00:00	IWM	ETF	60.575	60.575	60.15	60.225	5963000.0
2005-05-25 11:00:00	IWM	ETF	60.225	60.33	60.2	60.28	2051000.0
2005-05-25 12:00:00	IWM	ETF	60.28	60.455	60.275	60.4	2537800.0
2005-05-25 13:00:00	IWM	ETF	60.4	60.45	60.235	60.34	2297400.0
2005-05-25 14:00:00	IWM	ETF	60.345	60.66	60.335	60.56	2893400.0
2005-05-25 15:00:00	IWM	ETF	60.57	60.58	60.3	60.375	3638800.0
2005-05-25 16:00:00	IWM	ETF	60.34	61.05	60.28	60.38	644400.0
2005-05-25 17:00:00	IWM	ETF	60.39	60.39	60.39	60.39	200.0
2005-05-25 07:00:00	DIA	ETF	104.65	104.65	104.65	104.65	500.0
2005-05-25 08:00:00	DIA	ETF	104.65	104.76	104.65	104.75	5200.0
2005-05-25 09:00:00	DIA	ETF	104.71	104.75	104.56	104.6101	405500.0
2005-05-25 10:00:00	DIA	ETF	104.61	104.63	104.25	104.38	922300.0
2005-05-25 11:00:00	DIA	ETF	104.36	104.42	104.22	104.33	369200.0
2005-05-25 12:00:00	DIA	ETF	104.33	104.45	104.3	104.38	806100.0
2005-05-25 13:00:00	DIA	ETF	104.39	104.42	104.16	104.3	890200.0
2005-05-25 14:00:00	DIA	ETF	104.3008	104.69	104.3	104.57	719900.0
2005-05-25 15:00:00	DIA	ETF	104.58	104.61	104.42	104.51	752600.0
2005-05-25 16:00:00	DIA	ETF	104.5115	104.55	104.51	104.52	16700.0
2005-05-25 17:00:00	DIA	ETF	104.56	104.56	104.56	104.56	200.0
2005-05-25 18:00:00	DIA	ETF	104.59	104.59	104.59	104.59	200.0
2005-05-25 08:00:00	GLD	ETF	41.73	41.73	41.66	41.66	2700.0
2005-05-25 09:00:00	GLD	ETF	41.72	41.81	41.72	41.75	216200.0
2005-05-25 10:00:00	GLD	ETF	41.74	41.79	41.7	41.7	176100.0
2005-05-25 11:00:00	GLD	ETF	41.7	41.77	41.69	41.75	81800.0
2005-05-25 12:00:00	GLD	ETF	41.75	41.8	41.75	41.78	99100.0
2005-05-25 13:00:00	GLD	ETF	41.7602	41.82	41.7602	41.82	160500.0
2005-05-25 14:00:00	GLD	ETF	41.82	41.87	41.81	41.85	461500.0
2005-05-25 15:00:00	GLD	ETF	41.86	41.9	41.85	41.85	319900.0

> showing 50 of 860 rows — these rows as CSV

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