PREVIEW / etf_1hour / 2006-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-17.parquet
  size:    49 KB
  rows:    1,531

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
2006-07-17 04:00:00	SPY	ETF	123.1	123.1	123.06	123.06	1500.0
2006-07-17 05:00:00	SPY	ETF	123.11	123.23	123.11	123.16	6400.0
2006-07-17 06:00:00	SPY	ETF	123.6	123.6	123.15	123.25	99200.0
2006-07-17 07:00:00	SPY	ETF	123.38	123.72	123.17	123.3	531300.0
2006-07-17 08:00:00	SPY	ETF	123.29	123.7	123.11	123.32	2100400.0
2006-07-17 09:00:00	SPY	ETF	123.3	124.1	123.2	123.81	19078900.0
2006-07-17 10:00:00	SPY	ETF	123.81	123.88	123.15	123.68	18208200.0
2006-07-17 11:00:00	SPY	ETF	123.68	123.88	123.45	123.68	11143700.0
2006-07-17 12:00:00	SPY	ETF	123.69	123.83	123.45	123.59	6051600.0
2006-07-17 13:00:00	SPY	ETF	123.58	123.78	123.5	123.68	6488000.0
2006-07-17 14:00:00	SPY	ETF	123.68	123.84	123.48	123.53	5370100.0
2006-07-17 15:00:00	SPY	ETF	123.52	123.71	123.29	123.41	9308400.0
2006-07-17 16:00:00	SPY	ETF	123.39	123.45	123.18	123.41	1996900.0
2006-07-17 17:00:00	SPY	ETF	123.43	123.46	123.32	123.4	71500.0
2006-07-17 18:00:00	SPY	ETF	123.41	123.45	123.35	123.38	62500.0
2006-07-17 19:00:00	SPY	ETF	123.39	123.39	123.39	123.39	600.0
2006-07-17 09:00:00	QQQ	ETF	35.95	36.25	35.95	36.07	26624300.0
2006-07-17 10:00:00	QQQ	ETF	36.08	36.15	35.87	36.12	28523900.0
2006-07-17 11:00:00	QQQ	ETF	36.13	36.24	36.02	36.11	19523200.0
2006-07-17 12:00:00	QQQ	ETF	36.11	36.19	36.0	36.08	10454600.0
2006-07-17 13:00:00	QQQ	ETF	36.07	36.18	36.04	36.14	9815700.0
2006-07-17 14:00:00	QQQ	ETF	36.15	36.2	36.05	36.09	7805700.0
2006-07-17 15:00:00	QQQ	ETF	36.09	36.12	35.96	36.04	16302600.0
2006-07-17 08:00:00	IWM	ETF	67.45	67.45	67.25	67.4	852100.0
2006-07-17 09:00:00	IWM	ETF	67.41	68.2	67.39	67.57	10119600.0
2006-07-17 10:00:00	IWM	ETF	67.57	67.66	67.03	67.64	16622200.0
2006-07-17 11:00:00	IWM	ETF	67.64	67.88	67.35	67.58	15096800.0
2006-07-17 12:00:00	IWM	ETF	67.58	67.7	67.35	67.53	3761600.0
2006-07-17 13:00:00	IWM	ETF	67.52	67.67	67.38	67.6	5692000.0
2006-07-17 14:00:00	IWM	ETF	67.6	67.74	67.39	67.43	4345500.0
2006-07-17 15:00:00	IWM	ETF	67.43	67.5	67.19	67.28	7062900.0
2006-07-17 16:00:00	IWM	ETF	67.27	67.5	67.25	67.5	433300.0
2006-07-17 17:00:00	IWM	ETF	67.45	67.45	67.41	67.41	10300.0
2006-07-17 07:00:00	DIA	ETF	107.25	107.27	107.16	107.27	4500.0
2006-07-17 08:00:00	DIA	ETF	107.18	107.41	107.12	107.27	23000.0
2006-07-17 09:00:00	DIA	ETF	107.3	108.07	107.3	107.69	2388500.0
2006-07-17 10:00:00	DIA	ETF	107.63	107.75	107.17	107.72	1877600.0
2006-07-17 11:00:00	DIA	ETF	107.69	107.88	107.46	107.66	1444700.0
2006-07-17 12:00:00	DIA	ETF	107.66	107.75	107.4	107.57	598300.0
2006-07-17 13:00:00	DIA	ETF	107.54	107.73	107.49	107.7	439500.0
2006-07-17 14:00:00	DIA	ETF	107.7	107.83	107.53	107.57	464500.0
2006-07-17 15:00:00	DIA	ETF	107.56	107.7	107.34	107.48	663200.0
2006-07-17 16:00:00	DIA	ETF	107.44	107.56	107.44	107.5	106800.0
2006-07-17 06:00:00	GLD	ETF	66.35	66.35	66.35	66.35	200.0
2006-07-17 07:00:00	GLD	ETF	66.15	66.15	65.8	65.91	10800.0
2006-07-17 08:00:00	GLD	ETF	65.85	66.09	65.24	65.55	385200.0
2006-07-17 09:00:00	GLD	ETF	65.45	65.45	64.62	65.0792	2525000.0
2006-07-17 10:00:00	GLD	ETF	65.07	65.08	64.0	64.38	2541600.0
2006-07-17 11:00:00	GLD	ETF	64.39	64.79	64.26	64.49	1009900.0
2006-07-17 12:00:00	GLD	ETF	64.5092	64.9799	64.5	64.5	769100.0

> showing 50 of 1,531 rows — these rows as CSV

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