PREVIEW / etf_1hour / 2006-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-23.parquet
  size:    39 KB
  rows:    1,226

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-01-23 04:00:00	SPY	ETF	126.39	126.41	126.39	126.41	500.0
2006-01-23 05:00:00	SPY	ETF	126.39	126.4	126.36	126.36	9500.0
2006-01-23 06:00:00	SPY	ETF	126.16	126.16	126.16	126.16	1500.0
2006-01-23 07:00:00	SPY	ETF	126.14	126.42	126.14	126.35	237600.0
2006-01-23 08:00:00	SPY	ETF	126.42	126.44	125.95	126.28	1582400.0
2006-01-23 09:00:00	SPY	ETF	126.28	126.44	126.18	126.24	8709600.0
2006-01-23 10:00:00	SPY	ETF	126.24	126.53	126.13	126.5	9947700.0
2006-01-23 11:00:00	SPY	ETF	126.49	126.82	126.43	126.72	7220900.0
2006-01-23 12:00:00	SPY	ETF	126.73	126.78	126.2	126.27	5808100.0
2006-01-23 13:00:00	SPY	ETF	126.29	126.66	126.26	126.37	5200900.0
2006-01-23 14:00:00	SPY	ETF	126.37	126.64	126.14	126.49	6394000.0
2006-01-23 15:00:00	SPY	ETF	126.5	126.67	126.28	126.33	6484800.0
2006-01-23 16:00:00	SPY	ETF	126.32	126.47	126.28	126.3	11627500.0
2006-01-23 17:00:00	SPY	ETF	126.29	126.36	126.28	126.28	18200.0
2006-01-23 18:00:00	SPY	ETF	126.32	126.36	126.27	126.3	77500.0
2006-01-23 19:00:00	SPY	ETF	126.33	126.47	126.33	126.47	8800.0
2006-01-23 09:00:00	QQQ	ETF	41.37	41.38	41.1	41.11	15406300.0
2006-01-23 10:00:00	QQQ	ETF	41.11	41.32	41.08	41.28	18999800.0
2006-01-23 11:00:00	QQQ	ETF	41.28	41.45	41.22	41.4	16075300.0
2006-01-23 12:00:00	QQQ	ETF	41.41	41.41	41.15	41.2	8019100.0
2006-01-23 13:00:00	QQQ	ETF	41.21	41.35	41.17	41.18	6189300.0
2006-01-23 14:00:00	QQQ	ETF	41.18	41.26	41.08	41.24	7811000.0
2006-01-23 15:00:00	QQQ	ETF	41.23	41.28	41.17	41.26	10305200.0
2006-01-23 08:00:00	IWM	ETF	70.26	70.36	70.26	70.26	51500.0
2006-01-23 09:00:00	IWM	ETF	70.26	70.31	70.1	70.1	5049800.0
2006-01-23 10:00:00	IWM	ETF	70.09	70.2	69.99	70.19	8660400.0
2006-01-23 11:00:00	IWM	ETF	70.19	70.56	70.15	70.52	3225100.0
2006-01-23 12:00:00	IWM	ETF	70.53	70.53	70.12	70.2501	3066500.0
2006-01-23 13:00:00	IWM	ETF	70.26	70.44	70.16	70.2	2224900.0
2006-01-23 14:00:00	IWM	ETF	70.19	70.41	70.06	70.39	3436000.0
2006-01-23 15:00:00	IWM	ETF	70.4	70.43	70.21	70.24	3200300.0
2006-01-23 16:00:00	IWM	ETF	70.24	70.4	70.21	70.3	266300.0
2006-01-23 17:00:00	IWM	ETF	70.29	70.29	70.23	70.25	75500.0
2006-01-23 18:00:00	IWM	ETF	70.26	70.26	70.25	70.25	200.0
2006-01-23 07:00:00	DIA	ETF	106.61	106.69	106.61	106.69	600.0
2006-01-23 08:00:00	DIA	ETF	106.75	106.77	106.56	106.58	23700.0
2006-01-23 09:00:00	DIA	ETF	106.6	106.82	106.6	106.65	1001800.0
2006-01-23 10:00:00	DIA	ETF	106.64	106.97	106.56	106.97	1742900.0
2006-01-23 11:00:00	DIA	ETF	106.97	107.28	106.93	107.19	1268200.0
2006-01-23 12:00:00	DIA	ETF	107.19	107.19	106.68	106.72	880200.0
2006-01-23 13:00:00	DIA	ETF	106.71	107.01	106.71	106.83	765000.0
2006-01-23 14:00:00	DIA	ETF	106.84	106.93	106.65	106.89	683100.0
2006-01-23 15:00:00	DIA	ETF	106.9	107.14	106.76	106.81	947300.0
2006-01-23 16:00:00	DIA	ETF	106.8	106.88	106.76	106.8	133700.0
2006-01-23 18:00:00	DIA	ETF	106.8	106.8	106.8	106.8	500.0
2006-01-23 19:00:00	DIA	ETF	106.87	106.87	106.87	106.87	1000.0
2006-01-23 08:00:00	GLD	ETF	55.52	55.62	55.45	55.49	20800.0
2006-01-23 09:00:00	GLD	ETF	55.64	55.67	55.47	55.56	805400.0
2006-01-23 10:00:00	GLD	ETF	55.55	55.78	55.26	55.76	1557500.0
2006-01-23 11:00:00	GLD	ETF	55.75	55.9	55.33	55.55	822100.0

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

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