PREVIEW / etf_1hour / 2006-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-20.parquet
  size:    59 KB
  rows:    1,859

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-12-20 05:00:00	SPY	ETF	142.59	142.59	142.59	142.59	1800.0
2006-12-20 06:00:00	SPY	ETF	142.56	142.56	142.56	142.56	2500.0
2006-12-20 07:00:00	SPY	ETF	142.51	142.51	142.43	142.45	128100.0
2006-12-20 08:00:00	SPY	ETF	142.45	142.51	142.37	142.38	576900.0
2006-12-20 09:00:00	SPY	ETF	142.38	142.53	142.23	142.53	6790200.0
2006-12-20 10:00:00	SPY	ETF	142.52	142.66	142.42	142.59	8316100.0
2006-12-20 11:00:00	SPY	ETF	142.6	142.66	142.46	142.54	4160800.0
2006-12-20 12:00:00	SPY	ETF	142.55	142.59	142.4	142.46	2085200.0
2006-12-20 13:00:00	SPY	ETF	142.45	142.468	142.05	142.2	7031000.0
2006-12-20 14:00:00	SPY	ETF	142.2	142.37	142.16	142.2	5766600.0
2006-12-20 15:00:00	SPY	ETF	142.22	142.29	142.08	142.08	4638900.0
2006-12-20 16:00:00	SPY	ETF	142.08	142.2	142.02	142.2	1006300.0
2006-12-20 17:00:00	SPY	ETF	142.2	142.23	142.17	142.23	6700.0
2006-12-20 18:00:00	SPY	ETF	142.17	142.23	142.17	142.23	1000.0
2006-12-20 19:00:00	SPY	ETF	142.24	142.24	142.23	142.24	600.0
2006-12-20 09:00:00	QQQ	ETF	43.9	44.06	43.86	44.06	9472700.0
2006-12-20 10:00:00	QQQ	ETF	44.05	44.11	43.94	44.03	15748500.0
2006-12-20 11:00:00	QQQ	ETF	44.04	44.06	43.95	44.01	6494200.0
2006-12-20 12:00:00	QQQ	ETF	44.0	44.03	43.9	43.95	4771600.0
2006-12-20 13:00:00	QQQ	ETF	43.94	43.96	43.67	43.74	12186900.0
2006-12-20 14:00:00	QQQ	ETF	43.75	43.86	43.75	43.78	4950700.0
2006-12-20 15:00:00	QQQ	ETF	43.77	43.85	43.68	43.69	8140300.0
2006-12-20 07:00:00	IWM	ETF	78.06	78.06	78.06	78.06	3000.0
2006-12-20 08:00:00	IWM	ETF	78.06	78.07	77.65	77.77	509600.0
2006-12-20 09:00:00	IWM	ETF	77.76	78.05	77.6	78.04	6020900.0
2006-12-20 10:00:00	IWM	ETF	78.04	78.26	78.04	78.23	7291200.0
2006-12-20 11:00:00	IWM	ETF	78.23	78.25	78.1	78.16	2785500.0
2006-12-20 12:00:00	IWM	ETF	78.17	78.19	78.03	78.07	1177100.0
2006-12-20 13:00:00	IWM	ETF	78.07	78.1	77.72	77.79	3389700.0
2006-12-20 14:00:00	IWM	ETF	77.79	77.96	77.78	77.86	4497100.0
2006-12-20 15:00:00	IWM	ETF	77.86	77.95	77.79	77.92	9385500.0
2006-12-20 16:00:00	IWM	ETF	77.92	77.99	77.88	77.94	851100.0
2006-12-20 17:00:00	IWM	ETF	77.95	77.98	77.89	77.89	4711800.0
2006-12-20 19:00:00	IWM	ETF	77.96	77.96	77.96	77.96	2000.0
2006-12-20 07:00:00	DIA	ETF	124.6	124.6	124.6	124.6	100.0
2006-12-20 08:00:00	DIA	ETF	124.56	124.58	124.49	124.51	32600.0
2006-12-20 09:00:00	DIA	ETF	124.5	124.54	124.28	124.51	1043900.0
2006-12-20 10:00:00	DIA	ETF	124.51	124.65	124.44	124.65	1022500.0
2006-12-20 11:00:00	DIA	ETF	124.65	124.72	124.59	124.68	570000.0
2006-12-20 12:00:00	DIA	ETF	124.68	124.71	124.55	124.59	198200.0
2006-12-20 13:00:00	DIA	ETF	124.58	124.62	124.35	124.46	738200.0
2006-12-20 14:00:00	DIA	ETF	124.45	124.61	124.44	124.46	517400.0
2006-12-20 15:00:00	DIA	ETF	124.47	124.54	124.37	124.4	503400.0
2006-12-20 16:00:00	DIA	ETF	124.388	124.48	124.34	124.48	59100.0
2006-12-20 17:00:00	DIA	ETF	124.46	124.46	124.46	124.46	100.0
2006-12-20 19:00:00	DIA	ETF	124.45	124.45	124.45	124.45	100.0
2006-12-20 08:00:00	GLD	ETF	61.86	61.97	61.76	61.81	51400.0
2006-12-20 09:00:00	GLD	ETF	61.79	61.79	61.54	61.58	536900.0
2006-12-20 10:00:00	GLD	ETF	61.55	61.71	61.45	61.54	902900.0
2006-12-20 11:00:00	GLD	ETF	61.53	61.72	61.51	61.65	390300.0

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

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