PREVIEW / etf_1hour / 2006-01-11

all etf 1-hour files

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

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-11 06:00:00	SPY	ETF	129.13	129.13	129.13	129.13	200.0
2006-01-11 07:00:00	SPY	ETF	129.02	129.06	128.99	129.0	116900.0
2006-01-11 08:00:00	SPY	ETF	129.04	129.14	128.99	129.1	782400.0
2006-01-11 09:00:00	SPY	ETF	129.1	129.12	128.76	128.88	3315500.0
2006-01-11 10:00:00	SPY	ETF	128.87	129.14	128.73	128.8	9926000.0
2006-01-11 11:00:00	SPY	ETF	128.8	129.2	128.74	128.93	8593800.0
2006-01-11 12:00:00	SPY	ETF	128.93	129.23	128.91	129.11	3941800.0
2006-01-11 13:00:00	SPY	ETF	129.11	129.15	128.82	129.03	6212300.0
2006-01-11 14:00:00	SPY	ETF	129.05	129.44	128.97	129.41	9733800.0
2006-01-11 15:00:00	SPY	ETF	129.39	129.44	129.25	129.35	5304400.0
2006-01-11 16:00:00	SPY	ETF	129.37	129.38	129.25	129.3	534600.0
2006-01-11 17:00:00	SPY	ETF	129.29	129.34	129.27	129.33	50400.0
2006-01-11 18:00:00	SPY	ETF	129.31	129.33	129.27	129.27	8600.0
2006-01-11 19:00:00	SPY	ETF	129.28	129.28	129.28	129.28	200.0
2006-01-11 09:00:00	QQQ	ETF	43.01	43.02	42.87	42.95	13224600.0
2006-01-11 10:00:00	QQQ	ETF	42.95	43.1	42.89	43.02	19589500.0
2006-01-11 11:00:00	QQQ	ETF	43.02	43.23	42.99	43.09	13254100.0
2006-01-11 12:00:00	QQQ	ETF	43.08	43.24	43.06	43.16	10245300.0
2006-01-11 13:00:00	QQQ	ETF	43.16	43.2	42.17	43.18	11669700.0
2006-01-11 14:00:00	QQQ	ETF	43.18	43.31	43.15	43.29	11879700.0
2006-01-11 15:00:00	QQQ	ETF	43.29	43.31	43.19	43.21	12535600.0
2006-01-11 05:00:00	IWM	ETF	70.78	70.78	70.78	70.78	200.0
2006-01-11 07:00:00	IWM	ETF	70.7	70.7	70.7	70.7	2200.0
2006-01-11 08:00:00	IWM	ETF	70.71	70.73	70.65	70.73	151800.0
2006-01-11 09:00:00	IWM	ETF	70.7	70.75	70.34	70.45	2618600.0
2006-01-11 10:00:00	IWM	ETF	70.45	70.57	70.25	70.32	4996400.0
2006-01-11 11:00:00	IWM	ETF	70.33	70.53	70.11	70.15	3841500.0
2006-01-11 12:00:00	IWM	ETF	70.14	70.34	70.08	70.31	3007800.0
2006-01-11 13:00:00	IWM	ETF	70.32	70.43	70.04	70.34	4302200.0
2006-01-11 14:00:00	IWM	ETF	70.33	70.65	70.3	70.57	3697000.0
2006-01-11 15:00:00	IWM	ETF	70.58	70.66	70.49	70.61	3930300.0
2006-01-11 16:00:00	IWM	ETF	70.6	70.66	70.56	70.57	154900.0
2006-01-11 17:00:00	IWM	ETF	70.57	70.59	70.57	70.57	1700.0
2006-01-11 18:00:00	IWM	ETF	70.57	70.58	70.57	70.58	3500.0
2006-01-11 07:00:00	DIA	ETF	110.16	110.16	110.14	110.15	103000.0
2006-01-11 08:00:00	DIA	ETF	110.15	110.29	110.13	110.29	60400.0
2006-01-11 09:00:00	DIA	ETF	110.26	110.26	110.0	110.06	417900.0
2006-01-11 10:00:00	DIA	ETF	110.06	110.24	109.93	109.99	510700.0
2006-01-11 11:00:00	DIA	ETF	109.99	110.21	109.96	110.01	508900.0
2006-01-11 12:00:00	DIA	ETF	110.01	110.27	109.99	110.18	367300.0
2006-01-11 13:00:00	DIA	ETF	110.18	110.22	109.88	110.08	536800.0
2006-01-11 14:00:00	DIA	ETF	110.08	110.45	110.02	110.42	821200.0
2006-01-11 15:00:00	DIA	ETF	110.42	110.46	110.31	110.4	668900.0
2006-01-11 16:00:00	DIA	ETF	110.41	110.44	110.38	110.44	17000.0
2006-01-11 17:00:00	DIA	ETF	110.48	110.48	110.48	110.48	200.0
2006-01-11 18:00:00	DIA	ETF	110.45	110.45	110.45	110.45	100.0
2006-01-11 07:00:00	GLD	ETF	54.2	54.2	54.2	54.2	400.0
2006-01-11 08:00:00	GLD	ETF	54.1	54.55	54.1	54.4	62100.0
2006-01-11 09:00:00	GLD	ETF	54.4	54.4	54.07	54.34	1057100.0
2006-01-11 10:00:00	GLD	ETF	54.34	54.35	54.18	54.24	626300.0

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

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