PREVIEW / etf_1hour / 2006-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-16.parquet
  size:    41 KB
  rows:    1,263

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-03-16 05:00:00	SPY	ETF	130.52	130.52	130.52	130.52	5500.0
2006-03-16 06:00:00	SPY	ETF	130.6	130.6	130.6	130.6	3000.0
2006-03-16 07:00:00	SPY	ETF	130.56	130.61	130.56	130.61	12100.0
2006-03-16 08:00:00	SPY	ETF	130.62	131.1	130.54	131.07	2722800.0
2006-03-16 09:00:00	SPY	ETF	131.06	131.11	130.46	130.97	6708300.0
2006-03-16 10:00:00	SPY	ETF	130.98	131.3	130.84	130.96	11719500.0
2006-03-16 11:00:00	SPY	ETF	130.97	131.21	130.95	131.15	4995200.0
2006-03-16 12:00:00	SPY	ETF	131.16	131.47	131.05	131.33	8149600.0
2006-03-16 13:00:00	SPY	ETF	131.34	131.34	130.95	130.99	8573400.0
2006-03-16 14:00:00	SPY	ETF	130.99	131.25	130.87	130.95	7215600.0
2006-03-16 15:00:00	SPY	ETF	130.95	131.19	130.93	131.01	9367000.0
2006-03-16 16:00:00	SPY	ETF	131.0	131.05	130.92	131.03	4240500.0
2006-03-16 17:00:00	SPY	ETF	130.97	130.97	130.9	130.92	79500.0
2006-03-16 18:00:00	SPY	ETF	130.91	130.97	130.89	130.97	1557200.0
2006-03-16 19:00:00	SPY	ETF	130.94	130.97	130.9	130.93	2900.0
2006-03-16 09:00:00	QQQ	ETF	41.85	41.88	41.77	41.78	9371100.0
2006-03-16 10:00:00	QQQ	ETF	41.78	41.92	41.62	41.69	20470800.0
2006-03-16 11:00:00	QQQ	ETF	41.68	41.8	41.67	41.76	8842300.0
2006-03-16 12:00:00	QQQ	ETF	41.75	41.88	41.73	41.78	8481600.0
2006-03-16 13:00:00	QQQ	ETF	41.79	41.79	41.55	41.56	14135500.0
2006-03-16 14:00:00	QQQ	ETF	41.57	41.69	41.39	41.41	13755200.0
2006-03-16 15:00:00	QQQ	ETF	41.41	41.53	41.33	41.36	14446700.0
2006-03-16 08:00:00	IWM	ETF	73.88	74.22	73.88	74.18	366700.0
2006-03-16 09:00:00	IWM	ETF	74.2	74.31	74.03	74.17	4440000.0
2006-03-16 10:00:00	IWM	ETF	74.17	74.39	73.88	73.97	5152500.0
2006-03-16 11:00:00	IWM	ETF	73.97	74.27	73.93	74.21	2577500.0
2006-03-16 12:00:00	IWM	ETF	74.21	74.5	74.19	74.32	3100300.0
2006-03-16 13:00:00	IWM	ETF	74.32	74.36	73.98	74.0	3319600.0
2006-03-16 14:00:00	IWM	ETF	74.0	74.23	73.84	73.88	3179200.0
2006-03-16 15:00:00	IWM	ETF	73.88	74.05	73.85	73.96	6665200.0
2006-03-16 16:00:00	IWM	ETF	73.97	74.0	73.76	73.76	1903900.0
2006-03-16 17:00:00	IWM	ETF	73.98	73.98	73.8	73.8	120800.0
2006-03-16 18:00:00	IWM	ETF	73.8	73.83	73.8	73.8	5300.0
2006-03-16 19:00:00	IWM	ETF	73.8	73.82	73.8	73.82	1100.0
2006-03-16 08:00:00	DIA	ETF	112.21	112.54	112.2	112.53	42700.0
2006-03-16 09:00:00	DIA	ETF	112.51	112.64	112.43	112.61	670700.0
2006-03-16 10:00:00	DIA	ETF	112.6	112.9	112.52	112.61	1409000.0
2006-03-16 11:00:00	DIA	ETF	112.61	112.83	112.6	112.72	606200.0
2006-03-16 12:00:00	DIA	ETF	112.73	112.96	112.68	112.88	569000.0
2006-03-16 13:00:00	DIA	ETF	112.87	112.87	112.58	112.6	697800.0
2006-03-16 14:00:00	DIA	ETF	112.6	112.82	112.52	112.59	1107900.0
2006-03-16 15:00:00	DIA	ETF	112.6	112.83	112.58	112.75	881900.0
2006-03-16 16:00:00	DIA	ETF	112.75	112.79	112.69	112.75	304800.0
2006-03-16 17:00:00	DIA	ETF	112.74	112.74	112.67	112.67	700.0
2006-03-16 18:00:00	DIA	ETF	112.67	112.67	112.67	112.67	100.0
2006-03-16 08:00:00	GLD	ETF	55.14	55.36	55.12	55.36	46300.0
2006-03-16 09:00:00	GLD	ETF	55.35	55.41	54.89	54.93	415500.0
2006-03-16 10:00:00	GLD	ETF	54.91	55.11	54.49	54.63	1254300.0
2006-03-16 11:00:00	GLD	ETF	54.639	55.049	54.59	54.92	439100.0
2006-03-16 12:00:00	GLD	ETF	54.904	55.25	54.904	55.23	258400.0

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

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