PREVIEW / etf_1hour / 2006-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-05.parquet
  size:    53 KB
  rows:    1,687

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
2006-10-05 06:00:00	SPY	ETF	134.99	134.99	134.89	134.89	56000.0
2006-10-05 07:00:00	SPY	ETF	134.89	134.94	134.86	134.87	245400.0
2006-10-05 08:00:00	SPY	ETF	134.86	134.96	134.81	134.95	2955600.0
2006-10-05 09:00:00	SPY	ETF	134.94	135.1	134.85	135.05	10275400.0
2006-10-05 10:00:00	SPY	ETF	135.05	135.14	134.77	135.0	8637000.0
2006-10-05 11:00:00	SPY	ETF	135.01	135.19	134.85	135.01	7325700.0
2006-10-05 12:00:00	SPY	ETF	135.01	135.07	134.75	134.91	5694800.0
2006-10-05 13:00:00	SPY	ETF	134.91	135.15	134.89	135.0	4803600.0
2006-10-05 14:00:00	SPY	ETF	135.0	135.18	134.94	135.15	3043300.0
2006-10-05 15:00:00	SPY	ETF	135.14	135.41	135.1	135.3	13389300.0
2006-10-05 16:00:00	SPY	ETF	135.3	135.3	135.17	135.24	1577000.0
2006-10-05 17:00:00	SPY	ETF	135.24	135.29	135.2	135.29	187200.0
2006-10-05 18:00:00	SPY	ETF	135.24	135.24	135.17	135.17	90300.0
2006-10-05 19:00:00	SPY	ETF	135.18	135.18	135.18	135.18	2900.0
2006-10-05 09:00:00	QQQ	ETF	41.29	41.4	41.2	41.37	12566400.0
2006-10-05 10:00:00	QQQ	ETF	41.38	41.42	41.18	41.39	18201700.0
2006-10-05 11:00:00	QQQ	ETF	41.38	41.49	41.28	41.39	10466200.0
2006-10-05 12:00:00	QQQ	ETF	41.39	41.41	41.22	41.32	6755300.0
2006-10-05 13:00:00	QQQ	ETF	41.32	41.48	41.31	41.4	11752000.0
2006-10-05 14:00:00	QQQ	ETF	41.4	41.47	41.34	41.45	6906800.0
2006-10-05 15:00:00	QQQ	ETF	41.45	41.56	41.4	41.49	15748700.0
2006-10-05 08:00:00	IWM	ETF	72.9	72.95	72.82	72.9	86400.0
2006-10-05 09:00:00	IWM	ETF	72.89	73.39	72.82	73.33	6326600.0
2006-10-05 10:00:00	IWM	ETF	73.33	73.39	72.93	73.15	7552800.0
2006-10-05 11:00:00	IWM	ETF	73.14	73.36	73.01	73.2	4254500.0
2006-10-05 12:00:00	IWM	ETF	73.21	73.25	72.97	73.1	3300400.0
2006-10-05 13:00:00	IWM	ETF	73.11	73.52	73.07	73.39	5615600.0
2006-10-05 14:00:00	IWM	ETF	73.38	73.58	73.29	73.5599	3845600.0
2006-10-05 15:00:00	IWM	ETF	73.55	73.9	73.41	73.82	15197600.0
2006-10-05 16:00:00	IWM	ETF	73.81	73.9	73.75	73.85	1017700.0
2006-10-05 17:00:00	IWM	ETF	73.89	73.9	73.84	73.84	5000.0
2006-10-05 18:00:00	IWM	ETF	73.84	73.86	73.84	73.86	10000.0
2006-10-05 07:00:00	DIA	ETF	118.31	118.4	118.31	118.32	8000.0
2006-10-05 08:00:00	DIA	ETF	118.38	118.4	118.29	118.4	176600.0
2006-10-05 09:00:00	DIA	ETF	118.39	118.59	118.28	118.56	767300.0
2006-10-05 10:00:00	DIA	ETF	118.55	118.61	118.24	118.422	1570600.0
2006-10-05 11:00:00	DIA	ETF	118.42	118.54	118.28	118.42	781600.0
2006-10-05 12:00:00	DIA	ETF	118.42	118.47	118.2	118.32	893300.0
2006-10-05 13:00:00	DIA	ETF	118.32	118.56	118.32	118.38	1084400.0
2006-10-05 14:00:00	DIA	ETF	118.39	118.57	118.36	118.54	641500.0
2006-10-05 15:00:00	DIA	ETF	118.54	118.71	118.47	118.66	1089000.0
2006-10-05 16:00:00	DIA	ETF	118.66	118.69	118.54	118.61	111400.0
2006-10-05 17:00:00	DIA	ETF	118.6	118.6	118.6	118.6	500.0
2006-10-05 07:00:00	GLD	ETF	57.0	57.0	56.85	56.85	6000.0
2006-10-05 08:00:00	GLD	ETF	56.81	56.94	56.45	56.94	111300.0
2006-10-05 09:00:00	GLD	ETF	56.98	57.02	56.68	56.97	1175400.0
2006-10-05 10:00:00	GLD	ETF	56.96	57.02	56.52	56.6201	700300.0
2006-10-05 11:00:00	GLD	ETF	56.62	56.7	56.32	56.65	544900.0
2006-10-05 12:00:00	GLD	ETF	56.63	56.8	56.55	56.6	390100.0
2006-10-05 13:00:00	GLD	ETF	56.59	56.81	56.49	56.78	383300.0

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

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