PREVIEW / etf_1hour / 2004-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-22.parquet
  size:    23 KB
  rows:    645

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-01-22 08:00:00	SPY	ETF	114.95	115.12	114.93	115.1	23500.0
2004-01-22 09:00:00	SPY	ETF	115.1	115.38	115.08	115.32	4772500.0
2004-01-22 10:00:00	SPY	ETF	115.34	115.35	114.85	114.93	5456900.0
2004-01-22 11:00:00	SPY	ETF	114.92	114.97	114.67	114.84	4658600.0
2004-01-22 12:00:00	SPY	ETF	114.83	115.18	114.81	115.03	3126800.0
2004-01-22 13:00:00	SPY	ETF	115.03	115.05	114.76	114.88	1423900.0
2004-01-22 14:00:00	SPY	ETF	114.9	115.06	114.58	114.65	2935500.0
2004-01-22 15:00:00	SPY	ETF	114.65	115.02	114.63	114.73	3367600.0
2004-01-22 16:00:00	SPY	ETF	114.73	114.94	114.45	114.6	1585000.0
2004-01-22 17:00:00	SPY	ETF	114.56	114.61	114.5	114.51	20700.0
2004-01-22 18:00:00	SPY	ETF	114.54	114.6	114.51	114.6	10400.0
2004-01-22 19:00:00	SPY	ETF	114.62	114.62	114.62	114.62	100.0
2004-01-22 08:00:00	QQQ	ETF	38.45	38.54	38.44	38.52	143500.0
2004-01-22 09:00:00	QQQ	ETF	38.52	38.69	38.51	38.6	10149600.0
2004-01-22 10:00:00	QQQ	ETF	38.6	38.611	38.24	38.28	16508700.0
2004-01-22 11:00:00	QQQ	ETF	38.277	38.33	38.09	38.25	13244300.0
2004-01-22 12:00:00	QQQ	ETF	38.24	38.52	38.24	38.4	12436900.0
2004-01-22 13:00:00	QQQ	ETF	38.4	38.4	38.17	38.26	7489000.0
2004-01-22 14:00:00	QQQ	ETF	38.26	38.35	38.1	38.16	8506500.0
2004-01-22 15:00:00	QQQ	ETF	38.15	38.35	38.07	38.083	11846300.0
2004-01-22 16:00:00	QQQ	ETF	38.09	38.35	37.822	37.919	5684800.0
2004-01-22 17:00:00	QQQ	ETF	37.92	37.96	37.89	37.95	784100.0
2004-01-22 18:00:00	QQQ	ETF	37.96	37.97	37.91	37.95	362600.0
2004-01-22 19:00:00	QQQ	ETF	37.97	38.0	37.96	37.97	17800.0
2004-01-22 09:00:00	IWM	ETF	59.66	59.865	59.66	59.795	1145800.0
2004-01-22 10:00:00	IWM	ETF	59.835	59.835	59.259	59.26	2010000.0
2004-01-22 11:00:00	IWM	ETF	59.25	59.26	59.005	59.145	610200.0
2004-01-22 12:00:00	IWM	ETF	59.13	59.3495	59.12	59.24	465600.0
2004-01-22 13:00:00	IWM	ETF	59.2245	59.24	59.065	59.085	455000.0
2004-01-22 14:00:00	IWM	ETF	59.1	59.275	59.035	59.084	328400.0
2004-01-22 15:00:00	IWM	ETF	59.0775	59.26	58.83	58.83	724200.0
2004-01-22 16:00:00	IWM	ETF	58.84	59.04	58.83	58.91	167800.0
2004-01-22 17:00:00	IWM	ETF	59.04	59.04	59.04	59.04	800.0
2004-01-22 18:00:00	IWM	ETF	59.04	59.04	59.04	59.04	600.0
2004-01-22 08:00:00	DIA	ETF	106.25	106.32	106.22	106.32	8000.0
2004-01-22 09:00:00	DIA	ETF	106.42	106.75	106.39	106.72	775100.0
2004-01-22 10:00:00	DIA	ETF	106.67	106.71	106.25	106.39	1495900.0
2004-01-22 11:00:00	DIA	ETF	106.39	106.44	106.19	106.35	546400.0
2004-01-22 12:00:00	DIA	ETF	106.34	106.69	106.34	106.55	470300.0
2004-01-22 13:00:00	DIA	ETF	106.53	106.58	106.3	106.43	682300.0
2004-01-22 14:00:00	DIA	ETF	106.44	106.6	106.23	106.32	426500.0
2004-01-22 15:00:00	DIA	ETF	106.3	106.58	106.3	106.36	1083900.0
2004-01-22 16:00:00	DIA	ETF	106.38	106.57	106.2	106.27	385100.0
2004-01-22 17:00:00	DIA	ETF	106.3	106.37	106.3	106.37	1400.0
2004-01-22 18:00:00	DIA	ETF	106.27	106.32	106.25	106.32	800.0
2004-01-22 19:00:00	DIA	ETF	106.3	106.3	106.3	106.3	100.0
2004-01-22 09:00:00	TLT	ETF	87.95	87.99	87.71	87.75	21100.0
2004-01-22 10:00:00	TLT	ETF	87.73	88.0	87.73	88.0	67900.0
2004-01-22 11:00:00	TLT	ETF	88.0	88.33	88.0	88.3	181900.0
2004-01-22 12:00:00	TLT	ETF	88.29	88.4	88.22	88.26	23700.0

> showing 50 of 645 rows — these rows as CSV

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