PREVIEW / etf_1hour / 2006-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-21.parquet
  size:    49 KB
  rows:    1,623

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-08-21 04:00:00	SPY	ETF	130.07	130.07	130.07	130.07	3000.0
2006-08-21 06:00:00	SPY	ETF	130.25	130.25	130.23	130.24	2700.0
2006-08-21 07:00:00	SPY	ETF	130.22	130.24	130.1	130.21	139600.0
2006-08-21 08:00:00	SPY	ETF	130.2	130.3	130.1	130.23	1566800.0
2006-08-21 09:00:00	SPY	ETF	130.23	130.24	130.04	130.05	5690200.0
2006-08-21 10:00:00	SPY	ETF	130.06	130.25	129.99	130.12	7038100.0
2006-08-21 11:00:00	SPY	ETF	130.13	130.17	129.81	129.84	7390800.0
2006-08-21 12:00:00	SPY	ETF	129.84	130.11	129.8	130.04	3432100.0
2006-08-21 13:00:00	SPY	ETF	130.04	130.16	129.97	130.08	5021500.0
2006-08-21 14:00:00	SPY	ETF	130.07	130.16	129.9	130.02	3054900.0
2006-08-21 15:00:00	SPY	ETF	130.02	130.25	129.93	130.11	5892300.0
2006-08-21 16:00:00	SPY	ETF	130.14	130.28	130.09	130.09	635700.0
2006-08-21 17:00:00	SPY	ETF	130.18	130.19	130.1	130.1	5200.0
2006-08-21 18:00:00	SPY	ETF	130.16	130.16	130.16	130.16	100.0
2006-08-21 19:00:00	SPY	ETF	130.14	130.17	130.14	130.17	500.0
2006-08-21 09:00:00	QQQ	ETF	38.47	38.5	38.35	38.36	11883800.0
2006-08-21 10:00:00	QQQ	ETF	38.36	38.48	38.34	38.41	7979900.0
2006-08-21 11:00:00	QQQ	ETF	38.41	38.42	38.28	38.29	10545400.0
2006-08-21 12:00:00	QQQ	ETF	38.29	38.42	38.26	38.39	5596000.0
2006-08-21 13:00:00	QQQ	ETF	38.39	38.47	38.37	38.39	5431100.0
2006-08-21 14:00:00	QQQ	ETF	38.39	38.46	38.35	38.38	6942800.0
2006-08-21 15:00:00	QQQ	ETF	38.39	38.56	38.36	38.43	11708700.0
2006-08-21 08:00:00	IWM	ETF	70.45	70.52	70.33	70.48	133000.0
2006-08-21 09:00:00	IWM	ETF	70.47	70.51	70.18	70.18	4887500.0
2006-08-21 10:00:00	IWM	ETF	70.19	70.39	70.12	70.25	3725800.0
2006-08-21 11:00:00	IWM	ETF	70.24	70.24	69.87	69.89	5347500.0
2006-08-21 12:00:00	IWM	ETF	69.89	70.16	69.85	70.09	2186000.0
2006-08-21 13:00:00	IWM	ETF	70.09	70.21	70.03	70.19	1684800.0
2006-08-21 14:00:00	IWM	ETF	70.19	70.3	69.97	70.1	2348900.0
2006-08-21 15:00:00	IWM	ETF	70.1	70.37	70.04	70.15	3176200.0
2006-08-21 16:00:00	IWM	ETF	70.16	70.34	70.15	70.28	1277900.0
2006-08-21 17:00:00	IWM	ETF	70.26	70.26	70.23	70.23	1100.0
2006-08-21 18:00:00	IWM	ETF	70.28	70.28	70.26	70.26	4100.0
2006-08-21 07:00:00	DIA	ETF	113.47	113.47	113.43	113.45	16100.0
2006-08-21 08:00:00	DIA	ETF	113.47	113.48	113.44	113.48	53200.0
2006-08-21 09:00:00	DIA	ETF	113.46	113.46	113.29	113.31	865700.0
2006-08-21 10:00:00	DIA	ETF	113.3	113.5	113.26	113.37	701200.0
2006-08-21 11:00:00	DIA	ETF	113.36	113.4	113.14	113.14	845800.0
2006-08-21 12:00:00	DIA	ETF	113.15	113.39	113.1	113.36	338600.0
2006-08-21 13:00:00	DIA	ETF	113.36	113.44	113.26	113.37	787100.0
2006-08-21 14:00:00	DIA	ETF	113.37	113.4	113.14	113.251	425500.0
2006-08-21 15:00:00	DIA	ETF	113.26	113.46	113.18	113.4	852400.0
2006-08-21 16:00:00	DIA	ETF	113.41	113.55	113.41	113.49	90800.0
2006-08-21 19:00:00	DIA	ETF	113.38	113.38	113.38	113.38	1800.0
2006-08-21 04:00:00	GLD	ETF	61.44	61.44	61.44	61.44	100.0
2006-08-21 08:00:00	GLD	ETF	61.88	62.23	61.66	62.12	96600.0
2006-08-21 09:00:00	GLD	ETF	62.15	62.18	61.88	62.16	673100.0
2006-08-21 10:00:00	GLD	ETF	62.16	62.22	61.93	62.01	708900.0
2006-08-21 11:00:00	GLD	ETF	62.0	62.08	61.8	62.03	535700.0
2006-08-21 12:00:00	GLD	ETF	62.04	62.2	61.93	62.15	264400.0

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

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