PREVIEW / etf_1hour / 2004-03-17

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-17.parquet
  size:    26 KB
  rows:    707

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
2004-03-17 08:00:00	SPY	ETF	112.1	112.29	112.1	112.24	72900.0
2004-03-17 09:00:00	SPY	ETF	112.24	112.66	112.1	112.47	7148100.0
2004-03-17 10:00:00	SPY	ETF	112.47	112.75	112.4	112.5	5940300.0
2004-03-17 11:00:00	SPY	ETF	112.49	113.01	112.47	112.93	5119200.0
2004-03-17 12:00:00	SPY	ETF	112.93	113.02	112.81	112.87	3458600.0
2004-03-17 13:00:00	SPY	ETF	112.88	113.03	112.72	112.87	2936200.0
2004-03-17 14:00:00	SPY	ETF	112.87	113.13	112.85	113.06	4267700.0
2004-03-17 15:00:00	SPY	ETF	113.07	113.25	112.99	113.0	5699700.0
2004-03-17 16:00:00	SPY	ETF	112.98	113.08	112.96	113.05	3595400.0
2004-03-17 17:00:00	SPY	ETF	113.03	113.08	112.99	113.06	282300.0
2004-03-17 18:00:00	SPY	ETF	113.08	113.13	113.04	113.13	19100.0
2004-03-17 19:00:00	SPY	ETF	113.13	113.13	112.99	112.99	8700.0
2004-03-17 08:00:00	QQQ	ETF	35.1	35.22	35.1	35.2	365100.0
2004-03-17 09:00:00	QQQ	ETF	35.2	35.41	35.17	35.33	20417100.0
2004-03-17 10:00:00	QQQ	ETF	35.33	35.47	35.29	35.37	13867200.0
2004-03-17 11:00:00	QQQ	ETF	35.368	35.55	35.36	35.46	12095400.0
2004-03-17 12:00:00	QQQ	ETF	35.454	35.5	35.39	35.4	5976100.0
2004-03-17 13:00:00	QQQ	ETF	35.4	35.502	35.36	35.43	7934100.0
2004-03-17 14:00:00	QQQ	ETF	35.43	35.53	35.42	35.51	8934200.0
2004-03-17 15:00:00	QQQ	ETF	35.514	35.62	35.46	35.5	14999200.0
2004-03-17 16:00:00	QQQ	ETF	35.51	35.54	35.49	35.49	4098800.0
2004-03-17 17:00:00	QQQ	ETF	35.505	35.52	35.48	35.51	360000.0
2004-03-17 18:00:00	QQQ	ETF	35.51	35.53	35.51	35.51	7100.0
2004-03-17 19:00:00	QQQ	ETF	35.52	35.52	35.51	35.51	1100.0
2004-03-17 09:00:00	IWM	ETF	56.99	57.36	56.9	57.2	4203000.0
2004-03-17 10:00:00	IWM	ETF	57.22	57.44	57.2	57.26	1175800.0
2004-03-17 11:00:00	IWM	ETF	57.25	57.615	57.245	57.4	2613400.0
2004-03-17 12:00:00	IWM	ETF	57.41	57.475	57.315	57.395	1090800.0
2004-03-17 13:00:00	IWM	ETF	57.41	57.565	57.335	57.465	610400.0
2004-03-17 14:00:00	IWM	ETF	57.49	57.715	57.35	57.6	1717000.0
2004-03-17 15:00:00	IWM	ETF	57.605	57.8	57.485	57.55	4481200.0
2004-03-17 16:00:00	IWM	ETF	57.525	57.8	57.22	57.63	741400.0
2004-03-17 08:00:00	DIA	ETF	102.56	102.56	102.43	102.53	16100.0
2004-03-17 09:00:00	DIA	ETF	102.48	102.81	102.41	102.72	1340500.0
2004-03-17 10:00:00	DIA	ETF	102.74	102.98	102.7	102.82	858200.0
2004-03-17 11:00:00	DIA	ETF	102.84	103.22	102.84	103.11	797200.0
2004-03-17 12:00:00	DIA	ETF	103.12	103.2	103.03	103.11	438800.0
2004-03-17 13:00:00	DIA	ETF	103.11	103.24	103.0	103.11	381500.0
2004-03-17 14:00:00	DIA	ETF	103.11	103.35	103.09	103.29	658300.0
2004-03-17 15:00:00	DIA	ETF	103.27	103.55	103.19	103.28	1163100.0
2004-03-17 16:00:00	DIA	ETF	103.32	103.32	103.15	103.31	728200.0
2004-03-17 17:00:00	DIA	ETF	103.31	103.31	103.31	103.31	100.0
2004-03-17 18:00:00	DIA	ETF	103.31	103.31	103.31	103.31	100.0
2004-03-17 19:00:00	DIA	ETF	103.21	103.21	103.21	103.21	200.0
2004-03-17 08:00:00	TLT	ETF	91.3	91.36	91.3	91.3	11000.0
2004-03-17 09:00:00	TLT	ETF	91.35	91.47	91.35	91.42	48900.0
2004-03-17 10:00:00	TLT	ETF	91.47	91.48	91.26	91.4	186300.0
2004-03-17 11:00:00	TLT	ETF	91.36	91.4	91.08	91.14	1198900.0
2004-03-17 12:00:00	TLT	ETF	91.08	91.11	90.9	90.96	150700.0
2004-03-17 13:00:00	TLT	ETF	90.96	91.08	90.95	91.08	66700.0

> showing 50 of 707 rows — these rows as CSV

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