PREVIEW / etf_1hour / 2005-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-09.parquet
  size:    35 KB
  rows:    1,053

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-09 06:00:00	SPY	ETF	126.06	126.06	126.06	126.06	100.0
2005-12-09 07:00:00	SPY	ETF	126.06	126.1	126.04	126.1	23800.0
2005-12-09 08:00:00	SPY	ETF	126.11	126.33	126.05	126.28	1535500.0
2005-12-09 09:00:00	SPY	ETF	126.23	126.33	126.11	126.16	6253000.0
2005-12-09 10:00:00	SPY	ETF	126.16	126.22	125.82	126.06	9951500.0
2005-12-09 11:00:00	SPY	ETF	126.06	126.36	125.95	125.96	5474800.0
2005-12-09 12:00:00	SPY	ETF	125.96	126.31	125.92	126.25	4198700.0
2005-12-09 13:00:00	SPY	ETF	126.25	126.6	125.99	126.41	6328700.0
2005-12-09 14:00:00	SPY	ETF	126.4	126.78	126.39	126.61	6518400.0
2005-12-09 15:00:00	SPY	ETF	126.61	126.65	126.31	126.41	7630400.0
2005-12-09 16:00:00	SPY	ETF	126.41	126.44	126.25	126.33	1112400.0
2005-12-09 17:00:00	SPY	ETF	126.35	126.38	126.31	126.31	4300.0
2005-12-09 18:00:00	SPY	ETF	126.33	126.33	126.33	126.33	200.0
2005-12-09 19:00:00	SPY	ETF	126.33	126.36	126.33	126.36	2800.0
2005-12-09 09:00:00	QQQ	ETF	41.57	41.67	41.52	41.56	7577400.0
2005-12-09 10:00:00	QQQ	ETF	41.56	41.59	41.38	41.5	11833700.0
2005-12-09 11:00:00	QQQ	ETF	41.5	41.65	41.48	41.49	7085300.0
2005-12-09 12:00:00	QQQ	ETF	41.49	41.58	41.46	41.56	3724600.0
2005-12-09 13:00:00	QQQ	ETF	41.56	41.7	41.56	41.62	5604200.0
2005-12-09 14:00:00	QQQ	ETF	41.63	41.77	41.59	41.7	9141400.0
2005-12-09 15:00:00	QQQ	ETF	41.71	41.75	41.65	41.71	8552000.0
2005-12-09 08:00:00	IWM	ETF	68.36	68.46	68.3	68.3	145500.0
2005-12-09 09:00:00	IWM	ETF	68.34	68.5	68.24	68.31	1844900.0
2005-12-09 10:00:00	IWM	ETF	68.31	68.35	67.95	68.18	3461300.0
2005-12-09 11:00:00	IWM	ETF	68.19	68.45	68.11	68.11	3439900.0
2005-12-09 12:00:00	IWM	ETF	68.11	68.42	68.08	68.41	1832300.0
2005-12-09 13:00:00	IWM	ETF	68.41	68.71	68.41	68.5	4227100.0
2005-12-09 14:00:00	IWM	ETF	68.48	68.76	68.48	68.6	3746300.0
2005-12-09 15:00:00	IWM	ETF	68.6	68.66	68.44	68.57	2447200.0
2005-12-09 16:00:00	IWM	ETF	68.49	68.64	68.49	68.6	142300.0
2005-12-09 18:00:00	IWM	ETF	68.59	68.59	68.59	68.59	350000.0
2005-12-09 08:00:00	DIA	ETF	107.66	107.8	107.65	107.79	20400.0
2005-12-09 09:00:00	DIA	ETF	107.71	107.8	107.62	107.68	713000.0
2005-12-09 10:00:00	DIA	ETF	107.69	107.74	107.35	107.48	1031200.0
2005-12-09 11:00:00	DIA	ETF	107.49	107.68	107.42	107.43	444400.0
2005-12-09 12:00:00	DIA	ETF	107.44	107.71	107.4	107.66	306400.0
2005-12-09 13:00:00	DIA	ETF	107.67	107.93	107.62	107.79	470200.0
2005-12-09 14:00:00	DIA	ETF	107.82	108.09	107.81	107.97	507700.0
2005-12-09 15:00:00	DIA	ETF	107.97	108.11	107.8	107.85	1103700.0
2005-12-09 16:00:00	DIA	ETF	107.84	107.84	107.75	107.76	424700.0
2005-12-09 18:00:00	DIA	ETF	107.7	107.7	107.7	107.7	500.0
2005-12-09 19:00:00	DIA	ETF	107.85	107.85	107.85	107.85	200.0
2005-12-09 07:00:00	GLD	ETF	51.96	52.01	51.96	52.01	1000.0
2005-12-09 08:00:00	GLD	ETF	52.05	52.34	52.03	52.28	22200.0
2005-12-09 09:00:00	GLD	ETF	52.34	52.35	52.04	52.22	817700.0
2005-12-09 10:00:00	GLD	ETF	52.22	52.9	52.21	52.76	1471800.0
2005-12-09 11:00:00	GLD	ETF	52.77	52.87	52.63	52.71	570300.0
2005-12-09 12:00:00	GLD	ETF	52.72	52.72	52.38	52.46	1370000.0
2005-12-09 13:00:00	GLD	ETF	52.46	52.52	52.36	52.45	376300.0
2005-12-09 14:00:00	GLD	ETF	52.45	52.45	52.3	52.32	373500.0

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

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