PREVIEW / etf_1hour / 2006-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-26.parquet
  size:    43 KB
  rows:    1,343

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-05-26 06:00:00	SPY	ETF	127.64	127.64	127.59	127.6	5300.0
2006-05-26 07:00:00	SPY	ETF	127.62	127.62	127.53	127.57	304100.0
2006-05-26 08:00:00	SPY	ETF	127.58	128.25	127.45	128.04	6896800.0
2006-05-26 09:00:00	SPY	ETF	128.06	128.19	127.78	127.89	7475100.0
2006-05-26 10:00:00	SPY	ETF	127.89	128.03	127.51	127.81	12354300.0
2006-05-26 11:00:00	SPY	ETF	127.8	128.25	127.76	128.11	9959500.0
2006-05-26 12:00:00	SPY	ETF	128.09	128.17	127.93	128.07	3960400.0
2006-05-26 13:00:00	SPY	ETF	128.06	128.17	128.0	128.16	6639800.0
2006-05-26 14:00:00	SPY	ETF	128.16	128.36	128.11	128.12	4965400.0
2006-05-26 15:00:00	SPY	ETF	128.12	128.37	128.08	128.3	6448900.0
2006-05-26 16:00:00	SPY	ETF	128.3	128.44	128.25	128.4	1906300.0
2006-05-26 17:00:00	SPY	ETF	128.38	128.4	128.32	128.4	8900.0
2006-05-26 18:00:00	SPY	ETF	128.4	128.43	128.35	128.42	2100.0
2006-05-26 09:00:00	QQQ	ETF	39.45	39.47	39.28	39.39	18069500.0
2006-05-26 10:00:00	QQQ	ETF	39.39	39.49	39.23	39.36	18802400.0
2006-05-26 11:00:00	QQQ	ETF	39.35	39.5	39.33	39.46	10775100.0
2006-05-26 12:00:00	QQQ	ETF	39.46	39.47	39.35	39.43	6257700.0
2006-05-26 13:00:00	QQQ	ETF	39.43	39.44	38.39	39.43	5119800.0
2006-05-26 14:00:00	QQQ	ETF	39.44	39.58	39.37	39.4	9323200.0
2006-05-26 15:00:00	QQQ	ETF	39.4	39.51	39.38	39.5	9787000.0
2006-05-26 07:00:00	IWM	ETF	71.9	71.9	71.9	71.9	200.0
2006-05-26 08:00:00	IWM	ETF	72.2	72.75	72.16	72.55	1965300.0
2006-05-26 09:00:00	IWM	ETF	72.53	72.7	72.34	72.47	7295700.0
2006-05-26 10:00:00	IWM	ETF	72.47	72.58	72.02	72.24	8886400.0
2006-05-26 11:00:00	IWM	ETF	72.25	72.72	72.2	72.54	5456000.0
2006-05-26 12:00:00	IWM	ETF	72.54	72.56	72.25	72.44	1795600.0
2006-05-26 13:00:00	IWM	ETF	72.43	72.73	72.39	72.58	2634700.0
2006-05-26 14:00:00	IWM	ETF	72.57	72.64	72.32	72.34	3594800.0
2006-05-26 15:00:00	IWM	ETF	72.34	72.58	72.31	72.54	4334200.0
2006-05-26 16:00:00	IWM	ETF	72.51	72.7	72.39	72.6	486200.0
2006-05-26 17:00:00	IWM	ETF	72.6	72.6	72.6	72.6	1400.0
2006-05-26 07:00:00	DIA	ETF	112.0	112.0	112.0	112.0	500.0
2006-05-26 08:00:00	DIA	ETF	112.15	112.48	112.04	112.35	31200.0
2006-05-26 09:00:00	DIA	ETF	112.32	112.52	111.65	112.25	971200.0
2006-05-26 10:00:00	DIA	ETF	112.24	112.43	112.12	112.32	1039000.0
2006-05-26 11:00:00	DIA	ETF	112.32	112.68	112.29	112.59	770700.0
2006-05-26 12:00:00	DIA	ETF	112.59	112.61	112.45	112.52	503700.0
2006-05-26 13:00:00	DIA	ETF	112.52	112.61	112.44	112.55	484800.0
2006-05-26 14:00:00	DIA	ETF	112.54	112.7	112.51	112.54	528300.0
2006-05-26 15:00:00	DIA	ETF	112.53	112.78	112.52	112.71	873600.0
2006-05-26 16:00:00	DIA	ETF	112.68	112.89	112.68	112.82	28900.0
2006-05-26 17:00:00	DIA	ETF	112.83	112.9	112.83	112.9	2700.0
2006-05-26 07:00:00	GLD	ETF	64.9	64.9	64.9	64.9	400.0
2006-05-26 08:00:00	GLD	ETF	64.94	65.16	64.46	64.99	149500.0
2006-05-26 09:00:00	GLD	ETF	64.88	65.04	63.96	64.11	1118300.0
2006-05-26 10:00:00	GLD	ETF	64.1	64.29	63.75	64.11	1313500.0
2006-05-26 11:00:00	GLD	ETF	64.12	65.04	64.1	64.996	1049200.0
2006-05-26 12:00:00	GLD	ETF	64.98	65.0	64.75	64.83	577000.0
2006-05-26 13:00:00	GLD	ETF	64.83	64.95	64.8	64.9048	513800.0
2006-05-26 14:00:00	GLD	ETF	64.9048	65.08	64.86	65.03	215000.0

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

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