PREVIEW / etf_1hour / 2005-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-07.parquet
  size:    31 KB
  rows:    961

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-09-07 07:00:00	SPY	ETF	123.6	123.72	123.6	123.7	20300.0
2005-09-07 08:00:00	SPY	ETF	123.7	123.74	123.55	123.6	451500.0
2005-09-07 09:00:00	SPY	ETF	123.61	123.72	123.5	123.57	3331300.0
2005-09-07 10:00:00	SPY	ETF	123.58	123.82	123.46	123.81	7101700.0
2005-09-07 11:00:00	SPY	ETF	123.82	123.96	123.63	123.74	4857100.0
2005-09-07 12:00:00	SPY	ETF	123.72	123.88	123.69	123.85	1494300.0
2005-09-07 13:00:00	SPY	ETF	123.85	123.98	123.71	123.87	3509400.0
2005-09-07 14:00:00	SPY	ETF	123.87	123.98	123.6	123.91	5852100.0
2005-09-07 15:00:00	SPY	ETF	123.91	124.13	123.79	124.02	10404300.0
2005-09-07 16:00:00	SPY	ETF	124.04	124.04	123.82	123.86	1011200.0
2005-09-07 17:00:00	SPY	ETF	123.85	123.91	123.84	123.91	35500.0
2005-09-07 18:00:00	SPY	ETF	123.86	123.86	123.78	123.78	17100.0
2005-09-07 19:00:00	SPY	ETF	123.79	123.8	123.77	123.77	4800.0
2005-09-07 09:00:00	QQQ	ETF	39.3	39.34	39.22	39.26	7732700.0
2005-09-07 10:00:00	QQQ	ETF	39.26	39.37	39.21	39.37	9764300.0
2005-09-07 11:00:00	QQQ	ETF	39.37	39.41	39.3	39.33	6308600.0
2005-09-07 12:00:00	QQQ	ETF	39.33	39.38	39.31	39.37	5001900.0
2005-09-07 13:00:00	QQQ	ETF	39.38	39.42	39.32	39.38	7469400.0
2005-09-07 14:00:00	QQQ	ETF	39.38	39.45	39.32	39.41	7939400.0
2005-09-07 15:00:00	QQQ	ETF	39.41	39.48	38.44	39.41	8351000.0
2005-09-07 08:00:00	IWM	ETF	67.12	67.12	67.06	67.06	300.0
2005-09-07 09:00:00	IWM	ETF	67.06	67.2	66.9	66.93	1283400.0
2005-09-07 10:00:00	IWM	ETF	66.92	67.28	66.88	67.23	2325700.0
2005-09-07 11:00:00	IWM	ETF	67.25	67.31	67.11	67.18	1841900.0
2005-09-07 12:00:00	IWM	ETF	67.18	67.28	67.14	67.22	441100.0
2005-09-07 13:00:00	IWM	ETF	67.23	67.34	67.14	67.27	1234200.0
2005-09-07 14:00:00	IWM	ETF	67.29	67.35	67.1	67.3	2304600.0
2005-09-07 15:00:00	IWM	ETF	67.3	67.47	67.2	67.43	3190400.0
2005-09-07 16:00:00	IWM	ETF	67.42	67.42	67.31	67.33	116400.0
2005-09-07 17:00:00	IWM	ETF	67.36	67.36	67.3	67.3	501200.0
2005-09-07 19:00:00	IWM	ETF	67.32	67.32	67.3	67.3	600.0
2005-09-07 08:00:00	DIA	ETF	105.84	105.88	105.79	105.81	2000.0
2005-09-07 09:00:00	DIA	ETF	105.85	105.95	105.74	105.8	894400.0
2005-09-07 10:00:00	DIA	ETF	105.8	106.02	105.71	105.99	1541800.0
2005-09-07 11:00:00	DIA	ETF	106.0	106.1	105.9	105.99	681400.0
2005-09-07 12:00:00	DIA	ETF	105.99	106.06	105.96	106.02	152000.0
2005-09-07 13:00:00	DIA	ETF	106.01	106.17	105.94	106.08	621200.0
2005-09-07 14:00:00	DIA	ETF	106.09	106.22	105.95	106.19	908800.0
2005-09-07 15:00:00	DIA	ETF	106.18	106.37	106.11	106.28	1844500.0
2005-09-07 16:00:00	DIA	ETF	106.3	106.31	106.18	106.18	476700.0
2005-09-07 17:00:00	DIA	ETF	106.19	106.19	106.19	106.19	200.0
2005-09-07 18:00:00	DIA	ETF	106.14	106.14	106.14	106.14	200.0
2005-09-07 08:00:00	GLD	ETF	44.32	44.47	44.32	44.47	13500.0
2005-09-07 09:00:00	GLD	ETF	44.42	44.49	44.36	44.45	308900.0
2005-09-07 10:00:00	GLD	ETF	44.45	44.49	44.39	44.44	210500.0
2005-09-07 11:00:00	GLD	ETF	44.46	44.46	44.32	44.4	507100.0
2005-09-07 12:00:00	GLD	ETF	44.42	44.45	44.39	44.42	85300.0
2005-09-07 13:00:00	GLD	ETF	44.42	44.45	44.36	44.38	27600.0
2005-09-07 14:00:00	GLD	ETF	44.37	44.37	44.3	44.35	81100.0
2005-09-07 15:00:00	GLD	ETF	44.35	44.35	44.29	44.35	66600.0

> showing 50 of 961 rows — these rows as CSV

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