PREVIEW / etf_1hour / 2004-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-21.parquet
  size:    26 KB
  rows:    712

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-21 08:00:00	SPY	ETF	112.3	112.34	112.03	112.33	39800.0
2004-04-21 09:00:00	SPY	ETF	112.32	112.38	111.87	112.34	7464100.0
2004-04-21 10:00:00	SPY	ETF	112.34	112.72	111.96	112.07	11661500.0
2004-04-21 11:00:00	SPY	ETF	112.08	112.6	111.89	112.59	7558400.0
2004-04-21 12:00:00	SPY	ETF	112.59	112.79	112.37	112.45	4848500.0
2004-04-21 13:00:00	SPY	ETF	112.45	112.76	112.43	112.75	1594500.0
2004-04-21 14:00:00	SPY	ETF	112.75	112.95	112.48	112.53	5414100.0
2004-04-21 15:00:00	SPY	ETF	112.5221	112.87	112.52	112.81	5576100.0
2004-04-21 16:00:00	SPY	ETF	112.81	112.91	112.67	112.9	1841500.0
2004-04-21 17:00:00	SPY	ETF	112.94	113.03	112.7	112.7	116100.0
2004-04-21 18:00:00	SPY	ETF	112.7	112.71	112.64	112.68	55800.0
2004-04-21 19:00:00	SPY	ETF	112.77	112.79	112.74	112.74	1300.0
2004-04-21 08:00:00	QQQ	ETF	35.8	35.96	35.8	35.96	332200.0
2004-04-21 09:00:00	QQQ	ETF	35.96	35.96	35.68	35.92	23293600.0
2004-04-21 10:00:00	QQQ	ETF	35.92	36.07	35.74	35.776	23391800.0
2004-04-21 11:00:00	QQQ	ETF	35.786	36.02	35.649	35.99	17726000.0
2004-04-21 12:00:00	QQQ	ETF	36.0	36.04	35.88	35.9	10575600.0
2004-04-21 13:00:00	QQQ	ETF	35.91	36.019	35.9	36.0	5897000.0
2004-04-21 14:00:00	QQQ	ETF	36.0	36.1	35.92	35.97	14744000.0
2004-04-21 15:00:00	QQQ	ETF	35.96	36.11	35.95	36.075	10863700.0
2004-04-21 16:00:00	QQQ	ETF	36.08	36.22	35.15	36.2	3341000.0
2004-04-21 17:00:00	QQQ	ETF	36.21	36.24	35.8	35.85	2667200.0
2004-04-21 18:00:00	QQQ	ETF	35.86	35.96	35.86	35.96	470800.0
2004-04-21 19:00:00	QQQ	ETF	35.96	36.04	35.96	36.04	33500.0
2004-04-21 08:00:00	IWM	ETF	57.425	57.515	57.425	57.51	5800.0
2004-04-21 09:00:00	IWM	ETF	57.54	57.585	57.02	57.45	1959600.0
2004-04-21 10:00:00	IWM	ETF	57.43	57.75	57.25	57.325	3288200.0
2004-04-21 11:00:00	IWM	ETF	57.325	57.73	57.2	57.725	1967000.0
2004-04-21 12:00:00	IWM	ETF	57.725	57.895	57.635	57.67	869800.0
2004-04-21 13:00:00	IWM	ETF	57.725	57.82	57.655	57.82	790600.0
2004-04-21 14:00:00	IWM	ETF	57.815	58.085	57.73	57.885	1338600.0
2004-04-21 15:00:00	IWM	ETF	57.875	58.11	57.765	58.1	1213600.0
2004-04-21 16:00:00	IWM	ETF	58.115	58.275	58.075	58.275	297600.0
2004-04-21 17:00:00	IWM	ETF	58.4	58.4	58.21	58.21	14600.0
2004-04-21 18:00:00	IWM	ETF	58.2	58.2	58.2	58.2	400.0
2004-04-21 08:00:00	DIA	ETF	103.13	103.35	103.13	103.35	34600.0
2004-04-21 09:00:00	DIA	ETF	103.39	103.42	102.75	103.19	1715900.0
2004-04-21 10:00:00	DIA	ETF	103.16	103.44	102.7	102.81	1625900.0
2004-04-21 11:00:00	DIA	ETF	102.83	103.28	102.6	103.28	1421700.0
2004-04-21 12:00:00	DIA	ETF	103.27	103.43	102.99	103.06	746900.0
2004-04-21 13:00:00	DIA	ETF	103.08	103.37	103.03	103.37	321500.0
2004-04-21 14:00:00	DIA	ETF	103.36	103.5	103.09	103.12	676200.0
2004-04-21 15:00:00	DIA	ETF	103.09	103.44	103.09	103.36	837900.0
2004-04-21 16:00:00	DIA	ETF	103.41	103.45	103.27	103.45	113100.0
2004-04-21 17:00:00	DIA	ETF	103.49	103.49	103.15	103.15	20100.0
2004-04-21 08:00:00	TLT	ETF	83.63	83.63	83.63	83.63	2000.0
2004-04-21 09:00:00	TLT	ETF	83.72	83.86	83.72	83.77	112100.0
2004-04-21 10:00:00	TLT	ETF	83.75	84.15	83.75	83.99	245100.0
2004-04-21 11:00:00	TLT	ETF	83.99	84.04	83.72	83.94	56300.0
2004-04-21 12:00:00	TLT	ETF	83.9	84.07	83.85	84.0	61100.0

> showing 50 of 712 rows — these rows as CSV

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