PREVIEW / etf_1hour / 2001-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-11-14.parquet
  size:    13 KB
  rows:    276

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-11-14 09:00:00	SPY	ETF	115.17	115.4	114.88	114.9	3736900.0
2001-11-14 10:00:00	SPY	ETF	114.88	114.92	113.71	113.95	3244000.0
2001-11-14 11:00:00	SPY	ETF	113.99	114.58	113.92	114.56	1945100.0
2001-11-14 12:00:00	SPY	ETF	114.54	114.56	114.11	114.14	1028000.0
2001-11-14 13:00:00	SPY	ETF	114.11	114.3	113.96	114.17	1260500.0
2001-11-14 14:00:00	SPY	ETF	114.17	114.77	113.91	114.7	2370400.0
2001-11-14 15:00:00	SPY	ETF	114.7	115.0	114.31	114.62	3160500.0
2001-11-14 16:00:00	SPY	ETF	114.59	114.78	114.5	114.5	740600.0
2001-11-14 17:00:00	SPY	ETF	114.49	114.61	114.35	114.59	21700.0
2001-11-14 18:00:00	SPY	ETF	114.46	114.59	114.35	114.59	4100.0
2001-11-14 09:00:00	QQQ	ETF	39.96	40.24	39.72	39.75	15543200.0
2001-11-14 10:00:00	QQQ	ETF	39.73	39.8	38.74	38.96	21081400.0
2001-11-14 11:00:00	QQQ	ETF	38.96	39.45	38.95	39.39	10513900.0
2001-11-14 12:00:00	QQQ	ETF	39.38	39.4	38.96	38.97	7171100.0
2001-11-14 13:00:00	QQQ	ETF	38.99	39.18	38.82	39.03	6245100.0
2001-11-14 14:00:00	QQQ	ETF	39.02	39.57	38.9	39.51	10355900.0
2001-11-14 15:00:00	QQQ	ETF	39.5	39.83	39.31	39.5	14881700.0
2001-11-14 16:00:00	QQQ	ETF	39.49	39.68	39.28	39.3	1573800.0
2001-11-14 17:00:00	QQQ	ETF	39.29	39.44	39.25	39.32	208200.0
2001-11-14 18:00:00	QQQ	ETF	39.32	39.4	39.25	39.25	34600.0
2001-11-14 09:00:00	IWM	ETF	45.0	45.085	44.83	44.885	103400.0
2001-11-14 10:00:00	IWM	ETF	44.88	44.88	44.62	44.645	38800.0
2001-11-14 11:00:00	IWM	ETF	44.65	44.875	44.64	44.835	39000.0
2001-11-14 12:00:00	IWM	ETF	44.84	44.87	44.74	44.755	16600.0
2001-11-14 13:00:00	IWM	ETF	44.755	44.79	44.71	44.79	10400.0
2001-11-14 14:00:00	IWM	ETF	44.74	44.94	44.74	44.94	32400.0
2001-11-14 15:00:00	IWM	ETF	45.0	45.105	44.85	45.05	35800.0
2001-11-14 16:00:00	IWM	ETF	44.975	45.12	44.975	45.12	4800.0
2001-11-14 09:00:00	DIA	ETF	98.45	98.89	98.4	98.41	670300.0
2001-11-14 10:00:00	DIA	ETF	98.46	98.46	97.58	97.82	847100.0
2001-11-14 11:00:00	DIA	ETF	97.83	98.4	97.8	98.32	367600.0
2001-11-14 12:00:00	DIA	ETF	98.31	98.32	97.99	98.0	91900.0
2001-11-14 13:00:00	DIA	ETF	97.96	98.17	97.84	98.0	147900.0
2001-11-14 14:00:00	DIA	ETF	98.11	98.55	97.88	98.55	295500.0
2001-11-14 15:00:00	DIA	ETF	98.45	98.74	98.16	98.35	285900.0
2001-11-14 16:00:00	DIA	ETF	98.35	98.64	98.35	98.64	60700.0

> showing 36 of 276 rows — these rows as CSV

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