PREVIEW / etf_1hour / 2003-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-08.parquet
  size:    16 KB
  rows:    378

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-01-08 08:00:00	SPY	ETF	92.35	92.4	92.18	92.22	27400.0
2003-01-08 09:00:00	SPY	ETF	92.2	92.28	91.72	91.79	5017600.0
2003-01-08 10:00:00	SPY	ETF	91.8	92.13	91.7	91.93	4461800.0
2003-01-08 11:00:00	SPY	ETF	91.94	92.4	91.87	91.94	3836200.0
2003-01-08 12:00:00	SPY	ETF	91.93	91.97	91.52	91.7	4267500.0
2003-01-08 13:00:00	SPY	ETF	91.7	91.81	91.37	91.53	3936800.0
2003-01-08 14:00:00	SPY	ETF	91.54	91.64	91.17	91.21	5041800.0
2003-01-08 15:00:00	SPY	ETF	91.2	91.43	91.05	91.22	6892600.0
2003-01-08 16:00:00	SPY	ETF	91.17	91.44	91.16	91.43	1715900.0
2003-01-08 17:00:00	SPY	ETF	91.41	91.48	91.4	91.41	125500.0
2003-01-08 18:00:00	SPY	ETF	91.45	91.47	91.41	91.45	30300.0
2003-01-08 08:00:00	QQQ	ETF	26.51	26.52	26.38	26.4	68900.0
2003-01-08 09:00:00	QQQ	ETF	26.41	26.49	26.26	26.28	12861600.0
2003-01-08 10:00:00	QQQ	ETF	26.3	26.39	26.18	26.22	10421300.0
2003-01-08 11:00:00	QQQ	ETF	26.24	26.33	26.05	26.11	8197800.0
2003-01-08 12:00:00	QQQ	ETF	26.09	26.12	25.92	25.99	8147900.0
2003-01-08 13:00:00	QQQ	ETF	25.99	26.08	25.89	26.02	9061900.0
2003-01-08 14:00:00	QQQ	ETF	26.04	26.12	25.92	25.96	8532100.0
2003-01-08 15:00:00	QQQ	ETF	25.95	26.02	25.84	25.91	9255100.0
2003-01-08 16:00:00	QQQ	ETF	25.91	26.02	25.86	25.98	2895900.0
2003-01-08 17:00:00	QQQ	ETF	26.0	26.04	25.98	26.03	209500.0
2003-01-08 18:00:00	QQQ	ETF	26.01	26.04	25.98	26.04	45900.0
2003-01-08 19:00:00	QQQ	ETF	26.05	26.05	26.01	26.04	10600.0
2003-01-08 09:00:00	IWM	ETF	38.95	39.0	38.685	38.695	440600.0
2003-01-08 10:00:00	IWM	ETF	38.75	38.85	38.675	38.76	312600.0
2003-01-08 11:00:00	IWM	ETF	38.815	39.015	38.765	38.8	426600.0
2003-01-08 12:00:00	IWM	ETF	38.82	38.835	38.715	38.81	195800.0
2003-01-08 13:00:00	IWM	ETF	38.8	38.83	38.69	38.81	529600.0
2003-01-08 14:00:00	IWM	ETF	38.775	38.84	38.6	38.645	502600.0
2003-01-08 15:00:00	IWM	ETF	38.645	38.775	38.625	38.73	549200.0
2003-01-08 16:00:00	IWM	ETF	38.625	38.76	38.625	38.745	155400.0
2003-01-08 08:00:00	DIA	ETF	87.4	87.4	87.23	87.23	10000.0
2003-01-08 09:00:00	DIA	ETF	87.22	87.22	86.71	86.72	1666500.0
2003-01-08 10:00:00	DIA	ETF	86.75	87.02	86.67	86.81	917100.0
2003-01-08 11:00:00	DIA	ETF	86.85	87.14	86.78	86.82	1420800.0
2003-01-08 12:00:00	DIA	ETF	86.81	86.82	86.4	86.55	1154700.0
2003-01-08 13:00:00	DIA	ETF	86.5	86.64	86.23	86.37	741200.0
2003-01-08 14:00:00	DIA	ETF	86.37	86.43	86.02	86.05	1033200.0
2003-01-08 15:00:00	DIA	ETF	86.05	86.25	85.91	86.09	1188300.0
2003-01-08 16:00:00	DIA	ETF	86.08	86.29	86.0	86.2	63600.0
2003-01-08 17:00:00	DIA	ETF	86.22	86.24	86.19	86.22	1900.0
2003-01-08 09:00:00	TLT	ETF	86.88	86.92	86.78	86.92	5700.0
2003-01-08 10:00:00	TLT	ETF	86.98	87.0	86.86	86.86	3300.0
2003-01-08 11:00:00	TLT	ETF	86.89	86.94	86.85	86.85	26300.0
2003-01-08 12:00:00	TLT	ETF	87.0	87.05	86.98	87.05	63800.0
2003-01-08 13:00:00	TLT	ETF	87.0	87.14	86.96	87.06	32300.0
2003-01-08 14:00:00	TLT	ETF	87.06	87.14	86.98	87.0	14300.0
2003-01-08 15:00:00	TLT	ETF	86.96	87.0	86.92	86.94	5400.0
2003-01-08 16:00:00	TLT	ETF	86.99	86.99	86.99	86.99	4500.0

> showing 49 of 378 rows — these rows as CSV

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