PREVIEW / etf_1hour / 2004-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-05.parquet
  size:    25 KB
  rows:    704

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-10-05 08:00:00	SPY	ETF	113.96	113.97	113.87	113.87	61500.0
2004-10-05 09:00:00	SPY	ETF	113.85	113.9	113.74	113.82	4416000.0
2004-10-05 10:00:00	SPY	ETF	113.81	114.0	113.61	113.88	7716000.0
2004-10-05 11:00:00	SPY	ETF	113.88	113.95	113.79	113.9	3284300.0
2004-10-05 12:00:00	SPY	ETF	113.87	114.16	113.81	114.05	3450200.0
2004-10-05 13:00:00	SPY	ETF	114.05	114.09	113.79	113.79	2697900.0
2004-10-05 14:00:00	SPY	ETF	113.78	113.83	113.56	113.65	7322500.0
2004-10-05 15:00:00	SPY	ETF	113.66	113.88	113.54	113.83	5799700.0
2004-10-05 16:00:00	SPY	ETF	113.83	113.98	113.78	113.95	1036200.0
2004-10-05 17:00:00	SPY	ETF	113.93	113.93	113.85	113.86	182900.0
2004-10-05 18:00:00	SPY	ETF	113.86	113.96	113.86	113.91	60900.0
2004-10-05 19:00:00	SPY	ETF	113.98	113.98	113.98	113.98	200.0
2004-10-05 08:00:00	QQQ	ETF	36.32	36.33	36.23	36.23	150000.0
2004-10-05 09:00:00	QQQ	ETF	36.23	36.38	36.2	36.27	13987000.0
2004-10-05 10:00:00	QQQ	ETF	36.263	36.44	36.16	36.34	17408500.0
2004-10-05 11:00:00	QQQ	ETF	36.349	36.4	36.27	36.32	11656600.0
2004-10-05 12:00:00	QQQ	ETF	36.32	36.49	36.3	36.45	9784800.0
2004-10-05 13:00:00	QQQ	ETF	36.451	36.47	36.3	36.3	5844900.0
2004-10-05 14:00:00	QQQ	ETF	36.3	36.34	36.19	36.27	13345800.0
2004-10-05 15:00:00	QQQ	ETF	36.27	36.39	36.2	36.34	12532600.0
2004-10-05 16:00:00	QQQ	ETF	36.336	36.44	36.33	36.39	2965400.0
2004-10-05 17:00:00	QQQ	ETF	36.39	36.41	36.38	36.41	53800.0
2004-10-05 18:00:00	QQQ	ETF	36.41	36.41	36.39	36.39	25800.0
2004-10-05 19:00:00	QQQ	ETF	36.41	36.42	36.4	36.42	7000.0
2004-10-05 08:00:00	IWM	ETF	58.695	58.695	58.605	58.605	2000.0
2004-10-05 09:00:00	IWM	ETF	58.58	58.89	58.58	58.63	1667200.0
2004-10-05 10:00:00	IWM	ETF	58.64	58.735	58.375	58.65	2518800.0
2004-10-05 11:00:00	IWM	ETF	58.645	58.695	58.59	58.655	1795000.0
2004-10-05 12:00:00	IWM	ETF	58.65	58.805	58.61	58.735	659000.0
2004-10-05 13:00:00	IWM	ETF	58.745	58.78	58.61	58.61	445600.0
2004-10-05 14:00:00	IWM	ETF	58.61	58.615	58.46	58.545	1290200.0
2004-10-05 15:00:00	IWM	ETF	58.555	58.615	58.405	58.5	1241400.0
2004-10-05 16:00:00	IWM	ETF	58.56	58.64	58.545	58.625	206800.0
2004-10-05 18:00:00	IWM	ETF	58.585	58.585	58.585	58.585	200.0
2004-10-05 08:00:00	DIA	ETF	102.39	102.42	102.31	102.34	16600.0
2004-10-05 09:00:00	DIA	ETF	102.3	102.32	102.07	102.09	409900.0
2004-10-05 10:00:00	DIA	ETF	102.09	102.23	101.92	102.13	944500.0
2004-10-05 11:00:00	DIA	ETF	102.13	102.17	102.03	102.09	356900.0
2004-10-05 12:00:00	DIA	ETF	102.08	102.37	102.01	102.27	575100.0
2004-10-05 13:00:00	DIA	ETF	102.28	102.3	101.97	101.97	243100.0
2004-10-05 14:00:00	DIA	ETF	101.96	102.02	101.77	101.85	1067700.0
2004-10-05 15:00:00	DIA	ETF	101.85	102.03	101.73	101.93	1409000.0
2004-10-05 16:00:00	DIA	ETF	101.94	102.04	101.92	102.01	115500.0
2004-10-05 09:00:00	TLT	ETF	87.53	87.63	87.51	87.53	7700.0
2004-10-05 10:00:00	TLT	ETF	87.55	87.67	87.44	87.53	208000.0
2004-10-05 11:00:00	TLT	ETF	87.56	87.6985	87.56	87.67	61500.0
2004-10-05 12:00:00	TLT	ETF	87.67	87.67	87.42	87.48	38000.0
2004-10-05 13:00:00	TLT	ETF	87.46	87.62	87.42	87.57	15000.0
2004-10-05 14:00:00	TLT	ETF	87.63	87.63	87.52	87.55	51700.0
2004-10-05 15:00:00	TLT	ETF	87.55	87.61	87.5	87.57	82500.0

> showing 50 of 704 rows — these rows as CSV

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