PREVIEW / etf_1hour / 2006-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-04.parquet
  size:    41 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-05-04 06:00:00	SPY	ETF	131.17	131.17	131.1	131.1	2800.0
2006-05-04 07:00:00	SPY	ETF	131.1	131.1	131.0	131.05	51400.0
2006-05-04 08:00:00	SPY	ETF	131.12	131.12	130.79	130.95	1256500.0
2006-05-04 09:00:00	SPY	ETF	130.93	131.43	130.93	131.33	7937200.0
2006-05-04 10:00:00	SPY	ETF	131.34	131.62	131.28	131.28	10050100.0
2006-05-04 11:00:00	SPY	ETF	131.29	131.54	131.28	131.4	5367800.0
2006-05-04 12:00:00	SPY	ETF	131.4	131.42	130.97	131.17	5089800.0
2006-05-04 13:00:00	SPY	ETF	131.17	131.37	131.15	131.29	2711200.0
2006-05-04 14:00:00	SPY	ETF	131.31	131.48	131.23	131.32	3119700.0
2006-05-04 15:00:00	SPY	ETF	131.32	131.42	131.25	131.28	5769800.0
2006-05-04 16:00:00	SPY	ETF	131.29	131.36	131.27	131.34	733100.0
2006-05-04 17:00:00	SPY	ETF	131.34	131.34	131.31	131.33	3000.0
2006-05-04 18:00:00	SPY	ETF	131.3	131.35	131.3	131.34	13700.0
2006-05-04 19:00:00	SPY	ETF	131.32	131.32	131.3	131.31	1800.0
2006-05-04 09:00:00	QQQ	ETF	41.53	41.87	41.53	41.85	28992000.0
2006-05-04 10:00:00	QQQ	ETF	41.85	41.99	41.77	41.77	17956700.0
2006-05-04 11:00:00	QQQ	ETF	41.77	41.96	41.76	41.91	7532800.0
2006-05-04 12:00:00	QQQ	ETF	41.92	41.92	41.73	41.78	6972400.0
2006-05-04 13:00:00	QQQ	ETF	41.78	42.12	41.46	41.89	5623500.0
2006-05-04 14:00:00	QQQ	ETF	41.89	41.95	41.84	41.87	5121500.0
2006-05-04 15:00:00	QQQ	ETF	41.86	41.91	41.81	41.82	5944100.0
2006-05-04 08:00:00	IWM	ETF	76.3	76.32	76.06	76.13	1026000.0
2006-05-04 09:00:00	IWM	ETF	76.18	76.6	76.14	76.46	4278700.0
2006-05-04 10:00:00	IWM	ETF	76.46	76.86	76.4	76.58	5912700.0
2006-05-04 11:00:00	IWM	ETF	76.59	76.82	76.57	76.71	3481800.0
2006-05-04 12:00:00	IWM	ETF	76.71	76.72	76.35	76.5	3218100.0
2006-05-04 13:00:00	IWM	ETF	76.51	76.78	76.51	76.74	2491200.0
2006-05-04 14:00:00	IWM	ETF	76.73	76.97	76.71	76.89	3388800.0
2006-05-04 15:00:00	IWM	ETF	76.89	77.05	76.81	76.94	4715200.0
2006-05-04 16:00:00	IWM	ETF	76.95	77.11	76.28	77.05	1376400.0
2006-05-04 18:00:00	IWM	ETF	77.09	77.09	77.09	77.09	100.0
2006-05-04 08:00:00	DIA	ETF	114.11	114.2	114.0	114.0	86400.0
2006-05-04 09:00:00	DIA	ETF	114.09	114.47	114.05	114.42	810700.0
2006-05-04 10:00:00	DIA	ETF	114.43	114.63	114.3	114.3	1365500.0
2006-05-04 11:00:00	DIA	ETF	114.31	114.54	114.3	114.48	384600.0
2006-05-04 12:00:00	DIA	ETF	114.48	114.49	114.25	114.36	371900.0
2006-05-04 13:00:00	DIA	ETF	114.37	114.48	114.34	114.44	247200.0
2006-05-04 14:00:00	DIA	ETF	114.43	114.51	114.3	114.4	352500.0
2006-05-04 15:00:00	DIA	ETF	114.4	114.46	114.33	114.36	422700.0
2006-05-04 16:00:00	DIA	ETF	114.35	114.41	114.33	114.33	15700.0
2006-05-04 07:00:00	GLD	ETF	66.18	66.2	65.94	65.98	24100.0
2006-05-04 08:00:00	GLD	ETF	65.9	66.29	65.84	66.26	2342600.0
2006-05-04 09:00:00	GLD	ETF	66.3	66.99	66.3	66.9	1714900.0
2006-05-04 10:00:00	GLD	ETF	66.88	67.38	66.84	66.97	1827600.0
2006-05-04 11:00:00	GLD	ETF	67.0	67.4	66.83	67.09	2251400.0
2006-05-04 12:00:00	GLD	ETF	67.08	67.15	66.22	66.64	2849400.0
2006-05-04 13:00:00	GLD	ETF	66.65	67.23	66.51	67.1	881200.0
2006-05-04 14:00:00	GLD	ETF	67.09	67.63	66.98	67.48	1232800.0
2006-05-04 15:00:00	GLD	ETF	67.48	67.67	67.44	67.52	935200.0
2006-05-04 16:00:00	GLD	ETF	67.46	67.6	67.42	67.59	26100.0

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

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