PREVIEW / etf_1hour / 2006-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-23.parquet
  size:    39 KB
  rows:    1,221

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
2006-02-23 06:00:00	SPY	ETF	129.24	129.26	129.24	129.26	36000.0
2006-02-23 07:00:00	SPY	ETF	129.3	129.3	129.23	129.23	9000.0
2006-02-23 08:00:00	SPY	ETF	129.2	129.3	129.18	129.22	894700.0
2006-02-23 09:00:00	SPY	ETF	129.21	129.28	128.8	128.88	6962100.0
2006-02-23 10:00:00	SPY	ETF	128.87	129.26	128.71	129.17	7673900.0
2006-02-23 11:00:00	SPY	ETF	129.19	129.47	129.1	129.17	6262700.0
2006-02-23 12:00:00	SPY	ETF	129.16	129.63	129.05	129.57	3878900.0
2006-02-23 13:00:00	SPY	ETF	129.55	129.64	129.36	129.46	3566400.0
2006-02-23 14:00:00	SPY	ETF	129.45	129.58	129.19	129.3905	4136800.0
2006-02-23 15:00:00	SPY	ETF	129.4	129.5	128.97	129.01	6930100.0
2006-02-23 16:00:00	SPY	ETF	129.01	129.08	128.96	129.01	1757800.0
2006-02-23 17:00:00	SPY	ETF	129.01	129.15	129.01	129.1	55600.0
2006-02-23 18:00:00	SPY	ETF	129.15	129.17	129.15	129.15	26900.0
2006-02-23 19:00:00	SPY	ETF	129.16	129.18	129.16	129.18	4800.0
2006-02-23 09:00:00	QQQ	ETF	41.22	41.25	41.08	41.14	7218100.0
2006-02-23 10:00:00	QQQ	ETF	41.13	41.35	41.08	41.3	11164100.0
2006-02-23 11:00:00	QQQ	ETF	41.3	41.44	41.25	41.3	8703600.0
2006-02-23 12:00:00	QQQ	ETF	41.3	41.47	41.26	41.45	6791600.0
2006-02-23 13:00:00	QQQ	ETF	41.45	41.54	41.39	41.44	7360200.0
2006-02-23 14:00:00	QQQ	ETF	41.45	41.47	41.31	41.38	7463700.0
2006-02-23 15:00:00	QQQ	ETF	41.37	41.4	41.11	41.14	13061500.0
2006-02-23 08:00:00	IWM	ETF	72.7	72.73	72.7	72.7	357800.0
2006-02-23 09:00:00	IWM	ETF	72.71	72.77	72.44	72.44	2814400.0
2006-02-23 10:00:00	IWM	ETF	72.43	72.82	72.38	72.75	3280400.0
2006-02-23 11:00:00	IWM	ETF	72.75	73.11	72.7	73.04	6873500.0
2006-02-23 12:00:00	IWM	ETF	73.05	73.27	72.96	73.21	5707100.0
2006-02-23 13:00:00	IWM	ETF	73.21	73.24	73.09	73.19	3847100.0
2006-02-23 14:00:00	IWM	ETF	73.19	73.26	73.03	73.04	2594000.0
2006-02-23 15:00:00	IWM	ETF	73.05	73.08	72.66	72.74	8897700.0
2006-02-23 16:00:00	IWM	ETF	72.74	72.85	72.73	72.73	175300.0
2006-02-23 17:00:00	IWM	ETF	72.73	72.99	72.72	72.99	6300.0
2006-02-23 18:00:00	IWM	ETF	72.78	72.78	72.78	72.78	2000.0
2006-02-23 19:00:00	IWM	ETF	72.82	72.82	72.82	72.82	700.0
2006-02-23 08:00:00	DIA	ETF	111.13	111.16	111.08	111.08	3900.0
2006-02-23 09:00:00	DIA	ETF	111.1	111.11	110.64	110.65	2483700.0
2006-02-23 10:00:00	DIA	ETF	110.65	110.91	110.48	110.72	2587400.0
2006-02-23 11:00:00	DIA	ETF	110.74	111.07	110.7	110.87	913900.0
2006-02-23 12:00:00	DIA	ETF	110.88	111.34	110.71	111.27	810400.0
2006-02-23 13:00:00	DIA	ETF	111.28	111.3	111.0	111.02	429200.0
2006-02-23 14:00:00	DIA	ETF	111.05	111.12	110.82	110.95	916100.0
2006-02-23 15:00:00	DIA	ETF	110.95	111.03	110.59	110.7	1027800.0
2006-02-23 16:00:00	DIA	ETF	110.7	110.77	110.7	110.7	262700.0
2006-02-23 18:00:00	DIA	ETF	110.75	110.75	110.75	110.75	100.0
2006-02-23 07:00:00	GLD	ETF	55.21	55.21	55.16	55.16	2500.0
2006-02-23 08:00:00	GLD	ETF	55.14	55.14	54.96	55.1	11600.0
2006-02-23 09:00:00	GLD	ETF	55.12	55.13	54.92	54.95	292700.0
2006-02-23 10:00:00	GLD	ETF	54.96	55.07	54.82	55.0501	264900.0
2006-02-23 11:00:00	GLD	ETF	55.06	55.11	54.98	55.04	293500.0
2006-02-23 12:00:00	GLD	ETF	55.06	55.09	54.681	54.6971	306000.0
2006-02-23 13:00:00	GLD	ETF	54.7	54.75	54.55	54.67	702100.0

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

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