PREVIEW / etf_1hour / 2004-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-15.parquet
  size:    27 KB
  rows:    784

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-15 08:00:00	SPY	ETF	118.55	118.55	118.4	118.49	117600.0
2004-11-15 09:00:00	SPY	ETF	118.47	118.58	118.28	118.46	5415800.0
2004-11-15 10:00:00	SPY	ETF	118.46	118.69	118.37	118.43	8119700.0
2004-11-15 11:00:00	SPY	ETF	118.43	118.48	118.23	118.48	4991900.0
2004-11-15 12:00:00	SPY	ETF	118.46	118.73	118.33	118.72	3481700.0
2004-11-15 13:00:00	SPY	ETF	118.72	118.73	118.33	118.37	2552300.0
2004-11-15 14:00:00	SPY	ETF	118.36	118.61	118.3	118.42	4279200.0
2004-11-15 15:00:00	SPY	ETF	118.41	118.68	118.39	118.67	4147800.0
2004-11-15 16:00:00	SPY	ETF	118.67	118.77	118.61	118.73	1679200.0
2004-11-15 17:00:00	SPY	ETF	118.73	118.75	118.6	118.71	80500.0
2004-11-15 08:00:00	QQQ	ETF	38.62	38.63	38.55	38.6	222500.0
2004-11-15 09:00:00	QQQ	ETF	38.6	38.69	38.53	38.62	13025300.0
2004-11-15 10:00:00	QQQ	ETF	38.629	38.78	38.61	38.73	14186600.0
2004-11-15 11:00:00	QQQ	ETF	38.73	38.73	38.57	38.73	10895200.0
2004-11-15 12:00:00	QQQ	ETF	38.72	38.859	38.66	38.85	10327500.0
2004-11-15 13:00:00	QQQ	ETF	38.85	38.86	38.719	38.72	8940200.0
2004-11-15 14:00:00	QQQ	ETF	38.72	38.79	38.66	38.67	8911800.0
2004-11-15 15:00:00	QQQ	ETF	38.67	38.81	38.67	38.8	13366100.0
2004-11-15 16:00:00	QQQ	ETF	38.794	38.85	38.79	38.839	2438200.0
2004-11-15 17:00:00	QQQ	ETF	38.84	38.85	38.82	38.85	34600.0
2004-11-15 18:00:00	QQQ	ETF	38.84	38.85	38.81	38.85	14600.0
2004-11-15 19:00:00	QQQ	ETF	38.84	38.86	38.84	38.86	40600.0
2004-11-15 09:00:00	IWM	ETF	61.95	62.025	61.75	61.95	1537200.0
2004-11-15 10:00:00	IWM	ETF	61.975	62.08	61.88	61.885	1803400.0
2004-11-15 11:00:00	IWM	ETF	61.885	61.89	61.675	61.88	890200.0
2004-11-15 12:00:00	IWM	ETF	61.875	62.155	61.86	62.155	1334000.0
2004-11-15 13:00:00	IWM	ETF	62.13	62.145	61.89	61.89	947800.0
2004-11-15 14:00:00	IWM	ETF	61.875	62.02	61.83	61.975	881200.0
2004-11-15 15:00:00	IWM	ETF	61.975	62.195	61.93	62.175	1224600.0
2004-11-15 16:00:00	IWM	ETF	62.17	62.295	62.15	62.295	206800.0
2004-11-15 17:00:00	IWM	ETF	62.215	62.225	62.18	62.225	101000.0
2004-11-15 08:00:00	DIA	ETF	105.46	105.52	105.43	105.52	6500.0
2004-11-15 09:00:00	DIA	ETF	105.47	105.64	105.4	105.52	742000.0
2004-11-15 10:00:00	DIA	ETF	105.52	105.82	105.51	105.57	751300.0
2004-11-15 11:00:00	DIA	ETF	105.56	105.61	105.4	105.59	742400.0
2004-11-15 12:00:00	DIA	ETF	105.58	105.81	105.51	105.8	435600.0
2004-11-15 13:00:00	DIA	ETF	105.8	105.84	105.5	105.5	318700.0
2004-11-15 14:00:00	DIA	ETF	105.5	105.61	105.42	105.47	515100.0
2004-11-15 15:00:00	DIA	ETF	105.48	105.67	105.47	105.64	896400.0
2004-11-15 16:00:00	DIA	ETF	105.67	105.77	105.64	105.74	171900.0
2004-11-15 17:00:00	DIA	ETF	105.73	105.73	105.7	105.7	1300.0
2004-11-15 18:00:00	DIA	ETF	105.7	105.7	105.69	105.69	3900.0
2004-11-15 08:00:00	TLT	ETF	88.03	88.03	88.03	88.03	3200.0
2004-11-15 09:00:00	TLT	ETF	87.95	87.95	87.82	87.84	431800.0
2004-11-15 10:00:00	TLT	ETF	87.86	87.87	87.74	87.8	112900.0
2004-11-15 11:00:00	TLT	ETF	87.84	87.93	87.81	87.88	56400.0
2004-11-15 12:00:00	TLT	ETF	87.89	87.91	87.8	87.82	40000.0
2004-11-15 13:00:00	TLT	ETF	87.75	87.94	87.75	87.88	4000.0
2004-11-15 14:00:00	TLT	ETF	87.92	88.0	87.92	87.98	44100.0
2004-11-15 15:00:00	TLT	ETF	87.99	88.0	87.91	88.0	44100.0

> showing 50 of 784 rows — these rows as CSV

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