PREVIEW / etf_1hour / 2003-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-04.parquet
  size:    16 KB
  rows:    387

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-04-04 08:00:00	SPY	ETF	88.3	88.77	88.09	88.51	163400.0
2003-04-04 09:00:00	SPY	ETF	88.58	88.74	88.01	88.18	6358700.0
2003-04-04 10:00:00	SPY	ETF	88.19	88.35	87.62	87.75	8252400.0
2003-04-04 11:00:00	SPY	ETF	87.75	88.33	87.7	88.23	5379700.0
2003-04-04 12:00:00	SPY	ETF	88.22	88.25	87.75	87.99	2301000.0
2003-04-04 13:00:00	SPY	ETF	88.0	88.14	87.72	87.73	1841800.0
2003-04-04 14:00:00	SPY	ETF	87.75	88.13	87.67	87.98	2775800.0
2003-04-04 15:00:00	SPY	ETF	87.98	88.29	87.68	88.12	4685800.0
2003-04-04 16:00:00	SPY	ETF	88.11	88.29	88.1	88.26	2006700.0
2003-04-04 17:00:00	SPY	ETF	88.26	88.3	88.21	88.26	16900.0
2003-04-04 18:00:00	SPY	ETF	88.3	88.4	88.27	88.27	2700.0
2003-04-04 19:00:00	SPY	ETF	88.35	88.39	88.35	88.39	700.0
2003-04-04 08:00:00	QQQ	ETF	26.5	26.71	26.43	26.63	299000.0
2003-04-04 09:00:00	QQQ	ETF	26.63	26.7	26.28	26.32	10988600.0
2003-04-04 10:00:00	QQQ	ETF	26.32	26.4	26.05	26.12	14795000.0
2003-04-04 11:00:00	QQQ	ETF	26.11	26.29	26.07	26.22	6421700.0
2003-04-04 12:00:00	QQQ	ETF	26.23	26.24	25.98	26.08	6262400.0
2003-04-04 13:00:00	QQQ	ETF	26.08	26.13	25.97	26.0	5229500.0
2003-04-04 14:00:00	QQQ	ETF	26.0	26.16	25.98	26.1	5111200.0
2003-04-04 15:00:00	QQQ	ETF	26.1	26.21	26.0	26.11	8429500.0
2003-04-04 16:00:00	QQQ	ETF	26.12	26.16	25.97	26.06	2588900.0
2003-04-04 17:00:00	QQQ	ETF	26.06	26.11	26.05	26.06	102000.0
2003-04-04 18:00:00	QQQ	ETF	26.08	26.1	26.06	26.08	23600.0
2003-04-04 19:00:00	QQQ	ETF	26.08	26.09	26.06	26.09	16500.0
2003-04-04 09:00:00	IWM	ETF	37.54	37.655	37.5	37.52	202000.0
2003-04-04 10:00:00	IWM	ETF	37.49	37.5	37.25	37.26	367400.0
2003-04-04 11:00:00	IWM	ETF	37.25	37.4	37.225	37.395	143400.0
2003-04-04 12:00:00	IWM	ETF	37.395	37.4	37.245	37.32	219400.0
2003-04-04 13:00:00	IWM	ETF	37.32	37.345	37.265	37.265	38400.0
2003-04-04 14:00:00	IWM	ETF	37.27	37.325	37.255	37.29	30200.0
2003-04-04 15:00:00	IWM	ETF	37.28	37.3	37.165	37.265	195800.0
2003-04-04 16:00:00	IWM	ETF	37.265	37.285	37.185	37.185	151800.0
2003-04-04 08:00:00	DIA	ETF	82.95	83.36	82.85	83.17	51400.0
2003-04-04 09:00:00	DIA	ETF	83.2	83.25	82.71	82.86	1517400.0
2003-04-04 10:00:00	DIA	ETF	82.89	82.89	82.3	82.43	2046900.0
2003-04-04 11:00:00	DIA	ETF	82.42	83.02	82.38	82.98	763700.0
2003-04-04 12:00:00	DIA	ETF	82.97	82.99	82.46	82.63	365700.0
2003-04-04 13:00:00	DIA	ETF	82.65	82.79	82.41	82.45	354000.0
2003-04-04 14:00:00	DIA	ETF	82.43	82.79	82.36	82.63	576900.0
2003-04-04 15:00:00	DIA	ETF	82.64	82.97	82.34	82.87	1040500.0
2003-04-04 16:00:00	DIA	ETF	82.87	83.05	82.83	83.05	83700.0
2003-04-04 17:00:00	DIA	ETF	83.05	83.05	83.05	83.05	900.0
2003-04-04 18:00:00	DIA	ETF	83.0	83.02	83.0	83.0	800.0
2003-04-04 19:00:00	DIA	ETF	82.93	82.93	82.93	82.93	300.0
2003-04-04 09:00:00	TLT	ETF	87.06	87.06	86.88	86.98	5900.0
2003-04-04 10:00:00	TLT	ETF	87.05	87.18	87.05	87.12	36900.0
2003-04-04 11:00:00	TLT	ETF	87.13	87.14	87.06	87.08	3800.0
2003-04-04 12:00:00	TLT	ETF	87.13	87.28	87.13	87.2	8300.0
2003-04-04 13:00:00	TLT	ETF	87.21	87.3	87.21	87.29	19400.0
2003-04-04 14:00:00	TLT	ETF	87.29	87.29	87.06	87.06	9400.0

> showing 50 of 387 rows — these rows as CSV

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