PREVIEW / etf_1hour / 2003-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-19.parquet
  size:    17 KB
  rows:    432

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
2003-09-19 08:00:00	SPY	ETF	104.06	104.26	104.03	104.21	73100.0
2003-09-19 09:00:00	SPY	ETF	104.33	104.34	103.82	103.92	3985500.0
2003-09-19 10:00:00	SPY	ETF	103.89	104.16	103.57	103.69	5760700.0
2003-09-19 11:00:00	SPY	ETF	103.71	103.93	103.66	103.82	2584500.0
2003-09-19 12:00:00	SPY	ETF	103.82	103.96	103.649	103.68	1672300.0
2003-09-19 13:00:00	SPY	ETF	103.67	103.77	103.53	103.57	1687800.0
2003-09-19 14:00:00	SPY	ETF	103.57	103.8	103.4	103.79	2687400.0
2003-09-19 15:00:00	SPY	ETF	103.78	103.98	103.68	103.86	3396600.0
2003-09-19 16:00:00	SPY	ETF	103.84	104.1	103.58	103.58	6433400.0
2003-09-19 17:00:00	SPY	ETF	103.58	103.73	103.51	103.69	48400.0
2003-09-19 18:00:00	SPY	ETF	103.69	103.71	103.65	103.7	17800.0
2003-09-19 19:00:00	SPY	ETF	103.7	103.7	103.67	103.67	3400.0
2003-09-19 08:00:00	QQQ	ETF	34.71	34.77	34.67	34.77	71300.0
2003-09-19 09:00:00	QQQ	ETF	34.77	34.84	34.58	34.635	8180200.0
2003-09-19 10:00:00	QQQ	ETF	34.64	34.79	34.47	34.54	17412900.0
2003-09-19 11:00:00	QQQ	ETF	34.54	34.653	34.48	34.61	6820200.0
2003-09-19 12:00:00	QQQ	ETF	34.61	34.68	34.55	34.57	6007500.0
2003-09-19 13:00:00	QQQ	ETF	34.57	34.6	34.4	34.44	6053700.0
2003-09-19 14:00:00	QQQ	ETF	34.46	34.6	34.36	34.576	7909300.0
2003-09-19 15:00:00	QQQ	ETF	34.57	34.67	34.51	34.6	7972700.0
2003-09-19 16:00:00	QQQ	ETF	34.6	34.64	34.5	34.53	1810700.0
2003-09-19 17:00:00	QQQ	ETF	34.51	34.57	34.48	34.57	93500.0
2003-09-19 18:00:00	QQQ	ETF	34.54	34.55	34.47	34.47	6800.0
2003-09-19 19:00:00	QQQ	ETF	34.54	34.55	34.48	34.55	2100.0
2003-09-19 09:00:00	IWM	ETF	51.95	51.95	51.545	51.62	404800.0
2003-09-19 10:00:00	IWM	ETF	51.64	51.85	51.615	51.75	774400.0
2003-09-19 11:00:00	IWM	ETF	51.735	51.89	51.625	51.85	184400.0
2003-09-19 12:00:00	IWM	ETF	51.835	51.935	51.835	51.915	114200.0
2003-09-19 13:00:00	IWM	ETF	51.905	51.93	51.85	51.85	135400.0
2003-09-19 14:00:00	IWM	ETF	51.8	51.885	51.71	51.88	337600.0
2003-09-19 15:00:00	IWM	ETF	51.885	51.95	51.8	51.84	389800.0
2003-09-19 16:00:00	IWM	ETF	51.78	51.83	51.67	51.8	257800.0
2003-09-19 08:00:00	DIA	ETF	96.45	96.73	96.45	96.66	11600.0
2003-09-19 09:00:00	DIA	ETF	96.73	96.99	96.55	96.72	673600.0
2003-09-19 10:00:00	DIA	ETF	96.74	96.88	96.36	96.46	1157400.0
2003-09-19 11:00:00	DIA	ETF	96.44	96.68	96.4	96.55	768300.0
2003-09-19 12:00:00	DIA	ETF	96.57	96.68	96.41	96.43	253600.0
2003-09-19 13:00:00	DIA	ETF	96.41	96.52	96.32	96.35	342500.0
2003-09-19 14:00:00	DIA	ETF	96.33	96.57	96.21	96.51	619400.0
2003-09-19 15:00:00	DIA	ETF	96.53	96.65	96.45	96.56	451900.0
2003-09-19 16:00:00	DIA	ETF	96.62	96.62	96.4	96.43	210400.0
2003-09-19 17:00:00	DIA	ETF	96.47	96.51	96.45	96.51	3200.0
2003-09-19 18:00:00	DIA	ETF	96.55	96.58	96.55	96.58	400.0
2003-09-19 19:00:00	DIA	ETF	96.53	96.53	96.53	96.53	200.0
2003-09-19 09:00:00	TLT	ETF	85.65	85.84	85.58	85.82	141300.0
2003-09-19 10:00:00	TLT	ETF	85.84	85.99	85.7	85.85	285000.0
2003-09-19 11:00:00	TLT	ETF	85.85	85.87	85.49	85.7	36900.0
2003-09-19 12:00:00	TLT	ETF	85.7	86.03	85.63	85.95	144100.0
2003-09-19 13:00:00	TLT	ETF	85.95	86.0	85.71	85.82	62600.0
2003-09-19 14:00:00	TLT	ETF	85.78	85.87	85.75	85.8	27200.0

> showing 50 of 432 rows — these rows as CSV

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