PREVIEW / etf_1hour / 2003-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-25.parquet
  size:    19 KB
  rows:    478

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-11-25 08:00:00	SPY	ETF	105.84	106.05	105.65	105.7	110200.0
2003-11-25 09:00:00	SPY	ETF	105.69	105.93	105.45	105.851	5004900.0
2003-11-25 10:00:00	SPY	ETF	105.85	106.02	105.5	106.0	7247600.0
2003-11-25 11:00:00	SPY	ETF	105.99	106.11	105.75	105.81	2932500.0
2003-11-25 12:00:00	SPY	ETF	105.8	105.98	105.77	105.88	2990300.0
2003-11-25 13:00:00	SPY	ETF	105.87	105.98	105.79	105.91	1319200.0
2003-11-25 14:00:00	SPY	ETF	105.91	106.27	105.91	106.24	5825700.0
2003-11-25 15:00:00	SPY	ETF	106.22	106.42	105.93	106.01	4346300.0
2003-11-25 16:00:00	SPY	ETF	106.03	106.04	105.9	105.93	1373600.0
2003-11-25 17:00:00	SPY	ETF	105.95	105.97	105.93	105.93	2900.0
2003-11-25 18:00:00	SPY	ETF	105.99	106.02	105.99	106.0	1900.0
2003-11-25 19:00:00	SPY	ETF	106.0	106.0	106.0	106.0	500.0
2003-11-25 08:00:00	QQQ	ETF	35.35	35.55	35.31	35.35	366500.0
2003-11-25 09:00:00	QQQ	ETF	35.35	35.38	35.09	35.35	10029000.0
2003-11-25 10:00:00	QQQ	ETF	35.34	35.41	35.14	35.33	13887200.0
2003-11-25 11:00:00	QQQ	ETF	35.31	35.37	35.2	35.22	7326700.0
2003-11-25 12:00:00	QQQ	ETF	35.22	35.31	35.19	35.26	8215900.0
2003-11-25 13:00:00	QQQ	ETF	35.26	35.3	35.18	35.242	4221300.0
2003-11-25 14:00:00	QQQ	ETF	35.24	35.39	35.21	35.38	6210700.0
2003-11-25 15:00:00	QQQ	ETF	35.378	35.45	35.11	35.13	10669000.0
2003-11-25 16:00:00	QQQ	ETF	35.13	35.2987	35.1	35.15	3006600.0
2003-11-25 17:00:00	QQQ	ETF	35.147	35.17	35.145	35.17	107900.0
2003-11-25 18:00:00	QQQ	ETF	35.165	35.2	35.165	35.19	46000.0
2003-11-25 19:00:00	QQQ	ETF	35.19	35.22	35.18	35.2	7500.0
2003-11-25 08:00:00	IWM	ETF	53.97	53.97	53.925	53.925	3000.0
2003-11-25 09:00:00	IWM	ETF	53.895	54.25	53.755	54.21	1367600.0
2003-11-25 10:00:00	IWM	ETF	54.225	54.27	53.91	54.2165	1916200.0
2003-11-25 11:00:00	IWM	ETF	54.265	54.31	54.069	54.125	942000.0
2003-11-25 12:00:00	IWM	ETF	54.0765	54.17	54.045	54.095	424200.0
2003-11-25 13:00:00	IWM	ETF	54.1	54.215	54.095	54.175	397800.0
2003-11-25 14:00:00	IWM	ETF	54.18	54.34	54.175	54.305	570200.0
2003-11-25 15:00:00	IWM	ETF	54.31	54.42	54.045	54.165	1154000.0
2003-11-25 16:00:00	IWM	ETF	54.165	54.245	54.045	54.045	156400.0
2003-11-25 18:00:00	IWM	ETF	54.125	54.125	54.125	54.125	600.0
2003-11-25 08:00:00	DIA	ETF	97.72	97.86	97.58	97.62	17900.0
2003-11-25 09:00:00	DIA	ETF	97.62	97.7	97.4	97.65	1499600.0
2003-11-25 10:00:00	DIA	ETF	97.68	97.77	97.37	97.76	791500.0
2003-11-25 11:00:00	DIA	ETF	97.74	97.83	97.52	97.55	378100.0
2003-11-25 12:00:00	DIA	ETF	97.56	97.69	97.5	97.6	195300.0
2003-11-25 13:00:00	DIA	ETF	97.63	97.68	97.5	97.65	201500.0
2003-11-25 14:00:00	DIA	ETF	97.65	97.94	97.63	97.91	348300.0
2003-11-25 15:00:00	DIA	ETF	97.928	98.07	97.68	97.76	1416100.0
2003-11-25 16:00:00	DIA	ETF	97.766	97.82	97.68	97.71	68500.0
2003-11-25 09:00:00	TLT	ETF	85.95	86.14	85.95	86.1	61900.0
2003-11-25 10:00:00	TLT	ETF	86.1	86.33	86.1	86.19	61500.0
2003-11-25 11:00:00	TLT	ETF	86.2	86.35	86.2	86.2	81800.0
2003-11-25 12:00:00	TLT	ETF	86.23	86.37	86.18	86.33	19900.0
2003-11-25 13:00:00	TLT	ETF	86.38	86.52	86.38	86.45	28500.0
2003-11-25 14:00:00	TLT	ETF	86.41	86.45	86.24	86.24	8100.0
2003-11-25 15:00:00	TLT	ETF	86.28	86.29	86.22	86.27	11800.0

> showing 50 of 478 rows — these rows as CSV

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