PREVIEW / etf_1hour / 2005-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-29.parquet
  size:    37 KB
  rows:    1,166

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-12-29 07:00:00	SPY	ETF	125.74	125.74	125.74	125.74	500.0
2005-12-29 08:00:00	SPY	ETF	125.74	125.76	125.64	125.72	97900.0
2005-12-29 09:00:00	SPY	ETF	125.72	125.96	125.69	125.77	2943600.0
2005-12-29 10:00:00	SPY	ETF	125.77	125.82	125.56	125.68	5722900.0
2005-12-29 11:00:00	SPY	ETF	125.68	125.89	125.66	125.77	3241700.0
2005-12-29 12:00:00	SPY	ETF	125.78	125.85	125.66	125.85	2314200.0
2005-12-29 13:00:00	SPY	ETF	125.85	125.89	125.7	125.71	2121500.0
2005-12-29 14:00:00	SPY	ETF	125.71	125.87	125.7	125.75	2665500.0
2005-12-29 15:00:00	SPY	ETF	125.75	125.78	125.25	125.31	11309400.0
2005-12-29 16:00:00	SPY	ETF	125.3	125.3	125.06	125.27	701200.0
2005-12-29 17:00:00	SPY	ETF	125.22	125.6904	125.2	125.22	636200.0
2005-12-29 18:00:00	SPY	ETF	125.25	125.25	125.21	125.21	244700.0
2005-12-29 19:00:00	SPY	ETF	125.24	125.27	125.24	125.24	1400.0
2005-12-29 09:00:00	QQQ	ETF	41.03	41.12	40.98	41.02	5029900.0
2005-12-29 10:00:00	QQQ	ETF	41.02	41.05	40.94	41.0	6448000.0
2005-12-29 11:00:00	QQQ	ETF	40.99	41.07	40.96	40.96	5486500.0
2005-12-29 12:00:00	QQQ	ETF	40.97	40.98	40.88	40.96	4718400.0
2005-12-29 13:00:00	QQQ	ETF	40.96	40.99	40.91	40.92	2394100.0
2005-12-29 14:00:00	QQQ	ETF	40.91	40.97	40.91	40.91	2349500.0
2005-12-29 15:00:00	QQQ	ETF	40.92	40.93	40.65	40.72	17000000.0
2005-12-29 08:00:00	IWM	ETF	67.48	67.51	67.4	67.5	301600.0
2005-12-29 09:00:00	IWM	ETF	67.48	67.57	67.27	67.34	2228900.0
2005-12-29 10:00:00	IWM	ETF	67.34	67.5	67.24	67.43	3619300.0
2005-12-29 11:00:00	IWM	ETF	67.43	67.61	67.42	67.49	2801300.0
2005-12-29 12:00:00	IWM	ETF	67.49	67.65	67.41	67.65	2409400.0
2005-12-29 13:00:00	IWM	ETF	67.65	67.7	67.56	67.58	824900.0
2005-12-29 14:00:00	IWM	ETF	67.58	67.72	67.57	67.69	2224900.0
2005-12-29 15:00:00	IWM	ETF	67.7	67.7	67.24	67.28	6039100.0
2005-12-29 16:00:00	IWM	ETF	67.27	67.29	67.17	67.18	46300.0
2005-12-29 17:00:00	IWM	ETF	67.19	67.22	67.19	67.22	3500.0
2005-12-29 19:00:00	IWM	ETF	67.16	67.16	67.16	67.16	100.0
2005-12-29 07:00:00	DIA	ETF	107.99	108.03	107.97	107.97	38300.0
2005-12-29 08:00:00	DIA	ETF	107.96	108.03	107.84	107.93	11600.0
2005-12-29 09:00:00	DIA	ETF	107.93	108.15	107.89	108.08	221400.0
2005-12-29 10:00:00	DIA	ETF	108.12	108.12	107.9	107.99	420300.0
2005-12-29 11:00:00	DIA	ETF	107.98	108.12	107.97	107.99	589200.0
2005-12-29 12:00:00	DIA	ETF	108.0	108.02	107.89	107.99	338700.0
2005-12-29 13:00:00	DIA	ETF	108.02	108.05	107.93	107.9688	244900.0
2005-12-29 14:00:00	DIA	ETF	107.97	108.14	107.97	108.06	475300.0
2005-12-29 15:00:00	DIA	ETF	108.07	108.08	107.71	107.78	511600.0
2005-12-29 16:00:00	DIA	ETF	107.73	107.75	107.56	107.72	17900.0
2005-12-29 18:00:00	DIA	ETF	107.68	107.68	107.68	107.68	300.0
2005-12-29 08:00:00	GLD	ETF	51.5	51.5	51.43	51.44	10700.0
2005-12-29 09:00:00	GLD	ETF	51.35	51.55	51.26	51.27	494500.0
2005-12-29 10:00:00	GLD	ETF	51.279	51.28	50.92	51.12	1243500.0
2005-12-29 11:00:00	GLD	ETF	51.11	51.28	51.03	51.28	432700.0
2005-12-29 12:00:00	GLD	ETF	51.26	51.32	51.19	51.24	419800.0
2005-12-29 13:00:00	GLD	ETF	51.25	51.46	51.2	51.42	152600.0
2005-12-29 14:00:00	GLD	ETF	51.41	51.45	51.36	51.41	224300.0
2005-12-29 15:00:00	GLD	ETF	51.41	51.58	51.41	51.53	283700.0

> showing 50 of 1,166 rows — these rows as CSV

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