PREVIEW / etf_1hour / 2006-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-28.parquet
  size:    41 KB
  rows:    1,269

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-04-28 04:00:00	SPY	ETF	130.77	130.77	130.71	130.71	200.0
2006-04-28 07:00:00	SPY	ETF	130.75	130.82	130.73	130.75	16700.0
2006-04-28 08:00:00	SPY	ETF	130.75	131.94	130.6	130.64	1717500.0
2006-04-28 09:00:00	SPY	ETF	130.91	131.02	130.71	130.92	7717000.0
2006-04-28 10:00:00	SPY	ETF	130.92	131.75	130.91	131.3	13738100.0
2006-04-28 11:00:00	SPY	ETF	131.3	131.5	131.15	131.31	6248500.0
2006-04-28 12:00:00	SPY	ETF	131.3	131.32	131.05	131.21	4739100.0
2006-04-28 13:00:00	SPY	ETF	131.21	131.42	131.13	131.22	3611700.0
2006-04-28 14:00:00	SPY	ETF	131.21	131.28	131.08	131.14	3162500.0
2006-04-28 15:00:00	SPY	ETF	131.14	131.22	130.95	131.14	10338300.0
2006-04-28 16:00:00	SPY	ETF	131.15	131.47	130.752	131.39	1661500.0
2006-04-28 17:00:00	SPY	ETF	131.42	131.42	131.42	131.42	1900.0
2006-04-28 18:00:00	SPY	ETF	131.43	131.43	131.4	131.4	700.0
2006-04-28 09:00:00	QQQ	ETF	41.99	42.04	41.82	41.99	20826000.0
2006-04-28 10:00:00	QQQ	ETF	41.96	42.22	41.96	42.01	19117000.0
2006-04-28 11:00:00	QQQ	ETF	42.02	42.06	41.87	41.93	11812500.0
2006-04-28 12:00:00	QQQ	ETF	41.93	41.96	41.78	41.87	8647800.0
2006-04-28 13:00:00	QQQ	ETF	41.87	42.01	41.86	41.89	7695000.0
2006-04-28 14:00:00	QQQ	ETF	41.89	41.92	41.85	41.87	2634300.0
2006-04-28 15:00:00	QQQ	ETF	41.88	41.89	41.78	41.86	11953700.0
2006-04-28 08:00:00	IWM	ETF	75.33	75.37	75.15	75.33	23500.0
2006-04-28 09:00:00	IWM	ETF	75.33	75.89	75.1	75.61	4626700.0
2006-04-28 10:00:00	IWM	ETF	75.61	76.35	75.61	76.04	9239500.0
2006-04-28 11:00:00	IWM	ETF	76.04	76.28	75.91	76.12	6536000.0
2006-04-28 12:00:00	IWM	ETF	76.12	76.13	75.71	75.91	3315200.0
2006-04-28 13:00:00	IWM	ETF	75.92	76.12	75.83	75.92	3145500.0
2006-04-28 14:00:00	IWM	ETF	75.92	76.04	75.85	75.87	2739700.0
2006-04-28 15:00:00	IWM	ETF	75.88	75.97	75.72	75.94	5897000.0
2006-04-28 16:00:00	IWM	ETF	75.94	76.2	75.85	76.15	641200.0
2006-04-28 17:00:00	IWM	ETF	76.1	76.1	76.1	76.1	800.0
2006-04-28 18:00:00	IWM	ETF	76.1	76.2	76.1	76.2	400.0
2006-04-28 07:00:00	DIA	ETF	113.59	113.59	113.59	113.59	9900.0
2006-04-28 08:00:00	DIA	ETF	113.63	113.76	113.5	113.74	22800.0
2006-04-28 09:00:00	DIA	ETF	113.74	113.74	113.39	113.53	429700.0
2006-04-28 10:00:00	DIA	ETF	113.52	114.1	113.52	113.71	1203600.0
2006-04-28 11:00:00	DIA	ETF	113.71	113.86	113.57	113.6814	539100.0
2006-04-28 12:00:00	DIA	ETF	113.68	113.71	113.53	113.66	544600.0
2006-04-28 13:00:00	DIA	ETF	113.65	113.83	113.61	113.72	272700.0
2006-04-28 14:00:00	DIA	ETF	113.71	113.73	113.58	113.6	228400.0
2006-04-28 15:00:00	DIA	ETF	113.61	113.69	113.46	113.68	659000.0
2006-04-28 16:00:00	DIA	ETF	113.72	114.01	113.72	114.01	72500.0
2006-04-28 17:00:00	DIA	ETF	113.94	113.94	113.9	113.9	1000.0
2006-04-28 18:00:00	DIA	ETF	113.98	113.98	113.98	113.98	200.0
2006-04-28 08:00:00	GLD	ETF	63.53	64.1	63.32	63.89	238000.0
2006-04-28 09:00:00	GLD	ETF	63.82	64.18	63.67	64.14	1009500.0
2006-04-28 10:00:00	GLD	ETF	64.14	64.22	63.91	64.1999	831500.0
2006-04-28 11:00:00	GLD	ETF	64.2	64.89	64.2	64.72	1975500.0
2006-04-28 12:00:00	GLD	ETF	64.72	65.27	64.6	65.0	1592800.0
2006-04-28 13:00:00	GLD	ETF	64.9901	65.15	64.58	64.58	1232800.0
2006-04-28 14:00:00	GLD	ETF	64.58	64.89	64.57	64.87	845900.0

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

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