PREVIEW / etf_1hour / 2003-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-20.parquet
  size:    17 KB
  rows:    413

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-06-20 08:00:00	SPY	ETF	100.0	100.22	100.0	100.22	32700.0
2003-06-20 09:00:00	SPY	ETF	100.24	100.5	99.709	99.93	5790700.0
2003-06-20 10:00:00	SPY	ETF	99.92	100.42	99.808	100.21	5185300.0
2003-06-20 11:00:00	SPY	ETF	100.25	100.5	100.16	100.24	3259700.0
2003-06-20 12:00:00	SPY	ETF	100.243	100.42	100.18	100.23	975600.0
2003-06-20 13:00:00	SPY	ETF	100.23	100.29	99.61	99.699	4124200.0
2003-06-20 14:00:00	SPY	ETF	99.7	100.002	99.69	99.98	2727800.0
2003-06-20 15:00:00	SPY	ETF	99.98	99.98	99.53	99.75	4334100.0
2003-06-20 16:00:00	SPY	ETF	99.75	99.81	99.42	99.6	3773600.0
2003-06-20 17:00:00	SPY	ETF	99.55	99.6	99.55	99.6	7200.0
2003-06-20 18:00:00	SPY	ETF	99.55	99.55	99.51	99.51	3100.0
2003-06-20 19:00:00	SPY	ETF	99.55	99.6	99.55	99.6	3200.0
2003-06-20 08:00:00	QQQ	ETF	30.56	30.67	30.54	30.67	129300.0
2003-06-20 09:00:00	QQQ	ETF	30.66	30.72	30.27	30.36	15236700.0
2003-06-20 10:00:00	QQQ	ETF	30.36	30.56	30.25	30.436	13399600.0
2003-06-20 11:00:00	QQQ	ETF	30.44	30.63	30.41	30.53	6581100.0
2003-06-20 12:00:00	QQQ	ETF	30.529	30.66	30.51	30.57	4366000.0
2003-06-20 13:00:00	QQQ	ETF	30.58	30.6	30.3	30.331	7281900.0
2003-06-20 14:00:00	QQQ	ETF	30.331	30.49	30.32	30.44	7028800.0
2003-06-20 15:00:00	QQQ	ETF	30.46	30.47	30.27	30.4	9216600.0
2003-06-20 16:00:00	QQQ	ETF	30.41	30.41	30.27	30.36	1566100.0
2003-06-20 17:00:00	QQQ	ETF	30.37	30.38	30.35	30.38	24500.0
2003-06-20 18:00:00	QQQ	ETF	30.38	30.38	30.32	30.35	50800.0
2003-06-20 19:00:00	QQQ	ETF	30.36	30.37	30.34	30.34	16100.0
2003-06-20 09:00:00	IWM	ETF	45.15	45.2	44.88	44.905	717000.0
2003-06-20 10:00:00	IWM	ETF	44.935	44.975	44.815	44.825	343200.0
2003-06-20 11:00:00	IWM	ETF	44.815	44.89	44.815	44.875	201000.0
2003-06-20 12:00:00	IWM	ETF	44.88	44.98	44.88	44.915	41400.0
2003-06-20 13:00:00	IWM	ETF	44.94	44.95	44.75	44.765	727400.0
2003-06-20 14:00:00	IWM	ETF	44.77	44.87	44.765	44.845	118400.0
2003-06-20 15:00:00	IWM	ETF	44.865	44.875	44.76	44.795	374200.0
2003-06-20 16:00:00	IWM	ETF	44.795	44.8	44.58	44.635	82600.0
2003-06-20 08:00:00	DIA	ETF	92.21	92.45	92.2	92.45	6400.0
2003-06-20 09:00:00	DIA	ETF	92.44	92.73	92.18	92.35	1050700.0
2003-06-20 10:00:00	DIA	ETF	92.36	92.79	92.29	92.67	1445100.0
2003-06-20 11:00:00	DIA	ETF	92.68	92.9	92.55	92.59	1285400.0
2003-06-20 12:00:00	DIA	ETF	92.6	92.75	92.411	92.54	303800.0
2003-06-20 13:00:00	DIA	ETF	92.55	92.55	92.01	92.07	769800.0
2003-06-20 14:00:00	DIA	ETF	92.07	92.35	92.05	92.32	363300.0
2003-06-20 15:00:00	DIA	ETF	92.31	92.33	91.86	92.1	1895500.0
2003-06-20 16:00:00	DIA	ETF	92.1	92.12	91.8	91.89	307200.0
2003-06-20 18:00:00	DIA	ETF	91.9	91.9	91.84	91.84	1400.0
2003-06-20 09:00:00	TLT	ETF	93.9	94.05	93.81	94.03	34300.0
2003-06-20 10:00:00	TLT	ETF	94.01	94.01	93.78	93.89	139100.0
2003-06-20 11:00:00	TLT	ETF	93.86	93.9	93.61	93.72	117700.0
2003-06-20 12:00:00	TLT	ETF	93.74	93.74	93.28	93.3	61900.0
2003-06-20 13:00:00	TLT	ETF	93.33	93.45	93.03	93.28	66300.0
2003-06-20 14:00:00	TLT	ETF	93.18	93.49	93.12	93.44	35900.0
2003-06-20 15:00:00	TLT	ETF	93.48	93.7	93.48	93.56	24600.0
2003-06-20 16:00:00	TLT	ETF	93.59	93.75	93.59	93.75	12500.0

> showing 50 of 413 rows — these rows as CSV

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