PREVIEW / etf_1hour / 2003-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-06.parquet
  size:    17 KB
  rows:    445

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-10-06 08:00:00	SPY	ETF	103.54	103.55	103.45	103.5	30300.0
2003-10-06 09:00:00	SPY	ETF	103.5	103.54	103.22	103.44	2273800.0
2003-10-06 10:00:00	SPY	ETF	103.44	103.66	103.2	103.35	2830700.0
2003-10-06 11:00:00	SPY	ETF	103.35	103.6	103.32	103.54	1457600.0
2003-10-06 12:00:00	SPY	ETF	103.54	103.88	103.5	103.74	1913200.0
2003-10-06 13:00:00	SPY	ETF	103.74	103.85	103.66	103.8	1256000.0
2003-10-06 14:00:00	SPY	ETF	103.81	103.99	103.7	103.71	1753000.0
2003-10-06 15:00:00	SPY	ETF	103.72	103.84	103.58	103.722	2146200.0
2003-10-06 16:00:00	SPY	ETF	103.714	103.93	103.7	103.93	520500.0
2003-10-06 17:00:00	SPY	ETF	103.95	103.99	103.92	103.99	9400.0
2003-10-06 18:00:00	SPY	ETF	103.96	103.96	103.92	103.92	11600.0
2003-10-06 19:00:00	SPY	ETF	103.92	103.95	103.92	103.92	4000.0
2003-10-06 08:00:00	QQQ	ETF	34.38	34.39	34.32	34.33	173500.0
2003-10-06 09:00:00	QQQ	ETF	34.33	34.35	34.06	34.22	10900800.0
2003-10-06 10:00:00	QQQ	ETF	34.216	34.35	34.08	34.17	8872800.0
2003-10-06 11:00:00	QQQ	ETF	34.175	34.28	34.14	34.27	3420000.0
2003-10-06 12:00:00	QQQ	ETF	34.27	34.401	34.25	34.29	4546800.0
2003-10-06 13:00:00	QQQ	ETF	34.31	34.39	34.23	34.3	3734500.0
2003-10-06 14:00:00	QQQ	ETF	34.31	34.408	34.25	34.26	4042500.0
2003-10-06 15:00:00	QQQ	ETF	34.25	34.37	34.24	34.34	5643900.0
2003-10-06 16:00:00	QQQ	ETF	34.341	34.47	34.32	34.44	1382600.0
2003-10-06 17:00:00	QQQ	ETF	34.45	34.5	34.27	34.46	116300.0
2003-10-06 18:00:00	QQQ	ETF	34.46	34.47	34.45	34.47	43800.0
2003-10-06 19:00:00	QQQ	ETF	34.45	34.48	34.45	34.47	18700.0
2003-10-06 09:00:00	IWM	ETF	51.1	51.28	50.9	51.155	325200.0
2003-10-06 10:00:00	IWM	ETF	51.16	51.36	51.145	51.3	545600.0
2003-10-06 11:00:00	IWM	ETF	51.315	51.4	51.29	51.36	289000.0
2003-10-06 12:00:00	IWM	ETF	51.35	51.475	51.33	51.395	263400.0
2003-10-06 13:00:00	IWM	ETF	51.38	51.445	51.31	51.355	184600.0
2003-10-06 14:00:00	IWM	ETF	51.37	51.47	51.36	51.36	175600.0
2003-10-06 15:00:00	IWM	ETF	51.375	51.54	51.33	51.515	521600.0
2003-10-06 16:00:00	IWM	ETF	51.51	51.6	51.325	51.52	202800.0
2003-10-06 17:00:00	IWM	ETF	51.55	51.55	51.55	51.55	216000.0
2003-10-06 18:00:00	IWM	ETF	51.55	51.55	51.5	51.5	600.0
2003-10-06 08:00:00	DIA	ETF	96.04	96.04	96.01	96.02	1100.0
2003-10-06 09:00:00	DIA	ETF	96.06	96.08	95.77	95.89	451600.0
2003-10-06 10:00:00	DIA	ETF	95.88	96.14	95.83	95.96	579700.0
2003-10-06 11:00:00	DIA	ETF	95.956	96.1	95.92	96.06	164400.0
2003-10-06 12:00:00	DIA	ETF	96.05	96.38	96.01	96.27	313900.0
2003-10-06 13:00:00	DIA	ETF	96.27	96.32	96.15	96.27	244800.0
2003-10-06 14:00:00	DIA	ETF	96.27	96.44	96.1	96.12	836900.0
2003-10-06 15:00:00	DIA	ETF	96.13	96.25	96.0	96.06	531100.0
2003-10-06 16:00:00	DIA	ETF	96.05	96.26	96.049	96.26	59300.0
2003-10-06 17:00:00	DIA	ETF	96.3	96.3	96.3	96.3	400.0
2003-10-06 18:00:00	DIA	ETF	96.14	96.14	96.14	96.14	300.0
2003-10-06 19:00:00	DIA	ETF	96.28	96.28	96.25	96.25	300.0
2003-10-06 09:00:00	TLT	ETF	85.12	85.35	85.08	85.31	19900.0
2003-10-06 10:00:00	TLT	ETF	85.35	85.5	85.29	85.36	188200.0
2003-10-06 11:00:00	TLT	ETF	85.37	85.39	85.35	85.38	1300.0
2003-10-06 12:00:00	TLT	ETF	85.4	85.48	85.35	85.48	19200.0

> showing 50 of 445 rows — these rows as CSV

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