PREVIEW / etf_1hour / 2002-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-14.parquet
  size:    16 KB
  rows:    371

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-14 08:00:00	SPY	ETF	89.4	90.2	89.16	90.2	14900.0
2002-11-14 09:00:00	SPY	ETF	90.23	90.3	89.77	89.92	4464700.0
2002-11-14 10:00:00	SPY	ETF	89.93	90.5	89.89	90.17	4917600.0
2002-11-14 11:00:00	SPY	ETF	90.2	90.38	89.81	90.21	3845500.0
2002-11-14 12:00:00	SPY	ETF	90.22	90.73	89.95	90.55	2636000.0
2002-11-14 13:00:00	SPY	ETF	90.56	90.85	90.41	90.48	3339300.0
2002-11-14 14:00:00	SPY	ETF	90.47	91.0	90.35	90.89	3537400.0
2002-11-14 15:00:00	SPY	ETF	90.93	90.94	90.41	90.87	4777400.0
2002-11-14 16:00:00	SPY	ETF	90.9	91.03	90.59	90.62	2736700.0
2002-11-14 17:00:00	SPY	ETF	90.67	90.85	90.66	90.66	77700.0
2002-11-14 18:00:00	SPY	ETF	90.73	90.98	90.7	90.98	51000.0
2002-11-14 08:00:00	QQQ	ETF	25.25	25.68	25.17	25.68	57100.0
2002-11-14 09:00:00	QQQ	ETF	25.67	25.77	25.52	25.57	13348800.0
2002-11-14 10:00:00	QQQ	ETF	25.59	25.85	25.57	25.74	13276300.0
2002-11-14 11:00:00	QQQ	ETF	25.74	25.92	25.62	25.85	8867000.0
2002-11-14 12:00:00	QQQ	ETF	25.85	26.05	25.77	25.98	8164700.0
2002-11-14 13:00:00	QQQ	ETF	25.98	26.14	25.92	25.95	9626900.0
2002-11-14 14:00:00	QQQ	ETF	25.95	26.2	25.89	26.19	7714900.0
2002-11-14 15:00:00	QQQ	ETF	26.19	26.32	26.0	26.29	12613800.0
2002-11-14 16:00:00	QQQ	ETF	26.28	26.46	25.95	26.0	8665800.0
2002-11-14 17:00:00	QQQ	ETF	25.99	26.13	25.99	26.13	1273500.0
2002-11-14 18:00:00	QQQ	ETF	26.13	26.2	26.11	26.18	467400.0
2002-11-14 19:00:00	QQQ	ETF	26.17	26.2	26.15	26.2	7300.0
2002-11-14 09:00:00	IWM	ETF	37.9	38.025	37.855	37.92	198800.0
2002-11-14 10:00:00	IWM	ETF	37.925	38.15	37.925	38.06	336800.0
2002-11-14 11:00:00	IWM	ETF	38.05	38.245	38.0	38.225	285000.0
2002-11-14 12:00:00	IWM	ETF	38.2	38.355	38.15	38.32	124400.0
2002-11-14 13:00:00	IWM	ETF	38.32	38.375	38.17	38.175	131000.0
2002-11-14 14:00:00	IWM	ETF	38.175	38.26	38.15	38.19	251800.0
2002-11-14 15:00:00	IWM	ETF	38.225	38.55	38.07	38.55	616600.0
2002-11-14 16:00:00	IWM	ETF	38.51	38.51	38.31	38.415	102800.0
2002-11-14 18:00:00	IWM	ETF	38.435	38.435	38.435	38.435	400.0
2002-11-14 08:00:00	DIA	ETF	85.11	85.29	85.0	85.29	5300.0
2002-11-14 09:00:00	DIA	ETF	85.21	85.46	84.82	84.9	1744700.0
2002-11-14 10:00:00	DIA	ETF	85.0	85.5	84.98	85.09	1552100.0
2002-11-14 11:00:00	DIA	ETF	85.04	85.38	84.74	85.23	805600.0
2002-11-14 12:00:00	DIA	ETF	85.24	85.65	84.95	85.51	1066600.0
2002-11-14 13:00:00	DIA	ETF	85.5	85.74	85.3	85.38	654300.0
2002-11-14 14:00:00	DIA	ETF	85.36	85.75	85.23	85.74	735000.0
2002-11-14 15:00:00	DIA	ETF	85.74	85.78	85.3	85.71	1031500.0
2002-11-14 16:00:00	DIA	ETF	85.7	86.0	85.4	85.5	496800.0
2002-11-14 17:00:00	DIA	ETF	85.48	85.65	85.48	85.65	1700.0
2002-11-14 18:00:00	DIA	ETF	85.63	85.63	85.55	85.55	900.0
2002-11-14 09:00:00	TLT	ETF	87.65	87.65	87.44	87.6	61700.0
2002-11-14 10:00:00	TLT	ETF	87.55	87.55	87.3	87.3	14300.0
2002-11-14 11:00:00	TLT	ETF	87.35	87.39	87.25	87.3	5000.0
2002-11-14 12:00:00	TLT	ETF	87.31	87.31	87.15	87.19	7200.0
2002-11-14 13:00:00	TLT	ETF	87.24	87.25	87.05	87.11	1900.0
2002-11-14 14:00:00	TLT	ETF	87.14	87.14	87.03	87.14	2400.0
2002-11-14 15:00:00	TLT	ETF	87.02	87.09	86.76	86.76	18000.0

> showing 50 of 371 rows — these rows as CSV

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