PREVIEW / etf_1hour / 2002-11-22

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-22.parquet
  size:    16 KB
  rows:    380

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-11-22 08:00:00	SPY	ETF	93.79	93.81	93.55	93.56	26100.0
2002-11-22 09:00:00	SPY	ETF	93.55	93.87	93.27	93.77	4450800.0
2002-11-22 10:00:00	SPY	ETF	93.83	94.09	93.39	93.52	5758800.0
2002-11-22 11:00:00	SPY	ETF	93.48	93.84	93.31	93.38	2938400.0
2002-11-22 12:00:00	SPY	ETF	93.34	93.9	93.28	93.75	1743600.0
2002-11-22 13:00:00	SPY	ETF	93.75	93.9	93.6	93.77	1340000.0
2002-11-22 14:00:00	SPY	ETF	93.77	94.23	93.72	93.99	4540000.0
2002-11-22 15:00:00	SPY	ETF	94.04	94.27	93.45	93.62	6783200.0
2002-11-22 16:00:00	SPY	ETF	93.59	93.68	93.16	93.34	2356300.0
2002-11-22 17:00:00	SPY	ETF	93.35	93.49	93.34	93.4	15600.0
2002-11-22 18:00:00	SPY	ETF	93.42	93.5	93.42	93.5	200.0
2002-11-22 19:00:00	SPY	ETF	93.42	93.42	93.4	93.4	900.0
2002-11-22 08:00:00	QQQ	ETF	27.56	27.61	27.0	27.46	124900.0
2002-11-22 09:00:00	QQQ	ETF	27.45	27.72	27.32	27.64	13973400.0
2002-11-22 10:00:00	QQQ	ETF	27.65	27.8	27.39	27.42	12656400.0
2002-11-22 11:00:00	QQQ	ETF	27.43	27.63	27.41	27.46	6868100.0
2002-11-22 12:00:00	QQQ	ETF	27.46	27.7	27.44	27.64	6455400.0
2002-11-22 13:00:00	QQQ	ETF	27.65	27.73	27.59	27.68	3861700.0
2002-11-22 14:00:00	QQQ	ETF	27.68	27.92	27.65	27.75	10266700.0
2002-11-22 15:00:00	QQQ	ETF	27.81	27.94	27.58	27.73	11681100.0
2002-11-22 16:00:00	QQQ	ETF	27.73	27.79	27.65	27.75	2759700.0
2002-11-22 17:00:00	QQQ	ETF	27.75	27.75	27.68	27.71	37300.0
2002-11-22 18:00:00	QQQ	ETF	27.73	27.77	27.7	27.77	17200.0
2002-11-22 19:00:00	QQQ	ETF	27.76	27.77	27.73	27.73	2800.0
2002-11-22 09:00:00	IWM	ETF	39.4	39.55	39.335	39.55	257800.0
2002-11-22 10:00:00	IWM	ETF	39.555	39.75	39.515	39.54	663000.0
2002-11-22 11:00:00	IWM	ETF	39.595	39.685	39.5	39.525	379400.0
2002-11-22 12:00:00	IWM	ETF	39.53	39.76	39.53	39.755	218400.0
2002-11-22 13:00:00	IWM	ETF	39.74	39.845	39.71	39.835	566800.0
2002-11-22 14:00:00	IWM	ETF	39.835	40.05	39.835	39.95	177200.0
2002-11-22 15:00:00	IWM	ETF	40.005	40.07	39.85	40.01	1551400.0
2002-11-22 16:00:00	IWM	ETF	39.96	39.96	39.92	39.925	2000.0
2002-11-22 08:00:00	DIA	ETF	87.0	88.46	87.0	88.38	10500.0
2002-11-22 09:00:00	DIA	ETF	88.45	88.78	88.14	88.72	750400.0
2002-11-22 10:00:00	DIA	ETF	88.73	88.99	88.48	88.58	2466800.0
2002-11-22 11:00:00	DIA	ETF	88.56	88.92	88.22	88.26	1225100.0
2002-11-22 12:00:00	DIA	ETF	88.26	88.77	88.18	88.63	750300.0
2002-11-22 13:00:00	DIA	ETF	88.56	88.73	88.45	88.63	316400.0
2002-11-22 14:00:00	DIA	ETF	88.61	88.99	88.54	88.74	687200.0
2002-11-22 15:00:00	DIA	ETF	88.75	88.97	88.18	88.32	1119200.0
2002-11-22 16:00:00	DIA	ETF	88.33	88.34	88.12	88.14	140600.0
2002-11-22 17:00:00	DIA	ETF	88.24	88.44	88.24	88.3	1900.0
2002-11-22 09:00:00	TLT	ETF	86.33	86.39	86.14	86.2	8100.0
2002-11-22 10:00:00	TLT	ETF	86.25	86.25	85.88	86.1	33400.0
2002-11-22 11:00:00	TLT	ETF	86.05	86.1	86.0	86.05	2300.0
2002-11-22 12:00:00	TLT	ETF	86.09	86.11	86.05	86.09	33600.0
2002-11-22 13:00:00	TLT	ETF	86.03	86.15	86.03	86.14	2500.0
2002-11-22 14:00:00	TLT	ETF	86.11	86.11	85.95	86.0	11400.0
2002-11-22 15:00:00	TLT	ETF	86.0	86.09	85.9	86.04	92900.0

> showing 49 of 380 rows — these rows as CSV

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