PREVIEW / etf_1hour / 2001-08-27

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-27.parquet
  size:    12 KB
  rows:    240

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-27 09:00:00	SPY	ETF	118.97	119.04	118.72	118.85	1355400.0
2001-08-27 10:00:00	SPY	ETF	118.84	118.84	118.33	118.61	1207900.0
2001-08-27 11:00:00	SPY	ETF	118.61	118.76	118.31	118.31	368300.0
2001-08-27 12:00:00	SPY	ETF	118.28	118.69	118.26	118.69	448500.0
2001-08-27 13:00:00	SPY	ETF	118.68	119.05	118.54	118.9	688200.0
2001-08-27 14:00:00	SPY	ETF	118.93	119.15	118.77	119.15	754300.0
2001-08-27 15:00:00	SPY	ETF	119.15	119.2	118.47	118.49	1164000.0
2001-08-27 16:00:00	SPY	ETF	118.49	118.87	118.3	118.32	1424500.0
2001-08-27 09:00:00	QQQ	ETF	39.28	39.54	39.04	39.35	8521100.0
2001-08-27 10:00:00	QQQ	ETF	39.32	39.34	38.83	39.19	11997300.0
2001-08-27 11:00:00	QQQ	ETF	39.18	39.35	38.95	38.95	4239700.0
2001-08-27 12:00:00	QQQ	ETF	38.98	39.25	38.94	39.22	2575600.0
2001-08-27 13:00:00	QQQ	ETF	39.24	39.54	39.09	39.47	4607800.0
2001-08-27 14:00:00	QQQ	ETF	39.47	39.89	39.4	39.81	6672600.0
2001-08-27 15:00:00	QQQ	ETF	39.89	39.9	39.32	39.34	6295900.0
2001-08-27 16:00:00	QQQ	ETF	39.33	39.58	39.2	39.2	909900.0
2001-08-27 17:00:00	QQQ	ETF	39.18	39.35	39.14	39.23	55500.0
2001-08-27 18:00:00	QQQ	ETF	39.21	39.25	39.11	39.22	8700.0
2001-08-27 09:00:00	IWM	ETF	48.05	48.225	48.05	48.125	27400.0
2001-08-27 10:00:00	IWM	ETF	48.11	48.11	47.8	47.99	34800.0
2001-08-27 11:00:00	IWM	ETF	47.99	48.025	47.825	47.825	10200.0
2001-08-27 12:00:00	IWM	ETF	47.89	48.02	47.8	48.02	11600.0
2001-08-27 13:00:00	IWM	ETF	48.0	48.07	48.0	48.07	2800.0
2001-08-27 14:00:00	IWM	ETF	48.095	48.125	48.025	48.08	58200.0
2001-08-27 15:00:00	IWM	ETF	48.125	48.2	47.85	47.85	37000.0
2001-08-27 16:00:00	IWM	ETF	47.75	47.875	47.675	47.875	10200.0
2001-08-27 09:00:00	DIA	ETF	104.5	104.61	104.3	104.31	547400.0
2001-08-27 10:00:00	DIA	ETF	104.31	104.35	104.01	104.19	985200.0
2001-08-27 11:00:00	DIA	ETF	104.19	104.3	104.04	104.04	108800.0
2001-08-27 12:00:00	DIA	ETF	104.02	104.3	103.98	104.29	126600.0
2001-08-27 13:00:00	DIA	ETF	104.35	104.52	104.19	104.38	210300.0
2001-08-27 14:00:00	DIA	ETF	104.43	104.51	104.22	104.51	218200.0
2001-08-27 15:00:00	DIA	ETF	104.51	104.55	104.02	104.02	300100.0
2001-08-27 16:00:00	DIA	ETF	104.02	104.02	103.91	103.91	22900.0

> showing 34 of 240 rows — these rows as CSV

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