PREVIEW / etf_1hour / 2006-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-01.parquet
  size:    41 KB
  rows:    1,275

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-01 06:00:00	SPY	ETF	131.36	131.36	131.36	131.36	5000.0
2006-05-01 07:00:00	SPY	ETF	131.36	131.39	131.36	131.37	5200.0
2006-05-01 08:00:00	SPY	ETF	131.38	131.47	131.27	131.35	1029700.0
2006-05-01 09:00:00	SPY	ETF	131.36	131.78	131.32	131.62	6022500.0
2006-05-01 10:00:00	SPY	ETF	131.61	131.8	131.24	131.43	11601700.0
2006-05-01 11:00:00	SPY	ETF	131.4	131.53	131.22	131.37	4216800.0
2006-05-01 12:00:00	SPY	ETF	131.37	131.46	131.18	131.4	4853300.0
2006-05-01 13:00:00	SPY	ETF	131.39	131.55	131.32	131.49	3799800.0
2006-05-01 14:00:00	SPY	ETF	131.49	131.52	131.38	131.49	4846400.0
2006-05-01 15:00:00	SPY	ETF	131.48	131.57	130.32	130.57	24405100.0
2006-05-01 16:00:00	SPY	ETF	130.54	130.637	130.3	130.51	1351600.0
2006-05-01 17:00:00	SPY	ETF	130.5	130.55	130.48	130.55	22700.0
2006-05-01 18:00:00	SPY	ETF	130.5	130.55	130.0	130.54	16400.0
2006-05-01 19:00:00	SPY	ETF	130.52	130.56	130.5	130.51	14400.0
2006-05-01 09:00:00	QQQ	ETF	41.93	42.05	41.91	41.96	8636700.0
2006-05-01 10:00:00	QQQ	ETF	41.96	42.0	41.83	41.94	9286200.0
2006-05-01 11:00:00	QQQ	ETF	41.94	41.98	41.83	41.92	4170600.0
2006-05-01 12:00:00	QQQ	ETF	41.92	41.93	41.78	41.86	7604300.0
2006-05-01 13:00:00	QQQ	ETF	41.86	41.91	41.84	41.88	3142600.0
2006-05-01 14:00:00	QQQ	ETF	41.87	41.89	41.82	41.86	2420600.0
2006-05-01 15:00:00	QQQ	ETF	41.86	42.3	41.31	41.43	47990700.0
2006-05-01 06:00:00	IWM	ETF	75.18	75.18	75.18	75.18	100.0
2006-05-01 07:00:00	IWM	ETF	76.09	76.1	76.09	76.1	1200.0
2006-05-01 08:00:00	IWM	ETF	76.1	76.2	76.09	76.16	103300.0
2006-05-01 09:00:00	IWM	ETF	76.16	76.64	76.16	76.4	3171200.0
2006-05-01 10:00:00	IWM	ETF	76.41	76.54	75.98	76.1	7205400.0
2006-05-01 11:00:00	IWM	ETF	76.1	76.16	75.87	76.02	5362200.0
2006-05-01 12:00:00	IWM	ETF	76.03	76.07	75.79	75.96	9770300.0
2006-05-01 13:00:00	IWM	ETF	75.95	76.22	75.87	76.19	2102100.0
2006-05-01 14:00:00	IWM	ETF	76.19	76.31	76.05	76.23	2346100.0
2006-05-01 15:00:00	IWM	ETF	76.24	76.28	75.45	75.58	12665700.0
2006-05-01 16:00:00	IWM	ETF	75.56	75.57	75.23	75.33	707900.0
2006-05-01 17:00:00	IWM	ETF	75.33	75.35	75.28	75.28	4800.0
2006-05-01 18:00:00	IWM	ETF	75.32	75.32	75.32	75.32	3000.0
2006-05-01 05:00:00	DIA	ETF	113.75	113.75	113.75	113.75	100.0
2006-05-01 08:00:00	DIA	ETF	113.91	113.93	113.85	113.9	151200.0
2006-05-01 09:00:00	DIA	ETF	113.95	114.21	113.95	114.11	804900.0
2006-05-01 10:00:00	DIA	ETF	114.1	114.15	113.85	114.03	904000.0
2006-05-01 11:00:00	DIA	ETF	114.03	114.08	113.84	114.0	424400.0
2006-05-01 12:00:00	DIA	ETF	114.01	114.06	113.81	113.99	595000.0
2006-05-01 13:00:00	DIA	ETF	114.0	114.07	113.93	114.03	281600.0
2006-05-01 14:00:00	DIA	ETF	114.04	114.06	113.93	114.03	257200.0
2006-05-01 15:00:00	DIA	ETF	114.02	114.16	113.19	113.38	2098900.0
2006-05-01 16:00:00	DIA	ETF	113.35	113.4	113.27	113.4	52100.0
2006-05-01 18:00:00	DIA	ETF	113.41	113.41	113.41	113.41	100.0
2006-05-01 07:00:00	GLD	ETF	65.47	65.48	65.47	65.47	18400.0
2006-05-01 08:00:00	GLD	ETF	65.41	65.62	65.0	65.46	177300.0
2006-05-01 09:00:00	GLD	ETF	65.46	65.83	65.37	65.44	1522600.0
2006-05-01 10:00:00	GLD	ETF	65.44	65.66	65.26	65.3	1067600.0
2006-05-01 11:00:00	GLD	ETF	65.31	65.61	65.28	65.42	1377300.0

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

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