PREVIEW / etf_1hour / 2004-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-16.parquet
  size:    24 KB
  rows:    667

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-06-16 08:00:00	SPY	ETF	114.2	114.25	114.0	114.01	63800.0
2004-06-16 09:00:00	SPY	ETF	114.01	114.05	113.7	113.79	3764900.0
2004-06-16 10:00:00	SPY	ETF	113.79	114.15	113.72	114.04	5105200.0
2004-06-16 11:00:00	SPY	ETF	114.04	114.06	113.8	113.97	2654300.0
2004-06-16 12:00:00	SPY	ETF	113.96	114.07	113.8	113.99	2361800.0
2004-06-16 13:00:00	SPY	ETF	114.0	114.01	113.77	113.93	2189000.0
2004-06-16 14:00:00	SPY	ETF	113.93	114.11	113.87	114.0	3360000.0
2004-06-16 15:00:00	SPY	ETF	114.0	114.2	113.96	114.02	5075900.0
2004-06-16 16:00:00	SPY	ETF	113.99	114.1	113.87	113.98	1334700.0
2004-06-16 17:00:00	SPY	ETF	113.98	114.03	113.93	113.98	75200.0
2004-06-16 18:00:00	SPY	ETF	113.95	113.96	113.91	113.91	3600.0
2004-06-16 19:00:00	SPY	ETF	113.96	113.96	113.96	113.96	100.0
2004-06-16 08:00:00	QQQ	ETF	36.85	36.86	36.75	36.75	97500.0
2004-06-16 09:00:00	QQQ	ETF	36.75	36.79	36.65	36.72	8712200.0
2004-06-16 10:00:00	QQQ	ETF	36.72	36.87	36.68	36.82	11367400.0
2004-06-16 11:00:00	QQQ	ETF	36.81	36.82	36.68	36.74	8646700.0
2004-06-16 12:00:00	QQQ	ETF	36.741	36.782	36.65	36.76	6347300.0
2004-06-16 13:00:00	QQQ	ETF	36.766	36.79	36.66	36.72	4970200.0
2004-06-16 14:00:00	QQQ	ETF	36.72	36.84	36.71	36.804	8499100.0
2004-06-16 15:00:00	QQQ	ETF	36.802	36.9	36.78	36.8	11059500.0
2004-06-16 16:00:00	QQQ	ETF	36.82	36.82	36.65	36.68	3265200.0
2004-06-16 17:00:00	QQQ	ETF	36.69	36.69	36.62	36.63	985900.0
2004-06-16 18:00:00	QQQ	ETF	36.61	36.66	36.61	36.66	490000.0
2004-06-16 19:00:00	QQQ	ETF	36.66	36.66	36.65	36.65	4000.0
2004-06-16 08:00:00	IWM	ETF	56.83	56.85	56.75	56.75	5000.0
2004-06-16 09:00:00	IWM	ETF	56.66	56.735	56.46	56.525	1417400.0
2004-06-16 10:00:00	IWM	ETF	56.53	56.87	56.47	56.79	1809600.0
2004-06-16 11:00:00	IWM	ETF	56.79	56.8	56.62	56.73	743400.0
2004-06-16 12:00:00	IWM	ETF	56.74	56.8	56.61	56.76	405400.0
2004-06-16 13:00:00	IWM	ETF	56.76	56.775	56.615	56.765	169200.0
2004-06-16 14:00:00	IWM	ETF	56.77	56.895	56.735	56.8	405400.0
2004-06-16 15:00:00	IWM	ETF	56.8	56.955	56.785	56.91	837600.0
2004-06-16 16:00:00	IWM	ETF	56.89	56.905	56.85	56.895	2778000.0
2004-06-16 17:00:00	IWM	ETF	56.82	56.82	56.81	56.81	4000.0
2004-06-16 08:00:00	DIA	ETF	104.29	104.34	104.2	104.2	2600.0
2004-06-16 09:00:00	DIA	ETF	104.15	104.15	103.76	103.83	462300.0
2004-06-16 10:00:00	DIA	ETF	103.85	104.08	103.77	103.96	758200.0
2004-06-16 11:00:00	DIA	ETF	103.96	104.0	103.82	103.94	807100.0
2004-06-16 12:00:00	DIA	ETF	103.93	104.0	103.82	103.98	356500.0
2004-06-16 13:00:00	DIA	ETF	103.99	103.99	103.84	103.96	155000.0
2004-06-16 14:00:00	DIA	ETF	103.97	104.08	103.92	103.99	428100.0
2004-06-16 15:00:00	DIA	ETF	104.012	104.15	103.95	104.02	479500.0
2004-06-16 16:00:00	DIA	ETF	104.01	104.03	103.96	103.99	337200.0
2004-06-16 17:00:00	DIA	ETF	104.05	104.05	104.05	104.05	400.0
2004-06-16 18:00:00	DIA	ETF	103.94	103.94	103.94	103.94	300.0
2004-06-16 09:00:00	TLT	ETF	82.05	82.12	82.01	82.07	74400.0
2004-06-16 10:00:00	TLT	ETF	82.07	82.18	81.99	82.01	50700.0
2004-06-16 11:00:00	TLT	ETF	82.07	82.2	82.0	82.18	151900.0
2004-06-16 12:00:00	TLT	ETF	82.19	82.23	82.17	82.22	9500.0
2004-06-16 13:00:00	TLT	ETF	82.28	82.33	82.19	82.22	57700.0

> showing 50 of 667 rows — these rows as CSV

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