PREVIEW / etf_1hour / 2002-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-12-19.parquet
  size:    16 KB
  rows:    383

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-12-19 08:00:00	SPY	ETF	89.45	89.52	88.99	89.1	43300.0
2002-12-19 09:00:00	SPY	ETF	89.08	90.28	89.08	90.27	4644600.0
2002-12-19 10:00:00	SPY	ETF	90.27	90.7	89.5	89.53	6313400.0
2002-12-19 11:00:00	SPY	ETF	89.54	89.91	89.19	89.85	6368900.0
2002-12-19 12:00:00	SPY	ETF	89.85	90.05	89.19	89.44	4082000.0
2002-12-19 13:00:00	SPY	ETF	89.47	89.49	88.82	89.0	3542900.0
2002-12-19 14:00:00	SPY	ETF	88.99	89.25	88.85	88.93	2757900.0
2002-12-19 15:00:00	SPY	ETF	88.91	89.13	88.6	89.05	5740000.0
2002-12-19 16:00:00	SPY	ETF	89.05	89.25	88.69	89.23	1607700.0
2002-12-19 17:00:00	SPY	ETF	89.18	89.26	89.15	89.25	27600.0
2002-12-19 18:00:00	SPY	ETF	89.35	89.4	89.31	89.35	1300.0
2002-12-19 19:00:00	SPY	ETF	89.32	89.35	89.22	89.22	5500.0
2002-12-19 08:00:00	QQQ	ETF	25.31	25.31	25.03	25.07	65700.0
2002-12-19 09:00:00	QQQ	ETF	25.07	25.77	25.07	25.63	9724000.0
2002-12-19 10:00:00	QQQ	ETF	25.64	25.78	24.96	24.96	19072700.0
2002-12-19 11:00:00	QQQ	ETF	24.96	25.29	24.87	25.2	15653000.0
2002-12-19 12:00:00	QQQ	ETF	25.2	25.31	24.96	25.14	9358900.0
2002-12-19 13:00:00	QQQ	ETF	25.15	25.18	24.9	25.02	9370700.0
2002-12-19 14:00:00	QQQ	ETF	25.02	25.16	24.93	25.0	8126700.0
2002-12-19 15:00:00	QQQ	ETF	25.0	25.11	24.81	25.03	12364700.0
2002-12-19 16:00:00	QQQ	ETF	25.04	25.12	24.97	25.1	1915100.0
2002-12-19 17:00:00	QQQ	ETF	25.1	25.2	25.07	25.18	287100.0
2002-12-19 18:00:00	QQQ	ETF	25.2	25.2	25.15	25.17	26200.0
2002-12-19 19:00:00	QQQ	ETF	25.19	25.23	25.16	25.2	7500.0
2002-12-19 09:00:00	IWM	ETF	38.125	38.59	38.125	38.525	577400.0
2002-12-19 10:00:00	IWM	ETF	38.52	38.65	38.1	38.1	489600.0
2002-12-19 11:00:00	IWM	ETF	38.06	38.275	38.01	38.185	505800.0
2002-12-19 12:00:00	IWM	ETF	38.2	38.265	38.08	38.09	3394600.0
2002-12-19 13:00:00	IWM	ETF	38.12	38.145	37.975	38.04	231000.0
2002-12-19 14:00:00	IWM	ETF	38.0	38.08	37.95	37.985	132400.0
2002-12-19 15:00:00	IWM	ETF	37.98	38.125	37.86	38.125	735400.0
2002-12-19 16:00:00	IWM	ETF	38.15	38.2	38.085	38.085	277800.0
2002-12-19 08:00:00	DIA	ETF	84.55	84.55	84.08	84.15	13700.0
2002-12-19 09:00:00	DIA	ETF	84.25	85.13	84.21	85.0	1017600.0
2002-12-19 10:00:00	DIA	ETF	85.06	85.38	84.36	84.43	1073300.0
2002-12-19 11:00:00	DIA	ETF	84.45	84.82	84.1	84.69	852600.0
2002-12-19 12:00:00	DIA	ETF	84.7	84.82	84.2	84.39	651100.0
2002-12-19 13:00:00	DIA	ETF	84.4	84.5	83.75	83.96	1017500.0
2002-12-19 14:00:00	DIA	ETF	83.95	84.16	83.79	83.9	647100.0
2002-12-19 15:00:00	DIA	ETF	83.9	84.04	83.56	83.92	1247200.0
2002-12-19 16:00:00	DIA	ETF	83.92	84.15	83.87	84.04	67800.0
2002-12-19 17:00:00	DIA	ETF	84.0	84.09	84.0	84.09	700.0
2002-12-19 18:00:00	DIA	ETF	84.17	84.21	84.17	84.21	2200.0
2002-12-19 19:00:00	DIA	ETF	84.1	84.1	84.1	84.1	600.0
2002-12-19 09:00:00	TLT	ETF	86.66	86.66	86.65	86.66	4800.0
2002-12-19 10:00:00	TLT	ETF	86.71	86.9	86.67	86.9	20700.0
2002-12-19 11:00:00	TLT	ETF	86.95	86.99	86.84	86.91	2500.0
2002-12-19 12:00:00	TLT	ETF	86.88	87.14	86.88	87.14	30200.0
2002-12-19 13:00:00	TLT	ETF	87.15	87.44	87.15	87.4	45400.0
2002-12-19 14:00:00	TLT	ETF	87.3	87.47	87.23	87.4	6300.0

> showing 50 of 383 rows — these rows as CSV

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