PREVIEW / etf_1hour / 2002-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-30.parquet
  size:    16 KB
  rows:    365

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-30 08:00:00	SPY	ETF	88.66	88.8	88.66	88.67	4200.0
2002-10-30 09:00:00	SPY	ETF	88.72	88.99	88.23	88.24	4127100.0
2002-10-30 10:00:00	SPY	ETF	88.28	89.4	88.23	89.25	5832900.0
2002-10-30 11:00:00	SPY	ETF	89.22	89.96	89.17	89.44	5866600.0
2002-10-30 12:00:00	SPY	ETF	89.41	89.76	89.28	89.68	3601700.0
2002-10-30 13:00:00	SPY	ETF	89.66	89.76	88.91	89.15	4320000.0
2002-10-30 14:00:00	SPY	ETF	89.13	89.34	88.62	89.27	5480900.0
2002-10-30 15:00:00	SPY	ETF	89.26	89.78	88.9	89.45	5463200.0
2002-10-30 16:00:00	SPY	ETF	89.41	89.68	89.24	89.42	2669300.0
2002-10-30 17:00:00	SPY	ETF	89.3	89.78	89.12	89.27	220100.0
2002-10-30 18:00:00	SPY	ETF	89.27	89.27	89.22	89.23	4400.0
2002-10-30 08:00:00	QQQ	ETF	24.04	24.09	24.04	24.06	7300.0
2002-10-30 09:00:00	QQQ	ETF	24.05	24.14	23.85	23.92	10694300.0
2002-10-30 10:00:00	QQQ	ETF	23.92	24.42	23.9	24.35	13192500.0
2002-10-30 11:00:00	QQQ	ETF	24.35	24.79	24.34	24.51	24154400.0
2002-10-30 12:00:00	QQQ	ETF	24.49	24.7	24.45	24.7	11420600.0
2002-10-30 13:00:00	QQQ	ETF	24.68	24.7	24.41	24.45	9392400.0
2002-10-30 14:00:00	QQQ	ETF	24.45	24.61	24.26	24.58	10389700.0
2002-10-30 15:00:00	QQQ	ETF	24.59	24.75	24.44	24.54	11940600.0
2002-10-30 16:00:00	QQQ	ETF	24.52	24.6	24.47	24.54	2506300.0
2002-10-30 17:00:00	QQQ	ETF	24.54	24.55	24.5	24.54	178800.0
2002-10-30 18:00:00	QQQ	ETF	24.54	24.58	24.52	24.57	35700.0
2002-10-30 19:00:00	QQQ	ETF	24.54	24.54	24.51	24.51	1900.0
2002-10-30 09:00:00	IWM	ETF	37.0	37.0	36.72	36.72	275600.0
2002-10-30 10:00:00	IWM	ETF	36.795	37.21	36.725	37.11	332800.0
2002-10-30 11:00:00	IWM	ETF	37.2	37.365	37.155	37.225	191400.0
2002-10-30 12:00:00	IWM	ETF	37.18	37.275	37.14	37.185	160800.0
2002-10-30 13:00:00	IWM	ETF	37.185	37.215	37.025	37.025	587400.0
2002-10-30 14:00:00	IWM	ETF	37.03	37.085	36.925	37.05	198800.0
2002-10-30 15:00:00	IWM	ETF	37.105	37.345	37.005	37.345	983200.0
2002-10-30 16:00:00	IWM	ETF	37.315	37.495	37.3	37.325	19400.0
2002-10-30 17:00:00	IWM	ETF	37.315	37.315	37.315	37.315	321600.0
2002-10-30 08:00:00	DIA	ETF	83.91	84.0	83.78	83.78	1800.0
2002-10-30 09:00:00	DIA	ETF	83.88	83.99	83.16	83.23	1125600.0
2002-10-30 10:00:00	DIA	ETF	83.2	84.3	83.17	84.1	2342600.0
2002-10-30 11:00:00	DIA	ETF	84.1	84.78	84.04	84.35	1462600.0
2002-10-30 12:00:00	DIA	ETF	84.3	84.62	84.21	84.6	810100.0
2002-10-30 13:00:00	DIA	ETF	84.6	84.64	83.95	84.15	832800.0
2002-10-30 14:00:00	DIA	ETF	84.15	84.3	83.67	84.29	1271700.0
2002-10-30 15:00:00	DIA	ETF	84.25	84.74	83.85	84.42	1297500.0
2002-10-30 16:00:00	DIA	ETF	84.43	84.89	84.27	84.35	163300.0
2002-10-30 17:00:00	DIA	ETF	84.25	84.25	84.2	84.2	1100.0
2002-10-30 18:00:00	DIA	ETF	84.2	84.3	84.2	84.22	1300.0
2002-10-30 19:00:00	DIA	ETF	84.35	84.35	84.35	84.35	1000.0
2002-10-30 09:00:00	TLT	ETF	86.37	86.39	86.14	86.3	3500.0
2002-10-30 10:00:00	TLT	ETF	86.4	86.4	86.1	86.16	4400.0
2002-10-30 11:00:00	TLT	ETF	86.2	86.28	86.07	86.28	3800.0
2002-10-30 12:00:00	TLT	ETF	86.31	86.31	86.29	86.31	1300.0
2002-10-30 13:00:00	TLT	ETF	86.45	86.68	86.39	86.68	4100.0
2002-10-30 14:00:00	TLT	ETF	86.56	86.66	86.34	86.34	2100.0

> showing 50 of 365 rows — these rows as CSV

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