PREVIEW / etf_1hour / 2003-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-03.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-06-03 08:00:00	SPY	ETF	97.07	97.33	97.07	97.3	79200.0
2003-06-03 09:00:00	SPY	ETF	97.25	97.51	96.85	97.42	5973700.0
2003-06-03 10:00:00	SPY	ETF	97.47	97.69	97.07	97.47	5641300.0
2003-06-03 11:00:00	SPY	ETF	97.46	97.84	97.27	97.66	3897600.0
2003-06-03 12:00:00	SPY	ETF	97.67	97.74	97.18	97.32	2327300.0
2003-06-03 13:00:00	SPY	ETF	97.33	97.42	96.92	97.06	3175200.0
2003-06-03 14:00:00	SPY	ETF	97.07	97.42	96.94	97.35	3143500.0
2003-06-03 15:00:00	SPY	ETF	97.35	97.7	97.13	97.68	3438400.0
2003-06-03 16:00:00	SPY	ETF	97.7	97.81	97.4	97.81	2811900.0
2003-06-03 17:00:00	SPY	ETF	97.81	97.82	97.75	97.75	6700.0
2003-06-03 18:00:00	SPY	ETF	97.77	97.93	97.77	97.93	5300.0
2003-06-03 19:00:00	SPY	ETF	97.85	97.9	97.82	97.9	1900.0
2003-06-03 08:00:00	QQQ	ETF	29.44	29.53	29.41	29.49	83200.0
2003-06-03 09:00:00	QQQ	ETF	29.48	29.59	29.33	29.56	12435400.0
2003-06-03 10:00:00	QQQ	ETF	29.55	29.68	29.39	29.6	16712000.0
2003-06-03 11:00:00	QQQ	ETF	29.6	29.84	29.51	29.75	11475500.0
2003-06-03 12:00:00	QQQ	ETF	29.75	29.77	29.54	29.6	5570600.0
2003-06-03 13:00:00	QQQ	ETF	29.6	29.65	29.43	29.55	7850200.0
2003-06-03 14:00:00	QQQ	ETF	29.55	29.69	29.5	29.67	6701900.0
2003-06-03 15:00:00	QQQ	ETF	29.67	29.83	29.58	29.81	8190400.0
2003-06-03 16:00:00	QQQ	ETF	29.81	29.88	29.79	29.88	1853100.0
2003-06-03 17:00:00	QQQ	ETF	29.86	29.88	29.82	29.84	337500.0
2003-06-03 18:00:00	QQQ	ETF	29.85	29.93	29.84	29.91	56400.0
2003-06-03 19:00:00	QQQ	ETF	29.92	29.98	29.9	29.93	24100.0
2003-06-03 09:00:00	IWM	ETF	44.21	44.225	44.0	44.175	294400.0
2003-06-03 10:00:00	IWM	ETF	44.185	44.24	44.075	44.165	489600.0
2003-06-03 11:00:00	IWM	ETF	44.175	44.325	44.16	44.325	425400.0
2003-06-03 12:00:00	IWM	ETF	44.32	44.32	44.115	44.12	227800.0
2003-06-03 13:00:00	IWM	ETF	44.125	44.16	44.015	44.025	233800.0
2003-06-03 14:00:00	IWM	ETF	44.05	44.17	44.01	44.145	131000.0
2003-06-03 15:00:00	IWM	ETF	44.16	44.38	44.135	44.38	377600.0
2003-06-03 16:00:00	IWM	ETF	44.41	44.41	44.31	44.325	29200.0
2003-06-03 08:00:00	DIA	ETF	89.03	89.21	89.03	89.2	2600.0
2003-06-03 09:00:00	DIA	ETF	89.2	89.43	88.8	89.35	1667000.0
2003-06-03 10:00:00	DIA	ETF	89.29	89.53	88.96	89.28	1653200.0
2003-06-03 11:00:00	DIA	ETF	89.25	89.69	89.12	89.53	819400.0
2003-06-03 12:00:00	DIA	ETF	89.53	89.55	89.1	89.25	523000.0
2003-06-03 13:00:00	DIA	ETF	89.23	89.32	88.91	89.05	954200.0
2003-06-03 14:00:00	DIA	ETF	89.05	89.27	88.89	89.21	624100.0
2003-06-03 15:00:00	DIA	ETF	89.22	89.53	89.03	89.5	956400.0
2003-06-03 16:00:00	DIA	ETF	89.48	89.64	89.46	89.62	88000.0
2003-06-03 17:00:00	DIA	ETF	89.62	89.66	89.62	89.63	5100.0
2003-06-03 18:00:00	DIA	ETF	89.7	89.7	89.69	89.7	1800.0
2003-06-03 19:00:00	DIA	ETF	89.65	89.65	89.65	89.65	100.0
2003-06-03 09:00:00	TLT	ETF	93.76	94.5	93.71	94.3	158800.0
2003-06-03 10:00:00	TLT	ETF	94.27	94.28	94.1	94.26	76400.0
2003-06-03 11:00:00	TLT	ETF	94.15	94.2	94.02	94.1	15400.0
2003-06-03 12:00:00	TLT	ETF	94.13	94.41	94.13	94.31	31100.0
2003-06-03 13:00:00	TLT	ETF	94.35	94.58	94.35	94.55	56000.0
2003-06-03 14:00:00	TLT	ETF	94.41	94.46	94.35	94.35	1700.0

> showing 50 of 419 rows — these rows as CSV

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