PREVIEW / etf_1hour / 2004-08-27

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-27.parquet
  size:    23 KB
  rows:    656

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-08-27 08:00:00	SPY	ETF	111.03	111.21	111.01	111.2	45900.0
2004-08-27 09:00:00	SPY	ETF	111.17	111.33	111.05	111.3	3078600.0
2004-08-27 10:00:00	SPY	ETF	111.3	111.5	111.23	111.32	6277300.0
2004-08-27 11:00:00	SPY	ETF	111.32	111.47	111.27	111.31	2202200.0
2004-08-27 12:00:00	SPY	ETF	111.31	111.38	111.26	111.38	1850100.0
2004-08-27 13:00:00	SPY	ETF	111.38	111.49	111.35	111.4	2080700.0
2004-08-27 14:00:00	SPY	ETF	111.41	111.62	111.39	111.6	3038400.0
2004-08-27 15:00:00	SPY	ETF	111.59	111.63	111.33	111.46	4402000.0
2004-08-27 16:00:00	SPY	ETF	111.46	111.63	111.38	111.63	1201200.0
2004-08-27 17:00:00	SPY	ETF	111.5	111.55	111.45	111.55	3200.0
2004-08-27 18:00:00	SPY	ETF	111.5	111.55	111.5	111.55	500.0
2004-08-27 19:00:00	SPY	ETF	111.55	111.55	111.55	111.55	200.0
2004-08-27 08:00:00	QQQ	ETF	34.41	34.47	34.38	34.46	189400.0
2004-08-27 09:00:00	QQQ	ETF	34.46	34.597	34.44	34.57	9079800.0
2004-08-27 10:00:00	QQQ	ETF	34.56	34.64	34.5	34.57	11968800.0
2004-08-27 11:00:00	QQQ	ETF	34.57	34.68	34.54	34.56	6693100.0
2004-08-27 12:00:00	QQQ	ETF	34.56	34.59	34.52	34.56	4480300.0
2004-08-27 13:00:00	QQQ	ETF	34.56	34.65	34.55	34.59	6378200.0
2004-08-27 14:00:00	QQQ	ETF	34.593	34.659	34.54	34.63	7510500.0
2004-08-27 15:00:00	QQQ	ETF	34.63	34.64	34.48	34.56	9436800.0
2004-08-27 16:00:00	QQQ	ETF	34.56	34.59	34.485	34.54	2034000.0
2004-08-27 17:00:00	QQQ	ETF	34.54	34.54	34.511	34.52	44100.0
2004-08-27 18:00:00	QQQ	ETF	34.54	34.55	34.53	34.54	8000.0
2004-08-27 19:00:00	QQQ	ETF	34.53	34.56	34.53	34.56	1200.0
2004-08-27 08:00:00	IWM	ETF	54.5	54.5	54.5	54.5	12000.0
2004-08-27 09:00:00	IWM	ETF	54.575	54.83	54.575	54.8	986000.0
2004-08-27 10:00:00	IWM	ETF	54.805	54.875	54.7	54.775	1533800.0
2004-08-27 11:00:00	IWM	ETF	54.775	54.965	54.765	54.765	1013400.0
2004-08-27 12:00:00	IWM	ETF	54.77	54.82	54.715	54.77	270000.0
2004-08-27 13:00:00	IWM	ETF	54.775	54.86	54.775	54.805	228800.0
2004-08-27 14:00:00	IWM	ETF	54.79	55.125	54.79	55.08	1269200.0
2004-08-27 15:00:00	IWM	ETF	55.085	55.095	54.925	55.005	1328800.0
2004-08-27 16:00:00	IWM	ETF	54.98	55.035	54.865	54.9	418200.0
2004-08-27 08:00:00	DIA	ETF	101.8	101.89	101.79	101.88	19700.0
2004-08-27 09:00:00	DIA	ETF	101.96	101.98	101.78	101.95	697000.0
2004-08-27 10:00:00	DIA	ETF	101.93	102.12	101.89	101.98	454700.0
2004-08-27 11:00:00	DIA	ETF	101.98	102.13	101.97	101.99	171000.0
2004-08-27 12:00:00	DIA	ETF	102.0	102.05	101.95	102.05	131800.0
2004-08-27 13:00:00	DIA	ETF	102.04	102.13	102.02	102.06	146600.0
2004-08-27 14:00:00	DIA	ETF	102.07	102.25	102.07	102.23	657900.0
2004-08-27 15:00:00	DIA	ETF	102.23	102.24	102.0	102.13	485100.0
2004-08-27 16:00:00	DIA	ETF	102.16	102.23	102.05	102.19	125400.0
2004-08-27 17:00:00	DIA	ETF	102.21	102.21	102.19	102.21	800.0
2004-08-27 08:00:00	TLT	ETF	86.97	86.97	86.97	86.97	1000.0
2004-08-27 09:00:00	TLT	ETF	86.72	86.94	86.72	86.78	27400.0
2004-08-27 10:00:00	TLT	ETF	86.8	86.88	86.64	86.87	61500.0
2004-08-27 11:00:00	TLT	ETF	86.89	86.97	86.85	86.97	12400.0
2004-08-27 12:00:00	TLT	ETF	86.97	87.03	86.95	86.97	98000.0
2004-08-27 13:00:00	TLT	ETF	86.98	86.98	86.88	86.89	10400.0
2004-08-27 14:00:00	TLT	ETF	86.86	86.89	86.77	86.79	18300.0

> showing 50 of 656 rows — these rows as CSV

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