PREVIEW / etf_1hour / 2003-07-22

all etf 1-hour files

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

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-22 08:00:00	SPY	ETF	98.74	98.78	98.55	98.62	24000.0
2003-07-22 09:00:00	SPY	ETF	98.65	98.775	98.2	98.44	5088800.0
2003-07-22 10:00:00	SPY	ETF	98.43	98.66	97.91	98.1	5104000.0
2003-07-22 11:00:00	SPY	ETF	98.09	99.34	98.09	99.25	9592800.0
2003-07-22 12:00:00	SPY	ETF	99.24	99.41	99.0	99.151	4575100.0
2003-07-22 13:00:00	SPY	ETF	99.15	99.24	98.56	98.949	6750900.0
2003-07-22 14:00:00	SPY	ETF	98.93	99.35	98.88	99.33	5331800.0
2003-07-22 15:00:00	SPY	ETF	99.32	99.4	98.92	99.12	5417400.0
2003-07-22 16:00:00	SPY	ETF	99.103	99.3	98.8178	99.29	1924400.0
2003-07-22 17:00:00	SPY	ETF	99.28	99.36	99.28	99.36	649600.0
2003-07-22 18:00:00	SPY	ETF	99.36	99.42	99.36	99.42	18200.0
2003-07-22 19:00:00	SPY	ETF	99.36	99.42	99.36	99.4	1800.0
2003-07-22 08:00:00	QQQ	ETF	31.14	31.14	31.05	31.08	153600.0
2003-07-22 09:00:00	QQQ	ETF	31.07	31.15	30.91	31.1	10237600.0
2003-07-22 10:00:00	QQQ	ETF	31.09	31.18	30.86	30.96	10903200.0
2003-07-22 11:00:00	QQQ	ETF	30.96	31.5	30.92	31.42	17913900.0
2003-07-22 12:00:00	QQQ	ETF	31.42	31.46	31.29	31.33	9015200.0
2003-07-22 13:00:00	QQQ	ETF	31.33	31.38	31.1	31.286	10013500.0
2003-07-22 14:00:00	QQQ	ETF	31.29	31.43	31.22	31.37	6794900.0
2003-07-22 15:00:00	QQQ	ETF	31.37	31.44	31.22	31.307	12400100.0
2003-07-22 16:00:00	QQQ	ETF	31.3	31.45	31.28	31.37	3965900.0
2003-07-22 17:00:00	QQQ	ETF	31.4	31.45	31.27	31.42	553400.0
2003-07-22 18:00:00	QQQ	ETF	31.41	31.44	31.391	31.44	57400.0
2003-07-22 19:00:00	QQQ	ETF	31.42	31.43	31.39	31.4	27900.0
2003-07-22 09:00:00	IWM	ETF	45.86	45.88	45.71	45.81	751400.0
2003-07-22 10:00:00	IWM	ETF	45.82	45.94	45.64	45.695	785400.0
2003-07-22 11:00:00	IWM	ETF	45.72	45.985	45.56	45.985	819800.0
2003-07-22 12:00:00	IWM	ETF	45.975	46.1	45.955	46.0	203600.0
2003-07-22 13:00:00	IWM	ETF	46.0	46.01	45.884	45.955	220600.0
2003-07-22 14:00:00	IWM	ETF	45.955	46.25	45.935	46.19	238000.0
2003-07-22 15:00:00	IWM	ETF	46.23	46.35	46.095	46.24	470400.0
2003-07-22 16:00:00	IWM	ETF	46.225	46.345	46.225	46.3	45200.0
2003-07-22 08:00:00	DIA	ETF	91.4	91.5	91.31	91.31	13100.0
2003-07-22 09:00:00	DIA	ETF	91.42	91.44	90.7	90.93	720300.0
2003-07-22 10:00:00	DIA	ETF	90.94	91.06	90.45	90.64	1054800.0
2003-07-22 11:00:00	DIA	ETF	90.64	91.83	90.64	91.69	1683100.0
2003-07-22 12:00:00	DIA	ETF	91.62	91.88	91.55	91.65	1353200.0
2003-07-22 13:00:00	DIA	ETF	91.65	91.72	91.12	91.5	772900.0
2003-07-22 14:00:00	DIA	ETF	91.48	91.85	91.47	91.78	748400.0
2003-07-22 15:00:00	DIA	ETF	91.8	91.94	91.46	91.62	1008600.0
2003-07-22 16:00:00	DIA	ETF	91.6	91.77	91.56	91.72	225700.0
2003-07-22 17:00:00	DIA	ETF	91.76	91.88	91.75	91.88	2900.0
2003-07-22 19:00:00	DIA	ETF	91.99	92.0	91.85	91.85	300.0
2003-07-22 09:00:00	TLT	ETF	85.97	86.15	85.84	86.09	227200.0
2003-07-22 10:00:00	TLT	ETF	86.09	86.15	85.61	85.78	342800.0
2003-07-22 11:00:00	TLT	ETF	85.79	85.87	85.6	85.82	216800.0
2003-07-22 12:00:00	TLT	ETF	85.92	85.93	85.44	85.5	71500.0
2003-07-22 13:00:00	TLT	ETF	85.5	85.8	85.45	85.78	110300.0
2003-07-22 14:00:00	TLT	ETF	85.65	86.3	85.65	86.26	241300.0
2003-07-22 15:00:00	TLT	ETF	86.26	86.36	86.12	86.28	173300.0

> showing 50 of 414 rows — these rows as CSV

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