PREVIEW / etf_1hour / 2003-04-21

all etf 1-hour files

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

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-21 08:00:00	SPY	ETF	89.67	89.7	89.48	89.66	27500.0
2003-04-21 09:00:00	SPY	ETF	89.68	90.15	89.57	90.15	4073700.0
2003-04-21 10:00:00	SPY	ETF	90.13	90.16	89.06	89.38	6268000.0
2003-04-21 11:00:00	SPY	ETF	89.38	89.75	89.23	89.74	2454600.0
2003-04-21 12:00:00	SPY	ETF	89.74	89.8	89.32	89.43	3233800.0
2003-04-21 13:00:00	SPY	ETF	89.43	89.81	89.43	89.64	1383100.0
2003-04-21 14:00:00	SPY	ETF	89.64	89.69	89.23	89.41	4393800.0
2003-04-21 15:00:00	SPY	ETF	89.46	89.74	89.29	89.5	3800300.0
2003-04-21 16:00:00	SPY	ETF	89.51	89.79	89.46	89.58	1396500.0
2003-04-21 17:00:00	SPY	ETF	89.55	89.67	89.5	89.65	21200.0
2003-04-21 18:00:00	SPY	ETF	89.63	89.69	89.62	89.68	15700.0
2003-04-21 19:00:00	SPY	ETF	89.67	89.67	89.56	89.65	2900.0
2003-04-21 08:00:00	QQQ	ETF	26.93	26.98	26.86	26.95	61800.0
2003-04-21 09:00:00	QQQ	ETF	26.96	27.1	26.8	27.08	9731000.0
2003-04-21 10:00:00	QQQ	ETF	27.08	27.1	26.62	26.76	18626100.0
2003-04-21 11:00:00	QQQ	ETF	26.77	26.96	26.7	26.95	5643200.0
2003-04-21 12:00:00	QQQ	ETF	26.95	26.98	26.75	26.79	3581000.0
2003-04-21 13:00:00	QQQ	ETF	26.79	26.9	26.77	26.88	2103800.0
2003-04-21 14:00:00	QQQ	ETF	26.86	26.95	26.75	26.85	3766300.0
2003-04-21 15:00:00	QQQ	ETF	26.85	26.94	26.78	26.88	4265700.0
2003-04-21 16:00:00	QQQ	ETF	26.88	26.95	26.86	26.88	1160800.0
2003-04-21 17:00:00	QQQ	ETF	26.9	26.9	26.85	26.87	58600.0
2003-04-21 18:00:00	QQQ	ETF	26.86	26.88	26.85	26.86	11800.0
2003-04-21 19:00:00	QQQ	ETF	26.87	26.88	26.85	26.85	9300.0
2003-04-21 09:00:00	IWM	ETF	38.24	38.42	38.155	38.42	140800.0
2003-04-21 10:00:00	IWM	ETF	38.35	38.405	38.09	38.225	479400.0
2003-04-21 11:00:00	IWM	ETF	38.225	38.335	38.2	38.335	159000.0
2003-04-21 12:00:00	IWM	ETF	38.335	38.34	38.24	38.265	235000.0
2003-04-21 13:00:00	IWM	ETF	38.27	38.375	38.27	38.315	284400.0
2003-04-21 14:00:00	IWM	ETF	38.345	38.345	38.24	38.27	214800.0
2003-04-21 15:00:00	IWM	ETF	38.25	38.375	38.25	38.35	103800.0
2003-04-21 16:00:00	IWM	ETF	38.375	38.445	38.375	38.4	22000.0
2003-04-21 08:00:00	DIA	ETF	83.43	83.5	83.38	83.47	6900.0
2003-04-21 09:00:00	DIA	ETF	83.47	84.1	83.47	84.09	973700.0
2003-04-21 10:00:00	DIA	ETF	84.1	84.1	83.11	83.38	1857700.0
2003-04-21 11:00:00	DIA	ETF	83.35	83.67	83.2	83.67	593500.0
2003-04-21 12:00:00	DIA	ETF	83.67	83.73	83.28	83.36	524900.0
2003-04-21 13:00:00	DIA	ETF	83.4	83.67	83.4	83.54	320400.0
2003-04-21 14:00:00	DIA	ETF	83.54	83.58	83.21	83.38	367000.0
2003-04-21 15:00:00	DIA	ETF	83.37	83.58	83.22	83.39	739100.0
2003-04-21 16:00:00	DIA	ETF	83.34	83.65	83.31	83.58	65800.0
2003-04-21 17:00:00	DIA	ETF	83.45	83.5	83.41	83.5	1200.0
2003-04-21 09:00:00	TLT	ETF	87.48	87.5	87.26	87.33	80500.0
2003-04-21 10:00:00	TLT	ETF	87.47	87.61	87.27	87.57	34900.0
2003-04-21 11:00:00	TLT	ETF	87.52	87.52	87.41	87.45	18200.0
2003-04-21 12:00:00	TLT	ETF	87.61	87.73	87.6	87.73	4000.0
2003-04-21 13:00:00	TLT	ETF	87.64	87.64	87.63	87.63	600.0
2003-04-21 14:00:00	TLT	ETF	87.83	87.83	87.8	87.8	5000.0
2003-04-21 15:00:00	TLT	ETF	87.8	87.8	87.8	87.8	200.0

> showing 49 of 386 rows — these rows as CSV

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