PREVIEW / etf_1hour / 2005-12-06

all etf 1-hour files

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

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-06 07:00:00	SPY	ETF	126.8	126.88	126.77	126.84	7300.0
2005-12-06 08:00:00	SPY	ETF	126.65	127.08	126.65	127.03	680100.0
2005-12-06 09:00:00	SPY	ETF	127.03	127.17	126.88	127.01	5268000.0
2005-12-06 10:00:00	SPY	ETF	127.0	127.34	126.82	127.3	10297600.0
2005-12-06 11:00:00	SPY	ETF	127.28	127.4	127.01	127.31	5515200.0
2005-12-06 12:00:00	SPY	ETF	127.31	127.74	127.27	127.52	7782600.0
2005-12-06 13:00:00	SPY	ETF	127.5	127.68	127.47	127.61	5226900.0
2005-12-06 14:00:00	SPY	ETF	127.62	127.65	127.45	127.5	3406500.0
2005-12-06 15:00:00	SPY	ETF	127.54	127.58	126.63	126.73	15613200.0
2005-12-06 16:00:00	SPY	ETF	126.73	127.2559	126.68	126.82	2851200.0
2005-12-06 17:00:00	SPY	ETF	126.81	126.82	126.8	126.81	85400.0
2005-12-06 18:00:00	SPY	ETF	126.81	126.82	126.79	126.82	3200.0
2005-12-06 19:00:00	SPY	ETF	126.85	126.85	126.85	126.85	500.0
2005-12-06 09:00:00	QQQ	ETF	42.05	42.1	41.99	42.04	8365600.0
2005-12-06 10:00:00	QQQ	ETF	42.04	42.2	41.99	42.17	11923200.0
2005-12-06 11:00:00	QQQ	ETF	42.16	42.19	42.04	42.16	8950400.0
2005-12-06 12:00:00	QQQ	ETF	42.15	42.31	42.15	42.26	12267000.0
2005-12-06 13:00:00	QQQ	ETF	42.25	42.31	42.24	42.3	6012200.0
2005-12-06 14:00:00	QQQ	ETF	42.29	42.33	42.21	42.23	7370100.0
2005-12-06 15:00:00	QQQ	ETF	42.24	42.26	41.9	41.94	21460600.0
2005-12-06 08:00:00	IWM	ETF	68.42	68.59	68.4	68.57	44300.0
2005-12-06 09:00:00	IWM	ETF	68.57	68.86	68.34	68.7	3036200.0
2005-12-06 10:00:00	IWM	ETF	68.7	68.74	68.51	68.73	3857500.0
2005-12-06 11:00:00	IWM	ETF	68.74	68.79	68.53	68.7	1807000.0
2005-12-06 12:00:00	IWM	ETF	68.7	69.0	68.66	68.92	5927700.0
2005-12-06 13:00:00	IWM	ETF	68.93	69.08	68.93	69.04	1944400.0
2005-12-06 14:00:00	IWM	ETF	69.05	69.05	68.9	68.98	1869800.0
2005-12-06 15:00:00	IWM	ETF	68.99	69.04	68.35	68.42	6632100.0
2005-12-06 16:00:00	IWM	ETF	68.42	68.7	68.4	68.52	610700.0
2005-12-06 17:00:00	IWM	ETF	68.49	68.49	68.48	68.48	700.0
2005-12-06 08:00:00	DIA	ETF	108.61	108.82	108.6	108.77	85000.0
2005-12-06 09:00:00	DIA	ETF	108.81	108.89	108.68	108.76	453800.0
2005-12-06 10:00:00	DIA	ETF	108.75	109.0	108.63	108.98	1003800.0
2005-12-06 11:00:00	DIA	ETF	108.97	109.01	108.74	108.96	478600.0
2005-12-06 12:00:00	DIA	ETF	108.98	109.28	108.95	109.11	530300.0
2005-12-06 13:00:00	DIA	ETF	109.13	109.24	109.11	109.21	453600.0
2005-12-06 14:00:00	DIA	ETF	109.22	109.25	109.11	109.17	629500.0
2005-12-06 15:00:00	DIA	ETF	109.17	109.21	108.48	108.6	1334000.0
2005-12-06 16:00:00	DIA	ETF	108.63	108.72	108.62	108.66	125400.0
2005-12-06 07:00:00	GLD	ETF	50.55	50.55	50.55	50.55	6000.0
2005-12-06 08:00:00	GLD	ETF	50.55	50.56	50.46	50.48	61100.0
2005-12-06 09:00:00	GLD	ETF	50.45	50.45	50.26	50.29	291300.0
2005-12-06 10:00:00	GLD	ETF	50.299	50.55	50.21	50.5	494200.0
2005-12-06 11:00:00	GLD	ETF	50.49	50.69	50.46	50.69	312200.0
2005-12-06 12:00:00	GLD	ETF	50.7	50.78	50.67	50.74	318400.0
2005-12-06 13:00:00	GLD	ETF	50.74	50.95	50.7	50.88	315700.0
2005-12-06 14:00:00	GLD	ETF	50.89	50.94	50.84	50.9	194400.0
2005-12-06 15:00:00	GLD	ETF	50.9	50.91	50.77	50.91	339100.0
2005-12-06 16:00:00	GLD	ETF	50.78	51.0	50.78	51.0	77700.0
2005-12-06 08:00:00	TLT	ETF	89.21	89.21	89.21	89.21	100.0

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

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