PREVIEW / etf_1hour / 2005-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-09.parquet
  size:    31 KB
  rows:    958

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-09-09 07:00:00	SPY	ETF	123.61	123.79	123.61	123.76	21600.0
2005-09-09 08:00:00	SPY	ETF	123.76	123.86	123.68	123.81	386400.0
2005-09-09 09:00:00	SPY	ETF	123.81	124.01	123.57	123.86	5490100.0
2005-09-09 10:00:00	SPY	ETF	123.86	124.13	123.84	123.97	4697700.0
2005-09-09 11:00:00	SPY	ETF	123.96	124.46	123.87	124.43	7417100.0
2005-09-09 12:00:00	SPY	ETF	124.44	124.57	124.39	124.45	4312300.0
2005-09-09 13:00:00	SPY	ETF	124.45	124.74	124.4	124.63	7384100.0
2005-09-09 14:00:00	SPY	ETF	124.63	124.68	124.5	124.6	2841900.0
2005-09-09 15:00:00	SPY	ETF	124.6	124.66	124.44	124.48	7415700.0
2005-09-09 16:00:00	SPY	ETF	124.48	124.66	124.45	124.61	702900.0
2005-09-09 17:00:00	SPY	ETF	124.65	124.69	124.61	124.62	8100.0
2005-09-09 18:00:00	SPY	ETF	124.61	124.62	124.6	124.6	2800.0
2005-09-09 19:00:00	SPY	ETF	124.67	124.67	124.67	124.67	100.0
2005-09-09 09:00:00	QQQ	ETF	39.41	39.46	39.31	39.36	7840000.0
2005-09-09 10:00:00	QQQ	ETF	39.36	39.47	39.34	39.39	8073300.0
2005-09-09 11:00:00	QQQ	ETF	39.39	39.62	39.37	39.59	10911900.0
2005-09-09 12:00:00	QQQ	ETF	39.59	39.67	39.58	39.6	8136600.0
2005-09-09 13:00:00	QQQ	ETF	39.6	39.69	39.57	39.66	5569500.0
2005-09-09 14:00:00	QQQ	ETF	39.66	39.67	39.55	39.62	6515200.0
2005-09-09 15:00:00	QQQ	ETF	39.62	39.68	39.59	39.63	16181700.0
2005-09-09 08:00:00	IWM	ETF	67.02	67.02	67.02	67.02	1500000.0
2005-09-09 09:00:00	IWM	ETF	67.18	67.35	67.09	67.12	884800.0
2005-09-09 10:00:00	IWM	ETF	67.12	67.31	67.05	67.21	2860800.0
2005-09-09 11:00:00	IWM	ETF	67.21	67.48	67.14	67.48	5927800.0
2005-09-09 12:00:00	IWM	ETF	67.47	67.5	67.38	67.39	1437400.0
2005-09-09 13:00:00	IWM	ETF	67.38	67.45	67.31	67.43	2824900.0
2005-09-09 14:00:00	IWM	ETF	67.43	67.46	67.32	67.4	2591000.0
2005-09-09 15:00:00	IWM	ETF	67.41	67.53	67.37	67.48	3752400.0
2005-09-09 16:00:00	IWM	ETF	67.5	67.58	67.39	67.47	74900.0
2005-09-09 07:00:00	DIA	ETF	106.47	106.47	106.47	106.47	200.0
2005-09-09 08:00:00	DIA	ETF	106.2	106.46	106.16	106.16	600.0
2005-09-09 09:00:00	DIA	ETF	106.14	106.23	106.06	106.14	541700.0
2005-09-09 10:00:00	DIA	ETF	106.15	106.4	106.12	106.3	1650900.0
2005-09-09 11:00:00	DIA	ETF	106.29	106.7	106.23	106.69	1264200.0
2005-09-09 12:00:00	DIA	ETF	106.7	106.83	106.67	106.7	401600.0
2005-09-09 13:00:00	DIA	ETF	106.7	106.93	106.66	106.83	1160800.0
2005-09-09 14:00:00	DIA	ETF	106.82	106.83	106.68	106.77	1002400.0
2005-09-09 15:00:00	DIA	ETF	106.78	106.88	106.67	106.71	965600.0
2005-09-09 16:00:00	DIA	ETF	106.79	106.82	106.74	106.82	7700.0
2005-09-09 17:00:00	DIA	ETF	106.84	106.85	106.84	106.85	1900.0
2005-09-09 18:00:00	DIA	ETF	106.82	106.82	106.82	106.82	100.0
2005-09-09 19:00:00	DIA	ETF	106.79	106.79	106.79	106.79	100.0
2005-09-09 08:00:00	GLD	ETF	44.76	44.8	44.76	44.8	1100.0
2005-09-09 09:00:00	GLD	ETF	44.74	44.744	44.66	44.73	251900.0
2005-09-09 10:00:00	GLD	ETF	44.73	44.83	44.66	44.8	279700.0
2005-09-09 11:00:00	GLD	ETF	44.81	44.85	44.7715	44.79	202800.0
2005-09-09 12:00:00	GLD	ETF	44.79	44.84	44.75	44.79	124900.0
2005-09-09 13:00:00	GLD	ETF	44.8	44.82	44.78	44.82	272000.0
2005-09-09 14:00:00	GLD	ETF	44.81	44.83	44.8	44.82	98900.0
2005-09-09 15:00:00	GLD	ETF	44.83	44.87	44.82	44.87	122900.0

> showing 50 of 958 rows — these rows as CSV

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