PREVIEW / etf_1hour / 2005-02-16

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-16.parquet
  size:    29 KB
  rows:    838

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-02-16 08:00:00	SPY	ETF	121.02	121.04	120.48	120.72	1204600.0
2005-02-16 09:00:00	SPY	ETF	120.73	120.97	120.73	120.85	6387100.0
2005-02-16 10:00:00	SPY	ETF	120.84	121.13	120.67	120.87	10447400.0
2005-02-16 11:00:00	SPY	ETF	120.87	121.01	120.82	120.87	3788700.0
2005-02-16 12:00:00	SPY	ETF	120.87	120.96	120.77	120.86	6959900.0
2005-02-16 13:00:00	SPY	ETF	120.86	121.05	120.76	120.9	5172200.0
2005-02-16 14:00:00	SPY	ETF	120.9	121.42	120.9	121.39	6614000.0
2005-02-16 15:00:00	SPY	ETF	121.39	121.46	121.16	121.19	8916400.0
2005-02-16 16:00:00	SPY	ETF	121.19	121.26	121.08	121.15	665100.0
2005-02-16 17:00:00	SPY	ETF	121.15	121.22	121.15	121.2	285300.0
2005-02-16 18:00:00	SPY	ETF	121.19	121.19	121.14	121.14	6000.0
2005-02-16 19:00:00	SPY	ETF	121.19	121.23	121.19	121.23	6700.0
2005-02-16 09:00:00	QQQ	ETF	38.03	38.05	37.87	37.95	9447400.0
2005-02-16 10:00:00	QQQ	ETF	37.95	38.16	37.9	38.03	15864100.0
2005-02-16 11:00:00	QQQ	ETF	38.03	38.14	38.0	38.02	6319700.0
2005-02-16 12:00:00	QQQ	ETF	38.02	38.04	37.92	37.97	4856500.0
2005-02-16 13:00:00	QQQ	ETF	37.97	38.01	37.83	37.96	11976900.0
2005-02-16 14:00:00	QQQ	ETF	37.96	38.12	37.96	38.11	10628000.0
2005-02-16 15:00:00	QQQ	ETF	38.11	38.14	37.95	37.98	9899800.0
2005-02-16 08:00:00	IWM	ETF	63.1	63.1	62.87	62.96	109000.0
2005-02-16 09:00:00	IWM	ETF	63.15	63.225	63.0	63.085	1684200.0
2005-02-16 10:00:00	IWM	ETF	63.1	63.36	62.975	63.17	3637400.0
2005-02-16 11:00:00	IWM	ETF	63.16	63.34	63.125	63.31	1063000.0
2005-02-16 12:00:00	IWM	ETF	63.305	63.5	63.17	63.395	1390800.0
2005-02-16 13:00:00	IWM	ETF	63.4	63.45	63.2	63.38	1388400.0
2005-02-16 14:00:00	IWM	ETF	63.395	63.85	63.375	63.825	3634400.0
2005-02-16 15:00:00	IWM	ETF	63.875	63.9	63.51	63.57	4806000.0
2005-02-16 16:00:00	IWM	ETF	63.575	63.685	63.48	63.56	668600.0
2005-02-16 17:00:00	IWM	ETF	63.51	63.525	63.48	63.49	2600.0
2005-02-16 18:00:00	IWM	ETF	63.7687	63.7773	63.7687	63.7773	4600.0
2005-02-16 08:00:00	DIA	ETF	108.29	108.29	107.95	108.15	10100.0
2005-02-16 09:00:00	DIA	ETF	108.2	108.3	108.15	108.21	813100.0
2005-02-16 10:00:00	DIA	ETF	108.22	108.43	108.1	108.2	806400.0
2005-02-16 11:00:00	DIA	ETF	108.2	108.31	108.15	108.19	349200.0
2005-02-16 12:00:00	DIA	ETF	108.18	108.24	108.09	108.17	269900.0
2005-02-16 13:00:00	DIA	ETF	108.18	108.3	108.1	108.22	342200.0
2005-02-16 14:00:00	DIA	ETF	108.22	108.63	108.22	108.62	672200.0
2005-02-16 15:00:00	DIA	ETF	108.61	108.68	108.44	108.47	993400.0
2005-02-16 16:00:00	DIA	ETF	108.43	108.5	108.43	108.48	8400.0
2005-02-16 17:00:00	DIA	ETF	108.45	108.45	108.45	108.45	100.0
2005-02-16 18:00:00	DIA	ETF	108.45	108.45	108.45	108.45	200.0
2005-02-16 09:00:00	GLD	ETF	42.32	42.4	42.3	42.38	482500.0
2005-02-16 10:00:00	GLD	ETF	42.35	42.38	42.2	42.35	856200.0
2005-02-16 11:00:00	GLD	ETF	42.37	42.42	42.33	42.4	74800.0
2005-02-16 12:00:00	GLD	ETF	42.38	42.48	42.38	42.48	42200.0
2005-02-16 13:00:00	GLD	ETF	42.48	42.6	42.48	42.57	136300.0
2005-02-16 14:00:00	GLD	ETF	42.57	42.6	42.54	42.58	129300.0
2005-02-16 15:00:00	GLD	ETF	42.58	42.58	42.5	42.52	97300.0
2005-02-16 16:00:00	GLD	ETF	42.5	42.5	42.5	42.5	200.0
2005-02-16 08:00:00	TLT	ETF	92.67	92.67	92.67	92.67	2500.0

> showing 50 of 838 rows — these rows as CSV

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