PREVIEW / etf_1hour / 2002-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-03.parquet
  size:    15 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-03 08:00:00	SPY	ETF	82.89	83.61	82.85	83.36	18000.0
2002-10-03 09:00:00	SPY	ETF	83.35	83.37	82.58	82.78	4775300.0
2002-10-03 10:00:00	SPY	ETF	82.83	84.35	82.73	83.02	15817100.0
2002-10-03 11:00:00	SPY	ETF	83.01	83.18	82.32	82.85	7619300.0
2002-10-03 12:00:00	SPY	ETF	82.92	82.97	81.95	82.42	4559600.0
2002-10-03 13:00:00	SPY	ETF	82.44	82.9	81.95	82.36	5222100.0
2002-10-03 14:00:00	SPY	ETF	82.38	83.16	82.1	82.73	5658100.0
2002-10-03 15:00:00	SPY	ETF	82.72	83.3	82.02	82.05	8645800.0
2002-10-03 16:00:00	SPY	ETF	82.05	82.37	82.04	82.2	2095400.0
2002-10-03 17:00:00	SPY	ETF	82.2	82.29	82.18	82.22	10100.0
2002-10-03 18:00:00	SPY	ETF	82.22	82.31	82.21	82.21	20000.0
2002-10-03 19:00:00	SPY	ETF	82.29	82.29	82.28	82.28	200.0
2002-10-03 08:00:00	QQQ	ETF	21.02	21.17	21.02	21.1	30200.0
2002-10-03 09:00:00	QQQ	ETF	21.1	21.21	20.87	20.96	6585300.0
2002-10-03 10:00:00	QQQ	ETF	20.98	21.4	20.94	21.01	15447500.0
2002-10-03 11:00:00	QQQ	ETF	21.01	21.12	20.87	21.04	7437900.0
2002-10-03 12:00:00	QQQ	ETF	21.01	21.05	20.76	20.9	8383200.0
2002-10-03 13:00:00	QQQ	ETF	20.93	21.05	20.76	20.85	7444500.0
2002-10-03 14:00:00	QQQ	ETF	20.84	21.12	20.79	21.0	10085900.0
2002-10-03 15:00:00	QQQ	ETF	21.0	21.22	20.68	20.7	12926400.0
2002-10-03 16:00:00	QQQ	ETF	20.68	20.77	20.58	20.63	4230200.0
2002-10-03 17:00:00	QQQ	ETF	20.62	20.69	20.58	20.69	369600.0
2002-10-03 18:00:00	QQQ	ETF	20.68	20.75	20.67	20.71	55000.0
2002-10-03 19:00:00	QQQ	ETF	20.7	20.7	20.7	20.7	400.0
2002-10-03 09:00:00	IWM	ETF	36.07	36.075	35.725	35.825	92400.0
2002-10-03 10:00:00	IWM	ETF	35.88	36.335	35.86	35.93	478000.0
2002-10-03 11:00:00	IWM	ETF	35.98	35.98	35.83	35.95	354600.0
2002-10-03 12:00:00	IWM	ETF	35.95	35.95	35.66	35.73	91400.0
2002-10-03 13:00:00	IWM	ETF	35.74	35.79	35.565	35.66	208400.0
2002-10-03 14:00:00	IWM	ETF	35.625	35.825	35.585	35.69	443800.0
2002-10-03 15:00:00	IWM	ETF	35.7	35.79	35.455	35.455	297600.0
2002-10-03 16:00:00	IWM	ETF	35.48	35.635	35.48	35.615	9200.0
2002-10-03 08:00:00	DIA	ETF	78.0	78.07	78.0	78.07	1900.0
2002-10-03 09:00:00	DIA	ETF	78.0	78.36	77.46	77.74	1117100.0
2002-10-03 10:00:00	DIA	ETF	77.73	79.4	77.67	78.14	3667700.0
2002-10-03 11:00:00	DIA	ETF	78.11	78.3	77.4	77.94	1806800.0
2002-10-03 12:00:00	DIA	ETF	77.99	78.04	77.0	77.44	1258200.0
2002-10-03 13:00:00	DIA	ETF	77.5	78.09	77.0	77.45	1135900.0
2002-10-03 14:00:00	DIA	ETF	77.45	78.16	77.25	77.8	1628000.0
2002-10-03 15:00:00	DIA	ETF	77.86	78.3	77.1	77.14	2020100.0
2002-10-03 16:00:00	DIA	ETF	77.18	77.49	77.14	77.25	354200.0
2002-10-03 18:00:00	DIA	ETF	77.24	77.24	77.24	77.24	200.0
2002-10-03 19:00:00	DIA	ETF	77.69	77.69	77.69	77.69	100.0
2002-10-03 09:00:00	TLT	ETF	89.3	89.51	89.26	89.51	2700.0
2002-10-03 10:00:00	TLT	ETF	89.0	89.14	88.8	89.11	3400.0
2002-10-03 11:00:00	TLT	ETF	89.19	89.3	89.19	89.25	9300.0
2002-10-03 12:00:00	TLT	ETF	89.2	89.49	89.2	89.49	6100.0
2002-10-03 13:00:00	TLT	ETF	89.25	89.41	89.25	89.39	3600.0
2002-10-03 14:00:00	TLT	ETF	89.23	89.23	89.17	89.17	200.0
2002-10-03 15:00:00	TLT	ETF	89.05	89.25	89.05	89.23	4600.0

> showing 50 of 365 rows — these rows as CSV

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