PREVIEW / etf_1hour / 2006-09-08

all etf 1-hour files

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

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-09-08 04:00:00	SPY	ETF	130.29	130.29	130.29	130.29	100.0
2006-09-08 07:00:00	SPY	ETF	130.07	130.24	130.07	130.24	121000.0
2006-09-08 08:00:00	SPY	ETF	130.22	130.22	130.09	130.2	3159600.0
2006-09-08 09:00:00	SPY	ETF	130.2	130.2	129.98	130.06	5209200.0
2006-09-08 10:00:00	SPY	ETF	130.06	130.12	129.83	130.11	6020100.0
2006-09-08 11:00:00	SPY	ETF	130.11	130.17	130.01	130.04	5103600.0
2006-09-08 12:00:00	SPY	ETF	130.02	130.12	129.91	130.1	2785600.0
2006-09-08 13:00:00	SPY	ETF	130.11	130.43	130.02	130.41	5305000.0
2006-09-08 14:00:00	SPY	ETF	130.41	130.46	130.22	130.34	6060300.0
2006-09-08 15:00:00	SPY	ETF	130.33	130.42	130.15	130.3	7793100.0
2006-09-08 16:00:00	SPY	ETF	130.31	130.33	130.1	130.2	2352200.0
2006-09-08 17:00:00	SPY	ETF	130.19	130.22	130.15	130.22	1700.0
2006-09-08 18:00:00	SPY	ETF	130.23	130.25	130.2	130.2	11400.0
2006-09-08 09:00:00	QQQ	ETF	38.54	38.63	38.46	38.59	9832800.0
2006-09-08 10:00:00	QQQ	ETF	38.58	38.65	38.47	38.65	14275000.0
2006-09-08 11:00:00	QQQ	ETF	38.65	38.69	38.56	38.59	10183800.0
2006-09-08 12:00:00	QQQ	ETF	38.59	38.64	38.52	38.64	5970800.0
2006-09-08 13:00:00	QQQ	ETF	38.64	38.79	38.59	38.79	10568200.0
2006-09-08 14:00:00	QQQ	ETF	38.79	38.82	38.64	38.74	9632600.0
2006-09-08 15:00:00	QQQ	ETF	38.74	38.82	38.65	38.72	20766900.0
2006-09-08 07:00:00	IWM	ETF	70.48	70.55	70.48	70.55	31000.0
2006-09-08 08:00:00	IWM	ETF	70.5	70.6	70.47	70.53	95900.0
2006-09-08 09:00:00	IWM	ETF	70.5	70.63	70.21	70.35	3441000.0
2006-09-08 10:00:00	IWM	ETF	70.35	70.49	70.17	70.48	4542400.0
2006-09-08 11:00:00	IWM	ETF	70.48	70.5	70.3	70.35	1632400.0
2006-09-08 12:00:00	IWM	ETF	70.35	70.49	70.26	70.47	3328000.0
2006-09-08 13:00:00	IWM	ETF	70.47	70.64	70.38	70.63	2327200.0
2006-09-08 14:00:00	IWM	ETF	70.64	70.68	70.45	70.51	2588200.0
2006-09-08 15:00:00	IWM	ETF	70.51	70.64	70.38	70.53	3632800.0
2006-09-08 16:00:00	IWM	ETF	70.54	70.79	70.35	70.5	1172100.0
2006-09-08 17:00:00	IWM	ETF	70.48	70.48	70.48	70.48	600.0
2006-09-08 07:00:00	DIA	ETF	113.66	113.7	113.66	113.7	13800.0
2006-09-08 08:00:00	DIA	ETF	113.68	113.7	113.62	113.63	61800.0
2006-09-08 09:00:00	DIA	ETF	113.66	113.74	113.52	113.61	386900.0
2006-09-08 10:00:00	DIA	ETF	113.62	113.71	113.49	113.71	423100.0
2006-09-08 11:00:00	DIA	ETF	113.71	113.75	113.61	113.67	228300.0
2006-09-08 12:00:00	DIA	ETF	113.68	113.75	113.61	113.74	144600.0
2006-09-08 13:00:00	DIA	ETF	113.74	114.03	113.7	114.03	374400.0
2006-09-08 14:00:00	DIA	ETF	114.03	114.05	113.82	113.91	655900.0
2006-09-08 15:00:00	DIA	ETF	113.91	114.04	113.81	113.91	801100.0
2006-09-08 16:00:00	DIA	ETF	113.94	113.94	113.79	113.9	74400.0
2006-09-08 19:00:00	DIA	ETF	113.9	113.9	113.9	113.9	400.0
2006-09-08 08:00:00	GLD	ETF	61.09	61.12	60.3	60.34	230100.0
2006-09-08 09:00:00	GLD	ETF	60.35	60.62	60.24	60.44	1004900.0
2006-09-08 10:00:00	GLD	ETF	60.45	60.66	60.28	60.55	918000.0
2006-09-08 11:00:00	GLD	ETF	60.5301	60.56	60.41	60.56	307200.0
2006-09-08 12:00:00	GLD	ETF	60.57	60.68	60.42	60.65	423600.0
2006-09-08 13:00:00	GLD	ETF	60.63	60.77	60.58	60.65	264700.0
2006-09-08 14:00:00	GLD	ETF	60.6548	60.75	60.59	60.64	171200.0
2006-09-08 15:00:00	GLD	ETF	60.64	60.66	60.58	60.62	338100.0

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

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