PREVIEW / etf_1hour / 2005-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-16.parquet
  size:    37 KB
  rows:    1,163

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-12-16 05:00:00	SPY	ETF	127.25	127.32	127.25	127.32	400.0
2005-12-16 06:00:00	SPY	ETF	127.3	127.3	127.27	127.29	35900.0
2005-12-16 07:00:00	SPY	ETF	127.41	127.43	127.25	127.25	269200.0
2005-12-16 08:00:00	SPY	ETF	127.3	127.43	126.95	127.35	1392000.0
2005-12-16 09:00:00	SPY	ETF	127.35	127.4	127.03	127.24	9468200.0
2005-12-16 10:00:00	SPY	ETF	127.22	127.28	127.08	127.22	4393200.0
2005-12-16 11:00:00	SPY	ETF	127.2	127.38	126.83	126.97	6550900.0
2005-12-16 12:00:00	SPY	ETF	126.98	127.29	126.91	126.93	4572700.0
2005-12-16 13:00:00	SPY	ETF	126.92	127.01	126.76	126.9899	3415800.0
2005-12-16 14:00:00	SPY	ETF	126.99	127.0	126.62	126.64	3168300.0
2005-12-16 15:00:00	SPY	ETF	126.62	128.57	126.49	126.6	7169700.0
2005-12-16 16:00:00	SPY	ETF	126.6	126.69	126.3	126.35	3042900.0
2005-12-16 17:00:00	SPY	ETF	126.31	126.65	126.3	126.59	255400.0
2005-12-16 18:00:00	SPY	ETF	126.58	126.58	126.58	126.58	100.0
2005-12-16 19:00:00	SPY	ETF	126.5	126.5	126.5	126.5	200.0
2005-12-16 09:00:00	QQQ	ETF	41.87	41.94	41.66	41.8	11676800.0
2005-12-16 10:00:00	QQQ	ETF	41.81	41.83	41.71	41.77	5993700.0
2005-12-16 11:00:00	QQQ	ETF	41.77	41.94	41.74	41.78	6127900.0
2005-12-16 12:00:00	QQQ	ETF	41.77	41.81	41.73	41.73	2364600.0
2005-12-16 13:00:00	QQQ	ETF	41.74	41.79	41.7	41.77	3185300.0
2005-12-16 14:00:00	QQQ	ETF	41.78	41.78	41.61	41.61	5128900.0
2005-12-16 15:00:00	QQQ	ETF	41.62	41.75	41.55	41.59	14259500.0
2005-12-16 07:00:00	IWM	ETF	68.37	68.37	68.35	68.35	300.0
2005-12-16 08:00:00	IWM	ETF	68.33	68.33	68.28	68.28	3800.0
2005-12-16 09:00:00	IWM	ETF	68.35	68.6	68.17	68.24	2360300.0
2005-12-16 10:00:00	IWM	ETF	68.24	68.27	68.07	68.2	2279100.0
2005-12-16 11:00:00	IWM	ETF	68.19	68.44	68.18	68.24	4139900.0
2005-12-16 12:00:00	IWM	ETF	68.24	68.33	68.16	68.17	2030100.0
2005-12-16 13:00:00	IWM	ETF	68.16	68.22	68.08	68.19	1680800.0
2005-12-16 14:00:00	IWM	ETF	68.17	68.2	67.91	67.9188	1756100.0
2005-12-16 15:00:00	IWM	ETF	67.92	68.2118	67.85	67.93	4409900.0
2005-12-16 16:00:00	IWM	ETF	67.94	68.05	67.81	67.81	504500.0
2005-12-16 07:00:00	DIA	ETF	108.95	109.0	108.95	108.96	2900.0
2005-12-16 08:00:00	DIA	ETF	108.95	109.06	108.86	109.02	69100.0
2005-12-16 09:00:00	DIA	ETF	109.02	109.05	108.78	108.99	516800.0
2005-12-16 10:00:00	DIA	ETF	108.97	109.15	108.89	109.12	849000.0
2005-12-16 11:00:00	DIA	ETF	109.13	109.24	108.83	108.93	441200.0
2005-12-16 12:00:00	DIA	ETF	108.93	109.05	108.87	108.88	495100.0
2005-12-16 13:00:00	DIA	ETF	108.913	108.95	108.72	108.93	482400.0
2005-12-16 14:00:00	DIA	ETF	108.93	108.93	108.65	108.65	766100.0
2005-12-16 15:00:00	DIA	ETF	108.64	108.73	108.53	108.66	748000.0
2005-12-16 16:00:00	DIA	ETF	108.65	108.75	108.44	108.49	96300.0
2005-12-16 17:00:00	DIA	ETF	108.6	108.65	108.6	108.65	2400.0
2005-12-16 18:00:00	DIA	ETF	108.74	108.74	108.74	108.74	300.0
2005-12-16 19:00:00	DIA	ETF	108.7	108.8	108.7	108.8	1500.0
2005-12-16 07:00:00	GLD	ETF	50.05	50.28	50.05	50.28	2900.0
2005-12-16 08:00:00	GLD	ETF	50.32	50.54	50.23	50.42	287400.0
2005-12-16 09:00:00	GLD	ETF	50.36	50.58	50.25	50.58	525000.0
2005-12-16 10:00:00	GLD	ETF	50.54	50.59	50.13	50.2	471600.0
2005-12-16 11:00:00	GLD	ETF	50.17	50.42	50.17	50.39	264700.0

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

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