PREVIEW / etf_1hour / 2008-12-26

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-26.parquet
  size:    116 KB
  rows:    3,560

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
2008-12-26 07:00:00	SPY	ETF	87.04	87.37	86.98	87.21	110853.0
2008-12-26 08:00:00	SPY	ETF	87.21	87.34	87.17	87.2	406140.0
2008-12-26 09:00:00	SPY	ETF	87.18	87.3	86.91	86.94	7582427.0
2008-12-26 10:00:00	SPY	ETF	86.93	87.15	86.76	86.87	10251044.0
2008-12-26 11:00:00	SPY	ETF	86.87	86.95	86.68	86.83	8015136.0
2008-12-26 12:00:00	SPY	ETF	86.82	86.93	86.5	86.59	7685898.0
2008-12-26 13:00:00	SPY	ETF	86.59	86.83	86.55	86.67	9214685.0
2008-12-26 14:00:00	SPY	ETF	86.669	86.97	86.64	86.96	10025101.0
2008-12-26 15:00:00	SPY	ETF	86.95	87.2799	86.83	87.13	17231022.0
2008-12-26 16:00:00	SPY	ETF	87.14	87.22	87.01	87.1	1095630.0
2008-12-26 17:00:00	SPY	ETF	87.16	87.2	87.13	87.18	4096.0
2008-12-26 18:00:00	SPY	ETF	87.16	87.18	87.12	87.12	1930.0
2008-12-26 19:00:00	SPY	ETF	87.13	87.16	87.12	87.16	4311.0
2008-12-26 07:00:00	QQQ	ETF	29.16	29.23	29.14	29.23	29622.0
2008-12-26 08:00:00	QQQ	ETF	29.2	29.25	29.19	29.22	191913.0
2008-12-26 09:00:00	QQQ	ETF	29.22	29.23	29.07	29.07	1827390.0
2008-12-26 10:00:00	QQQ	ETF	29.08	29.14	29.04	29.09	2188462.0
2008-12-26 11:00:00	QQQ	ETF	29.09	29.11	28.97	29.04	2529243.0
2008-12-26 12:00:00	QQQ	ETF	29.05	29.08	28.97	28.99	1942216.0
2008-12-26 13:00:00	QQQ	ETF	28.99	29.08	28.98	29.05	3023152.0
2008-12-26 14:00:00	QQQ	ETF	29.05	29.14	29.04	29.1295	2539789.0
2008-12-26 15:00:00	QQQ	ETF	29.13	29.2	29.09	29.14	6088096.0
2008-12-26 16:00:00	QQQ	ETF	29.14	29.2	29.02	29.14	525940.0
2008-12-26 17:00:00	QQQ	ETF	29.18	29.21	29.15	29.21	5785.0
2008-12-26 18:00:00	QQQ	ETF	29.21	29.22	29.2	29.2	6565.0
2008-12-26 19:00:00	QQQ	ETF	29.17	29.2	29.15	29.16	2815.0
2008-12-26 06:00:00	IWM	ETF	47.33	47.33	47.33	47.33	100.0
2008-12-26 07:00:00	IWM	ETF	47.5	47.51	47.37	47.51	5450.0
2008-12-26 08:00:00	IWM	ETF	47.44	47.54	47.27	47.32	173492.0
2008-12-26 09:00:00	IWM	ETF	47.31	47.54	47.09	47.118	2769348.0
2008-12-26 10:00:00	IWM	ETF	47.12	47.25	46.95	47.04	2287148.0
2008-12-26 11:00:00	IWM	ETF	47.04	47.18	46.97	47.09	1772725.0
2008-12-26 12:00:00	IWM	ETF	47.09	47.12	46.73	46.7825	1801249.0
2008-12-26 13:00:00	IWM	ETF	46.78	47.01	46.73	46.948	2568767.0
2008-12-26 14:00:00	IWM	ETF	46.9499	47.48	46.9499	47.41	3720831.0
2008-12-26 15:00:00	IWM	ETF	47.41	47.67	47.28	47.59	7386553.0
2008-12-26 16:00:00	IWM	ETF	47.59	47.61	47.2411	47.46	2327871.0
2008-12-26 17:00:00	IWM	ETF	47.44	47.44	47.32	47.32	2458.0
2008-12-26 19:00:00	IWM	ETF	47.49	47.5	47.49	47.5	500.0
2008-12-26 04:00:00	DIA	ETF	85.49	85.49	85.49	85.49	100.0
2008-12-26 07:00:00	DIA	ETF	84.89	85.08	84.89	85.08	1644.0
2008-12-26 08:00:00	DIA	ETF	85.05	85.1	84.9	84.99	4146.0
2008-12-26 09:00:00	DIA	ETF	84.92	85.11	84.89	85.0	674744.0
2008-12-26 10:00:00	DIA	ETF	85.0	85.28	84.89	85.0201	752554.0
2008-12-26 11:00:00	DIA	ETF	85.01	85.068	84.89	84.94	517102.0
2008-12-26 12:00:00	DIA	ETF	84.94	85.02	84.56	84.66	518716.0
2008-12-26 13:00:00	DIA	ETF	84.67	84.9	84.62	84.74	478254.0
2008-12-26 14:00:00	DIA	ETF	84.74	84.96	84.71	84.95	699599.0
2008-12-26 15:00:00	DIA	ETF	84.95	85.28	84.83	85.06	1600485.0
2008-12-26 16:00:00	DIA	ETF	85.09	85.2	84.92	85.17	33862.0

> showing 50 of 3,560 rows — these rows as CSV

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