PREVIEW / etf_1hour / 2003-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-11.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-08-11 08:00:00	SPY	ETF	98.41	98.41	98.25	98.25	15500.0
2003-08-11 09:00:00	SPY	ETF	98.28	98.72	98.19	98.66	2648900.0
2003-08-11 10:00:00	SPY	ETF	98.66	99.04	98.49	98.72	7390100.0
2003-08-11 11:00:00	SPY	ETF	98.73	98.76	97.84	97.98	6623400.0
2003-08-11 12:00:00	SPY	ETF	98.0	98.3	97.95	98.1	2352100.0
2003-08-11 13:00:00	SPY	ETF	98.1	98.5	98.07	98.33	3845100.0
2003-08-11 14:00:00	SPY	ETF	98.31	98.47	98.16	98.24	1508000.0
2003-08-11 15:00:00	SPY	ETF	98.23	98.582	98.23	98.509	3261800.0
2003-08-11 16:00:00	SPY	ETF	98.51	98.72	98.48	98.659	1499400.0
2003-08-11 17:00:00	SPY	ETF	98.67	98.68	98.63	98.63	52200.0
2003-08-11 18:00:00	SPY	ETF	98.61	98.65	98.61	98.65	3300.0
2003-08-11 19:00:00	SPY	ETF	98.66	98.66	98.66	98.66	500.0
2003-08-11 08:00:00	QQQ	ETF	30.14	30.14	30.09	30.11	60300.0
2003-08-11 09:00:00	QQQ	ETF	30.13	30.375	30.03	30.33	8618200.0
2003-08-11 10:00:00	QQQ	ETF	30.33	30.6	30.214	30.52	17123000.0
2003-08-11 11:00:00	QQQ	ETF	30.52	30.55	30.11	30.2	10575900.0
2003-08-11 12:00:00	QQQ	ETF	30.218	30.35	30.17	30.22	4364500.0
2003-08-11 13:00:00	QQQ	ETF	30.22	30.41	30.2	30.33	5651100.0
2003-08-11 14:00:00	QQQ	ETF	30.33	30.41	30.25	30.3	3359700.0
2003-08-11 15:00:00	QQQ	ETF	30.304	30.47	30.29	30.4	7139000.0
2003-08-11 16:00:00	QQQ	ETF	30.422	30.46	30.37	30.39	1489500.0
2003-08-11 17:00:00	QQQ	ETF	30.38	30.45	30.38	30.43	30100.0
2003-08-11 18:00:00	QQQ	ETF	30.43	30.45	30.42	30.45	15500.0
2003-08-11 19:00:00	QQQ	ETF	30.47	30.48	30.47	30.48	5800.0
2003-08-11 08:00:00	IWM	ETF	45.3	45.3	45.3	45.3	600.0
2003-08-11 09:00:00	IWM	ETF	45.22	45.555	45.22	45.55	372200.0
2003-08-11 10:00:00	IWM	ETF	45.535	45.775	45.46	45.73	1601800.0
2003-08-11 11:00:00	IWM	ETF	45.755	45.77	45.51	45.54	394200.0
2003-08-11 12:00:00	IWM	ETF	45.515	45.585	45.515	45.56	68200.0
2003-08-11 13:00:00	IWM	ETF	45.56	45.725	45.56	45.695	577800.0
2003-08-11 14:00:00	IWM	ETF	45.695	45.745	45.64	45.68	218600.0
2003-08-11 15:00:00	IWM	ETF	45.685	45.8	45.685	45.795	673800.0
2003-08-11 16:00:00	IWM	ETF	45.79	45.9	45.775	45.9	253600.0
2003-08-11 08:00:00	DIA	ETF	92.21	92.23	92.04	92.04	6800.0
2003-08-11 09:00:00	DIA	ETF	92.1	92.4	91.93	92.36	595000.0
2003-08-11 10:00:00	DIA	ETF	92.34	92.66	92.24	92.42	1234800.0
2003-08-11 11:00:00	DIA	ETF	92.43	92.46	91.6	91.79	1109100.0
2003-08-11 12:00:00	DIA	ETF	91.79	92.01	91.701	91.86	635100.0
2003-08-11 13:00:00	DIA	ETF	91.85	92.16	91.85	92.034	556100.0
2003-08-11 14:00:00	DIA	ETF	92.02	92.12	91.81	91.89	270300.0
2003-08-11 15:00:00	DIA	ETF	91.921	92.363	91.921	92.33	858100.0
2003-08-11 16:00:00	DIA	ETF	92.33	92.44	92.28	92.33	111100.0
2003-08-11 17:00:00	DIA	ETF	92.43	92.43	92.31	92.31	1200.0
2003-08-11 19:00:00	DIA	ETF	92.37	92.37	92.36	92.36	1700.0
2003-08-11 09:00:00	TLT	ETF	83.55	83.57	83.21	83.21	234800.0
2003-08-11 10:00:00	TLT	ETF	83.21	83.29	82.96	83.11	134700.0
2003-08-11 11:00:00	TLT	ETF	83.13	83.41	83.11	83.34	591200.0
2003-08-11 12:00:00	TLT	ETF	83.33	83.33	83.05	83.05	10300.0
2003-08-11 13:00:00	TLT	ETF	83.05	83.1	82.95	82.95	173100.0
2003-08-11 14:00:00	TLT	ETF	82.95	83.18	82.91	83.18	75000.0

> showing 50 of 414 rows — these rows as CSV

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