PREVIEW / etf_1hour / 2005-10-31

all etf 1-hour files

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

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-31 06:00:00	SPY	ETF	120.13	120.13	120.13	120.13	25000.0
2005-10-31 07:00:00	SPY	ETF	120.25	120.36	120.17	120.26	161100.0
2005-10-31 08:00:00	SPY	ETF	120.26	120.36	119.92	120.27	1051500.0
2005-10-31 09:00:00	SPY	ETF	120.25	120.94	119.84	120.86	16393100.0
2005-10-31 10:00:00	SPY	ETF	120.87	121.01	120.65	120.75	11657600.0
2005-10-31 11:00:00	SPY	ETF	120.75	120.91	120.64	120.66	6102900.0
2005-10-31 12:00:00	SPY	ETF	120.66	120.86	120.5	120.72	6857400.0
2005-10-31 13:00:00	SPY	ETF	120.71	120.83	120.53	120.67	3394300.0
2005-10-31 14:00:00	SPY	ETF	120.66	120.97	120.58	120.95	8640400.0
2005-10-31 15:00:00	SPY	ETF	120.94	121.3	120.64	120.7	15778400.0
2005-10-31 16:00:00	SPY	ETF	120.7	120.9836	120.12	120.15	6660400.0
2005-10-31 17:00:00	SPY	ETF	120.14	120.45	120.13	120.41	182700.0
2005-10-31 18:00:00	SPY	ETF	120.42	120.42	120.36	120.39	62900.0
2005-10-31 19:00:00	SPY	ETF	120.4	120.4	120.34	120.35	4000.0
2005-10-31 09:00:00	QQQ	ETF	38.43	38.69	38.42	38.68	22556200.0
2005-10-31 10:00:00	QQQ	ETF	38.68	38.92	38.65	38.84	27496900.0
2005-10-31 11:00:00	QQQ	ETF	38.83	38.9	38.79	38.81	7227700.0
2005-10-31 12:00:00	QQQ	ETF	38.81	38.87	38.73	38.8	8007400.0
2005-10-31 13:00:00	QQQ	ETF	38.8	38.89	38.76	38.82	7370500.0
2005-10-31 14:00:00	QQQ	ETF	38.82	38.94	38.79	38.91	10297500.0
2005-10-31 15:00:00	QQQ	ETF	38.91	39.05	38.84	38.86	19738700.0
2005-10-31 07:00:00	IWM	ETF	63.38	63.38	63.38	63.38	1000.0
2005-10-31 08:00:00	IWM	ETF	63.35	63.4	63.1	63.33	211100.0
2005-10-31 09:00:00	IWM	ETF	63.33	64.14	63.32	64.07	4453100.0
2005-10-31 10:00:00	IWM	ETF	64.06	64.55	63.94	64.25	6408600.0
2005-10-31 11:00:00	IWM	ETF	64.25	64.29	63.97	64.02	3410300.0
2005-10-31 12:00:00	IWM	ETF	64.02	64.21	63.9	64.11	3328400.0
2005-10-31 13:00:00	IWM	ETF	64.11	64.32	64.02	64.11	2612000.0
2005-10-31 14:00:00	IWM	ETF	64.1	64.45	64.03	64.4	3291200.0
2005-10-31 15:00:00	IWM	ETF	64.4	64.54	64.16	64.17	9863100.0
2005-10-31 16:00:00	IWM	ETF	64.14	64.23	63.58	63.59	371300.0
2005-10-31 17:00:00	IWM	ETF	63.58	63.71	63.58	63.66	15100.0
2005-10-31 19:00:00	IWM	ETF	63.7	63.71	63.7	63.71	3000.0
2005-10-31 07:00:00	DIA	ETF	104.22	104.24	104.22	104.24	4000.0
2005-10-31 08:00:00	DIA	ETF	104.18	104.18	104.15	104.16	6300.0
2005-10-31 09:00:00	DIA	ETF	104.21	104.66	104.18	104.61	1491100.0
2005-10-31 10:00:00	DIA	ETF	104.63	104.79	104.51	104.6	892900.0
2005-10-31 11:00:00	DIA	ETF	104.6	104.74	104.49	104.49	545700.0
2005-10-31 12:00:00	DIA	ETF	104.5	104.61	104.33	104.46	281500.0
2005-10-31 13:00:00	DIA	ETF	104.46	104.55	104.25	104.33	596500.0
2005-10-31 14:00:00	DIA	ETF	104.33	104.53	104.28	104.51	386000.0
2005-10-31 15:00:00	DIA	ETF	104.5	104.77	104.26	104.29	995400.0
2005-10-31 16:00:00	DIA	ETF	104.25	104.27	103.83	103.86	272300.0
2005-10-31 17:00:00	DIA	ETF	103.91	104.0	103.91	104.0	1100.0
2005-10-31 18:00:00	DIA	ETF	103.95	103.95	103.95	103.95	100.0
2005-10-31 08:00:00	GLD	ETF	47.1	47.1	46.95	46.95	7600.0
2005-10-31 09:00:00	GLD	ETF	46.95	47.04	46.95	46.97	160500.0
2005-10-31 10:00:00	GLD	ETF	46.97	46.97	46.39	46.4799	744500.0
2005-10-31 11:00:00	GLD	ETF	46.46	46.54	46.35	46.4299	496900.0
2005-10-31 12:00:00	GLD	ETF	46.43	46.58	46.42	46.56	492100.0

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

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