PREVIEW / etf_1hour / 2005-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-27.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-27 07:00:00	SPY	ETF	121.51	121.58	121.51	121.52	15000.0
2005-09-27 08:00:00	SPY	ETF	121.55	121.58	121.49	121.51	1076100.0
2005-09-27 09:00:00	SPY	ETF	121.5	121.66	121.39	121.63	4587700.0
2005-09-27 10:00:00	SPY	ETF	121.62	121.64	121.02	121.16	15817600.0
2005-09-27 11:00:00	SPY	ETF	121.16	121.33	121.07	121.23	6512900.0
2005-09-27 12:00:00	SPY	ETF	121.23	121.38	121.14	121.26	4044500.0
2005-09-27 13:00:00	SPY	ETF	121.26	121.47	121.04	121.43	7013200.0
2005-09-27 14:00:00	SPY	ETF	121.43	121.9	121.33	121.85	11029500.0
2005-09-27 15:00:00	SPY	ETF	121.83	121.99	121.47	121.5	11467300.0
2005-09-27 16:00:00	SPY	ETF	121.49	121.62	121.49	121.55	2052000.0
2005-09-27 17:00:00	SPY	ETF	121.55	121.6	121.55	121.6	4500.0
2005-09-27 18:00:00	SPY	ETF	121.53	121.53	121.5	121.5	5700.0
2005-09-27 19:00:00	SPY	ETF	121.53	121.53	121.53	121.53	100.0
2005-09-27 09:00:00	QQQ	ETF	38.8	38.85	38.75	38.84	7952900.0
2005-09-27 10:00:00	QQQ	ETF	38.83	38.83	38.62	38.66	11855600.0
2005-09-27 11:00:00	QQQ	ETF	38.66	38.72	38.63	38.7	5446400.0
2005-09-27 12:00:00	QQQ	ETF	38.71	38.75	38.65	38.68	3518600.0
2005-09-27 13:00:00	QQQ	ETF	38.68	38.7	38.51	38.7	9460400.0
2005-09-27 14:00:00	QQQ	ETF	38.7	38.85	38.65	38.81	9904500.0
2005-09-27 15:00:00	QQQ	ETF	38.81	38.9	38.65	38.67	12822300.0
2005-09-27 08:00:00	IWM	ETF	65.55	65.56	65.51	65.52	607800.0
2005-09-27 09:00:00	IWM	ETF	65.52	65.59	65.31	65.4	2310100.0
2005-09-27 10:00:00	IWM	ETF	65.37	65.39	65.03	65.04	6006300.0
2005-09-27 11:00:00	IWM	ETF	65.04	65.16	64.9724	65.14	2969200.0
2005-09-27 12:00:00	IWM	ETF	65.14	65.24	65.062	65.13	1471000.0
2005-09-27 13:00:00	IWM	ETF	65.14	65.27	64.96	65.18	3581600.0
2005-09-27 14:00:00	IWM	ETF	65.18	65.76	65.18	65.74	3867600.0
2005-09-27 15:00:00	IWM	ETF	65.74	65.85	65.38	65.39	5120400.0
2005-09-27 16:00:00	IWM	ETF	65.41	65.5	65.38	65.42	815500.0
2005-09-27 17:00:00	IWM	ETF	65.42	65.42	65.33	65.34	1600.0
2005-09-27 18:00:00	IWM	ETF	65.47	65.47	65.31	65.31	200.0
2005-09-27 08:00:00	DIA	ETF	104.4	104.45	104.4	104.44	4000.0
2005-09-27 09:00:00	DIA	ETF	104.48	104.7	104.37	104.65	991100.0
2005-09-27 10:00:00	DIA	ETF	104.64	104.65	104.09	104.19	2021400.0
2005-09-27 11:00:00	DIA	ETF	104.19	104.32	104.11	104.32	590800.0
2005-09-27 12:00:00	DIA	ETF	104.28	104.38	104.17	104.24	470500.0
2005-09-27 13:00:00	DIA	ETF	104.25	104.49	104.07	104.42	632400.0
2005-09-27 14:00:00	DIA	ETF	104.47	104.83	104.34	104.77	1753200.0
2005-09-27 15:00:00	DIA	ETF	104.79	104.9	104.46	104.49	1184400.0
2005-09-27 16:00:00	DIA	ETF	104.54	104.57	104.49	104.49	304600.0
2005-09-27 18:00:00	DIA	ETF	104.5	104.5	104.5	104.5	1100.0
2005-09-27 07:00:00	GLD	ETF	46.32	46.32	46.32	46.32	500.0
2005-09-27 08:00:00	GLD	ETF	46.25	46.25	46.18	46.18	3000.0
2005-09-27 09:00:00	GLD	ETF	46.2	46.33	46.1	46.31	187800.0
2005-09-27 10:00:00	GLD	ETF	46.33	46.33	45.97	46.03	366100.0
2005-09-27 11:00:00	GLD	ETF	46.02	46.03	45.66	45.8	539500.0
2005-09-27 12:00:00	GLD	ETF	45.82	45.9	45.76	45.9	91200.0
2005-09-27 13:00:00	GLD	ETF	45.9	46.17	45.87	46.1	170500.0
2005-09-27 14:00:00	GLD	ETF	46.1	46.21	46.09	46.21	85200.0
2005-09-27 15:00:00	GLD	ETF	46.2	46.25	46.17	46.22	895700.0

> showing 50 of 958 rows — these rows as CSV

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