PREVIEW / etf_1hour / 2004-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-27.parquet
  size:    25 KB
  rows:    673

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-07-27 08:00:00	SPY	ETF	109.09	109.18	109.06	109.11	102200.0
2004-07-27 09:00:00	SPY	ETF	109.05	109.28	109.0	109.26	3023700.0
2004-07-27 10:00:00	SPY	ETF	109.26	109.54	109.03	109.11	10722900.0
2004-07-27 11:00:00	SPY	ETF	109.11	109.26	108.97	109.18	6289000.0
2004-07-27 12:00:00	SPY	ETF	109.17	109.57	109.17	109.49	5859600.0
2004-07-27 13:00:00	SPY	ETF	109.49	109.49	109.1	109.32	3423000.0
2004-07-27 14:00:00	SPY	ETF	109.31	109.95	109.2	109.84	7479100.0
2004-07-27 15:00:00	SPY	ETF	109.85	110.11	109.82	109.88	7547100.0
2004-07-27 16:00:00	SPY	ETF	109.89	109.95	109.71	109.79	1937600.0
2004-07-27 17:00:00	SPY	ETF	109.76	109.86	109.76	109.83	17100.0
2004-07-27 19:00:00	SPY	ETF	109.86	109.86	109.86	109.86	200.0
2004-07-27 08:00:00	QQQ	ETF	34.19	34.24	34.19	34.23	455100.0
2004-07-27 09:00:00	QQQ	ETF	34.23	34.28	34.12	34.24	6919200.0
2004-07-27 10:00:00	QQQ	ETF	34.24	34.42	34.11	34.17	21678500.0
2004-07-27 11:00:00	QQQ	ETF	34.17	34.304	34.07	34.29	13421000.0
2004-07-27 12:00:00	QQQ	ETF	34.29	34.43	34.27	34.373	10546600.0
2004-07-27 13:00:00	QQQ	ETF	34.37	34.4	34.23	34.32	6350600.0
2004-07-27 14:00:00	QQQ	ETF	34.31	34.603	34.25	34.586	15451800.0
2004-07-27 15:00:00	QQQ	ETF	34.59	34.71	34.55	34.57	18726900.0
2004-07-27 16:00:00	QQQ	ETF	34.57	34.59	34.499	34.52	3070200.0
2004-07-27 17:00:00	QQQ	ETF	34.52	34.57	34.5	34.56	180200.0
2004-07-27 18:00:00	QQQ	ETF	34.56	34.57	34.54	34.57	18900.0
2004-07-27 19:00:00	QQQ	ETF	34.56	34.6	34.55	34.57	7000.0
2004-07-27 08:00:00	IWM	ETF	53.36	53.37	53.36	53.36	12400.0
2004-07-27 09:00:00	IWM	ETF	53.345	53.625	53.315	53.535	2063000.0
2004-07-27 10:00:00	IWM	ETF	53.58	53.925	53.54	53.59	3300600.0
2004-07-27 11:00:00	IWM	ETF	53.595	53.68	53.48	53.66	2014000.0
2004-07-27 12:00:00	IWM	ETF	53.645	53.845	53.63	53.79	1243200.0
2004-07-27 13:00:00	IWM	ETF	53.795	53.8	53.625	53.745	696000.0
2004-07-27 14:00:00	IWM	ETF	53.75	54.24	53.665	54.215	2357800.0
2004-07-27 15:00:00	IWM	ETF	54.215	54.345	54.205	54.28	2896600.0
2004-07-27 16:00:00	IWM	ETF	54.295	54.295	54.09	54.12	350600.0
2004-07-27 08:00:00	DIA	ETF	100.08	100.08	100.04	100.04	12200.0
2004-07-27 09:00:00	DIA	ETF	100.04	100.35	99.98	100.31	395000.0
2004-07-27 10:00:00	DIA	ETF	100.3	100.53	100.22	100.29	1647400.0
2004-07-27 11:00:00	DIA	ETF	100.28	100.55	100.22	100.41	405300.0
2004-07-27 12:00:00	DIA	ETF	100.42	100.78	100.4	100.73	509200.0
2004-07-27 13:00:00	DIA	ETF	100.73	100.74	100.36	100.53	368500.0
2004-07-27 14:00:00	DIA	ETF	100.53	101.11	100.45	100.98	1438600.0
2004-07-27 15:00:00	DIA	ETF	100.97	101.21	100.92	101.05	963300.0
2004-07-27 16:00:00	DIA	ETF	101.02	101.06	100.92	100.92	50100.0
2004-07-27 17:00:00	DIA	ETF	100.93	101.04	100.93	100.99	400.0
2004-07-27 09:00:00	TLT	ETF	84.4	84.47	84.38	84.44	21100.0
2004-07-27 10:00:00	TLT	ETF	84.37	84.39	84.09	84.18	156000.0
2004-07-27 11:00:00	TLT	ETF	84.16	84.2	83.89	83.93	66700.0
2004-07-27 12:00:00	TLT	ETF	83.95	83.95	83.8	83.85	118300.0
2004-07-27 13:00:00	TLT	ETF	83.83	83.83	83.5	83.57	97600.0
2004-07-27 14:00:00	TLT	ETF	83.55	83.57	83.41	83.48	233400.0
2004-07-27 15:00:00	TLT	ETF	83.46	83.48	83.41	83.45	149700.0
2004-07-27 16:00:00	TLT	ETF	83.44	83.44	83.41	83.41	105700.0

> showing 50 of 673 rows — these rows as CSV

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