PREVIEW / etf_1hour / 2004-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-09.parquet
  size:    24 KB
  rows:    658

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-01-09 08:00:00	SPY	ETF	113.35	113.36	112.73	112.86	566300.0
2004-01-09 09:00:00	SPY	ETF	112.84	112.94	112.54	112.9	9721100.0
2004-01-09 10:00:00	SPY	ETF	112.9	113.24	112.85	113.11	6678200.0
2004-01-09 11:00:00	SPY	ETF	113.11	113.33	113.05	113.26	3936600.0
2004-01-09 12:00:00	SPY	ETF	113.27	113.34	113.01	113.11	3093600.0
2004-01-09 13:00:00	SPY	ETF	113.12	113.44	113.08	113.14	2601500.0
2004-01-09 14:00:00	SPY	ETF	113.15	113.24	112.5	112.68	5075500.0
2004-01-09 15:00:00	SPY	ETF	112.66	112.71	112.34	112.53	6749400.0
2004-01-09 16:00:00	SPY	ETF	112.51	112.56	112.27	112.4	7788200.0
2004-01-09 17:00:00	SPY	ETF	112.39	112.47	112.31	112.31	5490300.0
2004-01-09 18:00:00	SPY	ETF	112.35	112.37	112.31	112.37	2800.0
2004-01-09 19:00:00	SPY	ETF	112.38	112.41	112.35	112.41	800.0
2004-01-09 08:00:00	QQQ	ETF	38.02	38.02	37.65	37.69	686600.0
2004-01-09 09:00:00	QQQ	ETF	37.7	37.81	37.59	37.79	12941900.0
2004-01-09 10:00:00	QQQ	ETF	37.79	38.07	37.77	38.0	15612500.0
2004-01-09 11:00:00	QQQ	ETF	38.03	38.19	37.97	38.19	10711000.0
2004-01-09 12:00:00	QQQ	ETF	38.18	38.25	38.1	38.16	8219500.0
2004-01-09 13:00:00	QQQ	ETF	38.16	38.35	38.15	38.21	8030300.0
2004-01-09 14:00:00	QQQ	ETF	38.2	38.25	37.82	37.9	12169400.0
2004-01-09 15:00:00	QQQ	ETF	37.931	37.94	37.71	37.818	17562600.0
2004-01-09 16:00:00	QQQ	ETF	37.82	37.84	37.71	37.77	3235800.0
2004-01-09 17:00:00	QQQ	ETF	37.77	37.83	37.77	37.8	44000.0
2004-01-09 18:00:00	QQQ	ETF	37.81	37.81	37.78	37.81	22200.0
2004-01-09 19:00:00	QQQ	ETF	37.81	37.83	37.81	37.82	6100.0
2004-01-09 08:00:00	IWM	ETF	57.68	57.68	57.3	57.335	6400.0
2004-01-09 09:00:00	IWM	ETF	57.37	57.53	57.06	57.445	1485800.0
2004-01-09 10:00:00	IWM	ETF	57.5	57.91	57.475	57.825	1430200.0
2004-01-09 11:00:00	IWM	ETF	57.825	57.975	57.825	57.925	779000.0
2004-01-09 12:00:00	IWM	ETF	57.925	57.95	57.775	57.82	324600.0
2004-01-09 13:00:00	IWM	ETF	57.825	58.005	57.81	57.895	635200.0
2004-01-09 14:00:00	IWM	ETF	57.865	57.92	57.405	57.43	1222400.0
2004-01-09 15:00:00	IWM	ETF	57.435	57.475	57.2	57.2	2808800.0
2004-01-09 16:00:00	IWM	ETF	57.22	57.29	57.115	57.29	387400.0
2004-01-09 18:00:00	IWM	ETF	57.58	57.58	57.58	57.58	200.0
2004-01-09 08:00:00	DIA	ETF	106.0	106.0	105.36	105.4	53100.0
2004-01-09 09:00:00	DIA	ETF	105.4	105.5	105.17	105.46	1413300.0
2004-01-09 10:00:00	DIA	ETF	105.451	105.7	105.37	105.61	1576600.0
2004-01-09 11:00:00	DIA	ETF	105.57	105.73	105.48	105.62	661500.0
2004-01-09 12:00:00	DIA	ETF	105.63	105.66	105.41	105.5	456900.0
2004-01-09 13:00:00	DIA	ETF	105.5	105.67	105.38	105.44	484700.0
2004-01-09 14:00:00	DIA	ETF	105.45	105.53	104.9	104.97	1249700.0
2004-01-09 15:00:00	DIA	ETF	104.97	105.02	104.62	104.84	2616400.0
2004-01-09 16:00:00	DIA	ETF	104.86	104.86	104.68	104.8	256100.0
2004-01-09 17:00:00	DIA	ETF	104.8	104.8	104.76	104.79	1800.0
2004-01-09 18:00:00	DIA	ETF	104.78	104.78	104.75	104.75	1300.0
2004-01-09 19:00:00	DIA	ETF	104.7	104.7	104.7	104.7	200.0
2004-01-09 08:00:00	TLT	ETF	86.0	86.4	86.0	86.4	600.0
2004-01-09 09:00:00	TLT	ETF	86.76	87.07	86.71	86.71	401000.0
2004-01-09 10:00:00	TLT	ETF	86.81	86.93	86.7	86.75	340100.0
2004-01-09 11:00:00	TLT	ETF	86.75	86.79	86.66	86.68	386200.0

> showing 50 of 658 rows — these rows as CSV

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