PREVIEW / etf_1hour / 2003-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-05.parquet
  size:    17 KB
  rows:    434

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-06-05 08:00:00	SPY	ETF	99.08	99.1	98.61	98.63	166900.0
2003-06-05 09:00:00	SPY	ETF	98.62	98.93	98.27	98.79	8012500.0
2003-06-05 10:00:00	SPY	ETF	98.75	99.13	98.41	98.8	8335200.0
2003-06-05 11:00:00	SPY	ETF	98.8	99.04	98.67	98.93	2915600.0
2003-06-05 12:00:00	SPY	ETF	98.95	99.49	98.86	99.31	5739100.0
2003-06-05 13:00:00	SPY	ETF	99.31	99.45	98.89	98.99	3791900.0
2003-06-05 14:00:00	SPY	ETF	98.99	99.39	98.76	99.35	3609800.0
2003-06-05 15:00:00	SPY	ETF	99.36	99.59	99.12	99.53	6579000.0
2003-06-05 16:00:00	SPY	ETF	99.52	99.65	99.3	99.55	2569200.0
2003-06-05 17:00:00	SPY	ETF	99.58	99.85	99.55	99.85	74200.0
2003-06-05 18:00:00	SPY	ETF	99.87	100.0	99.84	99.97	95700.0
2003-06-05 19:00:00	SPY	ETF	99.99	100.0	99.9	99.9	20300.0
2003-06-05 08:00:00	QQQ	ETF	30.38	30.38	30.22	30.23	156900.0
2003-06-05 09:00:00	QQQ	ETF	30.23	30.24	29.97	30.17	17520700.0
2003-06-05 10:00:00	QQQ	ETF	30.17	30.38	30.03	30.24	15211500.0
2003-06-05 11:00:00	QQQ	ETF	30.24	30.3	30.13	30.26	8111200.0
2003-06-05 12:00:00	QQQ	ETF	30.26	30.55	30.24	30.46	10475800.0
2003-06-05 13:00:00	QQQ	ETF	30.45	30.5	30.27	30.32	5474000.0
2003-06-05 14:00:00	QQQ	ETF	30.32	30.57	30.21	30.57	6815100.0
2003-06-05 15:00:00	QQQ	ETF	30.55	30.64	30.42	30.61	13025400.0
2003-06-05 16:00:00	QQQ	ETF	30.58	30.69	30.48	30.62	3588100.0
2003-06-05 17:00:00	QQQ	ETF	30.6	30.75	30.59	30.75	272900.0
2003-06-05 18:00:00	QQQ	ETF	30.75	30.88	30.72	30.86	584900.0
2003-06-05 19:00:00	QQQ	ETF	30.87	30.88	30.83	30.83	36800.0
2003-06-05 20:00:00	QQQ	ETF	30.85	30.85	30.85	30.85	1600.0
2003-06-05 09:00:00	IWM	ETF	44.825	44.895	44.67	44.84	431200.0
2003-06-05 10:00:00	IWM	ETF	44.85	45.205	44.74	45.08	439400.0
2003-06-05 11:00:00	IWM	ETF	45.11	45.21	45.075	45.19	251000.0
2003-06-05 12:00:00	IWM	ETF	45.19	45.525	45.155	45.495	243000.0
2003-06-05 13:00:00	IWM	ETF	45.495	45.505	45.365	45.37	470600.0
2003-06-05 14:00:00	IWM	ETF	45.37	45.5	45.3	45.495	259600.0
2003-06-05 15:00:00	IWM	ETF	45.5	45.62	45.46	45.55	568200.0
2003-06-05 16:00:00	IWM	ETF	45.56	45.725	45.56	45.725	9400.0
2003-06-05 08:00:00	DIA	ETF	90.55	90.58	90.26	90.26	7200.0
2003-06-05 09:00:00	DIA	ETF	90.23	90.35	89.94	90.26	1159300.0
2003-06-05 10:00:00	DIA	ETF	90.22	90.48	89.94	90.22	1562000.0
2003-06-05 11:00:00	DIA	ETF	90.21	90.35	90.07	90.3	815500.0
2003-06-05 12:00:00	DIA	ETF	90.31	90.77	90.24	90.64	812300.0
2003-06-05 13:00:00	DIA	ETF	90.64	90.72	90.19	90.27	714100.0
2003-06-05 14:00:00	DIA	ETF	90.29	90.57	90.07	90.53	568000.0
2003-06-05 15:00:00	DIA	ETF	90.51	90.76	90.37	90.7	1099900.0
2003-06-05 16:00:00	DIA	ETF	90.65	90.78	90.63	90.76	339900.0
2003-06-05 17:00:00	DIA	ETF	90.72	90.76	90.67	90.75	6100.0
2003-06-05 18:00:00	DIA	ETF	90.88	91.08	90.8	91.08	32600.0
2003-06-05 19:00:00	DIA	ETF	91.2	91.37	91.08	91.08	6400.0
2003-06-05 09:00:00	TLT	ETF	95.2	95.38	95.0	95.02	282000.0
2003-06-05 10:00:00	TLT	ETF	95.05	95.27	94.9	95.06	44600.0
2003-06-05 11:00:00	TLT	ETF	95.09	95.16	94.94	95.11	25900.0
2003-06-05 12:00:00	TLT	ETF	95.19	95.24	94.78	94.89	78600.0
2003-06-05 13:00:00	TLT	ETF	94.78	94.78	93.95	94.07	107800.0

> showing 50 of 434 rows — these rows as CSV

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