PREVIEW / etf_1hour / 2004-02-19

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-19.parquet
  size:    25 KB
  rows:    711

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-02-19 08:00:00	SPY	ETF	116.16	116.28	116.07	116.24	141800.0
2004-02-19 09:00:00	SPY	ETF	116.24	116.39	116.18	116.29	4571300.0
2004-02-19 10:00:00	SPY	ETF	116.27	116.28	115.91	116.02	5565100.0
2004-02-19 11:00:00	SPY	ETF	116.05	116.24	115.83	116.16	5073900.0
2004-02-19 12:00:00	SPY	ETF	116.15	116.37	115.97	116.19	2705400.0
2004-02-19 13:00:00	SPY	ETF	116.2	116.28	115.91	116.23	3978700.0
2004-02-19 14:00:00	SPY	ETF	116.23	116.28	115.92	115.98	3673100.0
2004-02-19 15:00:00	SPY	ETF	116.0	116.02	115.13	115.22	13699900.0
2004-02-19 16:00:00	SPY	ETF	115.22	115.668	115.06	115.2	4687500.0
2004-02-19 17:00:00	SPY	ETF	115.23	115.24	115.1	115.24	39500.0
2004-02-19 18:00:00	SPY	ETF	115.17	115.17	115.12	115.16	1100.0
2004-02-19 19:00:00	SPY	ETF	115.15	115.19	115.15	115.19	1100.0
2004-02-19 08:00:00	QQQ	ETF	37.83	37.87	37.75	37.86	153400.0
2004-02-19 09:00:00	QQQ	ETF	37.87	37.9	37.76	37.81	9491500.0
2004-02-19 10:00:00	QQQ	ETF	37.802	37.802	37.61	37.66	12417500.0
2004-02-19 11:00:00	QQQ	ETF	37.65	37.72	37.538	37.63	8102300.0
2004-02-19 12:00:00	QQQ	ETF	37.62	37.721	37.527	37.62	7447100.0
2004-02-19 13:00:00	QQQ	ETF	37.63	37.64	37.425	37.55	9547000.0
2004-02-19 14:00:00	QQQ	ETF	37.55	37.57	37.31	37.32	14458200.0
2004-02-19 15:00:00	QQQ	ETF	37.32	37.34	36.92	36.96	25868200.0
2004-02-19 16:00:00	QQQ	ETF	36.95	37.0	36.84	36.98	5744800.0
2004-02-19 17:00:00	QQQ	ETF	36.98	37.0	36.93	36.94	124500.0
2004-02-19 18:00:00	QQQ	ETF	36.93	36.98	36.93	36.98	55500.0
2004-02-19 19:00:00	QQQ	ETF	36.98	37.01	36.95	37.01	39300.0
2004-02-19 08:00:00	IWM	ETF	59.285	59.285	59.285	59.285	1000.0
2004-02-19 09:00:00	IWM	ETF	59.315	59.47	59.28	59.355	466400.0
2004-02-19 10:00:00	IWM	ETF	59.31	59.34	58.995	59.055	1331800.0
2004-02-19 11:00:00	IWM	ETF	59.065	59.135	58.885	59.05	283800.0
2004-02-19 12:00:00	IWM	ETF	59.035	59.16	58.92	59.005	449400.0
2004-02-19 13:00:00	IWM	ETF	59.005	59.02	58.665	58.88	536000.0
2004-02-19 14:00:00	IWM	ETF	58.81	58.89	58.525	58.55	1095000.0
2004-02-19 15:00:00	IWM	ETF	58.525	58.535	57.9	57.9655	3540200.0
2004-02-19 16:00:00	IWM	ETF	57.975	58.275	57.875	58.275	1441600.0
2004-02-19 18:00:00	IWM	ETF	57.94	57.94	57.94	57.94	200.0
2004-02-19 19:00:00	IWM	ETF	57.965	57.965	57.965	57.965	800.0
2004-02-19 08:00:00	DIA	ETF	107.5	107.65	107.45	107.63	84800.0
2004-02-19 09:00:00	DIA	ETF	107.6	107.7	107.55	107.62	463400.0
2004-02-19 10:00:00	DIA	ETF	107.61	107.69	107.47	107.62	728900.0
2004-02-19 11:00:00	DIA	ETF	107.55	107.8	107.46	107.75	586700.0
2004-02-19 12:00:00	DIA	ETF	107.75	107.92	107.57	107.83	540300.0
2004-02-19 13:00:00	DIA	ETF	107.84	107.9	107.62	107.88	619900.0
2004-02-19 14:00:00	DIA	ETF	107.88	107.901	107.62	107.73	460900.0
2004-02-19 15:00:00	DIA	ETF	107.7	107.76	106.95	107.01	1898500.0
2004-02-19 16:00:00	DIA	ETF	107.02	107.1	106.95	107.06	181900.0
2004-02-19 17:00:00	DIA	ETF	107.07	107.11	107.07	107.1	2400.0
2004-02-19 18:00:00	DIA	ETF	107.1	107.1	107.07	107.07	2100.0
2004-02-19 19:00:00	DIA	ETF	107.08	107.09	107.07	107.07	1500.0
2004-02-19 09:00:00	TLT	ETF	87.53	87.6	87.47	87.53	22100.0
2004-02-19 10:00:00	TLT	ETF	87.51	87.63	87.47	87.51	55100.0
2004-02-19 11:00:00	TLT	ETF	87.51	87.61	87.51	87.57	37000.0

> showing 50 of 711 rows — these rows as CSV

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