PREVIEW / etf_1hour / 2004-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-16.parquet
  size:    24 KB
  rows:    679

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-04-16 08:00:00	SPY	ETF	113.01	113.37	113.0	113.37	49800.0
2004-04-16 09:00:00	SPY	ETF	113.37	113.46	112.98	113.07	5112200.0
2004-04-16 10:00:00	SPY	ETF	113.08	113.6	113.02	113.45	6129000.0
2004-04-16 11:00:00	SPY	ETF	113.43	113.78	113.4	113.72	4231500.0
2004-04-16 12:00:00	SPY	ETF	113.71	114.05	113.64	113.91	6051200.0
2004-04-16 13:00:00	SPY	ETF	113.91	113.97	113.62	113.74	2230100.0
2004-04-16 14:00:00	SPY	ETF	113.73	113.96	113.64	113.74	2290600.0
2004-04-16 15:00:00	SPY	ETF	113.73	113.92	113.5	113.73	3668200.0
2004-04-16 16:00:00	SPY	ETF	113.71	113.95	113.13	113.81	2780200.0
2004-04-16 17:00:00	SPY	ETF	113.75	113.83	113.73	113.73	183000.0
2004-04-16 19:00:00	SPY	ETF	113.73	113.73	113.73	113.73	100.0
2004-04-16 08:00:00	QQQ	ETF	36.05	36.2	36.05	36.2	443200.0
2004-04-16 09:00:00	QQQ	ETF	36.2	36.233	35.79	35.89	12422700.0
2004-04-16 10:00:00	QQQ	ETF	35.886	36.08	35.842	36.03	14660200.0
2004-04-16 11:00:00	QQQ	ETF	36.03	36.3	36.01	36.22	18332400.0
2004-04-16 12:00:00	QQQ	ETF	36.21	36.32	36.13	36.27	9077300.0
2004-04-16 13:00:00	QQQ	ETF	36.27	36.27	36.05	36.13	5814500.0
2004-04-16 14:00:00	QQQ	ETF	36.124	36.22	36.09	36.11	6690500.0
2004-04-16 15:00:00	QQQ	ETF	36.109	36.14	35.97	36.05	12161900.0
2004-04-16 16:00:00	QQQ	ETF	36.04	36.13	36.0	36.07	2450300.0
2004-04-16 17:00:00	QQQ	ETF	36.07	36.08	36.06	36.08	44600.0
2004-04-16 18:00:00	QQQ	ETF	36.08	36.12	36.05	36.08	51000.0
2004-04-16 19:00:00	QQQ	ETF	36.06	36.06	36.03	36.05	11200.0
2004-04-16 08:00:00	IWM	ETF	57.745	57.95	57.57	57.95	8000.0
2004-04-16 09:00:00	IWM	ETF	57.88	57.99	57.385	57.43	896400.0
2004-04-16 10:00:00	IWM	ETF	57.415	57.99	57.365	57.91	2632800.0
2004-04-16 11:00:00	IWM	ETF	57.905	58.22	57.905	58.11	1374800.0
2004-04-16 12:00:00	IWM	ETF	58.11	58.42	58.04	58.38	1375600.0
2004-04-16 13:00:00	IWM	ETF	58.38	58.41	58.12	58.175	845800.0
2004-04-16 14:00:00	IWM	ETF	58.125	58.375	58.125	58.185	1193800.0
2004-04-16 15:00:00	IWM	ETF	58.17	58.195	58.0	58.02	1232200.0
2004-04-16 16:00:00	IWM	ETF	58.1	58.15	58.075	58.1	208800.0
2004-04-16 08:00:00	DIA	ETF	103.9	104.09	103.84	104.07	7700.0
2004-04-16 09:00:00	DIA	ETF	104.1	104.32	103.89	103.95	646600.0
2004-04-16 10:00:00	DIA	ETF	103.91	104.34	103.86	104.2	558400.0
2004-04-16 11:00:00	DIA	ETF	104.19	104.5	104.19	104.41	398600.0
2004-04-16 12:00:00	DIA	ETF	104.39	104.75	104.39	104.59	705000.0
2004-04-16 13:00:00	DIA	ETF	104.63	104.68	104.39	104.49	244700.0
2004-04-16 14:00:00	DIA	ETF	104.48	104.72	104.46	104.54	399500.0
2004-04-16 15:00:00	DIA	ETF	104.54	104.71	104.37	104.64	792200.0
2004-04-16 16:00:00	DIA	ETF	104.65	104.74	104.29	104.7	216700.0
2004-04-16 17:00:00	DIA	ETF	104.72	104.72	104.58	104.58	600.0
2004-04-16 18:00:00	DIA	ETF	104.65	104.65	104.65	104.65	100.0
2004-04-16 08:00:00	TLT	ETF	84.5	84.59	84.45	84.59	4400.0
2004-04-16 09:00:00	TLT	ETF	84.59	84.87	84.59	84.85	91000.0
2004-04-16 10:00:00	TLT	ETF	84.8	84.84	84.68	84.7	317200.0
2004-04-16 11:00:00	TLT	ETF	84.73	84.81	84.68	84.75	92500.0
2004-04-16 12:00:00	TLT	ETF	84.73	84.78	84.45	84.53	57900.0
2004-04-16 13:00:00	TLT	ETF	84.54	84.54	84.42	84.44	65600.0
2004-04-16 14:00:00	TLT	ETF	84.5	84.67	84.41	84.58	37600.0

> showing 50 of 679 rows — these rows as CSV

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