PREVIEW / etf_1hour / 2003-07-23

all etf 1-hour files

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

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-23 08:00:00	SPY	ETF	99.35	99.47	99.35	99.42	12500.0
2003-07-23 09:00:00	SPY	ETF	99.45	99.45	98.54	98.6	5844400.0
2003-07-23 10:00:00	SPY	ETF	98.57	98.88	98.37	98.68	5263500.0
2003-07-23 11:00:00	SPY	ETF	98.68	98.86	98.47	98.5	2534100.0
2003-07-23 12:00:00	SPY	ETF	98.54	98.62	98.28	98.42	2437200.0
2003-07-23 13:00:00	SPY	ETF	98.44	99.0	98.39	98.94	3611100.0
2003-07-23 14:00:00	SPY	ETF	98.94	99.37	98.91	99.13	6965400.0
2003-07-23 15:00:00	SPY	ETF	99.12	99.31	98.92	99.231	3702700.0
2003-07-23 16:00:00	SPY	ETF	99.245	99.35	99.13	99.3	893800.0
2003-07-23 17:00:00	SPY	ETF	99.25	99.26	99.21	99.26	79700.0
2003-07-23 18:00:00	SPY	ETF	99.331	99.331	99.25	99.27	7200.0
2003-07-23 19:00:00	SPY	ETF	99.32	99.32	99.25	99.3	2400.0
2003-07-23 08:00:00	QQQ	ETF	31.42	31.5	31.42	31.47	89100.0
2003-07-23 09:00:00	QQQ	ETF	31.46	31.46	31.13	31.16	10679300.0
2003-07-23 10:00:00	QQQ	ETF	31.15	31.34	30.99	31.19	10647600.0
2003-07-23 11:00:00	QQQ	ETF	31.182	31.25	31.08	31.11	4356600.0
2003-07-23 12:00:00	QQQ	ETF	31.1	31.19	31.02	31.13	3238700.0
2003-07-23 13:00:00	QQQ	ETF	31.14	31.37	31.11	31.32	7803000.0
2003-07-23 14:00:00	QQQ	ETF	31.322	31.62	31.31	31.5	13245000.0
2003-07-23 15:00:00	QQQ	ETF	31.5	31.59	31.41	31.518	8146000.0
2003-07-23 16:00:00	QQQ	ETF	31.52	31.64	31.48	31.54	3663500.0
2003-07-23 17:00:00	QQQ	ETF	31.54	31.57	31.49	31.53	244100.0
2003-07-23 18:00:00	QQQ	ETF	31.53	31.53	31.49	31.49	26000.0
2003-07-23 19:00:00	QQQ	ETF	31.48	31.52	31.48	31.51	12300.0
2003-07-23 09:00:00	IWM	ETF	46.275	46.4	46.145	46.18	429200.0
2003-07-23 10:00:00	IWM	ETF	46.15	46.17	45.955	46.135	844200.0
2003-07-23 11:00:00	IWM	ETF	46.135	46.145	46.01	46.025	126000.0
2003-07-23 12:00:00	IWM	ETF	46.02	46.02	45.84	45.925	217600.0
2003-07-23 13:00:00	IWM	ETF	45.905	46.225	45.9	46.225	658800.0
2003-07-23 14:00:00	IWM	ETF	46.215	46.52	46.215	46.415	1104800.0
2003-07-23 15:00:00	IWM	ETF	46.415	46.5	46.31	46.38	233000.0
2003-07-23 16:00:00	IWM	ETF	46.455	46.605	46.435	46.605	222800.0
2003-07-23 08:00:00	DIA	ETF	91.82	92.05	91.82	92.0	17200.0
2003-07-23 09:00:00	DIA	ETF	92.0	92.02	91.25	91.27	600100.0
2003-07-23 10:00:00	DIA	ETF	91.27	91.64	91.06	91.44	1146700.0
2003-07-23 11:00:00	DIA	ETF	91.48	91.634	91.3	91.34	465300.0
2003-07-23 12:00:00	DIA	ETF	91.34	91.42	91.1	91.25	491900.0
2003-07-23 13:00:00	DIA	ETF	91.22	91.741	91.18	91.68	377100.0
2003-07-23 14:00:00	DIA	ETF	91.71	92.17	91.7	91.91	924400.0
2003-07-23 15:00:00	DIA	ETF	91.92	92.04	91.73	92.01	633200.0
2003-07-23 16:00:00	DIA	ETF	91.99	92.17	91.96	92.11	129300.0
2003-07-23 17:00:00	DIA	ETF	92.11	92.12	92.06	92.06	700.0
2003-07-23 19:00:00	DIA	ETF	92.04	92.04	92.04	92.04	2200.0
2003-07-23 09:00:00	TLT	ETF	86.8	87.05	86.7	86.99	439700.0
2003-07-23 10:00:00	TLT	ETF	87.0	87.0	86.65	86.79	296300.0
2003-07-23 11:00:00	TLT	ETF	86.74	87.0	86.43	86.87	136900.0
2003-07-23 12:00:00	TLT	ETF	86.87	87.03	86.73	86.9	51200.0
2003-07-23 13:00:00	TLT	ETF	86.88	86.88	86.55	86.7	84800.0
2003-07-23 14:00:00	TLT	ETF	86.65	86.69	86.4	86.5	88200.0
2003-07-23 15:00:00	TLT	ETF	86.5	86.72	86.5	86.63	136800.0

> showing 50 of 398 rows — these rows as CSV

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