PREVIEW / etf_1hour / 2003-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-17.parquet
  size:    17 KB
  rows:    427

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-09-17 08:00:00	SPY	ETF	103.56	103.56	103.38	103.48	51400.0
2003-09-17 09:00:00	SPY	ETF	103.48	103.75	103.38	103.73	3906600.0
2003-09-17 10:00:00	SPY	ETF	103.72	103.785	103.32	103.44	3810000.0
2003-09-17 11:00:00	SPY	ETF	103.4	103.64	103.4	103.611	1634800.0
2003-09-17 12:00:00	SPY	ETF	103.63	103.76	103.51	103.685	1750300.0
2003-09-17 13:00:00	SPY	ETF	103.7	103.71	103.22	103.25	4542200.0
2003-09-17 14:00:00	SPY	ETF	103.26	103.38	103.06	103.161	6698900.0
2003-09-17 15:00:00	SPY	ETF	103.161	103.382	103.16	103.22	3259100.0
2003-09-17 16:00:00	SPY	ETF	103.22	103.38	103.21	103.29	1404800.0
2003-09-17 17:00:00	SPY	ETF	103.31	103.36	103.249	103.36	183600.0
2003-09-17 18:00:00	SPY	ETF	103.36	103.38	103.35	103.35	3800.0
2003-09-17 19:00:00	SPY	ETF	103.28	103.28	103.28	103.28	500.0
2003-09-17 08:00:00	QQQ	ETF	34.37	34.37	34.22	34.33	202900.0
2003-09-17 09:00:00	QQQ	ETF	34.32	34.49	34.28	34.43	9291000.0
2003-09-17 10:00:00	QQQ	ETF	34.425	34.501	34.26	34.29	11432700.0
2003-09-17 11:00:00	QQQ	ETF	34.29	34.43	34.28	34.4	6386700.0
2003-09-17 12:00:00	QQQ	ETF	34.43	34.48	34.35	34.43	4472600.0
2003-09-17 13:00:00	QQQ	ETF	34.42	34.43	34.1	34.13	14100600.0
2003-09-17 14:00:00	QQQ	ETF	34.13	34.24	34.03	34.14	11718600.0
2003-09-17 15:00:00	QQQ	ETF	34.14	34.27	34.11	34.171	10696200.0
2003-09-17 16:00:00	QQQ	ETF	34.17	34.26	34.17	34.25	1092000.0
2003-09-17 17:00:00	QQQ	ETF	34.25	34.28	34.1781	34.26	196600.0
2003-09-17 18:00:00	QQQ	ETF	34.25	34.27	34.24	34.24	7700.0
2003-09-17 19:00:00	QQQ	ETF	34.26	34.28	34.25	34.25	7200.0
2003-09-17 08:00:00	IWM	ETF	51.185	51.185	51.185	51.185	1800.0
2003-09-17 09:00:00	IWM	ETF	51.315	51.44	51.09	51.44	798600.0
2003-09-17 10:00:00	IWM	ETF	51.44	51.485	51.27	51.335	452600.0
2003-09-17 11:00:00	IWM	ETF	51.36	51.5	51.36	51.455	229600.0
2003-09-17 12:00:00	IWM	ETF	51.46	51.55	51.425	51.5	307400.0
2003-09-17 13:00:00	IWM	ETF	51.485	51.495	51.27	51.31	251600.0
2003-09-17 14:00:00	IWM	ETF	51.305	51.315	51.175	51.275	329800.0
2003-09-17 15:00:00	IWM	ETF	51.27	51.38	51.235	51.235	576800.0
2003-09-17 16:00:00	IWM	ETF	51.235	51.325	51.235	51.325	117600.0
2003-09-17 08:00:00	DIA	ETF	95.99	95.99	95.99	95.99	100.0
2003-09-17 09:00:00	DIA	ETF	96.09	96.24	95.87	96.23	774100.0
2003-09-17 10:00:00	DIA	ETF	96.21	96.24	95.9	96.02	707300.0
2003-09-17 11:00:00	DIA	ETF	96.0	96.17	95.96	96.14	275000.0
2003-09-17 12:00:00	DIA	ETF	96.16	96.24	96.04	96.2	250900.0
2003-09-17 13:00:00	DIA	ETF	96.2	96.21	95.86	95.87	444700.0
2003-09-17 14:00:00	DIA	ETF	95.87	95.96	95.71	95.76	662400.0
2003-09-17 15:00:00	DIA	ETF	95.75	95.98	95.74	95.86	455700.0
2003-09-17 16:00:00	DIA	ETF	95.83	95.96	95.8	95.89	91300.0
2003-09-17 19:00:00	DIA	ETF	95.9	95.9	95.9	95.9	100.0
2003-09-17 09:00:00	TLT	ETF	84.72	84.8	84.48	84.5	41300.0
2003-09-17 10:00:00	TLT	ETF	84.49	84.88	84.49	84.88	164600.0
2003-09-17 11:00:00	TLT	ETF	84.85	85.08	84.85	85.08	59500.0
2003-09-17 12:00:00	TLT	ETF	85.07	85.3	85.05	85.25	259100.0
2003-09-17 13:00:00	TLT	ETF	85.25	85.56	85.25	85.31	140100.0
2003-09-17 14:00:00	TLT	ETF	85.35	85.44	85.12	85.25	229300.0
2003-09-17 15:00:00	TLT	ETF	85.25	85.5	85.25	85.44	130800.0

> showing 50 of 427 rows — these rows as CSV

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