PREVIEW / etf_1hour / 2006-01-18

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-18.parquet
  size:    40 KB
  rows:    1,253

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-18 06:00:00	SPY	ETF	127.21	127.25	127.17	127.19	99800.0
2006-01-18 07:00:00	SPY	ETF	127.23	127.53	127.21	127.47	171200.0
2006-01-18 08:00:00	SPY	ETF	127.49	128.33	127.16	127.52	2076700.0
2006-01-18 09:00:00	SPY	ETF	127.51	127.9	127.48	127.8	8165600.0
2006-01-18 10:00:00	SPY	ETF	127.8	128.9	127.76	127.84	11788900.0
2006-01-18 11:00:00	SPY	ETF	127.84	127.93	127.4	127.53	10311200.0
2006-01-18 12:00:00	SPY	ETF	127.52	127.59	127.31	127.45	7692300.0
2006-01-18 13:00:00	SPY	ETF	127.45	127.53	127.16	127.32	11107300.0
2006-01-18 14:00:00	SPY	ETF	127.31	127.84	127.31	127.48	11944300.0
2006-01-18 15:00:00	SPY	ETF	127.48	127.91	127.36	127.79	5737700.0
2006-01-18 16:00:00	SPY	ETF	127.79	127.85	127.55	127.61	910200.0
2006-01-18 17:00:00	SPY	ETF	127.6	127.97	127.59	127.95	52300.0
2006-01-18 18:00:00	SPY	ETF	127.91	128.06	127.91	127.99	51000.0
2006-01-18 19:00:00	SPY	ETF	128.0	128.01	127.98	127.98	3600.0
2006-01-18 09:00:00	QQQ	ETF	42.04	42.24	42.02	42.18	22592800.0
2006-01-18 10:00:00	QQQ	ETF	42.18	42.46	42.16	42.25	22082400.0
2006-01-18 11:00:00	QQQ	ETF	42.25	42.27	42.08	42.15	15126000.0
2006-01-18 12:00:00	QQQ	ETF	42.14	42.2	42.06	42.13	8685300.0
2006-01-18 13:00:00	QQQ	ETF	42.13	42.2	42.08	42.17	11452900.0
2006-01-18 14:00:00	QQQ	ETF	42.18	42.37	42.14	42.2	13085800.0
2006-01-18 15:00:00	QQQ	ETF	42.21	42.33	42.15	42.22	10002400.0
2006-01-18 07:00:00	IWM	ETF	69.37	69.38	69.37	69.38	2000.0
2006-01-18 08:00:00	IWM	ETF	69.38	69.41	69.2	69.32	83600.0
2006-01-18 09:00:00	IWM	ETF	69.29	69.8	69.29	69.61	7693300.0
2006-01-18 10:00:00	IWM	ETF	69.6	70.0	69.56	69.81	6553800.0
2006-01-18 11:00:00	IWM	ETF	69.8	69.88	69.67	69.75	3732700.0
2006-01-18 12:00:00	IWM	ETF	69.76	69.81	69.56	69.62	3083700.0
2006-01-18 13:00:00	IWM	ETF	69.62	69.67	69.39	69.54	2586200.0
2006-01-18 14:00:00	IWM	ETF	69.55	69.89	69.52	69.72	3086400.0
2006-01-18 15:00:00	IWM	ETF	69.72	70.0	69.6	69.91	3123300.0
2006-01-18 16:00:00	IWM	ETF	69.9	69.96	69.6	69.73	340300.0
2006-01-18 17:00:00	IWM	ETF	69.73	69.98	69.7	69.98	11900.0
2006-01-18 18:00:00	IWM	ETF	69.98	69.98	69.9	69.9	2800.0
2006-01-18 19:00:00	IWM	ETF	69.95	69.95	69.95	69.95	100.0
2006-01-18 07:00:00	DIA	ETF	108.35	108.35	108.35	108.35	900.0
2006-01-18 08:00:00	DIA	ETF	108.35	108.36	108.1	108.36	131400.0
2006-01-18 09:00:00	DIA	ETF	108.34	108.76	108.32	108.6	1364000.0
2006-01-18 10:00:00	DIA	ETF	108.58	108.9	108.54	108.57	911000.0
2006-01-18 11:00:00	DIA	ETF	108.57	108.67	108.34	108.45	578000.0
2006-01-18 12:00:00	DIA	ETF	108.45	108.5	108.28	108.43	278700.0
2006-01-18 13:00:00	DIA	ETF	108.42	108.48	108.21	108.29	370300.0
2006-01-18 14:00:00	DIA	ETF	108.29	108.66	108.25	108.33	695700.0
2006-01-18 15:00:00	DIA	ETF	108.31	108.66	108.24	108.6	550000.0
2006-01-18 16:00:00	DIA	ETF	108.59	108.64	108.4	108.48	21300.0
2006-01-18 18:00:00	DIA	ETF	108.86	108.86	108.85	108.85	1800.0
2006-01-18 19:00:00	DIA	ETF	108.78	108.8	108.78	108.8	1000.0
2006-01-18 07:00:00	GLD	ETF	54.41	54.53	54.41	54.53	10600.0
2006-01-18 08:00:00	GLD	ETF	54.51	54.61	54.33	54.49	64900.0
2006-01-18 09:00:00	GLD	ETF	54.45	54.73	54.45	54.47	879400.0
2006-01-18 10:00:00	GLD	ETF	54.47	54.6	54.11	54.49	1018600.0

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

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