PREVIEW / etf_1hour / 2001-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-07.parquet
  size:    11 KB
  rows:    225

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
2001-06-07 09:00:00	SPY	ETF	127.05	127.78	127.05	127.47	1082300.0
2001-06-07 10:00:00	SPY	ETF	127.46	128.13	127.3	127.82	958500.0
2001-06-07 11:00:00	SPY	ETF	127.81	128.0	127.3	127.44	858900.0
2001-06-07 12:00:00	SPY	ETF	127.39	127.44	127.06	127.3	556600.0
2001-06-07 13:00:00	SPY	ETF	127.3	127.96	127.0	127.88	799800.0
2001-06-07 14:00:00	SPY	ETF	127.86	128.13	127.69	127.8	713000.0
2001-06-07 15:00:00	SPY	ETF	127.92	128.29	127.85	128.24	1175600.0
2001-06-07 16:00:00	SPY	ETF	128.22	128.5	128.1	128.45	453400.0
2001-06-07 17:00:00	SPY	ETF	128.52	128.75	128.46	128.7	12300.0
2001-06-07 18:00:00	SPY	ETF	128.65	128.8	128.65	128.8	3600.0
2001-06-07 09:00:00	QQQ	ETF	47.13	47.89	47.07	47.76	8825300.0
2001-06-07 10:00:00	QQQ	ETF	47.77	48.6	47.72	48.26	10957500.0
2001-06-07 11:00:00	QQQ	ETF	48.23	48.39	47.48	48.03	5770900.0
2001-06-07 12:00:00	QQQ	ETF	48.03	48.09	47.74	47.96	4515500.0
2001-06-07 13:00:00	QQQ	ETF	47.97	48.66	47.79	48.6	9050500.0
2001-06-07 14:00:00	QQQ	ETF	48.61	48.84	48.46	48.7	8498200.0
2001-06-07 15:00:00	QQQ	ETF	48.68	48.91	48.5	48.89	10024900.0
2001-06-07 16:00:00	QQQ	ETF	48.88	49.55	48.35	49.4	5130500.0
2001-06-07 17:00:00	QQQ	ETF	49.35	49.62	49.35	49.5	443000.0
2001-06-07 18:00:00	QQQ	ETF	49.5	49.8	49.5	49.69	50200.0
2001-06-07 09:00:00	IWM	ETF	51.0	51.275	51.0	51.275	27600.0
2001-06-07 10:00:00	IWM	ETF	51.195	51.375	51.025	51.375	6800.0
2001-06-07 11:00:00	IWM	ETF	51.375	51.375	51.125	51.17	23800.0
2001-06-07 12:00:00	IWM	ETF	51.145	51.145	51.025	51.025	5000.0
2001-06-07 13:00:00	IWM	ETF	51.1	51.25	51.1	51.25	16400.0
2001-06-07 14:00:00	IWM	ETF	51.27	51.4	51.155	51.375	60600.0
2001-06-07 15:00:00	IWM	ETF	51.45	51.5	51.315	51.45	80000.0
2001-06-07 16:00:00	IWM	ETF	51.575	51.575	51.39	51.39	36200.0
2001-06-07 09:00:00	DIA	ETF	110.45	111.05	110.3	110.8	284700.0
2001-06-07 10:00:00	DIA	ETF	110.8	111.1	110.52	110.8	299300.0
2001-06-07 11:00:00	DIA	ETF	110.87	110.94	110.41	110.49	105700.0
2001-06-07 12:00:00	DIA	ETF	110.5	110.6	110.32	110.49	596900.0
2001-06-07 13:00:00	DIA	ETF	110.36	110.97	110.15	110.97	488800.0
2001-06-07 14:00:00	DIA	ETF	110.86	111.1	110.77	110.87	149800.0
2001-06-07 15:00:00	DIA	ETF	110.91	111.12	110.82	111.05	238900.0
2001-06-07 16:00:00	DIA	ETF	111.0	111.05	110.85	110.91	134800.0
2001-06-07 18:00:00	DIA	ETF	111.5	111.5	111.5	111.5	100.0

> showing 37 of 225 rows — these rows as CSV

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