PREVIEW / etf_1hour / 2005-09-06

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-06.parquet
  size:    32 KB
  rows:    973

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-06 06:00:00	SPY	ETF	122.83	122.83	122.79	122.79	5000.0
2005-09-06 07:00:00	SPY	ETF	122.77	122.87	122.74	122.75	16300.0
2005-09-06 08:00:00	SPY	ETF	122.47	122.86	122.47	122.65	1530200.0
2005-09-06 09:00:00	SPY	ETF	122.65	122.98	122.27	122.82	10213900.0
2005-09-06 10:00:00	SPY	ETF	122.83	123.42	122.83	123.23	13898500.0
2005-09-06 11:00:00	SPY	ETF	123.23	123.36	123.15	123.21	4911100.0
2005-09-06 12:00:00	SPY	ETF	123.2	123.42	123.2	123.4	1973100.0
2005-09-06 13:00:00	SPY	ETF	123.4	123.51	123.22	123.5	3872100.0
2005-09-06 14:00:00	SPY	ETF	123.49	123.57	123.32	123.47	5120700.0
2005-09-06 15:00:00	SPY	ETF	123.47	123.76	123.34	123.75	11172700.0
2005-09-06 16:00:00	SPY	ETF	123.79	123.79	123.44	123.73	1951600.0
2005-09-06 17:00:00	SPY	ETF	123.72	123.79	123.72	123.79	94000.0
2005-09-06 18:00:00	SPY	ETF	123.77	123.79	123.72	123.74	13500.0
2005-09-06 09:00:00	QQQ	ETF	38.93	39.04	38.91	38.99	9304100.0
2005-09-06 10:00:00	QQQ	ETF	38.99	39.35	38.98	39.25	21664800.0
2005-09-06 11:00:00	QQQ	ETF	39.25	39.3	39.22	39.27	6024500.0
2005-09-06 12:00:00	QQQ	ETF	39.26	39.35	39.25	39.31	4707400.0
2005-09-06 13:00:00	QQQ	ETF	39.31	39.34	39.21	39.3	5340100.0
2005-09-06 14:00:00	QQQ	ETF	39.3	39.34	39.26	39.3	6115600.0
2005-09-06 15:00:00	QQQ	ETF	39.3	39.41	39.26	39.37	12959700.0
2005-09-06 08:00:00	IWM	ETF	66.22	66.49	66.22	66.41	1522000.0
2005-09-06 09:00:00	IWM	ETF	66.39	66.69	66.17	66.52	4656400.0
2005-09-06 10:00:00	IWM	ETF	66.51	67.05	66.44	66.93	7665600.0
2005-09-06 11:00:00	IWM	ETF	66.93	66.94	66.74	66.79	1461600.0
2005-09-06 12:00:00	IWM	ETF	66.782	66.99	66.78	66.99	1105600.0
2005-09-06 13:00:00	IWM	ETF	66.99	67.01	66.79	66.92	2123800.0
2005-09-06 14:00:00	IWM	ETF	66.92	67.0	66.8	66.91	1598800.0
2005-09-06 15:00:00	IWM	ETF	66.92	67.18	66.75	67.18	4163900.0
2005-09-06 16:00:00	IWM	ETF	67.18	67.18	67.11	67.16	586400.0
2005-09-06 17:00:00	IWM	ETF	66.0667	67.18	66.0667	67.18	1553000.0
2005-09-06 18:00:00	IWM	ETF	67.12	67.16	67.12	67.16	12000.0
2005-09-06 07:00:00	DIA	ETF	105.0	105.0	105.0	105.0	200.0
2005-09-06 08:00:00	DIA	ETF	105.0	105.05	104.9	104.91	154200.0
2005-09-06 09:00:00	DIA	ETF	104.92	105.27	104.92	105.12	4061600.0
2005-09-06 10:00:00	DIA	ETF	105.12	105.59	105.11	105.46	2483200.0
2005-09-06 11:00:00	DIA	ETF	105.47	105.57	105.33	105.39	358100.0
2005-09-06 12:00:00	DIA	ETF	105.39	105.59	105.37	105.59	554300.0
2005-09-06 13:00:00	DIA	ETF	105.58	105.68	105.42	105.62	906300.0
2005-09-06 14:00:00	DIA	ETF	105.62	105.72	105.49	105.62	459400.0
2005-09-06 15:00:00	DIA	ETF	105.66	105.92	105.59	105.88	1364800.0
2005-09-06 16:00:00	DIA	ETF	105.9	105.91	105.83	105.9	125900.0
2005-09-06 18:00:00	DIA	ETF	105.9	105.9	105.9	105.9	100.0
2005-09-06 08:00:00	GLD	ETF	44.43	44.43	44.43	44.43	300.0
2005-09-06 09:00:00	GLD	ETF	44.42	44.42	44.31	44.38	144900.0
2005-09-06 10:00:00	GLD	ETF	44.36	44.37	44.23	44.29	151700.0
2005-09-06 11:00:00	GLD	ETF	44.3	44.3	44.19	44.26	103900.0
2005-09-06 12:00:00	GLD	ETF	44.27	44.3595	44.26	44.32	46500.0
2005-09-06 13:00:00	GLD	ETF	44.32	44.35	44.29	44.32	160500.0
2005-09-06 14:00:00	GLD	ETF	44.3205	44.33	44.28	44.31	151100.0
2005-09-06 15:00:00	GLD	ETF	44.29	44.3	44.24	44.27	60800.0

> showing 50 of 973 rows — these rows as CSV

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