PREVIEW / etf_1hour / 2006-08-15

all etf 1-hour files

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

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-15 06:00:00	SPY	ETF	127.28	127.28	127.28	127.28	5000.0
2006-08-15 07:00:00	SPY	ETF	127.26	127.35	127.23	127.35	11600.0
2006-08-15 08:00:00	SPY	ETF	127.39	128.38	127.19	128.21	5872500.0
2006-08-15 09:00:00	SPY	ETF	128.21	128.34	127.91	128.03	9727600.0
2006-08-15 10:00:00	SPY	ETF	128.03	128.51	127.9	128.34	13549200.0
2006-08-15 11:00:00	SPY	ETF	128.34	128.51	128.22	128.32	8178200.0
2006-08-15 12:00:00	SPY	ETF	128.32	128.5	128.27	128.47	3701300.0
2006-08-15 13:00:00	SPY	ETF	128.47	128.47	128.14	128.3	4885000.0
2006-08-15 14:00:00	SPY	ETF	128.3	128.7	128.18	128.67	7776500.0
2006-08-15 15:00:00	SPY	ETF	128.67	128.87	128.58	128.71	11176800.0
2006-08-15 16:00:00	SPY	ETF	128.71	128.7781	128.59	128.62	1662600.0
2006-08-15 17:00:00	SPY	ETF	128.63	128.65	128.63	128.65	6300.0
2006-08-15 18:00:00	SPY	ETF	128.65	128.67	128.61	128.63	11300.0
2006-08-15 19:00:00	SPY	ETF	128.61	128.63	128.58	128.59	11100.0
2006-08-15 09:00:00	QQQ	ETF	37.23	37.29	37.09	37.15	19964400.0
2006-08-15 10:00:00	QQQ	ETF	37.14	37.44	37.09	37.42	21167300.0
2006-08-15 11:00:00	QQQ	ETF	37.42	37.54	37.39	37.42	16495600.0
2006-08-15 12:00:00	QQQ	ETF	37.43	37.5	37.41	37.49	7701800.0
2006-08-15 13:00:00	QQQ	ETF	37.48	37.5	37.36	37.45	9464500.0
2006-08-15 14:00:00	QQQ	ETF	37.46	37.69	37.4	37.67	18207600.0
2006-08-15 15:00:00	QQQ	ETF	37.67	37.75	37.64	37.7	22970500.0
2006-08-15 07:00:00	IWM	ETF	68.1	68.1	68.1	68.1	100.0
2006-08-15 08:00:00	IWM	ETF	67.87	69.06	67.87	69.0	3404400.0
2006-08-15 09:00:00	IWM	ETF	69.02	69.15	68.73	68.81	8869700.0
2006-08-15 10:00:00	IWM	ETF	68.81	69.08	68.69	69.05	6734000.0
2006-08-15 11:00:00	IWM	ETF	69.06	69.2	68.95	68.95	6171000.0
2006-08-15 12:00:00	IWM	ETF	68.96	69.19	68.93	69.15	3227100.0
2006-08-15 13:00:00	IWM	ETF	69.15	69.15	68.81	68.9	5902900.0
2006-08-15 14:00:00	IWM	ETF	68.91	69.35	68.8	69.35	5247800.0
2006-08-15 15:00:00	IWM	ETF	69.36	69.44	69.23	69.43	7353000.0
2006-08-15 16:00:00	IWM	ETF	69.43	69.45	69.34	69.34	632800.0
2006-08-15 17:00:00	IWM	ETF	69.33	69.38	69.33	69.38	7600.0
2006-08-15 08:00:00	DIA	ETF	111.28	112.14	111.28	112.04	111600.0
2006-08-15 09:00:00	DIA	ETF	112.03	112.13	111.73	111.85	941500.0
2006-08-15 10:00:00	DIA	ETF	111.85	112.2	111.76	112.05	876600.0
2006-08-15 11:00:00	DIA	ETF	112.065	112.2	111.95	112.02	479700.0
2006-08-15 12:00:00	DIA	ETF	112.01	112.17	112.01	112.17	210000.0
2006-08-15 13:00:00	DIA	ETF	112.14	112.16	111.91	112.06	416700.0
2006-08-15 14:00:00	DIA	ETF	112.05	112.29	111.96	112.26	664800.0
2006-08-15 15:00:00	DIA	ETF	112.25	112.45	112.2	112.32	927000.0
2006-08-15 16:00:00	DIA	ETF	112.35	112.39	112.29	112.32	32500.0
2006-08-15 17:00:00	DIA	ETF	112.4	112.44	112.4	112.44	2300.0
2006-08-15 18:00:00	DIA	ETF	112.45	112.5	112.45	112.5	200.0
2006-08-15 19:00:00	DIA	ETF	112.27	112.27	112.27	112.27	1000.0
2006-08-15 07:00:00	GLD	ETF	62.05	62.06	61.98	62.06	27100.0
2006-08-15 08:00:00	GLD	ETF	62.34	62.34	61.65	62.07	357200.0
2006-08-15 09:00:00	GLD	ETF	62.09	62.27	61.81	62.26	1162600.0
2006-08-15 10:00:00	GLD	ETF	62.25	62.25	61.74	61.8	648200.0
2006-08-15 11:00:00	GLD	ETF	61.78	62.17	61.68	62.06	508300.0
2006-08-15 12:00:00	GLD	ETF	62.06	62.15	61.88	61.93	235400.0

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

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