PREVIEW / etf_1hour / 2003-05-22

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-22.parquet
  size:    17 KB
  rows:    397

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-05-22 08:00:00	SPY	ETF	92.9	93.0	92.87	92.99	69600.0
2003-05-22 09:00:00	SPY	ETF	93.0	93.12	92.68	93.03	4740800.0
2003-05-22 10:00:00	SPY	ETF	93.04	93.79	92.93	93.51	9794500.0
2003-05-22 11:00:00	SPY	ETF	93.49	93.64	93.23	93.4	4183800.0
2003-05-22 12:00:00	SPY	ETF	93.39	93.75	93.31	93.57	2373100.0
2003-05-22 13:00:00	SPY	ETF	93.57	93.74	93.44	93.68	2878800.0
2003-05-22 14:00:00	SPY	ETF	93.68	93.77	93.36	93.7	2634400.0
2003-05-22 15:00:00	SPY	ETF	93.7	94.04	93.58	93.68	4660600.0
2003-05-22 16:00:00	SPY	ETF	93.68	93.72	93.5	93.55	1317400.0
2003-05-22 17:00:00	SPY	ETF	93.58	93.59	93.55	93.58	25000.0
2003-05-22 18:00:00	SPY	ETF	93.59	93.6	93.54	93.6	9300.0
2003-05-22 19:00:00	SPY	ETF	93.64	93.65	93.6	93.62	5500.0
2003-05-22 08:00:00	QQQ	ETF	27.73	27.78	27.72	27.77	70300.0
2003-05-22 09:00:00	QQQ	ETF	27.77	27.88	27.62	27.82	6678400.0
2003-05-22 10:00:00	QQQ	ETF	27.83	28.18	27.77	28.1	16603800.0
2003-05-22 11:00:00	QQQ	ETF	28.1	28.17	28.02	28.1	8747200.0
2003-05-22 12:00:00	QQQ	ETF	28.08	28.24	28.06	28.18	4964300.0
2003-05-22 13:00:00	QQQ	ETF	28.19	28.21	28.12	28.15	2464400.0
2003-05-22 14:00:00	QQQ	ETF	28.17	28.2	28.06	28.17	4057400.0
2003-05-22 15:00:00	QQQ	ETF	28.18	28.32	28.07	28.13	8421100.0
2003-05-22 16:00:00	QQQ	ETF	28.11	28.15	28.02	28.09	1789800.0
2003-05-22 17:00:00	QQQ	ETF	28.09	28.13	28.09	28.11	100900.0
2003-05-22 18:00:00	QQQ	ETF	28.11	28.12	28.08	28.12	40100.0
2003-05-22 19:00:00	QQQ	ETF	28.12	28.14	28.11	28.14	10700.0
2003-05-22 09:00:00	IWM	ETF	40.975	41.045	40.925	41.04	651600.0
2003-05-22 10:00:00	IWM	ETF	41.01	41.3	41.0	41.205	877800.0
2003-05-22 11:00:00	IWM	ETF	41.215	41.26	41.175	41.21	298600.0
2003-05-22 12:00:00	IWM	ETF	41.205	41.36	41.185	41.31	107000.0
2003-05-22 13:00:00	IWM	ETF	41.31	41.32	41.225	41.32	138200.0
2003-05-22 14:00:00	IWM	ETF	41.325	41.335	41.225	41.31	491400.0
2003-05-22 15:00:00	IWM	ETF	41.32	41.455	41.32	41.405	366000.0
2003-05-22 16:00:00	IWM	ETF	41.4	41.4	41.34	41.375	61200.0
2003-05-22 08:00:00	DIA	ETF	85.45	85.5	85.4	85.44	5300.0
2003-05-22 09:00:00	DIA	ETF	85.46	85.71	85.28	85.6	791800.0
2003-05-22 10:00:00	DIA	ETF	85.65	86.37	85.55	86.07	2154900.0
2003-05-22 11:00:00	DIA	ETF	86.06	86.15	85.79	85.94	811800.0
2003-05-22 12:00:00	DIA	ETF	85.9	86.27	85.84	86.1	415000.0
2003-05-22 13:00:00	DIA	ETF	86.12	86.28	86.0	86.2	339200.0
2003-05-22 14:00:00	DIA	ETF	86.26	86.3	85.91	86.15	439500.0
2003-05-22 15:00:00	DIA	ETF	86.18	86.45	86.05	86.18	940000.0
2003-05-22 16:00:00	DIA	ETF	86.17	86.2	85.99	86.04	179200.0
2003-05-22 17:00:00	DIA	ETF	86.06	86.06	86.06	86.06	500.0
2003-05-22 18:00:00	DIA	ETF	86.04	86.04	86.01	86.03	2600.0
2003-05-22 19:00:00	DIA	ETF	86.01	86.07	86.01	86.07	1400.0
2003-05-22 09:00:00	TLT	ETF	95.1	95.22	95.01	95.14	34600.0
2003-05-22 10:00:00	TLT	ETF	95.17	95.22	94.9	95.1	146400.0
2003-05-22 11:00:00	TLT	ETF	95.1	95.39	95.1	95.32	72900.0
2003-05-22 12:00:00	TLT	ETF	95.3	95.47	95.27	95.46	57300.0
2003-05-22 13:00:00	TLT	ETF	95.48	95.56	95.27	95.27	28100.0
2003-05-22 14:00:00	TLT	ETF	95.2	95.58	95.07	95.56	32100.0

> showing 50 of 397 rows — these rows as CSV

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