PREVIEW / etf_1hour / 2005-12-30

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-30.parquet
  size:    38 KB
  rows:    1,190

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-30 04:00:00	SPY	ETF	125.16	125.16	125.09	125.09	600.0
2005-12-30 05:00:00	SPY	ETF	124.69	124.84	124.66	124.84	21200.0
2005-12-30 07:00:00	SPY	ETF	124.83	124.98	124.83	124.97	53400.0
2005-12-30 08:00:00	SPY	ETF	124.98	124.99	124.82	124.86	617100.0
2005-12-30 09:00:00	SPY	ETF	124.87	125.0	124.67	124.87	5909700.0
2005-12-30 10:00:00	SPY	ETF	124.86	124.88	124.54	124.67	6237300.0
2005-12-30 11:00:00	SPY	ETF	124.65	124.74	124.56	124.68	2722900.0
2005-12-30 12:00:00	SPY	ETF	124.68	124.69	124.54	124.59	2665100.0
2005-12-30 13:00:00	SPY	ETF	124.59	124.73	124.5	124.68	3924700.0
2005-12-30 14:00:00	SPY	ETF	124.68	124.91	124.64	124.81	5862500.0
2005-12-30 15:00:00	SPY	ETF	124.815	125.06	124.55	124.56	10979100.0
2005-12-30 16:00:00	SPY	ETF	124.55	124.98	124.37	124.42	3943300.0
2005-12-30 17:00:00	SPY	ETF	124.46	124.52	124.45	124.52	9300.0
2005-12-30 18:00:00	SPY	ETF	124.52	124.52	124.52	124.52	500.0
2005-12-30 19:00:00	SPY	ETF	124.52	124.52	124.52	124.52	400.0
2005-12-30 09:00:00	QQQ	ETF	40.54	40.57	40.5	40.54	9072800.0
2005-12-30 10:00:00	QQQ	ETF	40.55	40.55	40.36	40.41	10996600.0
2005-12-30 11:00:00	QQQ	ETF	40.42	40.5	40.39	40.47	5362000.0
2005-12-30 12:00:00	QQQ	ETF	40.48	40.5	40.41	40.43	4464600.0
2005-12-30 13:00:00	QQQ	ETF	40.43	40.57	40.41	40.53	7277200.0
2005-12-30 14:00:00	QQQ	ETF	40.53	40.58	40.46	40.53	5629800.0
2005-12-30 15:00:00	QQQ	ETF	40.54	40.57	40.41	40.42	13637200.0
2005-12-30 07:00:00	IWM	ETF	66.99	66.99	66.99	66.99	500.0
2005-12-30 08:00:00	IWM	ETF	67.02	67.02	66.79	66.82	44000.0
2005-12-30 09:00:00	IWM	ETF	66.79	66.85	66.46	66.76	4056200.0
2005-12-30 10:00:00	IWM	ETF	66.75	66.76	66.54	66.61	3912600.0
2005-12-30 11:00:00	IWM	ETF	66.6	66.78	66.59	66.71	2088900.0
2005-12-30 12:00:00	IWM	ETF	66.7	66.82	66.69	66.72	1715200.0
2005-12-30 13:00:00	IWM	ETF	66.72	66.95	66.68	66.87	2485400.0
2005-12-30 14:00:00	IWM	ETF	66.87	66.99	66.77	66.86	1758000.0
2005-12-30 15:00:00	IWM	ETF	66.87	66.99	66.66	66.66	9288400.0
2005-12-30 16:00:00	IWM	ETF	66.67	66.87	66.59	66.69	346500.0
2005-12-30 17:00:00	IWM	ETF	66.71	66.87	66.69	66.87	5867200.0
2005-12-30 18:00:00	IWM	ETF	66.69	66.7	66.69	66.7	1800.0
2005-12-30 07:00:00	DIA	ETF	107.41	107.41	107.41	107.41	300.0
2005-12-30 08:00:00	DIA	ETF	107.56	107.58	107.43	107.43	11200.0
2005-12-30 09:00:00	DIA	ETF	107.4	107.58	107.3	107.45	661100.0
2005-12-30 10:00:00	DIA	ETF	107.46	107.46	107.15	107.27	563100.0
2005-12-30 11:00:00	DIA	ETF	107.27	107.29	107.11	107.17	323500.0
2005-12-30 12:00:00	DIA	ETF	107.16	107.24	107.07	107.0901	352300.0
2005-12-30 13:00:00	DIA	ETF	107.09	107.18	106.96	107.16	461600.0
2005-12-30 14:00:00	DIA	ETF	107.17	107.3	107.08	107.16	672000.0
2005-12-30 15:00:00	DIA	ETF	107.16	107.38	107.0	107.01	1882600.0
2005-12-30 16:00:00	DIA	ETF	107.0	107.08	106.79	106.85	60700.0
2005-12-30 17:00:00	DIA	ETF	106.85	106.9	106.85	106.9	3600.0
2005-12-30 18:00:00	DIA	ETF	106.97	106.97	106.97	106.97	100.0
2005-12-30 19:00:00	DIA	ETF	106.92	106.92	106.9	106.9	1100.0
2005-12-30 08:00:00	GLD	ETF	51.23	51.24	51.18	51.21	2800.0
2005-12-30 09:00:00	GLD	ETF	51.17	51.43	51.17	51.42	457900.0
2005-12-30 10:00:00	GLD	ETF	51.42	51.55	51.39	51.491	738300.0

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

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