PREVIEW / etf_1hour / 2006-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-07.parquet
  size:    49 KB
  rows:    1,567

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-07 05:00:00	SPY	ETF	127.54	127.68	127.54	127.68	1900.0
2006-08-07 07:00:00	SPY	ETF	127.68	127.76	127.65	127.73	44800.0
2006-08-07 08:00:00	SPY	ETF	127.75	128.2	127.66	127.86	548600.0
2006-08-07 09:00:00	SPY	ETF	127.85	127.96	127.64	127.88	5691100.0
2006-08-07 10:00:00	SPY	ETF	127.88	128.01	127.67	127.68	5691100.0
2006-08-07 11:00:00	SPY	ETF	127.68	127.78	127.53	127.78	6208600.0
2006-08-07 12:00:00	SPY	ETF	127.78	128.05	127.64	127.8278	5454600.0
2006-08-07 13:00:00	SPY	ETF	127.8	128.08	127.75	127.79	4571000.0
2006-08-07 14:00:00	SPY	ETF	127.78	127.83	127.56	127.67	4908200.0
2006-08-07 15:00:00	SPY	ETF	127.66	127.78	127.4	127.76	7968400.0
2006-08-07 16:00:00	SPY	ETF	127.76	127.95	127.67	127.95	3599200.0
2006-08-07 17:00:00	SPY	ETF	127.9	127.94	127.88	127.88	10900.0
2006-08-07 18:00:00	SPY	ETF	127.88	127.96	127.88	127.96	55500.0
2006-08-07 19:00:00	SPY	ETF	127.97	127.97	127.91	127.91	300.0
2006-08-07 09:00:00	QQQ	ETF	36.92	36.94	36.75	36.87	10380300.0
2006-08-07 10:00:00	QQQ	ETF	36.87	36.91	36.75	36.77	9493800.0
2006-08-07 11:00:00	QQQ	ETF	36.76	36.82	36.63	36.81	10887800.0
2006-08-07 12:00:00	QQQ	ETF	36.82	36.88	36.74	36.79	4900200.0
2006-08-07 13:00:00	QQQ	ETF	36.8	36.92	36.76	36.79	5738000.0
2006-08-07 14:00:00	QQQ	ETF	36.79	36.8	36.59	36.63	10850100.0
2006-08-07 15:00:00	QQQ	ETF	36.64	36.75	36.53	36.71	13151500.0
2006-08-07 08:00:00	IWM	ETF	69.25	69.62	69.25	69.31	568200.0
2006-08-07 09:00:00	IWM	ETF	69.31	69.4	68.96	69.18	5364500.0
2006-08-07 10:00:00	IWM	ETF	69.2	69.41	69.02	69.04	6639800.0
2006-08-07 11:00:00	IWM	ETF	69.03	69.11	68.74	69.1099	9751300.0
2006-08-07 12:00:00	IWM	ETF	69.11	69.44	69.05	69.26	4156600.0
2006-08-07 13:00:00	IWM	ETF	69.27	69.48	69.15	69.16	3917500.0
2006-08-07 14:00:00	IWM	ETF	69.17	69.31	68.87	69.01	6611000.0
2006-08-07 15:00:00	IWM	ETF	69.01	69.25	68.8	69.23	7814100.0
2006-08-07 16:00:00	IWM	ETF	69.23	69.44	69.19	69.26	757300.0
2006-08-07 17:00:00	IWM	ETF	69.3	69.3	69.3	69.3	2000.0
2006-08-07 18:00:00	IWM	ETF	69.33	69.34	69.33	69.34	600.0
2006-08-07 19:00:00	IWM	ETF	69.33	69.33	69.33	69.33	500.0
2006-08-07 07:00:00	DIA	ETF	112.02	112.11	112.02	112.03	4600.0
2006-08-07 08:00:00	DIA	ETF	112.06	112.12	112.03	112.07	11500.0
2006-08-07 09:00:00	DIA	ETF	112.07	112.26	112.01	112.21	803000.0
2006-08-07 10:00:00	DIA	ETF	112.21	112.33	112.05	112.07	387600.0
2006-08-07 11:00:00	DIA	ETF	112.06	112.12	111.85	112.1	916300.0
2006-08-07 12:00:00	DIA	ETF	112.11	112.33	112.02	112.22	240700.0
2006-08-07 13:00:00	DIA	ETF	112.22	112.42	112.16	112.21	306200.0
2006-08-07 14:00:00	DIA	ETF	112.21	112.21	112.0	112.11	529600.0
2006-08-07 15:00:00	DIA	ETF	112.1	112.23	111.91	112.21	386600.0
2006-08-07 16:00:00	DIA	ETF	112.22	112.38	112.15	112.31	26000.0
2006-08-07 19:00:00	DIA	ETF	112.38	112.39	112.38	112.39	200.0
2006-08-07 07:00:00	GLD	ETF	64.3	64.3	64.3	64.3	100.0
2006-08-07 08:00:00	GLD	ETF	64.35	64.45	64.25	64.41	134500.0
2006-08-07 09:00:00	GLD	ETF	64.36	64.68	64.29	64.59	469700.0
2006-08-07 10:00:00	GLD	ETF	64.59	64.7	64.45	64.67	354300.0
2006-08-07 11:00:00	GLD	ETF	64.68	64.81	64.6	64.66	450000.0
2006-08-07 12:00:00	GLD	ETF	64.67	64.7999	64.53	64.5674	258200.0

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

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