PREVIEW / etf_1hour / 2004-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-29.parquet
  size:    24 KB
  rows:    675

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-06-29 08:00:00	SPY	ETF	113.65	113.65	113.42	113.44	55900.0
2004-06-29 09:00:00	SPY	ETF	113.44	113.74	113.42	113.74	3989100.0
2004-06-29 10:00:00	SPY	ETF	113.71	113.97	113.69	113.79	6192400.0
2004-06-29 11:00:00	SPY	ETF	113.8	114.06	113.76	114.01	2939000.0
2004-06-29 12:00:00	SPY	ETF	114.02	114.17	113.87	113.93	2755600.0
2004-06-29 13:00:00	SPY	ETF	113.9315	114.03	113.8	113.95	1724800.0
2004-06-29 14:00:00	SPY	ETF	113.93	114.11	113.77	114.01	3241000.0
2004-06-29 15:00:00	SPY	ETF	114.02	114.12	113.85	113.98	3629800.0
2004-06-29 16:00:00	SPY	ETF	113.97	114.02	113.8233	113.98	1841700.0
2004-06-29 17:00:00	SPY	ETF	113.98	113.98	113.92	113.93	40400.0
2004-06-29 18:00:00	SPY	ETF	113.93	113.99	113.92	113.94	3800.0
2004-06-29 08:00:00	QQQ	ETF	37.13	37.13	37.06	37.08	43900.0
2004-06-29 09:00:00	QQQ	ETF	37.08	37.28	37.08	37.24	9184000.0
2004-06-29 10:00:00	QQQ	ETF	37.24	37.43	37.24	37.33	14860900.0
2004-06-29 11:00:00	QQQ	ETF	37.34	37.41	37.27	37.409	9317900.0
2004-06-29 12:00:00	QQQ	ETF	37.39	37.47	37.32	37.33	6805400.0
2004-06-29 13:00:00	QQQ	ETF	37.34	37.37	37.25	37.34	5369900.0
2004-06-29 14:00:00	QQQ	ETF	37.34	37.423	37.28	37.41	6663200.0
2004-06-29 15:00:00	QQQ	ETF	37.41	37.471	37.33	37.44	11585500.0
2004-06-29 16:00:00	QQQ	ETF	37.45	37.46	37.35	37.4	3052800.0
2004-06-29 17:00:00	QQQ	ETF	37.4	37.42	37.38	37.39	131400.0
2004-06-29 18:00:00	QQQ	ETF	37.4	37.43	37.4	37.41	35600.0
2004-06-29 19:00:00	QQQ	ETF	37.4	37.45	37.4	37.45	14800.0
2004-06-29 08:00:00	IWM	ETF	58.125	58.125	58.125	58.125	1000.0
2004-06-29 09:00:00	IWM	ETF	58.125	58.585	58.07	58.56	1006000.0
2004-06-29 10:00:00	IWM	ETF	58.585	58.865	58.47	58.62	2028200.0
2004-06-29 11:00:00	IWM	ETF	58.625	58.67	58.525	58.615	802000.0
2004-06-29 12:00:00	IWM	ETF	58.625	58.65	58.395	58.405	1113800.0
2004-06-29 13:00:00	IWM	ETF	58.425	58.5	58.355	58.405	315000.0
2004-06-29 14:00:00	IWM	ETF	58.41	58.585	58.345	58.485	578600.0
2004-06-29 15:00:00	IWM	ETF	58.485	58.655	58.41	58.635	1177400.0
2004-06-29 16:00:00	IWM	ETF	58.635	58.665	58.56	58.64	563400.0
2004-06-29 18:00:00	IWM	ETF	58.665	58.665	58.665	58.665	600.0
2004-06-29 08:00:00	DIA	ETF	103.76	103.76	103.62	103.62	5500.0
2004-06-29 09:00:00	DIA	ETF	103.64	103.92	103.57	103.92	867500.0
2004-06-29 10:00:00	DIA	ETF	103.95	104.18	103.87	104.01	1178900.0
2004-06-29 11:00:00	DIA	ETF	104.02	104.27	104.0	104.24	423200.0
2004-06-29 12:00:00	DIA	ETF	104.25	104.44	104.21	104.22	607400.0
2004-06-29 13:00:00	DIA	ETF	104.23	104.3	104.15	104.29	209800.0
2004-06-29 14:00:00	DIA	ETF	104.29	104.43	104.13	104.34	465900.0
2004-06-29 15:00:00	DIA	ETF	104.35	104.45	104.2	104.3	486100.0
2004-06-29 16:00:00	DIA	ETF	104.31	104.34	104.17	104.32	547900.0
2004-06-29 17:00:00	DIA	ETF	104.34	104.34	104.34	104.34	200.0
2004-06-29 18:00:00	DIA	ETF	104.35	104.35	104.35	104.35	500.0
2004-06-29 19:00:00	DIA	ETF	104.35	104.35	104.35	104.35	500.0
2004-06-29 09:00:00	TLT	ETF	82.4	82.44	82.32	82.4	25500.0
2004-06-29 10:00:00	TLT	ETF	82.2	82.54	82.17	82.54	65200.0
2004-06-29 11:00:00	TLT	ETF	82.53	82.64	82.47	82.55	18800.0
2004-06-29 12:00:00	TLT	ETF	82.59	82.66	82.55	82.66	4000.0
2004-06-29 13:00:00	TLT	ETF	82.65	82.75	82.6	82.67	22100.0

> showing 50 of 675 rows — these rows as CSV

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