PREVIEW / etf_1hour / 2003-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-30.parquet
  size:    19 KB
  rows:    476

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-10-30 08:00:00	SPY	ETF	105.28	105.97	105.26	105.83	801700.0
2003-10-30 09:00:00	SPY	ETF	105.83	105.96	105.2	105.29	6462600.0
2003-10-30 10:00:00	SPY	ETF	105.27	105.35	104.8	105.12	10016700.0
2003-10-30 11:00:00	SPY	ETF	105.12	105.28	105.0	105.09	2694500.0
2003-10-30 12:00:00	SPY	ETF	105.09	105.64	105.04	105.56	1938200.0
2003-10-30 13:00:00	SPY	ETF	105.56	105.62	105.18	105.3	2788100.0
2003-10-30 14:00:00	SPY	ETF	105.3	105.68	105.14	105.45	3028500.0
2003-10-30 15:00:00	SPY	ETF	105.45	105.47	104.87	105.09	5800100.0
2003-10-30 16:00:00	SPY	ETF	105.11	105.4538	105.05	105.41	1395400.0
2003-10-30 17:00:00	SPY	ETF	105.42	105.48	105.36	105.43	191100.0
2003-10-30 18:00:00	SPY	ETF	105.41	105.48	105.4	105.42	17500.0
2003-10-30 19:00:00	SPY	ETF	105.4	105.4	105.36	105.39	7800.0
2003-10-30 08:00:00	QQQ	ETF	35.39	35.9	35.38	35.79	2207100.0
2003-10-30 09:00:00	QQQ	ETF	35.79	35.86	35.38	35.45	16426000.0
2003-10-30 10:00:00	QQQ	ETF	35.444	35.48	35.15	35.36	18264700.0
2003-10-30 11:00:00	QQQ	ETF	35.35	35.47	35.29	35.37	7869400.0
2003-10-30 12:00:00	QQQ	ETF	35.37	35.63	35.338	35.59	8883200.0
2003-10-30 13:00:00	QQQ	ETF	35.61	35.63	35.41	35.47	6304300.0
2003-10-30 14:00:00	QQQ	ETF	35.478	35.638	35.39	35.52	6903200.0
2003-10-30 15:00:00	QQQ	ETF	35.515	35.53	35.14	35.251	13444000.0
2003-10-30 16:00:00	QQQ	ETF	35.26	35.41	35.21	35.39	2876500.0
2003-10-30 17:00:00	QQQ	ETF	35.39	35.418	34.3904	35.36	157100.0
2003-10-30 18:00:00	QQQ	ETF	35.36	35.387	35.36	35.37	51900.0
2003-10-30 19:00:00	QQQ	ETF	35.36	35.37	35.32	35.36	11400.0
2003-10-30 08:00:00	IWM	ETF	53.21	53.475	53.21	53.425	7400.0
2003-10-30 09:00:00	IWM	ETF	53.425	53.625	53.165	53.235	1789400.0
2003-10-30 10:00:00	IWM	ETF	53.295	53.295	52.86	52.965	1231200.0
2003-10-30 11:00:00	IWM	ETF	53.0	53.235	52.97	53.07	765600.0
2003-10-30 12:00:00	IWM	ETF	53.065	53.375	53.06	53.375	625800.0
2003-10-30 13:00:00	IWM	ETF	53.375	53.375	53.175	53.245	285400.0
2003-10-30 14:00:00	IWM	ETF	53.245	53.34	53.15	53.15	834000.0
2003-10-30 15:00:00	IWM	ETF	53.2	53.25	52.815	52.95	1402600.0
2003-10-30 16:00:00	IWM	ETF	52.925	53.1	52.85	53.0	835000.0
2003-10-30 17:00:00	IWM	ETF	52.625	52.625	52.625	52.625	200.0
2003-10-30 08:00:00	DIA	ETF	98.0	98.61	97.95	98.5	61200.0
2003-10-30 09:00:00	DIA	ETF	98.5	98.64	97.99	98.09	790500.0
2003-10-30 10:00:00	DIA	ETF	98.08	98.18	97.741	97.97	1484300.0
2003-10-30 11:00:00	DIA	ETF	97.96	98.16	97.91	98.04	465500.0
2003-10-30 12:00:00	DIA	ETF	98.03	98.51	98.0	98.48	504100.0
2003-10-30 13:00:00	DIA	ETF	98.49	98.492	98.15	98.26	626000.0
2003-10-30 14:00:00	DIA	ETF	98.26	98.57	98.13	98.41	893600.0
2003-10-30 15:00:00	DIA	ETF	98.41	98.41	97.92	98.0	1630800.0
2003-10-30 16:00:00	DIA	ETF	97.98	98.31	97.98	98.29	257500.0
2003-10-30 17:00:00	DIA	ETF	98.26	98.33	98.2	98.22	3200.0
2003-10-30 19:00:00	DIA	ETF	98.25	98.3	98.25	98.3	900.0
2003-10-30 09:00:00	TLT	ETF	84.0	84.17	83.92	84.07	247900.0
2003-10-30 10:00:00	TLT	ETF	84.07	84.27	84.07	84.08	37900.0
2003-10-30 11:00:00	TLT	ETF	84.04	84.16	83.86	83.9	62200.0
2003-10-30 12:00:00	TLT	ETF	83.91	84.08	83.8	83.99	52300.0
2003-10-30 13:00:00	TLT	ETF	84.09	84.24	84.09	84.14	24000.0

> showing 50 of 476 rows — these rows as CSV

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