PREVIEW / etf_1hour / 2005-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-25.parquet
  size:    31 KB
  rows:    929

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
2005-07-25 07:00:00	SPY	ETF	123.29	123.45	123.29	123.4	39900.0
2005-07-25 08:00:00	SPY	ETF	123.37	123.47	123.37	123.46	398900.0
2005-07-25 09:00:00	SPY	ETF	123.45	123.61	123.36	123.38	4571300.0
2005-07-25 10:00:00	SPY	ETF	123.38	123.95	123.27	123.81	13328000.0
2005-07-25 11:00:00	SPY	ETF	123.82	123.82	123.44	123.6	5678700.0
2005-07-25 12:00:00	SPY	ETF	123.6	123.62	123.29	123.32	4390900.0
2005-07-25 13:00:00	SPY	ETF	123.32	123.53	123.25	123.36	3916500.0
2005-07-25 14:00:00	SPY	ETF	123.39	123.41	122.87	122.95	10995300.0
2005-07-25 15:00:00	SPY	ETF	122.95	123.1	122.85	122.93	10506800.0
2005-07-25 16:00:00	SPY	ETF	122.92	123.2	122.92	123.17	923100.0
2005-07-25 17:00:00	SPY	ETF	123.19	123.23	122.97	123.23	140100.0
2005-07-25 18:00:00	SPY	ETF	123.22	123.26	123.18	123.18	6100.0
2005-07-25 19:00:00	SPY	ETF	123.17	123.21	123.17	123.21	7300.0
2005-07-25 09:00:00	QQQ	ETF	39.45	39.54	39.43	39.44	5692200.0
2005-07-25 10:00:00	QQQ	ETF	39.44	39.63	39.38	39.58	8626700.0
2005-07-25 11:00:00	QQQ	ETF	39.58	39.58	39.38	39.43	7081200.0
2005-07-25 12:00:00	QQQ	ETF	39.43	39.47	39.28	39.29	4532800.0
2005-07-25 13:00:00	QQQ	ETF	39.29	39.37	39.28	39.31	4116200.0
2005-07-25 14:00:00	QQQ	ETF	39.31	39.37	39.21	39.23	5922800.0
2005-07-25 15:00:00	QQQ	ETF	39.23	39.31	39.2	39.25	9241300.0
2005-07-25 07:00:00	IWM	ETF	67.36	67.36	67.36	67.36	200.0
2005-07-25 08:00:00	IWM	ETF	67.34	67.34	67.28	67.28	2400.0
2005-07-25 09:00:00	IWM	ETF	67.34	67.46	67.26	67.27	1801900.0
2005-07-25 10:00:00	IWM	ETF	67.27	67.68	67.17	67.63	4511100.0
2005-07-25 11:00:00	IWM	ETF	67.63	67.65	67.27	67.4	1777700.0
2005-07-25 12:00:00	IWM	ETF	67.41	67.47	67.09	67.15	2891000.0
2005-07-25 13:00:00	IWM	ETF	67.14	67.33	67.09	67.13	1231900.0
2005-07-25 14:00:00	IWM	ETF	67.13	67.14	66.78	66.81	3522300.0
2005-07-25 15:00:00	IWM	ETF	66.82	66.92	66.61	66.73	5831300.0
2005-07-25 16:00:00	IWM	ETF	66.72	66.98	66.71	66.86	442200.0
2005-07-25 17:00:00	IWM	ETF	66.86	66.87	66.75	66.87	96300.0
2005-07-25 18:00:00	IWM	ETF	66.95	66.95	66.95	66.95	300.0
2005-07-25 19:00:00	IWM	ETF	66.95	66.95	66.95	66.95	200.0
2005-07-25 07:00:00	DIA	ETF	106.44	106.44	106.44	106.44	100.0
2005-07-25 08:00:00	DIA	ETF	106.47	106.5	106.47	106.48	1900.0
2005-07-25 09:00:00	DIA	ETF	106.49	106.65	106.47	106.48	564700.0
2005-07-25 10:00:00	DIA	ETF	106.47	106.85	106.39	106.7	1752000.0
2005-07-25 11:00:00	DIA	ETF	106.7	106.71	106.4	106.49	475000.0
2005-07-25 12:00:00	DIA	ETF	106.49	106.49	106.18	106.2	514400.0
2005-07-25 13:00:00	DIA	ETF	106.2	106.4	106.13	106.29	357400.0
2005-07-25 14:00:00	DIA	ETF	106.28	106.35	105.9	105.96	899600.0
2005-07-25 15:00:00	DIA	ETF	105.96	106.08	105.86	105.92	913200.0
2005-07-25 16:00:00	DIA	ETF	105.93	106.15	105.93	106.14	204800.0
2005-07-25 08:00:00	GLD	ETF	42.41	42.41	42.41	42.41	100.0
2005-07-25 09:00:00	GLD	ETF	42.46	42.47	42.43	42.44	141300.0
2005-07-25 10:00:00	GLD	ETF	42.45	42.56	42.43	42.55	343500.0
2005-07-25 11:00:00	GLD	ETF	42.55	42.55	42.48	42.49	1122700.0
2005-07-25 12:00:00	GLD	ETF	42.5	42.53	42.49	42.5	216200.0
2005-07-25 13:00:00	GLD	ETF	42.5	42.53	42.484	42.53	186000.0
2005-07-25 14:00:00	GLD	ETF	42.53	42.53	42.49	42.52	40900.0

> showing 50 of 929 rows — these rows as CSV

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