PREVIEW / etf_1hour / 2001-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-01.parquet
  size:    11 KB
  rows:    227

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-01 09:00:00	SPY	ETF	126.2	126.39	125.71	126.04	1160300.0
2001-06-01 10:00:00	SPY	ETF	126.14	126.25	125.12	125.7	2541200.0
2001-06-01 11:00:00	SPY	ETF	125.71	125.9	125.52	125.7	502100.0
2001-06-01 12:00:00	SPY	ETF	125.75	126.43	125.61	126.14	742800.0
2001-06-01 13:00:00	SPY	ETF	126.14	126.48	125.86	126.22	820300.0
2001-06-01 14:00:00	SPY	ETF	126.24	126.96	126.19	126.95	709200.0
2001-06-01 15:00:00	SPY	ETF	126.99	127.09	126.3	126.64	1349100.0
2001-06-01 16:00:00	SPY	ETF	126.64	126.89	125.91	125.91	443400.0
2001-06-01 17:00:00	SPY	ETF	126.93	126.93	126.9	126.9	4000.0
2001-06-01 09:00:00	QQQ	ETF	45.54	45.75	45.24	45.46	8213300.0
2001-06-01 10:00:00	QQQ	ETF	45.46	45.8	44.44	45.1	16495400.0
2001-06-01 11:00:00	QQQ	ETF	45.1	45.39	44.95	45.17	6051900.0
2001-06-01 12:00:00	QQQ	ETF	45.19	45.7	45.06	45.49	5174700.0
2001-06-01 13:00:00	QQQ	ETF	45.5	45.7	45.24	45.45	3208400.0
2001-06-01 14:00:00	QQQ	ETF	45.45	46.1	45.4	46.0	6046700.0
2001-06-01 15:00:00	QQQ	ETF	46.06	46.15	45.46	45.92	9323700.0
2001-06-01 16:00:00	QQQ	ETF	45.9	46.3	45.85	46.15	1728500.0
2001-06-01 17:00:00	QQQ	ETF	46.12	46.13	46.05	46.11	24500.0
2001-06-01 18:00:00	QQQ	ETF	46.1	46.16	46.05	46.05	5200.0
2001-06-01 09:00:00	IWM	ETF	49.875	49.9	49.55	49.575	66400.0
2001-06-01 10:00:00	IWM	ETF	49.5	49.65	49.25	49.445	68600.0
2001-06-01 11:00:00	IWM	ETF	49.45	49.55	49.375	49.45	55400.0
2001-06-01 12:00:00	IWM	ETF	49.45	49.795	49.45	49.75	39600.0
2001-06-01 13:00:00	IWM	ETF	49.795	49.88	49.71	49.875	83000.0
2001-06-01 14:00:00	IWM	ETF	49.87	50.025	49.85	50.025	39800.0
2001-06-01 15:00:00	IWM	ETF	50.22	50.22	49.85	49.995	51400.0
2001-06-01 16:00:00	IWM	ETF	50.03	50.145	50.03	50.135	6800.0
2001-06-01 09:00:00	DIA	ETF	109.5	109.6	108.8	109.14	327100.0
2001-06-01 10:00:00	DIA	ETF	109.24	109.24	108.4	108.85	430000.0
2001-06-01 11:00:00	DIA	ETF	108.99	109.19	108.8	109.0	352900.0
2001-06-01 12:00:00	DIA	ETF	109.04	109.56	108.97	109.34	202000.0
2001-06-01 13:00:00	DIA	ETF	109.35	109.93	109.19	109.65	199500.0
2001-06-01 14:00:00	DIA	ETF	109.64	110.3	109.61	110.3	241900.0
2001-06-01 15:00:00	DIA	ETF	110.31	110.42	109.97	110.1	436400.0
2001-06-01 16:00:00	DIA	ETF	110.2	110.45	110.1	110.45	119300.0

> showing 35 of 227 rows — these rows as CSV

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