PREVIEW / etf_1hour / 2003-04-01

all etf 1-hour files

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

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-01 08:00:00	SPY	ETF	85.44	85.59	85.15	85.37	82000.0
2003-04-01 09:00:00	SPY	ETF	85.37	85.45	84.98	85.11	4170300.0
2003-04-01 10:00:00	SPY	ETF	85.11	85.84	84.91	85.06	11051800.0
2003-04-01 11:00:00	SPY	ETF	85.07	85.46	85.01	85.44	2817700.0
2003-04-01 12:00:00	SPY	ETF	85.44	86.17	85.4	86.16	7846600.0
2003-04-01 13:00:00	SPY	ETF	86.16	86.25	85.77	86.23	4238700.0
2003-04-01 14:00:00	SPY	ETF	86.19	86.39	85.88	85.93	5490200.0
2003-04-01 15:00:00	SPY	ETF	85.95	86.23	85.6	86.1	10189000.0
2003-04-01 16:00:00	SPY	ETF	86.1	86.18	85.56	85.98	2356800.0
2003-04-01 17:00:00	SPY	ETF	85.96	86.04	85.9	86.0	31000.0
2003-04-01 18:00:00	SPY	ETF	85.93	86.35	85.88	86.35	241700.0
2003-04-01 19:00:00	SPY	ETF	86.35	87.61	86.18	86.23	91400.0
2003-04-01 08:00:00	QQQ	ETF	25.44	25.45	25.33	25.41	95600.0
2003-04-01 09:00:00	QQQ	ETF	25.43	25.51	25.31	25.35	7066500.0
2003-04-01 10:00:00	QQQ	ETF	25.37	25.64	25.25	25.33	17672300.0
2003-04-01 11:00:00	QQQ	ETF	25.33	25.45	25.32	25.4	4613200.0
2003-04-01 12:00:00	QQQ	ETF	25.4	25.59	25.39	25.58	9365900.0
2003-04-01 13:00:00	QQQ	ETF	25.58	25.62	25.43	25.59	5119000.0
2003-04-01 14:00:00	QQQ	ETF	25.59	25.67	25.48	25.49	7933300.0
2003-04-01 15:00:00	QQQ	ETF	25.49	25.55	25.36	25.43	10173800.0
2003-04-01 16:00:00	QQQ	ETF	25.44	25.48	25.36	25.44	5215500.0
2003-04-01 17:00:00	QQQ	ETF	25.44	25.45	25.43	25.43	59900.0
2003-04-01 18:00:00	QQQ	ETF	25.43	25.59	25.43	25.57	333200.0
2003-04-01 19:00:00	QQQ	ETF	25.57	25.69	25.52	25.56	122500.0
2003-04-01 09:00:00	IWM	ETF	36.35	36.4	36.195	36.195	170000.0
2003-04-01 10:00:00	IWM	ETF	36.165	36.425	36.11	36.255	472600.0
2003-04-01 11:00:00	IWM	ETF	36.24	36.405	36.235	36.35	241000.0
2003-04-01 12:00:00	IWM	ETF	36.365	36.605	36.365	36.605	189200.0
2003-04-01 13:00:00	IWM	ETF	36.615	36.62	36.52	36.59	186200.0
2003-04-01 14:00:00	IWM	ETF	36.62	36.675	36.555	36.555	240200.0
2003-04-01 15:00:00	IWM	ETF	36.575	36.665	36.455	36.64	422600.0
2003-04-01 16:00:00	IWM	ETF	36.65	36.69	36.625	36.66	27600.0
2003-04-01 17:00:00	IWM	ETF	36.655	36.655	36.655	36.655	2600.0
2003-04-01 08:00:00	DIA	ETF	80.36	80.45	80.14	80.3	10100.0
2003-04-01 09:00:00	DIA	ETF	80.3	80.4	79.9	80.0	904700.0
2003-04-01 10:00:00	DIA	ETF	80.03	80.74	79.85	80.07	2508400.0
2003-04-01 11:00:00	DIA	ETF	80.07	80.48	80.05	80.38	702500.0
2003-04-01 12:00:00	DIA	ETF	80.38	81.01	80.37	80.98	1459300.0
2003-04-01 13:00:00	DIA	ETF	80.99	81.1	80.6	80.97	753500.0
2003-04-01 14:00:00	DIA	ETF	80.98	81.1	80.65	80.72	1167600.0
2003-04-01 15:00:00	DIA	ETF	80.72	80.94	80.31	80.87	1318500.0
2003-04-01 16:00:00	DIA	ETF	80.89	80.9	80.68	80.71	95100.0
2003-04-01 18:00:00	DIA	ETF	80.75	81.25	80.75	81.25	21600.0
2003-04-01 19:00:00	DIA	ETF	81.2	82.3	80.95	80.95	7000.0
2003-04-01 09:00:00	TLT	ETF	88.4	88.64	88.4	88.64	111000.0
2003-04-01 10:00:00	TLT	ETF	88.65	88.79	88.27	88.42	63200.0
2003-04-01 11:00:00	TLT	ETF	88.37	88.5	88.37	88.5	13500.0
2003-04-01 12:00:00	TLT	ETF	88.36	88.39	88.0	88.0	24500.0
2003-04-01 13:00:00	TLT	ETF	87.96	88.1	87.94	87.94	10200.0
2003-04-01 14:00:00	TLT	ETF	87.92	88.02	87.9	88.02	8800.0

> showing 50 of 396 rows — these rows as CSV

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