PREVIEW / etf_1hour / 2005-12-05

all etf 1-hour files

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

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-05 05:00:00	SPY	ETF	126.78	126.78	126.78	126.78	2400.0
2005-12-05 06:00:00	SPY	ETF	126.77	126.78	126.77	126.78	25000.0
2005-12-05 07:00:00	SPY	ETF	126.78	126.8	126.75	126.8	26600.0
2005-12-05 08:00:00	SPY	ETF	126.79	126.85	126.69	126.72	871100.0
2005-12-05 09:00:00	SPY	ETF	126.7	126.73	126.54	126.63	5461800.0
2005-12-05 10:00:00	SPY	ETF	126.64	126.66	126.18	126.23	11732600.0
2005-12-05 11:00:00	SPY	ETF	126.23	126.55	126.21	126.41	5836700.0
2005-12-05 12:00:00	SPY	ETF	126.43	126.69	126.33	126.62	5170500.0
2005-12-05 13:00:00	SPY	ETF	126.61	126.68	126.43	126.49	4559900.0
2005-12-05 14:00:00	SPY	ETF	126.49	126.66	126.34	126.57	7366800.0
2005-12-05 15:00:00	SPY	ETF	126.57	126.66	126.41	126.63	9584300.0
2005-12-05 16:00:00	SPY	ETF	126.64	126.73	126.58	126.63	2874900.0
2005-12-05 17:00:00	SPY	ETF	126.62	126.64	126.55	126.6	98400.0
2005-12-05 18:00:00	SPY	ETF	126.6	126.62	126.6	126.6	18200.0
2005-12-05 19:00:00	SPY	ETF	126.62	126.62	126.62	126.62	1000.0
2005-12-05 09:00:00	QQQ	ETF	42.05	42.06	41.95	42.0	5646800.0
2005-12-05 10:00:00	QQQ	ETF	42.0	42.01	41.63	41.66	17744700.0
2005-12-05 11:00:00	QQQ	ETF	41.66	41.78	41.65	41.75	7294400.0
2005-12-05 12:00:00	QQQ	ETF	41.74	41.84	41.69	41.81	4802000.0
2005-12-05 13:00:00	QQQ	ETF	41.81	41.83	41.7	41.73	4529000.0
2005-12-05 14:00:00	QQQ	ETF	41.72	41.81	41.66	41.8	7287300.0
2005-12-05 15:00:00	QQQ	ETF	41.8	41.81	41.7	41.79	8196100.0
2005-12-05 07:00:00	IWM	ETF	68.86	68.86	68.86	68.86	5000.0
2005-12-05 08:00:00	IWM	ETF	68.87	68.87	68.78	68.78	46000.0
2005-12-05 09:00:00	IWM	ETF	68.75	68.76	68.3401	68.44	6008500.0
2005-12-05 10:00:00	IWM	ETF	68.44	68.45	67.93	67.95	5328000.0
2005-12-05 11:00:00	IWM	ETF	67.94	68.2	67.92	68.12	2052100.0
2005-12-05 12:00:00	IWM	ETF	68.12	68.35	68.06	68.29	1060500.0
2005-12-05 13:00:00	IWM	ETF	68.28	68.36	68.23	68.28	1275300.0
2005-12-05 14:00:00	IWM	ETF	68.28	68.3	68.1	68.25	2205900.0
2005-12-05 15:00:00	IWM	ETF	68.24	68.52	68.15	68.38	2430400.0
2005-12-05 16:00:00	IWM	ETF	68.39	68.4	68.25	68.35	117200.0
2005-12-05 17:00:00	IWM	ETF	68.38	68.38	68.38	68.38	3250000.0
2005-12-05 08:00:00	DIA	ETF	108.74	108.79	108.74	108.79	15400.0
2005-12-05 09:00:00	DIA	ETF	108.65	108.76	108.52	108.58	234900.0
2005-12-05 10:00:00	DIA	ETF	108.6	108.6	108.15	108.19	1240200.0
2005-12-05 11:00:00	DIA	ETF	108.19	108.45	108.15	108.37	300600.0
2005-12-05 12:00:00	DIA	ETF	108.36	108.54	108.26	108.5	471500.0
2005-12-05 13:00:00	DIA	ETF	108.49	108.49	108.25	108.28	312900.0
2005-12-05 14:00:00	DIA	ETF	108.29	108.4	108.14	108.35	687000.0
2005-12-05 15:00:00	DIA	ETF	108.35	108.43	108.25	108.4	918100.0
2005-12-05 16:00:00	DIA	ETF	108.4	108.47	108.38	108.46	108500.0
2005-12-05 17:00:00	DIA	ETF	108.49	108.49	108.49	108.49	100.0
2005-12-05 07:00:00	GLD	ETF	50.48	50.48	50.48	50.48	400.0
2005-12-05 08:00:00	GLD	ETF	50.45	50.47	50.22	50.31	25800.0
2005-12-05 09:00:00	GLD	ETF	50.31	50.49	50.31	50.38	260200.0
2005-12-05 10:00:00	GLD	ETF	50.39	50.45	50.29	50.35	410400.0
2005-12-05 11:00:00	GLD	ETF	50.35	50.5	50.33	50.49	208000.0
2005-12-05 12:00:00	GLD	ETF	50.5	50.61	50.48	50.57	313700.0
2005-12-05 13:00:00	GLD	ETF	50.58	50.73	50.57	50.71	145900.0

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

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