PREVIEW / etf_1hour / 2004-09-03

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-03.parquet
  size:    24 KB
  rows:    678

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-09-03 08:00:00	SPY	ETF	112.18	112.52	112.13	112.48	743500.0
2004-09-03 09:00:00	SPY	ETF	112.48	112.82	112.24	112.53	5827200.0
2004-09-03 10:00:00	SPY	ETF	112.54	112.55	112.21	112.23	5196600.0
2004-09-03 11:00:00	SPY	ETF	112.22	112.38	112.04	112.32	3946700.0
2004-09-03 12:00:00	SPY	ETF	112.32	112.44	112.19	112.23	1699500.0
2004-09-03 13:00:00	SPY	ETF	112.23	112.35	112.18	112.28	1972900.0
2004-09-03 14:00:00	SPY	ETF	112.27	112.37	112.02	112.06	2964500.0
2004-09-03 15:00:00	SPY	ETF	112.06	112.38	112.01	112.09	3862500.0
2004-09-03 16:00:00	SPY	ETF	112.1	112.222	112.03	112.15	801100.0
2004-09-03 17:00:00	SPY	ETF	112.13	112.15	112.13	112.13	5900.0
2004-09-03 18:00:00	SPY	ETF	112.13	112.13	112.1	112.1	400.0
2004-09-03 19:00:00	SPY	ETF	112.18	112.18	112.18	112.18	100.0
2004-09-03 08:00:00	QQQ	ETF	34.46	34.59	34.41	34.54	967700.0
2004-09-03 09:00:00	QQQ	ETF	34.53	34.67	34.36	34.569	17187700.0
2004-09-03 10:00:00	QQQ	ETF	34.57	34.58	34.183	34.19	20939000.0
2004-09-03 11:00:00	QQQ	ETF	34.19	34.24	34.05	34.2	16894700.0
2004-09-03 12:00:00	QQQ	ETF	34.2	34.28	34.13	34.14	6246600.0
2004-09-03 13:00:00	QQQ	ETF	34.13	34.23	34.12	34.18	3837100.0
2004-09-03 14:00:00	QQQ	ETF	34.18	34.23	34.089	34.11	5261700.0
2004-09-03 15:00:00	QQQ	ETF	34.111	34.24	34.09	34.133	10237500.0
2004-09-03 16:00:00	QQQ	ETF	34.152	34.45	34.1001	34.16	2435900.0
2004-09-03 17:00:00	QQQ	ETF	34.14	34.16	34.13	34.14	63900.0
2004-09-03 18:00:00	QQQ	ETF	34.14	34.16	34.14	34.16	28400.0
2004-09-03 19:00:00	QQQ	ETF	34.16	34.17	34.16	34.17	4100.0
2004-09-03 08:00:00	IWM	ETF	55.855	56.075	55.755	56.005	72400.0
2004-09-03 09:00:00	IWM	ETF	55.975	56.105	55.775	55.965	2347800.0
2004-09-03 10:00:00	IWM	ETF	55.96	55.96	55.525	55.525	2076000.0
2004-09-03 11:00:00	IWM	ETF	55.525	55.525	55.2	55.395	1628800.0
2004-09-03 12:00:00	IWM	ETF	55.3993	55.51	55.295	55.295	838200.0
2004-09-03 13:00:00	IWM	ETF	55.29	55.44	55.29	55.435	297000.0
2004-09-03 14:00:00	IWM	ETF	55.455	55.49	55.345	55.37	582800.0
2004-09-03 15:00:00	IWM	ETF	55.375	55.65	55.335	55.37	2034400.0
2004-09-03 16:00:00	IWM	ETF	55.3792	55.5	55.375	55.5	364600.0
2004-09-03 08:00:00	DIA	ETF	102.89	103.11	102.83	103.08	39600.0
2004-09-03 09:00:00	DIA	ETF	103.08	103.39	102.93	103.18	1169900.0
2004-09-03 10:00:00	DIA	ETF	103.18	103.2	102.94	103.0	729700.0
2004-09-03 11:00:00	DIA	ETF	102.96	103.11	102.81	103.08	710300.0
2004-09-03 12:00:00	DIA	ETF	103.08	103.14	102.85	103.0	285700.0
2004-09-03 13:00:00	DIA	ETF	103.0	103.09	102.98	103.06	237000.0
2004-09-03 14:00:00	DIA	ETF	103.05	103.1	102.82	102.87	591100.0
2004-09-03 15:00:00	DIA	ETF	102.87	103.14	102.81	102.85	806400.0
2004-09-03 16:00:00	DIA	ETF	102.86	102.91	102.77	102.88	136500.0
2004-09-03 19:00:00	DIA	ETF	102.83	102.83	102.83	102.83	200.0
2004-09-03 08:00:00	TLT	ETF	86.87	86.87	85.85	86.67	30200.0
2004-09-03 09:00:00	TLT	ETF	86.6	86.6	86.35	86.39	194400.0
2004-09-03 10:00:00	TLT	ETF	86.39	86.47	86.06	86.12	172900.0
2004-09-03 11:00:00	TLT	ETF	86.12	86.21	86.05	86.21	97100.0
2004-09-03 12:00:00	TLT	ETF	86.18	86.18	86.04	86.04	126400.0
2004-09-03 13:00:00	TLT	ETF	86.04	86.1	86.0	86.07	33300.0
2004-09-03 14:00:00	TLT	ETF	86.07	86.27	86.07	86.24	47000.0

> showing 50 of 678 rows — these rows as CSV

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