PREVIEW / etf_1hour / 2004-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-16.parquet
  size:    26 KB
  rows:    778

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-11-16 08:00:00	SPY	ETF	118.53	118.53	118.27	118.38	249200.0
2004-11-16 09:00:00	SPY	ETF	118.4	118.41	118.1	118.11	5025500.0
2004-11-16 10:00:00	SPY	ETF	118.12	118.16	117.86	118.05	10875100.0
2004-11-16 11:00:00	SPY	ETF	118.05	118.13	117.85	117.91	3643900.0
2004-11-16 12:00:00	SPY	ETF	117.92	118.05	117.83	117.92	3199800.0
2004-11-16 13:00:00	SPY	ETF	117.92	118.16	117.87	117.95	4732700.0
2004-11-16 14:00:00	SPY	ETF	117.95	118.03	117.77	117.9	3007400.0
2004-11-16 15:00:00	SPY	ETF	117.91	118.11	117.73	117.76	6174500.0
2004-11-16 16:00:00	SPY	ETF	117.76	118.03	117.72	118.01	1931800.0
2004-11-16 17:00:00	SPY	ETF	118.02	118.02	117.88	118.0	117200.0
2004-11-16 18:00:00	SPY	ETF	117.98	118.02	117.98	118.0	3100.0
2004-11-16 19:00:00	SPY	ETF	117.97	117.98	117.97	117.98	1100.0
2004-11-16 08:00:00	QQQ	ETF	38.74	38.76	38.63	38.66	399800.0
2004-11-16 09:00:00	QQQ	ETF	38.67	38.68	38.515	38.519	11321300.0
2004-11-16 10:00:00	QQQ	ETF	38.52	38.53	38.32	38.47	22597100.0
2004-11-16 11:00:00	QQQ	ETF	38.45	38.5	38.39	38.43	10754400.0
2004-11-16 12:00:00	QQQ	ETF	38.43	38.5	38.4	38.49	6647300.0
2004-11-16 13:00:00	QQQ	ETF	38.49	38.68	38.48	38.605	13197700.0
2004-11-16 14:00:00	QQQ	ETF	38.608	38.65	38.46	38.502	12325000.0
2004-11-16 15:00:00	QQQ	ETF	38.504	38.65	38.46	38.51	13867700.0
2004-11-16 16:00:00	QQQ	ETF	38.51	38.73	38.51	38.728	2688800.0
2004-11-16 17:00:00	QQQ	ETF	38.721	38.74	38.69	38.74	218000.0
2004-11-16 18:00:00	QQQ	ETF	38.73	38.74	38.7	38.71	101000.0
2004-11-16 19:00:00	QQQ	ETF	38.72	38.74	38.7	38.74	11100.0
2004-11-16 08:00:00	IWM	ETF	62.13	62.16	62.01	62.05	11200.0
2004-11-16 09:00:00	IWM	ETF	62.05	62.135	61.905	61.905	1594000.0
2004-11-16 10:00:00	IWM	ETF	61.905	61.92	61.725	61.865	2076000.0
2004-11-16 11:00:00	IWM	ETF	61.87	61.955	61.75	61.8	899400.0
2004-11-16 12:00:00	IWM	ETF	61.79	61.92	61.765	61.815	669200.0
2004-11-16 13:00:00	IWM	ETF	61.815	62.075	61.815	61.925	932800.0
2004-11-16 14:00:00	IWM	ETF	61.935	61.97	61.63	61.675	1600200.0
2004-11-16 15:00:00	IWM	ETF	61.685	61.83	61.525	61.65	2547200.0
2004-11-16 16:00:00	IWM	ETF	61.67	61.84	61.61	61.825	663400.0
2004-11-16 17:00:00	IWM	ETF	61.775	61.805	61.775	61.775	11400.0
2004-11-16 19:00:00	IWM	ETF	61.775	61.775	61.775	61.775	200.0
2004-11-16 08:00:00	DIA	ETF	105.57	105.57	105.37	105.41	59400.0
2004-11-16 09:00:00	DIA	ETF	105.42	105.47	105.21	105.21	569200.0
2004-11-16 10:00:00	DIA	ETF	105.21	105.23	104.94	105.14	2897000.0
2004-11-16 11:00:00	DIA	ETF	105.13	105.23	105.06	105.1	854700.0
2004-11-16 12:00:00	DIA	ETF	105.1	105.25	105.05	105.14	264100.0
2004-11-16 13:00:00	DIA	ETF	105.15	105.31	105.1	105.18	666100.0
2004-11-16 14:00:00	DIA	ETF	105.18	105.23	105.0	105.1	407900.0
2004-11-16 15:00:00	DIA	ETF	105.11	105.29	105.01	105.05	949500.0
2004-11-16 16:00:00	DIA	ETF	105.05	105.25	105.0	105.25	1341600.0
2004-11-16 17:00:00	DIA	ETF	105.25	105.33	105.22	105.22	6600.0
2004-11-16 19:00:00	DIA	ETF	105.22	105.22	105.22	105.22	700.0
2004-11-16 08:00:00	TLT	ETF	87.76	87.83	87.75	87.81	74900.0
2004-11-16 09:00:00	TLT	ETF	87.84	87.92	87.7	87.8	204500.0
2004-11-16 10:00:00	TLT	ETF	87.8	87.93	87.8	87.84	78700.0
2004-11-16 11:00:00	TLT	ETF	87.81	87.86	87.78	87.82	27600.0

> showing 50 of 778 rows — these rows as CSV

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