PREVIEW / etf_1hour / 2004-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-29.parquet
  size:    26 KB
  rows:    693

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-04-29 08:00:00	SPY	ETF	112.38	112.59	112.08	112.52	1001400.0
2004-04-29 09:00:00	SPY	ETF	112.51	112.89	112.28	112.54	8462600.0
2004-04-29 10:00:00	SPY	ETF	112.53	113.32	112.44	113.15	7378700.0
2004-04-29 11:00:00	SPY	ETF	113.14	113.3	112.43	112.54	5274400.0
2004-04-29 12:00:00	SPY	ETF	112.54	112.63	112.04	112.25	7914600.0
2004-04-29 13:00:00	SPY	ETF	112.28	112.63	112.12	112.36	4570800.0
2004-04-29 14:00:00	SPY	ETF	112.36	112.54	111.5	111.68	10417600.0
2004-04-29 15:00:00	SPY	ETF	111.67	111.99	111.16	111.85	10540700.0
2004-04-29 16:00:00	SPY	ETF	111.84	111.99	111.53	111.92	1941100.0
2004-04-29 17:00:00	SPY	ETF	111.91	111.96	111.83	111.83	14100.0
2004-04-29 18:00:00	SPY	ETF	111.86	111.86	111.72	111.72	11600.0
2004-04-29 19:00:00	SPY	ETF	111.7	111.7	111.7	111.7	4900.0
2004-04-29 08:00:00	QQQ	ETF	36.19	36.19	35.87	35.98	750800.0
2004-04-29 09:00:00	QQQ	ETF	35.97	36.21	35.846	35.96	18613000.0
2004-04-29 10:00:00	QQQ	ETF	35.95	36.34	35.9	36.16	23306900.0
2004-04-29 11:00:00	QQQ	ETF	36.159	36.23	35.893	35.919	11678300.0
2004-04-29 12:00:00	QQQ	ETF	35.917	35.95	35.68	35.78	14736200.0
2004-04-29 13:00:00	QQQ	ETF	35.78	35.91	35.71	35.82	10677700.0
2004-04-29 14:00:00	QQQ	ETF	35.82	35.88	35.37	35.46	24456700.0
2004-04-29 15:00:00	QQQ	ETF	35.457	35.7	35.3	35.62	24896400.0
2004-04-29 16:00:00	QQQ	ETF	35.64	35.7925	35.56	35.63	4380900.0
2004-04-29 17:00:00	QQQ	ETF	35.62	35.64	35.56	35.56	117700.0
2004-04-29 18:00:00	QQQ	ETF	35.58	35.59	35.54	35.55	44900.0
2004-04-29 19:00:00	QQQ	ETF	35.55	35.56	35.51	35.55	58700.0
2004-04-29 08:00:00	IWM	ETF	57.3	57.3	57.18	57.26	4400.0
2004-04-29 09:00:00	IWM	ETF	57.395	57.795	57.115	57.325	3060800.0
2004-04-29 10:00:00	IWM	ETF	57.32	57.935	57.28	57.595	1340600.0
2004-04-29 11:00:00	IWM	ETF	57.6	57.745	57.295	57.31	860200.0
2004-04-29 12:00:00	IWM	ETF	57.295	57.295	56.825	56.97	1620000.0
2004-04-29 13:00:00	IWM	ETF	56.995	57.125	56.905	56.99	856800.0
2004-04-29 14:00:00	IWM	ETF	56.98	57.045	56.2	56.405	2609800.0
2004-04-29 15:00:00	IWM	ETF	56.45	56.71	56.125	56.55	3610800.0
2004-04-29 16:00:00	IWM	ETF	56.54	56.585	56.475	56.585	174000.0
2004-04-29 17:00:00	IWM	ETF	56.62	56.62	56.62	56.62	2000.0
2004-04-29 18:00:00	IWM	ETF	56.47	56.47	56.44	56.44	1600.0
2004-04-29 08:00:00	DIA	ETF	103.49	103.55	103.14	103.51	22200.0
2004-04-29 09:00:00	DIA	ETF	103.54	103.93	103.41	103.63	975000.0
2004-04-29 10:00:00	DIA	ETF	103.61	104.27	103.53	104.16	1427700.0
2004-04-29 11:00:00	DIA	ETF	104.17	104.27	103.58	103.64	1590500.0
2004-04-29 12:00:00	DIA	ETF	103.65	103.72	103.24	103.5	900400.0
2004-04-29 13:00:00	DIA	ETF	103.53	103.78	103.33	103.58	363500.0
2004-04-29 14:00:00	DIA	ETF	103.56	103.73	102.75	102.92	1853000.0
2004-04-29 15:00:00	DIA	ETF	102.92	103.11	102.35	103.04	2270400.0
2004-04-29 16:00:00	DIA	ETF	103.03	103.14	102.7	103.05	473400.0
2004-04-29 17:00:00	DIA	ETF	103.05	103.05	103.05	103.05	800.0
2004-04-29 08:00:00	TLT	ETF	83.75	83.9	83.49	83.49	19400.0
2004-04-29 09:00:00	TLT	ETF	83.73	83.95	83.68	83.94	537200.0
2004-04-29 10:00:00	TLT	ETF	83.95	84.18	83.94	83.94	106400.0
2004-04-29 11:00:00	TLT	ETF	83.92	83.98	83.58	83.6	102000.0
2004-04-29 12:00:00	TLT	ETF	83.55	83.62	83.01	83.26	401900.0

> showing 50 of 693 rows — these rows as CSV

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