PREVIEW / etf_1hour / 2003-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-17.parquet
  size:    17 KB
  rows:    428

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-07-17 08:00:00	SPY	ETF	99.0	99.22	98.93	99.1	146000.0
2003-07-17 09:00:00	SPY	ETF	99.1	99.58	99.07	99.526	5295600.0
2003-07-17 10:00:00	SPY	ETF	99.54	99.58	98.71	99.02	6505100.0
2003-07-17 11:00:00	SPY	ETF	99.019	99.13	98.77	98.95	3537400.0
2003-07-17 12:00:00	SPY	ETF	98.95	99.12	98.3	98.31	9150700.0
2003-07-17 13:00:00	SPY	ETF	98.32	98.75	98.31	98.65	3997800.0
2003-07-17 14:00:00	SPY	ETF	98.64	98.72	98.17	98.22	6082700.0
2003-07-17 15:00:00	SPY	ETF	98.21	98.71	98.16	98.491	7494300.0
2003-07-17 16:00:00	SPY	ETF	98.51	98.79	98.41	98.6	2067700.0
2003-07-17 17:00:00	SPY	ETF	98.62	98.63	98.435	98.56	158800.0
2003-07-17 18:00:00	SPY	ETF	98.53	98.53	98.28	98.28	12700.0
2003-07-17 19:00:00	SPY	ETF	98.35	98.35	98.35	98.35	8800.0
2003-07-17 08:00:00	QQQ	ETF	31.6	31.69	31.6	31.69	415600.0
2003-07-17 09:00:00	QQQ	ETF	31.69	31.84	31.64	31.81	12245200.0
2003-07-17 10:00:00	QQQ	ETF	31.823	31.84	31.35	31.462	17233600.0
2003-07-17 11:00:00	QQQ	ETF	31.46	31.53	31.41	31.46	6192500.0
2003-07-17 12:00:00	QQQ	ETF	31.47	31.53	31.06	31.1	18592800.0
2003-07-17 13:00:00	QQQ	ETF	31.09	31.31	31.05	31.28	12345500.0
2003-07-17 14:00:00	QQQ	ETF	31.28	31.31	31.043	31.078	10097400.0
2003-07-17 15:00:00	QQQ	ETF	31.079	31.31	31.05	31.207	13906200.0
2003-07-17 16:00:00	QQQ	ETF	31.2	31.5	31.13	31.3	6581800.0
2003-07-17 17:00:00	QQQ	ETF	31.32	31.32	31.18	31.25	2083200.0
2003-07-17 18:00:00	QQQ	ETF	31.25	31.28	31.05	31.11	418000.0
2003-07-17 19:00:00	QQQ	ETF	31.1	31.18	31.1	31.12	14400.0
2003-07-17 09:00:00	IWM	ETF	46.885	46.94	46.765	46.89	219200.0
2003-07-17 10:00:00	IWM	ETF	46.88	46.91	46.395	46.475	635000.0
2003-07-17 11:00:00	IWM	ETF	46.46	46.5	46.3	46.315	329800.0
2003-07-17 12:00:00	IWM	ETF	46.33	46.375	46.06	46.06	1013800.0
2003-07-17 13:00:00	IWM	ETF	46.055	46.155	46.055	46.15	227000.0
2003-07-17 14:00:00	IWM	ETF	46.13	46.13	45.815	45.845	1384600.0
2003-07-17 15:00:00	IWM	ETF	45.825	45.94	45.79	45.905	2226400.0
2003-07-17 16:00:00	IWM	ETF	45.88	45.885	45.75	45.875	190600.0
2003-07-17 08:00:00	DIA	ETF	90.5	90.61	90.46	90.61	2800.0
2003-07-17 09:00:00	DIA	ETF	90.62	91.34	90.62	91.32	1435900.0
2003-07-17 10:00:00	DIA	ETF	91.32	91.34	90.63	91.03	1631000.0
2003-07-17 11:00:00	DIA	ETF	91.04	91.17	90.81	90.9	658900.0
2003-07-17 12:00:00	DIA	ETF	90.89	91.09	90.49	90.53	1161800.0
2003-07-17 13:00:00	DIA	ETF	90.5	90.9	90.5	90.77	677200.0
2003-07-17 14:00:00	DIA	ETF	90.77	90.87	90.4	90.47	674600.0
2003-07-17 15:00:00	DIA	ETF	90.48	90.88	90.39	90.72	966900.0
2003-07-17 16:00:00	DIA	ETF	90.76	91.1586	90.68	90.8	752900.0
2003-07-17 17:00:00	DIA	ETF	90.76	90.76	90.75	90.75	300.0
2003-07-17 18:00:00	DIA	ETF	90.74	90.74	90.74	90.74	100.0
2003-07-17 19:00:00	DIA	ETF	90.69	90.69	90.69	90.69	800.0
2003-07-17 09:00:00	TLT	ETF	87.33	87.45	87.18	87.45	137000.0
2003-07-17 10:00:00	TLT	ETF	87.43	87.6	87.39	87.48	86800.0
2003-07-17 11:00:00	TLT	ETF	87.4	87.5	87.31	87.36	151500.0
2003-07-17 12:00:00	TLT	ETF	87.27	88.04	87.27	88.0	192700.0
2003-07-17 13:00:00	TLT	ETF	88.03	88.04	87.65	87.75	206800.0
2003-07-17 14:00:00	TLT	ETF	87.8	87.94	87.65	87.87	35800.0

> showing 50 of 428 rows — these rows as CSV

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