PREVIEW / etf_1hour / 2006-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-13.parquet
  size:    38 KB
  rows:    1,195

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-01-13 07:00:00	SPY	ETF	128.65	128.67	128.62	128.65	165700.0
2006-01-13 08:00:00	SPY	ETF	128.65	128.76	128.55	128.65	1244000.0
2006-01-13 09:00:00	SPY	ETF	128.65	128.81	128.55	128.71	3198400.0
2006-01-13 10:00:00	SPY	ETF	128.71	128.79	128.41	128.64	8179600.0
2006-01-13 11:00:00	SPY	ETF	128.64	128.9	128.41	128.67	6029600.0
2006-01-13 12:00:00	SPY	ETF	128.67	128.74	128.27	128.37	5966200.0
2006-01-13 13:00:00	SPY	ETF	128.37	128.55	128.31	128.47	4209600.0
2006-01-13 14:00:00	SPY	ETF	128.47	128.7	128.2	128.61	5858700.0
2006-01-13 15:00:00	SPY	ETF	128.61	128.74	128.47	128.7	5741700.0
2006-01-13 16:00:00	SPY	ETF	128.69	128.72	128.53	128.62	1179500.0
2006-01-13 18:00:00	SPY	ETF	128.65	128.65	128.63	128.65	4200.0
2006-01-13 19:00:00	SPY	ETF	128.65	128.65	128.65	128.65	4000.0
2006-01-13 09:00:00	QQQ	ETF	42.94	43.02	42.92	42.97	9282000.0
2006-01-13 10:00:00	QQQ	ETF	42.97	42.97	42.79	42.94	11754400.0
2006-01-13 11:00:00	QQQ	ETF	42.94	43.05	42.9	42.95	11063700.0
2006-01-13 12:00:00	QQQ	ETF	42.96	42.99	42.82	42.88	3592100.0
2006-01-13 13:00:00	QQQ	ETF	42.87	42.9	42.79	42.86	4943300.0
2006-01-13 14:00:00	QQQ	ETF	42.86	42.97	42.73	42.92	10823800.0
2006-01-13 15:00:00	QQQ	ETF	42.93	42.98	42.82	42.97	8276000.0
2006-01-13 08:00:00	IWM	ETF	70.23	70.3	70.22	70.27	12500.0
2006-01-13 09:00:00	IWM	ETF	70.27	70.47	70.22	70.34	1716600.0
2006-01-13 10:00:00	IWM	ETF	70.34	70.37	70.07	70.22	6739700.0
2006-01-13 11:00:00	IWM	ETF	70.23	70.4	70.19	70.29	2072700.0
2006-01-13 12:00:00	IWM	ETF	70.29	70.37	70.02	70.09	1784600.0
2006-01-13 13:00:00	IWM	ETF	70.1	70.22	70.06	70.2	1218200.0
2006-01-13 14:00:00	IWM	ETF	70.2	70.45	70.09	70.36	3283300.0
2006-01-13 15:00:00	IWM	ETF	70.36	70.4	70.25	70.34	2982700.0
2006-01-13 16:00:00	IWM	ETF	70.33	70.38	70.2	70.3	313100.0
2006-01-13 17:00:00	IWM	ETF	70.34	70.34	70.34	70.34	100.0
2006-01-13 08:00:00	DIA	ETF	109.69	109.81	109.67	109.73	23700.0
2006-01-13 09:00:00	DIA	ETF	109.74	109.93	109.6	109.83	306000.0
2006-01-13 10:00:00	DIA	ETF	109.84	109.84	109.51	109.62	485000.0
2006-01-13 11:00:00	DIA	ETF	109.63	109.77	109.56	109.58	849500.0
2006-01-13 12:00:00	DIA	ETF	109.58	109.61	109.24	109.31	314400.0
2006-01-13 13:00:00	DIA	ETF	109.3	109.43	109.28	109.4	354100.0
2006-01-13 14:00:00	DIA	ETF	109.38	109.61	109.19	109.52	886800.0
2006-01-13 15:00:00	DIA	ETF	109.52	109.65	109.39	109.62	422700.0
2006-01-13 16:00:00	DIA	ETF	109.61	109.63	109.49	109.54	39400.0
2006-01-13 17:00:00	DIA	ETF	109.51	109.51	109.51	109.51	400.0
2006-01-13 08:00:00	GLD	ETF	54.48	54.51	54.4	54.45	21000.0
2006-01-13 09:00:00	GLD	ETF	54.43	54.67	54.43	54.59	223300.0
2006-01-13 10:00:00	GLD	ETF	54.59	55.39	54.53	55.3201	1586800.0
2006-01-13 11:00:00	GLD	ETF	55.33	55.56	55.26	55.37	1181900.0
2006-01-13 12:00:00	GLD	ETF	55.35	55.49	55.35	55.49	270900.0
2006-01-13 13:00:00	GLD	ETF	55.48	55.5	55.38	55.4	306100.0
2006-01-13 14:00:00	GLD	ETF	55.4	55.49	55.36	55.4	313000.0
2006-01-13 15:00:00	GLD	ETF	55.42	55.49	55.38	55.49	404800.0
2006-01-13 16:00:00	GLD	ETF	55.47	55.48	55.42	55.44	1100.0
2006-01-13 17:00:00	GLD	ETF	55.5	55.5	55.5	55.5	100.0
2006-01-13 08:00:00	TLT	ETF	91.47	91.66	91.46	91.59	7900.0

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

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