PREVIEW / etf_1hour / 2004-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-02.parquet
  size:    25 KB
  rows:    689

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-02-02 08:00:00	SPY	ETF	113.67	113.72	113.65	113.69	26300.0
2004-02-02 09:00:00	SPY	ETF	113.64	113.89	113.56	113.82	2959100.0
2004-02-02 10:00:00	SPY	ETF	113.81	113.82	113.13	113.16	8058400.0
2004-02-02 11:00:00	SPY	ETF	113.22	114.11	113.12	114.08	4476600.0
2004-02-02 12:00:00	SPY	ETF	114.07	114.68	114.03	114.53	4910400.0
2004-02-02 13:00:00	SPY	ETF	114.52	114.64	114.38	114.5	2590400.0
2004-02-02 14:00:00	SPY	ETF	114.5	114.57	114.32	114.49	2625500.0
2004-02-02 15:00:00	SPY	ETF	114.5	114.54	113.35	113.83	8897700.0
2004-02-02 16:00:00	SPY	ETF	113.84	113.97	113.8	113.92	1384800.0
2004-02-02 17:00:00	SPY	ETF	113.91	113.92	113.89	113.9	5900.0
2004-02-02 18:00:00	SPY	ETF	113.92	113.92	113.89	113.9	17800.0
2004-02-02 19:00:00	SPY	ETF	113.88	113.89	113.85	113.85	1400.0
2004-02-02 08:00:00	QQQ	ETF	37.2	37.24	37.17	37.19	70500.0
2004-02-02 09:00:00	QQQ	ETF	37.19	37.335	37.14	37.228	7240100.0
2004-02-02 10:00:00	QQQ	ETF	37.22	37.25	36.82	36.89	17730900.0
2004-02-02 11:00:00	QQQ	ETF	36.89	37.39	36.83	37.299	13788700.0
2004-02-02 12:00:00	QQQ	ETF	37.3	37.48	37.27	37.43	12609200.0
2004-02-02 13:00:00	QQQ	ETF	37.42	37.474	37.36	37.414	6563400.0
2004-02-02 14:00:00	QQQ	ETF	37.41	37.43	37.26	37.34	9365400.0
2004-02-02 15:00:00	QQQ	ETF	37.348	37.36	36.83	36.95	16754500.0
2004-02-02 16:00:00	QQQ	ETF	36.95	37.03	36.92	36.97	3992800.0
2004-02-02 17:00:00	QQQ	ETF	36.97	36.99	36.954	36.97	112200.0
2004-02-02 18:00:00	QQQ	ETF	36.97	36.997	36.97	36.99	19000.0
2004-02-02 19:00:00	QQQ	ETF	36.98	36.99	36.97	36.99	9500.0
2004-02-02 09:00:00	IWM	ETF	57.93	58.155	57.89	58.13	873400.0
2004-02-02 10:00:00	IWM	ETF	58.12	58.12	57.32	57.38	2273800.0
2004-02-02 11:00:00	IWM	ETF	57.3895	58.035	57.32	58.035	1317000.0
2004-02-02 12:00:00	IWM	ETF	58.0185	58.375	58.01	58.35	1770000.0
2004-02-02 13:00:00	IWM	ETF	58.35	58.37	58.235	58.24	1057800.0
2004-02-02 14:00:00	IWM	ETF	58.23	58.24	58.0	58.165	1374600.0
2004-02-02 15:00:00	IWM	ETF	58.165	58.165	57.6	57.77	945000.0
2004-02-02 16:00:00	IWM	ETF	57.8045	57.95	57.755	57.851	273600.0
2004-02-02 17:00:00	IWM	ETF	57.84	57.95	57.84	57.95	52600.0
2004-02-02 08:00:00	DIA	ETF	105.21	105.24	105.16	105.18	1400.0
2004-02-02 09:00:00	DIA	ETF	105.15	105.3	105.09	105.26	521300.0
2004-02-02 10:00:00	DIA	ETF	105.24	105.25	104.53	104.55	910300.0
2004-02-02 11:00:00	DIA	ETF	104.61	105.31	104.55	105.3	307700.0
2004-02-02 12:00:00	DIA	ETF	105.3	105.8	105.24	105.72	1536000.0
2004-02-02 13:00:00	DIA	ETF	105.72	105.86	105.64	105.73	528600.0
2004-02-02 14:00:00	DIA	ETF	105.76	105.82	105.57	105.72	413300.0
2004-02-02 15:00:00	DIA	ETF	105.7	105.74	104.71	105.18	2051300.0
2004-02-02 16:00:00	DIA	ETF	105.122	105.3	105.12	105.16	185800.0
2004-02-02 17:00:00	DIA	ETF	105.26	105.33	105.26	105.33	400.0
2004-02-02 09:00:00	TLT	ETF	86.45	86.58	86.45	86.5	33200.0
2004-02-02 10:00:00	TLT	ETF	86.55	86.8	86.38	86.8	115000.0
2004-02-02 11:00:00	TLT	ETF	86.8	86.85	86.42	86.43	53500.0
2004-02-02 12:00:00	TLT	ETF	86.45	86.52	86.43	86.51	19900.0
2004-02-02 13:00:00	TLT	ETF	86.54	86.86	86.51	86.86	30100.0
2004-02-02 14:00:00	TLT	ETF	86.85	86.88	86.46	86.48	47100.0
2004-02-02 15:00:00	TLT	ETF	86.46	86.55	86.44	86.48	26200.0

> showing 50 of 689 rows — these rows as CSV

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