PREVIEW / etf_1hour / 2005-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-07.parquet
  size:    31 KB
  rows:    984

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-07 06:00:00	SPY	ETF	119.5	119.5	119.5	119.5	25000.0
2005-10-07 07:00:00	SPY	ETF	119.49	119.53	119.4	119.4	24800.0
2005-10-07 08:00:00	SPY	ETF	119.4	119.62	119.1	119.46	7054300.0
2005-10-07 09:00:00	SPY	ETF	119.5	120.05	119.21	119.75	17198600.0
2005-10-07 10:00:00	SPY	ETF	119.76	119.99	119.13	119.47	17887900.0
2005-10-07 11:00:00	SPY	ETF	119.48	119.83	119.33	119.65	7261300.0
2005-10-07 12:00:00	SPY	ETF	119.65	119.75	119.43	119.48	3767500.0
2005-10-07 13:00:00	SPY	ETF	119.49	119.68	119.42	119.49	3403000.0
2005-10-07 14:00:00	SPY	ETF	119.48	119.66	119.25	119.44	6199900.0
2005-10-07 15:00:00	SPY	ETF	119.44	119.72	119.36	119.68	8804900.0
2005-10-07 16:00:00	SPY	ETF	119.68	119.68	119.181	119.48	2259800.0
2005-10-07 17:00:00	SPY	ETF	119.5	119.56	119.5	119.53	2800.0
2005-10-07 18:00:00	SPY	ETF	119.55	119.56	119.53	119.53	2200.0
2005-10-07 19:00:00	SPY	ETF	119.52	119.52	119.52	119.52	600.0
2005-10-07 09:00:00	QQQ	ETF	38.42	38.57	38.36	38.47	12943200.0
2005-10-07 10:00:00	QQQ	ETF	38.47	38.48	38.18	38.35	20524800.0
2005-10-07 11:00:00	QQQ	ETF	38.35	38.43	38.27	38.39	8970100.0
2005-10-07 12:00:00	QQQ	ETF	38.37	38.42	38.29	38.32	5350200.0
2005-10-07 13:00:00	QQQ	ETF	38.31	38.4	38.27	38.31	10475000.0
2005-10-07 14:00:00	QQQ	ETF	38.32	38.38	38.22	38.31	8611700.0
2005-10-07 15:00:00	QQQ	ETF	38.31	38.37	38.26	38.34	9892800.0
2005-10-07 08:00:00	IWM	ETF	63.74	63.86	63.53	63.84	88000.0
2005-10-07 09:00:00	IWM	ETF	63.88	64.18	63.77	64.06	3334900.0
2005-10-07 10:00:00	IWM	ETF	64.07	64.1	63.6	63.69	5538800.0
2005-10-07 11:00:00	IWM	ETF	63.69	64.13	63.66	64.06	3399600.0
2005-10-07 12:00:00	IWM	ETF	64.05	64.23	64.0	64.01	2073900.0
2005-10-07 13:00:00	IWM	ETF	64.05	64.21	64.01	64.09	1229100.0
2005-10-07 14:00:00	IWM	ETF	64.09	64.24	63.87	64.06	3326500.0
2005-10-07 15:00:00	IWM	ETF	64.07	64.26	63.98	64.05	4574800.0
2005-10-07 16:00:00	IWM	ETF	64.05	64.14	64.0	64.05	123000.0
2005-10-07 17:00:00	IWM	ETF	64.04	64.04	64.01	64.01	500.0
2005-10-07 18:00:00	IWM	ETF	64.09	64.1	64.09	64.1	500.0
2005-10-07 07:00:00	DIA	ETF	103.14	103.14	103.08	103.08	3800.0
2005-10-07 08:00:00	DIA	ETF	103.08	103.16	102.86	103.11	107400.0
2005-10-07 09:00:00	DIA	ETF	103.2	103.51	103.16	103.3	1905000.0
2005-10-07 10:00:00	DIA	ETF	103.3	103.35	102.83	103.06	2010000.0
2005-10-07 11:00:00	DIA	ETF	103.04	103.25	102.97	103.12	1031700.0
2005-10-07 12:00:00	DIA	ETF	103.1	103.22	102.96	102.98	261100.0
2005-10-07 13:00:00	DIA	ETF	102.98	103.2	102.96	103.02	306100.0
2005-10-07 14:00:00	DIA	ETF	103.05	103.08	102.82	102.92	536400.0
2005-10-07 15:00:00	DIA	ETF	102.92	103.08	102.83	102.99	659700.0
2005-10-07 16:00:00	DIA	ETF	102.97	103.0	102.87	102.87	6900.0
2005-10-07 17:00:00	DIA	ETF	102.9	102.9	102.8	102.8	2500.0
2005-10-07 08:00:00	GLD	ETF	47.09	47.28	46.98	47.13	21500.0
2005-10-07 09:00:00	GLD	ETF	47.1	47.15	46.9	47.12	251100.0
2005-10-07 10:00:00	GLD	ETF	47.13	47.47	47.12	47.4	440200.0
2005-10-07 11:00:00	GLD	ETF	47.4	47.4	47.25	47.32	408600.0
2005-10-07 12:00:00	GLD	ETF	47.35	47.48	47.3	47.44	213700.0
2005-10-07 13:00:00	GLD	ETF	47.45	47.48	47.25	47.31	138000.0
2005-10-07 14:00:00	GLD	ETF	47.31	47.39	47.27	47.39	125700.0

> showing 50 of 984 rows — these rows as CSV

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