PREVIEW / etf_1hour / 2004-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-28.parquet
  size:    26 KB
  rows:    705

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-28 08:00:00	SPY	ETF	113.93	114.01	113.8	113.83	81500.0
2004-04-28 09:00:00	SPY	ETF	113.82	113.9	113.27	113.53	5526000.0
2004-04-28 10:00:00	SPY	ETF	113.52	113.58	113.12	113.19	6018100.0
2004-04-28 11:00:00	SPY	ETF	113.17	113.27	112.75	113.09	6538900.0
2004-04-28 12:00:00	SPY	ETF	113.08	113.31	113.01	113.28	3211100.0
2004-04-28 13:00:00	SPY	ETF	113.27	113.3	112.82	113.05	3534700.0
2004-04-28 14:00:00	SPY	ETF	113.06	113.28	112.75	112.86	4295700.0
2004-04-28 15:00:00	SPY	ETF	112.87	113.0	112.5	112.58	8238400.0
2004-04-28 16:00:00	SPY	ETF	112.58	112.88	112.53	112.74	2107300.0
2004-04-28 17:00:00	SPY	ETF	112.7	112.78	112.69	112.72	173500.0
2004-04-28 18:00:00	SPY	ETF	112.76	112.78	112.73	112.73	6800.0
2004-04-28 19:00:00	SPY	ETF	112.73	112.77	112.7	112.77	6500.0
2004-04-28 08:00:00	QQQ	ETF	36.78	36.78	36.67	36.69	334000.0
2004-04-28 09:00:00	QQQ	ETF	36.69	36.72	36.4	36.47	16950100.0
2004-04-28 10:00:00	QQQ	ETF	36.473	36.56	36.31	36.353	17442800.0
2004-04-28 11:00:00	QQQ	ETF	36.354	36.45	36.2	36.36	14589200.0
2004-04-28 12:00:00	QQQ	ETF	36.37	36.47	36.31	36.46	5483700.0
2004-04-28 13:00:00	QQQ	ETF	36.467	36.471	36.25	36.38	6806800.0
2004-04-28 14:00:00	QQQ	ETF	36.367	36.44	36.16	36.22	11682100.0
2004-04-28 15:00:00	QQQ	ETF	36.22	36.26	36.019	36.08	19454300.0
2004-04-28 16:00:00	QQQ	ETF	36.077	36.221	36.05	36.14	2670700.0
2004-04-28 17:00:00	QQQ	ETF	36.14	36.16	36.13	36.14	87200.0
2004-04-28 18:00:00	QQQ	ETF	36.14	36.18	36.14	36.18	18700.0
2004-04-28 19:00:00	QQQ	ETF	36.18	36.18	36.14	36.17	11800.0
2004-04-28 08:00:00	IWM	ETF	58.675	58.68	58.6	58.605	9000.0
2004-04-28 09:00:00	IWM	ETF	58.54	58.65	57.955	58.225	1078800.0
2004-04-28 10:00:00	IWM	ETF	58.23	58.27	57.925	57.935	1211600.0
2004-04-28 11:00:00	IWM	ETF	57.935	58.025	57.58	57.87	2324600.0
2004-04-28 12:00:00	IWM	ETF	57.865	58.08	57.8	58.07	993200.0
2004-04-28 13:00:00	IWM	ETF	58.065	58.065	57.625	57.77	1606400.0
2004-04-28 14:00:00	IWM	ETF	57.775	57.88	57.525	57.56	1305600.0
2004-04-28 15:00:00	IWM	ETF	57.565	57.655	57.3	57.415	3471000.0
2004-04-28 16:00:00	IWM	ETF	57.415	57.62	57.415	57.575	288000.0
2004-04-28 17:00:00	IWM	ETF	57.59	57.59	57.525	57.565	80200.0
2004-04-28 18:00:00	IWM	ETF	57.565	57.565	57.565	57.565	1000.0
2004-04-28 08:00:00	DIA	ETF	104.77	104.81	104.68	104.7	14900.0
2004-04-28 09:00:00	DIA	ETF	104.69	104.75	104.16	104.42	935700.0
2004-04-28 10:00:00	DIA	ETF	104.41	104.43	104.07	104.1	622700.0
2004-04-28 11:00:00	DIA	ETF	104.08	104.17	103.72	104.01	1775600.0
2004-04-28 12:00:00	DIA	ETF	104.02	104.22	103.93	104.18	163600.0
2004-04-28 13:00:00	DIA	ETF	104.17	104.2	103.79	103.97	675500.0
2004-04-28 14:00:00	DIA	ETF	103.97	104.16	103.72	103.84	1441100.0
2004-04-28 15:00:00	DIA	ETF	103.83	103.94	103.5	103.6	1484400.0
2004-04-28 16:00:00	DIA	ETF	103.59	103.83	103.56	103.73	238900.0
2004-04-28 17:00:00	DIA	ETF	103.75	103.81	103.67	103.67	500.0
2004-04-28 19:00:00	DIA	ETF	103.67	103.67	103.67	103.67	600.0
2004-04-28 09:00:00	TLT	ETF	84.3	84.43	84.2	84.2	72700.0
2004-04-28 10:00:00	TLT	ETF	84.24	84.24	84.09	84.1	28300.0
2004-04-28 11:00:00	TLT	ETF	84.11	84.2	84.11	84.17	512100.0
2004-04-28 12:00:00	TLT	ETF	84.13	84.15	84.0	84.0	11000.0

> showing 50 of 705 rows — these rows as CSV

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