PREVIEW / etf_1hour / 2004-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-17.parquet
  size:    24 KB
  rows:    679

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
2004-08-17 08:00:00	SPY	ETF	108.68	108.99	108.59	108.87	516400.0
2004-08-17 09:00:00	SPY	ETF	108.87	109.28	108.67	109.11	6694400.0
2004-08-17 10:00:00	SPY	ETF	109.1	109.18	108.78	108.82	8455900.0
2004-08-17 11:00:00	SPY	ETF	108.82	108.9	108.61	108.75	5288900.0
2004-08-17 12:00:00	SPY	ETF	108.75	108.95	108.71	108.9	2625000.0
2004-08-17 13:00:00	SPY	ETF	108.91	108.95	108.71	108.85	1978200.0
2004-08-17 14:00:00	SPY	ETF	108.85	108.95	108.58	108.8	5113700.0
2004-08-17 15:00:00	SPY	ETF	108.82	108.84	108.53	108.71	6675900.0
2004-08-17 16:00:00	SPY	ETF	108.72	108.96	108.65	108.86	1655000.0
2004-08-17 17:00:00	SPY	ETF	108.99	108.99	108.77	108.83	69400.0
2004-08-17 18:00:00	SPY	ETF	108.77	108.81	108.76	108.81	62100.0
2004-08-17 19:00:00	SPY	ETF	108.8	108.8	108.71	108.77	17100.0
2004-08-17 08:00:00	QQQ	ETF	33.05	33.19	33.02	33.14	699600.0
2004-08-17 09:00:00	QQQ	ETF	33.14	33.44	33.1	33.344	19185600.0
2004-08-17 10:00:00	QQQ	ETF	33.34	33.38	33.18	33.27	13619600.0
2004-08-17 11:00:00	QQQ	ETF	33.27	33.28	33.1	33.2	10568700.0
2004-08-17 12:00:00	QQQ	ETF	33.198	33.35	33.189	33.337	6851700.0
2004-08-17 13:00:00	QQQ	ETF	33.339	33.35	33.25	33.31	6902600.0
2004-08-17 14:00:00	QQQ	ETF	33.314	33.33	33.164	33.27	9344200.0
2004-08-17 15:00:00	QQQ	ETF	33.27	33.29	33.15	33.17	13085300.0
2004-08-17 16:00:00	QQQ	ETF	33.171	33.27	33.15	33.242	2408000.0
2004-08-17 17:00:00	QQQ	ETF	33.25	33.29	33.22	33.28	174200.0
2004-08-17 18:00:00	QQQ	ETF	33.28	33.28	33.26	33.27	13600.0
2004-08-17 19:00:00	QQQ	ETF	33.27	33.27	33.22	33.22	28400.0
2004-08-17 08:00:00	IWM	ETF	53.035	53.045	52.94	52.94	18200.0
2004-08-17 09:00:00	IWM	ETF	52.94	53.225	52.79	53.1	1948600.0
2004-08-17 10:00:00	IWM	ETF	53.11	53.15	52.795	52.875	2040000.0
2004-08-17 11:00:00	IWM	ETF	52.895	52.925	52.77	52.835	1147200.0
2004-08-17 12:00:00	IWM	ETF	52.83	52.99	52.825	52.95	647200.0
2004-08-17 13:00:00	IWM	ETF	52.94	52.98	52.845	52.955	776000.0
2004-08-17 14:00:00	IWM	ETF	52.955	52.955	52.67	52.78	1168800.0
2004-08-17 15:00:00	IWM	ETF	52.805	52.88	52.675	52.81	1271000.0
2004-08-17 16:00:00	IWM	ETF	52.805	52.89	52.77	52.87	355800.0
2004-08-17 08:00:00	DIA	ETF	100.15	100.31	100.07	100.26	46100.0
2004-08-17 09:00:00	DIA	ETF	100.26	100.59	100.16	100.42	1125200.0
2004-08-17 10:00:00	DIA	ETF	100.42	100.47	100.14	100.16	454000.0
2004-08-17 11:00:00	DIA	ETF	100.15	100.19	99.93	100.05	847700.0
2004-08-17 12:00:00	DIA	ETF	100.04	100.21	100.01	100.19	306900.0
2004-08-17 13:00:00	DIA	ETF	100.2	100.23	100.0	100.08	381600.0
2004-08-17 14:00:00	DIA	ETF	100.08	100.2	99.86	100.1	409100.0
2004-08-17 15:00:00	DIA	ETF	100.12	100.12	99.86	100.09	438600.0
2004-08-17 16:00:00	DIA	ETF	100.1	100.25	99.98	100.2	570700.0
2004-08-17 08:00:00	TLT	ETF	86.5	86.5	86.35	86.35	1100.0
2004-08-17 09:00:00	TLT	ETF	86.35	86.53	86.35	86.38	12700.0
2004-08-17 10:00:00	TLT	ETF	86.42	86.5	86.38	86.4	10500.0
2004-08-17 11:00:00	TLT	ETF	86.48	86.57	86.41	86.53	10100.0
2004-08-17 12:00:00	TLT	ETF	86.55	86.69	86.55	86.66	17900.0
2004-08-17 13:00:00	TLT	ETF	86.56	86.67	86.56	86.67	11900.0
2004-08-17 14:00:00	TLT	ETF	86.65	86.74	86.65	86.74	14600.0
2004-08-17 15:00:00	TLT	ETF	86.71	86.85	86.71	86.79	88700.0

> showing 50 of 679 rows — these rows as CSV

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