PREVIEW / etf_1hour / 2005-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-16.parquet
  size:    30 KB
  rows:    879

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-03-16 08:00:00	SPY	ETF	120.11	120.17	119.6	119.71	424200.0
2005-03-16 09:00:00	SPY	ETF	119.71	119.86	119.5715	119.65	6688500.0
2005-03-16 10:00:00	SPY	ETF	119.65	119.88	119.27	119.42	16008200.0
2005-03-16 11:00:00	SPY	ETF	119.41	119.5	119.16	119.4	7820800.0
2005-03-16 12:00:00	SPY	ETF	119.39	119.62	119.3	119.62	6630900.0
2005-03-16 13:00:00	SPY	ETF	119.62	119.68	119.25	119.28	5931300.0
2005-03-16 14:00:00	SPY	ETF	119.28	119.34	119.0	119.03	8920900.0
2005-03-16 15:00:00	SPY	ETF	119.04	120.155	118.9	119.18	17355700.0
2005-03-16 16:00:00	SPY	ETF	119.18	119.27	119.1	119.25	1340700.0
2005-03-16 17:00:00	SPY	ETF	119.27	119.28	119.12	119.23	645600.0
2005-03-16 18:00:00	SPY	ETF	119.2	119.27	119.2	119.27	1200.0
2005-03-16 19:00:00	SPY	ETF	119.29	119.3	119.26	119.3	3100.0
2005-03-16 09:00:00	QQQ	ETF	36.9	37.05	36.88	36.97	18873900.0
2005-03-16 10:00:00	QQQ	ETF	36.97	37.18	36.79	36.8	36668300.0
2005-03-16 11:00:00	QQQ	ETF	36.8	36.81	36.65	36.76	27199700.0
2005-03-16 12:00:00	QQQ	ETF	36.76	36.86	36.72	36.86	9576900.0
2005-03-16 13:00:00	QQQ	ETF	36.86	36.9	36.69	36.7	9840200.0
2005-03-16 14:00:00	QQQ	ETF	36.7	36.71	36.6	36.63	13804200.0
2005-03-16 15:00:00	QQQ	ETF	36.64	36.72	36.53	36.62	22720400.0
2005-03-16 08:00:00	IWM	ETF	62.595	62.65	62.325	62.35	71200.0
2005-03-16 09:00:00	IWM	ETF	62.35	62.55	62.205	62.31	1526600.0
2005-03-16 10:00:00	IWM	ETF	62.33	62.64	62.33	62.39	6497400.0
2005-03-16 11:00:00	IWM	ETF	62.39	62.465	62.185	62.345	2214800.0
2005-03-16 12:00:00	IWM	ETF	62.35	62.415	62.25	62.415	1382600.0
2005-03-16 13:00:00	IWM	ETF	62.415	62.43	62.1	62.145	1648200.0
2005-03-16 14:00:00	IWM	ETF	62.145	62.21	62.05	62.105	2324000.0
2005-03-16 15:00:00	IWM	ETF	62.105	62.175	61.975	62.175	4831000.0
2005-03-16 16:00:00	IWM	ETF	62.19	62.27	62.105	62.27	764000.0
2005-03-16 17:00:00	IWM	ETF	62.205	62.205	62.205	62.205	400.0
2005-03-16 08:00:00	DIA	ETF	107.4	107.4	106.86	106.94	62200.0
2005-03-16 09:00:00	DIA	ETF	106.95	107.1	106.87	106.97	712900.0
2005-03-16 10:00:00	DIA	ETF	106.98	107.11	106.54	106.61	1062400.0
2005-03-16 11:00:00	DIA	ETF	106.61	106.74	106.4	106.67	817000.0
2005-03-16 12:00:00	DIA	ETF	106.67	106.89	106.61	106.89	746000.0
2005-03-16 13:00:00	DIA	ETF	106.88	106.92	106.59	106.62	544800.0
2005-03-16 14:00:00	DIA	ETF	106.61	106.71	106.28	106.37	859500.0
2005-03-16 15:00:00	DIA	ETF	106.37	106.7	106.19	106.41	1567000.0
2005-03-16 16:00:00	DIA	ETF	106.4	106.47	106.35	106.43	45200.0
2005-03-16 17:00:00	DIA	ETF	106.36	106.36	106.35	106.35	57300.0
2005-03-16 18:00:00	DIA	ETF	106.35	106.35	106.35	106.35	300.0
2005-03-16 08:00:00	GLD	ETF	44.18	44.26	44.18	44.26	59900.0
2005-03-16 09:00:00	GLD	ETF	44.29	44.32	44.25	44.27	773200.0
2005-03-16 10:00:00	GLD	ETF	44.26	44.35	44.22	44.31	775100.0
2005-03-16 11:00:00	GLD	ETF	44.31	44.31	44.2	44.29	185300.0
2005-03-16 12:00:00	GLD	ETF	44.29	44.33	44.25	44.28	224100.0
2005-03-16 13:00:00	GLD	ETF	44.3	44.33	44.262	44.33	39200.0
2005-03-16 14:00:00	GLD	ETF	44.32	44.34	44.27	44.27	84400.0
2005-03-16 15:00:00	GLD	ETF	44.26	44.35	44.26	44.33	79200.0
2005-03-16 16:00:00	GLD	ETF	44.31	44.31	44.29	44.29	600.0
2005-03-16 08:00:00	TLT	ETF	88.55	88.74	88.53	88.59	45900.0

> showing 50 of 879 rows — these rows as CSV

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