PREVIEW / etf_1hour / 2001-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-24.parquet
  size:    12 KB
  rows:    241

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-10-24 09:00:00	SPY	ETF	108.98	109.0	108.22	108.62	2235000.0
2001-10-24 10:00:00	SPY	ETF	108.61	109.39	108.55	108.95	3877400.0
2001-10-24 11:00:00	SPY	ETF	108.94	109.11	108.47	108.84	1753900.0
2001-10-24 12:00:00	SPY	ETF	108.82	109.11	108.51	109.11	1417400.0
2001-10-24 13:00:00	SPY	ETF	109.11	109.45	108.76	108.77	1830900.0
2001-10-24 14:00:00	SPY	ETF	108.75	109.2	108.5	108.88	2122600.0
2001-10-24 15:00:00	SPY	ETF	108.79	109.02	108.6	108.85	1635300.0
2001-10-24 16:00:00	SPY	ETF	108.77	108.88	107.6	108.7	1111700.0
2001-10-24 17:00:00	SPY	ETF	108.75	108.75	108.7	108.75	51000.0
2001-10-24 18:00:00	SPY	ETF	108.7	108.7	108.7	108.7	200.0
2001-10-24 09:00:00	QQQ	ETF	34.6	34.8	34.32	34.7	9454000.0
2001-10-24 10:00:00	QQQ	ETF	34.73	35.38	34.66	35.12	20508500.0
2001-10-24 11:00:00	QQQ	ETF	35.1	35.24	34.86	35.18	7936200.0
2001-10-24 12:00:00	QQQ	ETF	35.18	35.48	34.96	35.45	9644200.0
2001-10-24 13:00:00	QQQ	ETF	35.44	35.68	35.15	35.25	13210700.0
2001-10-24 14:00:00	QQQ	ETF	35.3	35.55	34.97	35.29	15461300.0
2001-10-24 15:00:00	QQQ	ETF	35.29	35.49	35.15	35.45	10373400.0
2001-10-24 16:00:00	QQQ	ETF	35.44	35.48	34.98	35.39	2937700.0
2001-10-24 17:00:00	QQQ	ETF	35.4	35.43	35.3	35.38	210100.0
2001-10-24 18:00:00	QQQ	ETF	35.33	35.4	35.33	35.37	14200.0
2001-10-24 09:00:00	IWM	ETF	42.5	42.565	42.41	42.5	23000.0
2001-10-24 10:00:00	IWM	ETF	42.535	42.63	42.515	42.61	5600.0
2001-10-24 11:00:00	IWM	ETF	42.6	42.625	42.385	42.435	213600.0
2001-10-24 12:00:00	IWM	ETF	42.49	42.545	42.3	42.545	19800.0
2001-10-24 13:00:00	IWM	ETF	42.54	42.62	42.51	42.57	59200.0
2001-10-24 14:00:00	IWM	ETF	42.495	42.6	42.485	42.485	101600.0
2001-10-24 15:00:00	IWM	ETF	42.555	42.69	42.5	42.69	99800.0
2001-10-24 16:00:00	IWM	ETF	42.675	42.675	42.675	42.675	5000.0
2001-10-24 09:00:00	DIA	ETF	93.65	93.65	92.85	93.11	639200.0
2001-10-24 10:00:00	DIA	ETF	93.2	93.8	93.1	93.56	915000.0
2001-10-24 11:00:00	DIA	ETF	93.55	93.6	93.07	93.24	157200.0
2001-10-24 12:00:00	DIA	ETF	93.25	93.64	93.08	93.64	170700.0
2001-10-24 13:00:00	DIA	ETF	93.64	94.0	93.5	93.5	358300.0
2001-10-24 14:00:00	DIA	ETF	93.46	93.87	93.25	93.6	313700.0
2001-10-24 15:00:00	DIA	ETF	93.52	93.7	93.35	93.6	232400.0
2001-10-24 16:00:00	DIA	ETF	93.54	93.6	93.32	93.46	35800.0

> showing 36 of 241 rows — these rows as CSV

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