PREVIEW / etf_1hour / 2004-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-19.parquet
  size:    24 KB
  rows:    679

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-19 08:00:00	SPY	ETF	113.63	113.63	113.43	113.58	84000.0
2004-04-19 09:00:00	SPY	ETF	113.6	113.84	113.4	113.55	4193800.0
2004-04-19 10:00:00	SPY	ETF	113.53	113.63	113.27	113.48	4189000.0
2004-04-19 11:00:00	SPY	ETF	113.48	113.78	113.38	113.73	3424800.0
2004-04-19 12:00:00	SPY	ETF	113.72	113.79	113.61	113.7	3531400.0
2004-04-19 13:00:00	SPY	ETF	113.7	113.73	113.45	113.59	2879000.0
2004-04-19 14:00:00	SPY	ETF	113.6	113.73	113.43	113.69	2369000.0
2004-04-19 15:00:00	SPY	ETF	113.7	113.99	113.66	113.88	3838900.0
2004-04-19 16:00:00	SPY	ETF	113.88	113.92	113.74	113.77	1023100.0
2004-04-19 17:00:00	SPY	ETF	113.77	113.77	113.72	113.73	1100.0
2004-04-19 18:00:00	SPY	ETF	113.74	113.74	113.71	113.71	400.0
2004-04-19 08:00:00	QQQ	ETF	36.05	36.05	35.93	36.0	263200.0
2004-04-19 09:00:00	QQQ	ETF	36.0	36.19	35.99	36.1	10713300.0
2004-04-19 10:00:00	QQQ	ETF	36.1	36.18	35.98	36.121	13455000.0
2004-04-19 11:00:00	QQQ	ETF	36.121	36.341	36.1	36.341	11589900.0
2004-04-19 12:00:00	QQQ	ETF	36.34	36.391	36.284	36.34	8290100.0
2004-04-19 13:00:00	QQQ	ETF	36.33	36.36	36.26	36.33	5475600.0
2004-04-19 14:00:00	QQQ	ETF	36.328	36.43	36.23	36.41	8375000.0
2004-04-19 15:00:00	QQQ	ETF	36.4	36.58	36.39	36.57	19297700.0
2004-04-19 16:00:00	QQQ	ETF	36.564	36.62	36.51	36.534	3910800.0
2004-04-19 17:00:00	QQQ	ETF	36.534	36.54	36.49	36.5	376900.0
2004-04-19 18:00:00	QQQ	ETF	36.51	36.53	36.49	36.51	41900.0
2004-04-19 19:00:00	QQQ	ETF	36.51	36.53	36.5	36.53	5000.0
2004-04-19 08:00:00	IWM	ETF	57.99	57.99	57.99	57.99	2000.0
2004-04-19 09:00:00	IWM	ETF	58.05	58.24	57.75	57.92	861600.0
2004-04-19 10:00:00	IWM	ETF	57.91	57.91	57.585	57.775	2161600.0
2004-04-19 11:00:00	IWM	ETF	57.785	58.145	57.74	58.115	1304200.0
2004-04-19 12:00:00	IWM	ETF	58.15	58.19	58.07	58.13	332800.0
2004-04-19 13:00:00	IWM	ETF	58.13	58.16	58.0	58.09	497800.0
2004-04-19 14:00:00	IWM	ETF	58.125	58.325	57.98	58.305	680000.0
2004-04-19 15:00:00	IWM	ETF	58.32	58.62	58.31	58.61	4302600.0
2004-04-19 16:00:00	IWM	ETF	58.61	58.61	58.49	58.53	427400.0
2004-04-19 08:00:00	DIA	ETF	104.7	104.7	104.4	104.5	1500.0
2004-04-19 09:00:00	DIA	ETF	104.59	104.67	104.35	104.47	998400.0
2004-04-19 10:00:00	DIA	ETF	104.47	104.54	104.1	104.27	714800.0
2004-04-19 11:00:00	DIA	ETF	104.23	104.47	104.18	104.42	329100.0
2004-04-19 12:00:00	DIA	ETF	104.43	104.47	104.3	104.36	226400.0
2004-04-19 13:00:00	DIA	ETF	104.36	104.39	104.22	104.33	280700.0
2004-04-19 14:00:00	DIA	ETF	104.35	104.43	104.15	104.35	294700.0
2004-04-19 15:00:00	DIA	ETF	104.36	104.64	104.35	104.51	651900.0
2004-04-19 16:00:00	DIA	ETF	104.53	104.53	104.41	104.41	23300.0
2004-04-19 17:00:00	DIA	ETF	104.4	104.45	104.4	104.45	1700.0
2004-04-19 09:00:00	TLT	ETF	84.85	84.9	84.72	84.9	154700.0
2004-04-19 10:00:00	TLT	ETF	84.9	84.91	84.75	84.78	261000.0
2004-04-19 11:00:00	TLT	ETF	84.79	84.79	84.66	84.66	72100.0
2004-04-19 12:00:00	TLT	ETF	84.64	84.64	84.47	84.49	47300.0
2004-04-19 13:00:00	TLT	ETF	84.5	84.6	84.39	84.41	13300.0
2004-04-19 14:00:00	TLT	ETF	84.41	84.5	84.35	84.35	26900.0
2004-04-19 15:00:00	TLT	ETF	84.33	84.4	84.3	84.33	100900.0
2004-04-19 16:00:00	TLT	ETF	84.33	84.38	84.33	84.38	800.0

> showing 50 of 679 rows — these rows as CSV

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