PREVIEW / etf_1hour / 2006-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-26.parquet
  size:    39 KB
  rows:    1,241

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-26 04:00:00	SPY	ETF	127.29	127.46	127.29	127.46	20700.0
2006-01-26 06:00:00	SPY	ETF	127.4	127.4	127.26	127.31	181500.0
2006-01-26 07:00:00	SPY	ETF	127.3	127.48	127.3	127.44	350400.0
2006-01-26 08:00:00	SPY	ETF	127.4	127.49	127.2	127.26	3066000.0
2006-01-26 09:00:00	SPY	ETF	127.29	127.35	126.99	127.14	8487500.0
2006-01-26 10:00:00	SPY	ETF	127.14	127.28	126.76	127.12	10706900.0
2006-01-26 11:00:00	SPY	ETF	127.12	127.54	126.94	127.46	10402800.0
2006-01-26 12:00:00	SPY	ETF	127.46	127.67	127.16	127.18	8432000.0
2006-01-26 13:00:00	SPY	ETF	127.18	127.36	126.98	127.16	4844900.0
2006-01-26 14:00:00	SPY	ETF	127.16	127.52	127.07	127.4	6937200.0
2006-01-26 15:00:00	SPY	ETF	127.41	127.58	127.23	127.4	10229800.0
2006-01-26 16:00:00	SPY	ETF	127.4	127.55	127.27	127.44	911100.0
2006-01-26 17:00:00	SPY	ETF	127.4	127.58	127.37	127.52	1882100.0
2006-01-26 18:00:00	SPY	ETF	127.52	127.6	127.52	127.6	71200.0
2006-01-26 19:00:00	SPY	ETF	127.62	127.65	127.62	127.62	5400.0
2006-01-26 09:00:00	QQQ	ETF	41.52	41.57	41.41	41.48	12390800.0
2006-01-26 10:00:00	QQQ	ETF	41.49	41.55	41.23	41.45	16446600.0
2006-01-26 11:00:00	QQQ	ETF	41.45	41.65	41.36	41.61	16469800.0
2006-01-26 12:00:00	QQQ	ETF	41.61	41.69	41.42	41.45	12335900.0
2006-01-26 13:00:00	QQQ	ETF	41.44	41.5	41.31	41.36	10718400.0
2006-01-26 14:00:00	QQQ	ETF	41.37	41.57	41.34	41.5	9760200.0
2006-01-26 15:00:00	QQQ	ETF	41.5	41.63	41.46	41.57	14307800.0
2006-01-26 07:00:00	IWM	ETF	71.64	71.78	71.64	71.78	32600.0
2006-01-26 08:00:00	IWM	ETF	71.76	71.78	71.58	71.6	44500.0
2006-01-26 09:00:00	IWM	ETF	71.62	71.73	71.51	71.6	4030900.0
2006-01-26 10:00:00	IWM	ETF	71.58	71.64	71.41	71.58	4285600.0
2006-01-26 11:00:00	IWM	ETF	71.56	71.92	71.52	71.9	2811700.0
2006-01-26 12:00:00	IWM	ETF	71.91	72.02	71.88	71.9	3186800.0
2006-01-26 13:00:00	IWM	ETF	71.89	72.04	71.82	71.99	4447200.0
2006-01-26 14:00:00	IWM	ETF	71.99	72.3	71.96	72.12	4670000.0
2006-01-26 15:00:00	IWM	ETF	72.12	72.42	72.11	72.35	10886300.0
2006-01-26 16:00:00	IWM	ETF	72.2	72.53	72.2	72.4	770600.0
2006-01-26 17:00:00	IWM	ETF	72.42	72.72	72.42	72.68	2483900.0
2006-01-26 18:00:00	IWM	ETF	72.65	72.7	72.65	72.7	600.0
2006-01-26 19:00:00	IWM	ETF	72.6	72.6	72.6	72.6	800.0
2006-01-26 04:00:00	DIA	ETF	107.8	107.8	107.8	107.8	100.0
2006-01-26 06:00:00	DIA	ETF	107.27	107.65	107.27	107.65	600.0
2006-01-26 07:00:00	DIA	ETF	107.74	107.89	107.74	107.89	500.0
2006-01-26 08:00:00	DIA	ETF	107.89	107.98	107.59	107.6	20200.0
2006-01-26 09:00:00	DIA	ETF	107.58	107.68	107.49	107.61	953000.0
2006-01-26 10:00:00	DIA	ETF	107.6	107.75	107.45	107.65	976800.0
2006-01-26 11:00:00	DIA	ETF	107.65	107.99	107.5	107.97	670900.0
2006-01-26 12:00:00	DIA	ETF	107.97	108.15	107.76	107.81	1198700.0
2006-01-26 13:00:00	DIA	ETF	107.8	107.87	107.63	107.78	678700.0
2006-01-26 14:00:00	DIA	ETF	107.79	108.15	107.77	108.05	885900.0
2006-01-26 15:00:00	DIA	ETF	108.03	108.2	107.86	108.02	2240000.0
2006-01-26 16:00:00	DIA	ETF	107.97	108.09	107.96	108.06	149100.0
2006-01-26 17:00:00	DIA	ETF	108.06	108.15	108.06	108.15	700.0
2006-01-26 18:00:00	DIA	ETF	108.17	108.17	108.17	108.17	100.0
2006-01-26 19:00:00	DIA	ETF	108.25	108.25	108.25	108.25	100.0

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

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