PREVIEW / etf_1hour / 2005-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-13.parquet
  size:    36 KB
  rows:    1,151

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-13 07:00:00	SPY	ETF	126.61	126.64	126.6	126.64	4400.0
2005-12-13 08:00:00	SPY	ETF	126.6	126.62	126.38	126.42	679900.0
2005-12-13 09:00:00	SPY	ETF	126.42	126.48	126.29	126.4	3695400.0
2005-12-13 10:00:00	SPY	ETF	126.4	126.61	126.39	126.52	5476200.0
2005-12-13 11:00:00	SPY	ETF	126.52	126.72	126.49	126.68	3225200.0
2005-12-13 12:00:00	SPY	ETF	126.68	126.69	126.505	126.58	2565500.0
2005-12-13 13:00:00	SPY	ETF	126.59	126.69	126.55	126.57	3894100.0
2005-12-13 14:00:00	SPY	ETF	126.57	127.7	126.53	127.57	41772100.0
2005-12-13 15:00:00	SPY	ETF	127.57	127.6	127.04	127.19	21784500.0
2005-12-13 16:00:00	SPY	ETF	127.18	127.4	127.14	127.4	3315100.0
2005-12-13 17:00:00	SPY	ETF	127.35	127.41	127.28	127.28	146500.0
2005-12-13 18:00:00	SPY	ETF	127.38	127.5	127.38	127.47	16500.0
2005-12-13 19:00:00	SPY	ETF	127.46	127.46	127.4	127.41	6600.0
2005-12-13 09:00:00	QQQ	ETF	41.83	41.86	41.76	41.81	6442000.0
2005-12-13 10:00:00	QQQ	ETF	41.81	41.89	41.78	41.82	5624800.0
2005-12-13 11:00:00	QQQ	ETF	41.82	41.88	41.81	41.86	3772500.0
2005-12-13 12:00:00	QQQ	ETF	41.86	41.88	41.81	41.82	1622700.0
2005-12-13 13:00:00	QQQ	ETF	41.82	41.93	41.82	41.85	3870600.0
2005-12-13 14:00:00	QQQ	ETF	41.85	42.21	41.84	42.17	31481800.0
2005-12-13 15:00:00	QQQ	ETF	42.17	42.18	41.97	42.04	15750100.0
2005-12-13 08:00:00	IWM	ETF	68.76	68.76	68.76	68.76	300.0
2005-12-13 09:00:00	IWM	ETF	68.68	68.74	68.52	68.59	1432900.0
2005-12-13 10:00:00	IWM	ETF	68.59	68.69	68.51	68.58	3997600.0
2005-12-13 11:00:00	IWM	ETF	68.58	68.7	68.57	68.65	2017400.0
2005-12-13 12:00:00	IWM	ETF	68.66	68.67	68.52	68.53	616800.0
2005-12-13 13:00:00	IWM	ETF	68.52	68.57	68.36	68.36	1758200.0
2005-12-13 14:00:00	IWM	ETF	68.35	69.03	68.31	68.97	8625800.0
2005-12-13 15:00:00	IWM	ETF	68.98	69.0	68.55	68.65	5725900.0
2005-12-13 16:00:00	IWM	ETF	68.66	68.86	68.64	68.79	222400.0
2005-12-13 17:00:00	IWM	ETF	68.82	68.96	68.82	68.96	1700.0
2005-12-13 08:00:00	DIA	ETF	107.91	107.91	107.8	107.8	107300.0
2005-12-13 09:00:00	DIA	ETF	107.8	107.83	107.58	107.65	455200.0
2005-12-13 10:00:00	DIA	ETF	107.67	107.85	107.67	107.76	435300.0
2005-12-13 11:00:00	DIA	ETF	107.75	107.87	107.7	107.83	503600.0
2005-12-13 12:00:00	DIA	ETF	107.83	107.91	107.8	107.8	332800.0
2005-12-13 13:00:00	DIA	ETF	107.81	107.91	107.8	107.84	180200.0
2005-12-13 14:00:00	DIA	ETF	107.83	108.79	107.78	108.7	3357400.0
2005-12-13 15:00:00	DIA	ETF	108.6905	108.71	108.18	108.25	2143200.0
2005-12-13 16:00:00	DIA	ETF	108.25	108.48	108.24	108.3	25700.0
2005-12-13 07:00:00	GLD	ETF	52.59	52.59	52.59	52.59	3000.0
2005-12-13 08:00:00	GLD	ETF	52.5	52.7	52.29	52.32	50200.0
2005-12-13 09:00:00	GLD	ETF	52.29	53.23	51.82	51.88	1528500.0
2005-12-13 10:00:00	GLD	ETF	51.84	52.16	51.76	52.11	1223300.0
2005-12-13 11:00:00	GLD	ETF	52.11	52.31	51.78	51.8	690500.0
2005-12-13 12:00:00	GLD	ETF	51.8	52.09	51.76	52.08	510100.0
2005-12-13 13:00:00	GLD	ETF	52.08	52.1	51.82	51.8501	375800.0
2005-12-13 14:00:00	GLD	ETF	51.85	52.01	51.8	51.81	471100.0
2005-12-13 15:00:00	GLD	ETF	51.82	51.86	51.56	51.67	1269900.0
2005-12-13 16:00:00	GLD	ETF	51.66	51.8375	51.61	51.61	37800.0
2005-12-13 09:00:00	TLT	ETF	89.7	89.75	89.67	89.68	32500.0

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

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