PREVIEW / etf_1hour / 2003-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-16.parquet
  size:    16 KB
  rows:    392

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
2003-04-16 08:00:00	SPY	ETF	90.22	90.32	90.1	90.15	93000.0
2003-04-16 09:00:00	SPY	ETF	90.07	90.08	89.36	89.62	8176800.0
2003-04-16 10:00:00	SPY	ETF	89.62	89.96	88.97	89.06	13049000.0
2003-04-16 11:00:00	SPY	ETF	89.06	89.21	88.7	88.76	4725400.0
2003-04-16 12:00:00	SPY	ETF	88.77	89.12	88.66	89.01	4456300.0
2003-04-16 13:00:00	SPY	ETF	89.01	89.01	88.79	88.9	1789000.0
2003-04-16 14:00:00	SPY	ETF	88.89	88.92	88.2	88.45	7301000.0
2003-04-16 15:00:00	SPY	ETF	88.45	88.54	88.03	88.23	6584500.0
2003-04-16 16:00:00	SPY	ETF	88.23	88.39	88.16	88.3	2117100.0
2003-04-16 17:00:00	SPY	ETF	88.31	88.33	88.25	88.32	32000.0
2003-04-16 18:00:00	SPY	ETF	88.3	88.32	88.25	88.27	6500.0
2003-04-16 19:00:00	SPY	ETF	88.24	88.25	88.2	88.25	7100.0
2003-04-16 08:00:00	QQQ	ETF	26.8	26.8	26.67	26.67	257800.0
2003-04-16 09:00:00	QQQ	ETF	26.68	26.73	26.4	26.6	15131700.0
2003-04-16 10:00:00	QQQ	ETF	26.61	26.83	26.39	26.44	17903600.0
2003-04-16 11:00:00	QQQ	ETF	26.43	26.5	26.32	26.35	7728600.0
2003-04-16 12:00:00	QQQ	ETF	26.35	26.47	26.29	26.44	4474300.0
2003-04-16 13:00:00	QQQ	ETF	26.45	26.45	26.31	26.35	3197900.0
2003-04-16 14:00:00	QQQ	ETF	26.35	26.39	26.16	26.27	7511000.0
2003-04-16 15:00:00	QQQ	ETF	26.28	26.33	26.12	26.21	6995800.0
2003-04-16 16:00:00	QQQ	ETF	26.24	26.44	26.15	26.26	1604200.0
2003-04-16 17:00:00	QQQ	ETF	26.26	26.31	26.25	26.27	449200.0
2003-04-16 18:00:00	QQQ	ETF	26.26	26.29	26.26	26.28	23700.0
2003-04-16 19:00:00	QQQ	ETF	26.28	26.28	26.24	26.24	11300.0
2003-04-16 09:00:00	IWM	ETF	38.06	38.12	37.78	37.815	333000.0
2003-04-16 10:00:00	IWM	ETF	37.85	38.02	37.745	37.81	657400.0
2003-04-16 11:00:00	IWM	ETF	37.77	37.825	37.65	37.655	206000.0
2003-04-16 12:00:00	IWM	ETF	37.68	37.825	37.635	37.79	50000.0
2003-04-16 13:00:00	IWM	ETF	37.77	37.795	37.715	37.77	93600.0
2003-04-16 14:00:00	IWM	ETF	37.765	37.775	37.53	37.65	170000.0
2003-04-16 15:00:00	IWM	ETF	37.615	37.715	37.565	37.645	407800.0
2003-04-16 16:00:00	IWM	ETF	37.61	37.65	37.525	37.525	23400.0
2003-04-16 17:00:00	IWM	ETF	37.62	37.65	37.62	37.65	2000.0
2003-04-16 08:00:00	DIA	ETF	84.8	84.89	84.7	84.75	19900.0
2003-04-16 09:00:00	DIA	ETF	84.7	84.7	83.9	84.08	1464400.0
2003-04-16 10:00:00	DIA	ETF	84.08	84.32	83.4	83.55	1701200.0
2003-04-16 11:00:00	DIA	ETF	83.54	83.7	83.27	83.32	983900.0
2003-04-16 12:00:00	DIA	ETF	83.33	83.65	83.27	83.55	590900.0
2003-04-16 13:00:00	DIA	ETF	83.55	83.55	83.25	83.35	449800.0
2003-04-16 14:00:00	DIA	ETF	83.36	83.38	82.72	82.92	1187200.0
2003-04-16 15:00:00	DIA	ETF	82.9	82.99	82.52	82.69	1915800.0
2003-04-16 16:00:00	DIA	ETF	82.68	82.78	82.62	82.71	200400.0
2003-04-16 17:00:00	DIA	ETF	82.73	82.74	82.71	82.74	3500.0
2003-04-16 18:00:00	DIA	ETF	82.72	82.85	82.72	82.75	5600.0
2003-04-16 19:00:00	DIA	ETF	82.84	82.84	82.84	82.84	100.0
2003-04-16 09:00:00	TLT	ETF	87.53	87.65	87.48	87.6	13400.0
2003-04-16 10:00:00	TLT	ETF	87.58	87.69	87.47	87.57	46400.0
2003-04-16 11:00:00	TLT	ETF	87.6	87.82	87.53	87.75	5900.0
2003-04-16 12:00:00	TLT	ETF	87.75	87.75	87.66	87.72	9400.0
2003-04-16 13:00:00	TLT	ETF	87.71	87.71	87.71	87.71	200.0

> showing 50 of 392 rows — these rows as CSV

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