PREVIEW / etf_1hour / 2005-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-05.parquet
  size:    34 KB
  rows:    1,005

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-10-05 07:00:00	SPY	ETF	121.24	121.28	121.24	121.25	4500.0
2005-10-05 08:00:00	SPY	ETF	121.28	121.32	121.19	121.31	1751300.0
2005-10-05 09:00:00	SPY	ETF	121.31	121.35	121.09	121.25	8135100.0
2005-10-05 10:00:00	SPY	ETF	121.25	121.25	120.67	120.93	19870800.0
2005-10-05 11:00:00	SPY	ETF	120.92	121.03	120.28	120.4	14092700.0
2005-10-05 12:00:00	SPY	ETF	120.41	120.73	120.22	120.66	11614100.0
2005-10-05 13:00:00	SPY	ETF	120.66	120.98	120.57	120.67	8466200.0
2005-10-05 14:00:00	SPY	ETF	120.67	121.28	120.47	120.5	14856400.0
2005-10-05 15:00:00	SPY	ETF	120.47	120.87	112.09	119.63	23802000.0
2005-10-05 16:00:00	SPY	ETF	119.62	119.75	119.56	119.6	935900.0
2005-10-05 17:00:00	SPY	ETF	119.62	119.68	119.6	119.66	18300.0
2005-10-05 18:00:00	SPY	ETF	119.67	119.7	119.62	119.7	7500.0
2005-10-05 19:00:00	SPY	ETF	119.69	119.71	119.68	119.68	4800.0
2005-10-05 09:00:00	QQQ	ETF	39.31	39.34	39.25	39.28	9707500.0
2005-10-05 10:00:00	QQQ	ETF	39.29	39.29	38.98	39.1	28270600.0
2005-10-05 11:00:00	QQQ	ETF	39.1	39.15	38.9	38.97	12696200.0
2005-10-05 12:00:00	QQQ	ETF	38.97	39.11	38.9	39.07	12133900.0
2005-10-05 13:00:00	QQQ	ETF	39.07	39.2	39.02	39.06	7158800.0
2005-10-05 14:00:00	QQQ	ETF	39.06	39.19	39.03	39.05	8863000.0
2005-10-05 15:00:00	QQQ	ETF	39.05	39.15	38.74	38.74	23083000.0
2005-10-05 08:00:00	IWM	ETF	65.78	65.82	65.78	65.82	16800.0
2005-10-05 09:00:00	IWM	ETF	65.82	65.82	65.43	65.5	4031400.0
2005-10-05 10:00:00	IWM	ETF	65.49	65.49	64.8	64.99	11384500.0
2005-10-05 11:00:00	IWM	ETF	64.98	65.01	64.42	64.54	3278700.0
2005-10-05 12:00:00	IWM	ETF	64.54	64.89	64.46	64.86	4136600.0
2005-10-05 13:00:00	IWM	ETF	64.87	65.22	64.87	64.92	5123600.0
2005-10-05 14:00:00	IWM	ETF	64.92	65.28	64.6	64.6	4946300.0
2005-10-05 15:00:00	IWM	ETF	64.6	64.63	64.05	64.1	11824100.0
2005-10-05 16:00:00	IWM	ETF	64.1	64.49	64.04	64.1	386700.0
2005-10-05 17:00:00	IWM	ETF	64.06	64.06	64.06	64.06	600.0
2005-10-05 19:00:00	IWM	ETF	64.5	64.5	64.18	64.18	700.0
2005-10-05 08:00:00	DIA	ETF	104.3	104.31	104.27	104.27	26200.0
2005-10-05 09:00:00	DIA	ETF	104.3	104.35	104.22	104.31	638900.0
2005-10-05 10:00:00	DIA	ETF	104.32	104.32	103.86	104.08	1857800.0
2005-10-05 11:00:00	DIA	ETF	104.08	104.3	103.74	103.8	1263200.0
2005-10-05 12:00:00	DIA	ETF	103.81	103.99	103.67	103.88	908700.0
2005-10-05 13:00:00	DIA	ETF	103.9	104.09	103.78	103.88	566300.0
2005-10-05 14:00:00	DIA	ETF	103.89	104.21	103.79	103.79	1439800.0
2005-10-05 15:00:00	DIA	ETF	103.8	103.93	103.18	103.24	1846900.0
2005-10-05 16:00:00	DIA	ETF	103.21	103.35	103.16	103.2	116600.0
2005-10-05 18:00:00	DIA	ETF	103.2	103.2	103.2	103.2	400.0
2005-10-05 08:00:00	GLD	ETF	46.33	46.4	46.33	46.4	1200.0
2005-10-05 09:00:00	GLD	ETF	46.37	46.45	46.2	46.24	187000.0
2005-10-05 10:00:00	GLD	ETF	46.24	46.36	46.14	46.19	721500.0
2005-10-05 11:00:00	GLD	ETF	46.19	46.45	46.19	46.45	202300.0
2005-10-05 12:00:00	GLD	ETF	46.44	46.5	46.36	46.4299	133500.0
2005-10-05 13:00:00	GLD	ETF	46.42	46.53	46.42	46.48	127200.0
2005-10-05 14:00:00	GLD	ETF	46.49	46.5	46.35	46.4	169200.0
2005-10-05 15:00:00	GLD	ETF	46.38	46.43	46.32	46.39	133000.0
2005-10-05 16:00:00	GLD	ETF	46.36	46.4	46.36	46.4	4800.0

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

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