PREVIEW / etf_1hour / 2005-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-24.parquet
  size:    29 KB
  rows:    836

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-24 08:00:00	SPY	ETF	116.91	117.06	116.91	117.04	388100.0
2005-01-24 09:00:00	SPY	ETF	117.04	117.28	116.8	116.84	8555900.0
2005-01-24 10:00:00	SPY	ETF	116.84	117.23	116.74	116.87	14929600.0
2005-01-24 11:00:00	SPY	ETF	116.87	117.25	116.71	117.03	7874100.0
2005-01-24 12:00:00	SPY	ETF	117.03	117.23	116.79	117.03	4321100.0
2005-01-24 13:00:00	SPY	ETF	117.03	117.34	116.95	116.98	3925800.0
2005-01-24 14:00:00	SPY	ETF	116.96	117.16	116.62	116.69	6528000.0
2005-01-24 15:00:00	SPY	ETF	116.69	116.89	116.37	116.42	10093200.0
2005-01-24 16:00:00	SPY	ETF	116.44	116.62	116.37	116.61	786300.0
2005-01-24 17:00:00	SPY	ETF	116.61	116.61	116.55	116.55	109400.0
2005-01-24 18:00:00	SPY	ETF	116.55	116.69	116.55	116.68	9500.0
2005-01-24 19:00:00	SPY	ETF	116.68	116.7	116.66	116.66	2800.0
2005-01-24 09:00:00	QQQ	ETF	37.15	37.2	36.93	36.97	18273700.0
2005-01-24 10:00:00	QQQ	ETF	36.97	37.11	36.86	36.93	25250400.0
2005-01-24 11:00:00	QQQ	ETF	36.93	37.01	36.79	36.92	14917500.0
2005-01-24 12:00:00	QQQ	ETF	36.92	37.0	36.73	36.82	12673700.0
2005-01-24 13:00:00	QQQ	ETF	36.82	36.99	36.8	36.82	10399600.0
2005-01-24 14:00:00	QQQ	ETF	36.82	36.93	36.54	36.6	16619100.0
2005-01-24 15:00:00	QQQ	ETF	36.6	36.71	36.46	36.53	27764000.0
2005-01-24 08:00:00	IWM	ETF	60.91	60.97	60.91	60.97	3400.0
2005-01-24 09:00:00	IWM	ETF	60.985	61.25	60.6715	60.71	4360000.0
2005-01-24 10:00:00	IWM	ETF	60.72	61.025	60.53	60.625	3666400.0
2005-01-24 11:00:00	IWM	ETF	60.64	60.785	60.505	60.695	1169200.0
2005-01-24 12:00:00	IWM	ETF	60.715	60.75	60.55	60.62	1509200.0
2005-01-24 13:00:00	IWM	ETF	60.62	60.835	60.59	60.605	1380000.0
2005-01-24 14:00:00	IWM	ETF	60.605	60.71	60.2	60.29	2397800.0
2005-01-24 15:00:00	IWM	ETF	60.28	60.38	60.085	60.185	3360000.0
2005-01-24 16:00:00	IWM	ETF	60.2	60.38	60.18	60.34	400200.0
2005-01-24 17:00:00	IWM	ETF	60.36	60.36	60.36	60.36	600.0
2005-01-24 18:00:00	IWM	ETF	60.29	60.29	60.29	60.29	4600.0
2005-01-24 08:00:00	DIA	ETF	103.97	104.02	103.93	104.02	17200.0
2005-01-24 09:00:00	DIA	ETF	104.08	104.2	103.8	103.85	778900.0
2005-01-24 10:00:00	DIA	ETF	103.87	104.14	103.73	103.85	2105400.0
2005-01-24 11:00:00	DIA	ETF	103.84	104.14	103.73	103.99	1682100.0
2005-01-24 12:00:00	DIA	ETF	103.98	104.1	103.8	104.08	880300.0
2005-01-24 13:00:00	DIA	ETF	104.06	104.31	104.05	104.06	1386500.0
2005-01-24 14:00:00	DIA	ETF	104.06	104.2	103.74	103.84	1082200.0
2005-01-24 15:00:00	DIA	ETF	103.84	104.01	103.62	103.69	1733200.0
2005-01-24 16:00:00	DIA	ETF	103.64	103.8	103.6	103.6	55900.0
2005-01-24 17:00:00	DIA	ETF	103.75	103.75	103.75	103.75	500.0
2005-01-24 18:00:00	DIA	ETF	103.77	103.83	103.77	103.83	200.0
2005-01-24 19:00:00	DIA	ETF	103.83	103.83	103.83	103.83	1300.0
2005-01-24 09:00:00	GLD	ETF	42.74	42.82	42.72	42.77	298600.0
2005-01-24 10:00:00	GLD	ETF	42.77	42.8	42.72	42.78	204800.0
2005-01-24 11:00:00	GLD	ETF	42.78	42.78	42.68	42.7	114400.0
2005-01-24 12:00:00	GLD	ETF	42.71	42.76	42.69	42.71	1095800.0
2005-01-24 13:00:00	GLD	ETF	42.71	42.74	42.67	42.73	253500.0
2005-01-24 14:00:00	GLD	ETF	42.73	42.74	42.67	42.71	89400.0
2005-01-24 15:00:00	GLD	ETF	42.71	42.78	42.71	42.77	237700.0
2005-01-24 16:00:00	GLD	ETF	42.79	42.79	42.79	42.79	300.0

> showing 50 of 836 rows — these rows as CSV

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