PREVIEW / etf_1hour / 2003-09-16

all etf 1-hour files

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

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-16 08:00:00	SPY	ETF	102.25	102.3	102.25	102.25	12600.0
2003-09-16 09:00:00	SPY	ETF	102.22	102.66	102.17	102.61	3008100.0
2003-09-16 10:00:00	SPY	ETF	102.61	102.85	102.57	102.71	3577900.0
2003-09-16 11:00:00	SPY	ETF	102.73	102.78	102.65	102.77	1566600.0
2003-09-16 12:00:00	SPY	ETF	102.76	102.84	102.65	102.75	1348300.0
2003-09-16 13:00:00	SPY	ETF	102.76	102.93	102.75	102.82	3127900.0
2003-09-16 14:00:00	SPY	ETF	102.79	103.25	102.56	103.19	5758300.0
2003-09-16 15:00:00	SPY	ETF	103.18	103.64	103.12	103.55	11704700.0
2003-09-16 16:00:00	SPY	ETF	103.55	103.751	103.52	103.6	1317100.0
2003-09-16 17:00:00	SPY	ETF	103.6	103.62	103.5	103.62	82200.0
2003-09-16 18:00:00	SPY	ETF	103.59	103.64	103.59	103.64	26500.0
2003-09-16 19:00:00	SPY	ETF	103.62	103.63	103.57	103.6	7700.0
2003-09-16 08:00:00	QQQ	ETF	33.59	33.64	33.55	33.57	161600.0
2003-09-16 09:00:00	QQQ	ETF	33.57	33.806	33.52	33.79	12092100.0
2003-09-16 10:00:00	QQQ	ETF	33.79	33.94	33.73	33.86	12513300.0
2003-09-16 11:00:00	QQQ	ETF	33.85	33.91	33.82	33.9	4122100.0
2003-09-16 12:00:00	QQQ	ETF	33.9	33.95	33.83	33.92	7986300.0
2003-09-16 13:00:00	QQQ	ETF	33.9	34.0	33.9	33.92	4188200.0
2003-09-16 14:00:00	QQQ	ETF	33.93	34.19	33.82	34.14	14374400.0
2003-09-16 15:00:00	QQQ	ETF	34.14	34.43	34.1	34.35	17779300.0
2003-09-16 16:00:00	QQQ	ETF	34.35	34.44	33.51	34.37	6721700.0
2003-09-16 17:00:00	QQQ	ETF	34.38	34.44	34.36	34.43	109000.0
2003-09-16 18:00:00	QQQ	ETF	34.412	34.45	34.412	34.42	35200.0
2003-09-16 19:00:00	QQQ	ETF	34.43	34.45	34.43	34.44	24800.0
2003-09-16 20:00:00	QQQ	ETF	34.44	34.44	34.44	34.44	500.0
2003-09-16 09:00:00	IWM	ETF	50.725	50.955	50.71	50.955	814000.0
2003-09-16 10:00:00	IWM	ETF	50.965	51.125	50.91	51.03	489200.0
2003-09-16 11:00:00	IWM	ETF	51.04	51.06	51.005	51.06	270000.0
2003-09-16 12:00:00	IWM	ETF	51.06	51.1	51.04	51.07	185800.0
2003-09-16 13:00:00	IWM	ETF	51.075	51.115	51.045	51.06	123400.0
2003-09-16 14:00:00	IWM	ETF	51.065	51.275	50.975	51.21	748600.0
2003-09-16 15:00:00	IWM	ETF	51.21	51.45	51.15	51.42	884600.0
2003-09-16 16:00:00	IWM	ETF	51.37	51.43	51.325	51.335	182000.0
2003-09-16 08:00:00	DIA	ETF	94.97	95.0	94.97	95.0	400.0
2003-09-16 09:00:00	DIA	ETF	94.91	95.16	94.91	95.1	894200.0
2003-09-16 10:00:00	DIA	ETF	95.15	95.3	95.06	95.23	774500.0
2003-09-16 11:00:00	DIA	ETF	95.23	95.27	95.19	95.25	275400.0
2003-09-16 12:00:00	DIA	ETF	95.25	95.32	95.15	95.18	475700.0
2003-09-16 13:00:00	DIA	ETF	95.18	95.39	95.18	95.29	261400.0
2003-09-16 14:00:00	DIA	ETF	95.33	95.67	95.05	95.58	873600.0
2003-09-16 15:00:00	DIA	ETF	95.63	96.04	95.56	95.97	947300.0
2003-09-16 16:00:00	DIA	ETF	95.97	96.2	95.9	96.1	180200.0
2003-09-16 17:00:00	DIA	ETF	96.19	96.19	96.07	96.15	800.0
2003-09-16 18:00:00	DIA	ETF	96.15	96.15	96.06	96.15	1400.0
2003-09-16 19:00:00	DIA	ETF	96.08	96.08	96.05	96.05	300.0
2003-09-16 09:00:00	TLT	ETF	84.37	84.37	84.17	84.22	28100.0
2003-09-16 10:00:00	TLT	ETF	84.27	84.35	84.11	84.11	46900.0
2003-09-16 11:00:00	TLT	ETF	84.08	84.1	83.9	83.98	58000.0
2003-09-16 12:00:00	TLT	ETF	84.02	84.24	84.02	84.17	19800.0
2003-09-16 13:00:00	TLT	ETF	84.16	84.25	84.16	84.2	6700.0

> showing 50 of 419 rows — these rows as CSV

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