PREVIEW / etf_1hour / 2005-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-08.parquet
  size:    31 KB
  rows:    927

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-08-08 06:00:00	SPY	ETF	123.24	123.24	123.24	123.24	25000.0
2005-08-08 07:00:00	SPY	ETF	123.21	123.22	123.14	123.15	9000.0
2005-08-08 08:00:00	SPY	ETF	123.13	123.25	123.11	123.2	368100.0
2005-08-08 09:00:00	SPY	ETF	123.2	123.32	123.09	123.26	5531300.0
2005-08-08 10:00:00	SPY	ETF	123.26	123.41	122.76	122.81	13947500.0
2005-08-08 11:00:00	SPY	ETF	122.82	123.05	122.76	122.92	6601000.0
2005-08-08 12:00:00	SPY	ETF	122.92	123.04	122.79	122.91	1832200.0
2005-08-08 13:00:00	SPY	ETF	122.912	122.98	122.62	122.71	4103500.0
2005-08-08 14:00:00	SPY	ETF	122.72	122.73	122.38	122.57	6068700.0
2005-08-08 15:00:00	SPY	ETF	122.57	122.65	122.39	122.42	6941500.0
2005-08-08 16:00:00	SPY	ETF	122.39	122.68	122.39	122.65	903400.0
2005-08-08 17:00:00	SPY	ETF	122.63	122.63	122.57	122.6	4500.0
2005-08-08 18:00:00	SPY	ETF	122.59	122.64	122.56	122.64	3400.0
2005-08-08 19:00:00	SPY	ETF	122.65	122.65	122.53	122.53	12000.0
2005-08-08 09:00:00	QQQ	ETF	39.52	39.57	39.44	39.56	7592100.0
2005-08-08 10:00:00	QQQ	ETF	39.56	39.61	39.31	39.36	15264500.0
2005-08-08 11:00:00	QQQ	ETF	39.36	39.45	39.33	39.4	8574200.0
2005-08-08 12:00:00	QQQ	ETF	39.4	39.43	39.34	39.38	4183400.0
2005-08-08 13:00:00	QQQ	ETF	39.39	39.4	39.25	39.28	6429200.0
2005-08-08 14:00:00	QQQ	ETF	39.28	39.29	39.17	39.25	8463500.0
2005-08-08 15:00:00	QQQ	ETF	39.25	39.28	39.14	39.19	8318900.0
2005-08-08 08:00:00	IWM	ETF	66.12	66.17	66.12	66.17	28900.0
2005-08-08 09:00:00	IWM	ETF	66.18	66.28	66.05	66.16	1998200.0
2005-08-08 10:00:00	IWM	ETF	66.17	66.37	65.67	65.7	4166900.0
2005-08-08 11:00:00	IWM	ETF	65.7	65.92	65.69	65.86	4837800.0
2005-08-08 12:00:00	IWM	ETF	65.87	65.95	65.81	65.9	1133200.0
2005-08-08 13:00:00	IWM	ETF	65.91	65.93	65.71	65.85	1676200.0
2005-08-08 14:00:00	IWM	ETF	65.85	65.85	65.52	65.62	2606200.0
2005-08-08 15:00:00	IWM	ETF	65.62	65.68	65.53	65.673	3085200.0
2005-08-08 16:00:00	IWM	ETF	65.67	65.77	65.65	65.72	471300.0
2005-08-08 17:00:00	IWM	ETF	65.74	65.74	65.74	65.74	100.0
2005-08-08 07:00:00	DIA	ETF	105.85	105.87	105.85	105.87	2600.0
2005-08-08 08:00:00	DIA	ETF	105.85	105.99	105.85	105.99	13300.0
2005-08-08 09:00:00	DIA	ETF	106.0	106.05	105.82	105.984	515500.0
2005-08-08 10:00:00	DIA	ETF	105.99	106.05	105.53	105.57	1221600.0
2005-08-08 11:00:00	DIA	ETF	105.54	105.76	105.53	105.68	733700.0
2005-08-08 12:00:00	DIA	ETF	105.67	105.73	105.56	105.67	287300.0
2005-08-08 13:00:00	DIA	ETF	105.66	105.69	105.41	105.53	1217200.0
2005-08-08 14:00:00	DIA	ETF	105.52	105.52	105.25	105.41	1340800.0
2005-08-08 15:00:00	DIA	ETF	105.4	105.46	105.31	105.38	1168400.0
2005-08-08 16:00:00	DIA	ETF	105.38	105.57	105.36	105.57	6500.0
2005-08-08 09:00:00	GLD	ETF	43.52	43.52	43.46	43.48	178100.0
2005-08-08 10:00:00	GLD	ETF	43.488	43.55	43.47	43.49	248200.0
2005-08-08 11:00:00	GLD	ETF	43.49	43.53	43.42	43.47	276900.0
2005-08-08 12:00:00	GLD	ETF	43.46	43.48	43.36	43.38	109800.0
2005-08-08 13:00:00	GLD	ETF	43.38	43.39	43.27	43.37	157800.0
2005-08-08 14:00:00	GLD	ETF	43.35	43.41	43.34	43.4	41600.0
2005-08-08 15:00:00	GLD	ETF	43.4	43.42	43.34	43.36	92800.0
2005-08-08 08:00:00	TLT	ETF	91.49	91.63	91.49	91.6	2500.0
2005-08-08 09:00:00	TLT	ETF	91.71	91.73	91.64	91.68	241200.0

> showing 50 of 927 rows — these rows as CSV

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