PREVIEW / etf_1hour / 2006-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-17.parquet
  size:    42 KB
  rows:    1,278

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-17 06:00:00	SPY	ETF	128.98	128.98	128.96	128.98	2500.0
2006-04-17 07:00:00	SPY	ETF	128.83	128.83	128.75	128.75	50100.0
2006-04-17 08:00:00	SPY	ETF	128.81	128.98	128.71	128.93	236500.0
2006-04-17 09:00:00	SPY	ETF	128.94	129.16	128.79	129.0	4880500.0
2006-04-17 10:00:00	SPY	ETF	129.01	129.25	128.99	129.07	8312200.0
2006-04-17 11:00:00	SPY	ETF	129.08	129.15	128.9	129.07	3924700.0
2006-04-17 12:00:00	SPY	ETF	129.07	129.09	128.53	128.64	9697200.0
2006-04-17 13:00:00	SPY	ETF	128.64	128.69	128.12	128.24	11902300.0
2006-04-17 14:00:00	SPY	ETF	128.24	129.31	128.02	128.14	12456100.0
2006-04-17 15:00:00	SPY	ETF	128.14	128.55	128.14	128.52	8066200.0
2006-04-17 16:00:00	SPY	ETF	128.51	129.06	128.5	128.65	699700.0
2006-04-17 17:00:00	SPY	ETF	128.64	128.7	128.58	128.6	9700.0
2006-04-17 18:00:00	SPY	ETF	128.65	128.65	128.64	128.65	2100.0
2006-04-17 19:00:00	SPY	ETF	128.65	128.66	128.63	128.63	2600.0
2006-04-17 09:00:00	QQQ	ETF	42.04	42.15	42.04	42.1	6266300.0
2006-04-17 10:00:00	QQQ	ETF	42.08	42.21	42.08	42.14	9927400.0
2006-04-17 11:00:00	QQQ	ETF	42.14	42.15	42.0	42.08	6752700.0
2006-04-17 12:00:00	QQQ	ETF	42.08	42.09	41.8	41.84	10093700.0
2006-04-17 13:00:00	QQQ	ETF	41.84	41.85	41.39	41.46	30645000.0
2006-04-17 14:00:00	QQQ	ETF	41.46	41.56	41.44	41.48	13501900.0
2006-04-17 15:00:00	QQQ	ETF	41.48	41.68	41.47	41.66	13906300.0
2006-04-17 08:00:00	IWM	ETF	74.66	74.71	74.24	74.61	639300.0
2006-04-17 09:00:00	IWM	ETF	74.62	74.85	74.55	74.65	3692700.0
2006-04-17 10:00:00	IWM	ETF	74.65	74.93	74.49	74.8	2772100.0
2006-04-17 11:00:00	IWM	ETF	74.82	74.89	74.62	74.75	1751100.0
2006-04-17 12:00:00	IWM	ETF	74.74	74.79	74.34	74.39	4617400.0
2006-04-17 13:00:00	IWM	ETF	74.4	74.42	73.9	74.02	7245700.0
2006-04-17 14:00:00	IWM	ETF	74.01	74.15	73.93	74.01	4459800.0
2006-04-17 15:00:00	IWM	ETF	74.01	74.57	73.95	74.45	6173700.0
2006-04-17 16:00:00	IWM	ETF	74.44	74.61	74.44	74.61	3445700.0
2006-04-17 17:00:00	IWM	ETF	74.61	74.62	74.45	74.59	45500.0
2006-04-17 18:00:00	IWM	ETF	74.54	74.63	74.54	74.55	8300.0
2006-04-17 19:00:00	IWM	ETF	74.54	74.54	74.52	74.52	600.0
2006-04-17 07:00:00	DIA	ETF	111.44	111.45	111.38	111.38	27600.0
2006-04-17 08:00:00	DIA	ETF	111.45	111.45	111.38	111.4	41800.0
2006-04-17 09:00:00	DIA	ETF	111.42	111.62	111.31	111.49	916700.0
2006-04-17 10:00:00	DIA	ETF	111.5	111.6	111.31	111.34	450200.0
2006-04-17 11:00:00	DIA	ETF	111.36	111.41	111.19	111.35	453400.0
2006-04-17 12:00:00	DIA	ETF	111.34	111.34	110.74	110.88	992700.0
2006-04-17 13:00:00	DIA	ETF	110.87	110.9	110.45	110.52	1049400.0
2006-04-17 14:00:00	DIA	ETF	110.53	110.6	110.36	110.49	767700.0
2006-04-17 15:00:00	DIA	ETF	110.45	110.78	110.45	110.75	669900.0
2006-04-17 16:00:00	DIA	ETF	110.78	110.84	110.75	110.83	44000.0
2006-04-17 17:00:00	DIA	ETF	110.88	110.89	110.85	110.89	1300.0
2006-04-17 18:00:00	DIA	ETF	110.89	110.89	110.89	110.89	900.0
2006-04-17 08:00:00	GLD	ETF	60.15	60.4	60.11	60.37	171500.0
2006-04-17 09:00:00	GLD	ETF	60.27	60.47	60.19	60.34	1196900.0
2006-04-17 10:00:00	GLD	ETF	60.3	60.48	60.2	60.42	1051200.0
2006-04-17 11:00:00	GLD	ETF	60.42	60.48	60.26	60.434	1044300.0
2006-04-17 12:00:00	GLD	ETF	60.45	60.95	60.45	60.92	806500.0

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

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