PREVIEW / etf_1hour / 2003-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-29.parquet
  size:    18 KB
  rows:    436

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-09-29 08:00:00	SPY	ETF	100.28	100.38	100.25	100.28	158200.0
2003-09-29 09:00:00	SPY	ETF	100.3	100.52	100.247	100.25	2858800.0
2003-09-29 10:00:00	SPY	ETF	100.24	100.49	99.92	100.07	4672700.0
2003-09-29 11:00:00	SPY	ETF	100.07	100.45	99.79	100.42	5854700.0
2003-09-29 12:00:00	SPY	ETF	100.42	100.9	100.41	100.78	6189700.0
2003-09-29 13:00:00	SPY	ETF	100.78	100.93	100.59	100.8	3092100.0
2003-09-29 14:00:00	SPY	ETF	100.79	100.99	100.66	100.984	2076000.0
2003-09-29 15:00:00	SPY	ETF	100.97	100.97	100.5	100.87	4809200.0
2003-09-29 16:00:00	SPY	ETF	100.85	100.99	100.7	100.84	1118900.0
2003-09-29 17:00:00	SPY	ETF	100.84	100.93	100.84	100.92	11500.0
2003-09-29 18:00:00	SPY	ETF	100.92	100.95	100.87	100.87	12800.0
2003-09-29 19:00:00	SPY	ETF	100.84	100.84	100.81	100.82	2700.0
2003-09-29 08:00:00	QQQ	ETF	32.81	32.86	32.8	32.83	98400.0
2003-09-29 09:00:00	QQQ	ETF	32.83	32.94	32.73	32.81	10883600.0
2003-09-29 10:00:00	QQQ	ETF	32.805	32.88	32.6	32.68	13325500.0
2003-09-29 11:00:00	QQQ	ETF	32.681	32.82	32.45	32.8	19085200.0
2003-09-29 12:00:00	QQQ	ETF	32.79	33.02	32.79	33.0	14207700.0
2003-09-29 13:00:00	QQQ	ETF	32.99	33.12	32.93	33.05	8301000.0
2003-09-29 14:00:00	QQQ	ETF	33.05	33.16	32.995	33.129	5446200.0
2003-09-29 15:00:00	QQQ	ETF	33.139	33.151	32.85	33.11	9702100.0
2003-09-29 16:00:00	QQQ	ETF	33.1	33.2	33.08	33.13	4156700.0
2003-09-29 17:00:00	QQQ	ETF	33.157	33.17	33.15	33.16	174200.0
2003-09-29 18:00:00	QQQ	ETF	33.165	33.19	33.16	33.18	181900.0
2003-09-29 19:00:00	QQQ	ETF	33.17	33.18	33.16	33.16	14800.0
2003-09-29 09:00:00	IWM	ETF	48.0	48.79	48.0	48.58	1511200.0
2003-09-29 10:00:00	IWM	ETF	48.565	48.62	48.07	48.1	1923200.0
2003-09-29 11:00:00	IWM	ETF	48.116	48.39	47.955	48.335	2110600.0
2003-09-29 12:00:00	IWM	ETF	48.385	48.84	48.375	48.81	1076200.0
2003-09-29 13:00:00	IWM	ETF	48.82	49.1135	48.775	48.85	1461600.0
2003-09-29 14:00:00	IWM	ETF	48.87	49.1	48.85	49.045	768400.0
2003-09-29 15:00:00	IWM	ETF	49.055	49.12	48.79	49.1	2028400.0
2003-09-29 16:00:00	IWM	ETF	49.1	49.225	49.059	49.165	307400.0
2003-09-29 08:00:00	DIA	ETF	93.6	93.61	93.53	93.53	2700.0
2003-09-29 09:00:00	DIA	ETF	93.52	93.77	93.49	93.53	691700.0
2003-09-29 10:00:00	DIA	ETF	93.58	93.69	93.17	93.28	701900.0
2003-09-29 11:00:00	DIA	ETF	93.28	93.73	93.05	93.72	1049700.0
2003-09-29 12:00:00	DIA	ETF	93.69	94.11	93.65	93.92	988900.0
2003-09-29 13:00:00	DIA	ETF	93.92	94.06	93.69	93.87	772700.0
2003-09-29 14:00:00	DIA	ETF	93.84	94.05	93.73	94.01	672500.0
2003-09-29 15:00:00	DIA	ETF	94.0	94.0	93.59	93.94	724700.0
2003-09-29 16:00:00	DIA	ETF	93.91	93.95	93.77	93.9	158200.0
2003-09-29 17:00:00	DIA	ETF	93.92	93.92	93.91	93.91	3000.0
2003-09-29 18:00:00	DIA	ETF	93.9	93.9	93.85	93.85	600.0
2003-09-29 19:00:00	DIA	ETF	93.85	93.85	93.85	93.85	100.0
2003-09-29 09:00:00	TLT	ETF	87.02	87.08	86.85	87.0	58200.0
2003-09-29 10:00:00	TLT	ETF	86.95	87.23	86.9	87.23	190400.0
2003-09-29 11:00:00	TLT	ETF	87.22	87.44	87.148	87.19	41200.0
2003-09-29 12:00:00	TLT	ETF	87.1	87.11	86.86	87.08	91700.0
2003-09-29 13:00:00	TLT	ETF	87.02	87.09	86.92	87.09	51100.0
2003-09-29 14:00:00	TLT	ETF	87.09	87.1	86.66	86.72	145800.0

> showing 50 of 436 rows — these rows as CSV

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