PREVIEW / etf_1hour / 2001-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-09-20.parquet
  size:    13 KB
  rows:    269

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-09-20 09:00:00	SPY	ETF	100.4	100.95	99.95	100.85	4488700.0
2001-09-20 10:00:00	SPY	ETF	100.68	101.17	99.3	100.12	8500300.0
2001-09-20 11:00:00	SPY	ETF	100.1	100.5	99.5	99.7	4920400.0
2001-09-20 12:00:00	SPY	ETF	99.75	100.06	98.8	99.18	4045000.0
2001-09-20 13:00:00	SPY	ETF	99.06	100.4	99.06	100.35	2390900.0
2001-09-20 14:00:00	SPY	ETF	100.4	100.46	99.45	99.76	3285500.0
2001-09-20 15:00:00	SPY	ETF	99.75	100.04	98.81	98.96	4124600.0
2001-09-20 16:00:00	SPY	ETF	98.95	99.7	98.25	98.64	2650400.0
2001-09-20 17:00:00	SPY	ETF	98.59	98.85	98.55	98.81	67700.0
2001-09-20 18:00:00	SPY	ETF	98.95	98.95	98.7	98.75	300.0
2001-09-20 09:00:00	QQQ	ETF	29.3	29.94	29.2	29.9	13433700.0
2001-09-20 10:00:00	QQQ	ETF	29.89	30.09	29.08	29.7	19327900.0
2001-09-20 11:00:00	QQQ	ETF	29.75	29.82	29.3	29.37	8391700.0
2001-09-20 12:00:00	QQQ	ETF	29.37	29.61	28.95	29.06	10506300.0
2001-09-20 13:00:00	QQQ	ETF	29.08	29.8	29.05	29.75	9153500.0
2001-09-20 14:00:00	QQQ	ETF	29.75	29.81	29.23	29.31	8168900.0
2001-09-20 15:00:00	QQQ	ETF	29.3	29.54	28.85	28.98	16514300.0
2001-09-20 16:00:00	QQQ	ETF	28.99	29.94	28.8	28.94	1659300.0
2001-09-20 17:00:00	QQQ	ETF	28.95	29.02	28.9	29.0	58200.0
2001-09-20 18:00:00	QQQ	ETF	29.04	29.15	28.96	28.96	10200.0
2001-09-20 09:00:00	IWM	ETF	39.55	39.62	39.255	39.565	18000.0
2001-09-20 10:00:00	IWM	ETF	39.625	39.625	38.95	39.15	105200.0
2001-09-20 11:00:00	IWM	ETF	39.15	39.375	38.975	38.975	12200.0
2001-09-20 12:00:00	IWM	ETF	39.175	39.175	38.7	38.7	2800.0
2001-09-20 13:00:00	IWM	ETF	38.7	38.75	38.605	38.75	128400.0
2001-09-20 14:00:00	IWM	ETF	39.0	39.0	38.75	38.8	134600.0
2001-09-20 15:00:00	IWM	ETF	38.8	38.875	38.3	38.555	308200.0
2001-09-20 09:00:00	DIA	ETF	86.5	86.9	85.85	86.35	1278600.0
2001-09-20 10:00:00	DIA	ETF	86.34	86.75	84.75	85.46	2267300.0
2001-09-20 11:00:00	DIA	ETF	85.4	86.08	84.95	85.14	1511100.0
2001-09-20 12:00:00	DIA	ETF	85.15	85.45	84.25	84.6	1100400.0
2001-09-20 13:00:00	DIA	ETF	84.63	85.51	84.51	85.47	1092400.0
2001-09-20 14:00:00	DIA	ETF	85.51	85.59	84.62	84.85	745700.0
2001-09-20 15:00:00	DIA	ETF	84.9	85.2	83.7	83.9	1348700.0
2001-09-20 16:00:00	DIA	ETF	83.76	83.9	83.5	83.5	273800.0
2001-09-20 17:00:00	DIA	ETF	83.5	83.52	83.5	83.52	3100.0
2001-09-20 18:00:00	DIA	ETF	83.56	83.56	83.56	83.56	400.0

> showing 37 of 269 rows — these rows as CSV

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