PREVIEW / etf_1hour / 2005-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-28.parquet
  size:    29 KB
  rows:    829

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-01-28 08:00:00	SPY	ETF	117.55	117.65	117.42	117.58	552300.0
2005-01-28 09:00:00	SPY	ETF	117.57	117.59	117.33	117.37	5919100.0
2005-01-28 10:00:00	SPY	ETF	117.39	117.55	117.19	117.24	9365300.0
2005-01-28 11:00:00	SPY	ETF	117.23	117.48	116.61	116.8	13303200.0
2005-01-28 12:00:00	SPY	ETF	116.8	116.89	116.65	116.71	4159900.0
2005-01-28 13:00:00	SPY	ETF	116.71	116.96	116.63	116.78	5744400.0
2005-01-28 14:00:00	SPY	ETF	116.77	116.97	116.63	116.81	5095900.0
2005-01-28 15:00:00	SPY	ETF	116.81	117.21	116.71	117.13	11667200.0
2005-01-28 16:00:00	SPY	ETF	117.15	117.49	117.09	117.47	1250700.0
2005-01-28 17:00:00	SPY	ETF	117.43	117.5	117.37	117.5	39200.0
2005-01-28 18:00:00	SPY	ETF	117.5	117.52	117.45	117.45	3600.0
2005-01-28 19:00:00	SPY	ETF	117.45	117.54	117.45	117.54	2300.0
2005-01-28 09:00:00	QQQ	ETF	37.22	37.27	37.08	37.15	13129800.0
2005-01-28 10:00:00	QQQ	ETF	37.15	37.19	36.95	36.96	16566600.0
2005-01-28 11:00:00	QQQ	ETF	36.96	36.97	36.62	36.72	26488900.0
2005-01-28 12:00:00	QQQ	ETF	36.72	36.78	36.65	36.7	8791600.0
2005-01-28 13:00:00	QQQ	ETF	36.7	36.79	36.65	36.71	7200000.0
2005-01-28 14:00:00	QQQ	ETF	36.7	36.86	36.63	36.78	9720600.0
2005-01-28 15:00:00	QQQ	ETF	36.78	37.74	36.71	36.91	18318600.0
2005-01-28 08:00:00	IWM	ETF	61.15	61.565	61.15	61.565	2400.0
2005-01-28 09:00:00	IWM	ETF	61.56	61.65	61.255	61.29	2193400.0
2005-01-28 10:00:00	IWM	ETF	61.295	61.525	61.16	61.3	4001600.0
2005-01-28 11:00:00	IWM	ETF	61.295	61.34	60.775	60.915	4369000.0
2005-01-28 12:00:00	IWM	ETF	60.92	61.09	60.885	60.92	1441200.0
2005-01-28 13:00:00	IWM	ETF	60.92	61.06	60.835	60.865	2370400.0
2005-01-28 14:00:00	IWM	ETF	60.875	60.955	60.685	60.85	2073000.0
2005-01-28 15:00:00	IWM	ETF	60.835	61.24	60.775	61.095	2938800.0
2005-01-28 16:00:00	IWM	ETF	61.105	61.39	60.945	61.39	950600.0
2005-01-28 17:00:00	IWM	ETF	61.395	61.395	61.395	61.395	800.0
2005-01-28 08:00:00	DIA	ETF	104.68	104.68	104.54	104.54	8400.0
2005-01-28 09:00:00	DIA	ETF	104.57	104.65	104.42	104.5	631600.0
2005-01-28 10:00:00	DIA	ETF	104.51	104.65	104.35	104.43	1069700.0
2005-01-28 11:00:00	DIA	ETF	104.42	104.5	103.87	103.97	1898600.0
2005-01-28 12:00:00	DIA	ETF	103.97	104.05	103.85	103.88	921000.0
2005-01-28 13:00:00	DIA	ETF	103.88	104.04	103.82	103.9	539900.0
2005-01-28 14:00:00	DIA	ETF	103.91	104.03	103.76	103.89	811400.0
2005-01-28 15:00:00	DIA	ETF	103.92	104.25	103.82	104.15	1577400.0
2005-01-28 16:00:00	DIA	ETF	104.15	104.45	104.15	104.45	267500.0
2005-01-28 17:00:00	DIA	ETF	104.45	104.45	104.45	104.45	1100.0
2005-01-28 18:00:00	DIA	ETF	104.45	104.5	104.45	104.5	3000.0
2005-01-28 19:00:00	DIA	ETF	104.53	104.53	104.53	104.53	300.0
2005-01-28 09:00:00	GLD	ETF	42.71	42.73	42.67	42.68	129800.0
2005-01-28 10:00:00	GLD	ETF	42.69	42.69	42.43	42.5	241200.0
2005-01-28 11:00:00	GLD	ETF	42.5	42.6	42.47	42.59	165300.0
2005-01-28 12:00:00	GLD	ETF	42.57	42.62	42.51	42.51	272500.0
2005-01-28 13:00:00	GLD	ETF	42.51	42.61	42.48	42.61	151800.0
2005-01-28 14:00:00	GLD	ETF	42.61	42.69	42.61	42.69	86000.0
2005-01-28 15:00:00	GLD	ETF	42.69	42.69	42.63	42.69	102300.0
2005-01-28 16:00:00	GLD	ETF	42.6	42.6	42.6	42.6	200.0
2005-01-28 08:00:00	TLT	ETF	91.0	91.3	90.91	91.14	27400.0

> showing 50 of 829 rows — these rows as CSV

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