PREVIEW / etf_1hour / 2005-11-23

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-23.parquet
  size:    35 KB
  rows:    1,058

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-11-23 07:00:00	SPY	ETF	126.35	126.4	126.35	126.4	3800.0
2005-11-23 08:00:00	SPY	ETF	126.42	126.43	126.28	126.3	1067400.0
2005-11-23 09:00:00	SPY	ETF	126.3	126.51	126.21	126.49	4246700.0
2005-11-23 10:00:00	SPY	ETF	126.48	126.67	126.4	126.6	6354000.0
2005-11-23 11:00:00	SPY	ETF	126.61	126.93	126.52	126.87	6502900.0
2005-11-23 12:00:00	SPY	ETF	126.89	127.24	126.81	127.11	8733700.0
2005-11-23 13:00:00	SPY	ETF	127.11	127.22	127.05	127.16	4868200.0
2005-11-23 14:00:00	SPY	ETF	127.16	127.41	127.15	127.17	6446800.0
2005-11-23 15:00:00	SPY	ETF	127.17	127.31	126.8	126.88	8670400.0
2005-11-23 16:00:00	SPY	ETF	126.86	127.03	126.83	126.9	545400.0
2005-11-23 17:00:00	SPY	ETF	126.89	126.94	126.89	126.93	900.0
2005-11-23 18:00:00	SPY	ETF	126.93	126.94	126.91	126.93	2400.0
2005-11-23 19:00:00	SPY	ETF	126.93	126.95	126.93	126.95	2100.0
2005-11-23 09:00:00	QQQ	ETF	41.72	41.84	41.71	41.79	8224000.0
2005-11-23 10:00:00	QQQ	ETF	41.8	41.87	41.78	41.85	7577300.0
2005-11-23 11:00:00	QQQ	ETF	41.85	41.89	41.81	41.85	4967300.0
2005-11-23 12:00:00	QQQ	ETF	41.86	41.97	41.83	41.94	5656700.0
2005-11-23 13:00:00	QQQ	ETF	41.94	41.95	41.9	41.94	2813400.0
2005-11-23 14:00:00	QQQ	ETF	41.93	42.02	41.89	41.9	10961000.0
2005-11-23 15:00:00	QQQ	ETF	41.9	41.9	41.73	41.81	17206900.0
2005-11-23 09:00:00	IWM	ETF	67.87	68.04	67.7699	67.95	3923700.0
2005-11-23 10:00:00	IWM	ETF	67.96	68.06	67.8	68.04	3569500.0
2005-11-23 11:00:00	IWM	ETF	68.05	68.15	67.95	68.1	2484600.0
2005-11-23 12:00:00	IWM	ETF	68.1099	68.22	68.0	68.18	1137800.0
2005-11-23 13:00:00	IWM	ETF	68.18	68.23	68.14	68.19	1345100.0
2005-11-23 14:00:00	IWM	ETF	68.2	68.35	68.11	68.11	3368700.0
2005-11-23 15:00:00	IWM	ETF	68.11	68.11	67.84	67.97	4615700.0
2005-11-23 16:00:00	IWM	ETF	67.98	68.5	67.89	67.94	584500.0
2005-11-23 08:00:00	DIA	ETF	108.62	108.62	108.56	108.56	1900.0
2005-11-23 09:00:00	DIA	ETF	108.52	108.74	108.42	108.74	430600.0
2005-11-23 10:00:00	DIA	ETF	108.74	108.99	108.42	108.9188	913200.0
2005-11-23 11:00:00	DIA	ETF	108.92	109.16	108.85	109.12	772800.0
2005-11-23 12:00:00	DIA	ETF	109.12	109.28	109.05	109.23	842600.0
2005-11-23 13:00:00	DIA	ETF	109.22	109.34	109.18	109.29	273300.0
2005-11-23 14:00:00	DIA	ETF	109.3	109.46	109.3	109.35	994700.0
2005-11-23 15:00:00	DIA	ETF	109.33	109.33	109.03	109.1	948300.0
2005-11-23 16:00:00	DIA	ETF	109.09	109.2	109.06	109.16	161700.0
2005-11-23 17:00:00	DIA	ETF	109.14	109.14	109.14	109.14	500.0
2005-11-23 19:00:00	DIA	ETF	109.13	109.13	109.13	109.13	900.0
2005-11-23 07:00:00	GLD	ETF	48.76	48.76	48.76	48.76	100.0
2005-11-23 08:00:00	GLD	ETF	48.73	48.92	48.73	48.75	13000.0
2005-11-23 09:00:00	GLD	ETF	48.74	48.83	47.92	48.66	472400.0
2005-11-23 10:00:00	GLD	ETF	48.67	48.89	48.6	48.83	359600.0
2005-11-23 11:00:00	GLD	ETF	48.83	48.97	48.81	48.85	144000.0
2005-11-23 12:00:00	GLD	ETF	48.85	48.94	48.81	48.94	175500.0
2005-11-23 13:00:00	GLD	ETF	48.94	49.1	48.94	49.1	205800.0
2005-11-23 14:00:00	GLD	ETF	49.09	49.25	49.08	49.22	142600.0
2005-11-23 15:00:00	GLD	ETF	49.23	49.24	49.15	49.19	210400.0
2005-11-23 08:00:00	TLT	ETF	90.53	90.53	90.53	90.53	300.0
2005-11-23 09:00:00	TLT	ETF	90.59	90.69	90.5301	90.5301	89100.0

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

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