PREVIEW / etf_1hour / 2003-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-21.parquet
  size:    17 KB
  rows:    432

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-08-21 08:00:00	SPY	ETF	101.01	101.12	100.97	101.03	76500.0
2003-08-21 09:00:00	SPY	ETF	101.03	101.48	100.79	101.42	3558100.0
2003-08-21 10:00:00	SPY	ETF	101.45	101.52	101.13	101.39	4124900.0
2003-08-21 11:00:00	SPY	ETF	101.37	101.39	100.4	100.65	11420500.0
2003-08-21 12:00:00	SPY	ETF	100.65	101.24	100.62	100.74	8935000.0
2003-08-21 13:00:00	SPY	ETF	100.74	100.99	100.62	100.94	2079600.0
2003-08-21 14:00:00	SPY	ETF	100.94	100.98	100.54	100.72	3218600.0
2003-08-21 15:00:00	SPY	ETF	100.72	101.06	100.65	100.87	3636300.0
2003-08-21 16:00:00	SPY	ETF	100.89	100.94	100.71	100.84	1312100.0
2003-08-21 17:00:00	SPY	ETF	100.783	100.84	100.76	100.77	41500.0
2003-08-21 18:00:00	SPY	ETF	100.75	100.77	100.74	100.77	10300.0
2003-08-21 19:00:00	SPY	ETF	100.75	100.76	100.72	100.72	2800.0
2003-08-21 08:00:00	QQQ	ETF	32.55	32.64	32.53	32.58	200200.0
2003-08-21 09:00:00	QQQ	ETF	32.59	32.73	32.48	32.715	9382000.0
2003-08-21 10:00:00	QQQ	ETF	32.71	32.82	32.559	32.73	11402000.0
2003-08-21 11:00:00	QQQ	ETF	32.71	32.75	32.27	32.43	15010400.0
2003-08-21 12:00:00	QQQ	ETF	32.45	32.65	32.42	32.451	12038800.0
2003-08-21 13:00:00	QQQ	ETF	32.47	32.62	32.41	32.56	5348500.0
2003-08-21 14:00:00	QQQ	ETF	32.578	32.6	32.48	32.57	5299600.0
2003-08-21 15:00:00	QQQ	ETF	32.56	32.73	32.53	32.68	9671500.0
2003-08-21 16:00:00	QQQ	ETF	32.674	32.7	32.573	32.66	1773500.0
2003-08-21 17:00:00	QQQ	ETF	32.65	32.67	32.62	32.646	83900.0
2003-08-21 18:00:00	QQQ	ETF	32.64	32.66	32.63	32.66	17000.0
2003-08-21 19:00:00	QQQ	ETF	32.66	32.68	32.64	32.64	13700.0
2003-08-21 09:00:00	IWM	ETF	49.2	49.35	49.05	49.34	266800.0
2003-08-21 10:00:00	IWM	ETF	49.37	49.4	49.29	49.35	993000.0
2003-08-21 11:00:00	IWM	ETF	49.35	49.355	49.11	49.125	536400.0
2003-08-21 12:00:00	IWM	ETF	49.105	49.32	49.105	49.235	228800.0
2003-08-21 13:00:00	IWM	ETF	49.21	49.4	49.2	49.38	216400.0
2003-08-21 14:00:00	IWM	ETF	49.385	49.385	49.265	49.315	775400.0
2003-08-21 15:00:00	IWM	ETF	49.315	49.375	49.245	49.375	1012200.0
2003-08-21 16:00:00	IWM	ETF	49.325	49.385	49.24	49.33	207400.0
2003-08-21 17:00:00	IWM	ETF	49.33	49.33	49.33	49.33	1000.0
2003-08-21 08:00:00	DIA	ETF	94.62	94.73	94.55	94.6	6800.0
2003-08-21 09:00:00	DIA	ETF	94.58	95.05	94.36	94.99	775300.0
2003-08-21 10:00:00	DIA	ETF	95.01	95.04	94.71	94.94	1096300.0
2003-08-21 11:00:00	DIA	ETF	94.94	94.96	94.1	94.29	1394200.0
2003-08-21 12:00:00	DIA	ETF	94.29	94.85	94.27	94.48	1185500.0
2003-08-21 13:00:00	DIA	ETF	94.46	94.66	94.4	94.6	260400.0
2003-08-21 14:00:00	DIA	ETF	94.63	94.65	94.24	94.44	545900.0
2003-08-21 15:00:00	DIA	ETF	94.45	94.74	94.36	94.45	847600.0
2003-08-21 16:00:00	DIA	ETF	94.48	94.53	94.32	94.48	175900.0
2003-08-21 18:00:00	DIA	ETF	94.37	94.37	94.37	94.37	100.0
2003-08-21 09:00:00	TLT	ETF	83.06	83.07	82.91	83.0	15600.0
2003-08-21 10:00:00	TLT	ETF	83.08	83.45	83.0	83.05	113500.0
2003-08-21 11:00:00	TLT	ETF	83.1	83.24	82.95	83.16	54300.0
2003-08-21 12:00:00	TLT	ETF	83.1	83.1	82.52	82.8	249600.0
2003-08-21 13:00:00	TLT	ETF	82.71	82.93	82.42	82.6	235700.0
2003-08-21 14:00:00	TLT	ETF	82.6	82.83	82.51	82.8	27600.0
2003-08-21 15:00:00	TLT	ETF	82.77	82.92	82.62	82.92	30200.0

> showing 50 of 432 rows — these rows as CSV

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