PREVIEW / etf_1hour / 2003-04-10

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-10.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-04-10 08:00:00	SPY	ETF	87.08	87.2	86.94	87.2	52600.0
2003-04-10 09:00:00	SPY	ETF	87.13	87.37	86.71	86.95	4338400.0
2003-04-10 10:00:00	SPY	ETF	86.93	87.14	86.56	86.84	7268400.0
2003-04-10 11:00:00	SPY	ETF	86.85	86.99	86.54	86.82	4522700.0
2003-04-10 12:00:00	SPY	ETF	86.83	87.2	86.78	87.01	4671200.0
2003-04-10 13:00:00	SPY	ETF	87.0	87.33	86.82	87.19	2931600.0
2003-04-10 14:00:00	SPY	ETF	87.2	87.39	87.06	87.25	3964800.0
2003-04-10 15:00:00	SPY	ETF	87.25	87.51	86.95	87.45	5828500.0
2003-04-10 16:00:00	SPY	ETF	87.45	87.65	87.15	87.56	3992800.0
2003-04-10 17:00:00	SPY	ETF	87.55	87.69	87.55	87.69	320000.0
2003-04-10 18:00:00	SPY	ETF	87.65	87.7	87.61	87.66	8100.0
2003-04-10 19:00:00	SPY	ETF	87.67	87.74	87.57	87.67	27800.0
2003-04-10 08:00:00	QQQ	ETF	25.5	25.5	25.39	25.41	89600.0
2003-04-10 09:00:00	QQQ	ETF	25.43	25.56	25.35	25.47	7070200.0
2003-04-10 10:00:00	QQQ	ETF	25.48	25.52	25.3	25.44	8149800.0
2003-04-10 11:00:00	QQQ	ETF	25.45	25.49	25.35	25.46	5136300.0
2003-04-10 12:00:00	QQQ	ETF	25.46	25.67	25.45	25.61	8617700.0
2003-04-10 13:00:00	QQQ	ETF	25.61	25.75	25.5	25.67	6166300.0
2003-04-10 14:00:00	QQQ	ETF	25.67	25.77	25.55	25.69	7374200.0
2003-04-10 15:00:00	QQQ	ETF	25.7	25.77	25.58	25.67	7131400.0
2003-04-10 16:00:00	QQQ	ETF	25.68	25.85	25.63	25.77	3583300.0
2003-04-10 17:00:00	QQQ	ETF	25.77	25.81	25.76	25.8	281500.0
2003-04-10 18:00:00	QQQ	ETF	25.79	25.79	25.76	25.79	125400.0
2003-04-10 19:00:00	QQQ	ETF	25.79	25.8	25.76	25.79	241700.0
2003-04-10 09:00:00	IWM	ETF	37.175	37.225	37.04	37.15	224000.0
2003-04-10 10:00:00	IWM	ETF	37.15	37.15	37.0	37.085	168000.0
2003-04-10 11:00:00	IWM	ETF	37.085	37.11	36.985	37.07	93200.0
2003-04-10 12:00:00	IWM	ETF	37.09	37.21	37.03	37.15	127800.0
2003-04-10 13:00:00	IWM	ETF	37.13	37.28	37.1	37.235	177600.0
2003-04-10 14:00:00	IWM	ETF	37.255	37.27	37.135	37.165	184000.0
2003-04-10 15:00:00	IWM	ETF	37.18	37.245	37.11	37.11	428000.0
2003-04-10 16:00:00	IWM	ETF	37.12	37.23	37.12	37.125	48200.0
2003-04-10 08:00:00	DIA	ETF	82.23	82.36	82.17	82.36	15600.0
2003-04-10 09:00:00	DIA	ETF	82.39	82.55	81.8	82.09	1496900.0
2003-04-10 10:00:00	DIA	ETF	82.1	82.2	81.65	81.88	1372600.0
2003-04-10 11:00:00	DIA	ETF	81.87	81.98	81.56	81.81	499500.0
2003-04-10 12:00:00	DIA	ETF	81.83	82.17	81.83	81.96	531400.0
2003-04-10 13:00:00	DIA	ETF	81.98	82.21	81.8	82.09	513600.0
2003-04-10 14:00:00	DIA	ETF	82.1	82.35	81.95	82.17	592900.0
2003-04-10 15:00:00	DIA	ETF	82.16	82.43	81.89	82.38	789300.0
2003-04-10 16:00:00	DIA	ETF	82.37	82.48	82.32	82.46	159100.0
2003-04-10 17:00:00	DIA	ETF	82.48	82.54	82.41	82.54	7200.0
2003-04-10 18:00:00	DIA	ETF	82.5	82.5	82.5	82.5	100.0
2003-04-10 19:00:00	DIA	ETF	82.55	82.7	82.55	82.55	600.0
2003-04-10 20:00:00	DIA	ETF	82.5	82.5	82.5	82.5	200.0
2003-04-10 09:00:00	TLT	ETF	87.75	87.75	87.58	87.75	2200.0
2003-04-10 10:00:00	TLT	ETF	87.66	87.75	87.6	87.7	2600.0
2003-04-10 11:00:00	TLT	ETF	87.82	87.85	87.69	87.74	2700.0
2003-04-10 12:00:00	TLT	ETF	87.65	87.65	87.5	87.58	6300.0
2003-04-10 13:00:00	TLT	ETF	87.51	87.54	87.46	87.46	3900.0

> showing 50 of 378 rows — these rows as CSV

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