PREVIEW / etf_1hour / 2003-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-10.parquet
  size:    17 KB
  rows:    418

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-10 08:00:00	SPY	ETF	100.06	100.1	99.77	99.83	86100.0
2003-07-10 09:00:00	SPY	ETF	99.83	100.04	99.66	99.74	5417300.0
2003-07-10 10:00:00	SPY	ETF	99.71	99.86	99.32	99.5	7221200.0
2003-07-10 11:00:00	SPY	ETF	99.52	99.65	99.0	99.04	8004600.0
2003-07-10 12:00:00	SPY	ETF	99.05	99.23	98.8	98.83	6412100.0
2003-07-10 13:00:00	SPY	ETF	98.85	99.06	98.75	98.96	4801300.0
2003-07-10 14:00:00	SPY	ETF	98.9	98.98	98.63	98.84	3969700.0
2003-07-10 15:00:00	SPY	ETF	98.83	99.32	98.797	99.22	6576300.0
2003-07-10 16:00:00	SPY	ETF	99.22	99.34	99.15	99.31	1890000.0
2003-07-10 17:00:00	SPY	ETF	99.31	99.33	99.18	99.18	120000.0
2003-07-10 18:00:00	SPY	ETF	99.19	99.26	99.16	99.26	11300.0
2003-07-10 19:00:00	SPY	ETF	99.3	99.33	99.25	99.3	34000.0
2003-07-10 08:00:00	QQQ	ETF	31.89	31.9	31.74	31.8	422500.0
2003-07-10 09:00:00	QQQ	ETF	31.8	31.99	31.747	31.76	11478100.0
2003-07-10 10:00:00	QQQ	ETF	31.76	31.89	31.623	31.71	16039800.0
2003-07-10 11:00:00	QQQ	ETF	31.73	31.78	31.52	31.57	11615400.0
2003-07-10 12:00:00	QQQ	ETF	31.56	31.64	31.4	31.43	12499100.0
2003-07-10 13:00:00	QQQ	ETF	31.43	31.53	31.35	31.456	10860400.0
2003-07-10 14:00:00	QQQ	ETF	31.453	31.5	31.33	31.45	9647400.0
2003-07-10 15:00:00	QQQ	ETF	31.45	31.63	31.41	31.56	13226000.0
2003-07-10 16:00:00	QQQ	ETF	31.55	31.64	31.5	31.606	4625000.0
2003-07-10 17:00:00	QQQ	ETF	31.606	31.61	31.44	31.45	1068100.0
2003-07-10 18:00:00	QQQ	ETF	31.45	31.47	31.44	31.45	46000.0
2003-07-10 19:00:00	QQQ	ETF	31.48	31.52	31.47	31.47	12700.0
2003-07-10 09:00:00	IWM	ETF	47.35	47.355	47.055	47.185	703000.0
2003-07-10 10:00:00	IWM	ETF	47.13	47.175	46.805	46.85	934800.0
2003-07-10 11:00:00	IWM	ETF	46.875	46.89	46.595	46.595	363600.0
2003-07-10 12:00:00	IWM	ETF	46.605	46.715	46.6	46.645	203400.0
2003-07-10 13:00:00	IWM	ETF	46.615	46.685	46.58	46.645	260400.0
2003-07-10 14:00:00	IWM	ETF	46.65	46.685	46.605	46.635	432200.0
2003-07-10 15:00:00	IWM	ETF	46.63	46.83	46.63	46.76	492600.0
2003-07-10 16:00:00	IWM	ETF	46.695	46.8	46.67	46.67	68800.0
2003-07-10 08:00:00	DIA	ETF	91.41	91.41	91.19	91.2	47800.0
2003-07-10 09:00:00	DIA	ETF	91.25	91.34	91.0	91.12	1198600.0
2003-07-10 10:00:00	DIA	ETF	91.04	91.18	90.71	90.86	974800.0
2003-07-10 11:00:00	DIA	ETF	90.87	90.99	90.43	90.45	608100.0
2003-07-10 12:00:00	DIA	ETF	90.46	90.6	90.2	90.25	1155700.0
2003-07-10 13:00:00	DIA	ETF	90.29	90.49	90.14	90.4	877100.0
2003-07-10 14:00:00	DIA	ETF	90.43	90.43	90.11	90.3	1128900.0
2003-07-10 15:00:00	DIA	ETF	90.31	90.68	90.21	90.6	1011500.0
2003-07-10 16:00:00	DIA	ETF	90.55	90.63	90.5	90.59	125600.0
2003-07-10 17:00:00	DIA	ETF	90.51	90.51	90.4	90.41	1000.0
2003-07-10 18:00:00	DIA	ETF	90.42	90.42	90.4	90.42	300.0
2003-07-10 19:00:00	DIA	ETF	90.57	90.59	90.57	90.59	900.0
2003-07-10 09:00:00	TLT	ETF	90.69	90.75	90.53	90.59	370800.0
2003-07-10 10:00:00	TLT	ETF	90.59	90.62	90.4	90.4	235000.0
2003-07-10 11:00:00	TLT	ETF	90.4	90.4	90.12	90.27	21600.0
2003-07-10 12:00:00	TLT	ETF	90.28	90.34	90.2	90.3	9900.0
2003-07-10 13:00:00	TLT	ETF	90.34	90.42	90.29	90.33	20800.0
2003-07-10 14:00:00	TLT	ETF	90.29	90.41	90.21	90.35	34600.0

> showing 50 of 418 rows — these rows as CSV

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