PREVIEW / etf_1hour / 2006-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-03.parquet
  size:    50 KB
  rows:    1,551

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-08-03 04:00:00	SPY	ETF	127.74	127.74	127.74	127.74	1200.0
2006-08-03 05:00:00	SPY	ETF	127.75	127.75	127.75	127.75	100.0
2006-08-03 07:00:00	SPY	ETF	127.66	127.66	127.44	127.57	183600.0
2006-08-03 08:00:00	SPY	ETF	127.58	127.69	127.23	127.38	2177900.0
2006-08-03 09:00:00	SPY	ETF	127.38	127.51	127.15	127.44	8549400.0
2006-08-03 10:00:00	SPY	ETF	127.4495	127.83	127.36	127.81	10988100.0
2006-08-03 11:00:00	SPY	ETF	127.81	127.94	127.46	127.55	6227100.0
2006-08-03 12:00:00	SPY	ETF	127.55	127.86	127.55	127.8005	2995100.0
2006-08-03 13:00:00	SPY	ETF	127.81	128.42	127.81	128.31	11225600.0
2006-08-03 14:00:00	SPY	ETF	128.32	128.55	128.2	128.44	8317500.0
2006-08-03 15:00:00	SPY	ETF	128.42	128.5	128.04	128.11	10367900.0
2006-08-03 16:00:00	SPY	ETF	128.11	128.45	128.1	128.35	773500.0
2006-08-03 17:00:00	SPY	ETF	128.34	128.37	128.32	128.37	17000.0
2006-08-03 18:00:00	SPY	ETF	128.35	128.38	128.34	128.34	39600.0
2006-08-03 19:00:00	SPY	ETF	128.33	128.33	128.33	128.33	600.0
2006-08-03 09:00:00	QQQ	ETF	36.54	36.67	36.48	36.64	11943100.0
2006-08-03 10:00:00	QQQ	ETF	36.64	36.86	36.6	36.84	14135600.0
2006-08-03 11:00:00	QQQ	ETF	36.85	36.92	36.71	36.73	9417000.0
2006-08-03 12:00:00	QQQ	ETF	36.73	36.9	36.72	36.89	6178700.0
2006-08-03 13:00:00	QQQ	ETF	36.89	37.27	36.89	37.24	18349800.0
2006-08-03 14:00:00	QQQ	ETF	37.24	37.34	37.16	37.29	12901600.0
2006-08-03 15:00:00	QQQ	ETF	37.29	37.32	37.07	37.1	16435300.0
2006-08-03 07:00:00	IWM	ETF	69.1	69.1	69.1	69.1	100.0
2006-08-03 08:00:00	IWM	ETF	69.0	69.5	68.76	68.86	740100.0
2006-08-03 09:00:00	IWM	ETF	68.86	68.87	68.54	68.63	4883800.0
2006-08-03 10:00:00	IWM	ETF	68.64	69.13	68.57	69.12	7092100.0
2006-08-03 11:00:00	IWM	ETF	69.12	69.21	68.84	68.93	3741600.0
2006-08-03 12:00:00	IWM	ETF	68.92	69.28	68.91	69.24	2469300.0
2006-08-03 13:00:00	IWM	ETF	69.25	70.05	69.25	70.01	11779100.0
2006-08-03 14:00:00	IWM	ETF	70.02	70.28	69.94	70.25	7396800.0
2006-08-03 15:00:00	IWM	ETF	70.25	70.31	69.85	70.08	9762200.0
2006-08-03 16:00:00	IWM	ETF	70.07	70.33	70.05	70.26	846500.0
2006-08-03 17:00:00	IWM	ETF	70.25	70.26	70.2	70.2	23800.0
2006-08-03 18:00:00	IWM	ETF	70.2	70.2	70.2	70.2	100.0
2006-08-03 19:00:00	IWM	ETF	70.27	70.27	70.2	70.2	1000.0
2006-08-03 07:00:00	DIA	ETF	111.68	111.75	111.68	111.7	1500.0
2006-08-03 08:00:00	DIA	ETF	111.67	111.7	111.4	111.51	8100.0
2006-08-03 09:00:00	DIA	ETF	111.5	111.72	111.27	111.69	590700.0
2006-08-03 10:00:00	DIA	ETF	111.68	112.06	111.59	112.06	1262600.0
2006-08-03 11:00:00	DIA	ETF	112.07	112.18	111.82	111.9	728300.0
2006-08-03 12:00:00	DIA	ETF	111.9	112.16	111.89	112.13	665500.0
2006-08-03 13:00:00	DIA	ETF	112.13	112.64	112.13	112.56	1174400.0
2006-08-03 14:00:00	DIA	ETF	112.56	112.66	112.42	112.59	504400.0
2006-08-03 15:00:00	DIA	ETF	112.58	112.62	112.33	112.39	793400.0
2006-08-03 16:00:00	DIA	ETF	112.39	112.62	112.39	112.58	15400.0
2006-08-03 17:00:00	DIA	ETF	112.61	112.61	112.61	112.61	300.0
2006-08-03 08:00:00	GLD	ETF	64.25	64.55	64.12	64.19	123400.0
2006-08-03 09:00:00	GLD	ETF	64.17	64.21	63.87	64.0	653300.0
2006-08-03 10:00:00	GLD	ETF	64.01	64.31	63.92	64.12	797500.0
2006-08-03 11:00:00	GLD	ETF	64.11	64.17	63.57	63.62	576600.0

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

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