PREVIEW / etf_1hour / 2004-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-22.parquet
  size:    25 KB
  rows:    688

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
2004-06-22 08:00:00	SPY	ETF	113.34	113.36	113.11	113.13	22000.0
2004-06-22 09:00:00	SPY	ETF	113.12	113.36	113.01	113.34	4902500.0
2004-06-22 10:00:00	SPY	ETF	113.34	113.38	112.88	112.9	5749900.0
2004-06-22 11:00:00	SPY	ETF	112.9	112.94	112.67	112.8685	4854800.0
2004-06-22 12:00:00	SPY	ETF	112.88	113.26	112.86	113.149	3493000.0
2004-06-22 13:00:00	SPY	ETF	113.13	113.28	112.96	113.15	2700100.0
2004-06-22 14:00:00	SPY	ETF	113.14	113.82	113.11	113.67	6204200.0
2004-06-22 15:00:00	SPY	ETF	113.66	113.8	113.5	113.78	5179800.0
2004-06-22 16:00:00	SPY	ETF	113.79	113.88	113.75	113.8	1359900.0
2004-06-22 17:00:00	SPY	ETF	113.78	113.8	113.77	113.77	201100.0
2004-06-22 18:00:00	SPY	ETF	113.81	113.82	113.8	113.8	8200.0
2004-06-22 19:00:00	SPY	ETF	113.77	113.8	113.77	113.8	500.0
2004-06-22 08:00:00	QQQ	ETF	36.25	36.27	36.16	36.19	356900.0
2004-06-22 09:00:00	QQQ	ETF	36.19	36.29	36.12	36.27	9409200.0
2004-06-22 10:00:00	QQQ	ETF	36.27	36.33	36.1	36.12	15686600.0
2004-06-22 11:00:00	QQQ	ETF	36.12	36.19	36.015	36.17	14780500.0
2004-06-22 12:00:00	QQQ	ETF	36.167	36.38	36.16	36.28	15515900.0
2004-06-22 13:00:00	QQQ	ETF	36.28	36.35	36.18	36.3	6937300.0
2004-06-22 14:00:00	QQQ	ETF	36.293	36.65	36.28	36.59	18636400.0
2004-06-22 15:00:00	QQQ	ETF	36.59	36.68	36.54	36.67	14697800.0
2004-06-22 16:00:00	QQQ	ETF	36.676	36.7	36.64	36.67	2403100.0
2004-06-22 17:00:00	QQQ	ETF	36.68	36.69	36.66	36.68	268500.0
2004-06-22 18:00:00	QQQ	ETF	36.68	36.69	36.65	36.65	47600.0
2004-06-22 19:00:00	QQQ	ETF	36.67	36.69	36.67	36.67	10000.0
2004-06-22 08:00:00	IWM	ETF	56.755	56.755	56.755	56.755	200.0
2004-06-22 09:00:00	IWM	ETF	56.725	56.77	56.5	56.75	889600.0
2004-06-22 10:00:00	IWM	ETF	56.77	56.825	56.49	56.495	1388800.0
2004-06-22 11:00:00	IWM	ETF	56.49	56.49	56.205	56.39	1757000.0
2004-06-22 12:00:00	IWM	ETF	56.39	56.72	56.39	56.595	1077800.0
2004-06-22 13:00:00	IWM	ETF	56.605	56.76	56.575	56.7	266400.0
2004-06-22 14:00:00	IWM	ETF	56.7	57.105	56.69	57.015	1917200.0
2004-06-22 15:00:00	IWM	ETF	57.03	57.145	56.995	57.135	1803600.0
2004-06-22 16:00:00	IWM	ETF	57.14	57.2	57.08	57.1	264800.0
2004-06-22 08:00:00	DIA	ETF	103.88	103.88	103.71	103.71	8000.0
2004-06-22 09:00:00	DIA	ETF	103.72	103.82	103.6	103.77	359000.0
2004-06-22 10:00:00	DIA	ETF	103.77	103.82	103.39	103.42	509300.0
2004-06-22 11:00:00	DIA	ETF	103.41	103.43	103.17	103.34	828400.0
2004-06-22 12:00:00	DIA	ETF	103.32	103.62	103.3	103.52	521100.0
2004-06-22 13:00:00	DIA	ETF	103.52	103.6	103.36	103.51	182100.0
2004-06-22 14:00:00	DIA	ETF	103.5	104.12	103.5	103.99	963700.0
2004-06-22 15:00:00	DIA	ETF	104.01	104.15	103.9	104.12	582200.0
2004-06-22 16:00:00	DIA	ETF	104.14	104.21	104.12	104.2	34300.0
2004-06-22 17:00:00	DIA	ETF	104.21	104.22	104.21	104.22	800.0
2004-06-22 09:00:00	TLT	ETF	82.43	82.52	82.43	82.49	7800.0
2004-06-22 10:00:00	TLT	ETF	82.54	82.59	82.42	82.45	138600.0
2004-06-22 11:00:00	TLT	ETF	82.44	82.48	82.41	82.44	84000.0
2004-06-22 12:00:00	TLT	ETF	82.44	82.5	82.4	82.41	25300.0
2004-06-22 13:00:00	TLT	ETF	82.45	82.54	82.45	82.53	17000.0
2004-06-22 14:00:00	TLT	ETF	82.53	82.55	82.38	82.43	57700.0
2004-06-22 15:00:00	TLT	ETF	82.46	82.46	82.36	82.39	30700.0

> showing 50 of 688 rows — these rows as CSV

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