PREVIEW / etf_1hour / 2003-04-17

all etf 1-hour files

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

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-17 08:00:00	SPY	ETF	88.61	88.66	88.35	88.4	132100.0
2003-04-17 09:00:00	SPY	ETF	88.46	88.67	88.19	88.37	5215500.0
2003-04-17 10:00:00	SPY	ETF	88.32	88.7	88.21	88.63	4590400.0
2003-04-17 11:00:00	SPY	ETF	88.62	88.81	88.59	88.74	3965500.0
2003-04-17 12:00:00	SPY	ETF	88.76	89.3	88.72	89.22	6274600.0
2003-04-17 13:00:00	SPY	ETF	89.24	89.5	89.09	89.5	4087600.0
2003-04-17 14:00:00	SPY	ETF	89.5	89.64	89.19	89.37	3426000.0
2003-04-17 15:00:00	SPY	ETF	89.35	89.72	89.26	89.65	5739100.0
2003-04-17 16:00:00	SPY	ETF	89.65	89.68	89.48	89.65	1869500.0
2003-04-17 17:00:00	SPY	ETF	89.62	89.62	89.49	89.51	107500.0
2003-04-17 18:00:00	SPY	ETF	89.48	89.54	89.44	89.53	8400.0
2003-04-17 19:00:00	SPY	ETF	89.55	89.65	89.55	89.63	3800.0
2003-04-17 08:00:00	QQQ	ETF	26.39	26.4	26.24	26.26	175800.0
2003-04-17 09:00:00	QQQ	ETF	26.27	26.42	26.15	26.3	6652400.0
2003-04-17 10:00:00	QQQ	ETF	26.31	26.49	26.23	26.44	8728900.0
2003-04-17 11:00:00	QQQ	ETF	26.44	26.66	26.4	26.59	7254200.0
2003-04-17 12:00:00	QQQ	ETF	26.59	26.84	26.56	26.79	12542300.0
2003-04-17 13:00:00	QQQ	ETF	26.81	26.98	26.78	26.91	11248600.0
2003-04-17 14:00:00	QQQ	ETF	26.92	26.98	26.73	26.85	7294300.0
2003-04-17 15:00:00	QQQ	ETF	26.85	26.95	26.8	26.91	7726000.0
2003-04-17 16:00:00	QQQ	ETF	26.91	26.96	26.82	26.94	2500900.0
2003-04-17 17:00:00	QQQ	ETF	26.95	26.98	26.9	26.93	101100.0
2003-04-17 18:00:00	QQQ	ETF	26.94	26.98	26.93	26.95	46100.0
2003-04-17 19:00:00	QQQ	ETF	26.95	27.02	26.95	26.99	53300.0
2003-04-17 09:00:00	IWM	ETF	37.685	37.875	37.625	37.76	558800.0
2003-04-17 10:00:00	IWM	ETF	37.8	37.95	37.73	37.825	1383000.0
2003-04-17 11:00:00	IWM	ETF	37.925	38.005	37.825	38.005	497800.0
2003-04-17 12:00:00	IWM	ETF	38.005	38.175	38.005	38.12	320800.0
2003-04-17 13:00:00	IWM	ETF	38.12	38.215	38.05	38.15	216800.0
2003-04-17 14:00:00	IWM	ETF	38.18	38.21	38.025	38.14	117400.0
2003-04-17 15:00:00	IWM	ETF	38.175	38.275	38.06	38.215	290200.0
2003-04-17 16:00:00	IWM	ETF	38.215	38.215	37.905	37.905	12000.0
2003-04-17 08:00:00	DIA	ETF	82.96	82.96	82.58	82.71	4200.0
2003-04-17 09:00:00	DIA	ETF	82.7	82.94	82.42	82.6	1666400.0
2003-04-17 10:00:00	DIA	ETF	82.62	82.84	82.46	82.58	1109700.0
2003-04-17 11:00:00	DIA	ETF	82.58	82.77	82.52	82.63	528900.0
2003-04-17 12:00:00	DIA	ETF	82.62	83.17	82.59	83.1	1331700.0
2003-04-17 13:00:00	DIA	ETF	83.1	83.38	82.95	83.25	815400.0
2003-04-17 14:00:00	DIA	ETF	83.25	83.33	83.05	83.22	845200.0
2003-04-17 15:00:00	DIA	ETF	83.2	83.58	83.15	83.51	1261500.0
2003-04-17 16:00:00	DIA	ETF	83.5	83.55	83.34	83.4	149100.0
2003-04-17 17:00:00	DIA	ETF	83.38	83.44	83.37	83.37	12000.0
2003-04-17 18:00:00	DIA	ETF	83.33	83.45	83.33	83.45	3200.0
2003-04-17 19:00:00	DIA	ETF	83.48	83.59	83.48	83.59	2000.0
2003-04-17 09:00:00	TLT	ETF	88.24	88.4	88.23	88.4	14600.0
2003-04-17 10:00:00	TLT	ETF	88.26	88.33	88.19	88.2	43600.0
2003-04-17 11:00:00	TLT	ETF	88.2	88.25	88.12	88.19	4800.0
2003-04-17 12:00:00	TLT	ETF	88.19	88.19	87.91	87.99	7100.0
2003-04-17 13:00:00	TLT	ETF	87.95	87.99	87.95	87.99	200.0
2003-04-17 14:00:00	TLT	ETF	88.0	88.04	87.91	87.95	11500.0

> showing 50 of 379 rows — these rows as CSV

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