PREVIEW / etf_1hour / 2006-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-26.parquet
  size:    40 KB
  rows:    1,244

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-26 05:00:00	SPY	ETF	130.58	130.58	130.58	130.58	300.0
2006-04-26 07:00:00	SPY	ETF	130.66	130.66	130.57	130.6	60800.0
2006-04-26 08:00:00	SPY	ETF	130.6	130.72	130.37	130.54	2711000.0
2006-04-26 09:00:00	SPY	ETF	130.54	131.0	130.46	130.92	7389600.0
2006-04-26 10:00:00	SPY	ETF	130.9	131.14	130.6	130.83	21098300.0
2006-04-26 11:00:00	SPY	ETF	130.83	131.12	130.6	130.75	6995700.0
2006-04-26 12:00:00	SPY	ETF	130.74	130.91	130.63	130.75	3839300.0
2006-04-26 13:00:00	SPY	ETF	130.75	130.97	130.65	130.87	2945000.0
2006-04-26 14:00:00	SPY	ETF	130.87	130.97	130.55	130.66	5438500.0
2006-04-26 15:00:00	SPY	ETF	130.66	130.74	130.3	130.58	12712600.0
2006-04-26 16:00:00	SPY	ETF	130.59	130.59	130.25	130.5	871200.0
2006-04-26 17:00:00	SPY	ETF	130.47	130.49	130.41	130.42	137400.0
2006-04-26 18:00:00	SPY	ETF	130.47	130.49	130.43	130.49	4700.0
2006-04-26 19:00:00	SPY	ETF	130.5	130.53	130.5	130.53	500.0
2006-04-26 09:00:00	QQQ	ETF	41.87	42.01	41.86	41.96	10684500.0
2006-04-26 10:00:00	QQQ	ETF	41.96	42.06	41.83	41.94	19700300.0
2006-04-26 11:00:00	QQQ	ETF	41.94	42.02	41.78	41.82	10778800.0
2006-04-26 12:00:00	QQQ	ETF	41.82	41.9	41.77	41.85	5339500.0
2006-04-26 13:00:00	QQQ	ETF	41.84	41.98	41.84	41.92	6230000.0
2006-04-26 14:00:00	QQQ	ETF	41.92	41.94	41.79	41.83	7057300.0
2006-04-26 15:00:00	QQQ	ETF	41.83	41.88	41.7	41.88	12198600.0
2006-04-26 07:00:00	IWM	ETF	76.2	76.2	76.12	76.13	5000.0
2006-04-26 08:00:00	IWM	ETF	76.18	76.23	76.06	76.12	26200.0
2006-04-26 09:00:00	IWM	ETF	76.15	76.37	76.0	76.33	4020600.0
2006-04-26 10:00:00	IWM	ETF	76.34	76.75	76.1	76.3	8707800.0
2006-04-26 11:00:00	IWM	ETF	76.31	76.52	76.12	76.19	3585000.0
2006-04-26 12:00:00	IWM	ETF	76.19	76.45	76.11	76.28	2058700.0
2006-04-26 13:00:00	IWM	ETF	76.28	76.48	76.2	76.46	2485300.0
2006-04-26 14:00:00	IWM	ETF	76.47	76.54	76.06	76.11	3997000.0
2006-04-26 15:00:00	IWM	ETF	76.11	76.14	75.78	76.1	4737100.0
2006-04-26 16:00:00	IWM	ETF	76.11	76.12	75.97	76.06	65300.0
2006-04-26 08:00:00	DIA	ETF	112.95	113.12	112.84	113.0	13500.0
2006-04-26 09:00:00	DIA	ETF	113.01	113.5	112.91	113.42	1104000.0
2006-04-26 10:00:00	DIA	ETF	113.41	113.69	113.17	113.38	1735400.0
2006-04-26 11:00:00	DIA	ETF	113.39	113.53	113.22	113.44	962000.0
2006-04-26 12:00:00	DIA	ETF	113.46	113.56	113.35	113.45	387600.0
2006-04-26 13:00:00	DIA	ETF	113.45	113.59	113.34	113.5	354500.0
2006-04-26 14:00:00	DIA	ETF	113.5	113.62	113.32	113.4	554500.0
2006-04-26 15:00:00	DIA	ETF	113.41	113.52	113.18	113.44	845100.0
2006-04-26 16:00:00	DIA	ETF	113.41	113.45	113.4	113.4	41600.0
2006-04-26 19:00:00	DIA	ETF	113.4	113.42	113.4	113.42	700.0
2006-04-26 08:00:00	GLD	ETF	62.8	62.82	62.46	62.55	207300.0
2006-04-26 09:00:00	GLD	ETF	62.61	63.3	62.57	63.23	1020700.0
2006-04-26 10:00:00	GLD	ETF	63.24	63.54	63.0601	63.49	1751300.0
2006-04-26 11:00:00	GLD	ETF	63.5	63.67	63.41	63.43	1091100.0
2006-04-26 12:00:00	GLD	ETF	63.45	63.67	63.29	63.4801	491900.0
2006-04-26 13:00:00	GLD	ETF	63.4961	63.69	63.4001	63.6	417000.0
2006-04-26 14:00:00	GLD	ETF	63.59	63.76	63.55	63.76	325100.0
2006-04-26 15:00:00	GLD	ETF	63.76	63.79	63.6	63.67	469400.0
2006-04-26 16:00:00	GLD	ETF	63.67	63.67	63.54	63.57	12900.0

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

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