PREVIEW / etf_1hour / 2005-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-23.parquet
  size:    32 KB
  rows:    958

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-09-23 06:00:00	SPY	ETF	121.44	121.53	121.39	121.52	75200.0
2005-09-23 07:00:00	SPY	ETF	121.53	121.53	121.45	121.5	55500.0
2005-09-23 08:00:00	SPY	ETF	121.54	121.54	121.28	121.43	2273500.0
2005-09-23 09:00:00	SPY	ETF	121.4	121.42	120.9	121.0	9116400.0
2005-09-23 10:00:00	SPY	ETF	120.98	121.3	120.94	121.27	10415700.0
2005-09-23 11:00:00	SPY	ETF	121.27	121.47	121.2	121.4	7711300.0
2005-09-23 12:00:00	SPY	ETF	121.4	121.43	121.22	121.3	3200300.0
2005-09-23 13:00:00	SPY	ETF	121.31	121.89	121.25	121.83	9103400.0
2005-09-23 14:00:00	SPY	ETF	121.86	121.88	121.6	121.75	7687300.0
2005-09-23 15:00:00	SPY	ETF	121.76	121.78	121.46	121.56	7840800.0
2005-09-23 16:00:00	SPY	ETF	121.64	121.87	121.44	121.57	701000.0
2005-09-23 17:00:00	SPY	ETF	121.52	121.58	121.52	121.58	2000.0
2005-09-23 18:00:00	SPY	ETF	121.58	121.58	121.58	121.58	900.0
2005-09-23 19:00:00	SPY	ETF	121.58	121.58	121.58	121.58	600.0
2005-09-23 09:00:00	QQQ	ETF	38.51	38.54	38.41	38.47	9825900.0
2005-09-23 10:00:00	QQQ	ETF	38.47	38.62	38.46	38.59	9352200.0
2005-09-23 11:00:00	QQQ	ETF	38.58	38.68	38.56	38.66	10240900.0
2005-09-23 12:00:00	QQQ	ETF	38.66	38.66	38.56	38.61	3694700.0
2005-09-23 13:00:00	QQQ	ETF	38.6	38.88	38.58	38.86	10426400.0
2005-09-23 14:00:00	QQQ	ETF	38.86	38.87	38.79	38.84	8050100.0
2005-09-23 15:00:00	QQQ	ETF	38.83	38.85	38.7	38.76	11024700.0
2005-09-23 07:00:00	IWM	ETF	64.87	64.87	64.76	64.85	16100.0
2005-09-23 08:00:00	IWM	ETF	64.87	64.87	64.72	64.75	661400.0
2005-09-23 09:00:00	IWM	ETF	64.8	64.8	64.24	64.29	2250200.0
2005-09-23 10:00:00	IWM	ETF	64.27	64.61	64.24	64.61	4346800.0
2005-09-23 11:00:00	IWM	ETF	64.61	64.84	64.59	64.79	4966800.0
2005-09-23 12:00:00	IWM	ETF	64.8	64.84	64.66	64.77	1621700.0
2005-09-23 13:00:00	IWM	ETF	64.77	65.18	64.75	65.17	2535500.0
2005-09-23 14:00:00	IWM	ETF	65.18	65.3	65.1	65.26	3597200.0
2005-09-23 15:00:00	IWM	ETF	65.26	65.27	65.02	65.16	3738300.0
2005-09-23 16:00:00	IWM	ETF	65.18	65.3	65.14	65.25	882700.0
2005-09-23 17:00:00	IWM	ETF	65.19	65.19	65.19	65.19	1926400.0
2005-09-23 07:00:00	DIA	ETF	104.11	104.11	104.11	104.11	400.0
2005-09-23 08:00:00	DIA	ETF	104.11	104.11	104.04	104.06	10700.0
2005-09-23 09:00:00	DIA	ETF	104.06	104.06	103.71	103.81	435500.0
2005-09-23 10:00:00	DIA	ETF	103.8	103.96	103.67	103.92	802400.0
2005-09-23 11:00:00	DIA	ETF	103.91	104.11	103.89	104.08	748400.0
2005-09-23 12:00:00	DIA	ETF	104.08	104.089	103.93	104.01	123900.0
2005-09-23 13:00:00	DIA	ETF	104.04	104.49	103.97	104.46	1596700.0
2005-09-23 14:00:00	DIA	ETF	104.46	104.5	104.27	104.39	522700.0
2005-09-23 15:00:00	DIA	ETF	104.39	104.41	104.1	104.17	694300.0
2005-09-23 16:00:00	DIA	ETF	104.24	104.24	104.1	104.2	4500.0
2005-09-23 17:00:00	DIA	ETF	104.25	104.3	104.25	104.3	900.0
2005-09-23 18:00:00	DIA	ETF	104.18	104.18	104.18	104.18	100.0
2005-09-23 19:00:00	DIA	ETF	104.33	104.49	104.18	104.18	2100.0
2005-09-23 07:00:00	GLD	ETF	46.02	46.04	45.99	46.04	245000.0
2005-09-23 08:00:00	GLD	ETF	46.11	46.34	46.0	46.19	253500.0
2005-09-23 09:00:00	GLD	ETF	46.25	46.25	46.08	46.09	466300.0
2005-09-23 10:00:00	GLD	ETF	46.1	46.28	46.09	46.16	340700.0
2005-09-23 11:00:00	GLD	ETF	46.17	46.21	46.0	46.02	200700.0

> showing 50 of 958 rows — these rows as CSV

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