PREVIEW / etf_1hour / 2003-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-16.parquet
  size:    16 KB
  rows:    385

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
2003-01-16 08:00:00	SPY	ETF	92.34	92.81	92.34	92.52	83300.0
2003-01-16 09:00:00	SPY	ETF	92.55	92.92	92.2	92.8	4672900.0
2003-01-16 10:00:00	SPY	ETF	92.81	92.93	92.05	92.14	5918600.0
2003-01-16 11:00:00	SPY	ETF	92.17	92.6	91.9	92.59	6507200.0
2003-01-16 12:00:00	SPY	ETF	92.59	92.7	92.07	92.15	5475000.0
2003-01-16 13:00:00	SPY	ETF	92.16	92.17	91.62	91.92	6487700.0
2003-01-16 14:00:00	SPY	ETF	91.92	91.97	91.61	91.67	4135300.0
2003-01-16 15:00:00	SPY	ETF	91.65	91.84	91.45	91.82	4233200.0
2003-01-16 16:00:00	SPY	ETF	91.8	92.63	91.71	91.75	4406400.0
2003-01-16 17:00:00	SPY	ETF	91.75	91.81	91.57	91.74	945100.0
2003-01-16 18:00:00	SPY	ETF	91.64	91.66	91.5	91.5	49700.0
2003-01-16 19:00:00	SPY	ETF	91.45	91.5	91.33	91.5	3900.0
2003-01-16 08:00:00	QQQ	ETF	26.67	26.93	26.4	26.81	82000.0
2003-01-16 09:00:00	QQQ	ETF	26.8	26.98	26.59	26.91	9735500.0
2003-01-16 10:00:00	QQQ	ETF	26.9	26.94	26.53	26.58	9433900.0
2003-01-16 11:00:00	QQQ	ETF	26.58	26.74	26.45	26.7	7297200.0
2003-01-16 12:00:00	QQQ	ETF	26.69	26.75	26.52	26.55	5683600.0
2003-01-16 13:00:00	QQQ	ETF	26.55	26.56	26.33	26.45	8412300.0
2003-01-16 14:00:00	QQQ	ETF	26.46	26.54	26.37	26.4	5320200.0
2003-01-16 15:00:00	QQQ	ETF	26.39	26.45	26.28	26.4	11079200.0
2003-01-16 16:00:00	QQQ	ETF	26.38	26.76	26.15	26.18	6117000.0
2003-01-16 17:00:00	QQQ	ETF	26.18	26.25	25.17	26.17	1313200.0
2003-01-16 18:00:00	QQQ	ETF	26.17	26.21	26.1	26.12	772300.0
2003-01-16 19:00:00	QQQ	ETF	26.12	26.16	26.07	26.12	50600.0
2003-01-16 09:00:00	IWM	ETF	39.5	39.735	39.23	39.69	448200.0
2003-01-16 10:00:00	IWM	ETF	39.705	39.75	39.29	39.33	272600.0
2003-01-16 11:00:00	IWM	ETF	39.315	39.475	39.27	39.475	145800.0
2003-01-16 12:00:00	IWM	ETF	39.475	39.475	39.285	39.35	57400.0
2003-01-16 13:00:00	IWM	ETF	39.315	39.33	39.19	39.295	191400.0
2003-01-16 14:00:00	IWM	ETF	39.285	39.405	39.23	39.34	274000.0
2003-01-16 15:00:00	IWM	ETF	39.33	39.4	39.21	39.39	845000.0
2003-01-16 16:00:00	IWM	ETF	39.35	39.395	39.335	39.37	27600.0
2003-01-16 08:00:00	DIA	ETF	87.6	88.15	87.6	87.8	15300.0
2003-01-16 09:00:00	DIA	ETF	87.88	88.2	87.57	88.09	702700.0
2003-01-16 10:00:00	DIA	ETF	88.09	88.23	87.4	87.59	922000.0
2003-01-16 11:00:00	DIA	ETF	87.62	87.91	87.37	87.91	1046600.0
2003-01-16 12:00:00	DIA	ETF	87.9	88.08	87.43	87.5	597500.0
2003-01-16 13:00:00	DIA	ETF	87.48	87.5	87.02	87.33	866400.0
2003-01-16 14:00:00	DIA	ETF	87.32	87.37	87.01	87.11	767000.0
2003-01-16 15:00:00	DIA	ETF	87.11	87.2	86.87	87.18	952800.0
2003-01-16 16:00:00	DIA	ETF	87.18	87.74	86.75	87.05	151000.0
2003-01-16 17:00:00	DIA	ETF	87.05	87.18	86.7	86.91	70600.0
2003-01-16 18:00:00	DIA	ETF	87.0	87.0	86.75	86.75	11700.0
2003-01-16 19:00:00	DIA	ETF	86.7	86.7	86.6	86.6	1100.0
2003-01-16 09:00:00	TLT	ETF	86.38	86.38	86.29	86.32	12800.0
2003-01-16 10:00:00	TLT	ETF	86.06	86.25	85.97	86.2	3700.0
2003-01-16 11:00:00	TLT	ETF	86.23	86.23	85.62	85.62	11700.0
2003-01-16 12:00:00	TLT	ETF	85.62	86.07	85.62	86.01	4800.0
2003-01-16 13:00:00	TLT	ETF	86.31	86.31	86.1	86.1	600.0
2003-01-16 14:00:00	TLT	ETF	86.18	86.54	86.18	86.54	5800.0

> showing 50 of 385 rows — these rows as CSV

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