PREVIEW / etf_1hour / 2001-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-16.parquet
  size:    12 KB
  rows:    226

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-08-16 09:00:00	SPY	ETF	117.8	117.88	117.25	117.5	1402100.0
2001-08-16 10:00:00	SPY	ETF	117.52	117.96	117.02	117.28	1924200.0
2001-08-16 11:00:00	SPY	ETF	117.24	117.79	117.24	117.58	946700.0
2001-08-16 12:00:00	SPY	ETF	117.56	117.58	117.04	117.27	804500.0
2001-08-16 13:00:00	SPY	ETF	117.24	117.7	117.01	117.61	1016400.0
2001-08-16 14:00:00	SPY	ETF	117.61	118.31	117.56	118.28	1805200.0
2001-08-16 15:00:00	SPY	ETF	118.29	118.75	117.93	118.62	1774600.0
2001-08-16 16:00:00	SPY	ETF	118.62	118.7	118.45	118.55	490800.0
2001-08-16 17:00:00	SPY	ETF	118.6	118.66	118.51	118.51	300.0
2001-08-16 18:00:00	SPY	ETF	118.42	118.42	118.41	118.41	1100.0
2001-08-16 09:00:00	QQQ	ETF	38.64	39.0	38.04	38.25	12981500.0
2001-08-16 10:00:00	QQQ	ETF	38.24	38.61	38.12	38.25	11476700.0
2001-08-16 11:00:00	QQQ	ETF	38.25	38.52	38.25	38.45	4944900.0
2001-08-16 12:00:00	QQQ	ETF	38.48	38.48	38.14	38.29	5190400.0
2001-08-16 13:00:00	QQQ	ETF	38.26	38.59	38.14	38.56	6120500.0
2001-08-16 14:00:00	QQQ	ETF	38.56	39.14	38.5	39.02	10531200.0
2001-08-16 15:00:00	QQQ	ETF	39.04	39.39	38.8	39.37	11575100.0
2001-08-16 16:00:00	QQQ	ETF	39.37	39.65	39.25	39.4	2523600.0
2001-08-16 17:00:00	QQQ	ETF	39.41	39.5	39.36	39.38	67800.0
2001-08-16 18:00:00	QQQ	ETF	39.41	39.5	39.3	39.42	28900.0
2001-08-16 09:00:00	IWM	ETF	47.625	47.625	47.33	47.335	19600.0
2001-08-16 10:00:00	IWM	ETF	47.37	47.56	47.25	47.445	127200.0
2001-08-16 11:00:00	IWM	ETF	47.495	47.525	47.325	47.41	333000.0
2001-08-16 12:00:00	IWM	ETF	47.4	47.475	47.4	47.42	222400.0
2001-08-16 13:00:00	IWM	ETF	47.38	47.54	47.38	47.54	336600.0
2001-08-16 14:00:00	IWM	ETF	47.525	47.8	47.525	47.75	220000.0
2001-08-16 15:00:00	IWM	ETF	47.705	48.2	47.635	48.13	273000.0
2001-08-16 16:00:00	IWM	ETF	48.145	48.25	48.1	48.1	46400.0
2001-08-16 09:00:00	DIA	ETF	103.32	103.5	103.08	103.26	658900.0
2001-08-16 10:00:00	DIA	ETF	103.26	103.65	102.89	103.18	749600.0
2001-08-16 11:00:00	DIA	ETF	103.15	103.52	103.12	103.3	347800.0
2001-08-16 12:00:00	DIA	ETF	103.28	103.28	102.9	103.0	266300.0
2001-08-16 13:00:00	DIA	ETF	103.02	103.32	102.92	103.3	259200.0
2001-08-16 14:00:00	DIA	ETF	103.27	103.89	103.2	103.81	538000.0
2001-08-16 15:00:00	DIA	ETF	103.84	104.2	103.48	104.1	610500.0
2001-08-16 16:00:00	DIA	ETF	104.1	104.25	104.02	104.25	224600.0

> showing 36 of 226 rows — these rows as CSV

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