PREVIEW / etf_1hour / 2001-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-05.parquet
  size:    12 KB
  rows:    235

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-05 09:00:00	SPY	ETF	127.49	127.96	127.27	127.8	1468500.0
2001-06-05 10:00:00	SPY	ETF	127.77	128.16	127.51	127.89	1423100.0
2001-06-05 11:00:00	SPY	ETF	127.84	128.56	127.7	128.48	1017600.0
2001-06-05 12:00:00	SPY	ETF	128.44	128.6	128.17	128.49	466500.0
2001-06-05 13:00:00	SPY	ETF	128.45	128.56	128.12	128.32	907000.0
2001-06-05 14:00:00	SPY	ETF	128.36	128.76	128.2	128.7	802100.0
2001-06-05 15:00:00	SPY	ETF	128.75	129.23	128.61	128.87	1536600.0
2001-06-05 16:00:00	SPY	ETF	128.85	129.0	128.6	128.8	1143200.0
2001-06-05 17:00:00	SPY	ETF	128.87	128.88	128.87	128.88	700.0
2001-06-05 18:00:00	SPY	ETF	128.83	128.83	128.7	128.7	500.0
2001-06-05 09:00:00	QQQ	ETF	46.3	47.14	46.2	47.0	14419800.0
2001-06-05 10:00:00	QQQ	ETF	47.01	47.68	46.95	47.35	15761500.0
2001-06-05 11:00:00	QQQ	ETF	47.33	47.85	47.18	47.66	6906700.0
2001-06-05 12:00:00	QQQ	ETF	47.67	47.94	47.56	47.76	3894900.0
2001-06-05 13:00:00	QQQ	ETF	47.77	47.94	47.62	47.89	3564700.0
2001-06-05 14:00:00	QQQ	ETF	47.85	48.15	47.72	48.15	7797800.0
2001-06-05 15:00:00	QQQ	ETF	48.15	48.36	47.86	47.96	10584500.0
2001-06-05 16:00:00	QQQ	ETF	47.95	48.0	47.4	47.88	2983200.0
2001-06-05 17:00:00	QQQ	ETF	47.97	48.05	47.9	47.95	40200.0
2001-06-05 18:00:00	QQQ	ETF	48.02	48.05	47.96	48.05	6800.0
2001-06-05 09:00:00	IWM	ETF	50.8	50.995	50.725	50.925	27200.0
2001-06-05 10:00:00	IWM	ETF	50.975	51.125	50.9	51.12	74200.0
2001-06-05 11:00:00	IWM	ETF	51.12	51.36	51.045	51.36	187600.0
2001-06-05 12:00:00	IWM	ETF	51.33	51.42	51.25	51.385	518400.0
2001-06-05 13:00:00	IWM	ETF	51.325	51.47	51.325	51.47	206000.0
2001-06-05 14:00:00	IWM	ETF	51.47	51.495	51.38	51.495	10600.0
2001-06-05 15:00:00	IWM	ETF	51.5	51.725	51.45	51.495	91600.0
2001-06-05 16:00:00	IWM	ETF	51.55	51.675	51.5	51.5	3400.0
2001-06-05 09:00:00	DIA	ETF	110.7	111.0	110.53	110.81	179600.0
2001-06-05 10:00:00	DIA	ETF	110.81	111.14	110.45	110.73	290800.0
2001-06-05 11:00:00	DIA	ETF	110.83	111.64	110.6	111.5	526100.0
2001-06-05 12:00:00	DIA	ETF	111.46	111.7	111.4	111.63	85100.0
2001-06-05 13:00:00	DIA	ETF	111.64	111.69	111.29	111.48	75100.0
2001-06-05 14:00:00	DIA	ETF	111.5	111.75	111.4	111.75	217300.0
2001-06-05 15:00:00	DIA	ETF	111.79	112.18	111.63	111.8	358200.0
2001-06-05 16:00:00	DIA	ETF	111.75	112.0	111.75	111.96	138400.0

> showing 36 of 235 rows — these rows as CSV

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