PREVIEW / etf_1hour / 2005-12-14

all etf 1-hour files

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

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-14 04:00:00	SPY	ETF	127.05	127.05	127.03	127.03	1900.0
2005-12-14 05:00:00	SPY	ETF	127.07	127.07	127.07	127.07	25000.0
2005-12-14 06:00:00	SPY	ETF	127.08	127.08	127.08	127.08	25000.0
2005-12-14 07:00:00	SPY	ETF	127.04	127.07	127.0	127.07	46800.0
2005-12-14 08:00:00	SPY	ETF	127.07	127.23	127.02	127.23	1060000.0
2005-12-14 09:00:00	SPY	ETF	127.23	127.65	127.14	127.54	13627900.0
2005-12-14 10:00:00	SPY	ETF	127.53	127.77	127.37	127.4	9126700.0
2005-12-14 11:00:00	SPY	ETF	127.4	127.54	127.21	127.38	9299800.0
2005-12-14 12:00:00	SPY	ETF	127.37	127.56	127.31	127.54	3030300.0
2005-12-14 13:00:00	SPY	ETF	127.53	128.09	127.48	127.97	10610400.0
2005-12-14 14:00:00	SPY	ETF	127.98	128.07	127.69	127.8	7824900.0
2005-12-14 15:00:00	SPY	ETF	127.78	127.92	127.71	127.76	6073600.0
2005-12-14 16:00:00	SPY	ETF	127.76	127.95	127.71	127.94	1485900.0
2005-12-14 17:00:00	SPY	ETF	127.94	127.95	127.83	127.83	108700.0
2005-12-14 18:00:00	SPY	ETF	127.82	127.83	127.81	127.81	2700.0
2005-12-14 19:00:00	SPY	ETF	127.81	127.82	127.81	127.81	1700.0
2005-12-14 09:00:00	QQQ	ETF	41.97	42.1	41.93	41.99	10274900.0
2005-12-14 10:00:00	QQQ	ETF	41.99	42.02	41.85	41.86	11265400.0
2005-12-14 11:00:00	QQQ	ETF	41.86	41.89	41.71	41.82	11096800.0
2005-12-14 12:00:00	QQQ	ETF	41.82	41.88	41.77	41.88	5730000.0
2005-12-14 13:00:00	QQQ	ETF	41.87	42.05	41.85	41.99	7642600.0
2005-12-14 14:00:00	QQQ	ETF	42.0	42.03	41.89	41.94	6488100.0
2005-12-14 15:00:00	QQQ	ETF	41.93	41.97	41.84	41.89	15256200.0
2005-12-14 08:00:00	IWM	ETF	68.72	68.8	68.64	68.8	92800.0
2005-12-14 09:00:00	IWM	ETF	68.8	68.98	68.71	68.9	2679900.0
2005-12-14 10:00:00	IWM	ETF	68.92	68.96	68.66	68.67	4750700.0
2005-12-14 11:00:00	IWM	ETF	68.66	68.7	68.42	68.59	3034000.0
2005-12-14 12:00:00	IWM	ETF	68.59	68.75	68.57	68.73	2004100.0
2005-12-14 13:00:00	IWM	ETF	68.73	69.16	68.72	69.07	2675900.0
2005-12-14 14:00:00	IWM	ETF	69.07	69.11	68.66	68.77	4300200.0
2005-12-14 15:00:00	IWM	ETF	68.77	68.85	68.65	68.75	3598300.0
2005-12-14 16:00:00	IWM	ETF	68.74	68.85	68.71	68.77	1708900.0
2005-12-14 17:00:00	IWM	ETF	68.78	68.78	68.78	68.78	1500000.0
2005-12-14 19:00:00	IWM	ETF	68.73	68.73	68.72	68.72	1400.0
2005-12-14 08:00:00	DIA	ETF	108.2	108.4	108.18	108.39	314900.0
2005-12-14 09:00:00	DIA	ETF	108.39	108.73	108.39	108.72	729900.0
2005-12-14 10:00:00	DIA	ETF	108.73	108.98	108.61	108.68	1809600.0
2005-12-14 11:00:00	DIA	ETF	108.67	108.8	108.54	108.67	1065600.0
2005-12-14 12:00:00	DIA	ETF	108.67	108.83	108.65	108.77	270600.0
2005-12-14 13:00:00	DIA	ETF	108.77	109.29	108.76	109.19	772800.0
2005-12-14 14:00:00	DIA	ETF	109.18	109.28	108.9	108.98	788000.0
2005-12-14 15:00:00	DIA	ETF	108.96	109.03	108.85	108.87	1209500.0
2005-12-14 16:00:00	DIA	ETF	108.88	109.01	108.87	109.0	60000.0
2005-12-14 18:00:00	DIA	ETF	109.0	109.0	109.0	109.0	1900.0
2005-12-14 07:00:00	GLD	ETF	51.15	51.15	50.96	51.0	18700.0
2005-12-14 08:00:00	GLD	ETF	51.09	51.18	50.95	51.0	101200.0
2005-12-14 09:00:00	GLD	ETF	51.06	51.11	50.86	51.02	1705300.0
2005-12-14 10:00:00	GLD	ETF	51.0	51.09	50.68	51.0	1089600.0
2005-12-14 11:00:00	GLD	ETF	51.01	51.2	50.91	51.05	705800.0
2005-12-14 12:00:00	GLD	ETF	51.07	51.07	50.52	50.65	923800.0

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

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