PREVIEW / etf_1hour / 2006-04-21

all etf 1-hour files

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

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-21 05:00:00	SPY	ETF	131.36	131.36	131.36	131.36	100.0
2006-04-21 07:00:00	SPY	ETF	131.33	131.37	131.33	131.37	5900.0
2006-04-21 08:00:00	SPY	ETF	131.13	131.56	131.13	131.52	1484700.0
2006-04-21 09:00:00	SPY	ETF	131.54	131.79	131.41	131.49	7301800.0
2006-04-21 10:00:00	SPY	ETF	131.49	131.79	131.3	131.44	9046100.0
2006-04-21 11:00:00	SPY	ETF	131.42	131.59	131.29	131.43	5379900.0
2006-04-21 12:00:00	SPY	ETF	131.43	131.53	131.26	131.48	6606500.0
2006-04-21 13:00:00	SPY	ETF	131.4774	131.54	131.36	131.39	5308700.0
2006-04-21 14:00:00	SPY	ETF	131.39	131.49	130.71	130.81	17658000.0
2006-04-21 15:00:00	SPY	ETF	130.81	131.2	130.62	131.1	16379100.0
2006-04-21 16:00:00	SPY	ETF	131.11	131.22	131.03	131.15	915900.0
2006-04-21 17:00:00	SPY	ETF	131.11	131.11	131.05	131.05	96500.0
2006-04-21 18:00:00	SPY	ETF	131.1	131.14	131.05	131.05	9100.0
2006-04-21 19:00:00	SPY	ETF	131.1	131.1	131.1	131.1	300.0
2006-04-21 09:00:00	QQQ	ETF	42.67	42.72	42.47	42.51	12577300.0
2006-04-21 10:00:00	QQQ	ETF	42.5	42.65	42.38	42.43	12262700.0
2006-04-21 11:00:00	QQQ	ETF	42.43	42.47	42.3	42.36	7940300.0
2006-04-21 12:00:00	QQQ	ETF	42.37	42.43	42.3	42.39	7248400.0
2006-04-21 13:00:00	QQQ	ETF	42.39	42.43	42.33	42.34	3293000.0
2006-04-21 14:00:00	QQQ	ETF	42.33	42.34	41.87	41.9	34034900.0
2006-04-21 15:00:00	QQQ	ETF	41.91	42.05	41.82	41.97	35613600.0
2006-04-21 08:00:00	IWM	ETF	76.98	77.24	76.85	77.08	264100.0
2006-04-21 09:00:00	IWM	ETF	77.08	77.35	76.95	76.98	3768500.0
2006-04-21 10:00:00	IWM	ETF	76.98	77.22	76.74	77.04	6525400.0
2006-04-21 11:00:00	IWM	ETF	77.05	77.09	76.84	76.99	3708100.0
2006-04-21 12:00:00	IWM	ETF	77.0	77.11	76.93	77.03	1540500.0
2006-04-21 13:00:00	IWM	ETF	77.03	77.19	77.02	77.07	2239700.0
2006-04-21 14:00:00	IWM	ETF	77.06	77.07	76.29	76.45	7245900.0
2006-04-21 15:00:00	IWM	ETF	76.46	77.17	76.26	76.6	9476400.0
2006-04-21 16:00:00	IWM	ETF	76.61	76.79	76.58	76.7	1112800.0
2006-04-21 08:00:00	DIA	ETF	113.51	113.63	113.51	113.6	4600.0
2006-04-21 09:00:00	DIA	ETF	113.72	113.98	113.62	113.76	1166700.0
2006-04-21 10:00:00	DIA	ETF	113.76	113.96	113.57	113.68	1208700.0
2006-04-21 11:00:00	DIA	ETF	113.68	113.86	113.64	113.73	489000.0
2006-04-21 12:00:00	DIA	ETF	113.75	113.78	113.57	113.71	267000.0
2006-04-21 13:00:00	DIA	ETF	113.74	113.77	113.61	113.64	257400.0
2006-04-21 14:00:00	DIA	ETF	113.64	113.67	113.18	113.22	1204200.0
2006-04-21 15:00:00	DIA	ETF	113.22	113.5	113.1	113.36	2238700.0
2006-04-21 16:00:00	DIA	ETF	113.38	113.45	113.38	113.45	62100.0
2006-04-21 17:00:00	DIA	ETF	113.4	113.4	113.4	113.4	700.0
2006-04-21 07:00:00	GLD	ETF	61.55	61.58	61.5	61.58	7200.0
2006-04-21 08:00:00	GLD	ETF	61.55	62.46	61.47	62.46	269500.0
2006-04-21 09:00:00	GLD	ETF	62.4	62.68	61.78	62.04	2146400.0
2006-04-21 10:00:00	GLD	ETF	62.03	62.32	61.9	62.19	1242800.0
2006-04-21 11:00:00	GLD	ETF	62.19	62.67	62.0	62.6	1061500.0
2006-04-21 12:00:00	GLD	ETF	62.6	62.62	62.2801	62.57	546700.0
2006-04-21 13:00:00	GLD	ETF	62.55	63.23	62.49	63.1826	877300.0
2006-04-21 14:00:00	GLD	ETF	63.18	63.28	62.6106	63.1	757500.0
2006-04-21 15:00:00	GLD	ETF	63.1	63.28	63.07	63.2	611500.0
2006-04-21 16:00:00	GLD	ETF	63.16	63.22	63.16	63.2	1800.0

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

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