PREVIEW / etf_1hour / 2003-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-06.parquet
  size:    17 KB
  rows:    408

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-06 08:00:00	SPY	ETF	91.0	91.4	91.0	91.3	58500.0
2003-01-06 09:00:00	SPY	ETF	91.27	91.87	91.17	91.79	4493000.0
2003-01-06 10:00:00	SPY	ETF	91.8	92.58	91.5	92.43	8870300.0
2003-01-06 11:00:00	SPY	ETF	92.43	92.68	92.34	92.59	3226500.0
2003-01-06 12:00:00	SPY	ETF	92.6	92.87	92.59	92.83	2588800.0
2003-01-06 13:00:00	SPY	ETF	92.86	93.13	92.75	92.91	4856100.0
2003-01-06 14:00:00	SPY	ETF	92.9	93.45	92.87	93.38	4088300.0
2003-01-06 15:00:00	SPY	ETF	93.39	93.49	93.02	93.12	5858200.0
2003-01-06 16:00:00	SPY	ETF	93.09	93.26	92.82	93.06	2692900.0
2003-01-06 17:00:00	SPY	ETF	92.98	93.03	92.95	92.96	11900.0
2003-01-06 18:00:00	SPY	ETF	92.96	93.01	92.95	93.0	12000.0
2003-01-06 19:00:00	SPY	ETF	93.0	93.0	92.96	92.96	2800.0
2003-01-06 08:00:00	QQQ	ETF	25.65	25.83	25.65	25.8	64700.0
2003-01-06 09:00:00	QQQ	ETF	25.78	25.99	25.7	25.96	8381600.0
2003-01-06 10:00:00	QQQ	ETF	25.96	26.22	25.85	26.19	12535600.0
2003-01-06 11:00:00	QQQ	ETF	26.19	26.26	26.11	26.24	6974000.0
2003-01-06 12:00:00	QQQ	ETF	26.25	26.32	26.21	26.3	4669800.0
2003-01-06 13:00:00	QQQ	ETF	26.29	26.43	26.25	26.36	4762200.0
2003-01-06 14:00:00	QQQ	ETF	26.35	26.58	26.33	26.56	7843200.0
2003-01-06 15:00:00	QQQ	ETF	26.56	26.59	26.35	26.4	10392800.0
2003-01-06 16:00:00	QQQ	ETF	26.36	26.5	26.24	26.41	6544300.0
2003-01-06 17:00:00	QQQ	ETF	26.38	26.41	26.34	26.38	678200.0
2003-01-06 18:00:00	QQQ	ETF	26.39	26.45	26.38	26.44	32800.0
2003-01-06 19:00:00	QQQ	ETF	26.44	26.44	26.34	26.38	52900.0
2003-01-06 20:00:00	QQQ	ETF	26.38	26.38	26.38	26.38	300.0
2003-01-06 09:00:00	IWM	ETF	38.885	39.225	38.885	39.1	180400.0
2003-01-06 10:00:00	IWM	ETF	39.1	39.475	39.005	39.345	653200.0
2003-01-06 11:00:00	IWM	ETF	39.425	39.425	39.285	39.385	354400.0
2003-01-06 12:00:00	IWM	ETF	39.4	39.44	39.33	39.42	117400.0
2003-01-06 13:00:00	IWM	ETF	39.42	39.49	39.385	39.425	188400.0
2003-01-06 14:00:00	IWM	ETF	39.4	39.59	39.4	39.59	243400.0
2003-01-06 15:00:00	IWM	ETF	39.605	39.61	39.36	39.37	540800.0
2003-01-06 16:00:00	IWM	ETF	39.36	39.4	39.05	39.325	102000.0
2003-01-06 17:00:00	IWM	ETF	39.5	39.5	39.275	39.275	256200.0
2003-01-06 08:00:00	DIA	ETF	86.38	86.38	86.38	86.38	900.0
2003-01-06 09:00:00	DIA	ETF	86.28	86.67	86.25	86.65	1191900.0
2003-01-06 10:00:00	DIA	ETF	86.59	87.33	86.36	87.1	1512500.0
2003-01-06 11:00:00	DIA	ETF	87.16	87.44	87.09	87.34	432900.0
2003-01-06 12:00:00	DIA	ETF	87.35	87.6	87.31	87.6	401100.0
2003-01-06 13:00:00	DIA	ETF	87.6	87.81	87.47	87.6	484100.0
2003-01-06 14:00:00	DIA	ETF	87.62	88.17	87.56	88.1	706600.0
2003-01-06 15:00:00	DIA	ETF	88.1	88.17	87.73	87.77	876000.0
2003-01-06 16:00:00	DIA	ETF	87.85	87.86	87.59	87.73	150700.0
2003-01-06 17:00:00	DIA	ETF	87.78	87.78	87.78	87.78	300.0
2003-01-06 18:00:00	DIA	ETF	87.78	87.85	87.78	87.85	2400.0
2003-01-06 19:00:00	DIA	ETF	87.8	87.85	87.79	87.79	2300.0
2003-01-06 09:00:00	TLT	ETF	86.05	86.1	86.05	86.09	3700.0
2003-01-06 10:00:00	TLT	ETF	86.09	86.13	86.0	86.13	4100.0
2003-01-06 11:00:00	TLT	ETF	86.12	86.12	85.91	85.91	3100.0
2003-01-06 12:00:00	TLT	ETF	85.86	85.96	85.81	85.96	12700.0

> showing 50 of 408 rows — these rows as CSV

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