PREVIEW / etf_1hour / 2005-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-08.parquet
  size:    28 KB
  rows:    816

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-08 08:00:00	SPY	ETF	120.27	120.27	120.14	120.15	26200.0
2005-02-08 09:00:00	SPY	ETF	120.18	120.4	120.07	120.4	4326900.0
2005-02-08 10:00:00	SPY	ETF	120.4	120.65	120.33	120.5	6492400.0
2005-02-08 11:00:00	SPY	ETF	120.48	120.58	120.32	120.39	3979400.0
2005-02-08 12:00:00	SPY	ETF	120.39	120.41	120.08	120.2	5705100.0
2005-02-08 13:00:00	SPY	ETF	120.2	120.44	120.11	120.31	5545100.0
2005-02-08 14:00:00	SPY	ETF	120.31	120.47	120.27	120.43	6563100.0
2005-02-08 15:00:00	SPY	ETF	120.43	120.5	120.31	120.34	4073600.0
2005-02-08 16:00:00	SPY	ETF	120.35	120.3858	120.15	120.28	1197800.0
2005-02-08 17:00:00	SPY	ETF	120.22	120.24	120.15	120.22	67400.0
2005-02-08 18:00:00	SPY	ETF	120.26	120.29	120.25	120.27	2100.0
2005-02-08 19:00:00	SPY	ETF	120.27	120.27	120.23	120.23	3600.0
2005-02-08 09:00:00	QQQ	ETF	37.65	37.84	37.63	37.84	7544500.0
2005-02-08 10:00:00	QQQ	ETF	37.84	38.01	37.35	37.89	14573100.0
2005-02-08 11:00:00	QQQ	ETF	37.9	37.95	37.81	37.83	5856100.0
2005-02-08 12:00:00	QQQ	ETF	37.83	37.83	37.62	37.71	11990800.0
2005-02-08 13:00:00	QQQ	ETF	37.71	37.81	37.66	37.73	7302700.0
2005-02-08 14:00:00	QQQ	ETF	37.73	37.81	37.72	37.78	10688400.0
2005-02-08 15:00:00	QQQ	ETF	37.78	37.8	37.71	37.74	7804000.0
2005-02-08 09:00:00	IWM	ETF	63.355	63.61	63.345	63.6	704200.0
2005-02-08 10:00:00	IWM	ETF	63.625	63.73	63.56	63.575	2973800.0
2005-02-08 11:00:00	IWM	ETF	63.6	63.625	63.465	63.48	875400.0
2005-02-08 12:00:00	IWM	ETF	63.465	63.485	63.3	63.375	1500600.0
2005-02-08 13:00:00	IWM	ETF	63.38	63.53	63.345	63.52	1708000.0
2005-02-08 14:00:00	IWM	ETF	63.52	63.57	63.4455	63.57	655400.0
2005-02-08 15:00:00	IWM	ETF	63.575	63.65	63.505	63.555	1382200.0
2005-02-08 16:00:00	IWM	ETF	63.53	63.57	63.39	63.495	808000.0
2005-02-08 08:00:00	DIA	ETF	107.1	107.1	107.1	107.1	200.0
2005-02-08 09:00:00	DIA	ETF	107.09	107.17	106.91	107.16	778200.0
2005-02-08 10:00:00	DIA	ETF	107.16	107.42	107.12	107.34	1703600.0
2005-02-08 11:00:00	DIA	ETF	107.35	107.41	107.22	107.26	376000.0
2005-02-08 12:00:00	DIA	ETF	107.26	107.27	107.03	107.11	562000.0
2005-02-08 13:00:00	DIA	ETF	107.12	107.35	107.05	107.28	314500.0
2005-02-08 14:00:00	DIA	ETF	107.28	107.4	107.24	107.36	388300.0
2005-02-08 15:00:00	DIA	ETF	107.36	107.4	107.27	107.29	729200.0
2005-02-08 16:00:00	DIA	ETF	107.3	107.33	107.18	107.28	16000.0
2005-02-08 17:00:00	DIA	ETF	107.25	107.25	107.25	107.25	25000.0
2005-02-08 09:00:00	GLD	ETF	41.19	41.23	41.08	41.1	200700.0
2005-02-08 10:00:00	GLD	ETF	41.1	41.23	41.05	41.19	363000.0
2005-02-08 11:00:00	GLD	ETF	41.2	41.39	41.17	41.29	277500.0
2005-02-08 12:00:00	GLD	ETF	41.3	41.4	41.27	41.3	91400.0
2005-02-08 13:00:00	GLD	ETF	41.29	41.31	41.25	41.27	135100.0
2005-02-08 14:00:00	GLD	ETF	41.27	41.32	41.25	41.3	107300.0
2005-02-08 15:00:00	GLD	ETF	41.29	41.31	41.23	41.3	121200.0
2005-02-08 16:00:00	GLD	ETF	41.3	41.3	41.25	41.25	300.0
2005-02-08 08:00:00	TLT	ETF	93.31	93.31	93.3	93.31	10100.0
2005-02-08 09:00:00	TLT	ETF	93.41	93.48	93.37	93.37	104400.0
2005-02-08 10:00:00	TLT	ETF	93.35	93.75	93.33	93.73	240400.0
2005-02-08 11:00:00	TLT	ETF	93.75	93.97	93.75	93.85	243700.0
2005-02-08 12:00:00	TLT	ETF	93.86	94.12	93.84	93.91	209700.0

> showing 50 of 816 rows — these rows as CSV

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