PREVIEW / etf_1hour / 2004-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-02.parquet
  size:    27 KB
  rows:    761

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-11-02 08:00:00	SPY	ETF	113.78	113.8	113.72	113.72	80800.0
2004-11-02 09:00:00	SPY	ETF	113.76	113.91	113.57	113.88	4028400.0
2004-11-02 10:00:00	SPY	ETF	113.9	114.42	113.83	114.26	9946400.0
2004-11-02 11:00:00	SPY	ETF	114.26	114.48	114.25	114.43	4670400.0
2004-11-02 12:00:00	SPY	ETF	114.41	114.55	114.33	114.43	2920800.0
2004-11-02 13:00:00	SPY	ETF	114.41	114.57	114.29	114.37	2971200.0
2004-11-02 14:00:00	SPY	ETF	114.37	114.54	113.57	113.97	9397400.0
2004-11-02 15:00:00	SPY	ETF	113.97	113.98	113.22	113.5	16526500.0
2004-11-02 16:00:00	SPY	ETF	113.5	113.61	113.36	113.46	3845400.0
2004-11-02 17:00:00	SPY	ETF	113.45	113.49	113.4	113.44	70900.0
2004-11-02 18:00:00	SPY	ETF	113.4	113.52	113.31	113.41	22500.0
2004-11-02 19:00:00	SPY	ETF	113.41	113.52	113.4	113.4	4900.0
2004-11-02 08:00:00	QQQ	ETF	37.12	37.12	37.07	37.11	136800.0
2004-11-02 09:00:00	QQQ	ETF	37.11	37.19	37.02	37.16	9133400.0
2004-11-02 10:00:00	QQQ	ETF	37.17	37.45	37.16	37.387	22829500.0
2004-11-02 11:00:00	QQQ	ETF	37.386	37.51	37.38	37.45	12798100.0
2004-11-02 12:00:00	QQQ	ETF	37.45	37.5	37.42	37.45	6715300.0
2004-11-02 13:00:00	QQQ	ETF	37.45	37.55	37.44	37.46	7473900.0
2004-11-02 14:00:00	QQQ	ETF	37.46	37.55	37.16	37.32	15565700.0
2004-11-02 15:00:00	QQQ	ETF	37.327	37.34	37.02	37.155	29013800.0
2004-11-02 16:00:00	QQQ	ETF	37.155	37.24	37.13	37.17	2768400.0
2004-11-02 17:00:00	QQQ	ETF	37.17	37.22	37.14	37.2	1012200.0
2004-11-02 18:00:00	QQQ	ETF	37.2	37.22	37.16	37.2	140400.0
2004-11-02 19:00:00	QQQ	ETF	37.2	37.2	37.17	37.2	48400.0
2004-11-02 08:00:00	IWM	ETF	58.7	58.7	58.65	58.65	14400.0
2004-11-02 09:00:00	IWM	ETF	58.65	58.765	58.55	58.735	1219000.0
2004-11-02 10:00:00	IWM	ETF	58.735	58.925	58.69	58.81	2245000.0
2004-11-02 11:00:00	IWM	ETF	58.815	59.015	58.815	59.01	951000.0
2004-11-02 12:00:00	IWM	ETF	59.01	59.03	58.9	58.95	923600.0
2004-11-02 13:00:00	IWM	ETF	58.95	58.985	58.865	58.875	638400.0
2004-11-02 14:00:00	IWM	ETF	58.875	58.975	58.57	58.75	905600.0
2004-11-02 15:00:00	IWM	ETF	58.73	58.73	58.07	58.255	4550600.0
2004-11-02 16:00:00	IWM	ETF	58.245	58.325	58.19	58.195	1092000.0
2004-11-02 17:00:00	IWM	ETF	58.235	58.235	58.2	58.2	6600.0
2004-11-02 08:00:00	DIA	ETF	100.95	100.95	100.84	100.86	8700.0
2004-11-02 09:00:00	DIA	ETF	100.88	101.08	100.75	101.06	913800.0
2004-11-02 10:00:00	DIA	ETF	101.03	101.53	101.0	101.36	1478400.0
2004-11-02 11:00:00	DIA	ETF	101.34	101.48	101.24	101.3	828300.0
2004-11-02 12:00:00	DIA	ETF	101.3	101.48	101.24	101.4	242300.0
2004-11-02 13:00:00	DIA	ETF	101.39	101.47	101.27	101.33	437400.0
2004-11-02 14:00:00	DIA	ETF	101.32	101.46	100.62	101.04	817900.0
2004-11-02 15:00:00	DIA	ETF	101.02	101.02	100.29	100.53	2436800.0
2004-11-02 16:00:00	DIA	ETF	100.53	100.82	100.41	100.55	155300.0
2004-11-02 17:00:00	DIA	ETF	100.5	100.53	100.42	100.43	2800.0
2004-11-02 18:00:00	DIA	ETF	100.45	100.45	100.42	100.42	3400.0
2004-11-02 19:00:00	DIA	ETF	100.48	100.58	100.48	100.48	4600.0
2004-11-02 08:00:00	TLT	ETF	88.48	88.48	88.48	88.48	10000.0
2004-11-02 09:00:00	TLT	ETF	88.48	88.55	88.48	88.5	172600.0
2004-11-02 10:00:00	TLT	ETF	88.48	88.52	88.32	88.45	224300.0
2004-11-02 11:00:00	TLT	ETF	88.44	88.44	88.31	88.39	25500.0

> showing 50 of 761 rows — these rows as CSV

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