PREVIEW / etf_1hour / 2002-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-14.parquet
  size:    15 KB
  rows:    357

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
2002-10-14 08:00:00	SPY	ETF	83.3	83.32	83.26	83.28	19100.0
2002-10-14 09:00:00	SPY	ETF	83.31	84.2	83.04	84.07	7684800.0
2002-10-14 10:00:00	SPY	ETF	84.04	84.5	83.59	83.63	8053700.0
2002-10-14 11:00:00	SPY	ETF	83.63	84.4	83.58	84.27	4289200.0
2002-10-14 12:00:00	SPY	ETF	84.29	84.85	84.0	84.47	4050200.0
2002-10-14 13:00:00	SPY	ETF	84.47	84.6	84.08	84.37	3157200.0
2002-10-14 14:00:00	SPY	ETF	84.35	84.64	83.82	83.89	4029900.0
2002-10-14 15:00:00	SPY	ETF	83.9	84.55	83.85	84.5	5623500.0
2002-10-14 16:00:00	SPY	ETF	84.48	84.69	84.4	84.55	2453800.0
2002-10-14 17:00:00	SPY	ETF	84.57	84.65	84.5	84.57	20500.0
2002-10-14 18:00:00	SPY	ETF	84.62	84.68	84.62	84.64	6400.0
2002-10-14 08:00:00	QQQ	ETF	21.87	21.87	21.86	21.87	6200.0
2002-10-14 09:00:00	QQQ	ETF	21.88	22.25	21.78	22.16	11780800.0
2002-10-14 10:00:00	QQQ	ETF	22.15	22.22	21.94	21.94	15182500.0
2002-10-14 11:00:00	QQQ	ETF	21.95	22.28	21.92	22.23	10223400.0
2002-10-14 12:00:00	QQQ	ETF	22.24	22.48	22.16	22.31	15742100.0
2002-10-14 13:00:00	QQQ	ETF	22.29	22.38	22.16	22.25	5956400.0
2002-10-14 14:00:00	QQQ	ETF	22.26	22.34	22.14	22.16	5906400.0
2002-10-14 15:00:00	QQQ	ETF	22.18	22.42	22.15	22.42	8783200.0
2002-10-14 16:00:00	QQQ	ETF	22.42	22.58	22.35	22.49	3329400.0
2002-10-14 17:00:00	QQQ	ETF	22.49	22.51	22.44	22.47	147700.0
2002-10-14 18:00:00	QQQ	ETF	22.48	22.5	22.45	22.49	44700.0
2002-10-14 19:00:00	QQQ	ETF	22.5	22.5	22.42	22.42	3600.0
2002-10-14 09:00:00	IWM	ETF	34.05	34.44	34.05	34.44	418200.0
2002-10-14 10:00:00	IWM	ETF	34.425	34.56	34.305	34.36	616000.0
2002-10-14 11:00:00	IWM	ETF	34.365	34.475	34.315	34.475	167200.0
2002-10-14 12:00:00	IWM	ETF	34.475	34.555	34.355	34.54	243000.0
2002-10-14 13:00:00	IWM	ETF	34.535	34.615	34.475	34.495	89600.0
2002-10-14 14:00:00	IWM	ETF	34.56	34.57	34.38	34.385	95200.0
2002-10-14 15:00:00	IWM	ETF	34.385	34.585	34.385	34.535	238400.0
2002-10-14 16:00:00	IWM	ETF	34.575	34.685	34.575	34.685	51400.0
2002-10-14 17:00:00	IWM	ETF	34.545	34.545	34.545	34.545	1157800.0
2002-10-14 08:00:00	DIA	ETF	78.26	78.26	77.9	78.05	3500.0
2002-10-14 09:00:00	DIA	ETF	78.14	78.7	77.58	78.6	1897300.0
2002-10-14 10:00:00	DIA	ETF	78.65	78.9	78.1	78.14	3226600.0
2002-10-14 11:00:00	DIA	ETF	78.15	78.95	78.11	78.84	1143200.0
2002-10-14 12:00:00	DIA	ETF	78.84	79.4	78.6	78.9	1650100.0
2002-10-14 13:00:00	DIA	ETF	78.96	79.05	78.6	78.82	1354000.0
2002-10-14 14:00:00	DIA	ETF	78.87	79.05	78.23	78.26	1727300.0
2002-10-14 15:00:00	DIA	ETF	78.31	78.96	78.31	78.93	1188100.0
2002-10-14 16:00:00	DIA	ETF	78.92	79.0	78.79	78.94	120600.0
2002-10-14 17:00:00	DIA	ETF	78.94	79.0	78.94	79.0	2900.0
2002-10-14 18:00:00	DIA	ETF	78.99	79.0	78.99	79.0	900.0
2002-10-14 09:00:00	TLT	ETF	88.5	88.55	88.5	88.55	3500.0
2002-10-14 10:00:00	TLT	ETF	88.41	88.41	88.25	88.35	4100.0
2002-10-14 11:00:00	TLT	ETF	88.34	88.49	88.34	88.34	1800.0
2002-10-14 12:00:00	TLT	ETF	88.25	88.25	88.1	88.1	2000.0
2002-10-14 13:00:00	TLT	ETF	88.11	88.3	88.11	88.3	1000.0
2002-10-14 14:00:00	TLT	ETF	88.3	88.3	88.07	88.15	3600.0
2002-10-14 15:00:00	TLT	ETF	88.2	88.25	88.15	88.25	2300.0

> showing 50 of 357 rows — these rows as CSV

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